Problems on Conversion of Financial Statements into Ratios and Ratios into Financial Statements

Conversion of Financial Statements into Ratios and Ratios into Financial Statements is an important application of Ratio Analysis in Management Accounting. Financial statements provide accounting figures, while ratios establish meaningful relationships between these figures. In some problems, given financial statement information is used to calculate different ratios such as Current Ratio, Quick Ratio, Gross Profit Ratio, and Debt Equity Ratio. In other problems, certain ratios are given and the required financial figures are calculated or reconstructed using algebraic relationships and accounting formulas. These problems help students understand the practical relationship between financial statements and accounting ratios. They are useful for analysing financial position, profitability, liquidity, solvency, and overall business performance.

A. Conversion of Financial Statements into Ratios

Question: From the following information, calculate Current Ratio, Quick Ratio, Gross Profit Ratio and Net Profit Ratio:

Particulars Amount (₹)
Current Assets 2,00,000
Inventory 50,000
Current Liabilities 1,00,000
Net Sales 4,00,000
Cost of Goods Sold 2,80,000
Operating Expenses 60,000

Solution:

1. Current Ratio

Current Ratio = Current Assets / Current Liabilities

= 2,00,000 / 1,00,000

= 2 : 1

2. Quick Ratio

Quick Assets = Current Assets − Inventory

= 2,00,000 − 50,000

= ₹1,50,000

Quick Ratio = Quick Assets / Current Liabilities

= 1,50,000 / 1,00,000

= 1.5 : 1

3. Gross Profit Ratio

Gross Profit = Net Sales − Cost of Goods Sold

= 4,00,000 − 2,80,000

= ₹1,20,000

Gross Profit Ratio = Gross Profit / Net Sales × 100

= 1,20,000 / 4,00,000 × 100

= 30%

4. Net Profit Ratio

Net Profit = Gross Profit − Operating Expenses

= 1,20,000 − 60,000

= ₹60,000

Net Profit Ratio = Net Profit / Net Sales × 100

= 60,000 / 4,00,000 × 100

= 15%

B. Conversion of Ratios into Financial Statements

Question: The following ratios are available:

Current Ratio = 2 : 1
Quick Ratio = 1 : 1
Net Profit Ratio = 20%
Net Sales = ₹5,00,000
Current Liabilities = ₹1,50,000

Calculate Current Assets, Quick Assets, Inventory and Net Profit.

Solution:

1. Current Assets

Current Ratio = Current Assets / Current Liabilities

Therefore,

Current Assets = Current Ratio × Current Liabilities

= 2 × 1,50,000

= ₹3,00,000

2. Quick Assets

Quick Ratio = Quick Assets / Current Liabilities

Therefore,

Quick Assets = 1 × 1,50,000

= ₹1,50,000

3. Inventory

Quick Assets = Current Assets − Inventory

Therefore,

Inventory = Current Assets − Quick Assets

= 3,00,000 − 1,50,000

= ₹1,50,000

4. Net Profit

Net Profit Ratio = Net Profit / Net Sales × 100

Therefore,

Net Profit = 20% × 5,00,000

= ₹1,00,000

Final Answer

Particulars Amount
Current Assets ₹3,00,000
Quick Assets ₹1,50,000
Inventory ₹1,50,000
Current Liabilities ₹1,50,000
Net Sales ₹5,00,000
Net Profit ₹1,00,000

These examples show how financial statement figures can be converted into ratios and how given ratios can be used to determine missing financial statement figures.

Leave a Reply

error: Content is protected !!