English

Calculate Gross Profit Ratio from the Following Data: - Accountancy

Advertisements
Advertisements

Question

Calculate Gross Profit Ratio from the following data:

Average Inventory ₹3,20,000; Inventory Turnover Ratio 8 Times; Average Trade Receivables ₹4,00,000; Trade Receivables Turnover Ratio 6 Times; Cash Sales 25% of Net Sales.

Sum

Solution

Inventory Turnover Ratio = 8 times
Average Inventory = Rs 3,20,000

Stock turnover Ratio = `"Cost of Goods Sold"/"Average Stock" = Cost of Goods Sold/320000` = 8 times

Cost of Goods sold = 25,60,000
Trade Receivables Turnover Ratio = 6 times
Average Trade Receivables = Rs 4,00,000

Trade Receivable Turnover Ratio = `"Net Credit Sales"/"Average Trade Receivables"`

`6 = "Net Credit Sales"/400000`

Net Credit Sales = 24,00,000
Total Sales = Cash Sales + Credit Sales
Total Sales = 25% of Total Sales + Credit Sales
75% of Total Sales = 24,00,000

Total Sales =`2400000/75% = 3200000`

Gross Profit = Total Sales – Cost of Goods Sold
= 32,00,000 – 25,60,000 = 6,40,000

Gross Profit Ratio = `"Gross Profit"/"Net Sales" xx 100`

`= 640000/3200000 xx 100 = 20 %`

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

APPEARS IN

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

RELATED QUESTIONS

Calculate Current Ratio if:

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


From the following Balance Sheet and other information, calculate following ratios: (i) Debt-Equity Ratio (ii) Working Capital Turnover Ratio (iii) Trade Receivables Turnover Ratio

Balance Sheet as at March 31, 2017

Particulars Note No. Rs.
I. Equity and Liabilities:    
1. Shareholders’ funds    
a) Share capital   10,00,000
b) Reserves and surplus   9,00,000
2. Non-current Liabilities    
Long-term borrowings   12,00,000
3. Current Liabilities    
Trade payables   5,00,000
Total   36,00,000
II. Assets    
1. Non-current Assets    
a) Fixed assets    
Tangible assets   18,00,000
2. Current Assets    
a) Inventories   4,00,000
b) Trade Receivables   9,00,000
c) Cash and cash equivalents   5,00,000
Total   36,00,000

Additional Information: Revenue from Operations Rs. 18,00,000


Quick Assets ₹ 1,50,000; Inventory (Stock) ₹ 40,000; Prepaid Expenses ₹ 10,000; Working Capital ₹ 1,20,000. Calculate Current Ratio.


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


Calculate Inventory Turnover Ratio from the data given Below:

Inventory in the beginning of the year Rs 20000
Inventory at the end of the year Rs 10000
Purchases Rs 50,000
Carriage Inwards Rs 5000
Revenue from Operations, i.e., Sales  Rs 100000

State the significance of this ratio.


Calculate Gross Profit Ratio from the following data:
Cash Sales are 20% of Total Sales; Credit Sales are ₹5,00,000; Purchases are ₹4,00,000; Excess of Closing Inventory over Opening Inventory ₹25,000.


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. 


From the following informations, calculate Return on Investment (or Return on Capital Employed):

Particulars

Share Capital

5,00,000

Reserves and Surplus 2,50,000
Net Fixed Assets 22,50,000
Non-current Trade Investments 2,50,000
Current Assets 11,00,000
10% Long-term Borrowings 20,00,000
Current Liabilities 8,50,000

Long-term Provision

NIL


Answer the following question:
The current ratio of a company is 2: 1. State giving reason whether the purchase of goods on credit will increase, decrease, or not change the ratio.


Calculate 'Total Assets to Debt ratio' from the following information:

 
Equity Share Capital 4,00,000
Long Term Borrowings 1,80,000
Surplus i.e. Balance in statement of Profit and Loss 1,00,000
General Reserve 70,000
Current Liabilities 30,000
Long Term Provisions 1,20,000

Quick Ratio can be calculated as ______?


Calculate current ratio from the following information:

Stock Rs.50,000, Cash 30,000, Debtors 40,000, Creditors 60,000, Bills Receivable 10,000, Bills Payable 40,000, Advance Tax 4,000, Bank Overdraft 4,000


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


Debt Ratio can be calculated as ______?


Return on Capital Employed or Investment (ROCE or ROI) can be calculated as ______?


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


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?


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  

What will be the amount of Trade payables added to get the Cash flow from operations?


Pick the odd one out.


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×