CONVEX

Microsoft (MSFT) vs Fed Balance Sheet

Microsoft (MSFT) and the Federal Reserve balance sheet (WALCL, published in the weekly H.4.1 release) trade as the cleanest test of whether enterprise software earnings power can override the policy backdrop. Microsoft closed April 29, 2026 near $424 with the stock down approximately 12 percent year-to-date, its worst quarterly run since 2008.

ByConvex Research Desk·Edited byBen Bleier·

Also known as: Microsoft (MSFT) (STK_MSFT, Microsoft) · Fed Balance Sheet (Fed BS, balance sheet, QE, QT)

Equity Stockdaily
Microsoft (MSFT)
$421.92
7D +3.47%30D -0.21%
Updated
Liquidityweekly
Fed Balance Sheet
$6.73T
7D +0.00%30D +0.31%
Updated

Why This Comparison Matters

Microsoft (MSFT) and the Federal Reserve balance sheet (WALCL, published in the weekly H.4.1 release) trade as the cleanest test of whether enterprise software earnings power can override the policy backdrop. Microsoft closed April 29, 2026 near $424 with the stock down approximately 12 percent year-to-date, its worst quarterly run since 2008. WALCL stood at $6.70 trillion on April 23, 2026, flat since the December 2025 QT halt. The April 29 fiscal Q3 print delivered EPS of $4.27 against consensus $4.06 and Azure growth of 40 percent, but the $190 billion capex guide for FY2026 was 23 percent above consensus and pulled the stock down 3.9 percent post-print. The pair captures the moment when capex commitments rather than balance-sheet liquidity dominate the discount-rate equation.

What MSFT and WALCL actually measure

Microsoft is the second-largest S&P 500 constituent by market cap and the broadest single-name proxy for enterprise software, cloud infrastructure, and AI distribution through the OpenAI partnership and Copilot product line. WALCL is the headline total-assets number from the Federal Reserve Board H.4.1 statistical release, published every Thursday and tracked on FRED back to December 2002. The two legs are linked through the discount-rate channel that prices long-dated cash flows.

Microsoft's duration is structurally lower than Nvidia's because a meaningful share of revenue comes from already-installed enterprise software seats and recurring Azure consumption rather than from speculative future AI workloads. That is why MSFT held up better than NVDA through the 2022 tightening cycle: MSFT fell roughly 30 percent peak-to-trough versus NVDA's 65 percent. The pair therefore has lower beta to balance-sheet moves, which makes regime breaks in the relationship more informative when they occur.

The April 2026 capex-versus-liquidity inflection

Microsoft's fiscal Q3 print on April 29, 2026 was the cleanest earnings-versus-capex tradeoff of the current cycle. Revenue beat at $82.89 billion against $81.39 billion expected, EPS beat at $4.27 against $4.06 expected, and Azure and other cloud services grew 40 percent against the StreetAccount consensus of 39.3 percent. The market reacted with a 3.9 percent drawdown in the after-hours session because CFO Amy Hood guided FY2026 capex to $190 billion, up 61 percent year-over-year, and flagged a $25 billion incremental impact from higher component prices. Visible Alpha consensus had been $154.6 billion.

WALCL was unchanged through the print at $6.70 trillion. The MSFT-WALCL spread compressed sharply on April 30 not because of any balance-sheet move but because the capex guide raised concerns about return on incremental investment. The 24/7 Wall St April 30 summary documented an explicit Wall Street split on whether Azure's acceleration justifies the spend. The relationship between the two legs is now driven primarily by the capex-to-revenue payback question rather than by liquidity conditions.

The 2022 QT cycle and how MSFT held up

From the FOMC's June 1, 2022 start of balance-sheet runoff through year-end 2022, WALCL fell from $8.97 trillion to $8.58 trillion, a contraction of roughly $390 billion. MSFT fell from $336 in early January 2022 to $213 on November 4, 2022, a drawdown of approximately 37 percent peak-to-trough. The pair traded as a coordinated liquidity-and-rates story, with MSFT's lower duration relative to NVDA producing a smaller absolute decline.

The November 2022 launch of ChatGPT and the January 2023 Microsoft-OpenAI extended partnership announcement reset the MSFT story. The fiscal Q3 print on April 25, 2023 showed Azure growth holding at 27 percent and management framed Copilot and Azure OpenAI Service as durable revenue drivers. MSFT rallied while WALCL kept contracting, and by the time WALCL bottomed near $6.6 trillion in late 2025 MSFT had compounded roughly 80 percent off the October 2022 low. The 2022-2024 episode is the cleanest illustration of MSFT's structurally lower beta to the balance-sheet leg.

Real yields, capex returns, and the new transmission channel

With WALCL flat and the QT regime ended, the dominant transmission channel from macro policy to MSFT now runs through real yields and through the capex-return question. The 10-year TIPS yield held near 2.0 percent through April 2026, well above the 0 to 1 percent band that prevailed during the 2020-2021 mega-cap rerate. At 2 percent real yields, the present value of MSFT's modeled cash flows beyond year five is roughly 25 to 35 percent lower than at 1 percent real yields, depending on growth assumptions.

The capex-return question is now the second discount-rate input. MSFT's $190 billion FY2026 capex guide, against current Azure run-rate revenue of roughly $90 billion and gross margin in the mid-60s, implies a payback period of 3 to 5 years if AI workloads scale as guided. Wall Street's split reflects disagreement on whether AI inference revenue ramps fast enough to vindicate the spend before depreciation expense compresses operating margins. MSFT has fallen 12 percent year-to-date 2026 specifically because the second variable, not WALCL, has dominated the price action.

What the pair tells you to do in April 2026

The actionable read in the current configuration is that WALCL is essentially a constant in the near-term decomposition of the MSFT story. The pair has lost most of its information content as a liquidity gauge for MSFT specifically, because the capex-and-returns line and the real-yield path are doing all the work. The two specific triggers worth watching are FOMC guidance on any return to outright balance-sheet expansion, which would broadcast through the H.4.1 weekly print and would re-establish the liquidity-equals-multiple expansion regime, and Azure margin trajectory through fiscal Q4 2026 (calendar Q2 2026, reported late July).

MSFT's 12 percent year-to-date decline already reflects significant capex skepticism, and the post-Q3-print 3.9 percent drawdown on April 30 reflects the marginal investor's vote against the $190 billion guide. A capex moderation or an Azure margin reacceleration would lift MSFT without any balance-sheet move; persistent capex inflation against flat margin would compress MSFT regardless of WALCL. Either outcome is the relevant signal in the current regime, not the H.4.1.

How CNLI sharpens the pair signal

The Convex Net Liquidity Impulse decomposes WALCL into outright Fed assets, the Treasury General Account, and reverse repo balances. For Microsoft specifically, the CNLI improvement over headline WALCL is smaller than for higher-beta names like Nvidia because MSFT's lower duration makes it less sensitive to high-frequency liquidity oscillations. The relevant CNLI input for MSFT is the trend-quarter signal rather than the weekly tick.

The quarterly CNLI through Q1 2026 shows liquidity broadly flat: TGA running near $700 billion against the recent average, RRP near $150 billion, and outright Fed assets stable at $6.70 trillion. That means the macro context is neutral, the AI-capex line is providing the dominant signal, and reading the pair alongside CNLI confirms what the headline WALCL number already shows: the central bank is not the marginal driver of MSFT in April 2026, and watching capex calls and Azure margins is the higher-information workflow.

Conditional Forward Response (Tail Events)

How Fed Balance Sheet has historically behaved in the 5 sessions following a top-decile or bottom-decile daily move in Microsoft (MSFT). Computed from 257 aligned daily observations ending .

Up-shock
Microsoft (MSFT) top-decile up-day (mean trigger +5.41%)
Mean 5D forward
-0.55%
Median 5D
-0.71%
Edge vs baseline
-0.21 pp
Hit rate (positive)
25%

Following these triggers, Fed Balance Sheet falls 0.55% on average over the next 5 sessions, versus an unconditional baseline of -0.34%. 24 qualifying events; Fed Balance Sheet closed positive in 25% of them.

n = 24 trigger events
Down-shock
Microsoft (MSFT) bottom-decile down-day (mean trigger -6.06%)
Mean 5D forward
-0.16%
Median 5D
-0.51%
Edge vs baseline
+0.18 pp
Hit rate (positive)
38%

Following these triggers, Fed Balance Sheet falls 0.16% on average over the next 5 sessions, versus an unconditional baseline of -0.34%. 26 qualifying events; Fed Balance Sheet closed positive in 38% of them.

n = 26 trigger events

Past behavior in the tails is descriptive, not predictive. Mean response is the simple arithmetic mean of compounded 5-day forward returns following each trigger event; baseline is the unconditional mean across the full sample window. Edge measures the gap between the two.

90-Day Statistics

Microsoft (MSFT)
90D High
$432.92
90D Low
$356.77
90D Average
$399.68
90D Change
+6.31%
76 data points
Fed Balance Sheet
90D High
$6.73T
90D Low
$6.61T
90D Average
$6.67T
90D Change
+1.74%
13 data points

Explore Each Metric

Related Scenarios & Forecasts

ShareXRedditLinkedInHN

Get daily macro analysis comparing key metrics delivered to your inbox. Stay ahead of market-moving divergences.

Frequently Asked Questions

Why did MSFT fall after a strong Q3 2026 earnings beat?+

Microsoft's April 29, 2026 fiscal Q3 print beat on revenue ($82.89 billion versus $81.39 billion expected), EPS ($4.27 versus $4.06), and Azure growth (40 percent versus 39.3 percent expected), but the FY2026 capex guide of $190 billion came in 23 percent above the Visible Alpha consensus of $154.6 billion. CFO Amy Hood flagged $25 billion of higher component prices in the guide. Wall Street has split on whether the Azure acceleration justifies the spend, and the stock fell 3.9 percent in the after-hours session and on April 30 trading. The 12 percent year-to-date decline in MSFT through April 2026 is largely about capex returns, not earnings power.

How does WALCL affect Microsoft's valuation?+

WALCL affects MSFT through the discount-rate channel: balance-sheet expansion historically suppresses real yields and supports long-duration cash-flow valuations, while contraction has the opposite effect. MSFT's beta to WALCL changes is lower than Nvidia's because MSFT's earnings are anchored by recurring enterprise software and Azure consumption rather than by speculative future cash flows. Through the 2022 QT cycle, MSFT fell about 37 percent peak-to-trough versus NVDA's 65 percent. Through the 2023-2024 contraction, MSFT rerated higher despite shrinking WALCL, driven by Copilot and Azure OpenAI Service revenue.

What does the Microsoft fiscal Q3 print mean for AI capex broadly?+

Microsoft's $190 billion FY2026 capex guide signals that hyperscaler AI capex remains in acceleration mode rather than plateau mode. The guide implies roughly $35 billion of incremental spend versus consensus, most of which routes to Nvidia GPUs, AMD MI accelerators, custom silicon (Maia, Cobalt), and the broader AI infrastructure supply chain. The FY2026 guide is the highest single-vendor capex disclosure in the cycle and validates Goldman Sachs' and JP Morgan's higher-end AI capex estimates rather than the cautious end of the range.

Has the QT halt changed the MSFT-WALCL relationship?+

Yes, materially. With WALCL flat at $6.70 trillion since December 2025, the balance-sheet leg has effectively become a constant in the MSFT decomposition. The dominant transmission channel from macro policy to MSFT now runs through the 10-year TIPS yield (held near 2.0 percent in April 2026) and through the capex-to-revenue payback question rather than through balance-sheet expansion or contraction. The pair's information content has compressed, and reading capex calls is currently a higher-information workflow than reading the H.4.1.

How does Microsoft's duration compare with Nvidia's?+

Microsoft has structurally lower duration than Nvidia because a meaningful portion of MSFT revenue comes from already-installed enterprise software seats (Office 365, Windows Server, Dynamics) and recurring Azure consumption, while a larger share of Nvidia's modeled value sits in future AI workload revenue 5 to 15 years out. Sell-side DCF templates from Morgan Stanley and JP Morgan typically place 50 to 60 percent of MSFT equity value in cash flows beyond year five, versus 70 to 85 percent for NVDA. The duration gap is why MSFT's drawdowns through tightening cycles have historically been roughly half NVDA's.

What should I watch alongside the MSFT-WALCL spread?+

Three high-information inputs sit alongside the spread. First, the Microsoft fiscal-quarter capex guide (next print late July 2026 for fiscal Q4) directly drives the capex-return discussion. Second, the 10-year TIPS yield, available daily on FRED as DFII10, captures the real-yield discount-rate channel. Third, the Azure operating margin trajectory, disclosed in MSFT segment data, captures whether the AI capex is translating into compounding profitability or into depreciation drag. The combination is more informative than tracking WALCL alone.

Related Comparisons

Explore Across Convex

Data sourced from FRED, CoinGecko, CBOE, and other providers. This page is for informational purposes only and does not constitute financial advice. Past performance does not guarantee future results.