English

Calculate Inventory Turnover Ratio from the Data Given Below: - Accountancy

Advertisements
Advertisements

Question

Calculate Inventory Turnover Ratio from the data given below:

 

 

Rs

Inventory in the beginning of the year

10,000

Inventory at the end of the year

5,000

Carriage

2,500

Revenue from Operations

50,000

Purchases

25,000

Numerical

Solution

`"Inventory turnover ratio" = "Cost of Revenue from operations"/"Average Inventor"`

`"Cost of revenue from operations" = "Inventory in the begining + Purchases + Carriage - Inventory at the end"`

                    =`10,000 + 25,000 + 2,500 - 5,000`

                    =`32,500`

`"Average Inventory" = "Inventory in the begining + Inventory at the end"/2`

                                 = `(10,000 + 5,000)/2`

                                  = `7,500`

`"Inventory Turnover Ratio" = "32,500"/"7,500" = 4.33 "times"`

shaalaa.com
Types of Ratios
  Is there an error in this question or solution?
Chapter 5: Accounting Ratios - Questions for Practice [Page 231]

APPEARS IN

NCERT Accountancy - Company Accounts and Analysis of Financial Statements [English] Class 12
Chapter 5 Accounting Ratios
Questions for Practice | Q 14 | Page 231

RELATED QUESTIONS

Short Answer Question

The liquidity of a business firm is measured by its ability to satisfy its long-term obligations as they become due. What are the ratios used for this purpose?


The current ratio provides a better measure of overall liquidity only when a firm’s inventory cannot easily be converted into cash. If inventory is liquid, the quick ratio is a preferred measure of overall liquidity. Explain.


Trade Payables ₹ 50,000, Working Capital ₹ 9,00,000, Current Liabilities ₹ 3,00,000. Calculate Current Ratio.


State giving reason, whether the Current Ratio will improve or decline or will have no effect in each of the following transactions if Current Ratio is 2:1:

(a) Cash paid to Trade Payables.
(b) Bills Payable discharged.
(c) Bills Receivable endorsed to a creditor.
(d) Payment of final Dividend already declared.
(e) Purchase of Stock-in-Trade on credit.
(f) Bills Receivable endorsed to a Creditor dishonoured.
(g) Purchases of Stock-in-Trade for cash.
(h) Sale of Fixed Assets (Book Value of ₹50,000) for ₹45,000.
(i) Sale of FIxed Assets (Book Value of ₹50,000) for ₹60,000.


Quick Assets ₹ 1,50,000; Inventory (Stock) ₹ 40,000; Prepaid Expenses ₹ 10,000; Working Capital ₹ 1,20,000. Calculate Current Ratio.


Calculate Debt to Equity Ratio: Equity Share Capital ₹ 5,00,000; General Reserve ₹ 90,000; Accumulated Profits ₹ 50,000; 10% Debentures ₹ 1,30,000; Current Liabilities ₹ 1,00,000.


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


Calculate Total Assets to Debt Ratio from the following information:
Long-term Debts ₹ 4,00,000; total Assets  ₹ 7,70,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 information, calculate Interest Coverage Ratio:

 
10,000 Equity Shares of ₹10 each 1,00,000
8% Preference Shares 70,000
10% Debentures 50,000
Long-term Loans from Bank 50,000
Interest on Long-term Loans from Bank  5,000
Profit after Tax 75,000
Tax 9,000

₹ 3,00,000 is the Cost of Revenue from Operations (Cost of Goods Sold). Inventory Turnover Ratio 8 times; Inventory in the beginning is 2 times more than the inventory at the end. Calculate value of Opening and Closing Inventories


A company earns Gross Profit of 25% on cost. For the year ended 31st March, 2017 its Gross Profit was ₹ 5,00,000; Equity Share Capital of the company was ₹ 10,00,000; Reserves and Surplus ₹ 2,00,000; Long-term Loan ₹ 3,00,000 and Non-current Assets were ₹ 10,00,000.
Compute the 'Working Capital Turnover Ratio' of the company.


What will be the Operating Profit Ratio, if Operating Ratio is 82.59%?


Calculate Operating Profit Ratio,in each of the following alternative cases:
Case 1:  Revenue from Operations (Net Sales) ₹ 10,00,000; Operating Profit ₹ 1,50,000.
Case 2:  Revenue from Operations (Net Sales) ₹ 6,00,000; Operating Cost ₹ 5,10,000.
Case 3:  Revenue from Operations (Net Sales) ₹ 3,60,000; Gross Profit 20% on Sales; Operating Expenses ₹ 18,000
Case 4: Revenue from Operations (Net Sales) ₹ 4,50,000; Cost of Revenue from Operations ₹ 3,60,000; Operating Expenses ₹ 22,500.
Case 5: Cost of Goods Sold, i.e., Cost of Revenue from Operations ₹ 8,00,000; Gross Profit 20% on Sales; Operating Expenses ₹ 50,000. 


Revenue from Operations ₹ 4,00,000; Gross Profit Ratio 25%; Operating Ratio 90%. Non-operating Expenses ₹ 2,000; Non-operating Income ₹22,000. Calculate Net 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

Balance Sheet (Extract)

Liabilities 31-03-2019
(₹)
31-03-2020
(₹)
12% debentures 2,00,000 1,60,000

Additional Information:

Interest on debentures is paid on half yearly basis on 30th September and 31st March each year.

Debentures were redeemed on 30th September, 2019.

How much amount (related to above information) will be shown in Financing Activity for Cash Flow Statement prepared on 31st March, 2020?


Which of the following items will be adjusted to Net Profit before Tax?


Which of the following is a profitability ratio?


Tangible Assets of the firm are ₹ 14,00,000 and outside liabilities are ₹ 4,00,000. Profit of the firm is ₹ 1,50,000 and the normal rate of return is 10%. The amount of capital employed will be:


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×