American Well Corporation (AMWL) 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
American Well Corporation (AMWL) Bundle
Discover the true potential of American Well Corporation with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect American Well Corporation's valuation – all within a single Excel template.
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 | 148.9 | 245.3 | 252.8 | 277.2 | 259.0 | 305.0 | 359.1 | 422.8 | 497.7 | 586.0 |
Revenue Growth, % | 0 | 64.77 | 3.07 | 9.65 | -6.55 | 17.74 | 17.74 | 17.74 | 17.74 | 17.74 |
EBITDA | -85.4 | -216.9 | -162.2 | -249.7 | -226.0 | -236.3 | -278.2 | -327.5 | -385.6 | -454.0 |
EBITDA, % | -57.4 | -88.45 | -64.16 | -90.08 | -87.24 | -77.47 | -77.47 | -77.47 | -77.47 | -77.47 |
Depreciation | 8.5 | 11.0 | 16.8 | 26.8 | 31.9 | 23.7 | 27.9 | 32.8 | 38.6 | 45.5 |
Depreciation, % | 5.69 | 4.49 | 6.66 | 9.66 | 12.32 | 7.76 | 7.76 | 7.76 | 7.76 | 7.76 |
EBIT | -93.9 | -227.9 | -179.0 | -276.5 | -257.9 | -259.9 | -306.0 | -360.3 | -424.2 | -499.5 |
EBIT, % | -63.09 | -92.93 | -70.82 | -99.74 | -99.56 | -85.23 | -85.23 | -85.23 | -85.23 | -85.23 |
Total Cash | 177.6 | 1,041.6 | 746.4 | 538.5 | 372.0 | 305.0 | 359.1 | 422.8 | 497.7 | 586.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 32.7 | 45.3 | 51.4 | 58.4 | 54.1 | 62.7 | 73.8 | 86.9 | 102.3 | 120.4 |
Account Receivables, % | 21.99 | 18.47 | 20.32 | 21.06 | 20.9 | 20.55 | 20.55 | 20.55 | 20.55 | 20.55 |
Inventories | 3.1 | 9.1 | 7.5 | 8.7 | 6.7 | 8.8 | 10.4 | 12.3 | 14.4 | 17.0 |
Inventories, % | 2.09 | 3.72 | 2.98 | 3.15 | 2.57 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 |
Accounts Payable | 6.5 | 5.8 | 12.2 | 7.2 | 4.9 | 9.8 | 11.5 | 13.6 | 16.0 | 18.8 |
Accounts Payable, % | 4.37 | 2.36 | 4.81 | 2.61 | 1.88 | 3.21 | 3.21 | 3.21 | 3.21 | 3.21 |
Capital Expenditure | -1.3 | -3.3 | -.6 | -10.4 | -15.2 | -7.4 | -8.7 | -10.3 | -12.1 | -14.2 |
Capital Expenditure, % | -0.89885 | -1.35 | -0.22113 | -3.77 | -5.89 | -2.43 | -2.43 | -2.43 | -2.43 | -2.43 |
Tax Rate, % | -0.36315 | -0.36315 | -0.36315 | -0.36315 | -0.36315 | -0.36315 | -0.36315 | -0.36315 | -0.36315 | -0.36315 |
EBITAT | -93.1 | -228.6 | -173.7 | -276.5 | -258.9 | -257.9 | -303.7 | -357.5 | -420.9 | -495.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -115.3 | -240.2 | -155.5 | -273.3 | -238.2 | -247.4 | -295.4 | -347.8 | -409.5 | -482.1 |
WACC, % | 8.92 | 8.92 | 8.91 | 8.92 | 8.92 | 8.92 | 8.92 | 8.92 | 8.92 | 8.92 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,350.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -492 | |||||||||
Terminal Value | -7,109 | |||||||||
Present Terminal Value | -4,638 | |||||||||
Enterprise Value | -5,989 | |||||||||
Net Debt | -360 | |||||||||
Equity Value | -5,628 | |||||||||
Diluted Shares Outstanding, MM | 14 | |||||||||
Equity Value Per Share | -396.02 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled financials for AMWL (American Well Corporation).
- Real-Time Data: Historical performance metrics and forward-looking projections (highlighted in the yellow cells).
- Forecasting Options: Adjust key assumptions such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Instant Calculations: Quickly observe how your inputs affect the valuation of American Well Corporation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts alike.
- User-Centric Layout: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Comprehensive Data: American Well Corporation’s (AMWL) historical financial reports and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: Observe American Well Corporation’s intrinsic value update instantly.
- Intuitive Visual Outputs: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and financial professionals.
How It Works
- 1. Access the Template: Download and open the Excel file featuring American Well Corporation’s (AMWL) preloaded data.
- 2. Modify Assumptions: Adjust key parameters such as growth projections, WACC, and capital expenditures.
- 3. Analyze Results Instantly: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Assurance: Share expert valuation insights to bolster your decision-making process.
Why Choose This Calculator for American Well Corporation (AMWL)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for AMWL.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes American Well's intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable baselines for analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focusing on AMWL.
Who Should Use This Product?
- Investors: Accurately assess American Well Corporation’s (AMWL) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to American Well Corporation.
- Consultants: Efficiently customize the template for valuation reports tailored to clients involving American Well Corporation.
- Entrepreneurs: Acquire insights into financial modeling practices adopted by leading healthcare companies.
- Educators: Employ it as a teaching resource to illustrate valuation methodologies in the healthcare sector.
What the Template Contains
- Pre-Filled Data: Includes American Well Corporation’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 American Well Corporation’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.