Corporate Accounting and Financial Management · Financial Statement Analysis

Common Size Statements and Trend Analysis Explained

Updated 11 October 2026 · Fact-checked

A common size statement shows each item as a percentage of one base figure, such as net sales or total assets. Trend analysis shows each item as a percentage of the same item in a base year. To solve questions, pick the correct base, divide, multiply by 100, then comment.

Understand Common Size Statements and Trend Analysis

Raw rupee figures are hard to compare. A company with sales of ₹50 crore and one with ₹5 crore cannot be judged by profit alone. Converting figures into percentages makes them comparable across years and across companies.

A common size statement expresses every item in one statement as a percentage of a single base figure from that same statement. In a profit and loss statement the base is usually revenue from operations (net sales). In a balance sheet the base is total assets (equal to total equity and liabilities). The base itself is always 100%. This is also called vertical analysis, because you read down one column for one date.

Trend analysis (also called horizontal analysis) takes one year as the base year and sets each item in that year at 100. For every later year, the item is shown as a percentage of its base-year value. It shows whether sales, profit or borrowings are rising or falling over time. Each line item is compared only with itself.

A comparative statement is different. It places figures of two or more years side by side and shows the absolute change and the percentage change from the earlier year. Trend analysis uses one fixed base year for all years. A comparative statement compares each year with the year just before it.

The percentages are only a tool. The marks come from your comment. For example, if cost of materials moves from 55% to 62% of sales, say what it means: margins are under pressure.

Key rules to remember

Common size percentage: Common size % = (Item amount ÷ Base amount) × 100; Base is net sales for the profit and loss statement and total assets (or total equity and liabilities) for the balance sheet.
Trend percentage: Trend % = (Current year amount ÷ Base year amount) × 100; Base year is always 100. Use the same item in both numerator and denominator.
Absolute change in a comparative statement: Change = Current year amount − Previous year amount; Positive means increase, negative means decrease.
Percentage change in a comparative statement: % change = (Change ÷ Previous year amount) × 100; The denominator is the earlier year. If the earlier figure is zero, percentage change cannot be computed.
Increase over base year: Increase over base % = Trend % − 100; A trend figure of 125 means a 25% rise over the base year.

How to solve Common Size Statements and Trend Analysis questions

This method works for any question on common size statements or trend percentages.

1Read what is asked: common size, trend, or comparative. Note the years and the statement type.
2Choose the base. For common size, use net sales (profit and loss statement) or total assets (balance sheet). For trend, use the base year given, or the earliest year if none is stated.
3Draw a table with columns for the item, each year's amount and each year's percentage.
4Compute each percentage as item ÷ base × 100. Round to one or two decimal places and keep the same rounding throughout.
5Check totals. In a common size statement, the sub-totals and the total must add up to the base (100%), allowing for rounding.
6Write a short interpretation: which items grew faster than sales, which fell, and what that means for profitability, borrowing or liquidity.
7State the conclusion clearly in one or two lines.

Quickest way: Constant-multiplier shortcut

When to use it: Use when many items share one base, as in a full common size statement, and you have a calculator.

Compute 100 ÷ base once and store it in memory.
Multiply each item by that stored value to get its percentage directly.
For trend analysis, compute 100 ÷ base-year value separately for each row, then multiply each later year by it.
Add up the percentages of the components and confirm they reach the total's percentage before writing the table.

Common mistakes in Common Size Statements and Trend Analysis

Using total assets as the base for the profit and loss statement.
Students remember one base and apply it everywhere.
Fix: Profit and loss items use net sales. Balance sheet items use total assets. Write the base at the top of the table.
Computing trend percentage against the previous year instead of the base year.
Confusion with the comparative statement method.
Fix: In trend analysis, the denominator is always the fixed base year. Only the comparative statement uses the previous year.
Dividing a different item by the base-year figure.
Rows are misaligned in a rushed table.
Fix: Divide each item only by the same item's base-year amount. Check the row label before each calculation.
Leaving out interpretation.
Students treat the exercise as pure arithmetic.
Fix: Add two or three lines after the table stating what the changes show about cost control, borrowing or growth.
Totals not adding to 100% after rounding.
Inconsistent rounding or a missed item.
Fix: Round all items the same way. A difference of 0.1 from rounding is acceptable; a bigger gap means an error.
Treating a rising trend percentage as always good.
Assuming higher means better.
Fix: Judge by the item. Rising sales is favourable, but rising borrowings or expenses faster than sales may not be.

Worked examples

Example 1

The profit and loss data of Sundaram Textiles Ltd for the year are: Revenue from operations ₹8,00,000; Cost of materials consumed ₹4,40,000; Employee benefit expenses ₹1,20,000; Other expenses ₹80,000; Income tax ₹40,000. Prepare a common size statement and find profit after tax.

Show the solution

Base is revenue from operations = ₹8,00,000 (100%).
Cost of materials: 4,40,000 ÷ 8,00,000 × 100 = 55%.
Employee benefit expenses: 1,20,000 ÷ 8,00,000 × 100 = 15%.
Other expenses: 80,000 ÷ 8,00,000 × 100 = 10%.
Total expenses before tax = 4,40,000 + 1,20,000 + 80,000 = ₹6,40,000 = 80%.
Profit before tax = 8,00,000 − 6,40,000 = ₹1,60,000 = 20%.
Income tax: 40,000 ÷ 8,00,000 × 100 = 5%.
Profit after tax = 1,60,000 − 40,000 = ₹1,20,000 = 15%.

Answer: Common size: revenue 100%, materials 55%, employee costs 15%, other expenses 10%, profit before tax 20%, tax 5%, profit after tax 15% (₹1,20,000). Materials form the largest cost, so margin depends on material cost control.

Example 2

Net sales and net profit of Kaveri Ltd for four years are: 2022-23 ₹5,00,000 and ₹50,000; 2023-24 ₹6,00,000 and ₹66,000; 2024-25 ₹7,50,000 and ₹75,000; 2025-26 ₹9,00,000 and ₹1,00,000. Calculate trend percentages taking 2022-23 as base year and comment.

Show the solution

Sales trend: 2022-23 = 100.
2023-24: 6,00,000 ÷ 5,00,000 × 100 = 120.
2024-25: 7,50,000 ÷ 5,00,000 × 100 = 150.
2025-26: 9,00,000 ÷ 5,00,000 × 100 = 180.
Profit trend: 2022-23 = 100.
2023-24: 66,000 ÷ 50,000 × 100 = 132.
2024-25: 75,000 ÷ 50,000 × 100 = 150.
2025-26: 1,00,000 ÷ 50,000 × 100 = 200.
Compare: profit trend is above sales trend in 2023-24 and 2025-26, and equal to it in 2024-25 (both 150). The equal index in 2024-25 hides a year-on-year fall in margin: profit grew from ₹66,000 to ₹75,000, which is 13.6%, while sales grew by 25%. Profit margin was 10% in 2022-23, 11% in 2023-24, 10% in 2024-25 and 11.1% in 2025-26.

Answer: Sales trend: 100, 120, 150, 180. Profit trend: 100, 132, 150, 200. Sales have risen by 80% and profit has doubled over the base year, so profit margin has improved overall (10% to 11.1%). In 2024-25 the trend index of profit equals that of sales (150), but year-on-year profit grew 13.6% against sales growth of 25%, so margin fell from 11% to 10% that year.

Exam tips

Write the base figure and the formula before the table. It shows method even if arithmetic slips.
Always add a short comment after the table. Questions often ask you to interpret, and comment carries marks.
If the question gives no base year, take the earliest year and state that assumption.
Do not mix up the terms: common size is vertical within one year, trend is horizontal against a base year, comparative is year-on-year.
Keep a neat table with items in rows and years in columns so each percentage is easy to check.

Practice questions from Financial Statement Analysis

Common Size Statements and Trend Analysis in other exams

The same ground in other exams, if you are preparing for more than one or want another angle on it.

Common Size Statements and Trend Analysis: frequently asked questions

What is the difference between common size and comparative statements?

A common size statement converts each item in one year into a percentage of a base such as net sales or total assets. A comparative statement places two or more years side by side and shows the change in amount and percentage. Common size is vertical, comparative is horizontal.

How do you calculate trend percentages?

Choose a base year and set each item in that year at 100. For every later year, divide that year's amount by the base-year amount for the same item and multiply by 100. A result of 130 means a 30% rise over the base year.

What base do you use in a common size balance sheet?

Use total assets, which equals total equity and liabilities. Express every asset, equity and liability item as a percentage of this total. The total on each side is 100%.

Is the paper objective or written?

CS Executive papers are descriptive written papers. You must show the table, the working and a short interpretation. There are no MCQs.