M&T Bank Corporation (MTB) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
M&T Bank Corporation (MTB) Bundle
Evaluate M&T Bank Corporation's financial outlook like an expert! This MTB DCF Calculator provides you with pre-filled financial data and the ability to customize revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 6,191.9 | 5,954.8 | 5,991.8 | 8,042.6 | 8,998.0 | 9,963.0 | 11,031.5 | 12,214.5 | 13,524.4 | 14,974.9 |
Revenue Growth, % | 0 | -3.83 | 0.62154 | 34.23 | 11.88 | 10.72 | 10.72 | 10.72 | 10.72 | 10.72 |
EBITDA | 2,743.4 | 1,955.1 | 2,687.0 | 2,906.7 | .0 | 3,150.8 | 3,488.7 | 3,862.8 | 4,277.1 | 4,735.8 |
EBITDA, % | 44.31 | 32.83 | 44.84 | 36.14 | 0 | 31.62 | 31.62 | 31.62 | 31.62 | 31.62 |
Depreciation | 229.4 | 235.5 | 234.4 | 337.7 | .0 | 314.3 | 348.0 | 385.3 | 426.6 | 472.3 |
Depreciation, % | 3.71 | 3.95 | 3.91 | 4.2 | 0 | 3.15 | 3.15 | 3.15 | 3.15 | 3.15 |
EBIT | 2,513.9 | 1,719.7 | 2,452.5 | 2,569.0 | .0 | 2,836.5 | 3,140.7 | 3,477.6 | 3,850.5 | 4,263.5 |
EBIT, % | 40.6 | 28.88 | 40.93 | 31.94 | 0 | 28.47 | 28.47 | 28.47 | 28.47 | 28.47 |
Total Cash | 9,451.5 | 25,722.2 | 43,655.7 | 51,686.8 | 28,628.0 | 9,963.0 | 11,031.5 | 12,214.5 | 13,524.4 | 14,974.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | 8,184.9 | .0 | .0 | 1,992.6 | 2,206.3 | 2,442.9 | 2,704.9 | 2,995.0 |
Account Receivables, % | 0 | 0 | 136.6 | 0 | 0 | 20 | 20 | 20 | 20 | 20 |
Inventories | -9,158.6 | -26,218.1 | -44,081.1 | -11,512.1 | .0 | -7,970.4 | -8,825.2 | -9,771.6 | -10,819.6 | -11,979.9 |
Inventories, % | -147.91 | -440.29 | -735.69 | -143.14 | 0 | -80 | -80 | -80 | -80 | -80 |
Accounts Payable | 2,337.5 | 2,166.4 | 2,127.9 | 4,377.0 | 4,516.0 | 4,269.3 | 4,727.1 | 5,234.1 | 5,795.4 | 6,417.0 |
Accounts Payable, % | 37.75 | 36.38 | 35.51 | 54.42 | 50.19 | 42.85 | 42.85 | 42.85 | 42.85 | 42.85 |
Capital Expenditure | -178.0 | -172.3 | -149.2 | -214.4 | -256.0 | -274.4 | -303.8 | -336.4 | -372.5 | -412.4 |
Capital Expenditure, % | -2.88 | -2.89 | -2.49 | -2.67 | -2.85 | -2.75 | -2.75 | -2.75 | -2.75 | -2.75 |
Tax Rate, % | 24.26 | 24.26 | 24.26 | 24.26 | 24.26 | 24.26 | 24.26 | 24.26 | 24.26 | 24.26 |
EBITAT | 1,903.9 | 1,315.0 | 1,857.0 | 1,959.9 | .0 | 2,155.5 | 2,386.7 | 2,642.6 | 2,926.0 | 3,239.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 13,451.4 | 18,266.7 | 11,581.8 | -20,051.8 | -11,629.1 | 7,926.4 | 3,529.7 | 3,908.3 | 4,327.4 | 4,791.5 |
WACC, % | 10.83 | 10.88 | 10.83 | 10.87 | 10.83 | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 |
PV UFCF | ||||||||||
SUM PV UFCF | 18,621.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 4,887 | |||||||||
Terminal Value | 55,230 | |||||||||
Present Terminal Value | 33,000 | |||||||||
Enterprise Value | 51,622 | |||||||||
Net Debt | -16,599 | |||||||||
Equity Value | 68,221 | |||||||||
Diluted Shares Outstanding, MM | 167 | |||||||||
Equity Value Per Share | 408.50 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real MTB financials.
- Authentic Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Adaptability: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect M&T Bank's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Layout: Organized for clarity and ease of use, complete with step-by-step guidance.
Key Features
- 🔍 Real-Life MTB Financials: Pre-filled historical and projected data for M&T Bank Corporation (MTB).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate M&T Bank's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize M&T Bank'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 featuring M&T Bank Corporation’s (MTB) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results in Real-Time: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
- 5. Utilize with Assurance: Deliver professional valuation insights to enhance your decision-making.
Why Choose This Calculator for M&T Bank Corporation (MTB)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for M&T Bank.
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes M&T Bank’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide a solid foundation for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focused on M&T Bank.
Who Should Use M&T Bank Corporation (MTB) Services?
- Investors: Gain insights and make informed decisions with M&T's comprehensive financial solutions.
- Financial Analysts: Streamline your analysis with M&T's robust data and analytics tools tailored for your needs.
- Consultants: Efficiently customize M&T's resources for client presentations or strategic reports.
- Finance Enthusiasts: Enhance your knowledge of banking services and market trends with M&T's expert insights.
- Educators and Students: Utilize M&T's resources as a practical guide in finance and banking coursework.
What the Template Contains
- Historical Data: Includes M&T Bank Corporation’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate M&T Bank Corporation’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of M&T Bank Corporation’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.