|
|
|
|
|
|
|
|
|
|
|
|
|
|
Intrinsic Valuation of FB |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
FB Free Cash Flow Average and Growth over past
5Y |
|
Key Statistics |
|
|
Year |
|
FCF |
FCF Growth |
|
|
|
|
|
|
|
|
2021 |
|
$39,116,000,000 |
65.52% |
|
EPS (FY) |
13.77 |
|
Market Cap |
496B |
|
|
2020 |
|
$23,632,000,000 |
11.41% |
|
P/E Ratio |
13.84 |
|
Total Asset |
164B |
|
|
2019 |
|
$21,212,000,000 |
38.11% |
|
Net Income |
39B |
|
Total Debt |
14B |
|
|
2018 |
|
$15,359,000,000 |
-12.15% |
|
EBITDA |
52B |
|
Total Liab |
41B |
|
|
2017 |
|
$17,483,000,000 |
50.49% |
|
Opr Margin |
0.3668 |
|
Debt/Equity |
0.12 |
|
|
2016 |
|
$11,617,000,000 |
|
|
PreTax Margin |
0.3734 |
|
BV/Share |
45.56 |
|
|
5Y Average FCF |
|
$23,360,400,000 |
30.68% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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.13% |
|
|
|
Current US Bond Yield: |
1.48% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forcasting Future Free Cash Flow for next 6Y |
|
Modified Benjamin Graham's Intrinsic Value |
|
|
Year |
|
FCF Projection |
|
|
|
|
|
|
|
|
|
2022 |
|
$51,115,531,843 |
|
|
MBG Intrinsic Value |
$290.32 |
|
|
2023 |
|
$66,796,134,462 |
|
|
|
|
|
|
|
|
|
2024 |
|
$87,287,042,082 |
|
|
|
|
|
|
|
|
|
2025 |
|
$114,063,901,704 |
|
|
|
|
|
|
|
|
|
2026 |
|
$149,055,041,408 |
|
|
|
|
|
|
|
|
|
2027 |
|
$194,780,338,365 |
|
|
|
|
|
|
|
|
|
Terminal Value |
|
$3,010,414,591,996 |
|
|
Net Worth/Share |
$43.73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DCF Valuation |
|
DCF Valuation "What If" Scenario
Table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enterprise Value |
$2,094,998,715,805 |
|
|
|
Growth Rate |
|
|
(+) Cash & Cash Equivalents |
$48,147,000,000 |
|
|
756.20 |
1.50% |
2.00% |
2.50% |
3.00% |
3.50% |
|
|
(-) Total Debt |
$14,454,000,000 |
|
WACC |
9.03% |
686.0 |
724.9 |
769.7 |
822.0 |
883.8 |
|
|
Equity Value |
$2,128,691,715,805 |
|
9.08% |
680.7 |
719.0 |
763.0 |
814.4 |
874.9 |
|
|
Shares Outstanding |
2815000000 |
|
9.13% |
675.5 |
713.1 |
756.5 |
806.9 |
866.2 |
|
|
|
|
|
9.63% |
627.0 |
659.2 |
695.8 |
737.9 |
787.0 |
|
|
DCF Intrinsic Value |
$756.20 |
|
10.13% |
584.4 |
612.1 |
643.3 |
679.0 |
720.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Swarnadeep
Seth (2022) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|