Advertisements
Advertisements
Question
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.
Solution
Average Trade Receivebles =`(120000 + 200000)/2 = 160000`
Trade Receivable Turnover Ratio = `"Net Credit Sales"/"Average Trade Receivables" = 800000/160000` = 5 times
(i) Collection from Trade Receivables Rs 40,000- Increase
Reason: Collection from Trade Receivables will result in decrease in the amount of closing Trade Receivables which will reduce the amount of average Trade Receivables.
Closing Trade Receivables = 2,00,000 − 40,000 = Rs 1,60,000
Average Trade Receivebles = `(120000 + 160000)/2 = 140000`
Trade Receivable Turnover Ratio = `"Net Credit Sales"/"Average Trade Receivables" = 800000/140000` = 5.71 times (Increased from 5 to 5.71)
(ii) Credit Revenue from Operations, i.e. Sales Rs 80,000- Decrease
Reason: This transaction will result in increase in both credit sales as well as closing Trade Receivables. Increase in closing Trade Receivables, in turn, will lead to an increase in the average Trade Receivables.
Credit Sales = 8,00,000 + 80,000 = Rs 8,80,000
Closing Trade Receivables = 2,00,000 + 80,000 = Rs 2,80,000
Average Trade Receivebles = `(120000 + 280000)/2` = Rs 200000
Trade Receivable Turnover Ratio = `"Credit Sales"/"Average Trade Receivables" =880000/200000` = 4.4 times
(iii) Sales Return Rs 20,000- Increase
Reason: This transaction will result in decrease in both sales and average Trade Receivables.
Credit Sales = 8,00,000 − 20,000= Rs 7,80,000
Closing Trade Receivables = 2,00,000 − 20,000 = Rs 1,80,000
Average Trade Receivebles = `(120000 + 180000)/2` = Rs 150000
Trade Receivable Turnover Ratio = `780000/150000` = 5.2 Times
(iv) Credit Purchase Rs 1,60,000- No Change
Reason: Credit Purchase does not affect the Debtors Turnover Ratio.
APPEARS IN
RELATED QUESTIONS
Long Answer Question
What are important profitability ratios? How are these worked out?
Calculate debt equity ratio from the following information:
|
|
Rs |
|
Total Assets |
15,00,000 |
|
Current Liabilities |
6,00,000 |
|
Total Debts |
12,00,000 |
From the following information calculate:
(i) Gross Profit Ratio (ii) Inventory Turnover Ratio (iii) Current Ratio (iv) Liquid Ratio (v) Net Profit Ratio (vi) Working capital Ratio:
|
|
Rs |
|
Revenue from Operations |
25,20,000 |
|
Net Profit |
3,60,000 |
|
Cast of Revenue from Operations |
19,20,000 |
|
Long-term Debts |
9,00,000 |
|
Trade Payables |
2,00,000 |
|
Average Inventory |
8,00,000 |
|
Current Assets |
7,60,000 |
|
Fixed Assets |
14,40,000 |
|
Current Liabilities |
6,00,000 |
|
Net Profit before Interest and Tax |
8,00,000 |
Current Assets are ₹ 7,50,000 and Working Capital is ₹ 2,50,000. Calculate Current Ratio.
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.
The Quick Ratio of a company is 0.8:1. State with reason, whether the following transactions will increase, decrease or not change the Quick Ratio:
(i) Purchase of loose tools for ₹2,000; (ii) Insurance premium paid in advance ₹500; (iii) Sale of goods on credit ₹3,000; (iv) Honoured a bills payable of ₹5,000 on maturity.
XYZ Limited's Inventory is ₹3,00,000. Total Liquid Assts are ₹12,00,000 and Quick Ratio is 2:1. Work out Current Ratio.
Calculate Debt to Equity Ratio from the following information:
| ₹ | ₹ | |||
| Fixed Assets (Gross) | 8,40,000 | Current Assets | 3,50,000 | |
| Accumulated Depreciation | 1,40,000 | Current Liabilities | 2,80,000 | |
| Non-current Investments | 14,000 | 10% Long-term Borrowings | 4,20,000 | |
| Long-term Loans and Advances | 56,000 | Long-term Provisions | 1,40,000 |
Shareholders' Funds ₹ 1,60,000; Total Debts ₹ 3,60,000; Current Liabilities ₹ 40,000.
Calculate Total Assets to Debt Ratio.
Revenue from Operations ₹4,00,000; Gross Profit ₹1,00,000; Closing Inventory ₹1,20,000; Excess of Closing Inventory over Opening Inventory ₹40,000. Calculate Inventory Turnover Ratio.
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?
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.
Following information is given about a company:
| ₹ | ₹ | |||
| Revenue From Operations, i.e., Net Sales Gross Profit | 1,50,000 | Opening Inventory | 29,000 | |
| Cost of Revenue From Operations | 30,000 | Closing Inventory | 31,000 | |
| (Cost of Goods Sold) | 1,20,000 | Debtors | 16,000 |
From the above information, calculate following ratios:
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.
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 |
Which one of the following is correct?
- A ratio is an arithmetical relationship of one number to another number.
- Liquid ratio is also known as acid test ratio.
- Ideally accepted current ratio is 1: 1.
- Debt equity ratio is the relationship between outsider’s funds and shareholders’ funds.
The ______ may indicate that the firm is experiencing stock outs and lost sales.
Revenue from the sale of goods manufactured is shown in the Statement of Profit and Loss as ______
Debt to Capital Employed ratio is 0.3:1. State whether the following transaction, will improve, decline or will have no change on the Debt to Capital Employed Ratio. Also give a reason for the same.
Tax Refund of ₹ 50,000 during the year.
