|
Valoración de DCF de Washington Federal, Inc. (WAFD)
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ 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
Washington Federal, Inc. (WAFD) Bundle
¡Descubra el verdadero valor de Washington Federal, Inc. (WAFD) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe los efectos de los cambios en la valoración de Washington Federal, Inc. (WAFD), todo dentro de una sola plantilla de Excel.
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 | 556.5 | 566.1 | 661.6 | 742.6 | 60.7 | 51.4 | 43.6 | 36.9 | 31.3 | 26.5 |
| Revenue Growth, % | 0 | 1.73 | 16.87 | 12.24 | -91.83 | -15.25 | -15.25 | -15.25 | -15.25 | -15.25 |
| EBITDA | 259.1 | 267.1 | 364.1 | 348.0 | .0 | 20.1 | 17.1 | 14.5 | 12.3 | 10.4 |
| EBITDA, % | 46.56 | 47.17 | 55.03 | 46.87 | 0 | 39.13 | 39.13 | 39.13 | 39.13 | 39.13 |
| Depreciation | 39.9 | 33.9 | 64.1 | 23.0 | 134.1 | 13.0 | 11.0 | 9.3 | 7.9 | 6.7 |
| Depreciation, % | 7.17 | 5.99 | 9.68 | 3.09 | 220.96 | 25.19 | 25.19 | 25.19 | 25.19 | 25.19 |
| EBIT | 219.2 | 233.1 | 300.0 | 325.1 | -134.1 | 7.2 | 6.1 | 5.2 | 4.4 | 3.7 |
| EBIT, % | 39.39 | 41.18 | 45.35 | 43.77 | -220.96 | 13.94 | 13.94 | 13.94 | 13.94 | 13.94 |
| Total Cash | 3,952.5 | 4,229.1 | .0 | 2,975.7 | 26.0 | 35.3 | 29.9 | 25.3 | 21.5 | 18.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | -1,767.7 | -2,159.7 | 15,292.3 | -1,085.5 | .0 | -20.6 | -17.4 | -14.8 | -12.5 | -10.6 |
| Inventories, % | -317.66 | -381.51 | 2311.36 | -146.17 | 0 | -40 | -40 | -40 | -40 | -40 |
| Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | -31.9 | -29.5 | -11.8 | -15.1 | .0 | -1.5 | -1.3 | -1.1 | -.9 | -.8 |
| Capital Expenditure, % | -5.74 | -5.21 | -1.78 | -2.03 | 0 | -2.95 | -2.95 | -2.95 | -2.95 | -2.95 |
| Tax Rate, % | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 |
| EBITAT | 173.4 | 183.6 | 236.3 | 257.4 | -104.8 | 5.6 | 4.8 | 4.1 | 3.4 | 2.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,949.2 | 580.0 | -17,163.4 | 16,643.1 | -1,056.2 | 37.7 | 11.3 | 9.6 | 8.1 | 6.9 |
| WACC, % | 13.31 | 13.27 | 13.27 | 13.32 | 13.19 | 13.27 | 13.27 | 13.27 | 13.27 | 13.27 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 57.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 7 | |||||||||
| Terminal Value | 63 | |||||||||
| Present Terminal Value | 34 | |||||||||
| Enterprise Value | 91 | |||||||||
| Net Debt | 937 | |||||||||
| Equity Value | -846 | |||||||||
| Diluted Shares Outstanding, MM | 74 | |||||||||
| Equity Value Per Share | -11.39 |
What You Will Get
- Real WAFD Financial Data: Pre-filled with Washington Federal's historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Washington Federal’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive WAFD Data: Pre-loaded with Washington Federal's historical financial performance and future projections.
- Fully Customizable Variables: Modify key inputs such as loan growth, interest margins, capital ratios, and operating expenses.
- Dynamic Valuation Framework: Instant updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation results.
- User-Centric Interface: Intuitive, organized, and tailored for both industry experts and newcomers.
How It Works
- Download: Get the pre-prepared Excel file featuring Washington Federal, Inc.'s (WAFD) financial data.
- Customize: Modify projections, including loan growth, net interest margin, and cost of capital.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose Washington Federal, Inc. (WAFD)?
- Time Efficiency: Access a comprehensive banking solution without the hassle of setup.
- Enhanced Precision: Dependable financial insights and tools minimize errors in your banking needs.
- Customizable Solutions: Adjust services to align with your financial goals and expectations.
- User-Friendly Interface: Intuitive design and clear information make banking straightforward.
- Endorsed by Professionals: Preferred choice for those who prioritize accuracy and convenience.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Washington Federal, Inc. (WAFD) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Washington Federal, Inc. (WAFD).
- Consultants: Deliver professional valuation insights on Washington Federal, Inc. (WAFD) to clients quickly and accurately.
- Business Owners: Understand how financial institutions like Washington Federal, Inc. (WAFD) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Washington Federal, Inc. (WAFD).
What the Template Contains
- Pre-Filled Data: Includes Washington Federal, Inc.'s (WAFD) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Washington Federal, Inc.'s (WAFD) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.