Skip to content
value.today

Microsoft Corporation: DCF model

A discounted-cash-flow model filled in from Microsoft Corporation's filings as reported. Change any assumption; the values follow at once.

A tool for your own analysis, not investment advice. It does arithmetic on the figures the company filed and on assumptions you choose; it does not forecast, and the result is only as good as those assumptions. Every formula is on the methodology page.

Weighted 25/50/25USD 312.5641.3% below the price

Market price USD 532.60 on Oct 27, 2026: Closing price the SEC publishes with its fails-to-deliver data (MSFT).

Assumptions: Base case

Change any figure; the values follow at once.

Revenue and margins

USD M

From the filings10-K filed Jul 29, 2026

Revenue growth%%

The years between change on a straight line.

From the filingsThe first year starts at Revenue growth a year from FY2023 to FY2026 (3 years): 16.12% a year; the years after are your assumption.

Operating margin%%

The years between change on a straight line.

From the filingsAverage operating margin, FY2024–FY2026: 45.68%; the years ahead are your assumption.

Tax and reinvestment

%

From the filingsIncome tax over income before tax, FY2024–FY2026

%

Your assumptionNot on file: set equal to capital spending.

%

From the filingsAverage share of revenue, FY2024–FY2026

%

From the filingsAverage operating working capital (current assets less cash and short-term investments, less current liabilities other than debt) as a share of revenue, FY2024–FY2026

Discount rate

How the discount rate is set

Your assumption1.0 to start with

%

Your assumption5% to start with

Cost of equity5.15% + 1 × 5%10.15%
%

From the filingsInterest expense of FY2026 over its average debt

%

From the filingsDebt over debt plus market value on Oct 27, 2026

Discount rate (WACC)99.11% × 10.15% + 0.89% × 5.96% after tax10.11%

After the last year

How the value after the last year is worked out
%

Your assumptionImplies 7.1× the last year's EBITDA.

From value to shares (every case)

Balance sheet of Q1FY2027, Sep 30, 2026 · 10-Q filed Oct 28, 2026

USD M

From the filings

USD M

From the filings

USD M

From the filings

USD M

From the filings

USD M

Your assumption

The three cases

%
%
%

Base case: value per share

Discount rate 10.11%; long-run growth 2.50%. Values as at the end of FY2026.

From the business's value to the value per share
Present value of the 5 projected yearsUSD 660.8 B
Present value after the last year71% of the business's valueUSD 1.61 T
Enterprise value (the whole business)USD 2.27 T
Less debtUSD 35.5 B
Plus cash and short-term investmentsUSD 64.5 B
Equity value (the shareholders')USD 2.3 T
Divided by shares (millions)7,446
Value per shareUSD 308.76

Value per share

USD 308.76

42.0% below the price

Price USD 532.60 on Oct 27, 2026

Base case: year by year

Millions of USD. The FY2026 column is as reported; the years after are projected. Tax, capital spending and working capital are signed as they add to (+) or take from (−) free cash flow.

Projection year by year, in millions of USD
USD millionsFY2026reportedFY2027projectedFY2028projectedFY2029projectedFY2030projectedFY2031projected
Revenue331,839385,331434,346474,783502,843515,414
Growth17.8%16.1%12.7%9.3%5.9%2.5%
Operating income (EBIT)155,237176,019198,409216,881229,699235,441
Operating margin46.8%45.7%45.7%45.7%45.7%45.7%
Tax on operating income−32,616−36,765−40,188−42,563−43,627
Depreciation and amortisation—97,604110,020120,263127,370130,554
Capital spending−115,948−97,604−110,020−120,263−127,370−130,554
Change in working capital7,0086,4215,2973,6761,647
Free cash flow to the firm−3,743150,411168,065181,990190,811193,461
Discount factor0.90820.82480.74900.68020.6178
Present value136,597138,612136,313129,794119,511

Base case: sensitivity

How the value per share moves when one pair of figures changes and the rest stay as they are.

Discount rate and long-run growth

Value per share in USD; your figures in the outlined middle; green at or above the market price, red below it.

Value per share for discount rates (rows) and long-run growth rates (columns)
Discount rate ↓ · Long-run growth →1.5%2.0%2.5%3.0%3.5%
8.11%368391419452492
9.11%319336355378405
10.11%282294309325344
11.11%252262273285299
12.11%228236245254264

Revenue growth and operating margin

Value per share in USD; your figures in the outlined middle; green at or above the market price, red below it.

Value per share for changes to every year's revenue growth (rows) and operating margin (columns)
Growth, every year ↓ · Margin, every year →−4 pt−2 pt±0 pt+2 pt+4 pt
−4 pt237248260271282
−2 pt259271283295308
±0 pt282296309322335
+2 pt308322336350365
+4 pt335350366381396

Where the figures come from

The statements as reported, in millions of USD; hover a figure for its filing.

The fiscal years the model starts from, as reported, in millions of USD
USD millionsFY2026to Jun 30, 2026FY2025to Jun 30, 2025FY2024to Jun 30, 2024FY2023to Jun 30, 2023FY2022to Jun 30, 2022FY2021to Jun 30, 2021
Revenue331,839281,724245,122211,915198,270168,088
Growth17.8%14.9%15.7%6.9%18.0%—
Operating income155,237128,528109,43388,52383,38369,916
Operating margin46.8%45.6%44.6%41.8%42.1%41.6%
Effective tax rate19.4%17.6%18.2%19.0%13.1%13.8%
D&A, % of revenue——————
Capital spending, % of revenue34.9%22.9%18.1%13.3%12.0%12.3%
Working capital, % of revenue-8.7%-14.8%-15.8%-12.2%-13.8%-15.8%
Free cash flow to the firm−3,74344,12557,94442,11749,456—
Filing10-K10-K10-K10-K10-K10-K
  • From the filings: revenue, margins, tax rate, depreciation, capital spending and working capital (fiscal years above), debt, cash, leases and minority interests (balance sheet of Q1FY2027), and the share count (Q1FY2027).
  • Market data: US Treasury daily par yield curve, 10-year (Nov 13, 2026); Market price USD 532.60 on Oct 27, 2026: Closing price the SEC publishes with its fails-to-deliver data (MSFT).
  • Your assumptions: the growth path and margins ahead, beta, the equity risk premium, long-run growth or the exit multiple, and the weights of the cases. How each figure is worked out: methodology.