Microsoft Corporation
MSFT 391.85 (1.14%) 4.45
2.91(T)
Information Technology
Software
My Holdings:
Shares:
Cost basis:
Microsoft Corporation (MSFT) price target and intrinsic value estimate
MSFT's fair price estimate is $496.7
This valuation is based on a fair P/E of 30.8 and EPS estimates of $16.15
The median analyst price target for MSFT is $480.0.
Analyst price targets range from $415.0 to $650.0
Is MSFT overvalued or undervalued?
MSFT is currently trading at $391.85
MSFT is undervalued by 27% using the pevaluation method.
MSFT is undervalued by 22% compared to median analyst price targets.
Access thousands of companies and create your own custom market model. Create FREE account!Valuation
Overview
Market data
Market cap:$2.91(T)
Enterprise value:$2.94(T)
Total Equity:$302.69(B)
Shares outstanding:7.43(B)
Div. yield:0.81%
P/S:11.13
P/E:31.40
P/FCF:41.60
P/B:9.63
EPS:$12.5
FCF per share:$9.4
Dividend per share:$3.2
Income (TTM)
Revenue$261.80(B)
Gross profit$181.72(B)
EBITDA$142.04(B)
Net income$92.75(B)
Gross margin69.4%
Net margin35.4%
Balance sheet
Total assets$533.90(B)
Total liabilities$231.20(B)
Cash & Short-term inv.$71.56(B)
Long-term debt$39.72(B)
Debt issued$1.60(B)
Debt repaid$-31.37(B)
Cash flow (TTM)
FCF$70.03(B)
CapEx$-55.55(B)
Dividends paid$-22.89(B)
Stock issued$2.02(B)
Stock repurchased$-17.52(B)
Stock-based comp.$11.32(B)
Per Share Data
Growth Estimates
Revenue
CAGR: 12.8%FY+1$276.74(B)
FY+2(+13.6%)$314.27(B)
FY+3(+14.9%)$361.07(B)
FY+4(+12.3%)$405.55(B)
FY+5(+10.5%)$448.29(B)
Net Income
CAGR: 14.8%FY+1$98.44(B)
FY+2(+13.4%)$111.62(B)
FY+3(+16.7%)$130.29(B)
FY+4(+14.1%)$148.67(B)
FY+5(+15.0%)$171.03(B)
EPS
CAGR: 15.1%FY+1$13.16
FY+2(+13.8%)$14.97
FY+3(+17.2%)$17.55
FY+4(+13.4%)$19.91
FY+5(+15.9%)$23.07
FCF per share
CAGR: 15.8%FY+1$17.52
FY+2(+32.8%)$23.26
FY+3(+62.9%)$37.90
FY+4(-28.3%)$27.18
Similar Companies
Historical Financials
Showing limited histrical data. Access 10+ years of financials now! Upgrade
Income
| FY2005 | FY2006 | FY2007 | FY2008 | FY2009 | FY2010 | FY2011 | FY2012 | FY2013 | FY2014 | FY2015 | FY2016 | FY2017 | FY2018 | FY2019 | FY2020 | FY2021 | FY2022 | FY2023 | FY2024 | TTM | 5Y avg | 5Y CAGR | |
| Revenue | 143.01(B) | 168.09(B) | 198.27(B) | 211.91(B) | 245.12(B) | 261.80(B) | 193.28(B) | 14% | |||||||||||||||
| COGS | 46.08(B) | 52.23(B) | 62.65(B) | 65.86(B) | 74.11(B) | 80.09(B) | 60.19(B) | 13% | |||||||||||||||
| Gross Profit | 96.94(B) | 115.86(B) | 135.62(B) | 146.05(B) | 171.01(B) | 181.72(B) | 133.09(B) | 15% | |||||||||||||||
| Total OpEx. | 43.98(B) | 45.94(B) | 52.24(B) | 57.53(B) | 61.58(B) | 64.00(B) | 52.25(B) | 9% | |||||||||||||||
| Â Â R&D | 19.27(B) | 20.72(B) | 24.51(B) | 27.20(B) | 29.51(B) | 31.17(B) | 24.24(B) | 11% | |||||||||||||||
| Â Â SG&A | 24.71(B) | 25.22(B) | 27.73(B) | 30.33(B) | 32.06(B) | 32.83(B) | 28.01(B) | 7% | |||||||||||||||
| Operating Income | 52.96(B) | 69.92(B) | 83.38(B) | 88.52(B) | 109.43(B) | 117.71(B) | 80.84(B) | 20% | |||||||||||||||
| Interest Expense | -2.59(B) | -2.35(B) | -2.06(B) | -1.97(B) | -2.94(B) | -2.68(B) | -2.38(B) | 3% | |||||||||||||||
| Interest Income | 2.68(B) | 2.13(B) | 2.09(B) | 2.99(B) | 3.16(B) | 2.54(B) | 2.61(B) | 4% | |||||||||||||||
| Pre-tax income | 53.04(B) | 71.10(B) | 83.72(B) | 89.31(B) | 107.79(B) | 113.61(B) | 80.99(B) | 19% | |||||||||||||||
| Income tax | -8.76(B) | -9.83(B) | -10.98(B) | -16.95(B) | -19.65(B) | -20.86(B) | -13.23(B) | 22% | |||||||||||||||
| Net Income | 44.28(B) | 61.27(B) | 72.74(B) | 72.36(B) | 88.14(B) | 92.75(B) | 67.76(B) | 19% |
Cash flow
| FY2005 | FY2006 | FY2007 | FY2008 | FY2009 | FY2010 | FY2011 | FY2012 | FY2013 | FY2014 | FY2015 | FY2016 | FY2017 | FY2018 | FY2019 | FY2020 | FY2021 | FY2022 | FY2023 | FY2024 | TTM | 5Y avg | 5Y CAGR | |
| CFO | 60.67(B) | 76.74(B) | 89.03(B) | 87.58(B) | 118.55(B) | 125.58(B) | 86.52(B) | 18% | |||||||||||||||
| Â Â Net Income | 44.28(B) | 61.27(B) | 72.74(B) | 72.36(B) | 88.14(B) | 92.75(B) | 67.76(B) | 19% | |||||||||||||||
| Â Â D&A | 12.80(B) | 11.69(B) | 14.46(B) | 13.86(B) | 22.29(B) | 26.62(B) | 15.02(B) | 15% | |||||||||||||||
| Â Â Stock-based Comp. | 5.29(B) | 6.12(B) | 7.50(B) | 9.61(B) | 10.73(B) | 11.32(B) | 7.85(B) | 19% | |||||||||||||||
| Â Â FCF | 45.23(B) | 56.12(B) | 65.15(B) | 59.48(B) | 74.07(B) | 70.03(B) | 60.01(B) | 13% | |||||||||||||||
| CFF | -46.03(B) | -48.49(B) | -58.88(B) | -43.94(B) | -37.76(B) | -70.19(B) | -47.02(B) | -5% | |||||||||||||||
| Â Â Stock Issued | 1.34(B) | 1.69(B) | 1.84(B) | 1.87(B) | 2.00(B) | 2.02(B) | 1.75(B) | 10% | |||||||||||||||
| Â Â Stock Repurchased | -22.97(B) | -27.39(B) | -32.70(B) | -22.25(B) | -17.25(B) | -17.52(B) | -24.51(B) | -7% | |||||||||||||||
| Â Â Debt Issued | 0.00 | 0.00 | 0.00 | 0.00 | 29.64(B) | 6.55(B) | 5.93(B) | N/A% | |||||||||||||||
| Â Â Debt Repaid | -5.52(B) | -3.75(B) | -9.02(B) | -2.75(B) | -29.07(B) | -36.32(B) | -10.02(B) | 52% | |||||||||||||||
| Â Â Dividend Paid | -15.14(B) | -16.52(B) | -18.14(B) | -19.80(B) | -21.77(B) | -22.89(B) | -18.27(B) | 10% | |||||||||||||||
| CFI | -12.22(B) | -27.58(B) | -30.31(B) | -22.68(B) | -96.97(B) | -54.86(B) | -37.95(B) | 68% | |||||||||||||||
| Â Â Acquisitions | -2.52(B) | -8.91(B) | -22.04(B) | -1.67(B) | -69.13(B) | -6.17(B) | -20.85(B) | 129% | |||||||||||||||
| Â Â Divestitures | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | N/A% | |||||||||||||||
| Â Â Capital Expenditures | -15.44(B) | -20.62(B) | -23.89(B) | -28.11(B) | -44.48(B) | -55.55(B) | -26.51(B) | 30% |
Balance sheet
| FY2005 | FY2006 | FY2007 | FY2008 | FY2009 | FY2010 | FY2011 | FY2012 | FY2013 | FY2014 | FY2015 | FY2016 | FY2017 | FY2018 | FY2019 | FY2020 | FY2021 | FY2022 | FY2023 | FY2024 | TTM | 5Y avg | 5Y CAGR | |
| Total Assets | 301.31(B) | 333.78(B) | 364.84(B) | 411.98(B) | 512.16(B) | 533.90(B) | 384.81(B) | 14% | |||||||||||||||
| Â Â Current assets | 181.91(B) | 184.41(B) | 169.68(B) | 184.26(B) | 159.73(B) | 147.08(B) | 176.00(B) | -3% | |||||||||||||||
| Â Â Â Â Cash and Equivalents | 13.58(B) | 14.22(B) | 13.93(B) | 34.70(B) | 18.32(B) | 17.48(B) | 18.95(B) | 8% | |||||||||||||||
| Â Â Â Â Short-term investments | 122.92(B) | 116.03(B) | 90.82(B) | 76.55(B) | 57.22(B) | 54.07(B) | 92.71(B) | -17% | |||||||||||||||
| Â Â Â Â Inventories | 1.90(B) | 2.64(B) | 3.74(B) | 2.50(B) | 1.25(B) | 909.00(M) | 2.40(B) | -10% | |||||||||||||||
| Â Â Â Â Receivables | 32.01(B) | 38.04(B) | 44.26(B) | 48.69(B) | 56.92(B) | 48.19(B) | 43.99(B) | 15% | |||||||||||||||
| Â Â Non-current assets | 119.40(B) | 149.37(B) | 195.16(B) | 227.72(B) | 352.43(B) | 386.82(B) | 208.81(B) | 31% | |||||||||||||||
| Â Â Â Â Net PP&E | 52.90(B) | 70.80(B) | 87.55(B) | 109.99(B) | 154.55(B) | 189.72(B) | 95.16(B) | 31% | |||||||||||||||
| Â Â Â Â Goodwill | 43.35(B) | 49.71(B) | 67.52(B) | 67.89(B) | 119.22(B) | 119.19(B) | 69.54(B) | 29% | |||||||||||||||
| Total Liabilities | 183.01(B) | 191.79(B) | 198.30(B) | 205.75(B) | 243.69(B) | 231.20(B) | 204.51(B) | 7% | |||||||||||||||
| Â Â Current liabilities | 72.31(B) | 88.66(B) | 95.08(B) | 104.15(B) | 125.29(B) | 108.88(B) | 97.10(B) | 15% | |||||||||||||||
| Â Â Â Â Accounts payable | 12.53(B) | 15.16(B) | 19.00(B) | 18.09(B) | 22.00(B) | 22.61(B) | 17.36(B) | 15% | |||||||||||||||
| Â Â Non-current liabilities | 110.70(B) | 103.13(B) | 103.22(B) | 101.60(B) | 118.40(B) | 122.32(B) | 107.41(B) | 2% | |||||||||||||||
| Â Â Â Â Long-Term Debt | 59.58(B) | 50.07(B) | 47.03(B) | 41.99(B) | 42.69(B) | 39.72(B) | 48.27(B) | -8% | |||||||||||||||
| Total Equity | 118.30(B) | 141.99(B) | 166.54(B) | 206.22(B) | 268.48(B) | 302.69(B) | 180.31(B) | 23% |
Per share data
EPS (Basic)FCF/ShareDividend/ShareEPS (Diluted)Book value/ShareCash & ST inv./ShareDebt/Share
Ratios
P/EP/SEV/EarningsP/FCFP/BEV/FCFDebt/EquityPayout ratio
Margins
Net Income MarginOperating MarginGross MarginEBITDA MarginFCF Margin
Returns
ROICROAROCEROE
Shares outstanding
Shares (Basic)Shares (Diluted)
Market Cap.
Market Cap.
Calculators
Discounted Cash Flow
| Forecast years | |
| Terminal Growth Rate | |
| Discount Rate |
Free cash flow estimates:
Target price
Discounted Cash Flow (exit mult.)
| Forecast years | |
| Exit FCF Multiple | |
| Discount Rate |
Free cash flow estimates:
Target price
Future P/E valuation
| Projection Years | |
| Base Revenue | |
| Revenue Growth Rate | |
| Final Net Margin | |
| Final P/E Ratio | |
| Discount Rate |
Target price
Dividend discount model
| Annual Dividend | |
| First Stage Length (Years) | |
| First Stage Growth Rate | |
| Final Growth Rate | |
| Discount Rate |
Target price
Graham formula
| Earnings Per Share | |
| Expected Growth Rate | |
| Government Bond Rate |
Target price
Dividend income
| Investment Amount | |
| Dividend Yield |
Required investment
| Dividend Yield | |
| Yearly Payout | |
| Quarterly Payout | |
| Monthly Payout |