EFTA01371090
EFTA01371091 DataSet-10
EFTA01371092

EFTA01371091.pdf

DataSet-10 1 page 421 words document
P24 V16 D6
Open PDF directly ↗ View extracted text
👁 1 💬 0
📄 Extracted Text (421 words)
31 October 2017 Railroads Canadian Rails I Figure 1 I: Our DCF framework for CP translates to an implied PIE multiple of 7.5>. Terminal CP DCF Framework 2016 2012E 2018E 2019E 2020E 2021E 2022E 2023E 2014E 2025E atn. Gross Revenue 7.556 7,858 8.172 8,499 8.839 9.193 9.537 YoY Change (%) 5.0% 4.4% 64% 4.0% 4.0% 4.0% 4.0% 4.0% 4.0% 3.75% EMT 2,747 2,860 3 'lab 3.400 3,536 3,678 3,825 3,978 4.137 4,292 % margin 42.4% 42.0% 43.3% 44.4% 45.0% 45.0% 45.0% 450% 45.0% 45.0% 45.0% IrnpIkO Off OSIMerest 22 23 24 25 26 27 29 30 31 32 33 EBET • Interest adjustment 2,600 2,770 2,984 3,251 3.426 3,564 3,706 3$54 4,006 4,169 4,325 % margin 41.7% 42.3% 43.7% 44.8% 453% 45.3% 45.3% 45.3% 45.3% 45.3% 45.3% Cash tat rate Oil j -• ; . . -, Cl. 166% 183% 19.9% 21.6% 23.2% 24.9% 26,5% Unlevered Free Cash now NOPAT 1,995 2,355 2,536 2,764 2,856 2,912 2,967 3,023 3,078 3,133 3,179 % of revenue 32.0% 36.0% 37.1% 38.0% 37.8% 37.1% 36.3% 35.6% 34.8% 344% 33.3% D&A 640 680 683 719 758 789 822 856 891 928 963 % of reeenue MI% 10.1% 10.0% 10.0% 10.0% 10.0% 10.1% 101% 10.1% 10.1% 101% Net Caper (1.005) Et ":‘25} (1.417) (1.478) 11441) (1.607) (1,675) (1.7471 aim % of revenue 417.1%) OS 9%) (18.7%) (18.7%1 (18.8%) (18.8%) (18.9%) 08.9%) (19.0%) (19.0%) (19.0%) Working capital • 0 0 0 0 0 0 0 Unlevered FCE 1,514.0 1,790.1 1,934.1 2,1652 2,1963 2,223.0 2,2483 2272.1 2,2942 2,314.4 2,330.1 Time factor . •. 1.0 Discount factor 100.0% 9274 8589: 79.5% 237% 683% 63.3% 58.6% 58.6% PV of cash flews 2,006.1 1.8855 1.268.2 1.656.9 1,551.4 1,451.4 L356.6 31.673.6 tdalirstillthstIss sA her As m• Don NPV 44.356 Revenue growth 2020-2025 4.0% Net Debt (3Q'17) Ternunal revenue growth 3.75% PV of Operating leases 2C3 Terminal MIT Margin 450% 4-Reached by 2020 Implied Equity Value 36,077 Terminal The Rate 26.5% 41:1'18e Sharecount Terminal O&A (% of rev.) 10.1% USD/CAD 5t.25 Terminal Capra OS of rev.) (19.0%) ImplbO Share Price $209 Translates to - 17,5x our 2029 EPS estimate Tg.ttttttgct.tttttt — tra;ttttttrattt, Historical RFR 2.35% Equity Risk Premium (EPP) 7.00% Beta itl Cost ol equity 9.4% WACD Tax rate 265% Cost ol debt 40% % equity % debt 28% WACC 7.9% some peat** &lee Ccerviry aag4 leaSer While our DCF framework for CNI translates to an implied P/E multiple of 15.5x our 2019 EPS estimate. Deutsche Bank Securities Inc Page 7 CONFIDENTIAL - PURSUANT TO FED. R. CRIM. P. 6(e) DB-SDNY-0064277 CONFIDENTIAL SDNY_GM_00210461 EFTA01371091
ℹ️ Document Details
SHA-256
d7844e6f2d4fd7c95eec4ee19aea89fd05637246c3c71229876285f7b8d9c7a0
Bates Number
EFTA01371091
Dataset
DataSet-10
Document Type
document
Pages
1

Comments 0

Loading comments…
Link copied!