Confirm the branch requirements before building the workbook
A business searching for a Canara Bank cash credit CMA Excel sheet usually needs a structured financial pack for a new limit, renewal or enhancement. CMA means Credit Monitoring Arrangement. Its purpose is to connect financial performance, the operating cycle and the proposed borrowing requirement. A workbook is valuable when its figures can be traced to records and its projections explain how the business will use and repay working capital.
This article describes a preparation structure, not an official Canara Bank template or a promise of acceptance. Ask the relationship manager for the current checklist, required year columns, statement layout and assessment method. Requirements can differ by borrower, facility and appraisal route. Preserve any branch-supplied format and map your financial workings into it rather than assuming a generic download satisfies every request.
Collect the source records
Keep historical financial statements, current provisional accounts, existing sanction terms and recent borrowing balances together. Add stock records, receivable and payable ageing, sales details and explanations of unusual transactions. Mark which figures are audited, provisional or projected. Do not describe a provisional balance sheet as audited because it occupies the same column in an old spreadsheet.
- Identify the borrower, constitution, activity and financial year in every schedule.
- Use one unit, such as rupees or lakhs, and display it prominently.
- Record the source and date of every opening balance.
- Keep assumptions separate from historical data and formula cells.
For renewals, compare the previous projection with actual performance. Explain material deviations in turnover, margins, inventory and collections. A revised forecast is more credible when it starts from observed performance rather than simply extending last year's growth percentage. If records are incomplete, label the gap and resolve it before presenting a precise borrowing requirement.
Arrange the Excel sheets around the lending question
Use an input sheet for financial data and assumptions, with linked schedules for the operating statement, balance sheet, working capital assessment, fund flow and ratios. Add supporting workings for inventory, debtors and creditors. A clearly separated check sheet can flag balance sheet differences, broken links and movements that lack explanations. Avoid scattering the same input across several worksheets.
| Worksheet | Purpose |
|---|---|
| Operating statement | Explain turnover, costs, finance charges and profit |
| Balance sheet | Show capital, borrowings, assets and other liabilities |
| Holding levels | Translate the operating cycle into current assets and trade credit |
| Assessment | Show the selected method, margin and proposed bank finance |
| Checks | Reconcile statements and identify exceptions |
Year headings should distinguish completed periods from estimates. Where the current year is part complete, explain how the remaining months were forecast. A sudden jump from low provisional sales to a high annual estimate needs support from orders, seasonality or capacity, rather than an unexplained annualisation formula.
Project the operating cycle
Estimate stock from the business's actual purchasing and selling pattern. A trader may need inventory and debtors schedules; a manufacturer may need raw material, work in progress and finished goods separately. Apply holding days to the relevant cost or sales base and document the convention used. Applying every holding period to turnover can overstate or understate the requirement.
Suppose projected annual credit sales are Rs 120 lakh and the chosen convention uses 365 days. Debtors at 45 days would be approximately Rs 14.79 lakh before any necessary adjustments to the sales base. This is an illustration, not a bank-approved eligibility figure. Compare the result with customer terms and ageing, and examine overdue or disputed balances separately.
Show assessment formulas without mixing methods
For traditional MPBF workings, distinguish total current assets from other current liabilities. Other current liabilities in these formulas means current liabilities excluding bank borrowings. MPBF Method I = 75% x (Total Current Assets - Other Current Liabilities). Method II = 75% x Total Current Assets - Other Current Liabilities. These represent different margin bases and should not be combined in one unexplained formula.
With total 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. The figures illustrate the arithmetic only. The branch determines the applicable assessment, eligible components and additional conditions. A calculated amount does not establish a sanctioned limit or available drawing power.
Under the turnover method associated with Nayak Committee guidance for MSMEs, working capital requirement is 25% of projected annual turnover, borrower margin is 5% of turnover and bank finance is up to 20% of turnover. Do not apply this automatically to every borrower. Ask whether the method applies to the proposal and how the bank assesses the underlying projection.
Separate assessed finance from drawing power
The proposed limit, sanctioned limit, outstanding borrowing and drawing power answer different questions. A sanction describes the approved facility and conditions. Drawing power depends on the applicable sanction terms and eligible current assets, margins and deductions. The available borrowing may therefore be lower than the limit shown in a CMA assessment.
Keep any periodic stock statement working distinct from the annual projection. Check how unpaid stock, ageing restrictions or other exclusions are treated under the actual sanction. Do not copy exclusions or margin percentages from another borrower's workbook. If the bank requires a particular certificate or statement, the Excel model should support that requirement without claiming to replace it.
Test the workbook before submission
Change one assumption, such as collection days, and check that debtors, borrowing, interest and the balance sheet respond coherently. Review profit flows into capital or reserves, asset additions into depreciation and debt movements into finance charges. Check for formulas replaced by hard-coded amounts, external workbook links and hidden rows that alter the printed result.
Read the exported pages as a credit officer would. Totals must be visible, headings must repeat where needed and units must remain clear. Explain negative balances and unusual ratio movements. Ask an independent preparer to trace several important totals back to source documents rather than checking only that the balance sheet balances.
Use software with a clear submission boundary
Finxora's CMA report software prepares linked CMA statements, working capital computations and PDF, Excel and Word exports. These are preparation features, not evidence of a bank partnership or automatic acceptance. Review the output against the branch's requested layout and retain the underlying evidence.
Inspect sample reports before choosing a workflow, then attach a concise assumptions note to the application. A coherent workbook explains the amount requested, how it follows from the operating cycle and what changes if sales or collections fall short. The lending decision remains subject to the bank's appraisal and sanction conditions.
