What a bank asks for before it sanctions
A term loan or working capital application reaches a credit team as a set of numbers about the future. The business has to show how much it will sell, what it will earn, what it will own and owe, and how the instalments will be met. For a new unit there is no trading history to lean on, so the projections carry the whole appraisal; for an existing unit they sit beside the audited accounts. Preparing those projections by hand, in the weeks when the proposal is also being negotiated, is where files slow down.
Two documents do most of the work. A CMA report, short for Credit Monitoring Arrangement, is the pack a bank reads for working capital finance and at every renewal. A project report, also called a detailed project report, is the document a bank appraises for a term loan or a new project. Both are built from projections, and both are expected in the format the credit team already uses.
Why manual projections go wrong
- The same figure entered in several places. Sales, purchases and expenses feed the operating statement, the balance sheet, the fund flow statement and the cash flow, so one typed figure can disagree with three statements.
- Formulas that break quietly. A copied cell that points at the wrong column does not look wrong until a total is checked by hand.
- Ratio and debt service working done separately. DSCR, the current ratio and TOL/TNW are often computed outside the model, so they drift from the statements they are meant to summarise.
- Changes not carried through. When the promoter revises a sales figure, the update lands in one sheet and not the others, and the file goes to the bank with an internal inconsistency.
- Versions that multiply. Several copies of the workbook circulate by email, and it becomes difficult to say which one is current.
What automated projection software does
Automated projection software keeps one set of inputs and derives every statement from it. Enter the opening position, the revenue assumptions and the loan terms, and the software calculates the rest, so the statements agree with each other by construction.
- Operating statement and projected profit and loss account for each year, from sales through direct and indirect costs, interest, depreciation, tax and net profit.
- Projected balance sheet with assets, liabilities and net worth, with each year's closing balances carried into the next year's opening figures.
- Cash flow statement showing inflows from capital, subsidy and borrowings against outflows for assets, interest, principal and drawings.
- Depreciation chart under the chosen method, written into the operating statement and the balance sheet.
- Month-wise EMI repayment schedule for each term loan, with principal, interest and closing balance.
- Statements a credit team expects beside the main three: comparative statement of current assets and liabilities, fund flow, break-even and sensitivity analysis.
The numbers a credit team checks
Projections are read through a small set of measures, and software that computes them from the same inputs keeps them honest.
- DSCR is receipts divided by repayments for each year, where receipts are net profit plus depreciation plus term-loan interest, and repayments are principal plus interest. A project report shows the yearly figure and an average DSCR row.
- Ratio analysis covers the current ratio, quick ratio, gross profit and net profit percentages, return on capital employed, debt-equity, TOL/TNW, interest coverage and turnover ratios, each with its formula.
- MPBF, the maximum permissible bank finance, is computed under the two Tandon Committee methods. Method I is 75 percent of the working capital gap, that is, MPBF = 75% of (total current assets minus current liabilities other than bank borrowings); Method II is MPBF = (75% of total current assets) minus current liabilities other than bank borrowings.
- The turnover method, used for many MSME assessments, takes the working capital requirement as 25 percent of projected annual turnover, with a borrower margin of 5 percent of turnover and bank finance of up to 20 percent of turnover.
What the software cannot do
Automation improves the quality and the consistency of a projection; it does not decide the loan. A lender weighs credit history, the promoter's contribution, security, the industry and its own policy along with the numbers, and no software can promise a sanction. What good projection software does is remove the avoidable reasons for a query: statements that disagree, ratios that cannot be traced, an EMI schedule that does not match the proposed terms.
How to choose projection software for bank loans
- Does it build all the statements from one set of inputs, so a change flows through automatically?
- Does it carry closing balances forward across years instead of asking for each year again?
- Does it compute MPBF under both methods and the turnover method, and show DSCR for every year?
- Does it support the entity type you are projecting for, from a proprietorship to a company?
- Can it import the books from Tally rather than asking for a full re-entry? Finxora reads a trial balance exported from TallyPrime or Tally.ERP 9 as XML, suggests a mapping for each ledger and lets you correct it before importing.
- Can the finished projection be downloaded in the format the bank wants, such as PDF, Word or Excel?
Spreadsheets, templates and dedicated software
A spreadsheet template is a reasonable starting point for a small, one-off projection. Its limits appear when the projection has to be revised: the statements are linked by formulas that have to be maintained by hand, the loan schedule sits in separate cells that can fall out of step, and each new year means rebuilding part of the sheet. A bank-ready pack has more moving parts than a single model, because it also carries an MPBF working, a fund flow statement, a ratio page and a DSCR table, and each of those has to agree with the balance sheet.
Dedicated software trades some of the spreadsheet's freedom for structure. The statements, the loan schedules and the ratio pages come from one set of inputs, the format follows the one banks expect, and the borrower's figures are saved so the next year's file starts from what is already there. The trade is that the layout is fixed rather than built cell by cell, which is usually an advantage when the document is going to a credit team.
Renewals are easier than first applications
A working capital limit is normally reviewed each year, and the review needs updated provisional figures and fresh projections. When the borrower's figures are saved as a master, a renewal updates the current and projected years instead of rebuilding the file, and the comparative statements show the movement the bank wants to see. The CMA report software is built around that cycle, while the project report software handles a new project or a term loan from project cost and means of finance. Both derive their statements from one set of inputs, and the samples show the finished format before you start.
