NMI Holdings, Inc. (NMIH) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
NMI Holdings, Inc. (NMIH) Bundle
Whether you’re an investor or an analyst, this NMI Holdings, Inc. (NMIH) DCF Calculator is your go-to tool for accurate valuation. Preloaded with real data from NMI Holdings, Inc., you can adjust forecasts and instantly observe the effects.
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 | 370.1 | 436.2 | 485.6 | 524.5 | 579.0 | 647.9 | 725.0 | 811.2 | 907.7 | 1,015.7 |
Revenue Growth, % | 0 | 17.85 | 11.34 | 7.99 | 10.4 | 11.9 | 11.9 | 11.9 | 11.9 | 11.9 |
EBITDA | 238.0 | 252.4 | 339.8 | 421.3 | 456.5 | 455.2 | 509.4 | 570.0 | 637.8 | 713.6 |
EBITDA, % | 64.31 | 57.87 | 69.96 | 80.34 | 78.83 | 70.26 | 70.26 | 70.26 | 70.26 | 70.26 |
Depreciation | 9.3 | 9.9 | 11.2 | 11.9 | 11.5 | 14.7 | 16.5 | 18.4 | 20.6 | 23.1 |
Depreciation, % | 2.51 | 2.28 | 2.31 | 2.26 | 1.99 | 2.27 | 2.27 | 2.27 | 2.27 | 2.27 |
EBIT | 228.7 | 242.5 | 328.5 | 409.5 | 444.9 | 440.5 | 492.9 | 551.5 | 617.2 | 690.6 |
EBIT, % | 61.8 | 55.59 | 67.65 | 78.07 | 76.84 | 67.99 | 67.99 | 67.99 | 67.99 | 67.99 |
Total Cash | 1,179.4 | 1,925.7 | 2,159.4 | 2,141.6 | 333.3 | 592.9 | 663.4 | 742.3 | 830.6 | 929.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 46.1 | 67.4 | 80.7 | 91.3 | 104.0 | 103.5 | 115.8 | 129.6 | 145.0 | 162.2 |
Account Receivables, % | 12.45 | 15.45 | 16.61 | 17.4 | 17.96 | 15.97 | 15.97 | 15.97 | 15.97 | 15.97 |
Inventories | -244.2 | -294.2 | -323.8 | -796.6 | .0 | -388.9 | -435.1 | -486.9 | -544.8 | -609.6 |
Inventories, % | -65.99 | -67.45 | -66.68 | -151.89 | 0 | -60.02 | -60.02 | -60.02 | -60.02 | -60.02 |
Accounts Payable | .0 | .0 | .0 | .0 | 86.2 | 19.3 | 21.6 | 24.2 | 27.0 | 30.2 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 14.89 | 2.98 | 2.98 | 2.98 | 2.98 | 2.98 |
Capital Expenditure | -10.0 | -12.2 | -12.2 | -10.6 | -9.4 | -15.1 | -16.9 | -18.9 | -21.1 | -23.6 |
Capital Expenditure, % | -2.69 | -2.79 | -2.52 | -2.02 | -1.62 | -2.33 | -2.33 | -2.33 | -2.33 | -2.33 |
Tax Rate, % | 21.95 | 21.95 | 21.95 | 21.95 | 21.95 | 21.95 | 21.95 | 21.95 | 21.95 | 21.95 |
EBITAT | 181.5 | 190.7 | 255.9 | 317.9 | 347.3 | 345.0 | 386.0 | 432.0 | 483.4 | 540.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 379.0 | 217.2 | 271.2 | 781.3 | -373.7 | 667.1 | 421.9 | 472.1 | 528.2 | 591.1 |
WACC, % | 9.4 | 9.4 | 9.39 | 9.39 | 9.39 | 9.39 | 9.39 | 9.39 | 9.39 | 9.39 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,069.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 603 | |||||||||
Terminal Value | 8,153 | |||||||||
Present Terminal Value | 5,204 | |||||||||
Enterprise Value | 7,273 | |||||||||
Net Debt | 302 | |||||||||
Equity Value | 6,971 | |||||||||
Diluted Shares Outstanding, MM | 84 | |||||||||
Equity Value Per Share | 83.13 |
What You Will Get
- Real NMIH Financial Data: Pre-filled with NMI 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 NMI 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
- 🔍 Real-Life NMIH Financials: Pre-filled historical and projected data for NMI Holdings, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate NMIH’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize NMIH’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered NMI Holdings, Inc. (NMIH) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for NMI Holdings, Inc. (NMIH)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for NMI Holdings, Inc. (NMIH)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for NMIH.
- Flexible Inputs: Modify the highlighted fields to explore different financial scenarios for NMI Holdings.
- In-Depth Analysis: Automatically computes NMIH’s intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data for precise calculations.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focusing on NMIH.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing NMI Holdings, Inc. (NMIH).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in NMI Holdings, Inc. (NMIH).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Real Estate Professionals: Gain insights into how companies like NMI Holdings, Inc. (NMIH) are valued in the mortgage insurance market.
What the Template Contains
- Pre-Filled Data: Includes NMI Holdings, Inc.'s 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 NMI Holdings, Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.