Management Accounting · Analytical techniques in budgeting and forecasting

Forecasting Using Trend and Seasonal Variations

Updated 11 October 2026 · Fact-checked

To forecast with trend and seasonal variations, extend the trend line to the future period, then adjust it by the seasonal variation for that period. Add or subtract the variation in the additive model. Multiply by the seasonal index in the multiplicative model. Forecasts become less reliable the further ahead you project.

Understand Forecasting Using Trend and Seasonal Adjustments

A time series is a set of figures recorded at regular intervals, such as quarterly sales. Forecasting takes the pattern in past figures and extends it into the future.

The trend is the underlying long-term movement, upwards or downwards, with short-term ups and downs removed. The seasonal variation is a regular pattern that repeats within a fixed period, such as higher sales every fourth quarter. Anything left over is random variation, which you cannot forecast.

There are two models. In the additive model, the seasonal variation is a fixed amount, for example +$20,000 in quarter 4. In the multiplicative model, it is a proportion of the trend, for example 1.10 (110% of trend). The question tells you which to use.

The forecast has two stages. First, find the trend value for the future period. Second, apply the seasonal variation for that period. The trend is often given as a formula like y = a + bx, where x counts the periods. Or you extend it using the average change per period.

Forecasts rest on assumptions: the past pattern continues, the seasonal pattern stays stable, and no big outside event changes things. These assumptions create the limitations the exam asks about.

Key formulas to remember

Trend line: y = a + bx; a is the starting value, b is the change in trend per period, x is the period number. Check how x is numbered in the question.
Additive forecast: Forecast = Trend + Seasonal variation; The seasonal variation is an amount. It may be negative. The variations for one full cycle should sum to about zero.
Multiplicative forecast: Forecast = Trend × Seasonal index; An index of 1.10 means 10% above trend. An index of 0.90 means 10% below trend. Indices over a cycle average 1 (for four quarters they sum to 4).
Seasonal variation (additive): Actual − Trend; Average these figures for each season to get the seasonal variation.
Seasonal index (multiplicative): Actual ÷ Trend; Average these figures for each season to get the index.

How to solve Forecasting Using Trend and Seasonal Adjustments questions

Use this order for any trend and seasonal forecasting question.

1Read which model is used: additive or multiplicative. Note the length of the cycle (quarters, months).
2Identify the trend formula, or the trend values and the average change per period.
3Work out the value of x for the period you are forecasting. Count carefully from the start of the series.
4Calculate the trend value for that period by putting x into the formula.
5Find the seasonal variation or index for the matching season. Match the quarter or month, not the period number.
6Apply it: add or subtract in the additive model, multiply in the multiplicative model.
7Check the answer is sensible: the sign, the size and the units. Round only at the end.
8If asked about reliability, link the limits to the assumptions: stable pattern, distance ahead, and outside events.

Quickest way: Trend then season in two lines

When to use it: Use this in Section A number entry or multiple choice questions where the trend formula and seasonal figures are given.

Write the trend calculation first: a + b × x. Do it fully before looking at seasonal figures.
Pick the right season from the table and apply it with one operation.
Scan the options. Remove any that look like the trend alone or that use the wrong sign or season.

Common mistakes in Forecasting Using Trend and Seasonal Adjustments

Adding a seasonal index instead of multiplying by it in the multiplicative model.
Students remember the additive method and apply it everywhere.
Fix: Read the model first. An index like 1.10 or 0.85 is always multiplied.
Using the wrong value of x.
Students do not check where x = 1 starts, or miscount the periods.
Fix: Write the period list down, such as Year 1 Q1 = 1, and count to the target period.
Applying the seasonal figure for the wrong quarter.
The period number and the season get mixed up.
Fix: Convert the period number to its season. With four quarters, period 10 is quarter 2.
Forgetting a negative seasonal variation.
Students drop the minus sign when adding.
Fix: Write the variation with its sign, then add. Adding −15 reduces the trend.
Presenting a forecast far into the future as reliable.
Students treat the formula as exact.
Fix: State that the further ahead you forecast, the less reliable it is, because the trend and seasonal pattern may change.
Treating forecasts as certain when listing limitations.
Students give vague answers like 'it may be wrong'.
Fix: Name specific limits: it uses past data, assumes the pattern continues, ignores random variation and outside events, and depends on enough data.

Worked examples

Example 1

Quarterly sales have the trend y = 5,000 + 200x, where x = 1 for Year 1 quarter 1. The additive seasonal variation for quarter 3 is −$300. Forecast sales for Year 4 quarter 3.

Show the solution

Year 4 quarter 3 is period (3 × 4) + 3 = 15, so x = 15.
Trend = 5,000 + 200 × 15 = 5,000 + 3,000 = 8,000.
Seasonal variation for quarter 3 is −300.
Forecast = 8,000 − 300 = 7,700.

Answer: $7,700

Example 2

The trend in units sold is y = 1,200 + 50x, where x = 1 for Year 1 quarter 1. Seasonal indices (multiplicative) are Q1 0.90, Q2 1.05, Q3 0.95, Q4 1.10. Forecast units for Year 3 quarter 4.

Show the solution

Year 3 quarter 4 is period (2 × 4) + 4 = 12, so x = 12.
Trend = 1,200 + 50 × 12 = 1,200 + 600 = 1,800.
Quarter 4 index is 1.10.
Forecast = 1,800 × 1.10 = 1,980.

Answer: 1,980 units

Exam tips

Check the model before any arithmetic. Additive means add or subtract. Multiplicative means multiply.
In number entry questions, follow the rounding instruction exactly and round only at the end.
For multiple response limitation questions, pick points about past data, stable patterns, distance ahead and outside events.
Match the season to the period number by dividing by the cycle length and using the remainder.
Wrong options are often the trend alone or the wrong season. Check your answer against these.

Practice questions from Analytical techniques in budgeting and forecasting

Forecasting Using Trend and Seasonal Adjustments in other exams

The same ground in other exams, if you are preparing for more than one or want another angle on it.

CMA FoundationSeasonal Variation Measurement

Forecasting Using Trend and Seasonal Adjustments: frequently asked questions

What is the difference between additive and multiplicative models?

The additive model uses a fixed amount for each season, added to or taken from the trend. The multiplicative model uses a proportion of the trend, applied as an index. The multiplicative model suits series where seasonal swings grow as the trend grows.

What are the limitations of forecasting with trend and seasonal variations?

Forecasts rely on past data and assume the trend and seasonal pattern will continue. They become less reliable further into the future. Random events, changes in the market and too little data can all make the forecast wrong.

How do I find x for a future period?

Count the periods from the start of the series, using the numbering given in the question. If x = 1 is Year 1 quarter 1, then Year 3 quarter 2 is (2 × 4) + 2 = 10.

Where does forecasting appear in ACCA MA?

It appears in objective test questions on analytical techniques in budgeting. Expect a calculation using a given trend and seasonal figures, or a question on the limitations of forecasting.