First Foundation Inc. (FFWM) 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
First Foundation Inc. (FFWM) Bundle
Looking to assess the intrinsic value of First Foundation Inc.? Our (FFWM) DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and enhance your investment choices.
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 | 193.9 | 243.8 | 295.0 | 328.7 | 174.9 | 179.8 | 184.9 | 190.2 | 195.6 | 201.2 |
Revenue Growth, % | 0 | 25.78 | 20.96 | 11.45 | -46.81 | 2.84 | 2.84 | 2.84 | 2.84 | 2.84 |
EBITDA | 86.1 | 125.4 | 158.6 | 158.5 | -191.9 | 35.2 | 36.2 | 37.2 | 38.3 | 39.4 |
EBITDA, % | 44.41 | 51.43 | 53.78 | 48.22 | -109.73 | 19.57 | 19.57 | 19.57 | 19.57 | 19.57 |
Depreciation | 5.3 | 5.1 | 4.9 | 5.9 | .0 | 3.0 | 3.1 | 3.2 | 3.2 | 3.3 |
Depreciation, % | 2.74 | 2.09 | 1.66 | 1.81 | 0 | 1.66 | 1.66 | 1.66 | 1.66 | 1.66 |
EBIT | 80.8 | 120.3 | 153.7 | 152.6 | -191.9 | 32.2 | 33.1 | 34.1 | 35.0 | 36.0 |
EBIT, % | 41.67 | 49.34 | 52.12 | 46.41 | -109.73 | 17.91 | 17.91 | 17.91 | 17.91 | 17.91 |
Total Cash | 1,080.4 | 1,437.1 | 2,313.1 | 882.7 | 2,038.1 | 179.8 | 184.9 | 190.2 | 195.6 | 201.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | 54.2 | 11.1 | 11.5 | 11.8 | 12.1 | 12.5 |
Account Receivables, % | 0 | 0 | 0 | 0 | 30.98 | 6.2 | 6.2 | 6.2 | 6.2 | 6.2 |
Inventories | .0 | .0 | .0 | -718.0 | .0 | -36.0 | -37.0 | -38.0 | -39.1 | -40.2 |
Inventories, % | 0 | 0 | 0 | -218.39 | 0 | -20 | -20 | -20 | -20 | -20 |
Accounts Payable | 66.4 | 79.0 | 110.1 | 147.3 | .0 | 53.5 | 55.0 | 56.6 | 58.2 | 59.9 |
Accounts Payable, % | 34.26 | 32.4 | 37.32 | 44.79 | 0 | 29.75 | 29.75 | 29.75 | 29.75 | 29.75 |
Capital Expenditure | -2.2 | -2.9 | -3.2 | -4.6 | -8.2 | -3.4 | -3.5 | -3.6 | -3.7 | -3.8 |
Capital Expenditure, % | -1.15 | -1.17 | -1.09 | -1.39 | -4.7 | -1.9 | -1.9 | -1.9 | -1.9 | -1.9 |
Tax Rate, % | 0.49984 | 0.49984 | 0.49984 | 0.49984 | 0.49984 | 0.49984 | 0.49984 | 0.49984 | 0.49984 | 0.49984 |
EBITAT | 57.2 | 85.5 | 110.9 | 112.5 | -190.9 | 24.9 | 25.6 | 26.4 | 27.1 | 27.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 126.7 | 100.3 | 143.7 | 869.1 | -1,118.5 | 157.0 | 27.4 | 28.2 | 29.0 | 29.8 |
WACC, % | 15.55 | 15.61 | 15.83 | 16.14 | 21.12 | 16.85 | 16.85 | 16.85 | 16.85 | 16.85 |
PV UFCF | ||||||||||
SUM PV UFCF | 201.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 30 | |||||||||
Terminal Value | 205 | |||||||||
Present Terminal Value | 94 | |||||||||
Enterprise Value | 295 | |||||||||
Net Debt | 256 | |||||||||
Equity Value | 40 | |||||||||
Diluted Shares Outstanding, MM | 56 | |||||||||
Equity Value Per Share | 0.70 |
What You Will Get
- Real FFWM Financial Data: Pre-filled with First Foundation 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 First Foundation 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
- 🔍 Real-Life FFWM Financials: Pre-filled historical and projected data for First Foundation Inc. (FFWM).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate First Foundation’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize First Foundation’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-formatted Excel file featuring First Foundation Inc.'s (FFWM) financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC as needed.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare their results.
- Make Decisions: Leverage the valuation insights to inform your investment strategy.
Why Choose This Calculator for First Foundation Inc. (FFWM)?
- Accurate Data: Utilize real financials from First Foundation Inc. (FFWM) for trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the financial sector.
- User-Friendly: Designed with an intuitive interface and clear instructions to facilitate ease of use for everyone.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for portfolio analysis of First Foundation Inc. (FFWM).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in First Foundation Inc. (FFWM).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Finance Enthusiasts: Gain insights into how financial institutions like First Foundation Inc. (FFWM) are valued in the market.
What the Template Contains
- Historical Data: Includes First Foundation Inc.'s (FFWM) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate First Foundation Inc.'s (FFWM) 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 First Foundation Inc.'s (FFWM) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.