Assumptions blue workbook inputs
Revenue modelIncome statementBalance sheetCash flowScenariosDCF inputs editable input estimate years Expand
HDFC Bank Limited - Standalone Cash Flow Statement — INR billion | fiscal year ends 31 March | FY2024A-FY2026A audited standalone Indian GAAP, FY2027E-FY2031E projected | Blue = driver assumption (editable) Black = actual or formula Green = cross-sheet link Red = structural-break flag | Derived from balance sheet movements; FY2024 omitted (requires the pre-merger FY2023 balance sheet)
| FY2024A | FY2025A | FY2026A | FY2027E | FY2028E | FY2029E | FY2030E | FY2031E | |
|---|---|---|---|---|---|---|---|---|
| OPERATING ACTIVITIES | ||||||||
| Net profit for the year | 673.47 | 746.71 | 774.11 | 904.14 | 1,077 | 1,226 | 1,359 | |
| Add: depreciation on the Bank property | 33.80 | 36.58 | 39.14 | 42.46 | 46.28 | 50.45 | 54.99 | |
| (Increase) in advances, net | -1,347 | -3,176 | -4,111 | -3,987 | -4,274 | -4,553 | -4,818 | |
| (Increase) in investments | -1,339 | -478.42 | -1,203 | -1,256 | -1,356 | -1,455 | -1,552 | |
| (Increase) in other assets | -12.04 | -293.23 | -234.33 | -317.20 | -342.58 | -367.70 | -392.16 | |
| Increase in deposits | 3,349 | 3,905 | 4,192 | 4,406 | 4,758 | 5,107 | 5,447 | |
| Increase in other liabilities and provisions | 106.91 | 612.12 | 182.25 | 242.31 | 255.35 | 316.63 | 337.69 | |
| NET CASH FROM OPERATING ACTIVITIES | 1,464 | 1,354 | -360.15 | 34.65 | 164.25 | 324.17 | 436.05 | |
| INVESTING ACTIVITIES | ||||||||
| Purchase of fixed assets, net of disposals and depreciation | -56.36 | -47.27 | -48.89 | -53.46 | -57.28 | -62.45 | -67.99 | |
| NET CASH USED IN INVESTING ACTIVITIES | -56.36 | -47.27 | -48.89 | -53.46 | -57.28 | -62.45 | -67.99 | |
| FINANCING ACTIVITIES | ||||||||
| Proceeds from issue of share capital and ESOP exercises | 63.47 | 51.09 | 55 | 57 | 59 | 61 | 63 | |
| Increase / (repayment) of borrowings, net | -1,142 | -585.36 | 306.05 | 400 | 450 | 500 | 550 | |
| Dividends declared and paid | -167.80 | -238.05 | -247.36 | -279.36 | -319.39 | -359.72 | -400.35 | |
| Other movements in reserves (ESOP charge, reserve transfers, dividend timing) | 42.65 | 55.02 | 0.00 | 0 | 0 | 0.00 | -0.00 | |
| NET CASH FROM / (USED IN) FINANCING ACTIVITIES | -1,204 | -717.31 | 113.69 | 177.64 | 189.61 | 201.28 | 212.65 | |
| NET INCREASE / (DECREASE) IN CASH AND CASH EQUIVALENTS | 204.23 | 588.96 | -295.34 | 158.83 | 296.57 | 463.00 | 580.71 | |
| Cash and cash equivalents at the beginning of the year | 2,191 | 2,396 | 2,985 | 2,689 | 2,848 | 3,145 | 3,608 | |
| CASH AND CASH EQUIVALENTS AT THE END OF THE YEAR | 2,396 | 2,985 | 2,689 | 2,848 | 3,145 | 3,608 | 4,188 | |
| Memo: cash and cash equivalents per the balance sheet (Schedule 6 + Schedule 7) | 2,191 | 2,396 | 2,985 | 2,689 | 2,848 | 3,145 | 3,608 | 4,188 |
| CASH FLOW CHECK (must be nil) | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | |
| AUDITED CASH FLOW STATEMENT AS REPORTED (memo, different presentation) | ||||||||
| Net cash from operating activities (as reported) | 1,452 | 1,236 | ||||||
| Net cash from / (used in) investing activities (as reported) | -20.39 | 92.54 | ||||||
| Net cash used in financing activities (as reported) | -1,229 | -750.70 | ||||||
| Effect of foreign currency translation reserve movement | 1.94 | 10.95 | ||||||
| Net increase in cash and cash equivalents (as reported) | 204.23 | 588.96 | ||||||
| Direct taxes paid (as reported) | -173.76 | -200.41 | ||||||
| Presentation note. The statement above is derived directly from balance sheet movements so that closing cash ties to the balance sheet in every year by construction (row 31). Row 24 is the reconciling line: for FY2025A and FY2026A it carries the movements in reserves that do not pass through the reported profit line (the employee stock option charge, the foreign currency translation and available-for-sale reserves, and the timing difference between dividends declared for a year and dividends actually paid in it). In the projection years it is nil by construction because net worth is rolled forward as profit less dividends declared plus issuance proceeds. | ||||||||
| The Bank audited statement classifies the same movements differently: it adds back provisions and shows advances gross of them, treats subsidiary transactions as investing, and shows direct taxes paid rather than the accrued charge. Its totals are reproduced on rows 34 to 39. Both presentations reach the same closing cash: INR 2,395.7bn at 31 March 2025 and INR 2,984.7bn at 31 March 2026. | ||||||||
| FY2024 is omitted because deriving it requires the 31 March 2023 balance sheet, which is pre-merger and not comparable. The audited FY2024 statement is not reproduced here for the same reason. |