Finxora Logo
Sign In
Kotak Mahindra Bank CMA Data Excel Format Guide
Back to Blog

Kotak Mahindra Bank CMA Data Excel Format Guide

FINXORA
6 min read
Kotak Mahindra Bank
CMA
Excel
Data Analysis
Financial Reporting

Prepare CMA data for a Kotak Mahindra Bank proposal with linked Excel schedules, supported assumptions and a checklist for the lender's requirements.

Start with the checklist for your Kotak proposal

If you are preparing a working capital proposal for Kotak Mahindra Bank, CMA data should connect the requested borrowing to the business's financial records and operating cycle. CMA means Credit Monitoring Arrangement. The pack normally brings together historical results, current estimates and projections so the lender can assess liquidity, leverage and repayment capacity.

A spreadsheet described online as a Kotak CMA format should not automatically be treated as an official bank document. Obtain the applicable checklist and any prescribed workbook from the relationship manager or credit team. Requirements can vary by borrower, facility and appraisal route. This guide explains how to organise a financial pack; it does not reproduce or authenticate a Kotak-issued template.

Confirm the scope before entering data

Clarify whether the request concerns a new cash credit limit, an enhancement, a takeover or renewal. Identify every existing facility and whether the proposed package includes term borrowing or non-fund-based exposure. A combined proposal needs consistent debt details across schedules even when individual facilities are assessed separately.

Ask which financial years are required, whether provisional figures are acceptable and what assumptions note should accompany the projections. Confirm the unit of presentation and the treatment of related-party balances. Resolve these questions before mapping the accounts into a workbook, because changing classifications later can affect several ratios and assessment schedules.

  • Record the borrower's legal name, constitution, business activity and operating locations.
  • List existing sanctioned limits, outstanding amounts and proposed changes.
  • Identify audited, provisional and projected periods individually.
  • Note the source of every major historical figure.
  • Keep the bank's requested annexures beside the preparation checklist.

Arrange the Excel workbook for credit appraisal

Use separate schedules for inputs, operating performance, balance sheet analysis, current assets and current liabilities, working capital assessment, fund flow and financial ratios. Add loan repayment and cash flow schedules where required. Keep year headings identical so the reader can compare one period across the entire pack.

ScheduleInformation to includeCross-check
Operating statementSales, direct costs, overheads, interest and profitHistorical profit agrees with accounts
Balance sheet analysisCapital, borrowings, assets and liabilitiesSources equal uses
Working capitalStock, receivables and operating creditorsHolding levels support the balances
AssessmentApplicable finance calculation and marginBank borrowing is excluded from other current liabilities
Ratios and fund flowFinancial measures and movement of fundsResults link back to statements

Separate data-entry cells from formula cells. Avoid copying last year's closing figures into every projected year. Capital changes, debt repayments, depreciation and retained earnings must move according to the underlying assumptions. A balance sheet that balances only because cash is forced to a convenient number needs further investigation.

Reconcile historical performance

Begin with the signed financial statements and supporting schedules. Map ledger classifications into the CMA structure without changing the underlying result. Keep a reconciliation for regroupings, such as separately presenting current maturities of debt or identifying receivables from connected parties. Consistent classification allows meaningful comparison across years.

Compare sales with relevant supporting returns and explain material timing or classification differences. Reconcile borrowings with lender statements at the reporting date. Where accounts are provisional, disclose the cut-off date and outstanding adjustments. Do not label management estimates as audited results or use a prior year's audit status for a later period.

Explain sales and working capital assumptions

Support projected sales with capacity, existing orders, pricing and market evidence appropriate to the business. A distributor may need SKU-level purchasing and inventory assumptions; a service business may need staff capacity, billing milestones and collection estimates. Apply cost assumptions that reflect the proposed volume instead of carrying forward a flat profit percentage without explanation.

Receivable days should reflect the customer credit policy and actual collections. Inventory days should reflect procurement lead times, minimum order quantities and slow-moving stock. Creditor days should reflect supplier terms. State the denominator used for each holding-level calculation so the bank can reproduce it.

Explain any increase in stock or receivable days and show how the additional requirement will be funded. If the proposal assumes faster collections, include a practical basis such as changed customer terms. Merely shortening the spreadsheet cycle to reduce borrowing does not demonstrate that cash will arrive earlier.

Show assessment methods without confusing margins

Where the lender requests Tandon Committee MPBF calculations, define other current liabilities as current liabilities excluding bank borrowings. Use the bank's accepted asset and liability classifications. The method applicable to the proposal is a lender decision, rather than an option selected solely because it gives a larger result.

MPBF Method I = 75% x (Total Current Assets - Other Current Liabilities). Borrower margin is 25% of the working capital gap. Method II = 75% x Total Current Assets - Other Current Liabilities. Borrower margin is 25% of total current assets. Explain this distinction in the assessment note.

For example, total current assets of 120 lakh rupees and other current liabilities of 30 lakh rupees give Method I finance of 67.5 lakh rupees and Method II finance of 60 lakh rupees. These figures illustrate the formulas only. They are not a statement of Kotak lending policy or an indication of what any borrower will receive.

If the turnover method is applicable, show its separate basis: working capital requirement of 25% of projected annual turnover, borrower margin of 5% of turnover and bank finance up to 20% of turnover. Confirm its use with the credit team rather than mixing it with the MPBF schedules.

Review ratios and facility utilisation

Calculate the current ratio, debt-equity measures, TOL/TNW, margins and interest coverage using stated definitions. Explain material changes across years and avoid presenting a general benchmark as a confirmed Kotak sanction criterion. The appraisal depends on more than a single ratio.

Separate assessed requirement, sanctioned facility and drawing power. Drawing power follows sanction terms and eligible periodic stock or receivable statements. A CMA projection cannot substitute for those statements. Include seasonal utilisation patterns if a year-end balance understates the business's peak cash requirement.

Prepare a complete submission

  1. Check that all year columns and units match.
  2. Reconcile every historical schedule to its source.
  3. Confirm that profit, depreciation, interest and repayments remain linked.
  4. Test lower sales and slower collections to understand cash pressure.
  5. Attach assumptions, requested supporting documents and explanations for exceptions.
  6. Compare the final export with the current bank checklist.

Finxora's CMA report software prepares linked CMA statements, MPBF calculations and 20+ financial ratios, with Excel, PDF and Word exports. Compare the report samples with your lender's requested schedules. Using reporting software supports preparation; it does not establish bank endorsement or replace the lender's credit assessment.

Frequently Asked Questions

Published on February 21, 2026

Updated on March 03, 2026

Back to Blog

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