English

From the Following Information, Calculate Inventory Turnover Ratio; Operating Ratio and Working Capital Turnover Ratio: - Accountancy

Advertisements
Advertisements

Question

From the following information, calculate Inventory Turnover Ratio; Operating Ratio and Working Capital Turnover Ratio:
Opening Inventory ₹ 28,000; Closing Inventory ₹ 22,000; Purchases ₹ 46,000; Revenue from Operations,  i.e., Net Sales ₹ 80,000; Return ₹10,000; Carriage Inwards ₹ 4,000; Office Expenses ₹ 4,000; Selling and Distribution Expenses ₹ 2,000; Working Capital ₹ 40,000. 

Sum

Solution

(i)

Opening Inventory = 28,000

Closing Inventory = 22,000

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

`= (28000 + 22000)/2` = Rs 25000

Cost of Goods Sold = Opening Inventory + Purchases + Carriage Inwards − Closing Inventory

= 28,000 + 46,000 + 4,000 − 22,000 = 56,000

Inventory Turnover Ratio = `"Cost of Goods Sold"/"Average Inventory" = 56000/25000` = 2.24 Times

(ii) 

Operating Expenses = Office Expenses + Selling and Distribution Expenses

= 4,000 + 2,000 = 6,000

Operating Cost = Cost of Goods Sold + Operating Expenses

= 56000 + 6000 = 62000

Net Sales = Rs 80,000*

Operating Ratio = `"Operating Cost"/"Net Sales" xx 100`

`= 62000/80000 xx 100 = 77.5 %`

(iii)

Working Capital = 40,000

Working Capital Turnover Ratio = `"Net Sales"/"Working Capital" = 80000/40000` = 2 Times

*Note: Sales return will not be considered as amount of net sales is provided in the question. 

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

APPEARS IN

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

RELATED QUESTIONS

Short Answer Question

The average age of inventory is viewed as the average length of time inventory is held by the firm for which explain with reasons.


Current Ratio is 3.5 : 1. Working Capital is Rs 90,000. Calculate the amount of Current Assets and Current Liabilities.


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  

 


Working Capital  ₹  3,60,000; Total :Debts  ₹ 7,80,000; Long-term Debts ₹ 6,00,000; Inventories  ₹ 1,80,000. Calcltate Liquid Ratio.


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:

 
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.


Calculate Inventory Turnover Ratio from the following information:

Opening Inventory ₹ 40,000; Purchases ₹ 3,20,000; and Closing Inventory ₹ 1,20,000.
State, giving reason, which of the following transactions would (i) increase, (ii) decrease, (iii) neither increase nor decrease the Inventory Turnover Ratio:
(a) Sale of goods for ₹ 40,000 (Cost ₹ 32,000).
(b) increase in the value of Closing Inventory by ₹ 40,000.
(c) Goods purchased for ₹ 80,000.
(d) Purchases Return ₹ 20,000.
(e) goods costing ₹ 10,000 withdrawn for personal use.
(f) Goods costing ₹ 20,000 distributed as free samples.


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. 


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.


From the information given below, calculate Trade Receivables Turnover Ratio:
Credit Revenue from Operations, i.e., Credit Sales ₹8,00,000; Opening Trade Receivables ₹1,20,000; and Closing Trade Receivables ₹2,00,000.
State giving reason, which of the following would increase, decrease or not change Trade Receivables Turnover Ratio:
(i) Collection from Trade Receivables ₹40,000.
(ii) Credit Revenue from Operations, i.e., Credit Sales ₹80,000.
(iii) Sales Return ₹20,000.
(iv) Credit Purchase ₹1,60,000.


Revenue from Operations: Cash Sales ₹ 5,00,000; Credit Sales ₹ 6,00,000; Sales Return ₹ 1,00,000. Current Assets ₹ 3,00,000; Current Liabilities ₹ 1,00,000. Calculate Working Capital Turnover Ratio.


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 


Cost of Revenue from Operations (Cost of Goods Sold) ₹3,00,000. Operating Expenses ₹1,20,000. Revenue from Operations: Cash Sales ₹5,20,000; Return ₹20,000. Calculate Operating Ratio.


Revenue from Operations, i.e., Net Sales ₹ 8,20,000; Return ₹ 10,000; Cost of Revenue from Operations (Cost of Goods Sold) ₹ 5,20,000; Operating Expenses ₹ 2,09,000; Interest on Debentures ₹ 40,500; Gain (Profit) on Sale of a Fixed Asset ₹ 81,000. Calculate Net Profit Ratio. 


Following is the Balance Sheet of the Bharati Ltd. as at 31st March, 2019:

Particulars

Note No.

Amount

(₹)

I. EQUITY AND LIABILITIES

1. Shareholder's Funds

   

(a) Share Capital

 

7,50,000

(b) Reserves and Surplus:

   

Surplus, i.e., Balance in Statement of Profit and Loss:

   

Opening Balance

6,30,000 

 

20,88,000

Add: Transfer from Statement of Profit and Loss

14,58,000 

 

2. Non-Current Liabilities

   

15% Long-term Borrowings

 

24,00,000

3. Current Liabilities

 

12,00,000

Total

 

64,38,000

II. ASSETS    

1. Non-Current Assets

   

(a) Fixed Assets

 

27,00,000

(b) Non-Current Investments:

   

(i) 10% Investments

 

3,00,000

(ii) 10% Non-trade Investments

 

1,80,000

2. Current Assets  

32,58,000

Total

 

64,38,000

You are required to calculate Return on Investment for the year 2018-19 with reference to Opening Capital Employed. 


Calculate 'Liquid Ratio' from the following information:

Current Liabilities Rs. 50,000, Current Assets Rs. 80,000, Stock Rs.25,000, Prepaid Expenses Rs.5,000


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


Read the following information and answer the given question:

X Ltd. made a profit of 5,00,000 after consideration of the following items:

   
(i) Goodwill written off 5,000
(ii) Depreciation on Fixed Tangible Assets 50,000
(iii) Loss on Sale of Fixed Tangible
Assets (Machinery)
20,000
(iv) Provision for Doubtful Debts 10,000
(v) Gain on Sale of Fixed Tangible Assets (Land) 7,500

Additional information:

Particulars 31.3.2019
(₹)
31.3.2018
(₹)
Trade Receivables 78,800 52,000
Prepaid Expenses 3,000 2,000
Trade Payables 51,000 30,000
Expenses Payable 20,000 34,000

How will goodwill written off be adjusted in the cash flow statement?


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×