Bank of India
NSE: BANKINDIA · Model build Since listing
Analyst
S. Rahman
Status
drafting
Model reviewer
BANKINDIA_Financial_Model_2026-08-31.xlsx · 292 editable inputs · recalculated 2026-09-01 07:44:07
Assumptions blue workbook inputs
Investments as % of deposits - FY2008N31
Cash and balances with RBI as % of deposits - FY2008N32
Overseas deposits as % of total deposits - FY2008N34
Bull - FY2027D8
Bull - FY2028E8
Bull - FY2029F8
Bull - FY2030G8
Bull - FY2031H8
Base - FY2027D9
Base - FY2028E9
Base - FY2029F9
Base - FY2030G9
Base - FY2031H9
Bear - FY2027D10
Bear - FY2028E10
Bear - FY2029F10
Bear - FY2030G10
Bear - FY2031H10
Bull - FY2027D12
Bull - FY2028E12
Bull - FY2029F12
Bull - FY2030G12
Bull - FY2031H12
Base - FY2027D13
Base - FY2028E13
Base - FY2029F13
Base - FY2030G13
Base - FY2031H13
Bear - FY2027D14
Bear - FY2028E14
Bear - FY2029F14
Bear - FY2030G14
Bear - FY2031H14
Bull - FY2027D16
Bull - FY2028E16
Bull - FY2029F16
Bull - FY2030G16
Bull - FY2031H16
Base - FY2027D17
Base - FY2028E17
Base - FY2029F17
Base - FY2030G17
Base - FY2031H17
Bear - FY2027D18
Bear - FY2028E18
Bear - FY2029F18
Bear - FY2030G18
Bear - FY2031H18
Bull - FY2027D20
Bull - FY2028E20
Bull - FY2029F20
Bull - FY2030G20
Bull - FY2031H20
Base - FY2027D21
Base - FY2028E21
Base - FY2029F21
Base - FY2030G21
Base - FY2031H21
Bear - FY2027D22
Bear - FY2028E22
Bear - FY2029F22
Bear - FY2030G22
Bear - FY2031H22
Bull - FY2027D24
Bull - FY2028E24
Bull - FY2029F24
Bull - FY2030G24
Bull - FY2031H24
Base - FY2027D25
Base - FY2028E25
Base - FY2029F25
Base - FY2030G25
Base - FY2031H25
Bear - FY2027D26
Bear - FY2028E26
Bear - FY2029F26
Bear - FY2030G26
Bear - FY2031H26
Bull - FY2027D28
Bull - FY2028E28
Bull - FY2029F28
Bull - FY2030G28
Bull - FY2031H28
Base - FY2027D29
Base - FY2028E29
Base - FY2029F29
Base - FY2030G29
Base - FY2031H29
Bear - FY2027D30
Bear - FY2028E30
Bear - FY2029F30
Bear - FY2030G30
Bear - FY2031H30
Bull - FY2027D32
Bull - FY2028E32
Bull - FY2029F32
Bull - FY2030G32
Bull - FY2031H32
Base - FY2027D33
Base - FY2028E33
Base - FY2029F33
Base - FY2030G33
Base - FY2031H33
Bear - FY2027D34
Bear - FY2028E34
Bear - FY2029F34
Bear - FY2030G34
Bear - FY2031H34
Bull - FY2027D36
Bull - FY2028E36
Bull - FY2029F36
Bull - FY2030G36
Bull - FY2031H36
Base - FY2027D37
Base - FY2028E37
Base - FY2029F37
Base - FY2030G37
Base - FY2031H37
Bear - FY2027D38
Bear - FY2028E38
Bear - FY2029F38
Bear - FY2030G38
Bear - FY2031H38
Bull - FY2027D40
Bull - FY2028E40
Bull - FY2029F40
Bull - FY2030G40
Bull - FY2031H40
Base - FY2027D41
Base - FY2028E41
Base - FY2029F41
Base - FY2030G41
Base - FY2031H41
Bear - FY2027D42
Bear - FY2028E42
Bear - FY2029F42
Bear - FY2030G42
Bear - FY2031H42
Bull - FY2027D44
Bull - FY2028E44
Bull - FY2029F44
Bull - FY2030G44
Bull - FY2031H44
Base - FY2027D45
Base - FY2028E45
Base - FY2029F45
Base - FY2030G45
Base - FY2031H45
Bear - FY2027D46
Bear - FY2028E46
Bear - FY2029F46
Bear - FY2030G46
Bear - FY2031H46
Bull - FY2027D48
Bull - FY2028E48
Bull - FY2029F48
Bull - FY2030G48
Bull - FY2031H48
Base - FY2027D49
Base - FY2028E49
Base - FY2029F49
Base - FY2030G49
Base - FY2031H49
Bear - FY2027D50
Bear - FY2028E50
Bear - FY2029F50
Bear - FY2030G50
Bear - FY2031H50
Bull - FY2027D52
Bull - FY2028E52
Bull - FY2029F52
Bull - FY2030G52
Bull - FY2031H52
Base - FY2027D53
Base - FY2028E53
Base - FY2029F53
Base - FY2030G53
Base - FY2031H53
Bear - FY2027D54
Bear - FY2028E54
Bear - FY2029F54
Bear - FY2030G54
Bear - FY2031H54
Bull - FY2027D56
Bull - FY2028E56
Bull - FY2029F56
Bull - FY2030G56
Bull - FY2031H56
Base - FY2027D57
Base - FY2028E57
Base - FY2029F57
Base - FY2030G57
Base - FY2031H57
Bear - FY2027D58
Bear - FY2028E58
Bear - FY2029F58
Bear - FY2030G58
Bear - FY2031H58
Bull - FY2027D60
Bull - FY2028E60
Bull - FY2029F60
Bull - FY2030G60
Bull - FY2031H60
Base - FY2027D61
Base - FY2028E61
Base - FY2029F61
Base - FY2030G61
Base - FY2031H61
Bear - FY2027D62
Bear - FY2028E62
Bear - FY2029F62
Bear - FY2030G62
Bear - FY2031H62
Bull - FY2027D64
Bull - FY2028E64
Bull - FY2029F64
Bull - FY2030G64
Bull - FY2031H64
Base - FY2027D65
Base - FY2028E65
Base - FY2029F65
Base - FY2030G65
Base - FY2031H65
Bear - FY2027D66
Bear - FY2028E66
Bear - FY2029F66
Bear - FY2030G66
Bear - FY2031H66
Bull - FY2027D68
Bull - FY2028E68
Bull - FY2029F68
Bull - FY2030G68
Bull - FY2031H68
Base - FY2027D69
Base - FY2028E69
Base - FY2029F69
Base - FY2030G69
Base - FY2031H69
Bear - FY2027D70
Bear - FY2028E70
Bear - FY2029F70
Bear - FY2030G70
Bear - FY2031H70
Bull - FY2027D72
Bull - FY2028E72
Bull - FY2029F72
Bull - FY2030G72
Bull - FY2031H72
Base - FY2027D73
Base - FY2028E73
Base - FY2029F73
Base - FY2030G73
Base - FY2031H73
Bear - FY2027D74
Bear - FY2028E74
Bear - FY2029F74
Bear - FY2030G74
Bear - FY2031H74
Bull - FY2027D76
Bull - FY2028E76
Bull - FY2029F76
Bull - FY2030G76
Bull - FY2031H76
Base - FY2027D77
Base - FY2028E77
Base - FY2029F77
Base - FY2030G77
Base - FY2031H77
Bear - FY2027D78
Bear - FY2028E78
Bear - FY2029F78
Bear - FY2030G78
Bear - FY2031H78
Bull - FY2027D80
Bull - FY2028E80
Bull - FY2029F80
Bull - FY2030G80
Bull - FY2031H80
Risk-free rate - 10-year Government of India security - FY2026C11
Equity risk premium - India - FY2026C12
Levered beta - FY2026C13
Country risk premium - FY2026C14
Terminal growth rate - FY2026C16
Terminal sustainable return on equity - FY2026C17
CET-1 regulatory minimum including capital conservation buffer - FY2026C21
CET-1 operating target used for the capital-retention calculation - FY2026C22
Total CRAR regulatory minimum including buffer - FY2026C23
Cost of equity - FY2027D80
Cost of equity - FY2028E80
Cost of equity - FY2029F80
Cost of equity - FY2030G80
Cost of equity - FY2031H80
Edits write to the Excel master; every dependent figure, table and chart input recalculates.
BANK OF INDIA | NSE: BANKINDIA | BSE: 532149 | Cash flow statement - AS-3 indirect method, banking presentation — 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 · PARTIAL · PARTIAL · PARTIAL · PARTIAL · PARTIAL · PARTIAL · PARTIAL · PARTIAL · PARTIAL · PARTIAL · PARTIAL · Actual
Line itemUnit / refFY1997FY1998FY1999FY2000FY2001FY2002FY2003FY2004FY2005FY2006FY2007FY2008
BasisFragments onlyFragments onlyFragments onlyFragments onlyFragments onlyFragments onlyFragments onlyFragments onlyFragments onlyFragments onlyFragments onlyAudited
A. CASH FLOW FROM OPERATING ACTIVITIES
Net profit before taxcroren.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.2,685
Adjustments for non-cash and non-operating items
Depreciation on bank propertycroren.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.73.13
Depreciation and amortisation on investmentscrore83.42
Provisions and contingencies (other than tax)crore70.31
Loss on sale of fixed assetscrore
Dividend received from subsidiaries (shown in investing)crore-6.30
Interest on subordinated debt (added back; paid in financing)crore
ECL transition provision charged to reserves (non-cash, excluded)crore
Movements in operating assets and liabilities
Increase / (decrease) in depositscrore30,130
Increase / (decrease) in borrowingscrore551.62
Increase / (decrease) in other liabilities and provisionscrore984.05
(Increase) / decrease in advancescrore-29,058
(Increase) / decrease in investmentscrore-6,533
(Increase) / decrease in other assetscrore-207.10
Direct taxes paid (net of refunds)crore-848.83
Components disclosed in the statement but not separately extractedbalancing1,511
NET CASH FROM / (USED IN) OPERATING ACTIVITIEScroren.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.-565.02
B. CASH FLOW FROM INVESTING ACTIVITIES
Purchase of fixed assetscrore-101.22
Proceeds from sale of fixed assetscrore6.09
Investment in / dividend from subsidiaries and joint venturescrore-94.50
NET CASH FROM / (USED IN) INVESTING ACTIVITIEScroren.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.-183.33
C. CASH FLOW FROM FINANCING ACTIVITIES
Proceeds from issue of share capitalcrore37.77
Share premium receivedcrore1,322
Issue / (redemption) of subordinated and perpetual bondscrore187.03
Interest paid on subordinated and perpetual bondscrore-401.11
Dividend paid (including dividend distribution tax where applicable)crore-85.53
NET CASH FROM / (USED IN) FINANCING ACTIVITIEScroren.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.1,060
D. MOVEMENT IN CASH AND CASH EQUIVALENTS
Net increase / (decrease) in cash and cash equivalentscroren.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.311.85
Cash and cash equivalents at the beginning of the yearcroren.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.17,406
Cash and cash equivalents at the end of the yearcroren.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.n.a.17,717
E. INTEGRITY CHECKS
Operating plus investing plus financing less net change in cashcrore10
Closing cash less opening cash less net change in cashcrore10
Closing cash less balance-sheet Schedules 6 and 7crore10.00
F. CASH FLOW DRIVERS (editable inputs)
Capital expenditure on fixed assetscrore
Depreciation on bank propertycrore
Additional Tier-1 issuancecrore
Tier-2 issuancecrore
Equity capital raisedcrore
Net new borrowings (bonds, ECB, refinance)crore
Dividend payout ratio (on prior-year profit)pct
ECL transition charge to opening reservescrore
NOTES, SOURCES AND STRUCTURAL BREAKS
PRESENTATION. Indian banks present cash flow under AS-3 using the indirect method, with movements in deposits, borrowings and advances classified as OPERATING rather than financing or investing, because taking deposits and making loans is the operating activity of a bank. Only capital instruments (equity, subordinated and perpetual bonds) and dividends sit in financing. That convention is followed here for both the history and the projections, so the two are directly comparable.
CASH AND CASH EQUIVALENTS are defined by the Bank as cash and balances with the Reserve Bank of India (Schedule 6) plus balances with banks and money at call and short notice (Schedule 7). The closing balance is checked back to those two balance-sheet lines in section E and ties in every year.
THE BALANCING LINE. For a small number of historical years the annual report disclosed adjustment items that this extraction did not capture as separate fields - most commonly the split of the movement in deposits, advances and borrowings for FY2026. Rather than force those subtotals or silently drop them, the difference is shown on its own labelled line, "Components disclosed in the statement but not separately extracted". The disclosed operating, investing and financing subtotals are the audited figures and are used as printed; nothing has been recomputed.
CASH FLOW HISTORY DEPTH. Cash flow statements have been sourced for FY2008 to FY2026. Years shown as "n.a." on this sheet were not located and have not been reconstructed from balance-sheet movements, which would not reproduce the audited statement because of exchange translation and non-cash adjustments.
PROJECTED CASH FLOW. The projected statement is derived arithmetically from the projected balance sheet and profit and loss, so it is a restatement of those sheets rather than an independent forecast. The change in borrowings is split between the operating line (ordinary market borrowing) and the financing line (AT-1 and Tier-2 issuance), matching the Bank's own presentation. A reconciling line is carried so that the sum of the three activities equals the movement in the balance-sheet cash lines exactly.
PROJECTED STATEMENT TIES BY CONSTRUCTION. In the projected years profit before tax is struck after depreciation and after all provisions, and the asset and liability movements used are the balance-sheet movements, which are also net of provisions, so nothing is added back twice and no balancing line is needed. The one non-cash item explicitly removed is the ECL transition provision: it reduces reserves and reduces net advances by the same amount without any cash moving. The three integrity checks in section E are nil in every projected year of all three scenarios.
DIVIDEND TIMING. Dividends appear in the financing section of the year in which they are PAID, which under Indian practice is the year after the profit to which they relate. The FY2026 outflow of Rs 1,843.8 crore is the dividend on FY2025 earnings.