Tanger Factory Outlet Centers, Inc. (SKT) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Tanger Factory Outlet Centers, Inc. (SKT) Bundle
Engineered for accuracy, our (SKT) DCF Calculator empowers you to evaluate Tanger Factory Outlet Centers, Inc. valuation using real-world financial data, granting you the 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 | 478.3 | 390.0 | 426.5 | 442.6 | 464.4 | 463.9 | 463.5 | 463.0 | 462.5 | 462.0 |
Revenue Growth, % | 0 | -18.47 | 9.37 | 3.77 | 4.92 | -0.10189 | -0.10189 | -0.10189 | -0.10189 | -0.10189 |
EBITDA | 271.9 | 207.2 | 227.3 | 241.8 | 242.7 | 250.7 | 250.4 | 250.1 | 249.9 | 249.6 |
EBITDA, % | 56.84 | 53.12 | 53.29 | 54.62 | 52.27 | 54.03 | 54.03 | 54.03 | 54.03 | 54.03 |
Depreciation | 334.8 | 302.0 | 316.6 | 327.4 | 108.9 | 296.1 | 295.8 | 295.5 | 295.1 | 294.8 |
Depreciation, % | 70 | 77.44 | 74.22 | 73.96 | 23.45 | 63.81 | 63.81 | 63.81 | 63.81 | 63.81 |
EBIT | -62.9 | -94.8 | -89.3 | -85.6 | 133.8 | -45.4 | -45.4 | -45.3 | -45.3 | -45.2 |
EBIT, % | -13.16 | -24.32 | -20.93 | -19.34 | 28.82 | -9.79 | -9.79 | -9.79 | -9.79 | -9.79 |
Total Cash | 16.7 | 84.8 | 161.3 | 264.6 | 22.0 | 118.3 | 118.2 | 118.1 | 118.0 | 117.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 61.6 | 65.8 | 53.3 | .0 | .0 | 39.2 | 39.2 | 39.1 | 39.1 | 39.0 |
Account Receivables, % | 12.88 | 16.87 | 12.5 | 0 | 0 | 8.45 | 8.45 | 8.45 | 8.45 | 8.45 |
Inventories | -1.0 | .0 | -2.5 | -14.1 | .0 | -3.7 | -3.7 | -3.7 | -3.7 | -3.7 |
Inventories, % | -0.21282 | 0 | -0.58262 | -3.19 | 0 | -0.79702 | -0.79702 | -0.79702 | -0.79702 | -0.79702 |
Accounts Payable | 79.6 | 88.3 | 93.0 | 104.7 | 118.5 | 102.3 | 102.2 | 102.1 | 102.0 | 101.9 |
Accounts Payable, % | 16.63 | 22.63 | 21.8 | 23.66 | 25.52 | 22.05 | 22.05 | 22.05 | 22.05 | 22.05 |
Capital Expenditure | -40.2 | -28.0 | -45.9 | -47.4 | -3.1 | -35.0 | -35.0 | -34.9 | -34.9 | -34.8 |
Capital Expenditure, % | -8.4 | -7.18 | -10.77 | -10.7 | -0.66773 | -7.54 | -7.54 | -7.54 | -7.54 | -7.54 |
Tax Rate, % | 4.55 | 4.55 | 4.55 | 4.55 | 4.55 | 4.55 | 4.55 | 4.55 | 4.55 | 4.55 |
EBITAT | -14.3 | -253.2 | 476.9 | -37.9 | 127.7 | -23.8 | -23.8 | -23.8 | -23.8 | -23.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 299.3 | 24.3 | 767.3 | 318.8 | 233.2 | 185.5 | 236.9 | 236.7 | 236.4 | 236.2 |
WACC, % | 9.53 | 10.55 | 9.23 | 9.82 | 10.49 | 9.92 | 9.92 | 9.92 | 9.92 | 9.92 |
PV UFCF | ||||||||||
SUM PV UFCF | 852.1 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 246 | |||||||||
Terminal Value | 4,147 | |||||||||
Present Terminal Value | 2,584 | |||||||||
Enterprise Value | 3,436 | |||||||||
Net Debt | 1,513 | |||||||||
Equity Value | 1,924 | |||||||||
Diluted Shares Outstanding, MM | 107 | |||||||||
Equity Value Per Share | 18.06 |
What You Will Get
- Real SKT Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are calculated in real-time.
- Scenario Analysis: Explore various scenarios to assess Tanger Factory Outlet Centers' future performance.
- User-Friendly Interface: Designed for professionals but easy to navigate for newcomers.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as rental income growth, operating margins, and capital expenditures.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and other financial metrics with ease.
- High-Precision Accuracy: Incorporates Tanger Factory Outlet Centers, Inc. (SKT)'s actual financial data for reliable valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze outcomes without hassle.
- Efficiency Booster: Streamline the valuation process without the need for intricate model building.
How It Works
- 1. Access the Template: Download and open the Excel file containing Tanger Factory Outlet Centers, Inc.'s (SKT) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. View Results in Real-Time: The DCF model automatically calculates the intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate multiple forecasts to assess various valuation outcomes for Tanger Factory Outlet Centers, Inc. (SKT).
- 5. Present with Assurance: Share professional valuation insights to enhance your decision-making process.
Why Choose This Calculator for Tanger Factory Outlet Centers, Inc. (SKT)?
- User-Friendly Interface: Perfect for both novices and seasoned investors.
- Customizable Inputs: Adjust parameters to tailor your financial analysis.
- Real-Time Valuation Updates: Instantly see how changes affect Tanger's valuation as you modify inputs.
- Preloaded Financial Data: Comes with Tanger's actual financial metrics for immediate analysis.
- Relied Upon by Experts: Widely used by analysts and investors for strategic decision-making.
Who Should Use Tanger Factory Outlet Centers, Inc. (SKT)?
- Real Estate Investors: Gain insights into retail property valuation and investment opportunities.
- Market Analysts: Utilize comprehensive data to assess the performance of outlet centers.
- Retail Consultants: Tailor analytics for client strategies and market positioning.
- Retail Enthusiasts: Explore trends and developments in the outlet shopping sector.
- Students and Educators: Leverage case studies and data for practical learning in real estate and finance courses.
What the Template Contains
- Historical Data: Includes Tanger Factory Outlet Centers, Inc.'s (SKT) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Tanger Factory Outlet Centers, Inc.'s (SKT) 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 Tanger Factory Outlet Centers, Inc.'s (SKT) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.