H.TO · TOR · Utilities
Hydro One Limited
Also onConsensus Drift
Implied value per share
CAD 52.38
Market price
CAD 51.90
Implied upside
+0.9%
5-year forecast · Perpetuity growth terminal value · Mid-year discounting · Base case
Value Per Share
Same forecast, different terminal treatment. Percentages vs price.
Forecast Cashflows
Reporting currency (CAD). Outflows negative.
| Line | FY26 | FY27 | FY28 | FY29 | FY30 | CAGR |
|---|---|---|---|---|---|---|
| Revenue | CAD 9.5bn | CAD 10.0bn | CAD 10.5bn | CAD 11.0bn | CAD 11.6bn | +5.1% |
| EBIT | CAD 2.4bn | CAD 2.6bn | CAD 2.7bn | CAD 2.8bn | CAD 3.0bn | +5.1% |
| NOPAT | CAD 2.1bn | CAD 2.2bn | CAD 2.3bn | CAD 2.4bn | CAD 2.6bn | +5.1% |
| Add depreciation & amortisation | CAD 1.0bn | CAD 1.1bn | CAD 1.1bn | CAD 1.2bn | CAD 1.2bn | +5.1% |
| Less capital expenditure | CAD -3.0bn | CAD -3.1bn | CAD -3.3bn | CAD -3.5bn | CAD -3.6bn | +5.1% |
| Less increase in working capital | CAD 180.6m | CAD 189.9m | CAD 199.6m | CAD 209.9m | CAD 220.7m | -5.1% |
| Free cashflow to firm | CAD 319.2m | CAD 335.6m | CAD 352.9m | CAD 371.0m | CAD 390.0m | +5.1% |
| Discount factor | 0.9749 | 0.9265 | 0.8806 | 0.8369 | 0.7954 | - |
| Present value | CAD 311.2m | CAD 311.0m | CAD 310.7m | CAD 310.5m | CAD 310.2m | -0.1% |
| Present Value Of The Forecast | CAD 1.6bn | |||||
Discount Rate
Source shown per component. All overridable above.
| Risk-free rate | 3.30% | CAD assumption - no free live source available for this market (assumption) |
| Equity risk premium | 5.50% | Market assumption |
| Beta | 0.582 | Reported 0.376, pulled toward 1.0 (Blume) |
| Cost of equity | 6.50% | Risk-free + beta x equity risk premium |
| Cost of debt | 3.65% | Interest expense / average total debt |
| Market capitalisation | CAD 31.1bn | 61.9% of capital |
| Total debt | CAD 19.2bn | 38.1% of capital, book value as a proxy |
| Tax rate | 14.0% | Effective, capped at statutory |
| WACC | 5.22% | E/V x Re + D/V x Rd x (1 - t) |
Terminal Value
Perpetuity growth is intrinsic. The exit multiple defaults to the company's current EV/EBITDA, so it answers a different question - what the shares are worth if today's rating holds and EBITDA grows as forecast.
Perpetuity growth at 2.50%
97% of EV
- Forecast FCFF, final year
- CAD 390.0m
- Capex at depreciation, working capital in reinvestment
- CAD 2.7bn
- Less reinvestment at g/ROIC (39.4% of NOPAT)
- CAD -1.1bn
- Capitalised
- CAD 1.6bn
- ROIC (reported)
- 6.4%
- Terminal value, undiscounted
- CAD 61.0bn
- Terminal value, discounted
- CAD 48.5bn
- Enterprise value
- CAD 50.1bn
- Less net debt
- CAD 18.6bn
- Equity value
- CAD 31.5bn
Exit at 14.9x EBITDA
97% of EV
- Terminal value, undiscounted
- CAD 62.7bn
- Terminal value, discounted
- CAD 49.9bn
- Enterprise value
- CAD 51.4bn
- Less net debt
- CAD 18.6bn
- Equity value
- CAD 32.8bn
Spread between methods: 4%.
Sensitivity
Value per share (CAD) by discount rate and long-run growth.
| Long-run growth | |||||
|---|---|---|---|---|---|
| Discount rate | 1.50% | 2.00% | 2.50% | 3.00% | 3.50% |
| 3.22% | 145.45 | 192.49 | 304.45 | 924.20 | — |
| 4.22% | 76.85 | 87.83 | 105.02 | 136.07 | 209.84 |
| 5.22% | 45.28 | 48.32 | 52.38 | 58.15 | 67.11 |
| 6.22% | 27.19 | 27.64 | 28.15 | 28.72 | 29.42 |
| 7.22% | 17.14 | 17.37 | 17.59 | 17.82 | 18.04 |
Outlined: this model. Green text: above today's price of 51.90. Shading: distance from this model's own value.
Priced In
What each input would have to be to justify the current price, one at a time.
| Input | Model | Implied | Gap |
|---|---|---|---|
| Revenue growth, every year | 5.1% | 5.0% | -0.1pp |
| EBIT margin | 25.7% | 25.6% | -0.1pp |
| Discount rate | 5.2% | 5.2% | +0.0pp |
Live formulas, not pasted numbers - edit a driver and the workbook reprices.
Yahoo Finance and RBA data. General information, not advice. Methodology.