Advertisements
Advertisements
Question
Calculate
- Inventory turnover ratio
- Trade receivables turnover ratio
- Trade payables turnover ratio and
- Fixed assets turnover ratio from the following information obtained from Aruna Ltd.
| Particulars | As of 31st March 2018 (₹) | As of 31st March 2019 (₹) |
| Inventory | 3,60,000 | 4,40,000 |
| Trade receivables | 7,40,000 | 6,60,000 |
| Trade Payable | 1,90,000 | 2,30,000 |
| Fixed assets | 6,00,000 | 8,00,000 |
Additional information:
- Revenue from operations for the year ₹ 35,00,000
- Purchases for the year ₹ 21,00,000
- Cost of revenue from operation ₹ 16,00,000
Assume that sales and purchases are for credit.
Solution
(i) Inventory turnover ratio- `"Cost of revenue from operations"/"Average Inventory"`
Average Inventory = `("Opening Inventory + Closing Inventory")/2`
`= (3,60,000 + 4,40,000)/2`
= Rs. 4,00,000
Inventory turnover ratio = `1600000/400000` = 4 times
(ii) Trade receivable turnover ratio = `"Credit revenue from operations"/"Average Trade receivable"`
Average Trade receivable = `("Opening trade receivable + Closing trade receivable")/2`
`= (7,40,000 + 6,60,000)/2`
= Rs. 7,00,000
Trade receivable turnover ratio = `3500000/700000` = 5 times
(iii) Trade payable turnover ratio = `"Net Credit purchases"/"Average Trade Payables"`
Average Trade Payables = `("Opening trade payable + Closing trade payable")/2`
`= (1,90,000 + 2,30,000)/2`
= Rs. 2,10,000
Trade payable turnover ratio = `2100000/21000` = 10 times
(iv) Fixed assets turnover ratio = `"Revenue from operations"/"Average fixed assets"`
Average fixed assets = `("Opening fixed assets + Closing fixed assets")/2`
`= (6,00,000 + 8,00,000)/2`
= Rs. 7,00,000
Fixed assets turnover ratio = `3500000/700000` = 5 times
APPEARS IN
RELATED QUESTIONS
Calculate quick ratio: Total current liabilities ₹ 2,40,000; total current assets ₹ 4,50,000; Inventories ₹ 70,000; Prepaid Expenses ₹ 20,000
To test the liquidity of a concern, which of the following ratios are useful?
- Quick ratio
- Net profit ratio
- Debt-equity ratio
- Current ratio
Select the correct answer using the codes given below:
Which one of the following is not correctly matched?
How is operating profit ascertained?
From the following information calculate the capital gearing ratio:
| Balance Sheet (Extract) as on 31.03.2018 | |
| Particulars | Amount ₹ |
| I. EQUITY AND LIABILITIES | |
| 1. Shareholders Funds | |
| (a) Share capital | |
| Equity share capital | 4,00,000 |
| 5% Preference share capital | 1,00,000 |
| (b) Reserves and surplus | |
| General reserve | 2,50,000 |
| Surplus | 1,50,000 |
| 2. Non-current Liabilities | |
| Long-term borrowings (6% Debentures) | 3,00,000 |
| 3. Current liabilities | |
| Trade payables | 1,20,000 |
| provision for tax | 30,000 |
| Total | 13,50,000 |
The credit revenue from operations of Velavan Ltd, amounted to ₹ 10,00,000. Its debtors and bills receivables at the end of the accounting period amounted to ₹ 1,10,000 and ₹ 1,40,000 respectively. Calculate trade receivables turnover ratio and also collection period in months.
Following is the statement of profit and loss of Padma Ltd. for the year ended 31st March, 2018. Calculate the operating cost ratio.
| Statement of Profit and Loss | ||
| Particulars | Note No. | Amount ₹ |
| I. Revenue from operations | 15,00,000 | |
| II. Other Income | 40,000 | |
| III. Total revenue (I+II) | 15,40,000 | |
| IV. Expenses: | ||
| Purchases of Stock-in-trade | 8,60,000 | |
| Changes in inventories | 40,000 | |
| Employee benefits expense (Salaries) | 1,60,000 | |
| Other expenses | 1 | 1,70,000 |
| Total expenses | 12,30,000 | |
| V. Profit before tax (III-IV) | 3,10,000 | |
Notes to Accounts-
| Particulars | Amount ₹ |
| 1. Other expenses | |
| Office and administrative expenses | 50,000 |
| Selling and distribution expenses | 90,000 |
| Loss on sale of furniture | 30,000 |
| 1,70,000 |
From the following details of a business concern calculate net profit ratio.
| Particulars | Amount Rs. |
| Revenue from operations | 9,60,000 |
| Cost of revenue from operations | 5,50,000 |
| Office and administration expenses | 1,45,000 |
| Selling and distribution expenses | 25,000 |
From the following statement of profit. and loss of Dericston Ltd. Calculate
- Gross Profit ratio
- Net Profit ratio.
| Statement of Profit and Loss | |
| Particulars | ₹ |
| I. Revenue from operations | 24,00,000 |
| II. Other income: | |
| Income from investment | 70,000 |
| III. Total revenues (I+II) | 24,70,000 |
| IV. Expenses: | |
| Purchases of stock-in-trade | 18,80,000 |
| Changes in inventories | -80,000 |
| Employee benefits expense | 2,90,000 |
| Other expenses | 1,10,000 |
| Provision for tax | 30,000 |
| Total expenses | 22,30,000 |
| V. Profit for year | 2,40,000 |
Following is the extract of balance sheet of Abdul Ltd., as on 31st March, 2019:
| Particulars | Rs. |
| I EQUITY AND LIABILITIES | |
| 1. Shareholders’ Funds | |
| a) Share capital | 2,00,000 |
| b) Reserves and surplus | 50,000 |
| 2. Non-Current liabilities | |
| Long-term borrowings | 1,50,000 |
| 3. Current liabilities | |
| (a) Trade Payable | 1,30,000 |
| (b) Reserves and surplus | 5,000 |
| (c) Short–term provisions | 20,000 |
| Total | 5,55,000 |
Net profit before interest and tax for the year was ₹ 60,000. Calculate the return on capital employed for the year.
