Microsoft [MSFT]
Task 5 · investment-memo skill v1.4.0 · 2026-07-27 · spot $389.10
Updated 2026-07-29 — Criteria + two-horizon valuation. The numbered Gates are retired and replaced by named Criteria with types (BINDING / MEASURED) returning PASS / FAIL / INDETERMINATE. This memo no longer issues a position verdict — no Long, Short, Watchlist or Avoid. The expected-return-versus-cash-hurdle test is replaced by a reverse-DCF implied-path test plus a 12-month target, with sensitivity run over the exit multiple rather than over scenario probabilities. Momentum is entry timing only and vetoes nothing. Sections below that predate this update are retained as the historical record and are annotated where superseded.
Reading the retired "Gate N" numbering. Any
Gate Nbelow is historical. The mapping is: Gate 1 → Quality Criteria (BINDING) · Gate 1b → Short Mechanism Criteria (MEASURED) · Gate 2 / 2A / 2B / Path B → dissolved, absorbed by the Valuation Criteria · Gate 2C → Peer Spread Criteria (MEASURED) · Gate 3 → Catalyst Criteria (MEASURED) · Gate 4 / 4a → Valuation Criteria (BINDING) · Gate 5 → Liquidity Criteria (BINDING) · Gate 6 → Momentum Criteria (MEASURED, entry timing only) · (new) Downside Criteria (MEASURED). A Criteria returns PASS / FAIL / INDETERMINATE; a missing input is INDETERMINATE, never FAIL. Historical calibration items keep the old numbering on purpose — the record is the record.
portfolio-book contract, executedportfolio_book.json read at 2026-07-27.
| Positions | None. The book is 100% cash. |
| Watchlist | MU, ISRG, NET, SMR, NBIS |
| Max single-name weight | 5.0% |
| Max gross / net exposure | 100% / 100% |
| Max pairwise correlation without disclosure | 0.60 |
| Max sector concentration | 25% |
| Cash hurdle (annual) | 4.70% |
| Drawdown ladder | review −5% · de-gross −10% (40% of book) · stop −15% |
| Position hard stop | −2% of book |
The brief anticipated that "a hyperscaler long is correlated with all of them." Computed from trailing daily returns, that is wrong, and the finding is worth more than the assumption it replaces.
Trailing 1-year daily-return correlation (252 sessions to 2026-07-27, Alpaca SIP):
| MU | NBIS | NET | SNDK | CIEN | AAOI | NVDA | CRWV | SPY | QQQ | |
|---|---|---|---|---|---|---|---|---|---|---|
| MSFT | −0.02 | +0.14 | +0.36 | −0.03 | +0.01 | +0.04 | +0.28 | +0.23 | +0.35 | +0.30 |
| GOOGL | +0.24 | +0.18 | +0.11 | +0.26 | +0.20 | +0.17 | +0.27 | +0.15 | +0.57 | +0.52 |
Trailing 6-month (the live AI-capex-fear regime) — the divergence widens:
| MU | NBIS | NET | SNDK | CIEN | AAOI | |
|---|---|---|---|---|---|---|
| MSFT | −0.11 | +0.16 | +0.39 | −0.15 | −0.13 | −0.01 |
| GOOGL | +0.17 | +0.13 | +0.05 | +0.22 | +0.13 | +0.12 |
MSFT's mean correlation to the six-name AI-infrastructure book is +0.08 over one year and slightly NEGATIVE over six months. The within-book mean pairwise correlation is +0.35. MSFT–GOOGL is only +0.13.
Why, and it is not a statistical accident. The underwriting book (MU, NBIS, NET, SNDK, CIEN, AAOI) is composed of AI-capex receivers. Microsoft and Alphabet are AI-capex payers. When Alphabet raised capex guidance on 22 July, GOOGL fell 7.1% — and that same news is revenue for the memory, optics and neocloud names. They are on opposite sides of the same trade, which is precisely why the six-month correlations turn negative.
Portfolio implication, stated explicitly: a hyperscaler long would be a genuine diversifier against the existing watchlist cluster, not an addition to it. That is a real point in its favour — and, exactly as with ISRG, diversification cannot rescue a position whose standalone expected return is negative. It is a reason to prioritise the name if and when its E[R] clears, not a reason to own it at $389.10.
The cash-hurdle test is retired (references/criteria.md: "The cash hurdle, replaced by slot competition
in the strategy"). Whether this analysis wins a slot against the book's alternatives is a question for the
book, not for the memo, and the memo does not answer it. The portfolio facts above are recorded because they
are inputs a strategy would need — not because a conclusion is drawn from them here.
ΔE = house − Street is approximately zero for FY2026 and
modestly negative-but-inside-the-range for FY2027.Per ~/.claude/skills/investment-memo/references/criteria.md, every test is a named Criteria carrying a
type, and returns PASS / FAIL / INDETERMINATE.
A missing input is INDETERMINATE, never FAIL. nan > 0.50 silently evaluating to FAIL rejected two live
names on 2026-07-29 (calibration item D1, 20 recorded instances). An absent field is not a rejection.
The memo scores every Criteria and blocks on none of them. The BINDING/MEASURED labels describe the long-only absolute-return strategy that consumes this analysis — not the analysis itself.
| Criteria | Type | Result | Evidence |
|---|---|---|---|
| Quality | BINDING | PASS | COMPOUNDER. FY2025 operating margin 45.6%, gross margin 68.8%, margin +1.0pp YoY. Accruals −0.055 (clean — CFO exceeds NI by $34bn), gross profitability 0.313. Piotroski 6/9, failing only on ΔROA, Δgross margin and Δasset turnover — all three the same fact: capex on the balance sheet before revenue on the P&L. No deterioration mechanism anywhere in the data. |
| Valuation | BINDING | PASS | Implied path requires 5.0% revenue CAGR against 12.4% demonstrated → +7.5pp margin, at a GROWTH_MATCHED 25.1x EV/EBIT exit (32 peers, 6.7–18.3% growth). Implied expansion of +5.2x / +26.4% from today's 19.9x. Achievable at any exit multiple above ~17.5x, including today's with no re-rating (+2.5pp). Working, sensitivity and two corrections to the scan record: Valuation Analysis §0. |
| Liquidity | BINDING | PASS | Equity: the most liquid stock listed; negligible short interest, no borrow constraint. Options chain pulled, not assumed (Alpaca, 18-Sep-2026 expiry, strikes within ±12% of spot): 38 strikes carrying open interest, median 2,905 contracts, maximum 19,813, 179,274 in total (OI as of 2026-07-27); median quoted spread 3.1% of mid; median quoted size 121 bid / 107 ask. A defined-risk structure is fillable at institutional size. Contrast HCA, where maximum open interest across an entire chain was 18 contracts. |
| Momentum | MEASURED | Scored — bottom quintile | 12-1 momentum −28.1%, 12.2nd cross-sectional percentile of the 129-name scan (quintile 1). 6-1 momentum −23.3% (15.1st pct). RSI-14 56.6. 72.5% of the 52-week high; below the 200-day. This governs when to enter, never whether to own. It does not veto the name, and nothing in this document treats it as doing so. |
| Catalyst | MEASURED | Scored | FQ4 FY2026 earnings, 29 July 2026, after the close — FY2027 capex guidance and the FQ4 Azure print against a 39–40% cc guide. FY2026 10-K, expected ~30 July 2026 — would disclose any shortening of the six-year server depreciable life. Time works for a long, so a dated event is not required to own a compounder. |
| Downside | MEASURED | Scored | Permanent-loss case: $252 (−35.9% from $393.44). Cause named: a four-year effective server life plus FY2027 capex above $190bn, forcing a de-rating to 16x on EPS ~14% lower. This is a de-rating, not an impairment — ~$157bn of commercial RPO converts within twelve months regardless of sentiment, which truncates the left tail. No going-concern case: net cash +$46.8bn, CFO exceeds net income by $34bn. Volatility (27.6% annualised, scan vol_252d_pct) is not the risk being measured. |
| Consensus | MEASURED | Scored | House FY2026E revenue $329,632m vs Street $329,600m (+0.0%); FY2026E EPS $16.77 vs $16.77; FY2027E EPS $18.32 vs $19.80 (−7.5%, the 11th percentile of a $17.89–$21.74 range). Street target $557.25, 56 analysts. No variant is required and none is claimed — a variant versus consensus is no longer an admission test. |
| Peer Spread | MEASURED | INDETERMINATE | The §2 comp set is the AI-capex cohort re-rating together; §2 states plainly that MSFT at 23.2x against a 23.0x peer median is not a stock-specific signal. No same-end-market peer's own multiple history and percentile were assembled, so this is INDETERMINATE — not FAIL. |
| Short Mechanism | MEASURED | FAIL (i.e. no short mechanism) | Requires decelerating growth and exhausted margin runway. Growth is not decelerating — corrected TTM revenue is +17.9% YoY against a 12.4% three-year CAGR — and the margin expanded 1.0pp. Clean accruals and 0.313 gross profitability contradict a deterioration mechanism outright. Scored on every name; acted on by nothing on this fork. |
| Sub-sector | MEASURED | Scored | Large-cap software / hyperscale cloud. AI-capex payer, not receiver — §0.1 of this document computes a mean one-year correlation of +0.08 to the six-name AI-infrastructure watchlist and a negative six-month correlation, so this is a genuine diversifier against that cluster rather than an addition to it. |
| Was | Now | Why |
|---|---|---|
| Gate 1 (Causal mechanism): FAIL — "undifferentiated and universally held for a long" | Quality Criteria: PASS | Quality asks is this a business worth owning, not is my reason for owning it proprietary. A mechanism being widely understood is not a defect in the business. The contrarian requirement left the framework with Path B. |
| Gate 2 (Variant vs consensus): FAIL on both branches | dissolved | Absorbed into the Valuation Criteria. The Consensus Criteria still records house-versus-Street; it blocks nothing, and a quota gap leaves it blank rather than failing it. |
| Gate 4 (Expected return): FAIL — net E[R] −3.35%, i.e. −8.05% vs a 4.7% cash hurdle | Valuation Criteria: PASS, margin +7.5pp | E[R]-versus-cash-hurdle is retired. The test is now what today's price requires versus what the business has demonstrated. Cash competition moved to the strategy layer as slot competition. |
| Gate 6 (Momentum): FAIL for a long — "precisely the falling-knife profile the gate exists to stop" | Momentum Criteria: MEASURED, bottom quintile, blocks nothing | Momentum is entry timing, not selection. criteria.md names it the change most likely to be silently reversed under pressure. It is not reversed here. |
| Gate 5: PASS equity / FAIL options on 86.5% front-week implied vol | Liquidity Criteria: PASS, chain actually pulled | An implied-vol level is a pricing observation, not a liquidity one. Liquidity asks whether a position can be filled and exited; 179,274 contracts of September open interest says it can. Whether front-week premium is expensive remains a valid execution point (§5) — it is simply not this Criteria. |
| Scenario probability sensitivity (30/50/20, 25/50/25, 20/55/25) | Sensitivity over the exit multiple | The range was being run on the parameter that could not change the answer. |
This memo does not output "Long", "Short", "Watchlist" or "Avoid". The prior version of this section
issued INVESTMENT DECISION: WATCHLIST (bias: long-if-converted). That line has been removed. The
evidence it rested on is retained above; the conclusion is not the memo's to draw, because whether an
analysis justifies a position depends on the book that would hold it — its existing exposures, its slot
competition and its risk budget.
MSFT — Microsoft Corporation framework: Criteria + two-horizon valuation (2026-07-29)
Spot $393.44 (2026-07-28) Archetype: COMPOUNDER
BINDING Quality ................ PASS
Valuation .............. PASS required 5.0% vs demonstrated 12.4% -> margin +7.5pp
exit 25.1x EV/EBIT, GROWTH_MATCHED (n=32, growth 6.7-18.3%)
implied compression: +5.2x / +26.4% EXPANSION from today's 19.9x
sign flips at ~17.5x exit; PASSES at today's multiple unchanged (+2.5pp)
Liquidity .............. PASS Sep-2026 chain: 38 strikes with OI, median 2,905, total 179,274
median quoted spread 3.1% of mid, size 121 bid / 107 ask
MEASURED Momentum ............... bottom quintile (12-1 -28.1%, 12.2nd pctile, RSI-14 56.6) - TIMING ONLY
Catalyst ............... FQ4 FY2026 earnings 29-Jul-2026; FY2026 10-K ~30-Jul-2026
Downside ............... $252 (-35.9%) - 4-year server life + FY2027 capex >$190bn -> 16x on -14% EPS
de-rating not impairment; no going-concern case; +$46.8bn net cash
Consensus .............. house FY2027E EPS $18.32 vs Street $19.80 (11th pctile, inside range)
Peer Spread ............ INDETERMINATE - no same-end-market peer multiple history assembled
Short Mechanism ........ FAIL (no short mechanism: revenue +17.9% YoY, margin expanding)
Sub-sector ............. LC software / hyperscale cloud; AI-capex PAYER (mean 1y corr +0.08 to the
AI-supplier cluster, negative over 6 months)
12-MONTH TARGET $710 (+80.5%) own six-year median 13.97x EV/Sales on NTM revenue $375.2bn
floor $463 (+17.6%) at today's 9.06x, no re-rating
MSFT trades at the 3rd PERCENTILE of its own six-year EV/Sales range
Street $557.25 (56 analysts, +41.6%) implies 10.93x - inside the band.
The Street and this analysis differ on multiple reversion, not on revenue.
CAVEAT: full reversion to a six-year median inside 12 months is the UPPER END of
what that history supports, and is labelled as such rather than as a central case.
INVALIDATION $252 (Downside Criteria realised)
CORRECTIONS scan TTM revenue $311,898m -> $318,273m (+2.0%): the scan's "TTM" skips Q4 entirely.
scan valuation FAIL (-11.8pp) -> PASS (+7.5pp): the scan's solve embedded a 20.0%
terminal margin against Microsoft's actual 45.6%.
DISCLOSED GAPS NTM revenue is corrected-TTM YoY held flat, NOT a consensus estimate (Alpha Vantage
quota exhausted). Peer Spread INDETERMINATE.
For the long-if-converted bias: 1. 29-Jul-2026: FY2027 capex guided above $190bn → the payback arithmetic in Task 1 §4.4 breaks. 2. 29-Jul-2026: FQ4 Azure constant-currency growth prints below 35% against a 39–40% guide. 3. 29-Jul-2026: FY2027 Microsoft Cloud gross margin guided below 62% (FQ4 guide is ~64%). 4. Any quarter: commercial RPO ex-OpenAI growing below 20% y/y (it was +26% in FQ3-26). This is the cleanest single read on whether demand is broad or concentrated. 5. Any quarter: the disclosed 12-month RPO conversion percentage falling below 25% (10-Q R70). 6. FY2026 10-K (~30-Jul-2026): any shortening of the disclosed server/network useful life from 6 years. 7. Any quarter: PP&E sitting unpaid in accounts payable rising above ~$30bn (it was $22.6bn at Mar-2026, from $6.9bn a year earlier) — reported FCF would be increasingly overstated. 8. Q-M7, unresolved: any disclosure that quantifies Teams' position. Its 87% collapse in management attention is the one signal in this memo I could not explain.
Conditions that would materially change this analysis (not upgrade triggers — no verdict exists to upgrade): - Price route: a close at or below $310.00, at which the base case delivers +24.1%. - Variant route (price-independent): ALL THREE of — (a) Microsoft discloses a commercial Copilot seat count and ARPU for the first time (withheld for eleven quarters; sell-side previews name it as one of three things wanted on 29-Jul); (b) commercial RPO ex-OpenAI accelerates above 30% y/y for two consecutive quarters; (c) a weekly close back above the 200-day moving average (~$434) with a higher-high sequence, fixing Gate 6. These are falsifiable predictions, kept because they are checkable. They are no longer framed as conversion conditions, because there is no position verdict to convert.
| Vehicle | Assessment |
|---|---|
| Outright equity (recommended on conversion) | Perfect liquidity, no financing cost, no time decay, and no exposure to the volatility distortion. For a multi-quarter thesis whose resolution is a sequence of earnings prints, this is the correct instrument. |
| Long call options (REJECTED) | 31-Jul ATM IV 86.5% vs 33.3% three-month realised. Naked long premium requires an explicit house view that the expected move exceeds the implied move; no such view exists. |
| Defined-risk call spread (REJECTED for now) | A Jan-2027 $400/$460 call spread would cost roughly $12.4 net (buy $400 at ~$37.70 mid, sell $460 at ~$25.30 mid — interpolated from the Jan-27 chain) for a $60 maximum payoff. But at 36.6% IV across the whole curve there is no meaningful skew to harvest, and buying a spread still expresses a directional view that failed Gate 2. Structure rejected because the thesis failed, not because the structure is wrong. |
| Cash-secured put (REJECTED — and this is the trap worth naming) | Selling a Sep-2026 $350 put at $7.03 bid (IV 39.3%, delta −0.207) would give an effective basis of $342.97. It is tempting because it looks like "getting paid to wait for the entry." It is not: selling a put IS long exposure, taken on before the conversion trigger fires. Documented here so the temptation is named and refused, exactly as it was on ISRG. |
No catalyst-dated tactical options recommendation is made. Task 6 identifies a hard catalyst two days away, and the reference file says to produce a specific contract when a dated catalyst exists. It also says the expected move must exceed the implied move. At 86.5% implied against 33.3% realised it does not, and issuing a contract recommendation into that would be exactly the "buying overpriced pre-catalyst options" failure the skill's own edge hypothesis says this system exists to prevent. Declining to recommend a contract is the output.
| Question | Answer |
|---|---|
| What is the market wrong about? | Nothing I can demonstrate. The market is applying ~20x forward earnings to a business with rising depreciation. That is a defensible view, and so is the Street's 28x. I cannot adjudicate. |
| What evidence supports a differentiated view? | None that is differentiated. Every piece of evidence assembled — RPO, duration, conversion, OpenAI concentration, capacity, depreciation — is disclosed by management on the record. |
| Why would the disagreement resolve now? | It would not. There is no disagreement between the house and consensus to resolve. |
| What prevents growing into the valuation? | Nothing obvious. That is precisely why a short fails. |
| What would invalidate the thesis? | The eight dated triggers in §4. |
| What is the adverse scenario? | For a long: a 4-year effective server life plus FY2027 capex above $190bn → $252, −35%. For a short: a clean print re-rating toward the Street's 28x → $548, +41%. |
| Why is taking the position superior to not owning it? | The memo does not answer this — it is a question about a particular book, not about the company. What the memo supplies: the implied path requires 5.0% revenue CAGR against 12.4% demonstrated (+7.5pp), and the 12-month target is $710 with a $463 no-re-rating floor. |
The Stage C.6 pre-flight, recorded before any modelling, said: variant unlikely; the honest prior is that Gate 2 will fail; spend the effort on unpublished scoping, the units build and the implied-penetration statement.
It was right. Gate 2 failed on both branches. The effort that produced value was: the 18-quarter
mention-frequency series (which dated the OpenAI commitment from the word RPO alone, and corrected a seeded
prior about power), the R-file pass (which found $22.6bn of unpaid capex and overturned four assumed
disclosure gaps), the correlation computation (which overturned the assumption that hyperscalers correlate with
the AI-supplier complex), and the units-based implied-penetration statement. The effort that produced nothing
was the search for a variant — and fifteen minutes of honest pre-flight predicted that correctly.
The pre-flight was right that no variant existed, and wrong about what follows from that. Under the
current framework the absence of a variant is not a finding against the name at all — no variant versus
consensus is required, Path B is dissolved, and the Valuation Criteria now PASSES on the same evidence base
that produced a Gate 4 FAIL. The label the old framework produced was a run of consecutive Watchlists; the
diagnosis in CALIBRATION_WATCH.md was that the sourcing might be wrong rather than the gates. On this name
the gates were wrong — specifically, a hardcoded 20% terminal margin against a 45.6% actual, and a range run
over scenario probabilities rather than over the exit multiple. That correction is the substantive output of
this update.