- Home
- Skills
- Business & Operations
- CMA Data for Bank Loans (Forms I–VI, MPBF, DSCR)
More screenshots
Works with the AI Agents you already use
CMA Data for Bank Loans (Forms I–VI, MPBF, DSCR)
Prepare lender-ready CMA data for an Indian bank or NBFC loan: Forms I–VI, MPBF / drawing power for working capital, term loan DSCR, ratios, sensitivities and a lender note.
$5
CMA Data for Bank Loans (Forms I–VI, MPBF, DSCR)
Example session with this skill installed
Prepare CMA data for a ₹35 crore term loan plus a cash credit limit. Attached: FY25 and FY26 audited financials and our 5-year projection model. We report under Ind AS with large office leases.
- Read your context and instructions
- Compiled the cma data
Excel workbook with Inputs, Forms I–VI tied to audited figures, MPBF (second method, current ratio 1.33 check), term loan schedule with moratorium, DSCR by year (average and minimum), ratios, sensitivities (revenue −10%, margin −2 pts, rate +1%), Ind AS 116 reversal and reconciliation; plus a lender note and open points.
Connects securely to your tools. The creator never sees your data.
About this skill
You prepare CMA data the way a credit analyst at an Indian bank will read it: consistent across all six forms, tied to audited numbers for past years, with projections that a sceptical appraiser cannot break in the first meeting.
- Years: two audited years (minimum), current-year estimate, and projections for the loan tenor (usually 5–7 years for a term loan, 2 years for pure working capital).
- Every past-year figure must tie to the audited balance sheet and P&L. Show the tie-out.
- Presentation basis: banks appraise on an IGAAP-style view. For Ind AS reporters with heavy leases, reverse Ind AS 116 (rent back into expenses, ROU and lease liability out) and give a one-page reconciliation to the reported Ind AS numbers. Say which basis every table is on.
- Classify consistently: current liabilities exclude bank borrowings for working capital when computing MPBF; current maturities of long-term debt sit in current liabilities.
- Never plug. If the balance sheet does not balance, find the error.
Ask for: audited financial statements, trial balance or ERP export for the current year, the projection model (or assumptions: revenue drivers, margins, capex, holding periods), existing and proposed facilities (lender, type, limit, rate, tenor, repayment, security), and promoter contribution. List what is missing.
| Form | Content | Checks |
|---|---|---|
| I | Particulars of existing and proposed limits | Ties to sanction letters |
| II | Operating statement (sales, cost of sales, operating profit, interest, PBT, tax, PAT) | Ties to audited P&L |
| III | Analysis of balance sheet (liabilities and assets, with current / non-current split) | Balances every year |
| IV | Comparative statement of current assets and current liabilities, with holding levels (raw material, WIP, finished goods in months of consumption or cost of sales; receivables in months of sales; creditors in months of purchases) | Holding levels reasonable vs history and industry |
| V | Computation of MPBF | See below |
| VI | Funds flow (long-term sources and uses, working capital changes) | Long-term sources should fund long-term uses |
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Business & Operations.
Uses common Indian bank appraisal norms; each lender's own policy (DSCR floors, turnover method caps) prevails. Projections are only as good as the inputs.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 23 days ago
Permissions
No special permissions declared or detected