- Practice
- About 22 min
- 5 practice questions
Common-size statements and trend analysis
Prepare common-size income statements and balance sheets, calculate trend percentages over several years, and interpret the results.
If something looks wrong, please tell us.
By the end of this lesson you can
- Prepare a common-size income statement with revenue from operations as 100.
- Prepare a common-size balance sheet with the balance sheet total as 100.
- Calculate trend percentages with the first year as base and interpret them.
A large company and a small one cannot be compared in rupees, but they can be compared in percentages. Common-size statements turn every item into a share of a base, and trend analysis turns several years into percentages of one base year.
Common-size statements
A common-size statement has three columns: particulars, absolute amount, and percentage of the common base. In a common-size income statement, revenue from operations is taken as 100. In a common-size balance sheet, the total of assets (or total of equity and liabilities) is taken as 100. They can be compared with previous years, or with similar businesses using similar accounting policies.
Common-size percentage = Item ÷ Common base × 100.
Worked example 1: common-size income statement
| Particulars | Amount ₹ | % of revenue from operations |
|---|---|---|
| Revenue from operations | 8,00,000 | 100 |
| Add: Other income | 40,000 | 5 |
| Total revenue | 8,40,000 | 105 |
| Less: Expenses | 5,60,000 | 70 |
| Profit before tax | 2,80,000 | 35 |
| Less: Income tax (30%) | 84,000 | 10.5 |
| Profit after tax | 1,96,000 | 24.5 |
The company and all figures in this example are made up for practice. Working: 40,000 ÷ 8,00,000 × 100 = 5; 5,60,000 ÷ 8,00,000 × 100 = 70; profit before tax 8,40,000 − 5,60,000 = 2,80,000 → 35; tax 2,80,000 × 30% = 84,000 → 10.5; profit after tax 2,80,000 − 84,000 = 1,96,000 → 24.5. Check: 105 − 70 = 35 and 35 − 10.5 = 24.5. Note that total revenue can exceed 100 because the base is revenue from operations, not total revenue.
Worked example 2: common-size balance sheet
| Particulars | Amount ₹ | % of total |
|---|---|---|
| Shareholders' funds | 6,00,000 | 40 |
| Non-current liabilities | 4,50,000 | 30 |
| Current liabilities | 4,50,000 | 30 |
| Total equity and liabilities | 15,00,000 | 100 |
| Non-current assets | 10,50,000 | 70 |
| Current assets | 4,50,000 | 30 |
| Total assets | 15,00,000 | 100 |
Working: 6,00,000 ÷ 15,00,000 × 100 = 40; 4,50,000 ÷ 15,00,000 × 100 = 30; 10,50,000 ÷ 15,00,000 × 100 = 70. Each side adds to 100. Reading it: 70% of the funds are tied up in non-current assets, and owners supply 40% of the total funds.
Trend analysis
Trend is the tendency of movement; it may be increasing, decreasing or irregular. When data for more than two years must be studied, comparative statements become clumsy, so trend analysis is used. Steps: (i) take the earliest year as the base; (ii) take its figures as 100; (iii) express each later year's figure as a percentage of the base.
Trend percentage = Current year figure ÷ Base year figure × 100.
Worked example 3: trend percentages
| Particulars (₹ in lakhs) | Year 1 | Year 2 | Year 3 | Trend Y1 | Trend Y2 | Trend Y3 |
|---|---|---|---|---|---|---|
| Revenue from operations | 200 | 240 | 280 | 100 | 120 | 140 |
| Add: Other income | 50 | 35 | 70 | 100 | 70 | 140 |
| Total revenue | 250 | 275 | 350 | 100 | 110 | 140 |
| Less: Expenses | 150 | 180 | 210 | 100 | 120 | 140 |
| Profit | 100 | 95 | 140 | 100 | 95 | 140 |
The company and all figures in this example are made up for practice. Working: 240 ÷ 200 × 100 = 120; 35 ÷ 50 × 100 = 70; 275 ÷ 250 × 100 = 110; 180 ÷ 150 × 100 = 120; profit 275 − 180 = 95 → 95 ÷ 100 × 100 = 95; Year 3: 280 ÷ 200 = 140, 70 ÷ 50 = 140, 350 ÷ 250 = 140, 210 ÷ 150 = 140, profit 140. Reading it: in Year 2 expenses (120) rose faster than total revenue (110), so profit dipped to 95; in Year 3 everything moved together and profit reached 140.
Common-size statement and trend analysis
-
Common-size statement
- One period at a time (vertical)
- Base: revenue from operations or balance sheet total
- Compares structure across firms or years
-
Trend analysis
- Several years (horizontal)
- Base: the earliest year = 100
- Shows direction of movement
Key takeaways: common-size statements show structure as percentages of one base; trend percentages show movement against a base year. Work out every total separately, then its percentage.
Check your understanding
-
1. In a common-size income statement, the item taken as 100 is
- total revenue
- profit before tax
- total expenses
- revenue from operations
Show answer
Answer: D. The textbook takes revenue from operations (net sales) as 100 in a common-size income statement. That is why total revenue can be more than 100.
-
2. In a common-size balance sheet, non-current assets are 64%. Current assets are
- 36%
- 164%
- 64%
- 100%
Show answer
Answer: A. Total assets = 100%, so current assets = 100 − 64 = 36%.
-
3. Expenses were ₹1,20,000 in the base year and ₹1,38,000 in the next year. The trend percentage for the next year is
- 15%
- 87%
- 115%
- 118%
Show answer
Answer: C. Trend % = 1,38,000 ÷ 1,20,000 × 100 = 115. The 15% is the increase, not the trend percentage.
-
4. Revenue from operations is ₹5,00,000, other income ₹25,000 and expenses ₹3,60,000. In a common-size income statement, profit before tax is
- 28%
- 33%
- 31.4%
- 35%
Show answer
Answer: B. Profit before tax = 5,00,000 + 25,000 − 3,60,000 = 1,65,000. Percentage = 1,65,000 ÷ 5,00,000 × 100 = 33%. Dividing by total revenue (5,25,000) gives 31.4%, which uses the wrong base.
-
5. Trend analysis is preferred to comparative statements when
- only one year's data is available
- a firm is compared with another firm in the same year
- data for more than two years is to be analysed
- only the balance sheet is available
Show answer
Answer: C. The textbook says comparative statements become difficult when data for more than two years is analysed, so trend analysis is used.
Sign in to keep track of the lessons you finish.