Apollo Global Management, Inc. (APO) 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
Apollo Global Management, Inc. (APO) Bundle
Looking to determine the intrinsic value of Apollo Global Management, Inc.? Our (APO) DCF Calculator merges real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | 2,931.8 | 2,354.0 | 5,951.0 | 10,968.0 | 32,644.0 | 54,237.7 | 90,115.3 | 149,725.6 | 248,767.6 | 413,324.7 |
| Revenue Growth, % | 0 | -19.71 | 152.8 | 84.31 | 197.63 | 66.15 | 66.15 | 66.15 | 66.15 | 66.15 |
| EBITDA | 1,328.2 | 1,430.0 | 2,658.0 | -1,688.0 | 9,120.0 | 17,709.8 | 29,424.6 | 48,888.7 | 81,228.0 | 134,959.5 |
| EBITDA, % | 45.3 | 60.75 | 44.66 | -15.39 | 27.94 | 32.65 | 32.65 | 32.65 | 32.65 | 32.65 |
| Depreciation | 15.8 | 19.0 | 27.0 | 529.0 | 803.0 | 985.1 | 1,636.7 | 2,719.4 | 4,518.3 | 7,507.1 |
| Depreciation, % | 0.53748 | 0.80714 | 0.45371 | 4.82 | 2.46 | 1.82 | 1.82 | 1.82 | 1.82 | 1.82 |
| EBIT | 1,312.4 | 1,411.0 | 2,631.0 | -2,217.0 | 8,317.0 | 16,724.7 | 27,787.9 | 46,169.2 | 76,709.7 | 127,452.4 |
| EBIT, % | 44.76 | 59.94 | 44.21 | -20.21 | 25.48 | 30.84 | 30.84 | 30.84 | 30.84 | 30.84 |
| Total Cash | 1,556.2 | 2,448.8 | 917.2 | 1,310.3 | 170,243.0 | 30,420.6 | 50,543.5 | 83,977.6 | 139,527.8 | 231,824.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | 510.6 | .0 | 4,823.0 | .0 | 7,122.9 | 11,834.6 | 19,663.1 | 32,670.1 | 54,281.0 |
| Account Receivables, % | 0 | 21.69 | 0 | 43.97 | 0 | 13.13 | 13.13 | 13.13 | 13.13 | 13.13 |
| Inventories | 2,661.1 | 3,858.5 | 5,007.5 | 18,696.1 | .0 | 40,668.4 | 67,570.1 | 112,267.1 | 186,530.5 | 309,918.5 |
| Inventories, % | 90.76 | 163.91 | 84.15 | 170.46 | 0 | 74.98 | 74.98 | 74.98 | 74.98 | 74.98 |
| Accounts Payable | 94.4 | 120.0 | 2,847.0 | 2,975.0 | 3,338.0 | 10,143.1 | 16,852.7 | 28,000.5 | 46,522.5 | 77,296.7 |
| Accounts Payable, % | 3.22 | 5.1 | 47.84 | 27.12 | 10.23 | 18.7 | 18.7 | 18.7 | 18.7 | 18.7 |
| Capital Expenditure | -39.5 | -59.6 | -64.7 | -202.5 | .0 | -738.9 | -1,227.7 | -2,039.8 | -3,389.1 | -5,630.9 |
| Capital Expenditure, % | -1.35 | -2.53 | -1.09 | -1.85 | 0 | -1.36 | -1.36 | -1.36 | -1.36 | -1.36 |
| Tax Rate, % | 9.65 | 9.65 | 9.65 | 9.65 | 9.65 | 9.65 | 9.65 | 9.65 | 9.65 | 9.65 |
| EBITAT | 786.0 | 400.6 | 995.4 | -1,023.9 | 7,514.5 | 8,785.5 | 14,597.0 | 24,252.7 | 40,295.6 | 66,950.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,804.4 | -1,322.3 | 3,046.2 | -19,081.1 | 32,199.6 | -31,954.5 | -9,897.9 | -16,445.2 | -27,323.5 | -45,397.8 |
| WACC, % | 11.26 | 11.15 | 11.18 | 11.21 | 11.36 | 11.23 | 11.23 | 11.23 | 11.23 | 11.23 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -93,187.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -46,306 | |||||||||
| Terminal Value | -501,568 | |||||||||
| Present Terminal Value | -294,562 | |||||||||
| Enterprise Value | -387,750 | |||||||||
| Net Debt | -7,836 | |||||||||
| Equity Value | -379,914 | |||||||||
| Diluted Shares Outstanding, MM | 589 | |||||||||
| Equity Value Per Share | -645.23 |
What You Will Get
- Editable Forecast Inputs: Seamlessly adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Apollo Global Management, Inc.'s (APO) financial data pre-filled to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life APO Financials: Pre-filled historical and projected data for Apollo Global Management, Inc. (APO).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Apollo’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Apollo’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Apollo Global Management data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Apollo Global Management’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Apollo Global Management Calculator?
- Accuracy: Leverages real Apollo financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexity of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Finance Students: Explore investment strategies and apply them using real-time data for Apollo Global Management (APO).
- Academics: Integrate advanced financial models into your teaching or research projects related to private equity.
- Investors: Validate your investment hypotheses and evaluate performance metrics for Apollo Global Management (APO).
- Analysts: Enhance your analysis process with a customizable financial model tailored for Apollo Global Management (APO).
- Small Business Owners: Understand the valuation methods used by large investment firms like Apollo Global Management (APO).
What the Apollo Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: Apollo Global Management’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for in-depth insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.