BizFinTax

CMA Data Generator

Enter your latest audited Balance Sheet & P&L (T-format). We auto-project the forward years and build a clean, formula-driven CMA pack (Form I–VI) in Excel.

1. Start from your audited statements (optional)

Upload a PDF / image / Excel of last year's Balance Sheet and P&L. We'll transcribe the figures into the form below for you to review.

AI extraction is not configured on the server — enter figures manually below.

2. Particulars of the unit

Firm / Unit name *Proprietor / PartnerAddressConstitutionAudited year (e.g. FY 2025-26)Working Capital Limit requested

₹

Term Loan requested

₹

3. Profit & Loss — audited year

Sales

Domestic / Local Sales

₹

Export Sales

₹

Other Operating Income

₹

Less: GST & Taxes

₹

Cost of Sales

Purchases — Imported

₹

Purchases — Indigenous

₹

Freight / Power & Fuel

₹

Direct Labour / Wages

₹

Other Variable Expenses

₹

Depreciation

₹

Opening Stock (FG)

₹

Closing Stock (FG)

₹

Expenses, Interest & Tax

Selling, General & Admin. Exp.

₹

Interest on Working Capital

₹

Interest on Term / Other Loans

₹

Non-operating Income

₹

Non-operating Expense

₹

Provision for Taxes

₹

4. Balance Sheet — audited year (closing)

Balanced ✓

Current Liabilities

Bank CC/OD — Applicant Bank

₹

Bank CC/OD — Other Banks

₹

Short-term Borrowings (Others)

₹

Sundry Creditors (Trade)

₹

Advances from Customers

₹

Statutory Liabilities

₹

Other Current Liabilities

₹

Term Liabilities & Net Worth

Term Loans from Banks

₹

Deferred Payment Credits

₹

Other / Unsecured Loans

₹

Capital Account

₹

Less: Drawings

₹

Surplus / Reserves in P&L

₹

Current Assets

Cash & Bank Balances

₹

Short-term Investments

₹

Fixed Deposits with Banks

₹

Receivables — Domestic

₹

Receivables — Export

₹

Inventory — Finished Goods

₹

Consumable Stores & Spares

₹

Advances to Suppliers

₹

Advance Tax / TDS

₹

Other Current Assets

₹

Fixed & Other Assets

Block 1 — Gross Block (e.g. Plant & Machinery)

₹

Block 1 — Depreciation to Date

₹

Block 1 — WDV Rate (leave blank to auto-detect)

Block 2 — Gross Block (e.g. Furniture / Building)

₹

Block 2 — Depreciation to Date

₹

Block 2 — WDV Rate (leave blank if no 2nd block)

Other Non-current Assets

₹

Intangible Assets

₹

5. Projection assumptions

Leave the rest to us — creditor / debtor / stock holding and purchase ratios are inferred from your audited year.

Projection yearsSales growth % p.a.Expense growth % p.a.Tax rate %

Unlock both formats with one payment — Excel carries live formulas; the PDF is a print-ready Form I–VI pack with identical figures.