Safehold Inc. (SAFE) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Safehold Inc. (SAFE) Bundle
Evaluate Safehold Inc.'s (SAFE) financial outlook with expert precision! This (SAFE) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, margins, and other essential 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 | 93.4 | 155.4 | 187.0 | 158.1 | 352.6 | 503.5 | 719.1 | 1,027.0 | 1,466.7 | 2,094.6 |
Revenue Growth, % | 0 | 66.42 | 20.32 | -15.49 | 123.08 | 42.81 | 42.81 | 42.81 | 42.81 | 42.81 |
EBITDA | 77.5 | 135.9 | 163.4 | 229.8 | 140.4 | 400.4 | 571.9 | 816.7 | 1,166.4 | 1,665.8 |
EBITDA, % | 82.97 | 87.45 | 87.39 | 145.37 | 39.82 | 79.53 | 79.53 | 79.53 | 79.53 | 79.53 |
Depreciation | 378.6 | 341.5 | 356.8 | 195.7 | 12.2 | 406.3 | 580.3 | 828.7 | 1,183.5 | 1,690.2 |
Depreciation, % | 405.33 | 219.69 | 190.77 | 123.83 | 3.47 | 80.69 | 80.69 | 80.69 | 80.69 | 80.69 |
EBIT | -301.1 | -205.5 | -193.3 | 34.1 | 128.2 | -243.8 | -348.2 | -497.3 | -710.2 | -1,014.2 |
EBIT, % | -322.35 | -132.23 | -103.38 | 21.55 | 36.35 | -48.42 | -48.42 | -48.42 | -48.42 | -48.42 |
Total Cash | 22.7 | 56.9 | 29.6 | 1,442.3 | 28.5 | 186.2 | 265.9 | 379.7 | 542.3 | 774.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,440.0 | 1,976.3 | 3,326.3 | 4,630.2 | 1,914.4 | 503.5 | 719.1 | 1,027.0 | 1,466.7 | 2,094.6 |
Account Receivables, % | 1541.81 | 1271.52 | 1778.63 | 2929.55 | 542.98 | 100 | 100 | 100 | 100 | 100 |
Inventories | 8.7 | 5.2 | .3 | 4.0 | .0 | 15.4 | 22.0 | 31.4 | 44.9 | 64.1 |
Inventories, % | 9.26 | 3.35 | 0.16095 | 2.52 | 0 | 3.06 | 3.06 | 3.06 | 3.06 | 3.06 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | -1,362.6 | -56.8 | -1,248.0 | -23.1 | -7.2 | -254.9 | -364.1 | -520.0 | -742.6 | -1,060.5 |
Capital Expenditure, % | -1458.94 | -36.51 | -667.32 | -14.59 | -2.06 | -50.63 | -50.63 | -50.63 | -50.63 | -50.63 |
Tax Rate, % | -4.02 | -4.02 | -4.02 | -4.02 | -4.02 | -4.02 | -4.02 | -4.02 | -4.02 | -4.02 |
EBITAT | -247.2 | -204.9 | -192.7 | 34.2 | 133.3 | -234.8 | -335.3 | -478.8 | -683.8 | -976.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -2,679.9 | -453.0 | -2,429.0 | -1,100.8 | 2,858.0 | 1,312.1 | -341.3 | -487.4 | -696.0 | -994.0 |
WACC, % | 4.92 | 5.53 | 5.53 | 5.54 | 5.54 | 5.41 | 5.41 | 5.41 | 5.41 | 5.41 |
PV UFCF | ||||||||||
SUM PV UFCF | -805.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1,014 | |||||||||
Terminal Value | -29,692 | |||||||||
Present Terminal Value | -22,810 | |||||||||
Enterprise Value | -23,616 | |||||||||
Net Debt | 3,951 | |||||||||
Equity Value | -27,567 | |||||||||
Diluted Shares Outstanding, MM | 67 | |||||||||
Equity Value Per Share | -413.36 |
What You Will Receive
- Authentic SAFE Financial Data: Pre-loaded with Safehold Inc.'s historical and forecasted data for thorough analysis.
- Completely Customizable Template: Easily adjust key metrics such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch Safehold Inc.'s intrinsic value update in real-time as you make adjustments.
- Expert Valuation Tool: Crafted for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidance suitable for all skill levels.
Key Features
- Customizable Investment Metrics: Adjust essential factors such as rental income growth, cap rate, and operating expenses.
- Instant DCF Analysis: Quickly determines intrinsic value, NPV, and additional financial metrics.
- High-Precision Valuation: Leverages Safehold Inc.'s (SAFE) actual financial data for accurate valuation results.
- Effortless Scenario Testing: Easily evaluate various assumptions and assess different outcomes.
- Efficiency Booster: Streamlines the valuation process, removing the need for complex model construction.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Safehold Inc. (SAFE) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Safehold Inc.'s (SAFE) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Safehold Inc. (SAFE)?
- Accurate Data: Utilizes real Safehold Inc. financials for trustworthy valuation outcomes.
- Customizable: Modify essential parameters like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the effort of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the industry.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use Safehold Inc. (SAFE)?
- Real Estate Students: Explore innovative land lease models and apply them to real-world scenarios.
- Researchers: Utilize Safehold's data for studies on land use and urban development trends.
- Investors: Evaluate your investment strategies by analyzing the performance of Safehold Inc. (SAFE).
- Financial Analysts: Enhance your analysis with a comprehensive understanding of Safehold's business model.
- Property Developers: Learn from Safehold's approach to land leasing and its impact on real estate projects.
What the Template Contains
- Pre-Filled Data: Contains Safehold Inc.'s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A specific sheet for calculating WACC using custom inputs.
- Key Financial Ratios: Evaluate Safehold Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Easily adjust revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.