NorthWestern Corporation (NWE) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
NorthWestern Corporation (NWE) Bundle
Explore NorthWestern Corporation's (NWE) financial potential with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate NorthWestern Corporation's (NWE) intrinsic value and enhance your investment strategy.
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 | 1,257.9 | 1,198.7 | 1,372.3 | 1,477.8 | 1,422.1 | 1,470.8 | 1,521.2 | 1,573.3 | 1,627.2 | 1,682.9 |
| Revenue Growth, % | 0 | -4.71 | 14.49 | 7.69 | -3.77 | 3.42 | 3.42 | 3.42 | 3.42 | 3.42 |
| EBITDA | 442.2 | 416.2 | 456.9 | 466.6 | 526.1 | 505.2 | 522.5 | 540.4 | 558.9 | 578.0 |
| EBITDA, % | 35.15 | 34.72 | 33.3 | 31.57 | 37 | 34.35 | 34.35 | 34.35 | 34.35 | 34.35 |
| Depreciation | 172.9 | 179.6 | 187.5 | 195.0 | 210.5 | 207.1 | 214.2 | 221.5 | 229.1 | 236.9 |
| Depreciation, % | 13.75 | 14.99 | 13.66 | 13.2 | 14.8 | 14.08 | 14.08 | 14.08 | 14.08 | 14.08 |
| EBIT | 269.3 | 236.5 | 269.5 | 271.6 | 315.7 | 298.1 | 308.3 | 318.9 | 329.8 | 341.1 |
| EBIT, % | 21.4 | 19.73 | 19.64 | 18.38 | 22.2 | 20.27 | 20.27 | 20.27 | 20.27 | 20.27 |
| Total Cash | 5.1 | 5.8 | 2.8 | 8.5 | 9.2 | 6.8 | 7.0 | 7.3 | 7.5 | 7.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 167.4 | 168.2 | 198.7 | 245.0 | 212.3 | 215.7 | 223.1 | 230.7 | 238.6 | 246.8 |
| Account Receivables, % | 13.31 | 14.03 | 14.48 | 16.58 | 14.93 | 14.66 | 14.66 | 14.66 | 14.66 | 14.66 |
| Inventories | 53.9 | 61.0 | 80.6 | 107.4 | 114.5 | 89.9 | 93.0 | 96.2 | 99.5 | 102.9 |
| Inventories, % | 4.28 | 5.09 | 5.87 | 7.26 | 8.05 | 6.11 | 6.11 | 6.11 | 6.11 | 6.11 |
| Accounts Payable | 96.7 | 100.4 | 115.2 | 201.5 | 124.3 | 137.8 | 142.5 | 147.4 | 152.4 | 157.6 |
| Accounts Payable, % | 7.69 | 8.37 | 8.4 | 13.63 | 8.74 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 |
| Capital Expenditure | -316.0 | -405.8 | -434.3 | -515.1 | -566.9 | -486.4 | -503.0 | -520.3 | -538.1 | -556.5 |
| Capital Expenditure, % | -25.12 | -33.85 | -31.65 | -34.86 | -39.86 | -33.07 | -33.07 | -33.07 | -33.07 | -33.07 |
| Tax Rate, % | 3.74 | 3.74 | 3.74 | 3.74 | 3.74 | 3.74 | 3.74 | 3.74 | 3.74 | 3.74 |
| EBITAT | 298.7 | 254.5 | 264.6 | 272.5 | 303.9 | 294.8 | 304.9 | 315.4 | 326.2 | 337.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 31.0 | 24.2 | -17.4 | -34.4 | -104.2 | 50.1 | 10.3 | 10.7 | 11.0 | 11.4 |
| WACC, % | 5.68 | 5.68 | 5.64 | 5.68 | 5.6 | 5.66 | 5.66 | 5.66 | 5.66 | 5.66 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 83.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 12 | |||||||||
| Terminal Value | 318 | |||||||||
| Present Terminal Value | 241 | |||||||||
| Enterprise Value | 325 | |||||||||
| Net Debt | 2,784 | |||||||||
| Equity Value | -2,460 | |||||||||
| Diluted Shares Outstanding, MM | 60 | |||||||||
| Equity Value Per Share | -40.75 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real NWE financials.
- Real-World Data: Historical data and forward-looking estimates (displayed in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on NorthWestern Corporation’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Historical Data: NorthWestern Corporation’s (NWE) complete financial statements and pre-populated forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Instantly view NorthWestern Corporation’s (NWE) intrinsic value updates as you modify inputs.
- Intuitive Visualizations: Engaging dashboard charts showcase valuation outcomes and essential metrics.
- Designed for Precision: A specialized tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered NorthWestern Corporation (NWE) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for NorthWestern Corporation’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for NorthWestern Corporation (NWE)?
- Accurate Data: Up-to-date NorthWestern Corporation financials provide trustworthy valuation insights.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Ready-made calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focusing on (NWE).
- User-Friendly: Clear layout and guided instructions ensure ease of use for everyone.
Who Should Use This Product?
- Investors: Accurately assess NorthWestern Corporation's (NWE) fair value prior to making investment choices.
- CFOs: Utilize a top-tier DCF model for financial reporting and analysis specific to NorthWestern Corporation (NWE).
- Consultants: Efficiently customize the template for valuation reports tailored to NorthWestern Corporation (NWE) clients.
- Entrepreneurs: Acquire insights into the financial modeling techniques employed by leading utility companies like NorthWestern Corporation (NWE).
- Educators: Implement it as a teaching resource to illustrate valuation methods relevant to NorthWestern Corporation (NWE).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for NorthWestern Corporation (NWE).
- Real-World Data: NorthWestern Corporation’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios for (NWE).
- Financial Statements: Complete annual and quarterly breakdowns for deeper insights into NorthWestern Corporation (NWE).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to (NWE).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results regarding NorthWestern Corporation (NWE).