English

From the Following Data, Calculate Inventory Turnover Ratio: Total Sales ₹5,00,000; Sales Return ₹50,000; - Accountancy

Advertisements
Advertisements

Question

From the following data, calculate Inventory Turnover Ratio:
Total Sales ₹5,00,000; Sales Return ₹50,000; Gross Profit ₹90,000; Closing Inventory ₹1,00,000; Excess of Closing Inventory over Opening Inventory ₹20,000.

Sum

Solution

Cost of Goods Sold = Net Sales (Sales – Sales Return) – Gross Profit
= Rs 5,00,000 – Rs 50,000 – Rs 90,000 = Rs 3,60,000
Closing Inventory = Rs 1,00,000
Closing Inventory is Rs 20,000 more than the Opening Inventory
Therefore, Opening Inventory = Rs 80,000 (Rs 1,00,000 – Rs 20,000) 

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

`= (80000 + 100000)/2` = Rs 90000

Stock turnover Ratio  =`"Cost of goods Sold"/"Average Stock"`

`= 360000/90000` = 4 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 67 | Page 99

RELATED QUESTIONS

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.


Calculate Current Ratio from the following information:

Particulars

Particulars

Total Assets 5,00,000 Non-current Liabilities 1,30,000
Fixed Tangible Assets 2,50,000 Non-current Investments 1,50,000
Shareholders'  Funds 3,20,000

 

 


Working Capital ₹ 1,80,000; Total Debts ₹ 3,90,000; Long-Term Debts ₹ 3,00,000.
Calculate Current Ratio.


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


Total Debt ₹ 60,00,000; Shareholders' Funds ₹ 10,00,000; Reserves and Surplus  ₹ 2,50,000; Current Assets ₹ 25,00,000; Working Capital ₹ 5,00,000. Calculate Total Assets to Debt Ratio.


Total Debt ₹15,00,000; Current Liablities ₹5,00,000; Capital Employed ₹15,00,000. Calculate Total Assets to Debt Ratio. 


From the following information, calculate value of Opening Inventory:

Closing Inventory = ₹ 68,000
Total Sales  = ₹ 4,80,000 (including Cash Sales ₹ 1,20,000)
Total Purchases = ₹ 3,60,000 (including Credit Purchases ₹ 2,39,200)

Goods are sold at a profit of 25% on cost. 


Capital Employed ₹ 12,00,000; Net Fixed Assets 8,00,000; Cost of Goods Sold or Cost of Revenue from Operations ₹ 40,00,000; Gross Profit is 20% on Cost. Calculate Working Capital Turnover Ratio.


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.


Operating Cost ₹ 3,40,000; Gross Profit Ratio 20%; Operating Expenses ₹ 20,000. Calculate Operating Profit Ratio.


From the following information, calculate any two of the following ratios:

(i) Current Ratio; 
(ii) Debt to Equity Ratio; and
(iii) Operating Ratio.
Revenue from Operations (Net Sales) ₹ 1,00,000; cost of Revenue from Operations (Cost of Goods Sold) was 80% of sales; Equity Share Capital ₹ 7,00,000; General Reserve ₹ 3,00,000; Operating Expenses ₹ 10,000; Quick Assets ₹ 6,00,000; 9% Debentures ₹ 5,00,000; Closing Inventory ₹ 50,000; Prepaid Expenses ₹ 10,000 and Current Liabilities ₹ 4,00,000. 

Which of the following are included in traditional classification of ratios?

  1. Liquidity Ratios
  2. Statement of Profit and loss Ratios
  3. Balance Sheet Ratios
  4. Profitability Ratios
  5. Composite Ratios
  6. Solvency Ratios

Which are the ratios that comes under traditional basis of classification?


Debt-Equity Ratio can be calculated as ______?


The ______ measures the activity of a firm's inventory.


The higher the ratio, the lower is the profitability, which is applicable to ______


Which of the following measures the firm's ability to meet its long-term obligations?


How much amount will be added while computing Net Profit before Tax?

  01.04.2020 31.03.2021
Provision for Tax ₹ 54,000 ₹ 72,900

Tax paid during the year ended 31st March 2021 is ₹ 64,800.


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×