• 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

Common-size income statement of Selvam Ltd (made-up figures)
ParticularsAmount ₹% of revenue from operations
Revenue from operations8,00,000100
Add: Other income40,0005
Total revenue8,40,000105
Less: Expenses5,60,00070
Profit before tax2,80,00035
Less: Income tax (30%)84,00010.5
Profit after tax1,96,00024.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

Common-size balance sheet of Selvam Ltd (made-up figures)
ParticularsAmount ₹% of total
Shareholders' funds6,00,00040
Non-current liabilities4,50,00030
Current liabilities4,50,00030
Total equity and liabilities15,00,000100
Non-current assets10,50,00070
Current assets4,50,00030
Total assets15,00,000100

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

Trend analysis of Vaanavil Ltd (made-up figures)
Particulars (₹ in lakhs)Year 1Year 2Year 3Trend Y1Trend Y2Trend Y3
Revenue from operations200240280100120140
Add: Other income50357010070140
Total revenue250275350100110140
Less: Expenses150180210100120140
Profit1009514010095140

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. 1. In a common-size income statement, the item taken as 100 is

    1. total revenue
    2. profit before tax
    3. total expenses
    4. 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. 2. In a common-size balance sheet, non-current assets are 64%. Current assets are

    1. 36%
    2. 164%
    3. 64%
    4. 100%
    Show answer

    Answer: A. Total assets = 100%, so current assets = 100 − 64 = 36%.

  3. 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

    1. 15%
    2. 87%
    3. 115%
    4. 118%
    Show answer

    Answer: C. Trend % = 1,38,000 ÷ 1,20,000 × 100 = 115. The 15% is the increase, not the trend percentage.

  4. 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

    1. 28%
    2. 33%
    3. 31.4%
    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. 5. Trend analysis is preferred to comparative statements when

    1. only one year's data is available
    2. a firm is compared with another firm in the same year
    3. data for more than two years is to be analysed
    4. 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.

Privacy · Terms · Refunds · Delivery