Microsoft Corporation Website

Microsoft Corporation

NasdaqGS-MSFT

Revenue

198,270.0211,915.0245,122.0278,758.7319,014.6367,374.1367,374.1367,374.1

Revenue % Chg.

18.0%6.9%15.7%

EBIT

83,383.088,675.0109,433.0123,325.0141,134.3163,479.4163,479.4163,479.4

EBIT Margin

42.1%41.8%44.6%

Tax Rate

13.1%19.0%18.2%

NOPAT

72,448.771,845.789,481.9100,046.1114,454.7132,404.7132,404.7132,404.7

NOPAT Margin

36.5%33.9%36.5%35.9%35.9%36.0%36.0%36.0%

D&A

14,600.013,500.020,000.027,792.233,607.243,092.043,092.043,092.0

D&A / Revenue

7.4%6.4%8.2%

Capex

-23,886.0-28,107.0-44,477.0-60,269.1-67,010.2-68,838.9-68,838.9-68,838.9

Capex / Revenue

-12.0%-13.3%-18.1%

Chg. NWC

446.0-2,388.01,824.0-146.6-167.8-193.2-193.2-193.2

Chg. NWC / Revenue

0.2%-1.1%0.7%

Unlevered FCF (UFCF)

63,608.754,850.766,828.967,422.680,883.9106,464.6106,464.6106,464.6

UFCF % Chg.

28.3%-13.8%21.8%0.9%20.0%31.6%——

PV of UFCF

———62,074.068,560.083,084.176,493.170,424.9

Sum of PV of UFCF

———62,074.0130,634.0213,718.1290,211.2360,636.1
Cost of Debt
Tax Rate
After Tax Cost of Debt2.8%
Risk Free Rate
Market Risk Premium
Beta0.9
Cost of Equity8.8%
Total Debt97,852.0
Market Cap3,106,218.8
Total Capital3,204,070.8
Debt Weighting3.1%
Equity Weighting96.9%
WACC8.6%
Exit Multiple EV/FCF
Terminal Value3,124,627.8
PV of Terminal Value1,902,934.7
Cumulative PV of UFCF360,636.1
Net Debt18,409.0
Equity Value2,245,161.8
Shares Outstanding7,434.9
Implied Share Price302.0
Current Share Price417.8
Implied Upside / (Downside)-27.7%