Advertisements
Advertisements
Question
You are able to collect the following information about a company for two years:
|
|
2015-16 |
|
2016-17 |
Trade receivables on Apr. 01 |
Rs. |
4,00,000 |
Rs |
5,00,000 |
Trade receivables on Mar. 31 |
|
|
Rs |
5,60,000 |
Stock in trade on Mar. 31 |
Rs. |
6,00,000 |
Rs |
9,00,000 |
Revenue from operations (at gross profit of 25%) |
Rs. |
3,00,000 |
Rs |
24,00,000 |
Calculate Inventory Turnover Ratio and Trade Receivables Turnover Ratio.
Solution
`"Inventory turnover ratio" = "Cost of revenue from operations"/"Average Inventory"`
or,
`"Cost of revenue from operations" = "Revenue from Operartions" - "Gross profit"`
= `24,00,000 - 6,00,000`
= `18,00,000`
`"Average Inventor" = ("Inventory in the begining" + "Inventory at the end")/2`
= `(6,00,000 + 9,00,000)/2`
= `7,50,000`
`"Inventory turnover ratio" = "18,00,000"/"7,50,000" = 2.4 "times"`
`"Trade Recievable turnover ratio" = "Net credit sales"/"Average trade recievables"`
`"Average trade recievables" = ("Trade Recievables in the begining" + "Trade Recievables at the end")/2`
= `(5,00,000 + 5,60,000)/2`
= `5,30,000`
`"Trade Recievables turnover Ratio" = "24,00,000"/"5,30,000"= 4.53 "times"`
Note: It has been assumed that all sales are credit sales.
APPEARS IN
RELATED QUESTIONS
What relationship will be established to study:
Working Capital Turnover
From the following compute Current Ratio:
₹ | ₹ | |||
Trade Receivable (Sundry Debtors) | 1,80,000 | Bills Payable | 20,000 | |
Prepaid Expenses | 40,000 | Sundry Creditors | 1,00,000 | |
Cash and Cash Equivalents | 50,000 | Debentures | 4,00,000 | |
Marketable Securities | 50,000 | Inventories | 80,000 | |
Land and Building | 5,00,000 | Expenses Payable | 80,000 |
Current Liabilities of a company are ₹ 6,00,000. Its Current Ratio is 3 : 1 and Liquid Ratio is 1 : 1. Calculate value of Inventory.
Total Assets ₹22,00,000; Fixed Assets ₹10,00,000; Capital Employed ₹20,00,000. There were no Long-term Investments.
Calculate Current Ratio.
From the following Balance Sheet of ABC Ltd. as at 31st March, 2019, Calculate Debt to Equity Ratio:
Particulars |
₹ |
|
I. EQUITY AND LIABILITIES | ||
1. Shareholder's Funds |
||
(a) Share Capital: |
||
(i) Equity Share Capital |
5,00,000 |
|
(ii) 10% Preference Share Capital |
5,00,000 |
10,00,000 |
(b) Reserves and Surplus |
2,40,000 |
|
2. Non-Current Liabilities |
||
Long-term Borrowings (Debentures) |
2,50,000 |
|
3. Current Liabilities : |
||
(a) Trade Payables |
4,30,000 |
|
(b) Other Current Liabilities |
20,000 |
|
(c) Short-term Provisions: Provision for Tax |
3,00,000 |
|
Total |
22,40,000 |
|
II. ASSETS | ||
1. Non-Current Assets |
||
Fixed Assets: |
||
(i) Tangible Assets |
6,40,000 |
|
(ii) Intangible Assets |
1,00,000 |
|
2. Current Assets |
||
(a) Inventories |
7,50,000 |
|
(b) Trade Receivables |
6,40,000 |
|
(c) Cash and Cash Equivalents |
1,10,000 |
|
Total |
22,40,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 |
If Profit before Interest and Tax is ₹5,00,000 and interest on Long-term Funds is ₹1,00,000, find Interest Coverage Ratio.
From the following information, calculate Interest Coverage Ratio:
₹ | |
10,000 Equity Shares of ₹10 each | 1,00,000 |
8% Preference Shares | 70,000 |
10% Debentures | 50,000 |
Long-term Loans from Bank | 50,000 |
Interest on Long-term Loans from Bank | 5,000 |
Profit after Tax | 75,000 |
Tax | 9,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% |
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.
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.
From the following, calculate Gross Profit Ratio:
Gross Profit:₹50,000; Revenue from Operations ₹5,00,000; Sales Return: ₹50,000.
Operating Cost ₹ 3,40,000; Gross Profit Ratio 20%; Operating Expenses ₹ 20,000. Calculate Operating Profit Ratio.
From the following information related to Naveen Ltd., calculate (a) Return on Investment and (b) Total Assets to Debt Ratio:
Information: Fixed Assets ₹ 75,00,000; Current Assets ₹ 40,00,000; Current Liabilities ₹ 27,00,000; 12% Debentures ₹ 80,00,000 and Net Profit before Interest, Tax and Dividend ₹ 14,50,000.
Liquid assets are determined by:
Collection of debtors:
Which Ratio establishes the relationship between current assets and current liabilities?
Interest Coverage Ratio can be calculated as ______?
Pick the odd one out.
Which of the following is a profitability ratio?