MAG 7 valuation report

Prices as of April 17, 2026 close Fundamentals from latest 10-Q/10-K filings Generated April 19, 2026
Jump to: MAG 7 overview Microsoft Meta Nvidia Summary thesis

The MAG 7 at a glance

The seven megacap tech companies driving most of the S&P 500's returns — ranked by upside to blended fair value.

Company Ticker Price Blended FV Upside Verdict TTM Revenue Market Cap
MicrosoftMSFT$420.26$554.90+32.0%Undervalued$305.5B$3.14T
Meta PlatformsMETA$678.80$771.63+13.7%Undervalued$201.0B$1.74T
NvidiaNVDA$201.68$221.79+10.0%Fair Value$215.9B$4.93T
AmazonAMZN$249.70$254.68+2.0%Fair Value$716.9B$2.71T
AppleAAPL$270.61$262.81−2.9%Fair Value$435.6B$4.01T
AlphabetGOOGL$336.72$318.18−5.5%Fair Value$402.8B$4.12T
TeslaTSLA$400.62$351.35−12.3%Overvalued$94.8B$1.42T
Upside to blended fair value (%)
Upside: MSFT 32%, META 14%, NVDA 10%, AMZN 2%, AAPL -3%, GOOGL -6%, TSLA -12%.

The three names with meaningful upside — Microsoft, Meta, and Nvidia — are the focus of this report. The other four are fairly priced to modestly overvalued, with Tesla the only outright sell signal (Morningstar cut its fair value from $400 to $300 in January 2026 after Nvidia's autonomous driving entry).

Microsoft · MSFT

Microsoft

Information Technology · Wide moat · Medium uncertainty

Undervalued · +32%
Price (Apr 17)
$420.26
Blended fair value
$554.90
Upside to FV
+32.0%
Market cap
$3.14T

Price vs fair value — last 12 months

The gap widened after MSFT pulled back 22% from its Oct 2025 peak while analyst fair values kept climbing.

Stock price
Morningstar FV ($600)
InsightInvest's DCF IV ($527)
Blended FV ($555)
MSFT price: $395 Apr 2025, peak $540 Oct 2025, current $420 Apr 2026. FVs: InsightInvest $527, Blended $555, Morningstar $600.
DCF assumptions
TTM Revenue$305.5B
TTM FCF$77.4B
FCF margin25.3%
Discount rate (WACC)10.0%
Terminal growth7.0%
Terminal P/FCF35.7x
Diluted shares7.46B
Net cash$31.9B
Fair value triangulation
Bear DCF (25% wt)$505.50
Base DCF (50% wt)$516.01
Bull DCF (25% wt)$526.71
Forward PS model$537.53
InsightInvest's IV avg$526.79
Morningstar FV$600.00
Investing SW FV$537.92
Blended fair value$554.90

Revenue forecast · FY23–FY30 (consensus, $B)

Revenue: FY23 $212B, FY24 $245B, FY25 $282B, TTM $305B, FY26 $328B, FY27 $378B, FY28 $441B, FY29 $516B, FY30 $591B.

Margin of safety buy zones

0% MoS
$554.90
5% MoS
$527.16
10% MoS
$499.41
20% MoS
$443.92
30% MoS
$388.43

Current price of $420.26 sits inside the 20% margin-of-safety zone and approaches the 30% zone at $388.

The hidden asset the market ignores

Microsoft's 27% stake in OpenAI Group PBC was officially disclosed at $135 billion when OpenAI restructured in October 2025 at a $500B valuation. Then in March-April 2026 OpenAI raised $122B at a $852B post-money valuation — which mathematically marks Microsoft's stake at roughly $230B (a 17.6x paper return on $13B invested, $11.6B of which is actually deployed). Microsoft carries this at cost. If OpenAI IPOs in late 2026 or 2027 — which Reuters and CFO Sarah Friar have signaled is plausible — that hidden value would move onto the balance sheet at market. For context: $230B is roughly 7% of Microsoft's current $3.14T market cap, sitting off-book today.

The contract nobody reads

In the October 2025 restructuring, Microsoft gave up its cloud right-of-first-refusal — the bear case headline. What actually happened: OpenAI signed a binding $250B incremental Azure contract, Microsoft's IP rights extended through 2032 (from 2030) and now cover post-AGI models, and Microsoft won the right to pursue AGI independently. Pre-deal, Microsoft needed OpenAI to succeed. Post-deal, Microsoft gets paid whether OpenAI succeeds, stumbles, or gets disrupted — because OpenAI is now a locked-in cash customer, a 27% equity position, and a licensed IP source Microsoft can build on alone.

Meta Platforms

Communication Services · Wide moat · Medium uncertainty

Undervalued · +14%
Price (Apr 17)
$678.80
Blended fair value
$771.63
Upside to FV
+13.7%
Market cap
$1.74T

Price vs fair value — last 12 months

META hit $796 in Sep 2025, then sold off 28% on capex-panic headlines. Fair values held or rose as Advantage+ scaled to $60B run-rate.

Stock price
Morningstar FV ($850)
InsightInvest's DCF IV ($722)
Blended FV ($772)
META price: $480 Apr 2025, peak $796 Sep 2025, current $679 Apr 2026. FVs: InsightInvest $722, Blended $772, Morningstar $850.
DCF assumptions
TTM Revenue$201.0B
TTM FCF$43.6B
FCF margin21.7%
Discount rate (WACC)10.5%
Terminal growth7.0%
Terminal P/FCF30.6x
Diluted shares2.57B
Net cash($2.3B)
Fair value triangulation
Bear DCF (25% wt)$618.83
Base DCF (50% wt)$687.05
Bull DCF (25% wt)$761.26
Forward PS model$755.86
InsightInvest's IV avg$722.20
Morningstar FV$850.00
Investing SW FV$742.68
Blended fair value$771.63

Revenue forecast · FY23–FY30 (consensus, $B)

Revenue: FY23 $135B, FY24 $165B, FY25 $201B, FY26 $249B, FY27 $291B, FY28 $340B, FY29 $380B, FY30 $427B.

Margin of safety buy zones

0% MoS
$771.63
5% MoS
$733.05
10% MoS
$694.47
20% MoS
$617.30
30% MoS
$540.14

At $678.80, META is hovering just above the 10% MoS zone ($694). A dip below $617 hits the 20% zone.

The $80 billion accounting illusion

Reality Labs has lost $83.6 billion cumulatively since 2020, including $19.19B in 2025 alone (Q4 2025: $6.02B loss on just $955M of revenue). The market treats all of Meta as one business and multiples it accordingly. Here's the asymmetry: Meta's 2025 total operating income was $83.3B — meaning the Family of Apps (core advertising business) actually generated roughly $102.5B of operating income standalone before Reality Labs wiped $19B off the top. At the current $1.74T market cap, the core business is trading at approximately 21x its standalone earnings — reasonable for a business growing revenue at 22%. Zuckerberg told analysts 2026 Reality Labs losses will be "similar to 2025 levels" and "likely be the peak" before gradually declining. Every dollar Reality Labs stops bleeding flows straight to consolidated earnings.

The silent business model inside the headset division

Quest VR is a rounding error. Ray-Ban Meta smart glasses — developed with EssilorLuxottica — have sold 2+ million units, tripled YoY, and the $799 Display model sold out store inventory in 48 hours at launch. EssilorLuxottica is expanding capacity to 10M units per year by end of 2026. Meta cut 1,500 Reality Labs staff in January and slashed the VR budget 30% to fund the glasses business. If glasses become the next smartphone-scale platform — Zuckerberg's explicit bet — Meta owns the operating system and the silicon. The bear case assumes Reality Labs is a permanent money pit. The pivot already happened; the market just hasn't noticed the re-allocation inside the line item.

"Mark has actually moved his desk and is seated in the AI lab with Alex Wang and Nat Friedman, and he's coding all day long."
— Dina Powell McCormick, Meta President, Semafor World Economy Summit, April 14, 2026

Zuckerberg physically relocated his desk into Meta's Superintelligence Labs between Alex Wang (Scale AI founder) and Nat Friedman (ex-GitHub CEO), writing and shipping code after a 20-year hiatus. Founders don't go into the trenches unless they believe something in the data the rest of the organization can't see yet. It's a behavioral signal — and those are the ones markets price in last.

Nvidia

Information Technology · Wide moat · High uncertainty

Fair Value · +10%
Price (Apr 17)
$201.68
Blended fair value
$221.79
Upside to FV
+10.0%
Market cap
$4.93T

Price vs fair value — last 12 months

NVDA doubled from April 2025 lows, peaked around $212 in Oct 2025, then cooled to $202 as the market digests the Rubin ramp.

Stock price
Morningstar FV ($240)
InsightInvest's DCF IV ($207)
Blended FV ($222)
NVDA price: $95 Apr 2025, peak $212 Oct 2025, current $202 Apr 2026. FVs: InsightInvest $207, Blended $222, Morningstar $240.
DCF assumptions
TTM Revenue$215.9B
TTM FCF$96.6B
FCF margin44.7%
Discount rate (WACC)10.5%
Terminal growth7.0%
Terminal P/FCF30.6x
Diluted shares24.43B
Net cash$51.5B
Fair value triangulation
Bear DCF (25% wt)$210.96
Base DCF (50% wt)$232.15
Bull DCF (25% wt)$255.08
Forward PS model$182.00
InsightInvest's IV avg$207.29
Morningstar FV$240.00
Investing SW FV$218.09
Blended fair value$221.79

Revenue forecast · FY24–FY30 (consensus, $B)

Revenue: FY24 $61B, FY25 $130B, FY26 $216B, FY27 $367B, FY28 $465B, FY29 $549B, FY30 $602B.

Margin of safety buy zones

0% MoS
$221.79
5% MoS
$210.70
10% MoS
$199.61
20% MoS
$177.43
30% MoS
$155.25

At $201.68, NVDA sits essentially right at the 10% MoS line — already attractive on any further red day. $177 hits a 20% discount.

The 40% the bear case ignores

At GTC 2026, Jensen disclosed that the top 5 hyperscalers represent 60% of Nvidia's revenue — and the remaining 40% spans sovereign clouds, enterprise, industrial, robotics, and edge. The bear case assumes hyperscaler concentration is 80%+ and that their in-house silicon efforts (Trainium, TPU, Maia, MTIA) will eat Nvidia's lunch. The disclosed 40% non-hyperscaler revenue is the fastest-growing segment and is structurally unaddressable by custom silicon: sovereign AI buyers like Saudi Arabia's Level42 ($4.8B) don't design chips, they buy national capacity. Huang also said on Dwarkesh's podcast that even inside the hyperscaler 60%, most of that compute serves external customers — AWS renting to enterprises — not the cloud's internal workloads. Meaning the chunk that's actually at risk of in-house replacement is much smaller than the concentration headline suggests.

The circular financing flywheel — feature, not bug

Nvidia has committed up to $100B to OpenAI, owns roughly 9–13% of CoreWeave after doubling down with another $2B in January 2026 (post-deal stake value ~$4.7B), backstops $6.3B of CoreWeave's excess capacity through 2032, committed $2B to xAI, and invested $2B each into Lumentum, Coherent, and Marvell. Critics call this "circular financing" and draw dot-com parallels. The less obvious read: Nvidia's equity stakes give portfolio companies access to Nvidia's AA- credit rating, letting OpenAI and CoreWeave borrow at 6–9% instead of the 15% they'd pay standalone. Each dollar Nvidia invests in a portfolio company creates multiples of forward chip demand backed by cheaper capital. This is vendor financing at industrial scale — the same playbook GE used to dominate jet engines for 50 years.

The valuation tension worth acknowledging

The forward PS model in the valuation table yields $182 — below the current $202 price. That's the DCF's quiet warning: at $216B TTM revenue, sustaining even 10x price-to-sales requires FY27 to hit $367B (70% growth on a $5T company). Consensus says yes, Morningstar's $240 FVE says yes, but the margin for error narrows with every doubling. The bull case works. The bear case — where Rubin ramp slows or hyperscaler silicon captures even 15% share — is also mathematically intact. This is why the blended FV is only $222 vs. Morningstar's $240: the PS model is dragging the average down, and that tension is honest math, not a bug.

Summary thesis

Three irreplaceable MAG 7 businesses at a discount

These are three practically irreplaceable stocks to be buying on any red days in April. They're part of the MAG 7 — Apple, Microsoft, Alphabet, Amazon, Meta, Nvidia, and Tesla — the seven megacap tech companies driving most of the S&P 500's returns.

Microsoft. Everyone thinks OpenAI is the threat. Truth is, Microsoft owns a piece of OpenAI, hosts them on Azure, and sells Copilot on top. OpenAI wins, loses, or gets disrupted — Microsoft gets paid on all three. It's the only AI trade where you don't have to pick a winner. Fair value $600, trading at $420. 32% off.

Meta. Wall Street is panicking about $135B in AI spending with "no return." Meanwhile Meta just quietly killed the traditional ad agency. Small businesses now type one sentence and AI builds the entire campaign. That's a multi-hundred-billion-dollar industry getting eaten alive — and Zuckerberg is literally back in the lab coding next to his AI team all day. Fair value $850, stock at $679.

Nvidia. The bear case is hyperscalers will cut Nvidia out. They're trying — and still signing bigger orders. Supply commitments jumped from $50B to $95B in ninety days. When your biggest customers actively trying to replace you are doubling orders instead, that tells you everything. Fair value $240, stock at $202.

The market is selling these because it's scared of AI spending. The contrarian read is that the market is reading the wrong chart. Microsoft owns the cloud, Meta owns the attention, Nvidia makes the chips. Any dip is a gift.