Client & ITR figures
Enter the figures from the client's latest filed ITR (Part A-P&L and Part A-BS of ITR-3 / ITR-5 / ITR-6). Add the previous year's ITR too if available, because most banks want two years of actuals in the CMA.
ITR figures (₹ in )
Sales net of GST. Leave a field at 0 if not applicable.Business growth & loan assumptions
Set the expected business growth for the provisional (current) year and each projected year. Cost ratios and holding days default to what the ITR shows; type a value to override, clear it to go back to the ITR figure.
Sales growth per year
Banks usually accept 10–20% growth when it is backed by order book, capacity or past trend. Above 25% a year needs a written justification.
Cost structure & working capital cycle
Tax, depreciation & owner funds
Cash credit (working capital) proposal
Project / term loan proposal
Provisional & projected financial statements
Audited figures come straight from the ITR. The provisional year is the current financial year; projected years follow your growth assumptions. Cash is the balancing figure.
Projected Balance Sheet
Projected Profit & Loss Account
Term loan repayment schedule
CMA data report
Credit Monitoring Arrangement in the standard bank format, Forms I to VI plus ratio and DSCR sheets. Copy any form straight into Excel, or download the full workbook.
Will this client get the loan?
A pre-screen against the norms Indian banks commonly apply. Fill in the credit profile, then read the verdict and the fixes for any weak point before you approach a lender.
Credit profile
Checks
Limit assessment (first projected year)
Banks sanction the lowest of these, subject to collateral and their internal rating. Turnover method applies to MSME limits up to ₹5 crore; above that, Method II (Tandon) or cash budget.
This tool gives an indicative pre-screen only. Each bank applies its own loan policy, internal rating model, industry exposure limits and collateral norms, and the final decision rests with the lender. Projected statements submitted to a bank should be reviewed and certified by a Chartered Accountant.