| Intrinsic Valuation of: BRITANNIA | |||||||||||
| Free Cash Flow Average and Growth over past 5Y | Key Statistics | ||||||||||
| Year | FCF | FCF (FCF/Revenue) | |||||||||
| 2021 | - | - | EPS (FY) | 105 | Market Cap | ₹1,302B | |||||
| 2022 | - | - (-) | P/E Ratio | 51 | Total Asset | ₹97B | |||||
| 2023 | ₹18B | - (-) | Net Income | ₹25B | Total Debt | ₹3B | |||||
| 2024 | ₹20B | 11.3% (7.5%) | EBITDA | ₹37B | Total Liab | ₹46B | |||||
| 2025 | ₹21B | 4.7% (-1.2%) | Opr Margin | 17.01 | Debt/Equity | 0.06 | |||||
| 2026 | ₹24B | 13.7% (5.7%) | PreTax Margin | 16.41 | BV/Share | 206 | |||||
| 5Y Average FCF | ₹21B | 7.4% (4.0%) | |||||||||
| Overall Market Assumptions: | |||||||||||
| Assumptions: | P/E for No-Growth Company: | 7.0 | |||||||||
| Perpetual Growth Rate (g): | 2.48% | Historical US Bond Yield: | 4.40% | ||||||||
| Discount Rate (WACC): | 7.01% | Current US Bond Yield: | 3.48% | ||||||||
| Forcasting Future Free Cash Flow for next 6Y | Modified Benjamin Graham's Intrinsic Value | ||||||||||
| Year | FCF Projection (7.4%) | ||||||||||
| 2027 | ₹25B | MBG Intrinsic Value | ₹942 | ||||||||
| 2028 | ₹26B | ||||||||||
| 2029 | ₹28B | ||||||||||
| 2030 | ₹29B | ||||||||||
| 2031 | ₹30B | ||||||||||
| 2032 | ₹31B | ||||||||||
| Terminal Value | ₹698B | Net Worth/Share | ₹213 | ||||||||
| DCF Valuation | DCF Valuation "What If" Scenario Table | ||||||||||
| Enterprise Value | ₹598B | Growth Rate | |||||||||
| (+) Cash & Cash Equivalents | ₹2B | ₹2,480 | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% | ||||
| (-) Total Debt | ₹3B | WACC | 6.5% | 2,332 | 2,537 | 2,794 | 3,124 | 3,563 | |||
| Equity Value | ₹597B | 7.1% | 2,068 | 2,224 | 2,413 | 2,648 | 2,947 | ||||
| Shares Outstanding | 240,868,296 | 7.8% | 1,860 | 1,982 | 2,127 | 2,302 | 2,518 | ||||
| 8.4% | 1,687 | 1,784 | 1,898 | 2,032 | 2,194 | ||||||
| DCF Intrinsic Value | ₹2,480 | 9.0% | 1,544 | 1,622 | 1,713 | 1,818 | 1,943 | ||||
| Analyzed by QuantJuice (2025) | |||||||||||