The Toronto-Dominion Bank (TD) 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
The Toronto-Dominion Bank (TD) Bundle
Whether you’re an investor or analyst, this (TD) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from The Toronto-Dominion Bank, you can adjust forecasts and observe the effects in real-time.
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 | 30,043.7 | 29,337.1 | 31,763.7 | 34,150.8 | 38,831.8 | 41,466.7 | 44,280.4 | 47,285.0 | 50,493.4 | 53,919.6 |
Revenue Growth, % | 0 | -2.35 | 8.27 | 7.51 | 13.71 | 6.79 | 6.79 | 6.79 | 6.79 | 6.79 |
EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Depreciation | 1,486.1 | 1,434.0 | 1,225.8 | 1,326.4 | 1,407.0 | 1,758.3 | 1,877.6 | 2,005.0 | 2,141.0 | 2,286.3 |
Depreciation, % | 4.95 | 4.89 | 3.86 | 3.88 | 3.62 | 4.24 | 4.24 | 4.24 | 4.24 | 4.24 |
EBIT | -1,486.1 | -1,434.0 | -1,225.8 | -1,326.4 | -1,407.0 | -1,758.3 | -1,877.6 | -2,005.0 | -2,141.0 | -2,286.3 |
EBIT, % | -4.95 | -4.89 | -3.86 | -3.88 | -3.62 | -4.24 | -4.24 | -4.24 | -4.24 | -4.24 |
Total Cash | 190,101.3 | 145,414.0 | 124,718.5 | 95,955.4 | 159,985.4 | 41,466.7 | 44,280.4 | 47,285.0 | 50,493.4 | 53,919.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 34,275.0 | 31,622.8 | 27,989.9 | 37,917.0 | 30,968.3 | 38,801.9 | 41,434.8 | 44,246.3 | 47,248.6 | 50,454.6 |
Account Receivables, % | 114.08 | 107.79 | 88.12 | 111.03 | 79.75 | 93.57 | 93.57 | 93.57 | 93.57 | 93.57 |
Inventories | -409,234.4 | -406,075.5 | -410,974.5 | .0 | .0 | -24,880.0 | -26,568.2 | -28,371.0 | -30,296.1 | -32,351.8 |
Inventories, % | -1362.13 | -1384.17 | -1293.85 | 0 | 0 | -60 | -60 | -60 | -60 | -60 |
Accounts Payable | 29,746.7 | 25,824.9 | 22,284.3 | 30,267.9 | 27,669.2 | 34,589.9 | 36,936.9 | 39,443.2 | 42,119.6 | 44,977.6 |
Accounts Payable, % | 99.01 | 88.03 | 70.16 | 88.63 | 71.25 | 83.42 | 83.42 | 83.42 | 83.42 | 83.42 |
Capital Expenditure | -875.3 | -783.6 | -1,009.2 | -1,279.9 | -1,511.1 | -1,360.2 | -1,452.5 | -1,551.0 | -1,656.3 | -1,768.7 |
Capital Expenditure, % | -2.91 | -2.67 | -3.18 | -3.75 | -3.89 | -3.28 | -3.28 | -3.28 | -3.28 | -3.28 |
Tax Rate, % | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 | 18.36 |
EBITAT | -1,483.7 | -1,196.7 | -1,046.0 | -1,025.2 | -1,148.7 | -1,503.5 | -1,605.5 | -1,714.5 | -1,830.8 | -1,955.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 403,833.1 | -4,974.7 | 4,161.8 | -413,896.7 | 3,097.2 | 22,861.6 | 221.9 | 237.0 | 253.1 | 270.3 |
WACC, % | 12.44 | 10.7 | 10.9 | 10.05 | 10.51 | 10.92 | 10.92 | 10.92 | 10.92 | 10.92 |
PV UFCF | ||||||||||
SUM PV UFCF | 21,292.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 276 | |||||||||
Terminal Value | 3,089 | |||||||||
Present Terminal Value | 1,840 | |||||||||
Enterprise Value | 23,132 | |||||||||
Net Debt | 196,182 | |||||||||
Equity Value | -173,050 | |||||||||
Diluted Shares Outstanding, MM | 1,760 | |||||||||
Equity Value Per Share | -98.32 |
What You Will Get
- Real TD Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess TD's future performance.
- User-Friendly Interface: Designed for professionals while remaining easy to navigate for newcomers.
Key Features
- Pre-Loaded Data: The Toronto-Dominion Bank's (TD) historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: View The Toronto-Dominion Bank's (TD) intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and essential metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Step 1: Download the prebuilt Excel template featuring Toronto-Dominion Bank’s (TD) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the key financial metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Toronto-Dominion Bank’s (TD) intrinsic value.
- Step 5: Use the outputs to make informed investment decisions or create reports.
Why Choose This Calculator for The Toronto-Dominion Bank (TD)?
- Accurate Data: Utilize real financials from The Toronto-Dominion Bank (TD) 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 save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the financial sector.
- User-Friendly: An intuitive design and guided instructions make it accessible for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling TD stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for TD (TD).
- Consultants: Deliver professional valuation insights regarding TD (TD) to clients quickly and accurately.
- Business Owners: Understand how major banks like TD (TD) are valued to guide your own business strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to TD (TD).
What the Template Contains
- Preloaded TD Data: Historical and projected financial data, including revenue, net income, and loan growth.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting interest rates, growth projections, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for in-depth analysis.
- Key Ratios: Profitability, liquidity, and efficiency ratios to assess performance.
- Dashboard and Charts: Visual summaries of valuation results and key assumptions.