|
Valoración de DCF de Mizuho Financial Group, Inc. (MFG)
JP | Financial Services | Banks - Regional | NYSE
|
- ✓ 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
Mizuho Financial Group, Inc. (MFG) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (MFG)! Utilizando datos reales de Mizuho Financial Group y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar Mizuho Financial Group, Inc. como un inversor experimentado.
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 | 15,717.7 | 16,657.7 | 17,170.7 | 17,238.5 | 19,788.7 | 20,988.3 | 22,260.7 | 23,610.1 | 25,041.4 | 26,559.5 |
Revenue Growth, % | 0 | 5.98 | 3.08 | 0.39445 | 14.79 | 6.06 | 6.06 | 6.06 | 6.06 | 6.06 |
EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Depreciation | 993.4 | 1,058.3 | 1,049.9 | 1,058.1 | 1,129.4 | 1,285.9 | 1,363.8 | 1,446.5 | 1,534.2 | 1,627.2 |
Depreciation, % | 6.32 | 6.35 | 6.11 | 6.14 | 5.71 | 6.13 | 6.13 | 6.13 | 6.13 | 6.13 |
EBIT | -993.4 | -1,058.3 | -1,049.9 | -1,058.1 | -1,129.4 | -1,285.9 | -1,363.8 | -1,446.5 | -1,534.2 | -1,627.2 |
EBIT, % | -6.32 | -6.35 | -6.11 | -6.14 | -5.71 | -6.13 | -6.13 | -6.13 | -6.13 | -6.13 |
Total Cash | 374,883.8 | 471,682.2 | 325,528.6 | 425,627.5 | 451,067.5 | 20,988.3 | 22,260.7 | 23,610.1 | 25,041.4 | 26,559.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4,083.2 | 4,478.1 | .0 | .0 | .0 | 2,218.9 | 2,353.5 | 2,496.1 | 2,647.5 | 2,807.9 |
Account Receivables, % | 25.98 | 26.88 | 0 | 0 | 0 | 10.57 | 10.57 | 10.57 | 10.57 | 10.57 |
Inventories | -538,083.2 | -544,364.9 | .0 | .0 | .0 | -8,395.3 | -8,904.3 | -9,444.1 | -10,016.6 | -10,623.8 |
Inventories, % | -3423.41 | -3267.96 | 0 | 0 | 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 | -1,501.2 | -1,370.4 | -882.7 | -1,161.0 | -1,629.0 | -1,590.3 | -1,686.7 | -1,789.0 | -1,897.4 | -2,012.4 |
Capital Expenditure, % | -9.55 | -8.23 | -5.14 | -6.74 | -8.23 | -7.58 | -7.58 | -7.58 | -7.58 | -7.58 |
Tax Rate, % | 28.9 | 28.9 | 28.9 | 28.9 | 28.9 | 28.9 | 28.9 | 28.9 | 28.9 | 28.9 |
EBITAT | -720.2 | -764.4 | -922.3 | -754.6 | -803.0 | -964.4 | -1,022.8 | -1,084.8 | -1,150.6 | -1,220.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 532,772.0 | 4,810.3 | -540,641.8 | -857.5 | -1,302.6 | 4,907.6 | -971.3 | -1,030.2 | -1,092.6 | -1,158.8 |
WACC, % | 16.07 | 16.01 | 19.36 | 15.82 | 15.77 | 16.61 | 16.61 | 16.61 | 16.61 | 16.61 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,716.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1,182 | |||||||||
Terminal Value | -8,092 | |||||||||
Present Terminal Value | -3,753 | |||||||||
Enterprise Value | -2,037 | |||||||||
Net Debt | -330,394 | |||||||||
Equity Value | 328,357 | |||||||||
Diluted Shares Outstanding, MM | 2,535 | |||||||||
Equity Value Per Share | 129.55 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled real MFG financials.
- Authentic Data: Historical data and projected estimates (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Mizuho’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Comprehensive MFG Data: Pre-filled with Mizuho Financial Group’s historical performance metrics and future projections.
- Fully Customizable Inputs: Modify parameters such as revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Develop various forecasting scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and tailored for both professionals and newcomers.
How It Works
- Download: Obtain the pre-built Excel file featuring Mizuho Financial Group, Inc.'s (MFG) financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose Mizuho Financial Group (MFG)?
- Save Time: Utilize our streamlined financial tools without starting from scratch.
- Enhance Accuracy: Dependable financial insights and calculations minimize valuation errors.
- Completely Customizable: Adjust the models to align with your unique assumptions and forecasts.
- User-Friendly: Intuitive graphs and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for industry experts who prioritize precision and efficiency.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive financial models for evaluating Mizuho Financial Group, Inc. (MFG).
- Corporate Finance Professionals: Assess valuation scenarios to inform strategic decisions within their organizations.
- Financial Consultants: Offer clients precise valuation analyses related to Mizuho Financial Group, Inc. (MFG).
- Academic Students and Instructors: Utilize current market data to enhance learning in financial modeling and analysis.
- Finance Enthusiasts: Gain insights into how financial institutions like Mizuho Financial Group, Inc. (MFG) are appraised in the industry.
What the Template Contains
- Pre-Filled DCF Model: Mizuho Financial Group’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Mizuho’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.