Railroads, Line-Haul Operating
Canadian Pacific Kansas City Limited, together with its subsidiaries, owns and operates a transcontinental freight railway in Canada and the United States. The company transports bulk commodities, including grain, coal, potash, fertilizers, and sulphur; and merchandise freight, such as energy, chemicals and plastics, metals, minerals and consumer, automotive, and forest products. It transports intermodal traffic comprising retail goods in overseas containers. The company offers rail and intermodal transportation services through a network of approximately 13,000 miles serving business centers in Quebec and British Columbia, Canada; and the United States Northeast and Midwest regions. Canadian Pacific Kansas City Limited is headquartered in Calgary, Canada.
Discounted Cash Flow Valuation of Canadian Pacific Kansas City Ltd
Growth
%
%
Discount
%
%
Multiple
g\r | +10% | +11% | +12% | +13% | +14% |
---|---|---|---|---|---|
0% | 10 | 9 | 8 | 8 | 7 |
+1% | 11 | 10 | 9 | 8 | 8 |
+2% | 13 | 11 | 10 | 9 | 8 |
+3% | 14 | 13 | 11 | 10 | 9 |
+4% | 17 | 14 | 12 | 11 | 10 |
Years | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | TV |
---|---|---|---|---|---|---|---|---|---|---|---|---|
FCF | $1.681B | $1.948B | $2.235B | $2.536B | $2.848B | $3.163B | $3.474B | $3.774B | $4.054B | $4.306B | $4.521B | $45.21B |
DCF | $1.694B | $1.69B | $1.668B | $1.628B | $1.572B | $1.502B | $1.419B | $1.325B | $1.224B | $1.118B | $11.18B | |
Value | $26.02B |
In the chart Earnings are multiplied by this value.
High margins render the company resilient under dire circumstances, hence able to drive competitors out or acquire them. ROE and ROA measure the average flow generated by each invested dollar. Their marginal value is a forecast of future growth, and it is considered by Buffett and Munger the most important single indicator.
Years | 12-2015 | 12-2016 | 12-2017 | 12-2018 | 12-2019 | 12-2020 | 12-2021 | 12-2022 | 12-2023 | TTM |
---|---|---|---|---|---|---|---|---|---|---|
Net Margin | 20% | 26% | 37% | 27% | 31% | 32% | 36% | 40% | 31% | 28% |
ROA | 14% | 14% | 15% | 14% | 16% | 14% | 5.3% | 5.6% | 5.5% | 5.6% |
ROE | 28% | 35% | 37% | 29% | 35% | 33% | 8.4% | 9% | 9.2% | 8.9% |
The average Net Margin over the past 5 years is +32.75%.
The trend of Net Margin over the past 5 years is +1.5%.
The average ROA over the past 5 years is +10.14%.
The trend of ROA over the past 5 years is -2.41%.
The average ROE over the past 5 years is +20.67%.
The trend of ROE over the past 5 years is -5.78%.
Being debt the number one cause of investment losses and company death, the ratio Debt/FCF is of utmost importance to guarantee safety. On the other hand the Graham’s stability measures the drawdown of earnings, hence indicating the reliability of the flow generated by the company.
Years | 12-2015 | 12-2016 | 12-2017 | 12-2018 | 12-2019 | 12-2020 | 12-2021 | 12-2022 | 12-2023 | TTM |
---|---|---|---|---|---|---|---|---|---|---|
Debt FCF | 9.59 | 9.60 | 10.58 | 7.93 | 6.97 | 9.69 | 10.05 | 8.19 | 15.36 | 13.52 |
Debt Equity | 1.87 | 1.88 | 1.38 | 1.39 | 1.32 | 1.50 | 0.64 | 0.54 | 0.60 | 0.52 |
MIN | ||||||||||
Graham Stability | - | - | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% |
The Debt/FCF trailing twelve month is 13.52.
The trend of Debt/FCF over the past 5 years is 1.18.
Graham’s Stability measure stands at 1.00.
Growth can be dangerous when forecasting, simply projecting the current growth is in general wrong. A company passes through multiple phases, from being young and unprofitable, to the first periods of profitability and high growth, until it arrives at a period of regime with limited growth. Identifying in which phase the company is in may help forecasting.
Years | 12-2016 | 12-2018 | 12-2020 | 12-2022 | Trend |
---|---|---|---|---|---|
Revenue | 11% | 11% | 18% | 42% | 3.3% |
Net Income | 14% | 15% | 17% | 12% | 0.78% |
Stockholders Equity | 37% | 45% | 80% | 9.1% | 13% |
FCF | 9.1% | 7.5% | 14% | -35% | -1.4% |
The Revenue CAGR over the past 5 years is +11.41%.
The trend of Revenue growth rate over the past 5 years is +3.35%.
The Earnings CAGR over the past 5 years is +14.99%.
The trend of Earnings growth rate over the past 5 years is +0.78%.
The Equity CAGR over the past 5 years is +44.92%.
The trend of Equity growth rate over the past 5 years is +13.27%.
The FCF CAGR over the past 5 years is +7.53%.
The trend of FCF growth rate over the past 5 years is -1.44%.