Fathom Holdings Inc. (FTHM) 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
Fathom Holdings Inc. (FTHM) Bundle
Engineered for accuracy, our FTHM DCF Calculator enables you to evaluate Fathom Holdings Inc. valuation using real-time financial data, offering complete flexibility to modify all essential parameters for improved forecasting.
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 | 109.6 | 176.8 | 330.2 | 413.0 | 345.2 | 480.5 | 668.7 | 930.7 | 1,295.4 | 1,802.9 |
Revenue Growth, % | 0 | 61.27 | 86.8 | 25.05 | -16.4 | 39.18 | 39.18 | 39.18 | 39.18 | 39.18 |
EBITDA | -3.9 | -1.1 | -13.4 | -21.4 | -17.3 | -17.7 | -24.7 | -34.4 | -47.8 | -66.6 |
EBITDA, % | -3.59 | -0.63344 | -4.04 | -5.19 | -5.01 | -3.69 | -3.69 | -3.69 | -3.69 | -3.69 |
Depreciation | .1 | .1 | 2.7 | 5.3 | 5.9 | 3.8 | 5.3 | 7.4 | 10.3 | 14.4 |
Depreciation, % | 0.0516995 | 0.08213127 | 0.83215 | 1.29 | 1.72 | 0.79663 | 0.79663 | 0.79663 | 0.79663 | 0.79663 |
EBIT | -4.0 | -1.3 | -16.1 | -26.8 | -23.3 | -21.6 | -30.0 | -41.8 | -58.2 | -81.0 |
EBIT, % | -3.64 | -0.71558 | -4.88 | -6.48 | -6.74 | -4.49 | -4.49 | -4.49 | -4.49 | -4.49 |
Total Cash | .6 | 28.6 | 37.8 | 8.3 | 7.4 | 31.0 | 43.2 | 60.1 | 83.7 | 116.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .7 | 1.6 | 4.0 | 3.1 | 3.4 | 4.3 | 5.9 | 8.2 | 11.5 | 16.0 |
Account Receivables, % | 0.60289 | 0.90223 | 1.21 | 0.74437 | 0.97096 | 0.8852 | 0.8852 | 0.8852 | 0.8852 | 0.8852 |
Inventories | .0 | 1.0 | .1 | .1 | .0 | .6 | .8 | 1.1 | 1.6 | 2.2 |
Inventories, % | 0 | 0.55675 | 0.04360597 | 0.01622417 | 0 | 0.12332 | 0.12332 | 0.12332 | 0.12332 | 0.12332 |
Accounts Payable | .9 | 2.6 | 5.3 | 3.3 | 3.4 | 5.5 | 7.7 | 10.7 | 14.8 | 20.7 |
Accounts Payable, % | 0.86299 | 1.47 | 1.61 | 0.80951 | 0.9837 | 1.15 | 1.15 | 1.15 | 1.15 | 1.15 |
Capital Expenditure | -.4 | -.7 | -3.5 | -4.1 | -1.8 | -3.2 | -4.5 | -6.2 | -8.6 | -12.0 |
Capital Expenditure, % | -0.34009 | -0.42127 | -1.05 | -0.98241 | -0.53096 | -0.66565 | -0.66565 | -0.66565 | -0.66565 | -0.66565 |
Tax Rate, % | -0.62099 | -0.62099 | -0.62099 | -0.62099 | -0.62099 | -0.62099 | -0.62099 | -0.62099 | -0.62099 | -0.62099 |
EBITAT | -4.0 | -1.3 | -12.8 | -26.7 | -23.4 | -20.6 | -28.7 | -40.0 | -55.7 | -77.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -4.0 | -2.1 | -12.4 | -26.4 | -19.4 | -19.4 | -27.6 | -38.4 | -53.5 | -74.4 |
WACC, % | 10.22 | 10.21 | 9.86 | 10.22 | 10.22 | 10.15 | 10.15 | 10.15 | 10.15 | 10.15 |
PV UFCF | ||||||||||
SUM PV UFCF | -151.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -76 | |||||||||
Terminal Value | -932 | |||||||||
Present Terminal Value | -575 | |||||||||
Enterprise Value | -726 | |||||||||
Net Debt | 10 | |||||||||
Equity Value | -736 | |||||||||
Diluted Shares Outstanding, MM | 16 | |||||||||
Equity Value Per Share | -45.26 |
What You Will Get
- Real FTHM Financial Data: Pre-filled with Fathom Holdings Inc.’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Fathom Holdings Inc.’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 DCF Calculator: Offers both unlevered and levered DCF valuation models tailored for Fathom Holdings Inc. (FTHM).
- WACC Calculator: Features a pre-structured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit FTHM's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Fathom Holdings Inc. (FTHM).
- Interactive Dashboard and Charts: Visual representations provide a clear overview of essential valuation metrics for streamlined analysis.
How It Works
- Download: Get the pre-built Excel file containing Fathom Holdings Inc.'s (FTHM) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment choices.
Why Choose This Calculator?
- Accurate Data: Real Fathom Holdings Inc. (FTHM) financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-built calculations save you the effort of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use Fathom Holdings Inc. (FTHM)?
- Real Estate Professionals: Enhance your understanding of market trends and valuation techniques.
- Academics: Utilize Fathom's models for teaching or research in real estate and business.
- Investors: Analyze your investment strategies and evaluate the performance of Fathom Holdings Inc. (FTHM).
- Market Analysts: Optimize your analysis with a customizable model tailored for real estate markets.
- Entrepreneurs: Learn how public companies like Fathom Holdings Inc. (FTHM) navigate the real estate landscape.
What the Template Contains
- Historical Data: Includes Fathom Holdings Inc.'s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Fathom Holdings Inc.'s 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 Fathom Holdings Inc.'s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.