Horizontal, vertical and trend analysis in QCE Accounting Unit 4
“Apply horizontal, vertical and trend analysis to financial statements to identify changes and relationships, and interpret the results to support decision-making”
Horizontal analysis measures change between periods, both in dollars and as a percentage of the earlier figure, so a $20,000 sales rise from $200,000 is a 10 percent increase. Vertical analysis (common-size analysis) expresses every item as a percentage of a base in the same statement: in the income statement the base is usually net sales, in the balance sheet it is usually total assets. This shows structure, such as cost of goods sold being 60 percent of sales. Trend analysis picks a base year as 100 and indexes later years to it, revealing direction over time. None of these techniques is conclusive alone; their value is in prompting questions and being interpreted alongside the ratios to justify a decision.
Jump to a section
Check against your course. The 2025 QCAA Accounting syllabus describes Unit 4 as the complete accounting processes for a trading GST business and the performance analysis of a public company, with ratios that include EBITDA, earnings per share, price earnings, dividend yield and cash flow ratios. This page covers part of that ground, so check your school's materials for the full list of what is assessed.
What this dot point is asking
QCAA wants you to analyse financial statements across more than one dimension, not just compute a single ratio. Horizontal analysis compares the same item across two or more periods to show how much it changed. Vertical analysis expresses each item as a percentage of a base figure within one statement, showing its relative size. Trend analysis tracks an item across several periods against a base year to reveal the direction it is moving. Together these techniques turn raw dollar figures into a story about the business, and you must interpret that story to support a decision.
Horizontal analysis
Horizontal analysis compares a line item across periods. You calculate the dollar change (this year minus last year) and the percentage change (dollar change divided by the earlier year, times 100). It answers "how much has this moved and is the movement material?" A small dollar change on a large base may be trivial, while a large percentage change on a small base may be noise. The technique is most useful for spotting items growing or shrinking out of step with the rest of the business, such as expenses rising faster than sales.
Vertical analysis
Vertical (common-size) analysis expresses each item as a percentage of a base within the same statement and period. In the income statement the base is net sales, so cost of goods sold, gross profit and each expense are shown as a percentage of sales. In the balance sheet the base is total assets, so each asset, liability and equity item is shown as a percentage of the total. This standardises the statement, making it possible to compare a business with a larger or smaller competitor, or with itself across years, because the size effect is removed. A rising cost of goods sold percentage, for example, signals margin pressure regardless of how big the business is.
Trend analysis
Trend analysis extends horizontal analysis across several periods. One year is chosen as the base and set to an index of 100; each later year's figure is expressed as a percentage of the base year. A sales trend of 100, 108, 121 shows steady growth, while an expense trend of 100, 115, 134 growing faster than sales warns of eroding profitability. Trend analysis reveals direction and momentum that a two-year comparison can miss, and it is especially powerful when the same base year is used across several related items so their paths can be compared.
Interpreting the results
Analysis is only as good as the interpretation. A change must be explained, not just stated. The techniques work best together: horizontal analysis flags what changed, vertical analysis shows whether the change matters relative to size, and trend analysis shows whether it is a one-off or a pattern. The decision-making marks come from synthesising these into a justified recommendation, while acknowledging limits such as inflation, accounting policy changes and one-off events.
The data
Reefline Ltd reports net sales of $200,000 (Year 1) and $230,000 (Year 2); cost of goods sold of $120,000 (Year 1) and $147,200 (Year 2); and a Year 3 sales figure of $253,000.
Horizontal analysis (Year 1 to Year 2)
| Item | Year 1 | Year 2 | $ change | % change |
|---|---|---|---|---|
| Net sales | 200,000 | 230,000 | 30,000 | 15.0% |
| Cost of goods sold | 120,000 | 147,200 | 27,200 | 22.7% |
Sales rose 15 percent but cost of goods sold rose 22.7 percent, so costs grew faster than sales, a warning sign.
Vertical analysis (cost of goods sold as a percentage of net sales)
| Item | Year 1 | Year 2 |
|---|---|---|
| Net sales | 100.0% | 100.0% |
| Cost of goods sold | 60.0% | 64.0% |
Cost of goods sold climbed from 60 percent to 64 percent of sales, confirming that the gross profit margin is shrinking even though total sales grew.
Trend analysis (net sales, Year 1 = 100)
| Year | Sales | Index |
|---|---|---|
| Year 1 | 200,000 | 100 |
| Year 2 | 230,000 | 115 |
| Year 3 | 253,000 | 127 |
Sales show a clear upward trend (100, 115, 127). The story across all three views: sales are growing strongly, but rising cost of goods sold is squeezing the margin, so management should investigate supplier prices or selling prices before the margin erosion offsets the sales growth.
- Using the later year as the percentage-change base
- The percentage change divides the dollar change by the earlier (base) year figure, not the current year.
- Choosing the wrong vertical base
- Income statement items are a percentage of net sales; balance sheet items are a percentage of total assets. Mixing the bases makes the percentages meaningless.
- Stating changes without interpreting them
- Calculating a 22.7 percent rise earns little on its own; explaining what it means for profitability is where the marks are.
- Ignoring distortions
- Inflation, policy changes and one-off items can exaggerate or hide trends, so conclusions should be qualified rather than absolute.
Exam-style questions
Questions in the style of QCAA exam questions on this dot point, each with a worked answer. They are written by ExamExplained unless tagged "Past paper"; the year shows the paper a question is modelled on.
Practice10 marksRead Case study 3 (Stimulus 5 to 6) in the stimulus book. Use horizontal analysis to analyse and evaluate the financial data and information. Make recommendations to the board of directors about whether they should progress with the expansion. [XYZ Catering Company, comparative 2023 and 2024 statements with a Difference column. Revenue from operations rose from $669 717 to $678 811; profit attributable to members fell from $62 707 to $59 173; return on equity fell from 18.2% to 16.2%.]Show worked answer →
Horizontal analysis expresses the dollar change between two years as a percentage of the earlier (base) year: change / base year x 100.
Work the key lines:
- Revenue from operations: 9 094 / 669 717 x 100 = +1.36%, a small increase.
- Profit attributable to members: -3 534 / 62 707 x 100 = -5.64%, a fall.
- Total comprehensive income: -6 256 / 61 044 x 100 = -10.25%, a larger fall, worsened by foreign currency translation losses.
Evaluation: although revenue grew slightly, profit fell, so expenses grew faster than revenue (employee benefits and other expenses both rose). Return on equity also declined from 18.2% to 16.2%, confirming the business became less profitable for its owners despite higher revenue.
Recommendation: the board should be cautious about progressing with the expansion. The current trend shows the existing operations are already converting revenue growth into lower profit, so adding a new equipment-sales division would need a clear plan to control costs first. A justified answer recommends either delaying expansion until margins recover, or proceeding only with strict cost controls and monitoring. Markers reward correct percentage changes, interpreting that profit fell while revenue rose, and a recommendation that follows from the analysis.
Practice12 marksUsing Stimulus 4, trend analysis and two relevant ratios, analyse and interpret the stability of The Supermarket Company across the four years. Show your working for the ratio calculations. [The Supermarket Company, comparative Statements of Financial Position for 2020 to 2023, with total equity, total liabilities and total assets given, plus a gearing ratio of 13%, 20%, 22% and 28% across the four years.]Show worked answer →
Use trend analysis (set a base year at 100 and index later years) together with two stability ratios, showing working.
Equity ratio = total equity / total assets x 100:
- 2020 = 215 108 / 393 884 = 54.61%; 2021 = 195 415 / 395 720 = 49.38%; 2022 = 261 502 / 519 107 = 50.38%; 2023 = 239 807 / 490 372 = 48.90%.
Debt to equity = total liabilities / total equity:
- 2020 = 178 776 / 215 108 = 0.83; 2021 = 1.03; 2022 = 0.99; 2023 = 250 565 / 239 807 = 1.04.
Trend analysis of total liabilities (2020 = 100): 2020 = 100, 2021 = 112, 2022 = 144, 2023 = 140 - liabilities have grown faster than the equity base over the period.
Interpretation: the equity ratio has fallen from 54.61% to 48.90%, debt to equity has risen from 0.83 to 1.04, and the gearing ratio has climbed steadily from 13% to 28%. All three measures point the same way: the company is progressively more reliant on debt, so its long-term stability has weakened across the four years and financial risk has increased. Markers reward correct calculations shown as working, a genuine four-year trend, and an interpretation that links the rising debt to reduced stability.