Finxora Logo
Sign In
CMA Data for Working Capital Loan: Stepwise Guide
Back to Blog

CMA Data for Working Capital Loan: Stepwise Guide

FINXORA
6 min read
CMA data
working capital loan
financial planning
loan application
business finance

Prepare CMA data for a cash credit or overdraft limit step by step, with MPBF Method I and II, the turnover method, and the ratios banks check.

CMA Data for a Working Capital Loan

A working capital loan is rarely a single term loan. In practice it is a cash credit or overdraft limit that the bank reviews every year, and the document that drives that review is the CMA data. CMA stands for Credit Monitoring Arrangement: the set of operating statements, balance sheet analyses, fund flow, cash flow and ratio tables that an Indian bank uses to fix and renew a working capital limit. This guide walks through preparing that pack for a cash credit or overdraft proposal, with particular attention to the three working capital tests that decide the limit: MPBF Method I, MPBF Method II and the turnover method.

What the Bank Looks For

A working capital limit is assessed on the operating cycle, not on a project. The relationship manager wants to know how much stock and receivables the business carries, how long they take to convert to cash, and how much of that gap the bank should finance. The CMA data answers those questions through the comparative statement of current assets and current liabilities, the working capital computation and the maximum permissible bank finance. Because the limit is reviewed annually, the same file is updated each year with fresh provisional and projected figures rather than rebuilt from nothing.

Step 1: Collect the Source Documents

Start with the documents that anchor every figure in the pack:

  • Audited balance sheets and profit and loss accounts for the last three financial years.
  • The current year's provisional balance sheet and profit and loss account.
  • Bank statements for all operating accounts for the last twelve months.
  • Income tax returns and GST returns for the same period.
  • Stock statements and book debts statements already submitted to the bank, if any.
  • Details of existing limits, interest rates, repayment terms and collateral.

These inputs feed both the historical years and the projections. If the balance sheet has already been prepared in Finxora, the audited and provisional years can seed the CMA report directly instead of being keyed twice.

Step 2: Enter the Historical and Provisional Years

Key the audited years first, then the provisional current year. The operating statement carries sales, direct and indirect costs, interest, tax and net profit for each year; the balance sheet analysis carries capital, reserves, borrowings and current assets and liabilities. Keep the same accounting treatment across years so the trend reads cleanly. Where a year is unaudited, label it provisional and note the basis in the assumptions.

Step 3: Set the Projection Assumptions

Projections for a working capital file usually run one to three years ahead. Set them from realistic drivers rather than from a single growth percentage:

  • Sales growth by product or customer group, supported by order book or market data.
  • Gross margin and the direct cost ratio, checked against the last three years.
  • The working capital cycle: inventory holding period, receivables collection period and payables payment period.
  • Existing term loan repayments and any planned capital expenditure.

In Finxora the Generate with AI option can estimate starting assumptions from the firm and industry, which you then adjust. Every assumption should be written down in the assumptions section of the report, because the credit team will test them.

Step 4: Compute the Working Capital and MPBF

This is the section that fixes the limit. The comparative statement of current assets and current liabilities shows the working capital gap, and the MPBF computation converts that gap into the amount the bank may finance. Finxora computes the first method and the second method side by side from the same balance sheet.

MethodComputationWhat the margin applies to
Method I (Tandon)75% of (current assets minus current liabilities other than bank borrowings)25% of the working capital gap, i.e. the borrower's margin on the gap
Method II (Tandon)75% of current assets, minus current liabilities other than bank borrowings25% of total current assets

Method I ties the limit to the working capital gap, so a business with a small gap gets a small limit. Method II ties it to total current assets, which usually produces a higher figure. The bank takes the lower of the two, so you need both in the file and you need to be able to explain which one binds. Alongside them, the Nayak Committee turnover method uses projected annual turnover: total working-capital requirement is 25 percent of turnover, the borrower contributes 5 percent as margin, and bank finance is 20 percent of turnover. The bank's current requirements and policy still govern the assessment, with excess borrowing and margins on working capital shown next to it. Seeing all three together lets you defend the assessed limit rather than guess at it.

Step 5: Review Ratios and Fund Flow

The ratio analysis should cover liquidity, profitability, leverage, activity, expense and growth ratios, measured against bank benchmarks. For a working capital proposal the credit team pays closest attention to the current ratio, the quick ratio, stock and receivables turnover, and the debt equity and total outside liabilities to net worth ratios. The fund flow statement then shows sources and uses of long-term funds across the reporting years, which is where a term loan repayment or a capital expenditure shows up. Change any input and both the ratios and the fund flow recalculate, so the pack stays internally consistent.

Step 6: Download and Submit

Export the CMA report as a formatted PDF for submission, or as an Excel workbook or Word document where the credit team wants to work the numbers further. You choose which statements go into each download, so a renewal file and a first application can carry different annexures. Keep the assumptions, the MPBF working and the ratio tables in the file even when the bank only asked for the summary, because the questions always arrive later.

Common Mistakes to Avoid

  • Projecting sales growth without linking it to the working capital cycle, so stock and receivables never move with sales.
  • Using the same margin percentage for every year instead of letting it follow the balance sheet.
  • Presenting only Method I or only Method II, which leaves the credit officer to compute the other.
  • Ignoring the turnover method when the bank's sanction letter specifically asks for it.
  • Letting historical and projected figures use different accounting treatments, which breaks the trend analysis.

How Finxora Helps

Finxora prepares the complete CMA data pack from one set of inputs: operating statement, balance sheet analysis, comparative statement of current assets and current liabilities, MPBF under both methods, fund flow and cash flow statements, turnover method computation, ratio analysis, sensitivity and break even analysis, depreciation and EMI schedules. Saved figures stay linked across years and projections link across statements, so a change in sales growth flows through to the balance sheet, the fund flow and the MPBF without retyping. For a working capital renewal the master stays saved and only the provisional and projected years are updated. See the CMA report software page, the sample reports and CMA pricing for details.

Frequently Asked Questions

Frequently Asked Questions

Published on February 24, 2026

Updated on July 22, 2026

Back to Blog

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