How to Use the CMA Data Tool — Complete Step-by-Step Guide

What the Tool Generates

In a single session the tool produces:

Step 1 — Select Industry Profile

The industry profile sets the default margin benchmarks, working capital day norms, and tax rate that the tool uses for projections. Choose the profile closest to your business activity.

After selecting a profile, the tool pre-fills gross margin, EBITDA margin, and working capital day defaults. You can override any default in subsequent steps.

Step 2 — Enter Firm Details

These fields appear as headers on every CMA form page:

• Business Name — exactly as per GST registration or partnership deed
• Entity Type — Proprietorship / Partnership / LLP / Private Limited / Public Limited
• Address — registered office address
• Financial Year — the base year (e.g., FY 2024–25 = April 2024 to March 2025)
• Loan Purpose — CC limit enhancement / term loan for plant & machinery / OD facility etc.
• Bank Name — the bank to which the CMA will be submitted

Step 3 — Historical Financials

Enter actual P&L and Balance Sheet figures for the last 2–3 financial years. The tool uses these as the base for trend-based projections.

P&L inputs (per year):

• Net Sales / Revenue from Operations
• Cost of Goods Sold (materials consumed or purchases ± stock)
• Manufacturing overheads (power, labour, packing, repairs)
• Administrative and selling expenses
• Interest paid on existing loans
• Depreciation charged
• Tax paid (or payable)

Balance Sheet inputs (per year):

• Fixed Assets: Gross Block and accumulated depreciation
• Current Assets: inventories, debtors, advances, cash
• Current Liabilities: creditors, statutory dues, short-term borrowings
• Term Loans: outstanding balance, repayment schedule
• Net Worth: share capital + reserves and surplus

Step 4 — Projection Parameters

Projections are the forward-looking portion that banks use for credit appraisal. The tool generates projections for up to 5 future years.

The tool automatically carries Profit After Tax (net of dividend/drawings) to Reserves & Surplus each year, ensuring the projected Balance Sheet balances without manual adjustment.

Step 5 — Working Capital Days

Working capital holding days drive the MPBF calculation. The tool converts holding days into rupee values of current assets and computes MPBF using Tandon Method 1 and Method 2.

The tool uses the formula: MPBF (Method 1) = 75% × (Current Assets − Current Liabilities excluding bank borrowings)

See our detailed guide: Working Capital Days Explained and MPBF Calculation — Tandon Method 1 vs 2.

Step 6 — Loan Configuration

This section tells the tool about your proposed and existing debt so it can build the EMI schedule and compute DSCR.

1. CC / OD Limit

   Enter the Cash Credit or Overdraft limit you are applying for (or the current sanctioned limit for renewal). This becomes the proposed CC in Form IV.

2. Proposed Term Loan

   Enter loan amount, interest rate, tenure (months), and moratorium period (months). The tool computes the EMI, builds a year-wise principal + interest schedule, and deducts repayment from DSCR each year.

3. Existing Term Loans

   Add all existing term loans with outstanding balance, remaining tenure, and interest rate. These appear in the current liabilities (current portion of TL) and reduce DSCR along with the proposed loan.

4. Subsidy / CGTMSE

   If the loan is under CGTMSE or has a capital subsidy (PMEGP, state scheme), note the subsidy amount. It reduces the net loan and improves DSCR. AGF charges (0.75–2% per annum) should be included in projected expenses.

Step 7 — Review & Export

After entering all inputs, the tool computes and displays all 6 CMA forms plus summary tables. Before exporting, check:

Once satisfied, use the Export to Excel button (Pro key required) to download a formatted workbook with all 6 forms, ratio sheet, and DSCR schedule — ready for bank submission.

Pro Key & CA Certification

The free version allows full calculation and on-screen preview. The Pro key unlocks:

• Excel Export — All CMA forms in a bank-formatted Excel workbook
• PDF Download — Printable version with firm header and page numbers
• CA Certification Service — A practicing CA reviews your CMA, signs it with UDIN, and returns the certified copy within 24 hours at ₹699

To get a Pro key: pay via Razorpay on the tool page → key is auto-generated and sent to your email. Enter the key in the tool to unlock export.

Tips for Accurate Output

1. Use figures in ₹ Lakhs consistently

   All inputs should be in the same unit (₹ Lakhs recommended). Mixing crores and lakhs is the most common data-entry error.

2. Match ITR and GST turnover

   Enter CMA turnover excluding GST (ex-GST basis). Historical revenues must reconcile with ITR Schedule BP/PL. Banks will cross-check. See GST vs CMA Turnover.

3. Depreciation must match books

   Use the same WDV/SLM method and rates as the audited accounts. Changing depreciation to inflate PAT is easily spotted by bank credit managers.

4. Keep promoter drawings realistic

   Excess drawings reduce net worth and retained profits. Banks are comfortable with drawings equal to a reasonable salary; excessive drawings signal fund diversion risk.

5. Projection growth should have a basis

   Link revenue projections to capacity utilisation, order book, or market data — especially for new term loans. Flat 20% growth year-on-year with no explanation invites bank queries.

6. Run the Balance Sheet balance check before exporting

   The tool highlights any year where Assets ≠ Liabilities + Net Worth. A non-balancing Balance Sheet is an automatic rejection trigger at the bank.

7. Save your session

   Copy or note your input values before closing the browser. The tool does not persist data between sessions — Pro users can export all inputs with the Excel file.