Bank of Montreal (BMO) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Bank of Montreal (BMO) Bundle
Evaluate the financial outlook of Bank of Montreal (BMO) with expert precision! This (BMO) DCF Calculator provides pre-filled financial data and offers complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 17,357.7 | 18,664.5 | 18,213.7 | 20,129.4 | 22,224.1 | 23,670.8 | 25,211.6 | 26,852.7 | 28,600.7 | 30,462.4 |
| Revenue Growth, % | 0 | 7.53 | -2.42 | 10.52 | 10.41 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 |
| EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Depreciation | 985.6 | 988.4 | 960.0 | 1,455.9 | 1,463.5 | 1,423.2 | 1,515.9 | 1,614.5 | 1,719.6 | 1,831.6 |
| Depreciation, % | 5.68 | 5.3 | 5.27 | 7.23 | 6.59 | 6.01 | 6.01 | 6.01 | 6.01 | 6.01 |
| EBIT | -985.6 | -988.4 | -960.0 | -1,455.9 | -1,463.5 | -1,423.2 | -1,515.9 | -1,614.5 | -1,719.6 | -1,831.6 |
| EBIT, % | -5.68 | -5.3 | -5.27 | -7.23 | -6.59 | -6.01 | -6.01 | -6.01 | -6.01 | -6.01 |
| Total Cash | 66,058.6 | 84,601.7 | 81,990.3 | 79,287.2 | 78,745.5 | 23,670.8 | 25,211.6 | 26,852.7 | 28,600.7 | 30,462.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4,126.3 | 4,643.8 | 5,614.1 | 8,190.2 | 29,430.1 | 10,422.9 | 11,101.4 | 11,824.0 | 12,593.7 | 13,413.4 |
| Account Receivables, % | 23.77 | 24.88 | 30.82 | 40.69 | 132.42 | 44.03 | 44.03 | 44.03 | 44.03 | 44.03 |
| Inventories | -205,030.8 | -231,718.4 | -232,985.6 | .0 | .0 | -14,202.5 | -15,127.0 | -16,111.6 | -17,160.4 | -18,277.4 |
| Inventories, % | -1181.21 | -1241.49 | -1279.18 | 0 | 0 | -60 | -60 | -60 | -60 | -60 |
| Accounts Payable | 8,695.2 | 9,583.7 | 11,438.4 | 13,679.5 | 36,197.0 | 15,726.9 | 16,750.6 | 17,841.0 | 19,002.3 | 20,239.2 |
| Accounts Payable, % | 50.09 | 51.35 | 62.8 | 67.96 | 162.87 | 66.44 | 66.44 | 66.44 | 66.44 | 66.44 |
| Capital Expenditure | -715.8 | -681.8 | -1,004.4 | -613.9 | -1,084.8 | -1,004.7 | -1,070.1 | -1,139.7 | -1,213.9 | -1,292.9 |
| Capital Expenditure, % | -4.12 | -3.65 | -5.51 | -3.05 | -4.88 | -4.24 | -4.24 | -4.24 | -4.24 | -4.24 |
| Tax Rate, % | 23.25 | 23.25 | 23.25 | 23.25 | 23.25 | 23.25 | 23.25 | 23.25 | 23.25 | 23.25 |
| EBITAT | -791.4 | -747.1 | -726.5 | -1,083.9 | -1,123.2 | -1,089.5 | -1,160.4 | -1,236.0 | -1,316.4 | -1,402.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 209,078.1 | 26,618.1 | 1,380.7 | -233,562.5 | 533.1 | 12,068.5 | 555.1 | 591.2 | 629.7 | 670.7 |
| WACC, % | 13.03 | 12.43 | 12.44 | 12.28 | 12.57 | 12.55 | 12.55 | 12.55 | 12.55 | 12.55 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 12,339.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 684 | |||||||||
| Terminal Value | 6,485 | |||||||||
| Present Terminal Value | 3,591 | |||||||||
| Enterprise Value | 15,930 | |||||||||
| Net Debt | 134,355 | |||||||||
| Equity Value | -118,425 | |||||||||
| Diluted Shares Outstanding, MM | 729 | |||||||||
| Equity Value Per Share | -162.55 |
What You Will Receive
- Adjustable Forecast Parameters: Effortlessly modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Financial Data: Bank of Montreal’s (BMO) financial information pre-loaded to accelerate your analysis.
- Instant DCF Calculations: The template automatically computes Net Present Value (NPV) and intrinsic value for you.
- Tailored and Professional Design: A sleek Excel model that can be customized to fit your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life BMO Financials: Pre-filled historical and projected data for Bank of Montreal (BMO).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Bank of Montreal’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Bank of Montreal’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing Bank of Montreal's (BMO) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Immediately: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Analyze different valuation outcomes by comparing multiple forecasts.
- 5. Utilize with Assurance: Present expert valuation insights to bolster your decision-making process.
Why Choose This Calculator for Bank of Montreal (BMO)?
- Accurate Data: Up-to-date Bank of Montreal financials provide trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from square one.
- Professional-Grade Tool: Tailored for investors, analysts, and financial consultants.
- User-Friendly: An intuitive design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Finance Students: Understand financial modeling and apply it using real data from Bank of Montreal (BMO).
- Academics: Integrate industry-standard models into your teaching or research involving Bank of Montreal (BMO).
- Investors: Validate your investment strategies and evaluate valuation scenarios for Bank of Montreal (BMO) stock.
- Analysts: Enhance your analysis process with a customizable financial model tailored for Bank of Montreal (BMO).
- Small Business Owners: Learn from the valuation techniques used for large institutions like Bank of Montreal (BMO).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Bank of Montreal (BMO) 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 such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models demonstrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Bank of Montreal (BMO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.