Obtain the lender's instructions before building the file
CMA stands for Credit Monitoring Arrangement. For a business borrowing proposal, it brings historical and projected financial statements together with working capital assessment and ratios. The borrower or its adviser prepares the data from business records and assumptions. It should not be described as a ready-made financial dataset supplied by the bank.
If YES BANK requests CMA data, ask the relationship manager for the current checklist, year coverage and any prescribed Excel workbook. This guide explains a general preparation structure. It is not an official YES BANK template, a downloadable bank-issued file or evidence that a particular report will be accepted. Requirements can vary by facility, borrower and appraisal circumstances.
Set up a controlled workbook
Use a cover sheet showing the borrower, constitution, activity, reporting date, monetary unit and version. Identify the preparer and review status. Set consistent year columns across all sheets, marking audited, provisional and projected periods. Keep input cells distinguishable from calculations and avoid embedding unexplained assumptions inside formulas.
Create a source index linking major historical figures to approved accounts or supporting schedules. For projected figures, use a separate assumption register with values, sources and dates. Keep one approved workbook version for submission. Multiple similar files with different loan balances or turnover estimates can create unnecessary clarification requests and make later reconciliation difficult.
Organise sheets around financial relationships
| Sheet | Purpose |
|---|---|
| Inputs and assumptions | Record source figures, business drivers and financing assumptions |
| Operating statement | Project sales, costs, interest, tax and profit |
| Balance sheet | Present capital, borrowing, other liabilities and assets |
| Working capital | Analyse current assets, other current liabilities and bank finance |
| Fund flow and cash flow | Explain financial movements and cash availability |
| Loans and ratios | Support repayment, leverage, liquidity and debt service analysis |
| Checks | Flag reconciliation differences and missing inputs |
Use the bank's statement order and terminology when a prescribed workbook is provided. The structure above is a preparation aid, not a reason to replace required forms. Supporting schedules can hold detailed calculations while the submission sheets follow the requested layout.
Reconcile the historical columns
Enter the approved historical accounts before forecasting. Reconcile total assets, liabilities, capital, profit and borrowing with the source statements. Explain regroupings between accounting presentation and CMA presentation. Keep an adjustment bridge where a classification changes, so the same balance is not counted in two categories or omitted from both.
Review provisional figures with their cut-off date. A partial-year result should not be presented as audited full-year performance. Reconcile debt to lender statements, inventory to the available stock record and receivables to ageing information. Unsupported balances should remain review points rather than being treated as automatically eligible assets in a borrowing calculation.
Build projections from clear assumptions
Forecast sales using volumes, prices, capacity or service-delivery drivers appropriate to the business. Link direct costs and expenses to realistic operating assumptions. Document material departures from historical margins. If an expansion drives growth, show its investment, commissioning and staffing requirements rather than adding revenue without the resources needed to earn it.
Carry profit into capital or reserves after drawings, distributions and relevant adjustments. Link asset balances to the depreciation schedule and loans to repayment workings. Calculate cash from the cash flow instead of inserting it to make the balance sheet tally. When a funding gap appears, identify an actual source or leave the shortfall visible for discussion.
Show the operating cycle and holding levels
Estimate receivables, inventory and supplier credit from the actual business cycle. State whether holding levels use annual sales, cost of sales or purchases, and whether the balances are closing figures or averages. Keep the day basis consistent. A ratio based on the wrong denominator can produce a plausible-looking number that misstates the funding need.
For a seasonal business, add a period-wise schedule where annual closing balances do not represent the peak requirement. Separate disputed receivables, obsolete inventory and other uncertain items for review. Ask the lender how such balances affect the assessment. A mechanically calculated working capital gap is not automatically the amount eligible for bank funding.
Keep MPBF methods distinct
Maximum Permissible Bank Finance calculations use defined current-asset and liability categories. For the following formulas, Other Current Liabilities means current liabilities excluding bank borrowings. Confirm the method and appraisal adjustments with the lender instead of selecting the calculation that produces the larger amount.
- MPBF Method I = 75% x (Total Current Assets - Other Current Liabilities).
- MPBF Method II = 75% x Total Current Assets - Other Current Liabilities.
Under Method I, borrower margin is 25% of the working capital gap. Under Method II, it is 25% of total current assets. For example, with current assets of Rs 100 lakh and other current liabilities of Rs 20 lakh, Method I gives Rs 60 lakh and Method II gives Rs 55 lakh. Keep the brackets explicit in Excel to avoid applying the percentage to the wrong base.
Under the turnover method associated with Nayak Committee MSME assessment, working capital requirement is 25% of projected annual turnover, borrower margin is 5% of turnover and bank finance is up to 20% of turnover. These are assessment workings, not a sanction promise or a statement that the method applies to every YES BANK application.
Calculate ratios with visible definitions
Include the ratios requested for the appraisal, with consistent definitions and clear treatment of any adjustments. Current ratio, TOL/TNW, profitability, holding levels and debt service coverage can illuminate different aspects of the business. Do not present a universal threshold as a bank rule unless it appears in the actual instructions for the facility.
Handle zero denominators explicitly. A missing or undefined ratio should be flagged rather than displayed as a healthy result through an error-suppression formula. Explain large year-on-year movements. For debt service coverage, identify the cash-accrual components and the principal and interest obligations included, checking the weak individual periods as well as any average.
Add checks before charts
Use workbook checks for balance-sheet equality, profit carry-forward, loan closing balances, asset movements and opening-to-closing cash. Validate input types and flag missing assumptions. Check external links and broken references before sharing. Presentation charts can help explain trends, but they should come after the underlying statements reconcile.
Test a downside with slower collections, reduced sales or weaker margins. Follow its effect through working capital, borrowing use, interest, cash and repayment. Keep the scenario assumptions separate from the base case. Record the management response to a shortfall rather than hiding it with a balancing entry.
Review the actual export against the checklist
Finxora's CMA report software documents operating statements, balance-sheet analysis, MPBF, turnover-method workings, cash flow, fund flow, DSCR and 20+ financial ratios, with Excel, PDF and Word exports. This supports a general CMA preparation workflow; it does not establish a dedicated YES BANK template or endorsement.
Inspect sample reports for presentation and compare the completed workbook with the lender's current instructions. Check units, dates, formulas, disclosures and supporting documents. Preserve the approved input version and exported submission together so later queries can be answered from the exact figures the lender received.
