| Intrinsic Valuation of: INDIANB | |||||||||||
| Free Cash Flow Average and Growth over past 5Y | Key Statistics | ||||||||||
| Year | FCF | FCF (FCF/Revenue) | |||||||||
| 2021 | - | - | EPS (FY) | 87 | Market Cap | ₹1,105B | |||||
| 2022 | - | - (-) | P/E Ratio | 9 | Total Asset | ₹9,916B | |||||
| 2023 | ₹-282B | - (-) | Net Income | ₹117B | Total Debt | ₹0 | |||||
| 2024 | ₹-92B | 67.3% (71.2%) | EBITDA | - | Total Liab | ₹9,115B | |||||
| 2025 | ₹169B | 282.4% (265.1%) | Opr Margin | - | Debt/Equity | - | |||||
| 2026 | ₹184B | 8.9% (1.5%) | PreTax Margin | - | BV/Share | 594 | |||||
| 5Y Average FCF | ₹-6B | 15.0% (112.6%) | |||||||||
| 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.00% | Current US Bond Yield: | 3.48% | ||||||||
| Forcasting Future Free Cash Flow for next 6Y | Modified Benjamin Graham's Intrinsic Value | ||||||||||
| Year | FCF Projection (15.0%) | ||||||||||
| 2027 | ₹209B | MBG Intrinsic Value | ₹777 | ||||||||
| 2028 | ₹235B | ||||||||||
| 2029 | ₹258B | ||||||||||
| 2030 | ₹277B | ||||||||||
| 2031 | ₹291B | ||||||||||
| 2032 | ₹298B | ||||||||||
| Terminal Value | ₹6,766B | Net Worth/Share | ₹595 | ||||||||
| DCF Valuation | DCF Valuation "What If" Scenario Table | ||||||||||
| Enterprise Value | ₹5,737B | Growth Rate | |||||||||
| (+) Cash & Cash Equivalents | ₹657B | ₹4,747 | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% | ||||
| (-) Total Debt | ₹0 | WACC | 6.5% | 4,485 | 4,841 | 5,286 | 5,857 | 6,618 | |||
| Equity Value | ₹6,394B | 7.1% | 4,035 | 4,306 | 4,635 | 5,044 | 5,565 | ||||
| Shares Outstanding | 1,346,963,981 | 7.8% | 3,669 | 3,880 | 4,131 | 4,434 | 4,809 | ||||
| 8.4% | 3,371 | 3,538 | 3,735 | 3,967 | 4,247 | ||||||
| DCF Intrinsic Value | ₹4,747 | 9.0% | 3,126 | 3,262 | 3,419 | 3,603 | 3,819 | ||||
| Analyzed by QuantJuice (2025) | |||||||||||