[email protected] 6.11
DCF VALUATION
VALUATION FORECAST (y/e 30 Sept)
30 Sep 20252026 2027 2028 2029 2030
FREE CASH FLOWS • POST-TAX WACC
FUTURE ENTERPRISE VALUE
Terminal Value - - - - 52,402.7
Discounted back one period 33,111.5 36,198.9 39,706.3 43,553.6 47,773.7 -
Free Cash Flows to the Firm (1,007.1) (621.7) 1,171.3 1,300.9 1,823.9
Discounted back one period (cumulative) 1,505.0 2,652.4 3,531.1 2,701.9 1,662.8 -
DCF Enterprise Value
1
34,616.5 38,851.3 43,237.4 46,255.5 49,436.5 52,402.7
Market value of associates and non-operating assets - - - - - -
Add cash balances (gross debt method only)(incl. Operating Cash)- - - - - -
Enterprise Value at each year end (Net Debt Method) 34,616.5 38,851.3 43,237.4 46,255.5 49,436.5 52,402.7
Discount Rate (Post-Tax WACC)- see Discount Rate Analysis 9.32% 9.69% 9.69% 9.69% 9.69%
One year discount factor 0.91471 0.91167 0.91167 0.91167 0.91167
Market value of associates and non-operating assetsDon't use 8,249.8 9,019.8 9,861.6 10,782.0 11,788.4 12,888.6
1
Ent Value at each year end = {Ent Value next yr + Cash Flows next yr} / (1 + discount rate)
CURRENT ENTERPRISE VALUE
Present Value of Free Cash Flows + TV 34,616.5 (921.2) (518.4) 890.5 901.7 34,264.0
Market value of associates and non-operating assets -
Add cash balances (gross debt method only)(incl. Operating Cash)-
Enterprise Value at each year end (Net Debt Method) 34,616.5
Discount Rate (Post-Tax WACC)- see Discount Rate Analysis 9.32% 9.69% 9.69% 9.69% 9.69%
Cumulative discount factor to valuation date 0.91471 0.83391 0.76025 0.69309 0.63187
Terminal Value
Perpetuity Leverage (D / D+E) at start 20.00%
Terminal Post-Tax WACC 9.69% 9.69%
Growth (2.91% real) 6.00% 6.00%
Inflation 3.00%
Free Cash Flows 1st terminal year1,823.9 x (1 +6.00%) =1,933.3
Terminal Value (TV) 1,933.3 / (9.69% - 6.00%) =52,402.7
EQUITY VALUE PER SHARE
DCF Equity Value - including options 30,697.1 31,081.0 34,589.9 37,004.4 39,549.2 41,922.1
less: fair value of outstainding options (709.2) (675.9) (721.0) (740.7) (760.8) (776.1)
DCF Equity Value - excluding options 29,987.9 30,405.1 33,869.0 36,263.7 38,788.4 41,146.0
Shares in issued - basic 296,581,476.0 297,322,501.2 298,053,821.9 298,759,613.8 299,418,542.1 300,034,099.1
DCF Equity Value per Share - minority quoted holding 101.11 102.26 113.63 121.38 129.55 137.14
DCF Equity Value 30,697.1 31,081.0 34,589.9 37,004.4 39,549.2 41,922.1
Shares in issued - diluted 308,734,331.7 308,792,504.9 309,057,071.9 309,273,095.5 309,476,144.3 309,654,688.7
DCF Equity Value per Share - diluted 99.43 100.65 111.92 119.65 127.79 135.38
LEVERAGE
Borrowings and finance leases 3,716.9 7,286.9 8,169.0 8,778.6 9,410.6 9,999.3
Pension Deficit 49.7 387.4 387.4 387.4 387.4 387.4
Gross debt and debt equivalents 3,766.6 7,674.2 8,556.3 9,166.0 9,797.9 10,386.7
less: cash if Net Debt Method used (excluding cash treated as working capital)(366.7) (192.7) (212.0) (233.2) (244.9) (257.1)
Net Interest bearing debt 3,399.9 7,481.5 8,344.3 8,932.8 9,553.0 10,129.6
Non-interest bearing debt equivalents - long term provisions 519.6 288.8 303.2 318.3 334.3 351.0
Net debt & debt equivalents 3,919.5 7,770.3 8,647.5 9,251.1 9,887.3 10,480.5
Net Debt and debt equivalents / Enterprise Value11.32% 20.00% 20.00% 20.00% 20.00% 20.00%
DCF equity value 30,697.1 31,081.0 34,589.9 37,004.4 39,549.2 41,922.1
Value of non-operating investmens - - - - - -
Equity 30,697.1 31,081.0 34,589.9 37,004.4 39,549.2 41,922.1
Enterprise Value at each year end (Net Debt Method) 34,616.5 38,851.3 43,237.4 46,255.5 49,436.5 52,402.7
Implied Forward EBITDA x 12.6 x 12.8 x 12.9 x 13.1 x 13.2 x 13.2 x
Target leverage used in WACC (market values) 11.32% 20.00% 20.00% 20.00% 20.00% 20.00%
Actual Leverage (market values i.e. DCF value) 11.32% 20.00% 20.00% 20.00% 20.00% 20.00%
Actual Leverage (book Invested Capital) 50.19% 74.74% 67.76% 68.39% 69.34% 71.78%
Terminal value as % of EV 95.65% 93.17% 91.83% 94.16% 96.64% 100.00%
DCF Enteprise Value 34,616.5 38,851.3 43,237.4 46,255.5 49,436.5 52,402.7
x target leverage = net debt 3,919.5 7,770.3 8,647.5 9,251.1 9,887.3 10,480.5