A time series is a sequence of data points collected at regular time intervals — monthly revenue, daily stock prices, weekly website traffic. Forecasting involves using past patterns in this data to predict future values. Before building any forecasting model, you must understand the four fundamental components that shape time series behavior.
Time series components can be combined in two ways:
The chart above shows NorthStar's quarterly revenue over five years. Three components are visible: a clear upward trend as the company grows, a seasonal pattern with Q4 consistently the highest quarter (holiday demand) and Q1 the lowest, and some irregular variation from quarter to quarter. The seasonal peaks also grow larger over time, suggesting a multiplicative model may be more appropriate than an additive one.
The simplest forecasting methods smooth out short-term noise to reveal the underlying pattern. Two foundational techniques are the simple moving average (SMA) and exponential smoothing (ES).
A moving average forecasts the next period by averaging the most recent n observations. A 3-month moving average, for example, forecasts next month's value as the average of the last three months. Larger values of n produce smoother forecasts but respond more slowly to changes.
=AVERAGE(last_n_values)n is the number of periods in the moving average window and yt is the observed value at time t.
Exponential smoothing addresses a key limitation of the moving average: it treats all past observations in the window equally. In many business settings, recent data should matter more than older data. Exponential smoothing assigns exponentially decreasing weights to older observations, controlled by a smoothing constant (alpha) between 0 and 1.
=alpha*y_t + (1-alpha)*F_tFt+1 is the forecast for the next period, α is the smoothing constant (0 < α < 1), yt is the actual value at time t, and Ft is the forecast for time t.
=AVERAGE(ABS(actual-forecast))Higher α makes forecasts more responsive to recent changes but also more volatile. Lower α produces smoother forecasts that are slower to adapt. The right choice depends on how quickly the underlying pattern changes in your business context.
When a time series has a clear trend, simple moving averages and exponential smoothing will systematically lag behind the data — always underforecasting in an upward trend and overforecasting in a downward trend. Trend-based regression addresses this by fitting a line (or curve) to the time series and projecting it forward.
The simplest trend model treats time as the predictor variable: Y = b0 + b1 × t. The slope b1 represents the average per-period change in the series. In Excel, this is easily accomplished with the FORECAST or TREND function, or by adding a trendline to a chart.
When both trend and seasonality are present, a two-step approach works well: (1) remove seasonality by computing seasonal indices and dividing them out, (2) fit a trend line to the deseasonalized data, and (3) multiply the trend forecast by the appropriate seasonal index to get the final prediction.
In practice, analysts often compare multiple forecasting methods on a holdout sample. The method that produces the lowest MAE (or MAPE, or RMSE) on the holdout period is selected for production forecasting.
No single forecasting method dominates in all situations. Always compare methods using holdout data. Simple methods like moving averages work well for stable series, while regression-based approaches are better when a strong trend is present. The best forecasters combine quantitative methods with domain knowledge about the business.
Time series forecasting is one of the most directly useful statistical skills in business. From inventory planning to sales targets to budgeting, the ability to project future values from historical patterns drives decisions across every function.
Components: Every time series can be decomposed into trend, seasonality, cyclical, and irregular components. Understanding these components is the first step in any forecasting exercise.
Smoothing Methods: Simple moving averages and exponential smoothing are foundational techniques. SMA treats all recent observations equally; ES gives more weight to recent data through the smoothing constant α.
Trend Forecasting: When a clear trend is present, regression-based approaches outperform simple smoothing. Seasonal adjustment allows you to handle both trend and seasonality simultaneously.