CMA Report Format for a Term Loan
A term loan proposal is appraised differently from a working capital limit. The bank is not checking an operating cycle; it is checking whether the project can generate enough cash to repay a fixed EMI over a fixed tenure. The CMA data still follows the standard Credit Monitoring Arrangement format, but the weight shifts to the projected profit and loss account, the debt service coverage ratio, the EMI schedule and the security cover. This guide sets out the format and the sections a term loan file needs.
What a Term Loan CMA Must Show
Banks appraise a term loan on repayment capacity. The credit team wants to see the project cost, the means of finance, the projected operating statement and balance sheet, the cash flow available for debt service, the EMI schedule and the DSCR for every year of the tenure. Ratio analysis and sensitivity analysis support the conclusion but do not replace the debt service working. The CMA report therefore carries the same statements as a working capital file, with the emphasis moved to the DSCR and repayment schedule.
Section 1: Basic Information and Company Profile
Open with the borrower's identity and context:
- Legal name, constitution, PAN, GST and Udyam details.
- Nature of business and industry overview.
- Promoters and directors with experience.
- Existing banking arrangements and limits.
Section 2: Past Performance
Present audited financial statements for the last three to five years: balance sheet, profit and loss account and cash flow statement. Calculate liquidity, solvency, profitability and efficiency ratios and show the trend. Explain any sharp movement rather than leaving the credit officer to guess. For an expansion proposal, split the historical performance of the existing unit from the projected performance of the new capacity.
Section 3: Projected Operating Statement
Build the projected profit and loss account for the tenure of the loan, usually five to seven years. Sales, direct costs, gross profit, indirect expenses, EBDIT, interest, depreciation, tax and net profit should each appear for every projected year. The interest line must reflect the proposed term loan and any existing borrowings. Depreciation should follow the method and rates the business actually uses. Net profit then feeds the balance sheet, the cash flow and the DSCR.
Section 4: Projected Balance Sheet
Carry the projected profit into the balance sheet so that assets, liabilities and net worth agree with the operating statement. Term loan balances reduce as principal is repaid, and the fixed assets grow with the project cost. Closing balances carry forward into the next year's opening balances, which keeps depreciation, reserves and loan balances consistent across the whole tenure.
Section 5: DSCR and Debt Service
DSCR is the number the sanction committee reads first. It is calculated as receipts divided by repayments, where receipts are net profit plus depreciation plus term loan interest, and repayments are principal plus interest. Finxora computes DSCR for every projected year and shows an average DSCR row beside the yearly figures. A comfortable DSCR depends on the bank and the sector, but the file must show the working rather than only the conclusion. Support it with a sensitivity case where sales or margins fall and show that the DSCR still covers the repayment.
Section 6: EMI Repayment Schedule
The EMI schedule must be month wise, with opening balance, EMI, principal, interest and closing balance for each loan. If the term loan has a moratorium, the schedule should show the moratorium period and the stepped repayment that follows. Multiple term loans each carry their own schedule. The schedule ties back to the DSCR and to the interest line in the operating statement, so all three must agree.
Section 7: Security Cover
Security cover is the ratio of the value of the collateral to the outstanding loan. The file should state the primary security, usually the plant and machinery or the building financed, and any collateral security such as land, property or personal guarantees. Give the current market value or the valuer's estimate, the margin the bank applies and the resulting security cover. Reassess the cover at the end of the moratorium and at the end of the tenure, because the outstanding balance falls while the asset value may not.
Section 8: Working Capital Assessment
Even a pure term loan proposal usually carries a working capital component, or at least a working capital requirement for the expanded unit. Include the turnover method and MPBF computation so the bank can see the drawing power and the margin on working capital alongside the term loan. This avoids a second round of questions after sanction.
Section 9: Ratio Analysis and Sensitivity
Present liquidity, profitability, leverage and solvency ratios with their formulas, plus break even sales value and margin of safety. Add a sensitivity analysis that changes sales, raw material cost or interest rate and shows the effect on DSCR and break even. The point is to show that the proposal survives a bad year, not only the base case.
Section 10: Assumptions and Supporting Documents
Document every assumption: sales growth, margins, capacity utilisation, raw material prices, interest rate, tenure, moratorium and depreciation rates. Attach the project report, quotations for plant and machinery, land and building estimates, sanction letters for any subsidy, and the valuer's report for security. Clear assumptions are what let the credit team approve without a further visit.
How Finxora Helps
Finxora builds the project cost, means of finance, projected statements, EMI repayment schedule, DSCR, ratio analysis, break even, turnover method and MPBF from one set of inputs, so the numbers agree from the summary through to the schedules. The project master can be tagged as Mudra, PMEGP, Normal MSME or a custom scheme type. Export the finished report as PDF, Word or Excel and choose the sections to include. See the project report software page, sample reports and project report pricing.
