Ameresco, Inc. (AMRC) DCF Valuation

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

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 36.92 34 42.48 43.64 60.32
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.