Finxora Logo
Sign In
Bank of Baroda CMA Excel Format: Download Checklist
Back to Blog

Bank of Baroda CMA Excel Format: Download Checklist

FINXORA
6 min read
Bank of Baroda
CMA data
Excel
Loan application
Finance

Looking for a Bank of Baroda CMA Excel download? Learn how to verify the template, prepare linked financial schedules and check your working capital data.

Before downloading a CMA Excel format

A search for a Bank of Baroda CMA data Excel format often produces spreadsheets with little information about their origin, version or intended borrower. Before entering financial details, confirm whether the file is the format required for your proposal. A familiar bank name in the filename does not establish that the bank issued or currently accepts the workbook.

CMA means Credit Monitoring Arrangement. The financial pack helps a lender examine historical performance, estimated results, projections and the working capital request. This article provides a preparation and download checklist. It does not offer an authenticated Bank of Baroda workbook or promise that a third-party download is suitable for every branch and loan product.

Obtain the applicable requirements

Ask the relationship manager for the current document checklist and any prescribed spreadsheet. State whether you are applying for a new limit, renewal, enhancement or takeover. Tell the bank whether the proposal includes a term loan, cash credit, overdraft or other facilities, because the supporting schedules may differ.

Confirm the required financial years, unit of presentation and submission format. Some files need signed statements and an editable workbook; others need additional annexures or explanatory notes. Ask how provisional figures should be identified. Record the guidance received so the person preparing the workbook and the person submitting it follow the same scope.

  • Verify the source and version of the template.
  • Check that financial year columns can represent the requested periods.
  • Identify protected cells, formulas and required input fields.
  • Avoid enabling macros or external links merely to view a template.
  • Keep an unchanged copy and work in a separate borrower file.

Understand the core CMA schedules

Most CMA preparation centres on a connected operating statement, balance sheet analysis, comparison of current assets and current liabilities, working capital assessment, fund flow and financial ratios. The exact headings and annexures should follow the bank's instructions. Begin with borrower particulars and facility details so the financial request is clear.

SectionContentEvidence to retain
Borrower and facilitiesBusiness details and existing or proposed limitsApplication and sanction records
Historical performanceSales, costs, profits and financial positionSigned accounts and schedules
ProjectionsFuture operating results and balancesAssumptions and operating evidence
Working capitalStock, collections, supplier funding and marginHolding-level calculations
Ratios and fund flowFinancial movement and appraisal measuresLinked calculation workings

A useful template exposes its logic. You should be able to trace projected receivables to sales and collection assumptions, stock to the relevant cost base, and interest to borrowing. If a downloaded workbook hides these relationships or contains unexplained plugs, rebuild or verify the relevant schedules before relying on it.

Prepare the source records

Gather signed accounts, detailed debt schedules, current provisional accounts and information on stock and receivables. Reconcile facility balances to lender records at the relevant date. Separate operating creditors from bank borrowing and disclose related-party balances clearly. Changes in classification between years need an explanation rather than silent regrouping.

Check the year status carefully. An estimate for an unfinished year is different from provisional accounts for a completed year, and both differ from audited statements. Label each column accordingly. If actual figures cover only part of a year, explain how the remaining months were forecast and whether seasonality affects that estimate.

Build projections that reflect the business

Forecast turnover from order visibility, capacity and expected pricing. A sales increase may require additional purchasing, labour, freight and customer credit. Link those costs and balances instead of increasing sales while holding all other inputs unchanged. Explain the reason for material margin improvements or reductions in collection days.

Use holding periods consistently. Receivable days should relate to the stated sales base, inventory days to the stated cost base, and creditor days to relevant purchases. Identify the day-count convention. Slow-moving stock, disputed receivables and unusually long customer terms deserve separate attention because they may not support borrowing on the same basis as ordinary operating assets.

Prepare a seasonal cash schedule where annual closing balances do not describe the peak requirement. A business may purchase stock months before collecting sale proceeds. The funding gap should be demonstrated with the timing of payments and receipts, not justified only by a higher projected turnover figure.

Check the finance calculation

Where the lender asks for Tandon Committee MPBF calculations, other current liabilities mean current liabilities excluding bank borrowings. MPBF Method I = 75% x (Total Current Assets - Other Current Liabilities). This method assumes borrower margin of 25% of the working capital gap.

Method II = 75% x Total Current Assets - Other Current Liabilities. The borrower margin here is 25% of total current assets. For current assets of 80 lakh rupees and other current liabilities of 16 lakh rupees, Method I gives 48 lakh rupees and Method II gives 44 lakh rupees. This is an arithmetic example, not a Bank of Baroda sanction indication.

The turnover method uses a different basis: working capital requirement is 25% of projected annual turnover, borrower margin is 5% of turnover and bank finance is up to 20% of turnover. Confirm whether the method applies to your MSME proposal. Do not present every method as a mandatory calculation for every applicant.

Review ratios and submission quality

Review liquidity, profitability, leverage and interest coverage across the reporting years. Explain trends, including declining net worth, persistent losses, stretched receivables or dependence on short-term funds. A current ratio should follow the classifications used in the accompanying balance sheet. Avoid treating an unsourced ratio benchmark as the bank's universal acceptance rule.

Check that capital movement reflects profit, drawings, dividends or introduced funds as applicable. Reconcile fixed assets to additions, disposals and depreciation. Trace term loan closing balances to repayments. Ensure the balance sheet balances without an unexplained adjustment. A neat spreadsheet cannot compensate for inconsistent financial statements.

Choose a preparation route

If the bank provides a workbook, preserve its required structure and complete the supporting workings. If you use another format, map its schedules to the requested checklist before submission. Finxora's CMA report software produces operating statements, balance sheet analysis, MPBF, fund flow and ratios, with Excel, PDF and Word exports.

Use the samples library to inspect report presentation and the CMA pricing page for current plan details. A sample report is a presentation reference, not proof of bank endorsement. Keep the source records, assumptions and final lender checklist with the submitted version so later queries can be answered from the same figures.

Frequently Asked Questions

Published on February 21, 2026

Updated on May 03, 2026

Back to Blog

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