Northwest Natural Gas Co
over ten years, 10x exit
| Fiscal year | Operating cash flow | Stock comp | Capex | Free cash flow | Net borrowing | FCFE | Shares (B) | FCF per share | Year-end price | FCF yield |
|---|---|---|---|---|---|---|---|---|---|---|
| 2016 | 0.2 | 0.0 | 0.1 | 0.1 | +0.1 | 0.2 | 0.03 | $2.80 | $59.80 | 4.7% |
| 2017 | 0.2 | 0.0 | 0.2 | -0.0 | +0.0 | -0.0 | 0.03 | $-0.31 | $59.65 | -0.5% |
| 2018 | 0.2 | 0.0 | 0.2 | -0.0 | +0.0 | -0.0 | 0.03 | $-1.67 | $60.46 | -2.8% |
| 2019 | 0.2 | 0.0 | 0.2 | -0.1 | +0.1 | 0.0 | 0.03 | $-2.84 | $73.73 | -3.8% |
| 2020 | 0.1 | 0.0 | 0.3 | -0.2 | +0.1 | -0.1 | 0.03 | $-5.17 | $45.99 | -11.2% |
| 2021 | 0.2 | 0.0 | 0.3 | -0.2 | +0.2 | 0.0 | 0.03 | $-4.93 | $48.78 | -10.1% |
| 2022 | 0.1 | 0.0 | 0.3 | -0.2 | +0.2 | 0.0 | 0.03 | $-5.73 | $47.59 | -12.0% |
| 2023 | 0.3 | 0.0 | 0.3 | -0.1 | +0.2 | 0.1 | 0.04 | $-1.40 | $38.94 | -3.6% |
| 2024 | 0.2 | 0.0 | 0.4 | -0.2 | +0.3 | 0.1 | 0.04 | $-4.99 | $39.56 | -12.6% |
| 2025 | 0.3 | 0.0 | 0.5 | -0.2 | +0.6 | 0.4 | 0.04 | $-4.83 | $46.74 | -10.3% |
| 9-yr CAGR | 2.2% | n/m | 14.4% | n/m | n/a | 8.5% | 4.1% | n/m | -2.7% | avg -6.2% |
| Fiscal year | Revenue | EBITDA | EBITDA margin | Debt incl. leases | Cash & securities | Market cap | Enterprise value | EV / EBITDA | Net debt / EBITDA |
|---|---|---|---|---|---|---|---|---|---|
| 2016 | 0.7 | 0.2 | 32.8% | 0.7 | 0.0 | 2 | 2 | 10.7x | 2.98x |
| 2017 | 0.8 | 0.2 | 30.0% | 0.7 | 0.0 | 2 | 2 | 10.5x | 2.93x |
| 2018 | 0.7 | 0.2 | 30.8% | 0.7 | 0.0 | 2 | 2 | 11.1x | 3.12x |
| 2019 | 0.7 | 0.2 | 31.5% | 0.8 | 0.0 | 2 | 3 | 12.7x | 3.37x |
| 2020 | 0.8 | 0.3 | 32.6% | 0.9 | 0.0 | 1 | 2 | 9.1x | 3.56x |
| 2021 | 0.9 | 0.3 | 32.2% | 1.1 | 0.1 | 2 | 3 | 9.2x | 3.83x |
| 2022 | 1.0 | 0.3 | 27.4% | 1.3 | 0.2 | 2 | 3 | 9.6x | 3.88x |
| 2023 | 1.2 | 0.3 | 27.4% | 1.5 | -0.1 | 1 | 3 | 9.2x | 4.88x |
| 2024 | 1.2 | 0.3 | 30.3% | 1.8 | 1.7 | 2 | 2 | 4.6x | 0.23x |
| 2025 | 1.3 | 0.6 | 47.2% | 2.4 | 0.0 | 2 | 4 | 6.9x | 3.79x |
| 9-yr CAGR | 7.4% | 11.9% | avg 32.2% | 14.8% | 8.7% | 1.2% | 6.6% | median 9.4x | avg 3.26x |
| Purchase price | 6.5x | 7x last FYE | 8x | 9.5x median | 12.5x |
|---|---|---|---|---|---|
| $36 | 6.6% | 8.1% | 10.7% | 13.9% | 18.8% |
| $43 | 5.3% | 6.8% | 9.4% | 12.5% | 17.2% |
| $48 last close | 4.5% | 6.0% | 8.5% | 11.6% | 16.3% |
| $55 | 3.5% | 5.0% | 7.4% | 10.5% | 15.0% |
| $58 | 3.1% | 4.5% | 7.0% | 10.0% | 14.5% |
Revenue grew 7.4% a year and EBITDA 11.9% a year from FY2016 to FY2025, and free cash flow after stock compensation did not grow from a positive base. The share count rose 4.1% a year, so per-share figures grew more slowly than the totals. Net debt stood at 3.8x EBITDA at the last fiscal year-end. Capital spending rose from 21% of revenue to 36%, which is why free cash flow lagged operating cash flow in the latest year. At 7x EBITDA at the last fiscal year-end against a ten-year median of 9x, the model prices the last close of $48 as a 11.6% ten-year return; the grid shows how that changes if the multiple holds.
From the data: Stock compensation is not reported in the data feed for the latest fiscal year, so that year's free cash flow is before stock comp.
- Free cash flow is operating cash flow less stock-based compensation less capital spending. Stock comp is treated as a real cost.
- Net borrowing is the year's change in long-term debt. FCFE adds it back to free cash flow, the classic one-page definition.
- EBITDA is operating income plus depreciation and amortization. Debt includes lease obligations; cash includes short-term investments.
- Market cap uses the fiscal year-end price as traded, restated for later splits but not for dividends; enterprise value adds debt and subtracts cash.
- Share count is the yearly change in shares outstanding over the period; flat or falling clears. Cash margin is the latest free cash flow margin against its three-year average; within two points clears.
- Hurdle price is the present value, at the hurdle rate, of ten years of modeled free cash flow per share plus a year-10 sale at the exit multiple. It is shown as an exhibit: the 2011 to 2021 back-test found that buying below it did not sort winners from losers, so it is not scored.
- Cleared on a check means the number clears the stated rule; Not cleared means it does not. Durable, Holding and First year say how many fiscal years running the company has cleared all four staying-power checks (four or more, two or three, one); Partial and Not cleared count the checks it clears today. All of it is fact about the filings, not a rating of the stock.