American Financial Group, Inc. (AFG) 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 Financial Group, Inc. (AFG) Bundle
Designed for accuracy, our (AFG) DCF Calculator enables you to assess American Financial Group, Inc. valuation using real-world financial data and provides complete flexibility to modify all essential parameters for improved 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 | 8,237.0 | 7,909.0 | 6,552.0 | 7,040.0 | 7,732.0 | 7,657.3 | 7,583.4 | 7,510.2 | 7,437.7 | 7,365.9 |
Revenue Growth, % | 0 | -3.98 | -17.16 | 7.45 | 9.83 | -0.96551 | -0.96551 | -0.96551 | -0.96551 | -0.96551 |
EBITDA | 1,435.0 | 726.0 | 1,616.0 | 1,308.0 | 1,227.0 | 1,312.7 | 1,300.0 | 1,287.5 | 1,275.0 | 1,262.7 |
EBITDA, % | 17.42 | 9.18 | 24.66 | 18.58 | 15.87 | 17.14 | 17.14 | 17.14 | 17.14 | 17.14 |
Depreciation | 259.0 | 299.0 | 187.0 | 100.0 | 78.0 | 187.0 | 185.2 | 183.4 | 181.6 | 179.8 |
Depreciation, % | 3.14 | 3.78 | 2.85 | 1.42 | 1.01 | 2.44 | 2.44 | 2.44 | 2.44 | 2.44 |
EBIT | 1,176.0 | 427.0 | 1,429.0 | 1,208.0 | 1,149.0 | 1,125.7 | 1,114.8 | 1,104.1 | 1,093.4 | 1,082.9 |
EBIT, % | 14.28 | 5.4 | 21.81 | 17.16 | 14.86 | 14.7 | 14.7 | 14.7 | 14.7 | 14.7 |
Total Cash | 48,819.0 | 46,017.0 | 12,488.0 | 10,967.0 | 1,225.0 | 6,368.5 | 6,307.0 | 6,246.1 | 6,185.8 | 6,126.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5,725.0 | 5,195.0 | 857.0 | 886.0 | 1,171.0 | 2,695.4 | 2,669.3 | 2,643.6 | 2,618.0 | 2,592.8 |
Account Receivables, % | 69.5 | 65.68 | 13.08 | 12.59 | 15.14 | 35.2 | 35.2 | 35.2 | 35.2 | 35.2 |
Inventories | -6,417.0 | -3,572.0 | -5,493.0 | .0 | .0 | -3,168.7 | -3,138.1 | -3,107.8 | -3,077.8 | -3,048.1 |
Inventories, % | -77.9 | -45.16 | -83.84 | 0 | 0 | -41.38 | -41.38 | -41.38 | -41.38 | -41.38 |
Accounts Payable | 3,838.0 | 3,924.0 | 4,339.0 | 1,035.0 | 1,186.0 | 2,947.7 | 2,919.2 | 2,891.0 | 2,863.1 | 2,835.5 |
Accounts Payable, % | 46.59 | 49.61 | 66.22 | 14.7 | 15.34 | 38.49 | 38.49 | 38.49 | 38.49 | 38.49 |
Capital Expenditure | -44.0 | -343.0 | -150.0 | -86.0 | .0 | -128.4 | -127.1 | -125.9 | -124.7 | -123.5 |
Capital Expenditure, % | -0.53418 | -4.34 | -2.29 | -1.22 | 0 | -1.68 | -1.68 | -1.68 | -1.68 | -1.68 |
Tax Rate, % | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 |
EBITAT | 952.1 | 368.6 | 1,157.1 | 966.0 | 912.3 | 917.7 | 908.9 | 900.1 | 891.4 | 882.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 5,697.1 | -1,904.4 | 7,868.1 | -7,846.0 | 856.3 | 4,382.3 | 933.9 | 924.8 | 915.9 | 907.1 |
WACC, % | 7.68 | 7.71 | 7.68 | 7.67 | 7.67 | 7.68 | 7.68 | 7.68 | 7.68 | 7.68 |
PV UFCF | ||||||||||
SUM PV UFCF | 6,923.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 925 | |||||||||
Terminal Value | 16,288 | |||||||||
Present Terminal Value | 11,251 | |||||||||
Enterprise Value | 18,175 | |||||||||
Net Debt | 250 | |||||||||
Equity Value | 17,925 | |||||||||
Diluted Shares Outstanding, MM | 85 | |||||||||
Equity Value Per Share | 211.37 |
What You Will Get
- Real AFG Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess American Financial Group’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Financial Metrics: Adjust essential inputs such as premium growth, underwriting profit margin, and investment income.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages AFG's actual financial data for credible valuation results.
- Streamlined Scenario Analysis: Effortlessly evaluate various assumptions and assess different outcomes.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based AFG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates American Financial Group’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial strategy.
Why Choose This Calculator for American Financial Group, Inc. (AFG)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Financial Data: Historical and projected financials for AFG are preloaded to ensure precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive and accurate valuation models for analyzing AFG's portfolio.
- Corporate Finance Departments: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Financial Consultants and Advisors: Deliver precise valuation insights for American Financial Group, Inc. (AFG) to clients.
- Students and Instructors: Utilize real-time data to enhance learning and practice in financial modeling.
- Finance Enthusiasts: Gain insights into the market valuation of financial services companies like AFG.
What the Template Contains
- Historical Data: Includes American Financial Group, Inc.'s (AFG) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate American Financial Group, Inc.'s (AFG) 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 American Financial Group, Inc.'s (AFG) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.