Ameresco, Inc. (AMRC) DCF Valuation
- ✓ 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
Ameresco, Inc. (AMRC) Bundle
Whether you’re an investor or analyst, this (AMRC) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Ameresco, 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 | 866.9 | 1,032.3 | 1,215.7 | 1,824.4 | 1,374.6 | 1,588.6 | 1,835.9 | 2,121.6 | 2,451.8 | 2,833.4 |
Revenue Growth, % | 0 | 19.07 | 17.77 | 50.07 | -24.65 | 15.56 | 15.56 | 15.56 | 15.56 | 15.56 |
EBITDA | 92.7 | 114.7 | 144.2 | 187.4 | 150.7 | 174.4 | 201.5 | 232.9 | 269.2 | 311.0 |
EBITDA, % | 10.69 | 11.11 | 11.86 | 10.27 | 10.96 | 10.98 | 10.98 | 10.98 | 10.98 | 10.98 |
Depreciation | 39.5 | 42.1 | 46.7 | 54.4 | 66.2 | 64.4 | 74.4 | 86.0 | 99.4 | 114.9 |
Depreciation, % | 4.55 | 4.08 | 3.84 | 2.98 | 4.81 | 4.05 | 4.05 | 4.05 | 4.05 | 4.05 |
EBIT | 53.2 | 72.5 | 97.5 | 133.0 | 84.5 | 110.0 | 127.1 | 146.9 | 169.7 | 196.2 |
EBIT, % | 6.14 | 7.03 | 8.02 | 7.29 | 6.15 | 6.92 | 6.92 | 6.92 | 6.92 | 6.92 |
Total Cash | 33.2 | 66.4 | 50.5 | 115.5 | 79.3 | 84.2 | 97.4 | 112.5 | 130.0 | 150.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 320.1 | 351.0 | 516.5 | 796.2 | 829.1 | 690.6 | 798.1 | 922.3 | 1,065.9 | 1,231.8 |
Account Receivables, % | 36.92 | 34 | 42.48 | 43.64 | 60.32 | 43.47 | 43.47 | 43.47 | 43.47 | 43.47 |
Inventories | 9.2 | 8.6 | 8.8 | 14.2 | 13.6 | 14.0 | 16.1 | 18.6 | 21.5 | 24.9 |
Inventories, % | 1.07 | 0.83069 | 0.72444 | 0.77932 | 0.99205 | 0.87837 | 0.87837 | 0.87837 | 0.87837 | 0.87837 |
Accounts Payable | 202.4 | 230.9 | 309.0 | 349.1 | 402.8 | 379.9 | 439.0 | 507.3 | 586.3 | 677.6 |
Accounts Payable, % | 23.35 | 22.37 | 25.41 | 19.14 | 29.3 | 23.91 | 23.91 | 23.91 | 23.91 | 23.91 |
Capital Expenditure | -140.6 | -182.8 | -183.8 | -327.9 | -551.8 | -340.4 | -393.4 | -454.7 | -525.4 | -607.2 |
Capital Expenditure, % | -16.22 | -17.7 | -15.12 | -17.97 | -40.14 | -21.43 | -21.43 | -21.43 | -21.43 | -21.43 |
Tax Rate, % | -63.24 | -63.24 | -63.24 | -63.24 | -63.24 | -63.24 | -63.24 | -63.24 | -63.24 | -63.24 |
EBITAT | 64.7 | 69.5 | 87.9 | 119.4 | 137.9 | 104.6 | 120.9 | 139.8 | 161.5 | 186.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -163.4 | -72.8 | -136.9 | -399.0 | -326.4 | -56.1 | -248.6 | -287.3 | -332.0 | -383.7 |
WACC, % | 8.26 | 8.15 | 8.01 | 8 | 8.26 | 8.14 | 8.14 | 8.14 | 8.14 | 8.14 |
PV UFCF | ||||||||||
SUM PV UFCF | -994.0 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | -397 | |||||||||
Terminal Value | -8,567 | |||||||||
Present Terminal Value | -5,794 | |||||||||
Enterprise Value | -6,788 | |||||||||
Net Debt | 1,469 | |||||||||
Equity Value | -8,257 | |||||||||
Diluted Shares Outstanding, MM | 53 | |||||||||
Equity Value Per Share | -155.12 |
What You Will Get
- Real Ameresco Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Ameresco, Inc. (AMRC).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Ameresco.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Ameresco’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections related to Ameresco, Inc. (AMRC).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for your analysis of Ameresco.
Key Features
- Comprehensive AMRC Data: Pre-loaded with Ameresco's historical financial performance and future projections.
- Fully Customizable Inputs: Modify growth rates, profit margins, discount rates, tax implications, and capital investments.
- Dynamic Valuation Model: Instantaneous updates to Net Present Value (NPV) and intrinsic valuation based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation results.
- User-Friendly Interface: Intuitive, organized, and crafted for both industry experts and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template containing Ameresco, Inc.'s (AMRC) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Ameresco, Inc.'s (AMRC) intrinsic value.
- Step 5: Use the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for Ameresco, Inc. (AMRC)?
- Designed for Experts: A sophisticated tool utilized by industry analysts, financial officers, and consultants.
- Accurate Data: Ameresco’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Investors: Evaluate Ameresco, Inc.'s (AMRC) performance and make informed investment decisions.
- CFOs and Financial Analysts: Enhance valuation processes and validate financial forecasts for Ameresco.
- Startup Founders: Discover valuation methodologies used by established companies like Ameresco, Inc. (AMRC).
- Consultants: Provide detailed valuation assessments and reports for clients interested in Ameresco.
- Students and Educators: Utilize real-time data from Ameresco, Inc. (AMRC) to practice and teach valuation strategies.
What the Template Contains
- Historical Data: Includes Ameresco, Inc.'s (AMRC) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Ameresco, Inc.'s (AMRC) 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 Ameresco, Inc.'s (AMRC) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.