AFC Gamma, Inc. (AFCG) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
AFC Gamma, Inc. (AFCG) Bundle
Gain insight into your AFC Gamma, Inc. (AFCG) valuation analysis with our sophisticated DCF Calculator! Preloaded with real AFCG data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of AFC Gamma, Inc. (AFCG).
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 5.6 | 38.1 | 71.5 | 66.1 | 105.8 | 169.4 | 271.2 | 434.2 | 695.1 | |
Revenue Growth, % | 0 | 580.66 | 87.85 | -7.59 | 60.09 | 60.09 | 60.09 | 60.09 | 60.09 | |
EBITDA | .0 | 22.2 | 43.8 | 27.0 | 42.4 | 67.9 | 108.6 | 173.9 | 278.4 | |
EBITDA, % | 0 | 58.19 | 61.19 | 40.81 | 40.05 | 40.05 | 40.05 | 40.05 | 40.05 | |
Depreciation | -5.8 | 16.4 | 38.2 | 45.6 | 17.3 | 27.7 | 44.4 | 71.1 | 113.8 | |
Depreciation, % | -103.17 | 43.14 | 53.36 | 68.99 | 16.37 | 16.37 | 16.37 | 16.37 | 16.37 | |
EBIT | 5.8 | 5.7 | 5.6 | -18.6 | 25.1 | 40.1 | 64.2 | 102.8 | 164.6 | |
EBIT, % | 103.17 | 15.06 | 7.82 | -28.18 | 23.68 | 23.68 | 23.68 | 23.68 | 23.68 | |
Total Cash | 9.6 | 125.1 | 140.4 | 121.6 | 105.8 | 169.4 | 271.2 | 434.2 | 695.1 | |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | |
Account Receivables | .9 | 4.4 | 5.3 | 5.6 | 11.6 | 18.6 | 29.8 | 47.7 | 76.3 | |
Account Receivables, % | 16.57 | 11.59 | 7.35 | 8.4 | 10.98 | 10.98 | 10.98 | 10.98 | 10.98 | |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | |
Inventories, % | 0.000017872756 | 0.000002625812 | 0 | 0 | 0.000005124642 | 0.000005124642 | 0.000005124642 | 0.000005124642 | 0.000005124642 | |
Accounts Payable | 1.3 | 5.8 | 4.2 | .7 | 12.1 | 19.4 | 31.1 | 49.8 | 79.7 | |
Accounts Payable, % | 23.69 | 15.16 | 5.92 | 1.08 | 11.47 | 11.47 | 11.47 | 11.47 | 11.47 | |
Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | |
Capital Expenditure, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Tax Rate, % | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 | |
EBITAT | 5.8 | 5.7 | 5.4 | -17.3 | 24.4 | 39.1 | 62.6 | 100.2 | 160.3 | |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | .4 | 23.1 | 41.2 | 24.5 | 47.1 | 67.1 | 107.5 | 172.0 | 275.4 | |
WACC, % | 7.57 | 7.57 | 7.51 | 7.42 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 | |
PV UFCF | ||||||||||
SUM PV UFCF | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | 508.8 | |
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 281 | |||||||||
Terminal Value | 5,091 | |||||||||
Present Terminal Value | 3,543 | |||||||||
Enterprise Value | 4,052 | |||||||||
Net Debt | 8 | |||||||||
Equity Value | 4,044 | |||||||||
Diluted Shares Outstanding, MM | 20 | |||||||||
Equity Value Per Share | 198.75 |
What You Will Receive
- Comprehensive Financial Model: AFC Gamma, Inc.’s (AFCG) actual data ensures accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates allow you to see results instantly as you make adjustments.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive AFCG Data: Pre-loaded with AFC Gamma’s historical financial performance and future projections.
- Flexible Input Options: Modify revenue growth rates, profit margins, discount rates, tax assumptions, and capital expenditures.
- Adaptive Valuation Model: Automatically recalculates Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive User Interface: Designed to be accessible and efficient for both seasoned professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based AFC Gamma, Inc. (AFCG) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key parameters.
- Instant Calculations: The model automatically recalculates the intrinsic value of AFC Gamma, Inc. (AFCG).
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis decisions.
Why Choose the AFC Gamma, Inc. (AFCG) Calculator?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for AFC Gamma, Inc.
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes AFC Gamma's intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data for reliable analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focused on AFCG.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling AFC Gamma, Inc. (AFCG) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to AFC Gamma, Inc. (AFCG).
- Consultants: Deliver professional valuation insights on AFC Gamma, Inc. (AFCG) to clients quickly and accurately.
- Business Owners: Understand how companies like AFC Gamma, Inc. (AFCG) are valued to guide your own business strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to AFC Gamma, Inc. (AFCG).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for AFC Gamma, Inc. (AFCG).
- Real-World Data: AFC Gamma’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into AFCG's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to AFC Gamma, Inc. (AFCG).
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for informed decision-making.