Altus Power, Inc. (AMPS) DCF Valuation
- ✓ 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
Altus Power, Inc. (AMPS) Bundle
Evaluate Altus Power, Inc.'s (AMPS) financial outlook like an expert! This (AMPS) DCF Calculator provides pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your forecasts.
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 | 37.4 | 45.3 | 71.8 | 101.2 | 155.2 | 222.6 | 319.3 | 458.0 | 657.1 | 942.5 |
Revenue Growth, % | 0 | 20.95 | 58.58 | 40.9 | 53.38 | 43.45 | 43.45 | 43.45 | 43.45 | 43.45 |
EBITDA | 21.7 | 24.2 | 47.3 | 108.6 | 76.9 | 145.5 | 208.7 | 299.3 | 429.4 | 616.0 |
EBITDA, % | 57.96 | 53.45 | 65.82 | 107.36 | 49.53 | 65.35 | 65.35 | 65.35 | 65.35 | 65.35 |
Depreciation | 8.2 | 11.9 | 22.7 | 33.2 | 53.6 | 65.5 | 94.0 | 134.9 | 193.5 | 277.6 |
Depreciation, % | 21.93 | 26.35 | 31.57 | 32.82 | 34.56 | 29.45 | 29.45 | 29.45 | 29.45 | 29.45 |
EBIT | 13.5 | 12.3 | 24.6 | 75.4 | 23.2 | 83.2 | 119.3 | 171.2 | 245.6 | 352.3 |
EBIT, % | 36.03 | 27.1 | 34.25 | 74.54 | 14.97 | 37.38 | 37.38 | 37.38 | 37.38 | 37.38 |
Total Cash | 26.6 | 33.8 | 326.0 | 193.0 | 160.8 | 198.5 | 284.7 | 408.5 | 585.9 | 840.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.7 | 5.5 | 9.2 | 13.4 | 17.1 | 23.9 | 34.3 | 49.3 | 70.7 | 101.4 |
Account Receivables, % | 4.45 | 12.17 | 12.84 | 13.29 | 11.02 | 10.75 | 10.75 | 10.75 | 10.75 | 10.75 |
Inventories | .0 | 3.5 | 2.5 | 2.4 | .0 | 6.0 | 8.7 | 12.4 | 17.8 | 25.6 |
Inventories, % | 0 | 7.65 | 3.54 | 2.38 | 0 | 2.71 | 2.71 | 2.71 | 2.71 | 2.71 |
Accounts Payable | 2.1 | 1.6 | 3.6 | 2.7 | 7.3 | 9.6 | 13.8 | 19.8 | 28.4 | 40.7 |
Accounts Payable, % | 5.69 | 3.47 | 5 | 2.71 | 4.73 | 4.32 | 4.32 | 4.32 | 4.32 | 4.32 |
Capital Expenditure | -57.2 | -60.1 | -41.9 | -91.1 | -117.8 | -188.9 | -271.0 | -388.8 | -557.8 | -800.1 |
Capital Expenditure, % | -152.7 | -132.64 | -58.42 | -90.1 | -75.91 | -84.89 | -84.89 | -84.89 | -84.89 | -84.89 |
Tax Rate, % | 64.9 | 64.9 | 64.9 | 64.9 | 64.9 | 64.9 | 64.9 | 64.9 | 64.9 | 64.9 |
EBITAT | 11.2 | 12.8 | 24.0 | 78.5 | 8.2 | 69.2 | 99.3 | 142.4 | 204.3 | 293.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -37.3 | -43.2 | 4.0 | 15.6 | -52.7 | -64.8 | -86.6 | -124.2 | -178.2 | -255.6 |
WACC, % | 5.39 | 5.9 | 5.83 | 5.9 | 3.95 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 |
PV UFCF | ||||||||||
SUM PV UFCF | -586.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -261 | |||||||||
Terminal Value | -7,689 | |||||||||
Present Terminal Value | -5,914 | |||||||||
Enterprise Value | -6,500 | |||||||||
Net Debt | 1,230 | |||||||||
Equity Value | -7,730 | |||||||||
Diluted Shares Outstanding, MM | 159 | |||||||||
Equity Value Per Share | -48.71 |
What You Will Get
- Real Altus Power Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Altus Power, Inc. (AMPS).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Altus Power.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Altus Power’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Altus Power, Inc. (AMPS).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for your analyses on Altus Power.
Key Features
- Comprehensive Altus Power Financials: Gain access to reliable pre-loaded historical data and future estimates.
- Adjustable Forecast Parameters: Modify highlighted cells for metrics like WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Altus Power data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Altus Power’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Altus Power, Inc. (AMPS)?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Altus Power’s valuation as you tweak inputs.
- Pre-Loaded Data: Comes with Altus Power’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: A go-to tool for investors and analysts aiming to make sound decisions.
Who Should Use This Product?
- Energy Sector Students: Explore renewable energy valuation techniques and apply them using real market data.
- Researchers: Integrate professional models into your studies on sustainable energy and finance.
- Investors: Validate your investment strategies and analyze valuation metrics for Altus Power, Inc. (AMPS).
- Financial Analysts: Enhance your analysis with a ready-to-use, customizable DCF model tailored for clean energy.
- Entrepreneurs: Learn how public companies like Altus Power, Inc. (AMPS) are evaluated in the renewable energy market.
What the Template Contains
- Historical Data: Includes Altus Power’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Altus Power’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Altus Power’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.