Finance Of America Companies Inc. (FOA) 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
Finance Of America Companies Inc. (FOA) Bundle
Enhance your investment strategy with the Finance Of America Companies Inc. (FOA) DCF Calculator! Utilize genuine financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of Finance Of America Companies Inc. (FOA).
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 | 847.6 | 1,739.2 | 1,736.2 | 573.2 | 234.3 | 218.9 | 204.5 | 191.0 | 178.5 | 166.7 |
Revenue Growth, % | 0 | 105.19 | -0.16853 | -66.98 | -59.14 | -6.57 | -6.57 | -6.57 | -6.57 | -6.57 |
EBITDA | 19.0 | .0 | -271.5 | .0 | .0 | -5.9 | -5.5 | -5.1 | -4.8 | -4.5 |
EBITDA, % | 2.24 | 0 | -15.64 | 0 | 0 | -2.68 | -2.68 | -2.68 | -2.68 | -2.68 |
Depreciation | .3 | 2.4 | 1,111.2 | 323.8 | 47.5 | 61.7 | 57.6 | 53.9 | 50.3 | 47.0 |
Depreciation, % | 0.03862673 | 0.13758 | 64 | 56.49 | 20.3 | 28.19 | 28.19 | 28.19 | 28.19 | 28.19 |
EBIT | 18.7 | -2.4 | -1,382.7 | -323.8 | -47.5 | -67.6 | -63.1 | -59.0 | -55.1 | -51.5 |
EBIT, % | 2.2 | -0.13758 | -79.64 | -56.49 | -20.3 | -30.87 | -30.87 | -30.87 | -30.87 | -30.87 |
Total Cash | 1.6 | 247.3 | 141.2 | 18.7 | 46.5 | 20.0 | 18.7 | 17.4 | 16.3 | 15.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | 109.1 | .0 | 104.1 | 22.2 | 20.7 | 19.4 | 18.1 | 16.9 |
Account Receivables, % | 0 | 0 | 6.28 | 0 | 44.46 | 10.15 | 10.15 | 10.15 | 10.15 | 10.15 |
Inventories | .0 | .0 | 580.7 | 293.1 | .0 | 37.0 | 34.6 | 32.3 | 30.2 | 28.2 |
Inventories, % | 0 | -0.00062288512 | 33.44 | 51.12 | 0 | 16.91 | 16.91 | 16.91 | 16.91 | 16.91 |
Accounts Payable | .1 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0.01021653 | 0 | 0 | 0 | 0 | 0.00204331 | 0.00204331 | 0.00204331 | 0.00204331 | 0.00204331 |
Capital Expenditure | -4.3 | -23.1 | -44.1 | -11.2 | .0 | -2.8 | -2.6 | -2.4 | -2.3 | -2.1 |
Capital Expenditure, % | -0.50602 | -1.33 | -2.54 | -1.96 | 0 | -1.27 | -1.27 | -1.27 | -1.27 | -1.27 |
Tax Rate, % | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 |
EBITAT | 18.5 | -2.5 | -1,360.1 | -316.5 | -22.8 | -59.8 | -55.9 | -52.2 | -48.8 | -45.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 14.6 | -23.3 | -982.7 | 392.7 | 213.6 | 44.0 | 3.0 | 2.8 | 2.6 | 2.5 |
WACC, % | 5.27 | 5.33 | 5.24 | 5.21 | 2.6 | 4.73 | 4.73 | 4.73 | 4.73 | 4.73 |
PV UFCF | ||||||||||
SUM PV UFCF | 51.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 3 | |||||||||
Terminal Value | 92 | |||||||||
Present Terminal Value | 73 | |||||||||
Enterprise Value | 125 | |||||||||
Net Debt | 26,240 | |||||||||
Equity Value | -26,116 | |||||||||
Diluted Shares Outstanding, MM | 8 | |||||||||
Equity Value Per Share | -3,185.70 |
What You Will Receive
- Pre-Loaded Financial Model: Finance Of America Companies Inc. (FOA) data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate results as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, enabling ongoing use for in-depth forecasts.
Key Features
- Accurate Financial Data for FOA: Access reliable pre-loaded historical information and future forecasts.
- Tailorable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help you visualize your valuation outcomes.
- Designed for All Users: An intuitive layout catered to investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based FOA DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Finance Of America’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Finance Of America Companies Inc. (FOA)?
- Accurate Data: Utilize real financials from Finance Of America Companies Inc. for trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations mean you won't have to start from ground zero.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the finance sector.
- User-Friendly: Designed with an intuitive interface and guided instructions for ease of use by all individuals.
Who Should Use This Product?
- Investors: Evaluate Finance Of America Companies Inc. (FOA) for informed stock trading decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate financial forecasts.
- Startup Founders: Gain insights into how established firms like Finance Of America Companies Inc. (FOA) are appraised.
- Consultants: Provide comprehensive valuation assessments for your clients.
- Students and Educators: Utilize current market data to teach and practice valuation strategies.
What the Template Contains
- Pre-Filled Data: Includes Finance Of America Companies Inc.'s (FOA) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Finance Of America Companies Inc.'s (FOA) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.