|
Nomura Holdings, Inc. (NMR) DCF Valuation
JP | Financial Services | Financial - Capital Markets | NYSE
|
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Nomura Holdings, Inc. (NMR) Bundle
Gain insights into your Nomura Holdings, Inc. (NMR) valuation analysis with our state-of-the-art DCF Calculator! Featuring built-in real (NMR) data, this Excel template enables you to adjust forecasts and assumptions for an accurate calculation of Nomura Holdings, Inc.'s intrinsic value.
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 | 6,802.5 | 7,887.2 | 7,252.2 | 7,295.5 | 9,904.5 | 11,000.3 | 12,217.3 | 13,568.9 | 15,070.1 | 16,737.3 |
Revenue Growth, % | 0 | 15.95 | -8.05 | 0.59665 | 35.76 | 11.06 | 11.06 | 11.06 | 11.06 | 11.06 |
EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Depreciation | 10,806.3 | 8,792.1 | 8,670.4 | 14,820.3 | 389.0 | 8,886.6 | 9,869.8 | 10,961.7 | 12,174.4 | 13,521.3 |
Depreciation, % | 158.86 | 111.47 | 119.56 | 203.14 | 3.93 | 80.79 | 80.79 | 80.79 | 80.79 | 80.79 |
EBIT | -10,806.3 | -8,792.1 | -8,670.4 | -14,820.3 | -389.0 | -8,886.6 | -9,869.8 | -10,961.7 | -12,174.4 | -13,521.3 |
EBIT, % | -158.86 | -111.47 | -119.56 | -203.14 | -3.93 | -80.79 | -80.79 | -80.79 | -80.79 | -80.79 |
Total Cash | 24,570.7 | 26,408.2 | 23,061.8 | 28,668.8 | 26,881.4 | 11,000.3 | 12,217.3 | 13,568.9 | 15,070.1 | 16,737.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 14,389.9 | 7,915.0 | 10,865.4 | 7,603.9 | 10,675.0 | 11,000.3 | 12,217.3 | 13,568.9 | 15,070.1 | 16,737.3 |
Account Receivables, % | 211.54 | 100.35 | 149.82 | 104.23 | 107.78 | 100 | 100 | 100 | 100 | 100 |
Inventories | 54,647.1 | 50,306.4 | 54,780.8 | 59,838.9 | .0 | 8,800.2 | 9,773.8 | 10,855.1 | 12,056.1 | 13,389.9 |
Inventories, % | 803.34 | 637.82 | 755.37 | 820.22 | 0 | 80 | 80 | 80 | 80 | 80 |
Accounts Payable | 9,304.9 | 9,224.5 | 9,657.0 | 8,623.3 | 8,311.8 | 10,646.5 | 11,824.4 | 13,132.5 | 14,585.4 | 16,199.0 |
Accounts Payable, % | 136.79 | 116.95 | 133.16 | 118.2 | 83.92 | 96.78 | 96.78 | 96.78 | 96.78 | 96.78 |
Capital Expenditure | -1,311.0 | -760.1 | -705.9 | -1,085.3 | -924.4 | -1,382.8 | -1,535.8 | -1,705.7 | -1,894.4 | -2,104.0 |
Capital Expenditure, % | -19.27 | -9.64 | -9.73 | -14.88 | -9.33 | -12.57 | -12.57 | -12.57 | -12.57 | -12.57 |
Tax Rate, % | 39.43 | 39.43 | 39.43 | 39.43 | 39.43 | 39.43 | 39.43 | 39.43 | 39.43 | 39.43 |
EBITAT | -9,445.5 | -5,836.1 | -5,470.9 | -9,199.7 | -235.6 | -6,034.5 | -6,702.1 | -7,443.6 | -8,267.1 | -9,181.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -59,682.2 | 12,931.1 | -4,498.7 | 1,705.0 | 55,685.3 | -5,321.5 | 619.2 | 687.7 | 763.7 | 848.2 |
WACC, % | 14.6 | 11.39 | 10.89 | 10.73 | 10.5 | 11.62 | 11.62 | 11.62 | 11.62 | 11.62 |
PV UFCF | ||||||||||
SUM PV UFCF | -2,794.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 865 | |||||||||
Terminal Value | 8,993 | |||||||||
Present Terminal Value | 5,190 | |||||||||
Enterprise Value | 2,396 | |||||||||
Net Debt | 56,655 | |||||||||
Equity Value | -54,260 | |||||||||
Diluted Shares Outstanding, MM | 3,145 | |||||||||
Equity Value Per Share | -17.26 |
What You Will Get
- Real NMR Financial Data: Pre-filled with Nomura Holdings’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Nomura Holdings’ 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
- Pre-Loaded Data: Nomura Holdings, Inc.’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: Observe Nomura’s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts showcase valuation results and essential metrics.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.
How It Works
- Download the Template: Gain immediate access to the Excel-based NMR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional variables.
- Instant Calculations: The model automatically recalculates Nomura’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Nomura Holdings, Inc. (NMR)?
- Accurate Data: Up-to-date Nomura financials provide trustworthy valuation results.
- 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 financial consultants.
- User-Friendly: Easy-to-navigate layout and clear instructions make it accessible for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing portfolios involving Nomura Holdings, Inc. (NMR).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Equip clients with precise valuation insights regarding Nomura Holdings, Inc. (NMR).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Finance Enthusiasts: Gain insights into how financial institutions like Nomura Holdings, Inc. (NMR) are valued in the market.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for Nomura Holdings, Inc. (NMR).
- Real-World Data: Nomura’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for deeper insights into Nomura's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.