📊 CMA Data / Project Report Maker

Project Cost · Means of Finance · 5-Year P&L, Balance Sheet, Ratios & Term Loan Repayment · PDF export

🆓 Free Tool · v1 mini · microshots.in

Entity & Applicant Details

Name of Company / Firm / Entity

Type of Entity / Constitution

Name of Authorised Person

Designation of Authorised Person

Type of Activity

PAN / GSTIN (optional)

Brief Description of Activity / Product / Service

Project Cost (₹)

Land & Site Development

Building & Civil Works

Plant & Machinery

Electrical Installation

Furniture & Fixtures

Preliminary & Pre-operative Exp.

Contingency

Margin for Working Capital

Other Assets / Misc. Fixed Assets

TOTAL PROJECT COST : ₹ 0

Means of Finance (₹)

Own Capital / Share Capital

Reserves & Surplus (opening)

Bank Term Loan

Unsecured Loans (Directors/Partners/Others)

Other Sources

TOTAL MEANS OF FINANCE : ₹ 0

Balancing Difference : ₹ 0

Projection Start Year & Year 1 Figures

Start Year (Year 1)

Year 1 Net Sales / Turnover (₹)

Annual Sales Growth Rate (%) – Yr2 to Yr5

Direct / Raw Material Cost (% of Sales)

Year 1 Employee Cost (₹)

Year 1 Administrative Expenses (₹)

Year 1 Selling & Distribution Exp. (₹)

Annual Growth – Operating Expenses (%)

Depreciation, Finance Cost & Tax

Depreciation Rate (% WDV on Building+P&M+Elec.+Furniture)

Interest Rate on Term Loan (% p.a.)

Term Loan Repayment Tenure (Years)

Moratorium Period (Years)

Income Tax Rate (%)

Working Capital Norms

Debtors Holding (Months of Sales)

Creditors Holding (Months of Direct Cost)

Stock / Inventory Holding (Months of Direct Cost)

Assumptions used to keep this a "mini" model: Gross Block of depreciable assets stays constant (no fresh capex assumed in Yr2–5); 100% of profit is retained as reserves (no dividend/drawings); Unsecured Loans remain constant; Cash & Bank balance is derived as the balancing figure of the projected Balance Sheet.