English

From the Following Statement of Profit and Loss for the Year Ended 31st March, 2019 of Rex Ltd., Calculate Inventory Turnover Ratio: - Accountancy

Advertisements
Advertisements

Question

From the following Statement of Profit and Loss for the year ended 31st March, 2019 of Rex Ltd., calculate Inventory Turnover Ratio:

STATEMENT OF PROFIT AND LOSS
for the year ended 31st March, 2019 

Particulars 

Note No.

Amount

(₹)

I. Revenue from Operations (Net Sales)  

6,00,000

II. Expenses:    

(a) Purchases of Stock-in-Trade

 

3,00,000

(b) Change in Inventory of Stock-in-Trade

1

50,000

(c) Employees Benefit Expenses

 

60,000

(d) Other Expenses

2

45,000

Total Expenses  

4,55,000

III. Profit before Tax (I-II)  

1,45,000

IV. Less: Tax  

45,000

V. Profit after Tax (III-IV)  

1,00,000

Notes to Accounts

Particulars

Amount

(₹)

I. Change in Inventory of stock-in-Trade  

Opening Inventory

1,25,000

Less: Closing Inventory

75,000

 

50,000

2. Other Expenses  

Carriage Inwards

15,000

Miscellaneous Expenses 

30,000

 

45,000

Sum

Solution

Cost of Goods Sold = Opening Inventory+ Purchases + Direct Expenses – Closing Inventory

= Rs 1,25,000 + Rs 3,00,000 + Rs 15,000 – Rs 75,000 = Rs 3,65,000

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

= `(125000 + 75000)/2 = 100000`

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

`= 365000/100000` = 3.65 times  

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

APPEARS IN

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

RELATED QUESTIONS

Following is the Balance Sheet of Title Machine Ltd. as at March 31, 2017. 

Particulars  

Amount

Rs. 

I. Equity and Liabilities    

1. Shareholders’ funds  

 

a) Share capital

24,00,000

b) Reserves and surplus

6,00,000

2. Non-current liabilities  

 

a) Long-term borrowings

9,00,000

3. Current liabilities

 

a) Short-term borrowings  

6,00,000

b) Trade payables

23,40,000

c) Short-term provisions  

60,000
Total 69,00,000
II. Assets  

1. Non-current Assets  

 

a) Fixed assets

 

Tangible assets

45,00,000

2. Current Assets

 

a) Inventories

12,00,000

b) Trade receivables

9,00,000

c) Cash and cash equivalents

2,28,000

d) Short-term loans and advances

72,000
Total 69,00,000

Calculate Current Ratio and Liquid Ratio.


Current liabilities of a company are Rs 75,000. If current ratio is 4:1 and liquid ratio is 1:1, calculate value of current assets, liquid assets and inventory.


Calculate Current Ratio if:

Inventory is Rs 6,00,000; Liquid Assets Rs 24,00,000; Quick Ratio 2:1.


Compute Stock Turnover Ratio from the following information:

 

 

Rs

Net Revenue from Operations

2,00,000

Gross Profit

50,000

Inventory at the end

60,000

Excess of inventory at the end over inventory in the beginning

20,000


Calculate following ratios from the following information:

(i) Current ratio (ii) Acid test ratio (iii) Operating Ratio (iv) Gross Profit Ratio

 

 

Rs

Current Assets

35,000

Current Liabilities

17,500

Inventory

15,000

Operating Expenses

20,000

Revenue from Operations

60,000

Cost of Goods Sold

30,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.


Current Liablilites of a company were ₹1,75,000 and its Current Ratio was 2:1. It paid ₹30,000 to a Creditor. Calculate Current Ratio after payment.


Calculate Total Assets to Debt Ratio from the following information:
Long-term Debts ₹ 4,00,000; total Assets  ₹ 7,70,000.


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


From the following infromation, calculate Proprietary Ratio:

 

Equity Share Capital 3,00,000
Preference Share Capital 1,50,000
Reserves and Surplus 75,000
Debentures 1,80,000

Trade Payables

45,000

 

7,50,000

Fixed Assets

3,75,000
Short-term Inverstments 2,25,000

Other Current Assets

1,50,000

 

7,50,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.


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.


A firm normally has trade Receivables equal to two months' credit Sales. During the coming year it expects Credit Sales of ₹ 7,20,000 spread evenly over the year (12 months). What is the estimated amount of Trade Receivables at the end of the year?


Calculate Operating Ratio from the following information:
Operating Cost ₹ 6,80,000; Gross Profit 25%; Operating Expenses ₹ 80,000. 


What will be the Operating Profit Ratio, if Operating Ratio is 82.59%?


Revenue from Operations ₹ 9,00,000; Gross Profit 25% on Cost; Operating Expenses ₹ 45,000. Calculate Operating Profit Ratio.


Pick the odd one out:


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)


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


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×