Advertisements
Advertisements
Question
(i) Revenue from Operations: Cash Sales ₹4,20,000; Credit Sales ₹6,00,000; Return ₹20,000. Cost of Revenue from Operations or Cost of Goods Sold ₹8,00,000. Calculate Gross Profit Ratio.
(ii) Average Inventory ₹1,60,000; Inventory Turnover Ratio is 6 Times; Selling Price 25% above cost. Calculate Gross Profit Ratio.
(iii) Opening Inventory ₹1,00,000; Closing Inventory ₹60,000; Inventory Turnover Ratio 8 Times; Selling Price 25% above cost. Calculate Gross Profit Ratio.
Solution
(i) Net Sales = Cash Sales + Credit Sales - Sales return
= 420000 + 600000 - 20000 = 1000000
Cost of Goods Sold = 8,00,000
Gross Profit = Net Sales - Cost of Goods Sold
= 1000000 - 800000 = 200000
Gross Profit Ratio = `"Gross Profit"/"Net Sales" xx 100`
`= 200000/1000000 xx 100 = 20%`
(ii) Average Stock = 1,60,000
Stock Turnover Ratio = 6 Times
Stock Turnover Ratio = `"Cost of Goods Sold"/"Average Stock"`
`6 = "Cost of goods sold"/160000`
Cost of goods sold = 960000
Gross Profit = 25% on Cost
Gross Profit = 25% on cost
∴ Gross Profit =`25/100 xx 960000 = 240000`
Net Sales = Cost of goods sold + Gross Profit
= 960000 + 240000 = 1200000
Gross Profit Ratio = `"Gross Profit"/"Net Sales" xx 100`
`=240000/1200000 xx 100 = 20%`
(iii) Opening Inventory = 1,00,000
Closing Inventory = 60,000
Average Inventory = `("Opening Inventory + Closing Inventory")/2`
`= (100000 + 60000)/2 = 80000`
Inventory Turnover Ratio = `"Cost of Goods Sold"/"Average Inventory"`
`8 = "Cost of Goods Sold"/80000`
Cost of Goods Sold = 640000
Gross Profit = 25% on Cost
Gross Profit = `25/100 xx 640000 = 160000`
Net Sales = Cost of Goods Sold + Gross Profit
= 640000 + 160000 = 800000
Gross Profit Ratio = `"Gross Profit "/"Net Sales" xx 100`
`= 160000/800000 xx 100 = 20%`
APPEARS IN
RELATED QUESTIONS
Long Answer Question
How would you study the solvency position of the firm?
From the following information calculate Gross Profit Ratio, Inventory Turnover Ratio and Trade Receivables Turnover Ratio.
| Rs | |
| Revenue from Operations | 3,00,000 |
| Cost of Revenue from Operations | 2,40,000 |
| Inventory at the end | 62,000 |
| Gross Profit | 60,000 |
| Inventory in the beginning | 58,000 |
| Trade Receivables | 32,000 |
Calculate Inventory Turnover Ratio if:
Inventory in the beginning is Rs. 76,250, Inventory at the end is 98,500, Gross Revenue from Operations is Rs. 5,20,000, Sales Return is Rs. 20,000, Purchases is Rs. 3,22,250.
Current Liablilites of a company were ₹1,75,000 and its Current Ratio was 2:1. It paid ₹30,000 to a Creditor. Calculate Current Ratio after payment.
Current Ratio 4; Liquid Ratio 2.5; Inventory ₹ 6,00,000. Calculate Current Liabilities, Current Assets and Liquid Assets.
From the following Balance Sheet of ABC Ltd. as at 31st March, 2019, Calculate Debt to Equity Ratio:
|
Particulars |
₹ |
|
| I. EQUITY AND LIABILITIES | ||
|
1. Shareholder's Funds |
||
|
(a) Share Capital: |
||
|
(i) Equity Share Capital |
5,00,000 |
|
|
(ii) 10% Preference Share Capital |
5,00,000 |
10,00,000 |
|
(b) Reserves and Surplus |
2,40,000 |
|
|
2. Non-Current Liabilities |
||
|
Long-term Borrowings (Debentures) |
2,50,000 |
|
|
3. Current Liabilities : |
||
|
(a) Trade Payables |
4,30,000 |
|
|
(b) Other Current Liabilities |
20,000 |
|
|
(c) Short-term Provisions: Provision for Tax |
3,00,000 |
|
|
Total |
22,40,000 |
|
| II. ASSETS | ||
|
1. Non-Current Assets |
||
|
Fixed Assets: |
||
|
(i) Tangible Assets |
6,40,000 |
|
|
(ii) Intangible Assets |
1,00,000 |
|
|
2. Current Assets |
||
|
(a) Inventories |
7,50,000 |
|
|
(b) Trade Receivables |
6,40,000 |
|
|
(c) Cash and Cash Equivalents |
1,10,000 |
|
|
Total |
22,40,000 |
|
From the following infromation, calculate Proprietary Ratio:
|
|
₹ |
| Equity Share Capital | 3,00,000 |
| Preference Share Capital | 1,50,000 |
| Reserves and Surplus | 75,000 |
| Debentures | 1,80,000 |
|
Trade Payables |
45,000 |
|
|
7,50,000 |
|
Fixed Assets |
3,75,000 |
| Short-term Inverstments | 2,25,000 |
|
Other Current Assets |
1,50,000 |
|
|
7,50,000 |
From the following details, calculate Inventory Turnover Ratio:
| ₹ | |
| Cost of Revenue from Operations (Cost of Goods Sold) | 4,50,000 |
| Inventory in the beginning of the year | 1,25,000 |
| Inventory at the close of the year | 1,75,000 |
From the following Statement of Profit and Loss for the year ended 31st March, 2019 of Rex Ltd., calculate Inventory Turnover Ratio:
STATEMENT OF PROFIT AND LOSS
for the year ended 31st March, 2019
|
Particulars |
Note No. |
Amount (₹) |
| I. Revenue from Operations (Net Sales) |
6,00,000 |
|
| II. Expenses: | ||
|
(a) Purchases of Stock-in-Trade |
3,00,000 |
|
|
(b) Change in Inventory of Stock-in-Trade |
1 |
50,000 |
|
(c) Employees Benefit Expenses |
60,000 |
|
|
(d) Other Expenses |
2 |
45,000 |
| Total Expenses |
4,55,000 |
|
| III. Profit before Tax (I-II) |
1,45,000 |
|
| IV. Less: Tax |
45,000 |
|
| V. Profit after Tax (III-IV) |
1,00,000 |
Notes to Accounts
|
Particulars |
Amount (₹) |
| I. Change in Inventory of stock-in-Trade | |
|
Opening Inventory |
1,25,000 |
|
Less: Closing Inventory |
75,000 |
|
50,000 |
|
| 2. Other Expenses | |
|
Carriage Inwards |
15,000 |
|
Miscellaneous Expenses |
30,000 |
|
45,000 |
A limited company made Credit Sales of ₹ 4,00,000 during the financial period. If the collection period is 36 days and the year is assumed to be 360 days, calculate:
- Trade Receivables Turnover Ratio;
- Average Trade Receivables;
- Trade Receivables at the end when Trade Receivables at the end are more than that in the beginning by ₹ 6,000.
Compute Gross Profit Ratio from the following information:
Revenue from Operations, i.e., Net Sales = ₹4,00,000; Gross Profit 25% on Cost.
Revenue from Operations, i.e., Net Sales ₹ 8,20,000; Return ₹ 10,000; Cost of Revenue from Operations (Cost of Goods Sold) ₹ 5,20,000; Operating Expenses ₹ 2,09,000; Interest on Debentures ₹ 40,500; Gain (Profit) on Sale of a Fixed Asset ₹ 81,000. Calculate Net Profit Ratio.
From the following calculate:
(b) Working Capital Turnover Ratio.
| ₹ | ||
| (i) | Revenue from Operations | 1,50,000 |
| (ii) | Total Assets | 1,00,000 |
| (iii) | Shareholders' Funds | 60,000 |
| (iv) | Non-current Liabilities | 20,000 |
| (v) | Non-current Assets | 50,000 |
Liquid assets are determined by:
Ratio analysis provide analysis of the _________.
The ______ may indicate that the firm is experiencing stock outs and lost sales.
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 ______.
Debt to Capital Employed ratio is 0.3:1. State whether the following transaction, will improve, decline or will have no change on the Debt to Capital Employed Ratio. Also give a reason for the same.
Tax Refund of ₹ 50,000 during the year.
