Advertisements
Advertisements
Question
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 |
Solution
Cost of Goods Sold = Opening Inventory+ Purchases + Direct Expenses – Closing Inventory
= Rs 1,25,000 + Rs 3,00,000 + Rs 15,000 – Rs 75,000 = Rs 3,65,000
Average Stock = `("Opening Stock + Closing Stock")/2`
= `(125000 + 75000)/2 = 100000`
Inventory Turnover Ratio=`"Cost of goods Sold"/"Average Inventory"`
`= 365000/100000` = 3.65 times
APPEARS IN
RELATED QUESTIONS
Following is the Balance Sheet of Title Machine Ltd. as at March 31, 2017.
Particulars |
Amount Rs. |
I. Equity and Liabilities | |
1. Shareholders’ funds |
|
a) Share capital |
24,00,000 |
b) Reserves and surplus |
6,00,000 |
2. Non-current liabilities |
|
a) Long-term borrowings |
9,00,000 |
3. Current liabilities |
|
a) Short-term borrowings |
6,00,000 |
b) Trade payables |
23,40,000 |
c) Short-term provisions |
60,000 |
Total | 69,00,000 |
II. Assets | |
1. Non-current Assets |
|
a) Fixed assets |
|
Tangible assets |
45,00,000 |
2. Current Assets |
|
a) Inventories |
12,00,000 |
b) Trade receivables |
9,00,000 |
c) Cash and cash equivalents |
2,28,000 |
d) Short-term loans and advances |
72,000 |
Total | 69,00,000 |
Calculate Current Ratio and Liquid Ratio.
Current liabilities of a company are Rs 75,000. If current ratio is 4:1 and liquid ratio is 1:1, calculate value of current assets, liquid assets and inventory.
Calculate Current Ratio if:
Inventory is Rs 6,00,000; Liquid Assets Rs 24,00,000; Quick Ratio 2:1.
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 |
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.
Calculate Total Assets to Debt Ratio from the following information:
Long-term Debts ₹ 4,00,000; total Assets ₹ 7,70,000.
Calculate Total Assets to Debt Ratio from the following information:
Particulars | ₹ |
Particulars |
₹
|
||
Total Assets | 15,00,000 | Bills Payable | 60,000 | ||
Total Debts | 12,00,000 | Bank Overdraft | 50,000 | ||
Creditors | 90,000 |
Outstanding Expenses |
20,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 |
Inventory Turnover Ratio 5 times; Cost of Revenue from Operations (Cost of Goods Sold) ₹ 18,90,000. Calculate Opening Inventory and Closing Inventory if Inventory at the end is 2.5 times more than that in the beginning.
Credit Revenue from Operations, i.e., Net Credit Sales for the year | 1,20,000 |
Debtors | 12,000 |
Billls Receivable | 8,000 |
Calculate Trade Receivables Turnover Ratio.
₹ 1,75,000 is the Credit Revenue from Operations, i.e., Net Credit Sales of an enterprise. If Trade Receivables Turnover Ratio is 8 times, calculate Trade Receivables in the Beginning and at the end of the year. Trade Receivables at the end is ₹ 7,000 more than that in the beginning.
A firm normally has trade Receivables equal to two months' credit Sales. During the coming year it expects Credit Sales of ₹ 7,20,000 spread evenly over the year (12 months). What is the estimated amount of Trade Receivables at the end of the year?
Calculate Operating Ratio from the following information:
Operating Cost ₹ 6,80,000; Gross Profit 25%; Operating Expenses ₹ 80,000.
What will be the Operating Profit Ratio, if Operating Ratio is 82.59%?
Revenue from Operations ₹ 9,00,000; Gross Profit 25% on Cost; Operating Expenses ₹ 45,000. Calculate Operating Profit Ratio.
Pick the odd one out:
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% |
Inventory turnover ratio for the year 2020 will be ______. (Choose the correct alternative)
Which of the following measures the firm's ability to meet its long-term obligations?