|
|
|
|
|
|
|
|
|
|
|
|
|
|
Intrinsic Valuation of MSFT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
MSFT Free Cash Flow Average and Growth over past
5Y |
|
Key Statistics |
|
|
Year |
|
FCF |
FCF Growth |
|
|
|
|
|
|
|
|
2021 |
|
$56,118,000,000 |
24.06% |
|
EPS (FY) |
8.05 |
|
Market Cap |
1981B |
|
|
2020 |
|
$45,234,000,000 |
18.23% |
|
P/E Ratio |
27.36 |
|
Total Asset |
345B |
|
|
2019 |
|
$38,260,000,000 |
18.63% |
|
Net Income |
61B |
|
Total Debt |
82B |
|
|
2018 |
|
$32,252,000,000 |
2.79% |
|
EBITDA |
96B |
|
Total Liab |
192B |
|
|
2017 |
|
$31,378,000,000 |
25.60% |
|
Opr Margin |
0.4256 |
|
Debt/Equity |
0.48 |
|
|
2016 |
|
$24,982,000,000 |
|
|
PreTax Margin |
0.4291 |
|
BV/Share |
18.88 |
|
|
5Y Average FCF |
|
$40,648,400,000 |
17.86% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Overall Market Assumptions: |
|
|
Assumptions: |
|
|
|
P/E for No-Growth Company: |
7.00 |
|
|
|
Perpetual Growth Rate (g): |
2.50% |
|
|
|
Historical US Bond Yield: |
4.40% |
|
|
|
Discount Rete (WACC): |
9.03% |
|
|
|
Current US Bond Yield: |
1.48% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forcasting Future Free Cash Flow for next 6Y |
|
Modified Benjamin Graham's Intrinsic Value |
|
|
Year |
|
FCF Projection |
|
|
|
|
|
|
|
|
|
2022 |
|
$66,141,301,953 |
|
|
MBG Intrinsic Value |
$169.76 |
|
|
2023 |
|
$77,954,877,651 |
|
|
|
|
|
|
|
|
|
2024 |
|
$91,878,489,994 |
|
|
|
|
|
|
|
|
|
2025 |
|
$108,289,015,105 |
|
|
|
|
|
|
|
|
|
2026 |
|
$127,630,643,399 |
|
|
|
|
|
|
|
|
|
2027 |
|
$150,426,902,660 |
|
|
|
|
|
|
|
|
|
Terminal Value |
|
$2,361,049,231,564 |
|
|
Net Worth/Share |
$20.25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DCF Valuation |
|
DCF Valuation "What If" Scenario Table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enterprise Value |
$1,735,186,155,188 |
|
|
|
Growth Rate |
|
|
(+) Cash & Cash Equivalents |
$130,334,000,000 |
|
|
236.28 |
1.50% |
2.00% |
2.50% |
3.00% |
3.50% |
|
|
(-) Total Debt |
$82,278,000,000 |
|
WACC |
8.93% |
215.3 |
226.9 |
240.3 |
255.9 |
274.5 |
|
|
Equity Value |
$1,783,242,155,188 |
|
8.98% |
213.7 |
225.1 |
238.3 |
253.6 |
271.8 |
|
|
Shares Outstanding |
7547000000 |
|
9.03% |
212.2 |
223.4 |
236.3 |
251.4 |
269.2 |
|
|
|
|
|
9.53% |
197.7 |
207.3 |
218.2 |
230.7 |
245.4 |
|
|
DCF Intrinsic Value |
$236.28 |
|
10.03% |
185.0 |
193.2 |
202.5 |
213.1 |
225.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Swarnadeep
Seth (2022) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|