English

Uestion 18: from the Following Information, Calculate the Following Ratios: I) Quick Ratio Ii) Inventory Turnover Ratio Iii) Return on Investment - Accountancy

Advertisements
Advertisements

Question

From the following information, calculate the following ratios:
i) Quick Ratio
ii) Inventory Turnover Ratio
iii) Return on Investment

  Rs.
Inventory in the beginning 50,000
Inventory at the end 60,000
Revenue from operations 4,00,000
Gross Profit 1,94,000
Cash and Cash Equivalents 40,000
Trade Receivables 1,00,000
Trade Payables 1,90,000
Other Current Liabilities 70,000
Share Capital 2,00,000
Reserves and Surplus 1,40,000

(Balance in the Statement of Profit & Loss A/c)

Sum

Solution

(i) Quick Ratio = `"Quick Assets"/"Current Liabilities"`

Quick Assets = Cash + Debtors
= 40,000 + 1,00,000
= 1,40,000
Current Liabilities = Creditors + Outstanding Expenses
= 190,000 + 70,000
= 260,000

Quick Ratio = `[1,40,000]/[2,60,000] = 7 : 13 = 0.54 : 1`

(ii) Inventory Turnover Ratio = `"Cost of Revenue from Operations"/"Average Inventory"`

Cost of Revenue from Operations = Revenue From Operations - Gross Profit
= 4,00,000 - 1,94,000
= 2,06,000

Average Inventory = `"Inventory in the beinning + Inventory at the end"/2`
= `[50,000 + 60,000]/2`

= 55,000

Inventory Turnover Ratio = `[2,06,000]/[55,000]` = 3.74 times

Return on Investment = `"Profit before Interest and tax"/"Capital Employed"` x 100
Capital Employed = `"Equity Share Capital + Profit and Loss"`
= 2,00,000 + 1,40,000
= 3,40,000

Return on Investment = `[1,40,000]/[3,40,000] xx 100` = 41.17 % 

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

APPEARS IN

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

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.


Long Answer Question

How would you study the solvency position of the firm?


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


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.


Current Assets of a company is are  ₹ 5,00,000. Its Current Ratio is 2.5 : 1 and Quick Ratio is 1 : 1. Calculate value of Current Liabilities, Liquid Assets and Inventory.


When Debt to Equity Ratio is 2, state giving reason, whether this ratio will increase or decrease or will have no change in each of the following cases:
(i) Sale of Land (Book value ₹4,00,000) for ₹5,00,000; (ii) Issue of Equity Shares for the purchase of Plant and Machinery worth ₹10,00,000; (iii) Issue of Preference Shares for redemption of 13% Debentures, worth ₹10,00,000.


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.


From the following information, calculate Proprietary Ratio: 

Particulars

Note No.

Amount
(₹)

I. EQUITY AND LIABILITIES

1. Shareholders' Funds 

 

 

(a) Share Capital

 

6,00,000

(b) Reserves and Surplus

 

1,50,000

2. Current Liabilities

 

 

(a) Trade Payables

 

1,00,000

(b) Other Current Liabilities

 

50,000

(c) Short-term Provisions (Provision for Tax)

 

1,00,000

Total

 

10,00,000

II. ASSETS

 

 

1. Non-Current Assets

 

 

Fixed Assets (Tangible Assets)

 

5,00,000

2. Current Assets

 

 

(a) Current Investments

 

1,50,000

(b) Inventories 

 

1,00,000

(c) Trade Receivables

 

1,50,000

(d) Cash and Cash Equivalents

 

1,00,000

Total

 

10,00,000


Inventory Turnover Ratio 5 times; Cost of Revenue from Operations (Cost of Goods Sold) ₹ 18,90,000. Calculate Opening Inventory and Closing Inventory if Inventory at the end is 2.5 times more than that in the beginning.


From the following Information, calculate Inventory Turnover Ratio:
Credit Revenue from Operations ₹ 3,00,000; Cash Revenue from Operations ₹ 1,00,000, Gross Profit 25% of Cost, Closing Inventory was 3 times the Opening Inventory. Opening Inventory was 10% of Cost of Revenue from Operations.


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.


(i) Revenue from Operations: Cash Sales ₹4,20,000; Credit Sales ₹6,00,000; Return ₹20,000. Cost of Revenue from Operations or Cost of Goods Sold ₹8,00,000. Calculate Gross Profit Ratio.
(ii) Average Inventory ₹1,60,000; Inventory Turnover Ratio is 6 Times; Selling Price 25% above cost. Calculate Gross Profit Ratio.
(iii) Opening Inventory ₹1,00,000; Closing Inventory ₹60,000; Inventory Turnover Ratio 8 Times; Selling Price 25% above cost. Calculate Gross Profit Ratio.


Ratio analysis provide analysis of the _________.


Debt Ratio can be calculated as ______?


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


The ______ ratios provide the information critical to the long run operation to the firm.


Operating Profit ratio is equal to ______


Read the following information and answer the given question:

Year 2020 2019 2018
Amount (in ₹) (in ₹) (in ₹)
Outstanding Expenses 50,000 40,000 25,000
Prepaid Expenses 3,00,000 2,50,000 3,50,000
Trade Payables 18,00,000 16,00,000 14,00,000
Inventory 12,00,000 10,00,000 11,00,000
Trade Receivables 11,00,000 8,00,000 10,00,000
Cash in hand 17,00,000 12,00,000 15,00,000
Revenue from operations 24,00,000 18,00,000 20,00,000
Gross Profit Ratio 12% 15% 18%

Quick Ratio for the year 2018 will be ______. (Choose the correct alternative)


Read the following information and answer the given question:

Year 2020 2019 2018
Amount (in ₹) (in ₹) (in ₹)
Outstanding Expenses 50,000 40,000 25,000
Prepaid Expenses 3,00,000 2,50,000 3,50,000
Trade Payables 18,00,000 16,00,000 14,00,000
Inventory 12,00,000 10,00,000 11,00,000
Trade Receivables 11,00,000 8,00,000 10,00,000
Cash in hand 17,00,000 12,00,000 15,00,000
Revenue from operations 24,00,000 18,00,000 20,00,000
Gross Profit Ratio 12% 15% 18%

Inventory turnover ratio for the year 2020 will be ______. (Choose the correct alternative)


What relationship will be established to study:

Trade payables turnover


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×