|
|
|
|
|
|
|
|
|
|
|
|
|
|
Intrinsic Valuation of BRITANNIA |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
BRITANNIA Free Cash Flow Average and Growth
over past 5Y |
|
Key Statistics |
|
|
Year |
|
FCF |
FCF Growth |
|
|
|
|
|
|
|
|
2021 |
|
$8,374,800,000 |
-51.90% |
|
EPS (FY) |
63.31 |
|
Market Cap |
889B |
|
|
2020 |
|
$17,411,300,000 |
30.67% |
|
P/E Ratio |
60.33 |
|
Total Asset |
75B |
|
|
2019 |
|
$13,324,400,000 |
54.56% |
|
Net Income |
15B |
|
Total Debt |
25B |
|
|
2018 |
|
$8,620,700,000 |
-7.05% |
|
EBITDA |
21B |
|
Total Liab |
49B |
|
|
2017 |
|
$9,274,700,000 |
514.71% |
|
Opr Margin |
0.1348 |
|
Debt/Equity |
0.96 |
|
|
2016 |
|
$1,508,800,000 |
|
|
PreTax Margin |
0.1393 |
|
BV/Share |
106.18 |
|
|
5Y Median FCF |
|
$11,401,180,000 |
30.67% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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): |
6.44% |
|
|
|
Current US Bond Yield: |
1.48% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forcasting Future Free Cash Flow for next 6Y |
|
Modified Benjamin Graham's Intrinsic Value |
|
|
Year |
|
FCF Projection |
|
|
|
|
|
|
|
|
|
2022 |
|
$10,943,543,817 |
|
|
MBG Intrinsic Value |
$1,329.55 |
|
|
2023 |
|
$14,300,180,456 |
|
|
|
|
|
|
|
|
|
2024 |
|
$18,686,374,769 |
|
|
|
|
|
|
|
|
|
2025 |
|
$24,417,915,780 |
|
|
|
|
|
|
|
|
|
2026 |
|
$31,907,452,269 |
|
|
|
|
|
|
|
|
|
2027 |
|
$41,694,201,892 |
|
|
|
|
|
|
|
|
|
Terminal Value |
|
$1,084,411,202,602 |
|
|
Net Worth/Share |
$107.34 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DCF Valuation |
|
DCF Valuation "What If" Scenario
Table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enterprise Value |
$809,981,920,152 |
|
|
|
Growth Rate |
|
|
(+) Cash & Cash Equivalents |
$10,186,300,000 |
|
|
3302.04 |
1.50% |
2.00% |
2.50% |
3.00% |
3.50% |
|
|
(-) Total Debt |
$24,812,000,000 |
|
WACC |
6.34% |
2756.1 |
3041.1 |
3400.2 |
3866.9 |
4497.8 |
|
|
Equity Value |
$795,356,220,152 |
|
6.39% |
2723.4 |
3001.5 |
3351.0 |
3803.5 |
4412.8 |
|
|
Shares Outstanding |
240868296 |
|
6.44% |
2691.4 |
2962.8 |
3303.0 |
3742.1 |
4330.6 |
|
|
|
|
|
6.94% |
2404.3 |
2619.6 |
2883.4 |
3214.2 |
3641.2 |
|
|
DCF Intrinsic Value |
$3,302.04 |
|
7.44% |
2166.5 |
2340.7 |
2550.1 |
2806.6 |
3128.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
© Swarnadeep
Seth (2022) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|