Discounted Cash Flow

Canadian Pacific Kansas City Ltd./Cn

CP · Based on 10 years of SEC filings · Converted from CAD to USD

Average annual growth rates

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Average annual growth is the mean year-over-year change across each period.

Endpoint CAGR (better for long term trend)

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Endpoint CAGR is the compound annual rate from the first to last year in each period.

Projections use average year-over-year growth. Change this in Settings.

Projected growth rate

Free cash flow growth
10-year: — 5-year: — 3-year: —
Averaged growth (FCF & NI)
10-year: — 5-year: — 3-year: —
Net income growth
10-year: — 5-year: — 3-year: —
Sales growth (not added to calculations)
10-year: — 5-year: — 3-year: —

Click a greyed-out slider to switch metrics. Slide between the 10-year, 5-year, and 3-year historic growth rates for FCF, net income, or their average.

%
%

Historical inputs (10 fiscal years)

YEAR Sales Net Income Free Cash Flow Net Margin EPS (diluted)
2016 $6.2b $1.1b $650.9m 18.4% $10.69
2017 $6.6b (5.2%) $1.7b (50.4%) $604.3m (-7.2%) 26.3% (43.0%) $16.49 (54.3%)
2018 $7.3b (10.7%) $1.4b (-18.9%) $833.2m (37.9%) 19.3% (-26.7%) $13.65 (-17.2%)
2019 $7.7b (6.5%) $1.8b (25.1%) $963.9m (15.7%) 22.7% (17.4%) $17.58 (28.8%)
2020 $7.6b (-1.0%) $1.8b (0.2%) $811.7m (-15.8%) 22.9% (1.2%) $18.05 (2.7%)
2021 $7.9b (3.5%) $2.0b (16.7%) $1.5b (90.6%) 25.9% (12.7%) $4.20 (-76.7%)
2022 $8.7b (10.3%) $2.5b (23.3%) $1.9b (19.9%) 28.9% (11.8%) $3.78 (-10.0%)
2023 $12.4b (42.5%) $2.8b (11.7%) $1.2b (-35.4%) 22.7% (-21.7%) $4.22 (11.6%)
2024 $14.4b (15.8%) $2.7b (-5.3%) $1.8b (46.4%) 18.5% (-18.3%) $3.98 (-5.7%)
2025 $15.0b (3.9%) $3.0b (11.4%) $1.6b (-9.7%) 19.9% (7.2%) $4.52 (13.6%)

Base FCF: (latest fiscal year)

Discount rate: %

Terminal growth:

Projection period: years

Alt A decline yrs:

Alt B total yrs:

SEC filings report in CAD. Values above are converted to USD for comparison with the US-listed share price.

Values abbreviated: b = billions, m = millions, k = thousands.

Projected cash flows

Year Projected cash flow Discount Factor Present Value

PV of projected FCF:

Terminal FCF:

Terminal value:

PV of terminal value:

Enterprise value (DCF):

DCF price per share:

Current price:

Alternative DCF Models

Model Fair Value Upside PV(FCFs) PV(Terminal) Total Years
Standard (10yr→TV) 10 + TV
Alt A (Gradual Decline)
Alt B (30yr Hard Stop) N/A

This is a simplified DCF model for illustration. It uses reported free cash flow, a single growth assumption, fixed WACC, and a Gordon Growth terminal value. It is not investment advice.

+ 10YR Financials Balance Sheet (10YR) Cash Flow (10YR) DCF Model