American International Group, Inc. (AIG) 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
American International Group, Inc. (AIG) Bundle
Engineered for accuracy, our (AIG) DCF Calculator empowers you to assess American International Group, Inc. valuation using real-world financial data, allowing complete flexibility to modify all essential parameters for enhanced projections.
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 | 49,792.0 | 43,839.0 | 51,885.0 | 56,539.0 | 47,251.0 | 47,125.8 | 47,000.9 | 46,876.4 | 46,752.1 | 46,628.2 |
Revenue Growth, % | 0 | -11.96 | 18.35 | 8.97 | -16.43 | -0.26499 | -0.26499 | -0.26499 | -0.26499 | -0.26499 |
EBITDA | 11,710.0 | -1,716.0 | 18,037.0 | 19,833.0 | 9,208.0 | 10,267.1 | 10,239.9 | 10,212.7 | 10,185.7 | 10,158.7 |
EBITDA, % | 23.52 | -3.91 | 34.76 | 35.08 | 19.49 | 21.79 | 21.79 | 21.79 | 21.79 | 21.79 |
Depreciation | 5,006.0 | 4,120.0 | 4,633.0 | 4,409.0 | 4,214.0 | 4,250.5 | 4,239.3 | 4,228.0 | 4,216.8 | 4,205.7 |
Depreciation, % | 10.05 | 9.4 | 8.93 | 7.8 | 8.92 | 9.02 | 9.02 | 9.02 | 9.02 | 9.02 |
EBIT | 6,704.0 | -5,836.0 | 13,404.0 | 15,424.0 | 4,994.0 | 6,016.6 | 6,000.6 | 5,984.7 | 5,968.9 | 5,953.0 |
EBIT, % | 13.46 | -13.31 | 25.83 | 27.28 | 10.57 | 12.77 | 12.77 | 12.77 | 12.77 | 12.77 |
Total Cash | 267,172.0 | 292,526.0 | 292,757.0 | 240,575.0 | 2,155.0 | 38,130.5 | 38,029.4 | 37,928.7 | 37,828.2 | 37,727.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 10,274.0 | 11,333.0 | 12,409.0 | .0 | 10,561.0 | 8,742.1 | 8,718.9 | 8,695.8 | 8,672.8 | 8,649.8 |
Account Receivables, % | 20.63 | 25.85 | 23.92 | 0 | 22.35 | 18.55 | 18.55 | 18.55 | 18.55 | 18.55 |
Inventories | -39,378.0 | -45,591.0 | -37,837.0 | -179,461.0 | .0 | -33,177.5 | -33,089.6 | -33,001.9 | -32,914.4 | -32,827.2 |
Inventories, % | -79.08 | -104 | -72.92 | -317.41 | 0 | -70.4 | -70.4 | -70.4 | -70.4 | -70.4 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | -3,689.0 | 1,815.0 | -746.0 | .0 | .0 | -833.8 | -831.6 | -829.4 | -827.2 | -825.0 |
Capital Expenditure, % | -7.41 | 4.14 | -1.44 | 0 | 0 | -1.77 | -1.77 | -1.77 | -1.77 | -1.77 |
Tax Rate, % | 5.57 | 5.57 | 5.57 | 5.57 | 5.57 | 5.57 | 5.57 | 5.57 | 5.57 | 5.57 |
EBITAT | 4,245.3 | -4,667.7 | 11,485.2 | 11,044.8 | 4,715.7 | 4,753.4 | 4,740.8 | 4,728.2 | 4,715.7 | 4,703.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 34,666.3 | 6,421.3 | 6,542.2 | 169,486.8 | -181,092.3 | 43,166.5 | 8,083.7 | 8,062.3 | 8,040.9 | 8,019.6 |
WACC, % | 7.63 | 7.88 | 7.97 | 7.75 | 8.1 | 7.87 | 7.87 | 7.87 | 7.87 | 7.87 |
PV UFCF | ||||||||||
SUM PV UFCF | 64,823.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 8,180 | |||||||||
Terminal Value | 139,469 | |||||||||
Present Terminal Value | 95,515 | |||||||||
Enterprise Value | 160,339 | |||||||||
Net Debt | 20,232 | |||||||||
Equity Value | 140,107 | |||||||||
Diluted Shares Outstanding, MM | 725 | |||||||||
Equity Value Per Share | 193.19 |
What You Will Get
- Pre-Filled Financial Model: AIG’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Customizable Risk Parameters: Adjust essential inputs such as premium growth, loss ratios, and expense ratios.
- Instant Valuation Metrics: Provides quick calculations of intrinsic value, NPV, and other key financial indicators.
- Industry-Leading Precision: Leverages AIG's real-world financial data for accurate valuation results.
- Effortless Scenario Testing: Easily analyze various assumptions and evaluate different outcomes.
- Efficiency Booster: Streamline the valuation process without the need to create intricate models from the ground up.
How It Works
- Download: Obtain the pre-configured Excel file containing American International Group, Inc.'s (AIG) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare results.
- Make Decisions: Leverage the valuation findings to inform your investment strategy.
Why Choose This Calculator for AIG?
- Designed for Experts: A sophisticated tool favored by analysts, CFOs, and consultants in the industry.
- Accurate Financials: AIG’s historical and projected financial data preloaded for precision.
- 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?
- Finance Students: Explore risk management strategies and apply them using real-world data related to American International Group, Inc. (AIG).
- Academics: Integrate advanced insurance models into your research or teaching materials.
- Investors: Evaluate your investment hypotheses and analyze the performance metrics for American International Group, Inc. (AIG).
- Analysts: Enhance your efficiency with a ready-to-use, adaptable financial model tailored for insurance companies.
- Small Business Owners: Understand how large insurance firms like American International Group, Inc. (AIG) assess risk and manage portfolios.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for American International Group, Inc. (AIG).
- Real-World Data: AIG’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results.