Finxora Logo
Sign In
ICICI Bank Cash Credit CMA Excel Sheet: How to Build It
Back to Blog

ICICI Bank Cash Credit CMA Excel Sheet: How to Build It

FINXORA
6 min read
ICICI Bank
cash credit
CMA
Excel
financial modeling

A cash credit limit is assessed on CMA data. Here is how to lay out the Excel workbook, link the statements and check the figures before you submit.

What the workbook has to produce

An ICICI Bank cash credit application is assessed on CMA data, and the Excel sheet is the working behind it. The workbook has to hold three things at once: the borrower's audited history, the current year's provisional figures, and the projection for the years ahead, with the working capital computation that decides the limit. The sheets are linked, so a change in sales growth moves the operating statement, the balance sheet and the maximum permissible bank finance together.

The exact checklist comes from the branch, and requirements vary with the facility and the borrower, so confirm what the relationship manager wants before building the file. What does not vary much is the internal order of the workbook described below.

The sheets, in order

SheetWhat it holds
AssumptionsGrowth in volume and rate, cost percentages, capacity utilisation, interest rates and working capital days
Operating statementSales through direct costs, gross profit, indirect expenses, interest, depreciation, tax and net profit
Balance sheetCapital, reserves, borrowings, current liabilities and current assets, with closing balances carried forward
Current assets and liabilitiesEvery current item with its holding level in days and the year-on-year change
MPBFThe maximum permissible bank finance under both methods, with the margin
Fund flow and cash flowSources and uses of long-term funds, and the movement in cash by activity
RatiosLiquidity, profitability, leverage, activity and debt service ratios with their formulas

Columns and year span

A common layout runs a Particulars column first, then two or three audited years, the provisional year and two or three projected years, all on the same sheet so the movement is visible. Keep the financial years as column headings and never re-number them: a sheet where the audited years, the provisional year and the projections sit in different blocks with different labels is the most common reason behind figures that cannot be reconciled at the branch.

Linking the statements

The operating statement is the engine. Net profit after tax and depreciation feed the balance sheet; the balance sheet's current assets and current liabilities feed the working capital sheet; and the working capital sheet feeds the MPBF computation. Build the links with formulas rather than by typing totals, because a hard-coded total is the first figure to go stale when an assumption changes.

  • Reserves for each year equal last year's reserves plus the year's net profit, less drawings or dividend.
  • Depreciation comes from the fixed-asset schedule, not from a percentage typed on the operating statement.
  • Interest is computed on the average borrowing for the year at the rate assumed, and the rate should be the one discussed with the branch.
  • Closing stock, debtors and creditors follow from the holding days or the turnover ratios used, not from a separate guess.
  • Term-loan balances reduce by the principal repaid in the year, as per the repayment schedule.

The working capital and MPBF sheets

The working capital sheet lists current assets (stock, debtors, cash and other current assets) and current liabilities other than bank borrowings (creditors, provisions and other current liabilities), and works out the gap. The MPBF sheet then applies the two Tandon Committee methods, because the bank's internal policy decides which it follows:

  • Method I = 75% x (Total Current Assets - Other Current Liabilities), where other current liabilities are current liabilities excluding bank borrowings. This leaves the borrower a margin of 25% of the working capital gap.
  • Method II = 75% x Total Current Assets - Other Current Liabilities, leaving a margin of 25% of total current assets.

Show both, mark which one binds, and state the limit requested against it. Where the borrower is an MSME within the turnover-method threshold, add the Nayak Committee computation: working capital requirement of 25% of projected annual turnover, borrower margin of 5% of turnover and bank finance of up to 20% of turnover.

Two further sheets keep the file complete: a depreciation chart tied to the fixed-asset blocks, and an EMI schedule for any term loan held alongside the limit. Where the operating statement shows interest that the EMI schedule does not support, the discrepancy is noticed quickly.

Where Excel files go wrong

  • Hard-coded totals. The grand total is typed rather than summed, and the first change to an assumption leaves the sheet internally inconsistent.
  • Misaligned year columns. A projected year that is actually the provisional year, or a blank year left between blocks.
  • Interest circularity. Interest depends on the borrowing, which depends on the profit, which depends on the interest. A circular reference or an iterative calculation left switched on quietly produces figures that do not reconcile.
  • Balance sheet plug. A balancing figure typed into cash or reserves to make the two sides agree, which hides the real gap.
  • Ratios entered manually. Ratios typed on a summary sheet rather than calculated from the statements, so they stop matching the moment a figure changes.
  • Drawing power confused with the sanctioned limit. The limit is sanctioned; the drawing power is set against the current stock and acceptable book debts and is usually lower.
  • No version discipline. Several copies of the workbook in circulation, with the branch holding one version and the borrower another.

Checks before the file goes in

  1. The balance sheet balances in every year, with no plug figure.
  2. Reserves roll forward, and drawings or dividend are deducted.
  3. Interest and depreciation agree with the loan and asset schedules.
  4. Stock and debtor days in the projections are consistent with the trading terms in the assumptions.
  5. The MPBF sheet uses the same current assets and current liabilities as the working capital sheet.
  6. Every ratio recalculates from the statements rather than from typed values.
  7. The limit requested agrees with the MPBF or turnover-method result.

When a spreadsheet stops being the right tool

An Excel workbook works while the file is small and one person maintains it. Once a renewal arrives with fresh provisional figures, a second term loan to accommodate, or a branch request to show the pack under a different method, the workbook usually has to be rebuilt rather than updated, and each rebuild is an opportunity for the figures to drift apart.

Finxora's CMA report software takes the borrower's figures once and builds the operating statement, balance sheet analysis, comparative statement, MPBF under both methods, turnover method, fund flow, cash flow, DSCR, ratio analysis, sensitivity and break-even, depreciation chart and EMI schedule from them. The ratio set covers 20+ financial ratios, each calculated rather than entered, and the MPBF page shows both methods beside the turnover-method requirement with the excess borrowing. Historical years can be seeded from a balance sheet prepared in Finxora, and a trial balance exported from Tally as XML can be imported instead of being keyed in.

The finished pack exports as a formatted PDF for submission, or as an Excel workbook or Word document where the branch prefers to work on it. Look through a filled sample CMA report to compare the format with the branch's checklist, read the CMA report software page for the full statement list, and see the CMA pricing page for plan details.

Frequently Asked Questions

Published on February 21, 2026

Updated on July 10, 2026

Back to Blog

Need bank-ready financials? Create a CMA report or a project report with Finxora in minutes.