SIXIS STRATEGY INTELLIGENCE SERIES
The MAT Advantage
Why Moving Annual Totals Are the Most Important Management Measure Your Business Is Probably Not Using
A SIXiS Strategy Intelligence Briefing | Updated June 2026
THE INSIGHT
“A monthly sales number tells you what happened last month. A Moving Annual Total tells you whether your business is genuinely growing — or whether you have been misled by seasonal noise for years.”
The Problem with the Measures You're Already Using
If your management reporting relies on monthly sales, year to-date comparisons, and same-period-last-year (SPLY) figures, you are not seeing your business clearly. Each of these measures is useful — and each carries a structural flaw that distorts the picture in a predictable way.
Monthly figures are volatile. A strong December followed by a weak January can create the illusion of decline when the underlying business is healthy. YTD resets to zero on 1 January, making early-year figures meaningless and creating artificial urgency or complacency depending on how the prior year ended. SPLY gives you a single
reference point with no trend direction — you know whether this month was better or worse than last year’s equivalent, but not whether that gap is growing, shrinking, or stable. And critically, none of these measures removes the distorting effect of seasonality.
The Moving Annual Total (MAT) solves all three problems simultaneously. It is always a rolling 12-month figure — updated every period — that removes seasonality by design, never resets, and generates a trend line rather than a point-in-time comparison.
WHAT IS A MAT?
A Moving Annual Total is the sum of the last 12 months of a metric, recalculated every reporting period. At the end of January, it covers February prior year through January current. At the end of February, it covers March prior year through February current — and so on. Seasonality cancels out because each MAT always contains exactly the same 12 calendar months. It simply moves forward one period at a time.
The Problem with the Measures You're Already Using
| Factor | Monthly | YTD | SPLY | MAT ✓ |
|---|---|---|---|---|
| Seasonal bias | High | High | High | None — always 12 months |
| Year-end reset | No | Yes — Jan = 0 | No | No — rolls continuously |
| Trend direction | Single point | Resets annually | Single point | Clear trend line |
| Seasonality removed | No | No | No | Yes — by design |
| Useful from Jan 1 | Yes | No — Jan = 0 | Yes | Yes |
| Shows true growth | Rarely | Rarely | Partially | Consistently |
| CAGR calculation base | Unreliable | Unreliable | Unreliable | Correct input |
Three Leadership Perspectives on Why MAT Changes Everything
1
The CEO: A Clear Answer to "Is My Business Actually Growing?"
The CEO's most important question is whether the business is growing, contracting, or flat — stripped of seasonal alibi. The MAT answers that question cleanly. Plot MAT for revenue, gross margin, and key categories over 36 months and you see your business's true direction without noise. When a board member or investor asks how the business is performing, the MAT is the answer that cannot be obscured by "a difficult trading month." It is also the measure that most clearly signals when a strategic intervention is required — a declining MAT sustained over multiple periods is unambiguous evidence that something structural needs to change. When combined with CAGR (see below), the CEO has both a trend line and a precise growth rate — the two most powerful tools in any board presentation.
2
The Sales Manager: Understanding What Each Account Is Actually Doing
Monthly account reviews create perverse incentives: a customer who bought heavily in a promotional period looks strong, while a steady, growing account with no spikes looks flat. The MAT by account, channel, and territory strips out these distortions. A customer whose MAT grows month-on-month is a genuinely expanding relationship worth investing in. A customer whose MAT is declining is losing commitment regardless of how the most recent promotion looked. The MAT also measures promotional ROI with precision: if a major promotion does not move the MAT — if it only pulls forward demand that would have occurred anyway — the MAT will not budge. Distribution gains and losses are equally visible in the MAT build curve.
3
The Marketing Manager: Separating Real Growth from Campaign Spikes
Marketing investments are frequently validated by the monthly result immediately following a campaign — the most misleading possible evidence of effectiveness. A campaign that generates a monthly spike but leaves the MAT unchanged has simply redistributed demand. A campaign that genuinely builds preference and repeat purchase will move the MAT progressively over the following 6–12 months. MAT is also the most reliable tool for product lifecycle management: it shows clearly when a product has entered structural decline rather than seasonal softness. New product launches should be assessed on their MAT build trajectory — how quickly does the MAT accumulate distribution and repeat purchase? A launch that stalls in the MAT has failed to build genuine traction regardless of how the launch month looked.
The CAGR Connection: Unlocking Your True Growth Rate
A Compound Annual Growth Rate (CAGR) measures the smoothed annual growth of a business over multiple years — eliminating the distortion of individual strong or weak periods to give a single, defensible growth rate. It is the standard by which investors, acquirers, and strategic partners assess business performance. The formula is straightforward: (End Value ÷ Start Value)^(1 ÷ Years) − 1.
The critical insight is this: a CAGR is only as reliable as the values used to calculate it. Use a monthly figure as your start or end point, and your CAGR will be distorted by whatever seasonal, promotional, or one-off factors affected that specific month. Use a MAT as both the start and end value, and the CAGR is based on consistent, seasonality- adjusted 12-month totals — the correct input for any meaningful growth rate calculation.
Running MATs — consecutive monthly MAT data points — enable you to calculate rolling CAGRs on a continuous basis. A 1-year CAGR (this MAT vs. the MAT exactly 12 months prior) tells you your current annual growth rate. A 3-year CAGR tells you your sustained medium-term growth rate. A 5-year CAGR tells you your strategic growth trajectory. Tracking all three simultaneously reveals something no single CAGR can: whether your growth rate is accelerating or decelerating.
| Period | Start MAT | End MAT | CAGR & Insight |
|---|---|---|---|
| Jan 2021 → Jan 2022 | $2.00M | $2.18M | 9.0% — Solid growth year |
| Jan 2022 → Jan 2023 | $2.18M | $2.28M | 4.6% — Growth decelerating |
| Jan 2023 → Jan 2024 | $2.28M | $2.50M | 9.6% — Re-acceleration |
| Jan 2021 → Jan 2024 | $2.00M | $2.50M | 7.7% (3-yr) — True compound growth rate, not distorted by any single year |
Illustrative example. CAGR calculated as (End MAT ÷ Start MAT)^(1 ÷ years) − 1. MAT values are seasonality-adjusted — monthly figures would not yield a reliable CAGR.
In the example above, looking only at Year 2 (4.6% CAGR) would prompt alarm. Looking only at Year 3 (9.6%) would prompt optimism. The 3-year CAGR of 7.7% is the honest answer — and only the MAT series makes that calculation reliable. Running CAGRs across your MAT history transform a set of trend data points into a precise,
boardroom-ready measure of compound business performance.
Why More History Is Always Better
The power of the MAT increases dramatically with the depth of history behind it. A business with only 13 months of data has one MAT data point — a fact, not a trend. With five years of monthly data, it has 48 MAT data points and can calculate 1-year, 3-year, and 5-year CAGRs on a rolling basis — enough to identify seasonal cycles, isolate the impact of specific decisions, and model future performance with genuine confidence.
| History | MAT Points | CAGR Available | What It Tells You |
|---|---|---|---|
| 13 months | 12 points | 1-year CAGR only | Direction visible — rising or falling, but a single bad period can distort the signal. |
| 2 years | 24 points | 2-year CAGR | Trend visible. Acceleration or deceleration separable from one-off events. |
| 3 years | 36 points | 1 & 3-year CAGR | Pattern visible. Seasonality, promo cycles and competitor impacts become isolatable. |
| 5 years | 60 points | 1, 3 & 5-year CAGR | Business story. Model future performance with real confidence. CAGR comparison across periods highly actionable. |
| 7+ years | 84+ points | Full CAGR suite | Structural insight. Inflection points, market share shifts and lifecycle position visible with authority. |
The practical implication is important: start building your MAT data set now. Every month of history in your accounting or ERP system is a data point waiting to be activated. A business that extracts five years of monthly revenue data today and builds a MAT series has, in one afternoon, created the most powerful management tool it has ever owned.
Building the Best MAT Reporting Structure
The most effective MAT reporting structures share five characteristics. First, they are built at multiple levels of granularity: total business, then category, then brand or product group, then SKU, then channel, then customer. The total MAT tells you whether the business is growing; the granular MAT tells you where and why.
Second, they are visualised as a trend line, not a number. Twelve to 36 consecutive MAT data points, plotted as a line, tell a story that no table of numbers can replicate. Overlay your 1-year rolling CAGR on the same chart and you have a two-line management tool of exceptional clarity: trend direction and growth rate on a single page.
Third, they are benchmarked against a reference. For businesses with access to market data, the ideal reference is the category MAT — your MAT growing while the category MAT is flat means you are gaining market share. Without category data, a rolling gross margin MAT alongside revenue MAT is the minimum: revenue growing
while margin MAT is flat signals a pricing or mix problem that monthly reporting will almost never surface.
Fourth, they are updated on a fixed cadence and reviewed at every management meeting. A MAT calculated quarterly and reviewed annually is not a management tool — it is a periodic curiosity. The MAT and its rolling CAGRs should be the opening slide at every weekly or fortnightly sales and marketing review.
Fifth, incorporate every month of history the business possesses. If your accounting system holds seven years of data, all of it belongs in your MAT chart. The business context that seven years of MAT and rolling CAGRs provides — through economic cycles, product launches, competitive entries, and pricing changes — is irreplaceable
intelligence that no forward-looking forecast can substitute for.
The SIXiS Perspective
In more than two decades of working in FMCG businesses of all sizes, the single most consistent observation is this: businesses that understand their MAT and rolling CAGRs make better decisions than those that do not — not occasionally, but consistently. The combination is uniquely powerful: the MAT shows you where your business is going; the CAGR tells you how fast it is getting there; and the history depth tells you whether that rate of change is something you have earned sustainably or something that will revert.
Neither tool is sophisticated. Both can be built in Excel in two hours from data that already exists in your accounting system. What they require is a CEO who decides that seeing the business clearly is worth that two- hour investment. For most SME CEOs, it is the highest-return analytical decision available to them.
CEO Takeaway: Pull your last five years of monthly revenue data from your accounting system, build a
rolling 12-month MAT, and calculate your 1-year, 3-year, and 5-year CAGRs from that series. Do it this
week. Is your MAT rising or falling? Is your 1-year CAGR higher or lower than your 3-year CAGR — is your
growth rate accelerating or decelerating? Is there a point in the history where the slope changed, and do
you know why? If you cannot answer those questions about your own business today, your management
reporting is not showing you what you need to see. The MAT and its CAGRs will.