English

From the Following Information, Calculate Opening and Closing Trade Receivables, If Trade Receivables Turnover Ratio is 3 Times: - Accountancy

Advertisements
Advertisements

Question

From the following information, calculate Opening and Closing Trade Receivables, if Trade Receivables Turnover Ratio is 3 Times:

(i) Cash Revenue from Operations is 1/3rd of Credit Revenue from Operations.
(ii) Cost of Revenue from Operations is ₹3,00,000.
(iii) Gross Profit is 25% of the Revenue from Operations.
(iv) Trade Receivables at the end are 3 Times more than that of in the beginning. 

Sum

Solution

Trade Receivable Turnover Ratio =`"Credit Revenue from Operations"/"Average Trade Receivables"`

`3 = 300000/"Average Trade Receivables"`

`"Average Trade Receivables" = 300000/3 = 100000`

`"Average Trade Receivables" =("Opening Trade Receivables + Closing Trade Receivables")/2 ` 

`100000 = (x + 4x)/2`

So, x would be Rs 40000

∴Opening receivables would be Rs 40,000 and, 

Closing Receivables would be Rs 1,60,000 (40,000 × 4)

Revenue from Operations= `300000 + 25/75 xx 300000` = Rs 400000

Credit Revenue from Operations=Total Revenue from OperationsCash Revenue from Operations

`x = 400000 - 1/3 x`

Credit Revenue from Operations=Rs 3,00,000 

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

APPEARS IN

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

RELATED QUESTIONS

Following is the Balance Sheet of Raj Oil Mills Limited as at March 31, 2017. Calculate Current Ratio.

Particulars (Rs)
I. Equity and Liabilities:  

1. Shareholders’ funds

 

a) Share capital

7,90,000

b) Reserves and surplus

35,000

2. Current Liabilities

 

a) Trade Payables

72,000
Total 8,97,000
II. Assets  

1. Non-current Assets

 

a) Fixed assets

 

Tangible assets

7,53,000

2. Current Assets

 

a) Inventories

55,800

b) Trade Receivables

28,800

c) Cash and cash equivalents

59,400
Total 8,97,000

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.


Calculate Current Ratio if:

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


Total Assets ₹22,00,000; Fixed Assets ₹10,00,000; Capital Employed ₹20,00,000. There were no Long-term Investments.
Calculate Current Ratio.


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.


Calculate Inventory Turnover Ratio from the following:

 
Opening Inventory 29,000
Closing Inventory 31,000
Revenue from Operations, i.e., Sales 3,20,000
Gross Profit Ratio 25%

₹ 3,00,000 is the Cost of Revenue from Operations (Cost of Goods Sold). Inventory Turnover Ratio 8 times; Inventory in the beginning is 2 times more than the inventory at the end. Calculate value of Opening and Closing Inventories


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.


Compute Gross Profit Ratio from the following information:
Revenue from Operations, i.e., Net Sales = ₹4,00,000; Gross Profit 25% on Cost.


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


Calculate Operating Profit Ratio,in each of the following alternative cases:
Case 1:  Revenue from Operations (Net Sales) ₹ 10,00,000; Operating Profit ₹ 1,50,000.
Case 2:  Revenue from Operations (Net Sales) ₹ 6,00,000; Operating Cost ₹ 5,10,000.
Case 3:  Revenue from Operations (Net Sales) ₹ 3,60,000; Gross Profit 20% on Sales; Operating Expenses ₹ 18,000
Case 4: Revenue from Operations (Net Sales) ₹ 4,50,000; Cost of Revenue from Operations ₹ 3,60,000; Operating Expenses ₹ 22,500.
Case 5: Cost of Goods Sold, i.e., Cost of Revenue from Operations ₹ 8,00,000; Gross Profit 20% on Sales; Operating Expenses ₹ 50,000. 


Net Profit before Interest and Tax ₹2,50,000; Capital Employed ₹10,00,000. Calculate Return on Investment.


Net Profit before Interest and Tax ₹4,00,000; 15% Long-term Debt ₹8,00,000; Shareholders' Funds ₹4,00,000. Calculate Return on Investment.


From the following information, calculate any two of the following ratios:

(i) Current Ratio; 
(ii) Debt to Equity Ratio; and
(iii) Operating Ratio.
Revenue from Operations (Net Sales) ₹ 1,00,000; cost of Revenue from Operations (Cost of Goods Sold) was 80% of sales; Equity Share Capital ₹ 7,00,000; General Reserve ₹ 3,00,000; Operating Expenses ₹ 10,000; Quick Assets ₹ 6,00,000; 9% Debentures ₹ 5,00,000; Closing Inventory ₹ 50,000; Prepaid Expenses ₹ 10,000 and Current Liabilities ₹ 4,00,000. 

Ratio analysis provide analysis of the _________.


Creditors (Payable) Turnover Ratio can be calculated as ______?


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 34,000

What amount of trade Receivables will be subtracted from the Cash flow Statement to get Cash flow from operations?


______ ratios are a measure of the speed with which various accounts are converted into sales.


Determine Return on Investment and Net Assets Turnover ratio from the following information:

Profits after Tax were ₹ 6,00,000; Tax rate was 40%; 15% Debentures were of ₹20,00,000; 10% Bank Loan was ₹ 20,00,000; 12% Preference Share Capital ₹ 30,00,000; Equity Share Capital ₹ 40,00,000 ; Reserves and Surplus were ₹ 10,00,000; Sales ₹ 3,75,00,000 and Sales Return ₹ 15,00,000.


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×