Discounted Cash Flow (DCF) Analysis Levered
Microsoft Corp (MSFT)
$214.24
-1.13 (-0.52%)
Free Cash Flow
Year A/P |
| Revenue |
|---|
| Revenue (%) |
| Operating Cash Flow |
| Operating Cash Flow (%) |
| Capital Expenditure |
| Capital Expenditure (%) |
| Free Cash Flow |
Weighted Average Cost Of Capital
| Share price | $ 214.24 |
|---|---|
| Beta | 0.855 |
| Diluted Shares Outstanding | 7,683.00 |
| Cost of Debt | |
| Tax Rate | 16.51 |
| After-tax Cost of Debt | 4.17% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 9.267 |
| Total Debt | 70,998.00 |
| Total Equity | 1,646,005.92 |
| Total Capital | 1,717,003.92 |
| Debt Weighting | 4.13 |
| Equity Weighting | 95.87 |
| Wacc |
Build Up Free Cash Flow
Year A/P |
| Revenue |
|---|
| Operating Cash Flow |
| Capital Expenditure |
| Free Cash Flow |
| WACC |
| PV LFCF |
| SUM PV LFCF |
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 | 49,751.00 |
| Equity Value | - |
| Shares Outstanding | 7,683.00 |
| Equity Value Per Share | - |