Legacy Housing Corporation (LEGH) 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
Legacy Housing Corporation (LEGH) Bundle
Evaluate the financial prospects of Legacy Housing Corporation (LEGH) like an expert! This (LEGH) DCF Calculator provides you with pre-filled financial data and the flexibility to modify revenue growth, WACC, profit margins, and other crucial assumptions to align with your predictions.
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 | 169.0 | 176.7 | 197.5 | 257.0 | 189.1 | 198.6 | 208.6 | 219.1 | 230.1 | 241.6 |
Revenue Growth, % | 0 | 4.6 | 11.76 | 30.13 | -26.41 | 5.02 | 5.02 | 5.02 | 5.02 | 5.02 |
EBITDA | 39.3 | 51.1 | 63.1 | 84.3 | 71.4 | 61.4 | 64.5 | 67.8 | 71.2 | 74.7 |
EBITDA, % | 23.26 | 28.91 | 31.95 | 32.8 | 37.74 | 30.93 | 30.93 | 30.93 | 30.93 | 30.93 |
Depreciation | 1.0 | 1.2 | 1.6 | 1.8 | 1.7 | 1.5 | 1.5 | 1.6 | 1.7 | 1.8 |
Depreciation, % | 0.60016 | 0.68582 | 0.80352 | 0.69296 | 0.91253 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 |
EBIT | 38.3 | 49.9 | 61.5 | 82.5 | 69.7 | 60.0 | 63.0 | 66.2 | 69.5 | 73.0 |
EBIT, % | 22.66 | 28.22 | 31.15 | 32.11 | 36.83 | 30.19 | 30.19 | 30.19 | 30.19 | 30.19 |
Total Cash | 1.7 | .8 | 1.0 | 11.2 | .7 | 2.7 | 2.8 | 3.0 | 3.1 | 3.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 19.2 | 23.7 | 45.8 | 59.7 | 69.0 | 42.8 | 44.9 | 47.2 | 49.6 | 52.0 |
Account Receivables, % | 11.34 | 13.43 | 23.2 | 23.23 | 36.5 | 21.54 | 21.54 | 21.54 | 21.54 | 21.54 |
Inventories | 27.2 | 27.2 | 41.2 | 32.1 | 33.2 | 32.7 | 34.4 | 36.1 | 37.9 | 39.8 |
Inventories, % | 16.12 | 15.4 | 20.88 | 12.48 | 17.54 | 16.48 | 16.48 | 16.48 | 16.48 | 16.48 |
Accounts Payable | 5.2 | 10.2 | 4.2 | 4.5 | 4.1 | 5.9 | 6.2 | 6.5 | 6.8 | 7.2 |
Accounts Payable, % | 3.06 | 5.77 | 2.1 | 1.77 | 2.16 | 2.97 | 2.97 | 2.97 | 2.97 | 2.97 |
Capital Expenditure | -4.2 | -2.8 | -6.0 | -3.8 | -7.7 | -5.0 | -5.3 | -5.6 | -5.8 | -6.1 |
Capital Expenditure, % | -2.49 | -1.61 | -3.01 | -1.48 | -4.08 | -2.53 | -2.53 | -2.53 | -2.53 | -2.53 |
Tax Rate, % | 20.77 | 20.77 | 20.77 | 20.77 | 20.77 | 20.77 | 20.77 | 20.77 | 20.77 | 20.77 |
EBITAT | 29.4 | 38.8 | 50.6 | 68.1 | 55.2 | 47.8 | 50.2 | 52.7 | 55.4 | 58.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -15.0 | 37.6 | 4.1 | 61.7 | 38.3 | 72.7 | 43.0 | 45.1 | 47.4 | 49.8 |
WACC, % | 9.36 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 |
PV UFCF | ||||||||||
SUM PV UFCF | 201.9 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | 50 | |||||||||
Terminal Value | 601 | |||||||||
Present Terminal Value | 384 | |||||||||
Enterprise Value | 586 | |||||||||
Net Debt | 25 | |||||||||
Equity Value | 561 | |||||||||
Diluted Shares Outstanding, MM | 25 | |||||||||
Equity Value Per Share | 22.37 |
What You Will Get
- Authentic LEGH Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess Legacy Housing's future performance.
- User-Friendly Interface: Designed for professionals while remaining easy for newcomers to navigate.
Key Features
- 🔍 Real-Life LEGH Financials: Pre-filled historical and projected data for Legacy Housing Corporation (LEGH).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Legacy Housing’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Legacy Housing’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-built Excel file featuring Legacy Housing Corporation’s (LEGH) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly assess different outcomes.
- Make Decisions: Leverage the valuation results to inform your investment choices.
Why Choose This Calculator for Legacy Housing Corporation (LEGH)?
- Accuracy: Utilizes real Legacy Housing financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Investors: Accurately assess Legacy Housing Corporation’s (LEGH) fair value before making investment choices.
- CFOs: Utilize a top-tier DCF model for financial reporting and analysis related to Legacy Housing Corporation (LEGH).
- Consultants: Efficiently customize the template for valuation reports tailored to clients focused on Legacy Housing Corporation (LEGH).
- Entrepreneurs: Obtain insights into financial modeling practices employed by leading housing corporations like Legacy Housing Corporation (LEGH).
- Educators: Employ it as an educational resource to illustrate valuation techniques relevant to Legacy Housing Corporation (LEGH).
What the Template Contains
- Pre-Filled DCF Model: Legacy Housing Corporation’s (LEGH) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Legacy Housing Corporation’s (LEGH) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.