Canadian Pacific Railway Limited (CP) DCF Valuation

Canadian Pacific Railway Limited (CP) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

Canadian Pacific Railway Limited (CP) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Whether you’re an investor or analyst, this (CP) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Canadian Pacific Railway Limited, you can adjust forecasts and view the effects in real time.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2019		 AY2
2020		 AY3
2021		 AY4
2022		 AY5
2023		 FY1
2024		 FY2
2025		 FY3
2026		 FY4
2027		 FY5
2028
Revenue 5,408.5 5,351.6 5,549.4 6,117.9 8,714.6 9,920.1 11,292.3 12,854.4 14,632.5 16,656.6
Revenue Growth, % 0 -1.05 3.7 10.24 42.44 13.83 13.83 13.83 13.83 13.83
EBITDA 2,986.8 3,084.6 3,366.4 3,181.8 -512.9 4,357.8 4,960.7 5,646.9 6,428.0 7,317.2
EBITDA, % 55.22 57.64 60.66 52.01 -5.89 43.93 43.93 43.93 43.93 43.93
Depreciation 494.2 547.7 569.9 597.6 1,071.0 1,025.7 1,167.6 1,329.1 1,513.0 1,722.2
Depreciation, % 9.14 10.23 10.27 9.77 12.29 10.34 10.34 10.34 10.34 10.34
EBIT 2,492.6 2,537.0 2,796.6 2,584.2 -1,584.0 3,332.1 3,793.1 4,317.8 4,915.0 5,594.9
EBIT, % 46.09 47.41 50.39 42.24 -18.18 33.59 33.59 33.59 33.59 33.59
Total Cash 92.3 102.0 47.9 313.0 322.1 263.7 300.1 341.6 388.9 442.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 558.8 572.6 568.5 705.2 1,038.4
Account Receivables, % 10.33 10.7 10.24 11.53 11.92
Inventories 126.3 144.4 163.1 197.1 277.6 285.3 324.8 369.7 420.9 479.1
Inventories, % 2.34 2.7 2.94 3.22 3.19 2.88 2.88 2.88 2.88 2.88
Accounts Payable 314.4 278.3 299.9 349.1 472.0 546.4 622.0 708.0 806.0 917.5
Accounts Payable, % 5.81 5.2 5.4 5.71 5.42 5.51 5.51 5.51 5.51 5.51
Capital Expenditure -1,143.2 -1,159.9 -1,063.4 -1,080.7 -1,734.6 -1,974.9 -2,248.1 -2,559.1 -2,913.1 -3,316.1
Capital Expenditure, % -21.14 -21.67 -19.16 -17.67 -19.9 -19.91 -19.91 -19.91 -19.91 -19.91
Tax Rate, % 228.63 228.63 228.63 228.63 228.63 228.63 228.63 228.63 228.63 228.63
EBITAT 1,933.2 1,936.4 2,203.3 2,192.7 2,037.4 2,116.0 2,408.7 2,741.9 3,121.2 3,553.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 913.5 1,256.2 1,716.7 1,588.1 1,083.0 1,186.3 1,214.2 1,382.1 1,573.3 1,791.0
WACC, % 7.28 7.27 7.29 7.34 6.62 7.16 7.16 7.16 7.16 7.16
PV UFCF
SUM PV UFCF 5,748.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 1,827
Terminal Value 35,403
Present Terminal Value 25,054
Enterprise Value 30,802
Net Debt 15,530
Equity Value 15,272
Diluted Shares Outstanding, MM 934
Equity Value Per Share 16.36

What You Will Get

  • Pre-Filled Financial Model: Canadian Pacific Railway Limited's (CP) actual data enables precise DCF valuation.
  • Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers specific to (CP).
  • Instant Calculations: Automatic updates ensure you see results as you make changes to (CP).
  • Investor-Ready Template: A refined Excel file designed for professional-grade valuation of (CP).
  • Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts related to (CP).

Key Features

  • Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Canadian Pacific Railway Limited (CP).
  • WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to the railway industry.
  • Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit CP's financial outlook.
  • Integrated Financial Ratios: Assess profitability, leverage, and efficiency ratios specifically for Canadian Pacific Railway Limited (CP).
  • Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Canadian Pacific Railway Limited’s (CP) preloaded data.
  • 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
  • 3. See Results in Real-Time: The DCF model automatically calculates the intrinsic value and NPV.
  • 4. Explore Different Scenarios: Evaluate various forecasts to understand different valuation possibilities.
  • 5. Present with Assurance: Deliver professional valuation insights to back your strategic decisions.

Why Choose This Calculator for Canadian Pacific Railway Limited (CP)?

  • Comprehensive Tool: Features DCF, WACC, and financial ratio analyses all in one platform.
  • Customizable Inputs: Modify yellow-highlighted cells to explore different scenarios.
  • Detailed Insights: Automatically computes Canadian Pacific Railway’s intrinsic value and Net Present Value.
  • Preloaded Data: Historical and projected data provide reliable starting points for analysis.
  • Professional Quality: Perfect for financial analysts, investors, and business consultants focused on (CP).

Who Should Use This Product?

  • Professional Investors: Develop comprehensive and accurate valuation models for portfolio management related to Canadian Pacific Railway Limited (CP).
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
  • Consultants and Advisors: Deliver precise valuation insights to clients interested in Canadian Pacific Railway Limited (CP) stock.
  • Students and Educators: Utilize real-world data for practicing and teaching financial modeling techniques.
  • Transportation Enthusiasts: Gain insights into how transportation companies like Canadian Pacific Railway Limited (CP) are valued in the market.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Canadian Pacific Railway Limited (CP) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Canadian Pacific Railway Limited (CP).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.