|
Apollo Global Management, Inc. (APO) Valoración de DCF
US | Financial Services | Asset Management - Global | NYSE
|
- ✓ 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
Apollo Global Management, Inc. (APO) Bundle
¿Busca determinar el valor intrínseco de Apollo Global Management, Inc.? Nuestra calculadora DCF (APO) fusiona datos del mundo real con extensas características de personalización, lo que le permite ajustar los pronósticos y mejorar sus estrategias de inversión.
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.