Advertisements
Advertisements
Question
Cost of Revenue from Operations (Cost of Goods Sold) ₹5,00,000; Purchases ₹5,50,000; Opening Inventory ₹1,00,000.
Calculate Inventory Turnover Ratio.
Solution
Cost of Goods Sold = Opening Inventory + Purchases − Closing Inventory
5,00,000 = 1,00,000 + 5,50,000 − Closing Inventory
Closing Inventory = 1,50,000
Average Stock = `("Opening Stock + Closing Stock")/2`
`=(100000 + 150000)/2 = 125000`
Inventory Turnover Ratio=`"Cost of goods Sold"/"Average Stock"`
`= 500000/125000` = 4 times
APPEARS IN
RELATED QUESTIONS
Compute Stock Turnover Ratio from the following information:
|
|
Rs |
|
Net Revenue from Operations |
2,00,000 |
|
Gross Profit |
50,000 |
|
Inventory at the end |
60,000 |
|
Excess of inventory at the end over inventory in the beginning |
20,000 |
Calculate following ratios from the following information:
(i) Current ratio (ii) Acid test ratio (iii) Operating Ratio (iv) Gross Profit Ratio
|
|
Rs |
|
Current Assets |
35,000 |
|
Current Liabilities |
17,500 |
|
Inventory |
15,000 |
|
Operating Expenses |
20,000 |
|
Revenue from Operations |
60,000 |
|
Cost of Goods Sold |
30,000 |
From the following Balance Sheet and other information, calculate following ratios: (i) Debt-Equity Ratio (ii) Working Capital Turnover Ratio (iii) Trade Receivables Turnover Ratio
Balance Sheet as at March 31, 2017
| Particulars | Note No. | Rs. |
| I. Equity and Liabilities: | ||
| 1. Shareholders’ funds | ||
| a) Share capital | 10,00,000 | |
| b) Reserves and surplus | 9,00,000 | |
| 2. Non-current Liabilities | ||
| Long-term borrowings | 12,00,000 | |
| 3. Current Liabilities | ||
| Trade payables | 5,00,000 | |
| Total | 36,00,000 | |
| II. Assets | ||
| 1. Non-current Assets | ||
| a) Fixed assets | ||
| Tangible assets | 18,00,000 | |
| 2. Current Assets | ||
| a) Inventories | 4,00,000 | |
| b) Trade Receivables | 9,00,000 | |
| c) Cash and cash equivalents | 5,00,000 | |
| Total | 36,00,000 |
Additional Information: Revenue from Operations Rs. 18,00,000
From the following information, calculate the following ratios:
i) Quick Ratio
ii) Inventory Turnover Ratio
iii) Return on Investment
| Rs. | |
| Inventory in the beginning | 50,000 |
| Inventory at the end | 60,000 |
| Revenue from operations | 4,00,000 |
| Gross Profit | 1,94,000 |
| Cash and Cash Equivalents | 40,000 |
| Trade Receivables | 1,00,000 |
| Trade Payables | 1,90,000 |
| Other Current Liabilities | 70,000 |
| Share Capital | 2,00,000 |
| Reserves and Surplus | 1,40,000 |
(Balance in the Statement of Profit & Loss A/c)
A company had Current Assets of ₹4,50,000 and Current Liabilities of ₹2,00,000. Afterwards it purchased goods for ₹30,000 on credit. Calculate Current Ratio after the purchase.
A firm had Current Assets of ₹5,00,000. It paid Current Liabilities of ₹1,00,000 and the Current Ratio became 2:1. Determine Current Liabilities and Working Capital before and after the payment was made.
State with reason, whether the Proprietary Ratio will improve, decline or will not change because of the following transactions if Proprietary Ratio is 0.8 : 1:
(i) Obtained a loan of ₹ 5,00,000 from State Bank of India payable after five years.
(ii) Purchased machinery of ₹ 2,00,000 by cheque.
(iii) Redeemed 7% Redeemable Preference Shares ₹ 3,00,000.
(iv) Issued equity shares to the vendor of building purchased for ₹ 7,00,000.
(v) Redeemed 10% redeemable debentures of ₹ 6,00,000.
Calculate Inventory Turnover Ratio in each of the following alternative cases:
Case 1: Cash Sales 25% of Credit Sales; Credit Sales ₹3,00,000; Gross Profit 20% on Revenue from Operations, i.e., Net Sales; Closing Inventory ₹1,60,000; Opening Inventory ₹40,000.
Case 2: Cash Sales 20% of Total Sales; Credit Sales ₹4,50,000; Gross Profit 25% on Cost; Opening Inventory ₹37,500; Closing Inventory ₹1,12,500.
From the following information, calculate Opening and Closing Trade Receivables, if Trade Receivables Turnover Ratio is 3 Times:
(i) Cash Revenue from Operations is 1/3rd of Credit Revenue from Operations.
(ii) Cost of Revenue from Operations is ₹3,00,000.
(iii) Gross Profit is 25% of the Revenue from Operations.
(iv) Trade Receivables at the end are 3 Times more than that of in the beginning.
Calculate Trade Payables Turnover Ratio and Average Debt payment Period from the following information:
| 1st April, 2018 ₹ |
31st March, 2019 ₹ |
|
| Sundry Creditors | 1,50,000 | 4,50,000 |
| Bills Payable | 50,000 | 1,50,000 |
Total Purchases ₹ 21,00,000; Purchases Return ₹ 1,00,000; Cash Purchases ₹ 4,00,000.
Revenue from Operations: Cash Sales ₹ 5,00,000; Credit Sales ₹ 6,00,000; Sales Return ₹ 1,00,000. Current Assets ₹ 3,00,000; Current Liabilities ₹ 1,00,000. Calculate Working Capital Turnover Ratio.
Operating Ratio 92%; Operating Expenses ₹94,000; Revenue from Operations ₹6,00,000; Sales Return ₹40,000. Calculate Cost of Revenue from Operations (Cost of Goods Sold).
Calculate Operating Profit Ratio from the Following:
| ₹ | |
| Revenue from Operations (Net Sales) | 5,00,000 |
| Cost of Revenue from Operations (Cost of Goods Sold) | 2,00,000 |
| Wages | 1,00,000 |
| Office and Administrative Expenses | 50,000 |
| Interest on Borrowings | 5,000 |
Operating Cost ₹ 3,40,000; Gross Profit Ratio 20%; Operating Expenses ₹ 20,000. Calculate Operating Profit Ratio.
Calculate following ratios on the basis of the following information:
(i) Gross Profit Ratio;
(ii) Current Ratio;
(iii) Acid Test Ratio; and
(iv) Inventory Turnover Ratio.
| ₹ | ₹ | |||
| Gross Profit | 50,000 | Revenue from Operations | 1,00,000 | |
| Inventory | 15,000 | Trade Receivables | 27,500 | |
| Cash and Cash Equivalents | 17,500 | Current Liabilities | 40,000 |
Calculate 'Total Assets to Debt ratio' from the following information:
| ₹ | |
| Equity Share Capital | 4,00,000 |
| Long Term Borrowings | 1,80,000 |
| Surplus i.e. Balance in statement of Profit and Loss | 1,00,000 |
| General Reserve | 70,000 |
| Current Liabilities | 30,000 |
| Long Term Provisions | 1,20,000 |
The current ratio is 2:1
State giving reasons which of the following transactions would improve, reduce and not change the current ratio.
"Payment of dividend."
From the following information, calculate stock turnover ratio ______?
Sales: Rs.4, 00,000, Average Stock: Rs.55, 000, Gross Loss Ratio: 10%
Read the following information and answer the given question:
| Year | 2020 | 2019 | 2018 |
| Amount | (in ₹) | (in ₹) | (in ₹) |
| Outstanding Expenses | 50,000 | 40,000 | 25,000 |
| Prepaid Expenses | 3,00,000 | 2,50,000 | 3,50,000 |
| Trade Payables | 18,00,000 | 16,00,000 | 14,00,000 |
| Inventory | 12,00,000 | 10,00,000 | 11,00,000 |
| Trade Receivables | 11,00,000 | 8,00,000 | 10,00,000 |
| Cash in hand | 17,00,000 | 12,00,000 | 15,00,000 |
| Revenue from operations | 24,00,000 | 18,00,000 | 20,00,000 |
| Gross Profit Ratio | 12% | 15% | 18% |
Cost of Revenue from Operations for the year 2020 would be ______.
