Why a bank starts with the cash flow
A bank sanctioning a term loan or a working capital limit is not only asking whether the business is profitable. It is asking whether cash will arrive in time to pay interest and principal on the due dates. Profit on paper and cash in the bank are different things: a sale made on ninety days of credit adds to profit in the month of the invoice, but the money reaches the account much later. A projected cash flow statement shows the timing, month by month and year by year, and that is what a credit officer tests the proposal against.
Where the proposal includes a working capital facility, the projection also shows how the operating cycle behaves: how long stock sits before it is sold, how long debtors take to pay, and how much the business funds on its own before the bank finance comes in. The figures the bank reads here are the same ones it uses to fix the limit.
What a cash flow projection contains
Lay out a five-year cash flow projection
Use one column for each financial year, with a supporting monthly schedule where timing matters. Five years is an illustration of the layout, not a universal bank requirement. Confirm the required horizon and extend it where the lender needs to review repayments beyond year five.
- Opening cash carried from the previous period.
- Customer collections and other operating receipts.
- Supplier payments, wages, overheads and taxes.
- Asset purchases and disposal proceeds.
- Promoter funds, loan receipts, principal repayments, interest and withdrawals or distributions.
- Closing cash: opening cash plus receipts less payments.
Do not substitute sales for collections or include depreciation as a cash payment. Reconcile closing cash to the projected balance sheet and outstanding debt to the repayment schedule. If monthly cash falls below the funding available, show the gap even when the annual total remains positive.
In a bank loan file the projection is built on the same assumptions as the projected profit and loss account and balance sheet. The usual rows are:
- Opening cash balance at the start of the year, carried forward from the previous year's closing figure.
- Operating inflows such as cash sales, collections from debtors, and other receipts from the business.
- Operating outflows such as payments to suppliers, wages, rent, power and fuel, freight, selling expenses and the tax paid during the year.
- Other items including capital expenditure, the drawdown of a fresh term loan, subsidy received, and drawings by the proprietor or partners.
- Finance costs covering interest on existing and proposed borrowings, and the instalments due on term loans.
- Net cash flow for the period and the cumulative position after adding it to the opening balance.
Depreciation never appears as a cash payment. It reduces profit, so it is added back when the projection is built from the profit figure. Working capital movements behave in the opposite way: an increase in stock or debtors absorbs cash even though it is not an expense.
Keeping the statements tied together
The quickest way to lose a credit officer's confidence is three statements that do not agree. A sound projection satisfies a few simple rules at every year end:
- The closing cash in the cash flow equals the cash and bank balances in the projected balance sheet.
- The profit carried into the cash flow matches the operating statement.
- Interest and principal in the cash flow match the repayment schedule, loan by loan.
- Retained profit in the balance sheet equals opening net worth plus profit after tax, less drawings and dividends.
Debt service is read from the same figures. DSCR is computed as receipts, that is net profit plus depreciation plus term loan interest, divided by repayments, that is principal plus interest, and an average DSCR row sits beside the yearly figures.
Building the projection step by step
- Start from the audited figures of the last two or three years, so the trend is visible.
- Set the sales assumption from capacity, orders or past growth, and be ready to defend it.
- Convert sales into collections using a realistic debtor period, and split the year into months where the business is seasonal.
- Cost the purchases and expenses at the holding levels the business actually works with, using stock days, creditor days and the credit terms suppliers give.
- Add the proposed loan: drawdown, any moratorium, the interest rate, the repayment frequency and the instalments.
- Provide for tax and for drawings, then read the closing cash of each year. A year that dips below zero signals that the proposal or the repayment plan needs attention before the bank finds it.
Assumptions a bank will question
Most queries in an appraisal come back to the assumptions behind the cash flow. Four are asked again and again:
- Sales growth and why the unit can grow at the rate claimed when the industry is growing more slowly.
- Debtor days and why customers will pay faster than they have in the past.
- Stock levels and why inventory can be held lower without affecting sales.
- Drawings and whether the promoter's withdrawals leave enough cash in the business to service the loan.
The working capital side of the same story
Where the proposal includes a cash credit or overdraft limit, the bank also works out how much short term finance the operating cycle can support. Under the first method of the Tandon Committee approach, the maximum permissible bank finance is 75% of the working capital gap, that is, 75% × (total current assets − other current liabilities), which leaves the borrower a margin of 25% of the gap. Under the second method it is (75% × total current assets) − other current liabilities, with the margin at 25% of total current assets. Other current liabilities means current liabilities excluding bank borrowings. For an eligible micro, small or medium enterprise assessed on the turnover method, the working capital requirement is taken as 25% of projected annual turnover, the borrower provides a margin of 5% of turnover, and bank finance can go up to 20% of turnover. Which method a bank applies depends on the facility and the borrower, so confirm it with the relationship manager.
What the bank checks before sanction
Along with the projection, banks read the ratio analysis. The current ratio shows whether short term assets cover short term liabilities, TOL/TNW shows how much of the net worth is already committed to outside liabilities, and DSCR shows the cushion on repayments. Growth assumptions far ahead of the industry, debtor periods that improve every year without a reason, and a projection that never shows a tight month are the usual triggers for questions. A conservative base case with a sensitivity run is easier to defend than a single optimistic line, and it tells you which assumption the proposal depends on most.
How Finxora handles the working
Finxora's project report software builds the projected profit and loss account, balance sheet, cash flow, depreciation chart, EMI schedules, DSCR and break-even from one set of inputs, so the statements agree with each other instead of being reconciled by hand. The CMA report software covers the same ground for working capital files, with MPBF under both methods and the turnover method computed alongside. Reports export as PDF, Word or Excel, and the samples show the statements as they print before you begin.
