What it means
A single year's revenue tells you very little on its own. Five years of revenue tells you whether the business is growing, flat or shrinking, and whether the growth is accelerating or quietly fading.
The most common presentation is an indexed series, where the base year is set to 100 and each later year is scaled against it. An index of 150 in year four means revenue is 50% above the base year, which is far easier to read at a glance than four separate dollar amounts.
Trend analysis becomes much more useful when two related lines are compared. Revenue rising 25% while cost of sales rises 40% tells a story about margin erosion that neither line reveals alone, and the same technique applied to receivables against revenue can flag deteriorating collections.
It is used in budgeting, credit assessment, investor reporting and audit planning. Auditors in particular use it to spot balances that moved in an unexpected direction or by an unexpected amount, which then receive closer testing.
The main trap is treating a trend as a forecast. Extending a straight line into the future ignores capacity limits, market saturation and the base effect, where a strong prior year makes the next year's growth look weak even when trading is perfectly healthy.
Choice of base period matters more than most people expect. If the base year happened to include a strike, a pandemic disruption or an exceptional contract, every index number that follows carries that distortion, which is why analysts often show two versions using different starting points.
In practice
Real-world examples.
Example
A subscription software company indexes revenue and support costs from the same base year. Revenue reaches an index of 150 while support costs reach 190, prompting an investigation that finds most of the extra cost sits with one poorly onboarded customer segment.
Example
An auditor reviews five years of inventory balances against cost of sales before planning fieldwork. Inventory has grown far faster than sales volumes, so the team allocates extra time to testing for obsolete stock.
Example
A credit analyst assessing a loan application charts four years of operating cash flow. The trend is upward but flattening, so the bank sets the loan term and covenant headroom against the flattening pattern rather than the average growth rate.
Think of it
“Trend analysis is like tracking your running pace over months of training. You're looking for patterns-are you getting faster or slowing down?
Formula
Calculation
Trend Index = (Value in Current Period / Value in Base Period) x 100
A specialist retailer records revenue of $12,000,000 in 2021, $13,800,000 in 2022, $15,600,000 in 2023 and $18,000,000 in 2024. Setting 2021 as the base year of 100:
2022 index = ($13,800,000 / $12,000,000) x 100 = 115
2023 index = ($15,600,000 / $12,000,000) x 100 = 130
2024 index = ($18,000,000 / $12,000,000) x 100 = 150
By 2024 revenue is 50% above the base year. Year on year growth was 15.0% in 2022, 13.0% in 2023 and 15.4% in 2024, so the underlying pace is steady rather than accelerating, even though the dollar increases get larger each year. That distinction between a rising index and a rising growth rate is the single most useful thing trend analysis makes visible.Case study
Seen in the real world.
Larkfield Home is a fictional specialist retailer used here as an illustrative example. Its board reviewed revenue of $12,000,000, $13,800,000, $15,600,000 and $18,000,000 across four years and concluded that growth was accelerating, because each year added more dollars than the one before.
The finance director rebuilt the same figures as an index on a base of 100, giving 100, 115, 130 and 150. Expressed as growth rates, the years came out at 15.0%, 13.0% and 15.4%, which was steady rather than accelerating. She then indexed store count over the same period and found it had grown faster than revenue, meaning average revenue per store had actually slipped.
In this illustrative case the trend analysis changed the plan. Instead of approving twelve new stores on the assumption of accelerating demand, the board approved four and funded a refit programme for the weakest existing sites.
The finance director kept the indexed view in the monthly board pack afterwards, adding gross margin and stock levels to the same base year. Within two reporting cycles the pattern of margin slipping slightly ahead of every store opening was obvious enough that the expansion pace became a standing agenda item.
Watch out
Common mistakes.
- Choosing a base year that was unusually good or unusually bad, which makes every later index number misleading.
- Analysing one line in isolation, when the insight almost always comes from comparing two related lines over the same periods.
- Projecting a historical trend forward as if it were a forecast, without asking what actually drove the pattern.
Questions
People also ask.
How many periods do I need?
Three is the practical minimum to see a direction, and five or more gives a much more reliable picture through a business cycle.
Should figures be adjusted for inflation?
For long periods, yes; a nominal revenue index of 130 over ten years may represent flat or falling volumes once price rises are stripped out.
How does trend analysis differ from vertical analysis?
Trend analysis compares one figure across time, while vertical analysis expresses each line as a percentage of a total such as revenue within a single period.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%