Assumptions blue workbook inputs
Revenue modelIncome statementBalance sheetCash flowScenariosDCF inputs editable input estimate years Expand
BANK OF INDIA | NSE: BANKINDIA | BSE: 532149 | Scenarios - bull, base and bear — Standalone financial statements prepared under Indian GAAP in the forms of the Third Schedule to the Banking Regulation Act, 1949 (RBI formats). Ind AS is not applicable to Indian banks at the build date. Reporting currency INR; all amounts in Rs crore (1 crore = 10 million) unless stated. Fiscal year ends 31 March; FY2026 = year ended 31-Mar-2026. Blue font = editable driver assumption. — Period type · Actual · Projected · Projected · Projected · Projected · Projected
| Line item | Unit / ref | FY2026 | FY2027 | FY2028 | FY2029 | FY2030 | FY2031 | |
|---|---|---|---|---|---|---|---|---|
| Basis | Audited | See scenario blocks below | See scenario blocks below | See scenario blocks below | See scenario blocks below | See scenario blocks below | ||
| A. DRIVER SETS - the three scenarios differ in every driver below | ||||||||
| Gross advances growth (global) | % | |||||||
| Bull | pct | 17% | 15% | 13.5% | 12.5% | 12% | ||
| Base | pct | 15.5% | 12.5% | 10.5% | 10.5% | 10% | FY27 guidance 15-16% (MD and CEO, Q1FY27 call 24-Jul-2026, transcript p5); about Rs 11 lakh cr advances by Mar-2029 (Q4FY26 call p10-11) | |
| Bear | pct | 11% | 9% | 8.5% | 8% | 8% | ||
| Total deposit growth (global) | % | |||||||
| Bull | pct | 15% | 14% | 13% | 12.5% | 12% | ||
| Base | pct | 13.5% | 12.5% | 11.5% | 11% | 10.5% | FY27 guidance 13-14% (MD and CEO, Q1FY27 call 24-Jul-2026, p5) | |
| Bear | pct | 10% | 9% | 8.5% | 8% | 8% | ||
| Investments as % of deposits | % | |||||||
| Bull | pct | 28% | 27.5% | 27% | 26.8% | 26.5% | ||
| Base | pct | 28% | 27.5% | 27% | 26.8% | 26.5% | FY26 actual 28.97% of deposits; SLR requirement 18.00% of NDTL, unchanged since 11-Apr-2020 | |
| Bear | pct | 28% | 27.5% | 27% | 26.8% | 26.5% | ||
| Cash and balances with RBI as % of deposits | % | |||||||
| Bull | pct | 5% | 5% | 5% | 5% | 5% | ||
| Base | pct | 5% | 5% | 5% | 5% | 5% | FY26 actual 5.10%; CRR 3.00% of NDTL after the final 25bp tranche effective 29-Nov-2025 | |
| Bear | pct | 5% | 5% | 5% | 5% | 5% | ||
| Other assets growth | % | |||||||
| Bull | pct | 8% | 8% | 8% | 8% | 8% | ||
| Base | pct | 8% | 8% | 8% | 8% | 8% | ||
| Bear | pct | 8% | 8% | 8% | 8% | 8% | ||
| Capital expenditure on fixed assets | Rs crore | |||||||
| Bull | crore | 700 | 750 | 800 | 850 | 900 | ||
| Base | crore | 700 | 750 | 800 | 850 | 900 | ||
| Bear | crore | 700 | 750 | 800 | 850 | 900 | ||
| Depreciation on bank property | Rs crore | |||||||
| Bull | crore | 740 | 760 | 790 | 820 | 850 | ||
| Base | crore | 740 | 760 | 790 | 820 | 850 | ||
| Bear | crore | 740 | 760 | 790 | 820 | 850 | ||
| Other liabilities and provisions as % of assets | % | |||||||
| Bull | pct | 2.5% | 2.5% | 2.5% | 2.5% | 2.5% | ||
| Base | pct | 2.5% | 2.5% | 2.5% | 2.5% | 2.5% | ||
| Bear | pct | 2.5% | 2.5% | 2.5% | 2.5% | 2.5% | ||
| Net new borrowings (bonds, ECB, refinance) | Rs crore | |||||||
| Bull | crore | 18,000 | 12,000 | 12,000 | 12,000 | 12,000 | ||
| Base | crore | 18,000 | 12,000 | 12,000 | 12,000 | 12,000 | FY27 includes the Board-approved AT-1 Rs 2,500 cr and Tier-2 Rs 5,000 cr plus the OFCB/MTN/ECB component of the USD 4.2bn FX resource plan (Q1FY27 call p8, p10, p12; IP-Q1FY27 p29) | |
| Bear | crore | 12,000 | 9,000 | 9,000 | 9,000 | 9,000 | ||
| CASA as % of domestic deposits | % | |||||||
| Bull | pct | 38% | 39% | 40% | 40.5% | 41% | ||
| Base | pct | 37% | 37.5% | 38% | 38.5% | 39% | FY26 actual 37.64%, Q1FY27 36.68%; management target about Rs 3.30 lakh cr CASA by end-FY27 (Q4FY26 call p17). The FY26 40% target was missed | |
| Bear | pct | 36% | 35.5% | 35% | 35% | 35% | ||
| Overseas deposits as % of total deposits | % | |||||||
| Bull | pct | 13.5% | 13.5% | 13.5% | 13.5% | 13.5% | ||
| Base | pct | 13.5% | 13.5% | 13.5% | 13.5% | 13.5% | ||
| Bear | pct | 13.5% | 13.5% | 13.5% | 13.5% | 13.5% | ||
| Yield on average net advances | % | |||||||
| Bull | pct | 7.55% | 7.65% | 7.75% | 7.78% | 7.78% | ||
| Base | pct | 7.42% | 7.45% | 7.5% | 7.5% | 7.5% | Q1FY27 actual 7.46%; FY26 7.80%; FY25 8.46% (IP-Q1FY27 p20). Repo held at 5.25% since 05-Dec-2025, four consecutive MPC holds to Aug-2026 | |
| Bear | pct | 7.15% | 7.12% | 7.12% | 7.15% | 7.15% | ||
| Yield on average investments | % | |||||||
| Bull | pct | 6.85% | 6.85% | 6.9% | 6.9% | 6.9% | ||
| Base | pct | 6.85% | 6.85% | 6.9% | 6.9% | 6.9% | Q1FY27 actual 6.87%, Q4FY26 6.91% (IP-Q1FY27 p20) | |
| Bear | pct | 6.7% | 6.68% | 6.68% | 6.72% | 6.72% | ||
| Yield on other earning assets | % | |||||||
| Bull | pct | 3.6% | 3.6% | 3.65% | 3.65% | 3.65% | ||
| Base | pct | 3.6% | 3.6% | 3.65% | 3.65% | 3.65% | ||
| Bear | pct | 3.6% | 3.6% | 3.65% | 3.65% | 3.65% | ||
| Cost of average deposits | % | |||||||
| Bull | pct | 4.5% | 4.5% | 4.55% | 4.58% | 4.58% | ||
| Base | pct | 4.6% | 4.62% | 4.7% | 4.72% | 4.72% | Q1FY27 actual 4.69%, FY26 4.80%, FY25 4.93% (IP-Q1FY27 p20); deposit repricing tailwind still running | |
| Bear | pct | 4.85% | 4.9% | 4.92% | 4.92% | 4.92% | ||
| Cost of average borrowings | % | |||||||
| Bull | pct | 7.05% | 6.95% | 6.95% | 6.95% | 6.95% | ||
| Base | pct | 7.2% | 7.1% | 7.1% | 7.1% | 7.1% | Implied FY26 cost of average borrowings 7.54% from Schedule 15 over average balance-sheet borrowings | |
| Bear | pct | 7.45% | 7.45% | 7.45% | 7.45% | 7.45% | ||
| Commission, exchange and brokerage growth | % | |||||||
| Bull | pct | 15% | 14% | 13% | 12.5% | 12% | ||
| Base | pct | 12% | 12% | 11% | 11% | 10% | FY26 commission, exchange and brokerage Rs 2,177 cr (+9.1% YoY); Q1FY27 Rs 404 cr (-0.5% YoY) | |
| Bear | pct | 7% | 7% | 7% | 7% | 7% | ||
| Profit on sale of investments (treasury) | Rs crore | |||||||
| Bull | crore | 2,400 | 2,200 | 2,200 | 2,250 | 2,300 | ||
| Base | crore | 1,900 | 1,600 | 1,600 | 1,650 | 1,700 | FY26 actual Rs 2,137 cr; Q1FY27 Rs 414 cr (-49.5% YoY). Management explicitly declines to guide treasury (Q1FY27 call p9) | |
| Bear | crore | 1,000 | 800 | 800 | 850 | 900 | ||
| Profit on revaluation of investments | Rs crore | |||||||
| Bull | crore | 0 | 0 | 0 | 0 | 0 |