Skip to content

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:

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:Οƒt+12=Ο‰+Ξ±ut2+Ξ²Οƒt2sigma_{t+1}^2 = omega + alpha u_t^2 + beta sigma_t^2

However, when forecasting, future shocks are unknown.
Therefore, we replace them with their expected values, which gives:

E[Οƒt+k2]=VL+(Ξ±+Ξ²)k(Οƒt2βˆ’VL)E[sigma_{t+k}^2] = V_L + (alpha+beta)^k(sigma_t^2 – V_L)

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:VL=Ο‰1βˆ’Ξ±βˆ’Ξ²V_L = frac{omega}{1 – alpha – beta}

πŸ“ˆ 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

Discover more from Eon Investment

Subscribe now to keep reading and get access to the full archive.

Continue reading