The following is an extract from the financial statements of Lusaka (Pty) Ltd for the year ended 28 February 2024: 2024 R’000 Cost of sales 42 323 Gross profit 34 155 Operating expenses 17 820 Finance costs 1 617 Income tax 3 267 Capital and reserves 73 095 Long-term (interest-bearing) borrowings 7 425 Bank balance (overdraft) 743 Trade payables 9 445 Non-current assets 75 059 Trade receivables 10 303 Inventory 5 346 Required: Complete the table below to calculate the following ratios and choose the nearest correct answer from the list of options provided: Ratio 2024 Return on assets (ROA) Blank 1 Debtors’ collection period Blank 2 Days' sales inventory held Blank 3 Operating profit margin Blank 4 Quick ratio Blank 5 Gross profit margin Blank 6 Debt ratio Blank 7
Question
The following is an extract from the financial statements of Lusaka (Pty) Ltd for the year ended 28 February 2024:
2024
R’000
Cost of sales
42 323
Gross profit
34 155
Operating expenses
17 820
Finance costs
1 617
Income tax
3 267
Capital and reserves
73 095
Long-term (interest-bearing) borrowings
7 425
Bank balance (overdraft)
743
Trade payables
9 445
Non-current assets
75 059
Trade receivables
10 303
Inventory
5 346
Required:
Complete the table below to calculate the following ratios and choose the nearest correct answer from the list of options provided:
Ratio
2024
Return on assets (ROA)
Blank 1
Debtors’ collection period
Blank 2
Days' sales inventory held
Blank 3
Operating profit margin
Blank 4
Quick ratio
Blank 5
Gross profit margin
Blank 6
Debt ratio
Blank 7
Solution
Sure, let's calculate the ratios one by one:
-
Return on Assets (ROA): This is calculated as (Net Income / Total Assets). However, the net income is not provided in the question. We would need that information to calculate the ROA.
-
Debtors’ Collection Period: This is calculated as (Trade Receivables / Sales) x 365. However, the sales figure is not provided in the question. We would need that information to calculate the Debtors’ Collection Period.
-
Days' Sales Inventory Held: This is calculated as (Inventory / Cost of Sales) x 365. Using the provided figures, this would be (5346 / 42323) x 365 = 46 days.
-
Operating Profit Margin: This is calculated as (Operating Profit / Sales). Operating profit can be calculated as Gross Profit - Operating Expenses = 34155 - 17820 = 16335. However, we still need the sales figure to calculate the Operating Profit Margin.
-
Quick Ratio: This is calculated as (Current Assets - Inventory) / Current Liabilities. Current Assets can be calculated as Trade Receivables + Bank Balance = 10303 + (-743) = 9560. Current Liabilities can be calculated as Trade Payables + Bank Overdraft = 9445 + 743 = 10188. Therefore, the Quick Ratio is (9560 - 5346) / 10188 = 0.41.
-
Gross Profit Margin: This is calculated as (Gross Profit / Sales). Again, we need the sales figure to calculate this ratio.
-
Debt Ratio: This is calculated as Total Liabilities / Total Assets. Total Liabilities can be calculated as Long-term Borrowings + Current Liabilities = 7425 + 10188 = 17613. Total Assets can be calculated as Non-current Assets + Current Assets = 75059 + 9560 = 84619. Therefore, the Debt Ratio is 17613 / 84619 = 0.21.
Please note that some of these calculations require additional information not provided in the question.
Similar Questions
The following is an extract from the financial statements of Lusaka (Pty) Ltd for the year ended 28 February 2024: 2024 R’000 Cost of sales 42 323 Gross profit 34 155 Operating expenses 17 820 Finance costs 1 617 Income tax 3 267 Capital and reserves 73 095 Long-term (interest-bearing) borrowings 7 425 Bank balance (overdraft) 743 Trade payables 9 445 Non-current assets 75 059 Trade receivables 10 303 Inventory 5 346 Required: Complete the table below to calculate the following ratios and choose the nearest correct answer from the list of options provided: Ratio 2024 Return on assets (ROA) Blank 1 Debtors’ collection period Blank 2 Days' sales inventory held Blank 3 Operating profit margin Blank 4 Quick ratio Blank 5 Gross profit margin Blank 6 Debt ratio Blank 7
Tshiawelo Pty Limited has provided you with the following extract from the financial records for the financial year ended 31 December 2023 RCost of sales2 400 000Gross profit40%Operating expenses800 000Interest expense200 000Income tax expense30%Inventories 800 000Issued capital2 000 000Trade payables500 000Trade receivables600 000Cash and other equivalents200 000Short-term borrowings500 000Long-term borrowings2 000 000Property Plant and equipment1 000 000Required:Calculate the following ratios by choosing the correct answer from the options provided:Revenue from sales Blank 1 Net profit margin Blank 2Current ratio Blank 3Quick ratio Blank 4Debtors’ collection period Blank 5 Return on assets (ROA) Blank 6Days’ sales inventory held Blank 7Times interest earned ratio Blank 8
Ngwenya (Pty) Ltd had the following expenses during the 2024 year of assessment:Bad debts from customers = R74 000Bad debts from a loan to a supplier = R98 000Calculate the deduction available for tax purposes to Ngwenya (Pty) Ltd for the 2024 year of assessment ending 29 February 2024.
You've been provided with the following Trial BalanceCalculate TOTAL ASSETSCash 25,450Accounts Receivable 25,500Inventory 85,000Prepaid Expenses 4,950Motor vehicle 68,000Equipment 155,000Accounts Payable 35,000Unearned Revenue 8,000Wages Payable 15,000Bank Loan 50,000Share Capital 235,000Retained Earnings 10,000Dividends -5,000Revenue 53,650Cost of Sales -12,450Wages Expense -15,000Interest expense -2,500Marketing expense -2,800Insurance expense -5,000
Ngwenya (Pty) Ltd had the following bad debts as at 29 February 2024:Bad debts - relating to trade debtors - Namibian located customers = R67 000Bad debts - relating to trade debtors - South African located customers = R153 000Bad debts - relating to loans made to former employees = R16 800 (including interest charged on the loans of R980)Calculate the amount that Ngwenya (Pty) Ltd can deduct for tax purposes with regards to the bad debts it has incurred during the year of assessment ending on 29 February 2024.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.