English

Calculate Inventory Turnover Ratio from the Following Information: - Accountancy

Advertisements
Advertisements

Question

Calculate Inventory Turnover Ratio from the following information:

Opening Inventory is ₹50,000; Purchases ₹3,90,000; Revenue from Operations, i.e., Net Sales ₹6,00,000; Gross Profit Ratio 30%.

Sum

Solution

Cost of Goods Sold = Net Sales – Gross Profit
= Rs 6,00,000 – 30% of Rs 6,00,000
= Rs 6,00,000 – Rs 1,80,000 = Rs 4,20,000

Cost of Goods Sold = Opening Inventory + Purchases – Closing Inventory
Rs 4,20,000  = Rs 50,000 + Rs 3,90,000 – Closing Inventory
Closing Inventory =  Rs 50,000 + Rs 3,90,000 – Rs 4,20,000
= Rs 20,000  

Average Stock = `("Opening Stock + Closing Stock")/2`

`= (50000 + 20000)/2` = Rs 35000

Stock turnover Ratio =`"Cost of goods Sold"/"Average Stock" = 420000/35000` = 12 times

shaalaa.com
Types of Ratios
  Is there an error in this question or solution?
Chapter 3: Accounting Ratios - Exercises [Page 99]

APPEARS IN

TS Grewal Accountancy - Analysis of Financial Statements [English] Class 12
Chapter 3 Accounting Ratios
Exercises | Q 63 | Page 99

RELATED QUESTIONS

From the following compute Current Ratio:

     
Trade Receivable (Sundry Debtors) 1,80,000   Bills Payable 20,000
Prepaid Expenses 40,000   Sundry Creditors 1,00,000
Cash and Cash Equivalents 50,000   Debentures 4,00,000
Marketable Securities 50,000   Inventories 80,000
Land and Building 5,00,000   Expenses Payable 80,000

Current Assets are ₹ 7,50,000 and Working Capital is ₹ 2,50,000. Calculate Current Ratio.


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


Ratio of Current Assets (₹8,75,000) to Current Liabilities (₹3,50,000) is 2.5:1 The firm wants to maintain Current Ratio of 2:1 by purchasing goods on credit. Compute amount of goods that should be purchased on credit.


Current Liabilities of a company are  ₹  1,50,000. Its Current Ratio is 3 : 1 and Acid Test Ratio (Liquid Ratio) is 1 : 1. Calculate values of Current Assets, Liquid Assets and Inventory.


From the following information, calculate Debt to Equity Ratio: 

 
10,000 Equity Shares of ₹ 10 each fully paid 1,00,000
5,000; 9% Preference Shares of ₹ 10 each fully paid 50,000
General Reserve  45,000
Surplus, i.e., Balance in Statement of Profit and Loss 20,000
10% Debentures 75,000
Current Liabilities  50,000

If Profit before Interest and Tax is ₹5,00,000 and interest on Long-term Funds is ₹1,00,000, find Interest Coverage Ratio.


From the following information, calculate Interest Coverage Ratio: Profit after Tax ₹1,70,000; Tax ₹30,000; Interest on Long-term Funds ₹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

₹2,00,000 is the Cost of Revenue from Operations (Cost of Goods Sold), during the year. If Inventory Turnover Ratio is 8 times, calculate inventories at the end of the year. Inventories at the end is 1.5 times that of in the beginning.


Cash Revenue from Operations (Cash Sales) ₹ 2,00,000, Cost of Revenue from Operations or Cost of Goods Solds ₹ 3,50,000; Gross Profit ₹ 1,50,000; Trade Receivables Turnover Ratio 3 Times. Calculate Opening and Closing Trade Receivables in each of the following alternative cases:
Case 1: If Closing Trade Receivables were ₹ 1,00,000 in excess of Opening Trade Receivalbes.
Case 2: If trade Receivables at the end were 3 times than in the beginning.
Case 3: If trade Receivables at the end were 3 times more than that of in the beginning.


Equity Share Capital ₹ 15,00,000; Gross Profit on Revenue from Operations, i.e., Net Sales `33 1/3`%;  Cost Revenue from Operatins or Cost of Goods Sold ₹ 20,00,000; Current Assets ₹ 10,00,000; Current Liabilities ₹ 2,50,000. Calculate Working Capital Turnover Ratio 


Cash Sales ₹ 2,20,000; Credit Sales ₹ 3,00,000; Sales Return ₹ 20,000; Gross Profit ₹ 1,00,000; Operating Expenses ₹ 25,000; Non-operating incomes ₹ 30,000; Non-operating Expenses ₹ 5,000. Calculate Net Profit Ratio.


From the following Balance Sheet of Global Ltd., you are required to calculate Return on Investment for the year 2018-19:

BALANCE SHEET OF GLOBAL LTD.
as at 31st March, 2019 

Particulars 

Note No.

Amount

I. EQUITY AND LIABILITIES

1. Shareholder's Funds

   

(a) Share Capital–Equity Shares of ₹ 10 each Fully paid

 

5,00,000

(b) Reserves and Surplus

 

4,20,000

2. Non-Current Liabilities

   

15% Long-term Borrowings

 

16,00,000

3. Current Liabilities

 

8,00,000

Total

 

33,20,000

II. ASSETS    

1. Non-Current Assets

   

(a) Fixed Assets

 

16,00,000

(b) Non-Current Investments:

 

 

(i) 10% Investments

 

2,00,000

(ii) 10% Non-trade Investments

 

1,20,000

2. Current Assets

  14,00,000

Total

 

33,20,000

Additional Information: Net Profit before Tax for the year 2018-19 is rs 9,72,000. 


From the following calculate:

(a) Current Ratio; and 
(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

Choose the appropriate alternative from the given options:
Bishan and Sudha were partners in firm sharing profits and losses in the ratio of 5 : 3. Alena was admitted as a new partner. It was decided that the new profit sharing ratio of Bishan, Sudha, and Alena will be 10: 6: 5. The sacrificing ratio of Bishan and Sudha will be:


Current ratio is stated as a crude ratio because:


An annual Report is issued by a company to its ______?


Gain on sale of fixed assets by a financial company is shown in the Statement of Profit and Loss as:


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.


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×