- Practice
- About 22 min
- 5 practice questions
Comparative statements
Prepare comparative income statements and comparative balance sheets with absolute and percentage changes, and read what they show.
If something looks wrong, please tell us.
By the end of this lesson you can
- Lay out the five columns of a comparative statement.
- Prepare a comparative income statement, including tax.
- Prepare a comparative balance sheet and comment on the main changes.
A comparative statement puts two years side by side so that every rise and fall is visible, in rupees and in per cent. It is the simplest way to see what changed.
The five columns
| Column | Contents |
|---|---|
| 1 | Particulars of the income statement or balance sheet |
| 2 | Amount of year 1 |
| 3 | Amount of year 2 |
| 4 | Absolute increase (+) or decrease (−): year 2 − year 1 |
| 5 | Percentage increase (+) or decrease (−): column 4 ÷ column 2 × 100 |
Percentage change = Absolute increase or decrease ÷ Year 1 amount × 100.
Comparative income statement
Worked example 1
The company and all figures in this example are made up for practice. Mugil Ltd: revenue from operations ₹4,00,000 in Year 1 and ₹5,00,000 in Year 2; other income ₹50,000 and ₹40,000; expenses ₹2,50,000 and ₹3,15,000; income tax 25% of profit before tax in both years.
| Particulars | Year 1 ₹ | Year 2 ₹ | Change ₹ | Change % |
|---|---|---|---|---|
| Revenue from operations | 4,00,000 | 5,00,000 | +1,00,000 | +25 |
| Add: Other income | 50,000 | 40,000 | −10,000 | −20 |
| Total revenue | 4,50,000 | 5,40,000 | +90,000 | +20 |
| Less: Expenses | 2,50,000 | 3,15,000 | +65,000 | +26 |
| Profit before tax | 2,00,000 | 2,25,000 | +25,000 | +12.5 |
| Less: Income tax (25%) | 50,000 | 56,250 | +6,250 | +12.5 |
| Profit after tax | 1,50,000 | 1,68,750 | +18,750 | +12.5 |
Working, checked twice: total revenue 4,00,000 + 50,000 = 4,50,000 and 5,00,000 + 40,000 = 5,40,000; 90,000 ÷ 4,50,000 × 100 = 20%. Expenses 65,000 ÷ 2,50,000 × 100 = 26%. Profit before tax 4,50,000 − 2,50,000 = 2,00,000 and 5,40,000 − 3,15,000 = 2,25,000; 25,000 ÷ 2,00,000 × 100 = 12.5%. Tax 2,00,000 × 25% = 50,000 and 2,25,000 × 25% = 56,250. Note the percentage on a total is worked on the total, never by adding the item percentages. Reading it: revenue grew 25%, but expenses grew faster (26%) and other income fell, so profit grew only 12.5%.
Comparative balance sheet
Worked example 2
| Particulars | Year 1 ₹ | Year 2 ₹ | Change ₹ | Change % |
|---|---|---|---|---|
| I. Equity and liabilities | ||||
| Share capital | 3,00,000 | 3,60,000 | +60,000 | +20 |
| Reserves and surplus | 1,00,000 | 1,50,000 | +50,000 | +50 |
| Long-term borrowings | 80,000 | 60,000 | −20,000 | −25 |
| Trade payables | 20,000 | 30,000 | +10,000 | +50 |
| Total | 5,00,000 | 6,00,000 | +1,00,000 | +20 |
| II. Assets | ||||
| Fixed assets | 2,50,000 | 3,25,000 | +75,000 | +30 |
| Non-current investments | 50,000 | 40,000 | −10,000 | −20 |
| Inventories | 1,20,000 | 1,50,000 | +30,000 | +25 |
| Cash and cash equivalents | 80,000 | 85,000 | +5,000 | +6.25 |
| Total | 5,00,000 | 6,00,000 | +1,00,000 | +20 |
Check the totals: 3,00,000 + 1,00,000 + 80,000 + 20,000 = 5,00,000 and 3,60,000 + 1,50,000 + 60,000 + 30,000 = 6,00,000; assets 2,50,000 + 50,000 + 1,20,000 + 80,000 = 5,00,000 and 3,25,000 + 40,000 + 1,50,000 + 85,000 = 6,00,000. Cash: 5,000 ÷ 80,000 × 100 = 6.25%. Reading it: the business grew by 20%. The growth was financed by more share capital and retained profits (reserves +50%) while long-term borrowings were reduced; the funds went mainly into fixed assets (+30%).
Key takeaways: always divide the change by the year 1 figure. Work totals and percentages on totals separately. A comparative statement shows what changed; the reasons need further study.
Check your understanding
-
1. A company's revenue from operations rose from ₹1,60,000 to ₹2,00,000. In a comparative income statement the percentage change is
- +20%
- +40%
- +25%
- +125%
Show answer
Answer: C. Change = 2,00,000 − 1,60,000 = 40,000. Percentage = 40,000 ÷ 1,60,000 × 100 = 25%. Dividing by the year 2 figure would give 20%, which is wrong.
-
2. In a comparative statement, the percentage increase or decrease is calculated on
- the year 1 amount
- the year 2 amount
- the average of the two years
- the total of the balance sheet
Show answer
Answer: A. Column 5 = column 4 ÷ column 2 × 100, and column 2 holds the year 1 amount.
-
3. Expenses fell from ₹2,40,000 to ₹2,04,000. The comparative statement shows
- +15%
- −17.6%
- −36%
- −15%
Show answer
Answer: D. Change = 2,04,000 − 2,40,000 = −36,000. Percentage = −36,000 ÷ 2,40,000 × 100 = −15%.
-
4. Profit before tax was ₹1,50,000 in Year 1 and ₹1,80,000 in Year 2; tax is 40% in both years. The percentage change in profit after tax is
- +18%
- +20%
- +30%
- +12%
Show answer
Answer: B. Profit after tax = 60% of profit before tax: 90,000 and 1,08,000. Change = 18,000; 18,000 ÷ 90,000 × 100 = 20%. With the same tax rate, the change equals that in profit before tax.
-
5. A comparative statement, as described in the textbook, has
- three columns
- five columns
- two columns
- four columns
Show answer
Answer: B. Particulars, year 1, year 2, absolute change and percentage change: five columns. A common-size statement for one year needs three.
Sign in to keep track of the lessons you finish.