Sensitivity of enterprise value to correlated assumptions · Calculation guide

Use the perpetual-growth enterprise value with fixed next-year free cash flow.

Calculation guide

Estimate one standard deviation of value by first-order propagation of correlated discount-rate and growth shocks. Enter volatilities in percentage points.

Approximate enterprise value deviation = (((100 × Next-year free cash flow) ÷ ((Discount rate (%) − Perpetual growth (%)) ^ 2)) × √((((Discount-rate volatility (points) − Growth volatility (points)) ^ 2) + (((2 × Discount-rate volatility (points)) × Growth volatility (points)) × (1 − Correlation of rate and growth shocks))))). Base enterprise value = ((100 × Next-year free cash flow) ÷ (Discount rate (%) − Perpetual growth (%)))

Inputs

Next-year free cash flow

Example entry 100 (in the selected currency).

Discount rate (%)

Example entry 10 %. Allowed range -90.0 to 100.0.

Perpetual growth (%)

Example entry 5 %. Allowed range -90.0 to 100.0.

Discount-rate volatility (points)

Example entry 1 %. Allowed range 0 to 100.

Growth volatility (points)

Example entry 1 %. Allowed range 0 to 100.

Correlation of rate and growth shocks

Example entry 0.5. Allowed range -1.0 to 1.0.

Worked example

InputValue
Next-year free cash flow100
Discount rate (%)10%
Perpetual growth (%)5%
Discount-rate volatility (points)1%
Growth volatility (points)1%
Correlation of rate and growth shocks0.5
ResultValue
Approximate enterprise value deviation400
Base enterprise value2,000

Calculation steps

Approximate enterprise value deviation = (((100 × Next-year free cash flow) ÷ ((Discount rate (%) − Perpetual growth (%)) ^ 2)) × √((((Discount-rate volatility (points) − Growth volatility (points)) ^ 2) + (((2 × Discount-rate volatility (points)) × Growth volatility (points)) × (1 − Correlation of rate and growth shocks)))))

(((100 × 100) ÷ ((10 − 5) ^ 2)) × √((((1 − 1) ^ 2) + (((2 × 1) × 1) × (1 − 0.5))))) = 400

Base enterprise value = ((100 × Next-year free cash flow) ÷ (Discount rate (%) − Perpetual growth (%)))

((100 × 100) ÷ (10 − 5)) = 2,000

Interpreting the result

The reported deviation is a local approximation around the base valuation. A narrow spread between discount and growth rates increases sensitivity to small shocks.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Next-year free cash flow100110Approximate enterprise value deviation400440
Discount rate (%)10%11%Approximate enterprise value deviation400277.777778
Perpetual growth (%)5%6%Approximate enterprise value deviation400625
Discount-rate volatility (points)1%2%Approximate enterprise value deviation400692.820323
Growth volatility (points)1%2%Approximate enterprise value deviation400692.820323
Correlation of rate and growth shocks0.5-0.5Approximate enterprise value deviation400692.820323
Sensitivity of enterprise value to correlated assumptions →

Sources