Affirm Holdings, Inc. (AFRM) 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
Affirm Holdings, Inc. (AFRM) Bundle
Gain insight into your Affirm Holdings, Inc. (AFRM) valuation analysis using our sophisticated DCF Calculator! Featuring real-time data for (AFRM), this Excel template enables you to adjust forecasts and assumptions, allowing you to accurately determine the intrinsic value of Affirm Holdings, Inc.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 509.5 | 870.5 | 1,349.3 | 1,588.0 | 2,323.0 | 3,425.4 | 5,050.9 | 7,447.9 | 10,982.3 | 16,194.0 |
| Revenue Growth, % | 0 | 70.84 | 55.01 | 17.69 | 46.29 | 47.46 | 47.46 | 47.46 | 47.46 | 47.46 |
| EBITDA | -70.5 | -370.7 | -602.4 | -671.6 | -2.2 | -982.8 | -1,449.2 | -2,136.9 | -3,151.0 | -4,646.3 |
| EBITDA, % | -13.84 | -42.59 | -44.65 | -42.29 | -0.0959966 | -28.69 | -28.69 | -28.69 | -28.69 | -28.69 |
| Depreciation | 9.4 | 20.0 | 52.7 | 134.6 | 169.0 | 163.1 | 240.5 | 354.6 | 522.8 | 770.9 |
| Depreciation, % | 1.84 | 2.3 | 3.91 | 8.48 | 7.28 | 4.76 | 4.76 | 4.76 | 4.76 | 4.76 |
| EBIT | -79.9 | -390.7 | -655.1 | -806.2 | -171.3 | -1,145.9 | -1,689.6 | -2,491.5 | -3,673.8 | -5,417.2 |
| EBIT, % | -15.68 | -44.88 | -48.55 | -50.77 | -7.37 | -33.45 | -33.45 | -33.45 | -33.45 | -33.45 |
| Total Cash | 267.1 | 1,466.6 | 2,850.5 | 2,066.7 | 2,144.7 | 3,046.8 | 4,492.7 | 6,624.7 | 9,768.5 | 14,404.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 59.0 | 131.0 | 161.9 | 199.2 | 353.0 | 454.7 | 670.5 | 988.7 | 1,457.9 | 2,149.7 |
| Account Receivables, % | 11.58 | 15.05 | 12 | 12.54 | 15.2 | 13.27 | 13.27 | 13.27 | 13.27 | 13.27 |
| Inventories | .0 | -171.8 | -72.7 | .0 | -334.3 | -270.7 | -399.2 | -588.6 | -867.9 | -1,279.8 |
| Inventories, % | 0.000000196 | -19.74 | -5.39 | 0.000000063 | -14.39 | -7.9 | -7.9 | -7.9 | -7.9 | -7.9 |
| Accounts Payable | 18.4 | 57.8 | 33.1 | 28.6 | 41.0 | 111.4 | 164.2 | 242.2 | 357.1 | 526.5 |
| Accounts Payable, % | 3.6 | 6.64 | 2.45 | 1.8 | 1.77 | 3.25 | 3.25 | 3.25 | 3.25 | 3.25 |
| Capital Expenditure | -21.0 | -20.3 | -111.7 | -120.8 | -159.3 | -200.0 | -294.9 | -434.9 | -641.2 | -945.5 |
| Capital Expenditure, % | -4.13 | -2.33 | -8.28 | -7.61 | -6.86 | -5.84 | -5.84 | -5.84 | -5.84 | -5.84 |
| Tax Rate, % | -0.43257 | -0.43257 | -0.43257 | -0.43257 | -0.43257 | -0.43257 | -0.43257 | -0.43257 | -0.43257 | -0.43257 |
| EBITAT | -80.2 | -388.6 | -639.4 | -803.1 | -172.0 | -1,138.2 | -1,678.4 | -2,474.8 | -3,649.3 | -5,381.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -132.4 | -249.7 | -853.1 | -903.6 | 30.6 | -1,270.1 | -1,767.3 | -2,606.0 | -3,842.6 | -5,666.2 |
| WACC, % | 16.97 | 16.97 | 16.94 | 16.97 | 16.97 | 16.97 | 16.97 | 16.97 | 16.97 | 16.97 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -8,647.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -5,780 | |||||||||
| Terminal Value | -38,618 | |||||||||
| Present Terminal Value | -17,640 | |||||||||
| Enterprise Value | -26,287 | |||||||||
| Net Debt | 5,601 | |||||||||
| Equity Value | -31,888 | |||||||||
| Diluted Shares Outstanding, MM | 310 | |||||||||
| Equity Value Per Share | -102.91 |
What You Will Get
- Real AFRM Financial Data: Pre-filled with Affirm Holdings’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Affirm’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Financial Data: Gain access to precise historical data and future forecasts for Affirm Holdings, Inc. (AFRM).
- Adjustable Forecast Parameters: Modify highlighted cells to tailor assumptions like WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Utilize clear charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based AFRM DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other parameters.
- Instant Calculations: The model will automatically refresh Affirm's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation impacts.
- Analyze and Decide: Leverage the findings to inform your investment or financial evaluations.
Why Choose This Calculator for Affirm Holdings, Inc. (AFRM)?
- Accuracy: Utilizes real Affirm financial data for precise calculations.
- Flexibility: Tailored for users to easily adjust and experiment with inputs.
- Time-Saving: Avoid the complexities of constructing a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and standards expected by CFOs.
- User-Friendly: Intuitive interface designed for users of all financial backgrounds.
Who Should Use This Product?
- Finance Students: Discover innovative financing models and apply them using real-world data.
- Academics: Integrate advanced financial theories into your research or educational programs.
- Investors: Evaluate your investment strategies and analyze valuation outcomes for Affirm Holdings, Inc. (AFRM).
- Analysts: Enhance your analysis process with a customizable financial modeling tool.
- Small Business Owners: Understand how fintech companies like Affirm are valued and assessed in the market.
What the Template Contains
- Preloaded AFRM Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.