What it means
The simple version takes the last few values, adds them and divides by how many there are. Choosing that number, the window, is the only real decision: a short window reacts quickly but stays jumpy, while a long window is smooth but slow to show a genuine turning point.
Business reporting leans on it because raw monthly figures are noisy for reasons that have nothing to do with performance. Bank holidays, a large order landing on the first rather than the last day of a month, and simple seasonality all create swings that a three or twelve month rolling average quietly irons out.
A weighted or exponential variant gives recent periods more influence than older ones. That responds faster to real change and is preferred when the series is expected to shift, such as monthly demand for a product that has just been repriced.
The main limitation is lag. Because it looks only backwards, a moving average always confirms a turn after it has happened, so it is a description of what has occurred rather than a forecast of what comes next.
A twelve month moving average has a particularly useful property for seasonal businesses: it contains every month of the year exactly once, so seasonality cancels out entirely. Plotting it alongside the raw monthly line is one of the quickest ways to show a board whether the business is genuinely growing.
In practice
Real-world examples.
Example
A garden centre reports revenue on a twelve month rolling average because its raw sales quadruple between February and May. The smoothed line shows steady 6% annual growth that is invisible in the monthly chart, which had previously led the owners to assume the business was shrinking every autumn.
Example
A logistics firm forecasts weekly fuel spend with a four week moving average, which absorbs the effect of one unusually heavy delivery week. The result is a stable number the finance team can accrue against, and month end adjustments have fallen sharply since the change.
Example
An investor watches a share price cross above its 200 day moving average and treats it as a signal that the downtrend has ended. She is aware the signal arrives well after the low point, so she treats it as confirmation of a change already under way rather than a prediction of what happens next.
Think of it
“Moving average is smoothed price trend-average of recent prices.
Formula
Calculation
Simple moving average = (sum of the values in the last n periods) / n
A software company records revenue of $120,000, $135,000, $128,000, $142,000 and $150,000 over five consecutive months. The five month moving average = ($120,000 + $135,000 + $128,000 + $142,000 + $150,000) / 5 = $675,000 / 5 = $135,000.
When month six comes in at $160,000, the oldest figure drops out of the window. The new average = ($135,000 + $128,000 + $142,000 + $150,000 + $160,000) / 5 = $715,000 / 5 = $143,000. The average has risen by $8,000 while the raw monthly figure jumped by $10,000, showing how the calculation dampens a single month's move while still tracking the direction of travel.Case study
Seen in the real world.
What follows is an illustrative and clearly fictional story. Fernbank Interiors, an invented furniture retailer, ran monthly board meetings that swung between celebration and crisis depending entirely on which way the latest month had gone. Two directors had spent a year arguing about whether the business was growing, using the same figures to support opposite conclusions.
A newly appointed finance manager rebuilt the pack with a single change, adding a twelve month moving average line to every revenue and margin chart. The smoothed picture showed revenue growing at about 4% a year and gross margin drifting down by roughly one percentage point annually, a slow erosion nobody had spotted amid the monthly drama.
With the argument settled, Fernbank's fictional board could turn to the real issue, which was pricing rather than demand. Meetings shortened noticeably once the monthly swings stopped being treated as news.
Watch out
Common mistakes.
- Picking a window length to make the chart look encouraging rather than choosing it once and applying it consistently.
- Treating a moving average as a forecast, when by construction it can only describe what has already happened.
- Using a short window on a strongly seasonal series, which leaves the seasonal pattern in place and produces misleading turning points.
Questions
People also ask.
How long should the window be?
Match it to the cycle you want removed, so twelve months for seasonality, seven days for weekday effects, and three months for general reporting noise.
What is the difference between a simple and an exponential moving average?
A simple average treats every period in the window equally, while an exponential one weights recent periods more heavily and therefore reacts faster.
Does a moving average work on any metric?
It works on anything measured repeatedly over time, including cash balances, headcount, conversion rates and complaint volumes, not just revenue.
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%Related