Landsea Homes Corporation (LSEA) 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
Landsea Homes Corporation (LSEA) Bundle
Designed for accuracy, our (LSEA) DCF Calculator enables you to evaluate the valuation of Landsea Homes Corporation using real-world financial data, while offering complete flexibility to modify all essential parameters for improved projections.
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 | 631.0 | 734.6 | 1,023.3 | 1,446.4 | 1,209.9 | 1,454.1 | 1,747.6 | 2,100.2 | 2,524.1 | 3,033.4 |
| Revenue Growth, % | 0 | 16.42 | 39.3 | 41.35 | -16.35 | 20.18 | 20.18 | 20.18 | 20.18 | 20.18 |
| EBITDA | 41.0 | 7.8 | 64.9 | 113.8 | 45.4 | 74.2 | 89.2 | 107.2 | 128.8 | 154.8 |
| EBITDA, % | 6.5 | 1.06 | 6.34 | 7.87 | 3.75 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 |
| Depreciation | 3.0 | 3.6 | 5.4 | 5.5 | 5.1 | 6.7 | 8.0 | 9.6 | 11.6 | 13.9 |
| Depreciation, % | 0.46911 | 0.48733 | 0.52702 | 0.38363 | 0.42184 | 0.45778 | 0.45778 | 0.45778 | 0.45778 | 0.45778 |
| EBIT | 38.1 | 4.2 | 59.5 | 108.3 | 40.3 | 67.6 | 81.2 | 97.6 | 117.3 | 140.9 |
| EBIT, % | 6.03 | 0.56806 | 5.81 | 7.49 | 3.33 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 |
| Total Cash | .2 | 105.8 | 342.8 | 123.6 | 119.6 | 193.0 | 231.9 | 278.7 | 335.0 | 402.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | 2.7 | 10.6 | 38.0 | 6.0 | 13.1 | 15.8 | 19.0 | 22.8 | 27.4 |
| Account Receivables, % | 0 | 0.36251 | 1.04 | 2.63 | 0.49209 | 0.90393 | 0.90393 | 0.90393 | 0.90393 | 0.90393 |
| Inventories | 598.2 | 687.8 | 844.8 | 1,093.4 | 1,121.7 | 1,277.5 | 1,535.4 | 1,845.2 | 2,217.6 | 2,665.1 |
| Inventories, % | 94.8 | 93.63 | 82.56 | 75.59 | 92.71 | 87.86 | 87.86 | 87.86 | 87.86 | 87.86 |
| Accounts Payable | .1 | 36.2 | 73.7 | 74.4 | 78.0 | 69.1 | 83.0 | 99.8 | 119.9 | 144.1 |
| Accounts Payable, % | 0.01925805 | 4.93 | 7.21 | 5.15 | 6.44 | 4.75 | 4.75 | 4.75 | 4.75 | 4.75 |
| Capital Expenditure | -5.6 | -1.8 | -3.2 | -5.5 | -7.5 | -7.1 | -8.5 | -10.2 | -12.3 | -14.8 |
| Capital Expenditure, % | -0.88512 | -0.24421 | -0.31037 | -0.3781 | -0.61804 | -0.48717 | -0.48717 | -0.48717 | -0.48717 | -0.48717 |
| Tax Rate, % | 34.37 | 34.37 | 34.37 | 34.37 | 34.37 | 34.37 | 34.37 | 34.37 | 34.37 | 34.37 |
| EBITAT | 22.9 | 3.1 | 47.1 | 78.8 | 26.4 | 47.6 | 57.2 | 68.8 | 82.7 | 99.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -577.8 | -51.3 | -78.1 | -196.4 | 31.3 | -124.7 | -189.8 | -228.1 | -274.2 | -329.5 |
| WACC, % | 5.37 | 5.77 | 5.89 | 5.72 | 5.52 | 5.66 | 5.66 | 5.66 | 5.66 | 5.66 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -951.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -336 | |||||||||
| Terminal Value | -9,191 | |||||||||
| Present Terminal Value | -6,981 | |||||||||
| Enterprise Value | -7,932 | |||||||||
| Net Debt | 437 | |||||||||
| Equity Value | -8,370 | |||||||||
| Diluted Shares Outstanding, MM | 39 | |||||||||
| Equity Value Per Share | -214.19 |
What You Will Receive
- Authentic LSEA Financial Data: Pre-filled with Landsea Homes Corporation’s historical and projected figures for accurate analysis.
- Completely Customizable Template: Adjust essential inputs like revenue growth, WACC, and EBITDA % effortlessly.
- Instant Calculations: Observe Landsea's intrinsic value update in real-time based on your modifications.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF results.
- User-Friendly Interface: Straightforward layout and clear guidance suitable for all levels of expertise.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Landsea Homes Corporation (LSEA).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs specific to the housing market.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Landsea's strategic plans.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Landsea Homes Corporation (LSEA).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the ready-to-use Excel file containing Landsea Homes Corporation's (LSEA) financial data.
- Customize: Modify forecasts, including revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy for Landsea Homes Corporation (LSEA).
Why Choose This Calculator for Landsea Homes Corporation (LSEA)?
- Accurate Data: Utilize real Landsea Homes financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the real estate sector.
- User-Friendly: Easy-to-navigate design and guided instructions ensure accessibility for all users.
Who Should Use This Product?
- Real Estate Students: Understand market analysis techniques and apply them using real-time data.
- Researchers: Integrate industry-specific models into academic studies or papers.
- Homebuyers: Evaluate your own investment strategies and assess property valuations for Landsea Homes Corporation (LSEA).
- Market Analysts: Enhance your analysis process with a ready-to-use, customizable valuation model.
- Real Estate Investors: Discover how major homebuilders like Landsea Homes Corporation (LSEA) are evaluated in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Landsea Homes Corporation (LSEA) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Landsea Homes Corporation (LSEA).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.