|
The Bank of N.T. Butterfield & Son Limited (NTB) DCF Valuation
BM | Financial Services | Banks - Diversified | NYSE
|
- ✓ 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
The Bank of N.T. Butterfield & Son Limited (NTB) Bundle
Explore the financial prospects of The Bank of N.T. Butterfield & Son Limited (NTB) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to calculate the intrinsic value of (NTB) and refine your investment strategy.
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 | 532.5 | 502.7 | 496.5 | 551.7 | 583.2 | 597.8 | 612.7 | 628.1 | 643.8 | 659.9 |
| Revenue Growth, % | 0 | -5.6 | -1.23 | 11.12 | 5.71 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 |
| EBITDA | 224.1 | 212.0 | 235.2 | 257.9 | 262.5 | 267.1 | 273.8 | 280.6 | 287.6 | 294.8 |
| EBITDA, % | 42.08 | 42.18 | 47.38 | 46.74 | 45 | 44.68 | 44.68 | 44.68 | 44.68 | 44.68 |
| Depreciation | 48.4 | 62.4 | 69.5 | 40.2 | 36.2 | 58.6 | 60.0 | 61.5 | 63.1 | 64.7 |
| Depreciation, % | 9.09 | 12.42 | 13.99 | 7.28 | 6.21 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 |
| EBIT | 175.7 | 149.6 | 165.8 | 217.7 | 226.3 | 208.5 | 213.7 | 219.1 | 224.5 | 230.2 |
| EBIT, % | 33 | 29.76 | 33.39 | 39.46 | 38.79 | 34.88 | 34.88 | 34.88 | 34.88 | 34.88 |
| Total Cash | 3,768.0 | 4,113.0 | 3,379.0 | 2,985.0 | 2,285.8 | 597.8 | 612.7 | 628.1 | 643.8 | 659.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 23.6 | 162.0 | 158.0 | 217.0 | .0 | 128.9 | 132.1 | 135.4 | 138.8 | 142.3 |
| Account Receivables, % | 4.42 | 32.23 | 31.82 | 39.33 | 0 | 21.56 | 21.56 | 21.56 | 21.56 | 21.56 |
| Inventories | -3,945.6 | -4,329.7 | -3,483.4 | -3,062.8 | .0 | -478.2 | -490.2 | -502.5 | -515.0 | -527.9 |
| Inventories, % | -740.95 | -861.3 | -701.59 | -555.15 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 262.4 | 203.9 | 189.4 | 185.9 | .0 | 193.3 | 198.1 | 203.1 | 208.1 | 213.3 |
| Accounts Payable, % | 49.27 | 40.55 | 38.14 | 33.69 | 0 | 32.33 | 32.33 | 32.33 | 32.33 | 32.33 |
| Capital Expenditure | -22.8 | -20.6 | -15.7 | -26.9 | -54.3 | -30.7 | -31.5 | -32.3 | -33.1 | -33.9 |
| Capital Expenditure, % | -4.28 | -4.09 | -3.17 | -4.87 | -9.31 | -5.14 | -5.14 | -5.14 | -5.14 | -5.14 |
| Tax Rate, % | 0.33899 | 0.33899 | 0.33899 | 0.33899 | 0.33899 | 0.33899 | 0.33899 | 0.33899 | 0.33899 | 0.33899 |
| EBITAT | 177.1 | 147.2 | 162.7 | 214.0 | 225.5 | 206.2 | 211.4 | 216.7 | 222.1 | 227.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 4,387.1 | 376.3 | -640.5 | -255.8 | -2,824.2 | 776.7 | 253.5 | 259.8 | 266.3 | 273.0 |
| WACC, % | 18.75 | 18.6 | 18.57 | 18.59 | 18.71 | 18.64 | 18.64 | 18.64 | 18.64 | 18.64 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,240.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 278 | |||||||||
| Terminal Value | 1,673 | |||||||||
| Present Terminal Value | 712 | |||||||||
| Enterprise Value | 1,952 | |||||||||
| Net Debt | -1,548 | |||||||||
| Equity Value | 3,501 | |||||||||
| Diluted Shares Outstanding, MM | 49 | |||||||||
| Equity Value Per Share | 71.04 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real NTB financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect the valuation of The Bank of N.T. Butterfield & Son Limited (NTB).
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Financial Data: Access to The Bank of N.T. Butterfield & Son Limited's historical financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and net interest margins to fit your analysis.
- Real-Time Valuation: Instantly view The Bank of N.T. Butterfield & Son Limited's intrinsic value as it updates live.
- Intuitive Visualizations: User-friendly dashboard charts illustrate valuation outcomes and essential metrics.
- Precision Designed: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the pre-configured Excel file featuring The Bank of N.T. Butterfield & Son Limited’s (NTB) financial metrics.
- Customize: Modify projections such as interest income growth, net interest margin, and cost of equity.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly evaluate different outcomes.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for The Bank of N.T. Butterfield & Son Limited (NTB)?
- Accurate Data: Utilize real financial data from The Bank of N.T. Butterfield & Son Limited for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations streamline the process, allowing you to avoid starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and financial consultants.
- User-Friendly: With an intuitive design and clear step-by-step guidance, it's accessible for all users.
Who Should Use This Product?
- Investors: Accurately assess the fair value of The Bank of N.T. Butterfield & Son Limited (NTB) before making investment choices.
- CFOs: Utilize a top-tier DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire insights into the financial modeling practices of leading financial institutions.
- Educators: Employ it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Preloaded NTB Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.