Discounted Cash Flow (DCF) Analysis Unlevered
Technology Select Sector SPDR Fund (XLK)
$143.53
+0.39 (+0.27%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P |
| Revenue |
|---|
| Revenue (%) |
| EBITDA |
| EBITDA (%) |
| EBIT |
| EBIT (%) |
| Depreciation |
| Depreciation (%) |
Balance Sheet Data
Year A/P |
| Total Cash |
|---|
| Total Cash (%) |
| Account Receivables |
| Account Receivables (%) |
| Inventories |
| Inventories (%) |
| Accounts Payable |
| Accounts Payable (%) |
| Capital Expenditure |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 143.53 |
|---|---|
| Beta | 0.000 |
| Diluted Shares Outstanding | - |
| Cost of Debt | |
| Tax Rate | - |
| After-tax Cost of Debt | -% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 3.481 |
| Total Debt | - |
| Total Equity | - |
| Total Capital | - |
| Debt Weighting | - |
| Equity Weighting | - |
| Wacc |
Build Up Free Cash
Year A/P |
| Revenue |
|---|
| EBITDA |
| EBIT |
| Tax Rate |
| EBIAT |
| Depreciation |
| Accounts Receivable |
| Inventories |
| Accounts Payable |
| Capital Expenditure |
| UFCF |
| WACC |
| PV UFCF |
| SUM PV UFCF |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | - |
| Free cash flow (t + 1) | - |
| Terminal Value | - |
| Present Value of Terminal Value | - |
Intrinsic Value
| Enterprise Value | - |
|---|---|
| Net Debt | - |
| Equity Value | - |
| Shares Outstanding | - |
| Equity Value Per Share | - |