Excel Models
Using GARCH to Forecast Volatility
π― GARCH is not just a descriptive model β its purpose is to forecast the volatility of future returns on invested capital.
In previous posts, we:
- Explained the GARCH model
- Estimated its parameters using the Maximum Likelihood Method (MLE)
- Validated the model by removing volatility clustering
Now we answer the key question:
How do we use the model once we are confident it works properly?
π§ Forecasting Mechanism
The original model is defined as:
However, when forecasting, future shocks are unknown.
Therefore, we replace them with their expected values, which gives:
This means that volatility evolves according to a simple logic:
π its current level gradually moves toward a long-term level β a kind of gravitational equilibrium
Where:
π What This Looks Like in Excel

- We start from the current variance (ΟβΒ²)
- We forecast forward (t = 1β¦30)
- We convert variance into volatility
The result:
π a smooth curve that converges toward equilibrium

π What Determines the Shape of the Curve
Two key factors:
- Persistence (Ξ± + Ξ²)
High β slow adjustment
Low β fast adjustment - Mean Reversion
Volatility does not remain at extreme levels β it gradually returns to equilibrium
π Excel: Volatility Forecast β GARCH
Adapted from:
Options, Futures & Other Derivatives, John C. Hull