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)