What is Moving annual total (MAT)? How it is calculated?
The moving annual total is the total value of a variable, such as sales figures for a product, over the course of the previous 12 months.
This is a rolling yearly sum, so changes at the end of each month with data from the new month added to the total and data from the first month of the period taken away.
The moving annual total is abbreviated as MAT.
Calculation
Here’s how you can calculate a Moving Annual Total:
- Choose a specific month as your starting point. This can be the current month or any other month of interest.
- Calculate the total for the 12 months following that starting point. This involves adding up the data points (e.g., sales, revenue, units sold, etc.) for each of those 12 months.
- Move forward one month, and again calculate the total for the next 12 months.
- Repeat this process until you have calculated the MAT for each month over the desired time period.
Example of Moving Annual Total Calculation
MAT JAN 2024 = FEB-23+MAR-23+…..+DEC-23+JAN-24
MAT JUNE 2025 = JULY-2024+AUG-2024+……….+MAY-2025+JUNE-2025
Significance of Moving Annual Total
Moving Annual Total is often used in sales, revenue, and performance analysis to provide a more accurate representation of trends and performance over time, especially in industries with seasonality or fluctuations.