English

Revenue from Operations ₹4,00,000; Gross Profit ₹1,00,000; Closing Inventory ₹1,20,000; Excess of Closing Inventory Over Opening Inventory ₹40,000. Calculate Inventory Turnover Ratio. - Accountancy

Advertisements
Advertisements

Question

Revenue from Operations ₹4,00,000; Gross Profit ₹1,00,000; Closing Inventory ₹1,20,000; Excess of Closing Inventory over Opening Inventory ₹40,000. Calculate Inventory Turnover Ratio.

Sum

Solution

Sales = 4,00,000

Gross Profit = 1,00,000

Cost of Goods Sold = Sales − Gross Profit

= 4,00,000 − 1,00,000 = 3,00,000

Let Opening Inventory = x

Closing Inventory = x + 40,000

1,20,000 = x + 40,000

x= 80,000

Opening Inventory = 80,000 

Average Inventory

= `("Opening Inventory + Closing Inventory")/2`

`= (80000 + 120000)/2 = 100000`

Inventory Turnover Ratio =`"Cost of goods Sold"/"Average Inventory"`

`= 300000/100000` = 3 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 66 | Page 99

RELATED QUESTIONS

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.


Calculate the following ratio on the basis of following information:
(i) Gross Profit Ratio (ii) Current Ratio (iii) Acid Test Ratio (iv) Inventory Turnover Ratio (v) Fixed Assets Turnover Ratio

  Rs.
Gross Profit 50,000
Revenue from Operations 100,000
Inventory 15,000
Trade Receivables 27,500
Cash and Cash Equivalents 17,500
Current Liabilities 40,000
Land & Building 50,000
Plant & Machinery 30,000
Furniture 20,000

Working Capital is ₹ 9,00,000; Trade payables ₹ 90,000; and Other Current Liabilities are ₹ 2,10,000. Circulate Current Ratio.


From the following information, calculate Liquid Ratio:

Particulars

Particulars

₹​

Current Assets

2,00,000 Trade Receivables

1,10,000

Inventories

50,000 Current Liabilities

70,000

Prepaid Expenses 

10,000  

 


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.


Total Assets ₹ 2,60,000; Total Debts ₹ 1,80,000; Current Liabilities ₹ 20,000. Calculate Debt to Equity Ratio. 


Debt to Equity Ratio of a company is 0.5:1. Which of the following suggestions would increase, decrease or not change it:

(i) Issue of Equity Shares:

(ii) Cash received from debtors:

(iii) Redemption of debentures;

(iv) Purchased goods on Credit?


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


₹ 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.


Calculate Trade Receivables Turnover Ratio in each of the following alternative cases:
Case 1: Net Credit Sales ₹4,00,000; Average Trade Receivables ₹1,00,000.

Case 2: Revenue from Operations (Net Sales) ₹30,00,000; Cash Revenue from Operations, i.e., Cash Sales ₹6,00,000; Opening Trade Receivables ₹2,00,000; Closing Trade Receivables ₹6,00,000.

Case 3: Cost of Revenue from Operations or Cost of Goods Sold ₹3,00,000; Gross Profit on Cost 25%; Cash Sales 20% of Total Sales; Opening Trade Receivables ₹50,000; Closing Trade Receivables ₹1,00,000.

Case 4: Cost of Revenue from Operations or Cost of Goods Sold ₹4,50,000; Gross Profit on Sales 20%; Cash Sales 25% of Net Credit Sales, Opening Trade Receivables ₹90,000; Closing Trade Receivables ₹60,000.


Calculate Working Capital Turnover Ratio from the following information: 
Revenue from Operations ₹ 30,00,000; Current Assets ₹ 12,50,000; Total Assets ₹ 20,00,000; Non-current Liabilities ₹ 10,00,000, Shareholders' Funds ₹ 5,00,000.


Revenue from Operations, i.e., Net Sales ₹ 6,00,000. Calculate Net Profit Ratio. 


On the basis of the following information calculate: 

(i) Debt to Equity Ratio; and 
(ii) Working Capital Turnover Ratio.
 
Information:      
Revenue from Operations: (a) Cash Sales 40,00,000   Paid-up Share Capital 17,00,000
  (b) Credit Sales 20,00,000   6% Debentures 3,00,000
Cost of Goods Sold   35,00,000   9% Loan from Bank 7,00,000
Other Current Assets   8,00,000   Debentures Redemption Reserve 3,00,000
Current Liabilities   4,00,000   Closing Inventory  1,00,000 

Calculate the amount of opening trade receivables and closing trade receivables from the following information:
Trade receivables turnover ratio 8 times
Cost of revenue from operations ₹ 4,80,000
The amount of credit revenue from operations is ₹ 2,00,000 more than cash revenue from operations. Gross profit ratio is 20%. Opening trade receivables are 1/4th of Closing trade receivables.


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:


Debt Ratio can be calculated as ______?


Pick the odd one out:


Operating Profit ratio is equal to ______


The ______ is useful in evaluating credit and collection policies.


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×