Financial Reporting · Calculation and interpretation of accounting ratios and trends to address users' and stakeholders' needs

Trend, Common-Size and Horizontal Analysis for ACCA FR

Updated 11 October 2026 · Fact-checked

Horizontal (trend) analysis measures the percentage change in each line item over time. Common-size (vertical) analysis expresses each line as a percentage of a base, such as revenue or total assets. You then compare the results across years or against other entities, and explain the causes and what they mean for users.

Understand Trend, Common-Size and Horizontal Analysis

Raw figures are hard to judge. Revenue of $5 million means little until you know last year's figure or a competitor's. Trend and common-size analysis turn raw figures into percentages so you can see what has changed and what matters.

Horizontal analysis looks across time. You take each line item and measure how much it moved from one year to the next. A 20% rise in revenue with a 35% rise in cost of sales tells you margins are under pressure, even before you calculate a single ratio.

Common-size analysis (also called vertical analysis) looks down one statement for one year. In the statement of profit or loss you set revenue at 100% and show every line as a percentage of revenue. In the statement of financial position you usually set total assets at 100%. This lets you compare entities of different sizes, or the same entity over several years, on equal terms.

Benchmarking compares the entity with something else: a competitor, an industry average, a group member or a budget. Differences may be real performance gaps. They may also come from different accounting policies, year-ends, business models or size, so you must check comparability before drawing conclusions.

In the exam, the numbers are only the start. Marks go for identifying the significant movements, giving likely reasons based on the scenario, and linking them to the needs of the user, such as an investor, lender or manager.

Key rules to remember

Percentage change (horizontal analysis): Change % = (Current year − Prior year) ÷ Prior year × 100; Always divide by the earlier year (the base). A negative result is a fall.
Trend index: Index = Year figure ÷ Base year figure × 100; Base year is set at 100. An index of 125 means 25% above the base year.
Common-size statement of profit or loss: Line item % = Line item ÷ Revenue × 100; Revenue is 100%. Gross and operating margins appear as the subtotals.
Common-size statement of financial position: Line item % = Line item ÷ Total assets × 100; Total assets equals total equity and liabilities, so both sides add to 100%.
Percentage point change: Point change = Current % − Prior %; Use this for changes in common-size percentages. Do not call a move from 40% to 45% a 5% rise.

How to solve Trend, Common-Size and Horizontal Analysis questions

Use this method for any question asking you to analyse movements, compare periods or benchmark against other entities.

1Read the requirement and identify the user (investor, lender, management) and what they need to decide.
2Choose the right tool: percentage changes for movement over time, common-size for structure and comparability, benchmark for comparison with others.
3Pick a consistent base: the prior year for changes, revenue for the profit or loss, total assets for the statement of financial position.
4Calculate the percentages for the key lines only. Round sensibly, usually to one decimal place.
5Flag the significant movements: large changes, items growing faster than revenue, and shifts in the mix of costs or assets.
6Explain each point using the scenario: possible causes such as price cuts, new debt, acquisitions, disposals, or changes in policy.
7Check comparability when benchmarking: size, year-end, accounting policies, business mix, one-off items.
8Conclude for the user: state what the analysis suggests and what further information you would want.

Quickest way: Revenue-anchor shortcut

When to use it: Use it when time is short and you must spot the story in a set of figures, especially in Section B cases.

Compute only the revenue change first. This is your yardstick.
Compare the change in cost of sales, expenses, receivables and inventory with the revenue change.
Any line moving much faster or slower than revenue is a signal. Examine only those lines.
For benchmarking, compare just the gross margin, operating margin and one working capital or gearing figure.
Write the signals down in order of size, then give one cause and one consequence for each.

Common mistakes in Trend, Common-Size and Horizontal Analysis

Dividing the change by the current year instead of the prior year.
Students divide by the figure nearest to hand or the one in the first column.
Fix: Always use the earlier year as the base. Write the formula at the top of your working.
Describing a change in a common-size percentage as a percentage change.
Percentages of percentages are easy to confuse.
Fix: Say percentage points for differences between two common-size percentages.
Listing the numbers without explaining them.
Calculation feels safe, and commentary feels vague.
Fix: For each key movement, give a cause from the scenario and a consequence for the user.
Treating a benchmark as a target that must be met.
Industry averages look authoritative.
Fix: State that averages mix different business models and policies. Say the gap needs investigation rather than automatically showing weakness.
Using the wrong base in a common-size statement of financial position.
Students copy the profit or loss approach and use revenue.
Fix: Use total assets as 100% so that the statement of financial position balances at 100% on both sides.
Ignoring one-off items and inflation when judging trends.
Students take the figures at face value.
Fix: Check for disposals, impairments, acquisitions and price inflation. Comment that a rise may be partly price-driven or non-recurring.

Worked examples

Example 1

Entity A reports revenue of $800,000 (prior year $640,000), cost of sales of $520,000 (prior year $448,000) and receivables of $160,000 (prior year $96,000). Calculate the percentage changes and comment.

Show the solution

Revenue change = (800,000 − 640,000) ÷ 640,000 × 100 = 160,000 ÷ 640,000 × 100 = 25.0%.
Cost of sales change = (520,000 − 448,000) ÷ 448,000 × 100 = 72,000 ÷ 448,000 × 100 = 16.1% (to one decimal place).
Receivables change = (160,000 − 96,000) ÷ 96,000 × 100 = 64,000 ÷ 96,000 × 100 = 66.7%.
Gross profit: current 800,000 − 520,000 = 280,000; prior 640,000 − 448,000 = 192,000. Change = 88,000 ÷ 192,000 × 100 = 45.8%.
Comment: cost of sales grew more slowly than revenue, so gross margin improved (from 30.0% to 35.0%). Receivables grew much faster than revenue, which suggests slacker credit control or more generous credit terms used to win sales. This raises cash flow and bad debt risk.

Answer: Revenue +25.0%, cost of sales +16.1%, receivables +66.7%, gross profit +45.8%. Margin improved, but receivables are growing far faster than revenue and need investigation.

Example 2

Extracts from the statements of profit or loss for the year: Entity X has revenue $500,000, cost of sales $350,000, distribution costs $40,000 and administrative expenses $60,000. The industry average shows cost of sales 62%, distribution costs 5% and administrative expenses 15% of revenue. Prepare a common-size comparison and comment.

Show the solution

Cost of sales = 350,000 ÷ 500,000 × 100 = 70.0%.
Gross profit = 500,000 − 350,000 = 150,000, which is 30.0% of revenue.
Distribution costs = 40,000 ÷ 500,000 × 100 = 8.0%.
Administrative expenses = 60,000 ÷ 500,000 × 100 = 12.0%.
Operating profit = 150,000 − 40,000 − 60,000 = 50,000, which is 10.0% of revenue. The industry average gives 100 − 62 − 5 − 15 = 18%.
Compare: cost of sales is 8 percentage points above average (70% vs 62%). Distribution is 3 points higher. Administration is 3 points lower.
Comment: the main weakness is direct cost, possibly due to lower selling prices, higher input costs or an inefficient product mix. Higher distribution costs may reflect a wider delivery network. Low administration costs are a strength but may reflect different cost classification. The gap of 8 percentage points in operating margin should be investigated before conclusions are drawn.

Answer: Entity X: cost of sales 70.0%, distribution 8.0%, administration 12.0%, operating margin 10.0%, against industry 62%, 5%, 15% and 18%. The operating margin is 8 percentage points below average, driven mainly by cost of sales.

Exam tips

In Section C, set out a short table of percentages, then write commentary. Commentary usually earns more marks than the calculation.
In Section B cases, the objective test often asks for one percentage change or common-size figure. Check the base and the rounding instruction.
Relate every point to the user named in the question. A lender wants to hear about cash and risk. An investor wants to hear about returns and growth.
Always mention a comparability caveat when benchmarking, such as different accounting policies or year-ends.
Compare movements with revenue growth rather than commenting on each line in isolation.

Practice questions from Calculation and interpretation of accounting ratios and trends to address users' and stakeholders' needs

Trend, Common-Size and Horizontal Analysis in other exams

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

Trend, Common-Size and Horizontal Analysis: frequently asked questions

What is the difference between horizontal and vertical analysis?

Horizontal analysis compares the same line item across periods and shows the percentage change. Vertical analysis, or common-size analysis, expresses each line as a percentage of a base within one period. Use horizontal for trends and vertical for structure and comparison between entities.

What base do I use for a common-size statement of financial position?

Use total assets as 100%. Each asset, liability and equity line is then shown as a percentage of total assets. Total equity and liabilities will also equal 100%.

How do I compare ratios with industry averages in the exam?

Calculate the entity's figures and set them beside the benchmark. State the gap, give likely causes from the scenario, and note limits such as different business mix, policies and year-ends. Avoid treating the average as the correct answer.

Do I need to calculate every line in a trend analysis?

No. Calculate the key lines, such as revenue, cost of sales, profit, receivables, inventory, payables and borrowings. Time is limited, so concentrate on the items that tell the story for the user in the question.