The St. Joe Company (JOE) 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
The St. Joe Company (JOE) Bundle
Explore The St. Joe Company's (JOE) financial prospects with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and expenses to calculate The St. Joe Company's (JOE) intrinsic value and enhance your investment strategy.
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 | 127.1 | 160.5 | 267.0 | 252.3 | 389.3 | 526.9 | 713.2 | 965.4 | 1,306.7 | 1,768.7 |
Revenue Growth, % | 0 | 26.28 | 66.36 | -5.51 | 54.29 | 35.36 | 35.36 | 35.36 | 35.36 | 35.36 |
EBITDA | 40.3 | 57.9 | 112.7 | 84.4 | 129.5 | 186.2 | 252.0 | 341.1 | 461.7 | 624.9 |
EBITDA, % | 31.72 | 36.06 | 42.19 | 33.43 | 33.27 | 35.33 | 35.33 | 35.33 | 35.33 | 35.33 |
Depreciation | 101.1 | 113.5 | 174.4 | 190.9 | 38.8 | 317.4 | 429.6 | 581.5 | 787.1 | 1,065.4 |
Depreciation, % | 79.55 | 70.7 | 65.32 | 75.66 | 9.96 | 60.24 | 60.24 | 60.24 | 60.24 | 60.24 |
EBIT | -60.8 | -55.6 | -61.8 | -106.5 | 90.7 | -131.2 | -177.6 | -240.4 | -325.4 | -440.4 |
EBIT, % | -47.83 | -34.64 | -23.13 | -42.22 | 23.31 | -24.9 | -24.9 | -24.9 | -24.9 | -24.9 |
Total Cash | 185.8 | 154.9 | 159.2 | 78.3 | 86.1 | 325.9 | 441.2 | 597.1 | 808.3 | 1,094.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | 30.3 | 36.8 | 23.8 | 49.6 | 57.8 | 78.2 | 105.9 | 143.3 | 193.9 |
Account Receivables, % | 0 | 18.87 | 13.77 | 9.43 | 12.75 | 10.97 | 10.97 | 10.97 | 10.97 | 10.97 |
Inventories | 1.4 | 2.0 | 2.8 | 4.0 | 4.3 | 6.4 | 8.7 | 11.7 | 15.9 | 21.5 |
Inventories, % | 1.09 | 1.26 | 1.05 | 1.58 | 1.09 | 1.21 | 1.21 | 1.21 | 1.21 | 1.21 |
Accounts Payable | 16.2 | 25.4 | 48.6 | 69.9 | 24.3 | 85.1 | 115.1 | 155.8 | 210.9 | 285.5 |
Accounts Payable, % | 12.75 | 15.81 | 18.2 | 27.69 | 6.25 | 16.14 | 16.14 | 16.14 | 16.14 | 16.14 |
Capital Expenditure | -74.2 | -121.8 | -153.5 | -259.2 | -140.0 | -345.3 | -467.4 | -632.7 | -856.4 | -1,159.2 |
Capital Expenditure, % | -58.38 | -75.87 | -57.49 | -102.72 | -35.95 | -65.54 | -65.54 | -65.54 | -65.54 | -65.54 |
Tax Rate, % | 22.34 | 22.34 | 22.34 | 22.34 | 22.34 | 22.34 | 22.34 | 22.34 | 22.34 | 22.34 |
EBITAT | -45.0 | -42.0 | -46.2 | -79.9 | 70.5 | -99.0 | -134.0 | -181.3 | -245.4 | -332.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -3.3 | -72.1 | -9.4 | -115.1 | -102.4 | -76.5 | -164.4 | -222.5 | -301.2 | -407.7 |
WACC, % | 9.1 | 9.11 | 9.11 | 9.11 | 9.13 | 9.11 | 9.11 | 9.11 | 9.11 | 9.11 |
PV UFCF | ||||||||||
SUM PV UFCF | -855.6 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | -412 | |||||||||
Terminal Value | -5,077 | |||||||||
Present Terminal Value | -3,283 | |||||||||
Enterprise Value | -4,139 | |||||||||
Net Debt | 547 | |||||||||
Equity Value | -4,685 | |||||||||
Diluted Shares Outstanding, MM | 58 | |||||||||
Equity Value Per Share | -80.33 |
What You Will Receive
- Pre-Filled Financial Model: The St. Joe Company’s actual 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 you adjust parameters.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive JOE Data: Pre-filled with The St. Joe Company's historical performance metrics and future projections.
- Customizable Parameters: Modify revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your specified inputs.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive Interface: Designed for ease of use, catering to both experienced professionals and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file featuring The St. Joe Company's (JOE) preloaded data.
- 2. Modify Assumptions: Adjust key variables such as growth projections, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically computes intrinsic value and NPV in real time.
- 4. Explore Scenarios: Evaluate multiple forecasts to examine various valuation possibilities.
- 5. Present with Assurance: Deliver expert valuation insights to enhance your decision-making process.
Why Choose The St. Joe Company (JOE)?
- Exceptional Growth Potential: Invest in a company with a strong track record of development and expansion.
- Strategic Location: Benefit from properties situated in prime locations with high demand.
- Expert Management: Rely on a team with extensive experience in real estate and land development.
- Commitment to Sustainability: Engage with a company focused on environmentally responsible practices.
- Strong Community Engagement: Participate in a firm that values and invests in local communities.
Who Should Use This Product?
- Finance Students: Master valuation techniques and apply them using real data from The St. Joe Company (JOE).
- Academics: Integrate professional models into your coursework or research focused on The St. Joe Company (JOE).
- Investors: Validate your assumptions and analyze valuation outcomes for The St. Joe Company (JOE) stock.
- Analysts: Enhance your workflow with a pre-built, customizable DCF model tailored for The St. Joe Company (JOE).
- Small Business Owners: Understand the analytical methods used for evaluating large public companies like The St. Joe Company (JOE).
What the Template Contains
- Historical Data: Includes The St. Joe Company's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate The St. Joe Company'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 The St. Joe Company's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.