Intrinsic Value / DCF Agent
Company-specific DCF, reverse DCF, sensitivity, and margin-of-safety view. This does not feed the whole-market score.
MSFT | Microsoft Corporation
MSFT screen-grade DCF value is 129.03/share versus live price 492.60 (-73.8% to value). Margin-of-safety price is 96.77; reverse DCF implies outside the model bracket.
Calculation integrity: OK
Decision readiness: Screen-grade only; forecast growth, WACC, terminal growth, and EV-to-equity bridge require investor review.
Ticker-only score, excluded from whole-market FS score.
Assumptions
| Years | FCF Growth | WACC | Terminal Growth | Margin Of Safety |
|---|---|---|---|---|
| 5 | 4.04% | 10.29% | 2.50% | 25.00% |
Observed Facts
| Fact | Source Field | Value | As Of | Period |
|---|---|---|---|---|
| Base FCF | trailingFreeCashFlow | 66.99B | 2026-06-30 | TTM USD |
| Net Income | trailingNetIncome | 133.75B | 2026-06-30 | TTM USD |
| Operating Income | trailingOperatingIncome | 155.24B | 2026-06-30 | TTM USD |
| Invested Capital | quarterlyInvestedCapital | 482.68B | 2026-06-30 | 3M USD |
| Share Count | quarterlyDilutedAverageShares | 7.44B | 2026-06-30 | 3M USD |
| Cash And Short-Term Investments | quarterlyCashCashEquivalentsAndShortTermInvestments | 76.65B | 2026-06-30 | 3M USD |
| Total Debt | quarterlyTotalDebt | 56.83B | 2026-06-30 | 3M USD |
| 10Y Treasury Proxy | Yahoo chart endpoint | +4.79% | current | Rate input for default WACC |
Valuation Bridge
Forecast
| Year | FCF | Discount Factor | PV |
|---|---|---|---|
| 1 | 69.69B | 0.907 | 63.19B |
| 2 | 72.51B | 0.822 | 59.61B |
| 3 | 75.44B | 0.745 | 56.23B |
| 4 | 78.49B | 0.676 | 53.05B |
| 5 | 81.66B | 0.613 | 50.04B |
Sensitivity
| WACC | Terminal Growth | Value / Share |
|---|---|---|
| 9.29% | 2.00% | 140.03 |
| 9.29% | 2.50% | 147.80 |
| 9.29% | 3.00% | 156.80 |
| 10.29% | 2.00% | 123.29 |
| 10.29% | 2.50% | 129.03 |
| 10.29% | 3.00% | 135.56 |
| 11.29% | 2.00% | 110.15 |
| 11.29% | 2.50% | 114.53 |
| 11.29% | 3.00% | 119.44 |
Warnings
- Reverse DCF did not solve inside the -20% to +30% annual FCF growth bracket.
Sources
- Yahoo chart endpoint for live price
- Yahoo fundamentals time-series for FCF, net income, operating income, invested capital, share count, cash, and debt
- Yahoo chart endpoint for 10Y Treasury proxy
Owner-Minded Checklist
Simple screen: low price, high earnings yield, high return on capital. Passing the screen is not permission to buy; it earns deeper work.
Upside to DCF value: -73.81%
Higher means more earnings for each dollar paid.
High is attractive unless reinvestment quality is poor.
Operating income divided by invested capital when available.
Need To Know
- MOAT: MOAT is a competitive-advantage gate, not a price datapoint. Look for durable pricing power, switching costs, network effects, cost advantage, brand, distribution, or regulation.
- ROC: High ROC means each retained dollar can become more dollars. That is the engine behind compounding.
- Negative cash flow: It can be good when the cash is building high-ROC capacity, like stores, factories, software, or distribution that earn more later. It is bad when it only funds weak unit economics or survival.
- Kleiber's Law lens: Use log-log charts to compare company scale against output such as earnings, FCF, or ROC. A strong business keeps output scaling well as size grows; a weak one needs more capital for less incremental return.