How can the financial statements of a business be analysed over time and in relative terms to reveal the story behind the dollar figures?
Apply horizontal, vertical and trend analysis to financial statements to identify changes and relationships, and interpret the results to support decision-making
A worked QCE Accounting Unit 4 answer on analysing financial statements beyond single ratios. Covers horizontal analysis of dollar and percentage changes between periods, vertical analysis expressing items as a percentage of a base, trend analysis using a base year, and interpreting the results to support business decisions.
Reviewed by: AI editorial process; not yet individually human-reviewed
Have a quick question? Jump to the Q&A page
Jump to a section
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.
Exam-style practice questions
Practice questions written in the style of QCAA exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.
2024 QCAA10 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 678 811; profit attributable to members fell from 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.
2023 QCAA12 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.