Accepted by SBI, PNB, BOB, Canara & all nationalized banks

Project Report for Bank Loan
Complete Format + Free Generator (2026)

Everything you need to know about the bank project report format — 14 IBA-standard sections, bank-wise requirements, DSCR & CMA explained, common mistakes, and a generator that builds your report in 60 seconds.

Free watermarked preview · ₹499 for the clean bank-ready copy

5,000+
Reports Generated
14
IBA Format Sections
85%+
Approval Rate
60 sec
Generation Time

What Is a Project Report for Bank Loan?

A project report for bank loan — also called a Detailed Project Report (DPR) or bank DPR — is the primary document a business owner submits to a bank when applying for a term loan, working capital limit, or government scheme loan (MUDRA, PMEGP, Stand-Up India, etc.). It is your business's complete "case file" that proves to the bank manager that your project is technically feasible, financially viable, and capable of repaying the loan.

In India, project reports for bank loans follow the IBA (Indian Banks' Association) standard format which includes CMA (Credit Monitoring Arrangement) data, 5-year financial projections, DSCR calculation, and working capital assessment using the Tandon Method. This format is accepted by all PSU banks — SBI, PNB, Bank of Baroda, Canara Bank, Union Bank — and most private banks.

A weak or incomplete project report is the single biggest reason for bank loan rejection in India's MSME sector, according to SIDBI's MSME Pulse report. Banks receive hundreds of applications — a well-prepared project report makes your file stand out and gets processed faster.

Key terms to know:

  • DPR — Detailed Project Report (used for larger/infrastructure projects; same as project report for MSME context)
  • CMA Data — Credit Monitoring Arrangement data; standardized financial statements in IBA format
  • DSCR — Debt Service Coverage Ratio; measures whether profits can cover loan repayment (must be ≥ 1.25)
  • MPBF — Maximum Permissible Bank Finance; the ceiling for working capital loans per Tandon Method II
  • Means of Finance — How the total project cost is split between bank loan, promoter contribution, and subsidy

Why Do Banks Require a Project Report?

Banks are fiduciaries — they lend depositors' money and are legally required to assess creditworthiness before disbursing loans. A project report gives the bank's credit officer everything needed to evaluate your application under RBI's prudential norms.

Technical Feasibility
Can this business actually operate? Does the promoter have the skills, space, and equipment needed?
Financial Viability
Will the business generate enough revenue and profit? Are the projections realistic and supported by market data?
Repayment Capacity (DSCR)
Can the business repay the loan from its own cash flows? DSCR ≥ 1.25 is the RBI-guided minimum.
Collateral & Risk Assessment
What assets secure the loan? CGTMSE-covered loans still need a strong project report for guarantee approval.
Promoter's Commitment
Is the promoter putting in their own money? Banks need proof of minimum promoter contribution (10–25%).
Regulatory Compliance
Does the project meet licensing, environmental, and sectoral requirements? A good report addresses all of these.

Project Report Format for Bank Loan — 14 Standard Sections

This is the IBA-standard format accepted by all scheduled banks in India. Every section is mandatory for MSME loans above ₹5 lakh.

1
Cover Page & Executive Summary

The cover page includes the business name, applicant name, loan amount requested, scheme (MUDRA/PMEGP/etc.), and bank branch. The executive summary (1–2 pages) gives the bank manager a quick overview of the project — business concept, loan purpose, total project cost, means of finance, and expected profitability. This is the first impression; it must be crisp and accurate.

2
Promoter Profile

Full personal details of the applicant/promoter: name, age, educational qualification, work experience, technical skills, and family background. Includes KYC documents list (Aadhaar, PAN, address proof) and a declaration of no existing defaults. For manufacturing loans, relevant technical experience is highlighted. Banks assess whether the promoter has the capability to run this business.

3
Business Description

Detailed description of the business activity: what is produced or sold, how it works, production process (for manufacturing), service delivery process (for services), target customers, geographic market, and business model. For manufacturing units, include the production flowchart and key process steps.

4
Market Analysis

Evidence that there is demand for your product or service. Includes: industry overview (market size, growth rate), demand-supply analysis, target customer segments, competitor analysis, pricing strategy, and sales plan. For smaller MUDRA loans, local market demand evidence suffices. For larger PMEGP loans, district/state market data is expected.

5
Technical Feasibility

For manufacturing units: details of the production process, installed capacity (units/day or kg/day), capacity utilization plan (Year 1 typically 50–60%), energy requirements, water requirement, waste disposal, pollution control, and quality standards. For service businesses: service delivery method, infrastructure requirements, technology platform if any.

6
Project Cost Statement

Complete breakdown of the total project cost: (a) Fixed assets — land & building, plant & machinery, other equipment, furniture, vehicles, pre-operative expenses; (b) Working capital (initial) — raw material stock, semi-finished goods, debtors, cash buffer. All items must have supporting quotations. The total project cost determines the loan quantum.

7
Means of Finance

How the total project cost is funded: Term Loan (from bank), Promoter's Contribution (own money/equity — minimum 10–25%), and Subsidy (PMEGP, MYUY, NLM, etc.). The debt-equity ratio and promoter's stake are key appraisal parameters. Subsidy must be correctly modelled as either front-end or back-end depending on the scheme.

8
Machinery & Equipment List

Item-wise list of all machines, equipment, and tools to be purchased. Each item must show: description, specification, quantity, rate per unit, and total cost. Quotations from manufacturers or authorized dealers must be attached as annexures. Banks will verify that the loan amount justifies the machinery investment.

9
Raw Material & Manpower Plan

Raw material section: list of all inputs, monthly consumption quantity, rate per unit, total monthly cost, and supplier details. Working capital cycle (holding period for raw materials, WIP, finished goods). Manpower section: designation-wise staffing plan, monthly salaries, and projected headcount growth over 5 years. Both must be consistent with the production capacity and revenue projections.

10
5-Year Financial Projections (P&L, Balance Sheet, Cash Flow)

The heart of the project report. Three financial statements projected for 5 years: Profit & Loss Account (revenue, COGS, gross profit, operating expenses, EBITDA, depreciation, interest, PBT, tax, PAT), Balance Sheet (fixed assets, current assets, term loan, working capital, equity), and Cash Flow Statement (operating, investing, financing cash flows). Year 1 must be conservative; growth rates must be justifiable. All three statements must reconcile exactly.

11
CMA Data (IBA Format — 7 Statements)

CMA (Credit Monitoring Arrangement) data is required for working capital loans and term loans above ₹5L at PSU banks. The 7 statements are: (1) Operating Statement, (2) Analysis of Balance Sheet, (3) Comparative Statement of Current Assets & Liabilities, (4) MPBF Calculation (Tandon Method II), (5) Fund Flow Statement, (6) Ratio Analysis (Current Ratio, DSCR, TOL/TNW), (7) Details of Existing/Proposed Borrowings.

12
Working Capital Assessment (Tandon Method II)

Working capital loan (CC/OD limit) is calculated using the Tandon Committee's Method II: Bank finances 75% of Current Assets minus Other Current Liabilities. The MPBF (Maximum Permissible Bank Finance) ceiling cannot be exceeded by the CC limit request. Banks verify this on page 7 of the CMA data. Current Ratio ≥ 1.25 is mandatory per RBI norms.

13
Loan Repayment Schedule & DSCR

Month-wise repayment schedule showing: outstanding principal, monthly EMI, principal component, interest component, and balance at end of month. Year-wise DSCR calculation: DSCR = (PAT + Depreciation + Interest on TL) ÷ (TL Principal Repaid + TL Interest). Banks require DSCR ≥ 1.25 (service/trade) or ≥ 1.50 (manufacturing) across all projection years. A single year below 1.25 can cause rejection.

14
SWOT Analysis & Declarations

SWOT analysis (Strengths, Weaknesses, Opportunities, Threats) demonstrates the promoter's understanding of business risks. Declarations include: undertaking that information provided is true, no defaults to any scheduled bank, no government scheme subsidy already availed, and compliance with lending bank's terms. Some banks require a separate Declaration of Assets.

Bank-Wise Project Report Requirements

All major PSU banks follow the IBA CMA format but have specific internal requirements for DSCR and documentation thresholds.

BankMUDRA RequirementMSME LoanPMEGPMin DSCRKey Notes
SBIRequired for Tarun (₹5L–₹10L)Mandatory above ₹25L; CMA for WCMandatory≥ 1.25 (service/trade); ≥ 1.50 (mfg)SBI uses CRISIL-aligned appraisal; CMA in IBA format
PNBRequired for Kishor+50-point checklist; CMA mandatory ≥ ₹10LMandatory≥ 1.25; ≥ 1.50 mfgPNB 50-point MSME checklist; Tandon Method II
Bank of BarodaRequired for TarunMandatory; CGTMSE linkage commonMandatory≥ 1.25; ≥ 1.50 mfgState lead bank Gujarat + Rajasthan; RLLR-linked
Canara BankRequired for TarunMandatory; IBA CMA formatMandatory≥ 1.25State lead bank Karnataka; strong PMEGP lender
Union BankRequired for Kishor+Mandatory above ₹10LMandatory≥ 1.25Top 5 PMEGP lender; merged Andhra Bank

Requirements verified against current bank circulars. May vary by branch and credit officer. Always confirm with your specific branch.

Project Report Format by Loan Scheme

Why Banks Reject Project Reports — and How to Fix Each Issue

According to SIDBI data, over 60% of MSME loan rejections are due to problems in the project report, not the business itself. Knowing these in advance can save weeks of delay.

Issue: Revenue projections too high
Cap Year-1 growth at 30–40%; link to market evidence (district demand, footfall data, order book)
Issue: DSCR below 1.25
Extend loan tenure, increase promoter contribution, or revise revenue upward with justification
Issue: CMA figures inconsistent
Ensure P&L → Balance Sheet → Cash Flow reconcile exactly; MPBF must match loan request
Issue: Actuals mismatch ITR
Historical P&L and balance sheet must match ITR filed exactly — banks cross-verify
Issue: Missing machinery quotations
Attach original dealer quotations for each major machine/equipment item
Issue: Promoter contribution < minimum
Show ≥ 10% for MUDRA, ≥ 10–25% for PMEGP, ≥ 25% for MSME loans; include own contribution proof
Issue: Working capital overestimated
MPBF must be ≥ working capital loan request; recalculate Tandon Method II carefully

Cred by Fastlegal prevents all 7 rejection reasons automatically:

Conservative Year-1 growth rates (30–40%)
DSCR auto-calculated — flags if below 1.25
CMA data reconciles across all 7 statements
MPBF ceiling automatically checked
Promoter contribution modelled in Means of Finance
All three financial statements reconcile exactly

Doing It Yourself vs. Using Cred

FactorDIY (Excel + Word)Hire CA/ConsultantCred by Fastlegal
Time to prepare3–7 days5–15 days (waiting for CA)Under 60 seconds
CostFree (your time)₹3,000–₹15,000Free preview
DSCR calculationError-prone in ExcelAccurateAuto-calculated, error-free
CMA data (IBA format)Difficult to format correctlyAccurateAuto-generated, IBA-standard
Editable after downloadYesSometimes (extra charge)Yes — unlimited edits
Bank acceptanceIf formatted correctlyHighSame IBA format all banks use
Scheme-specific variantsManual adjustment neededCA knows the formats8+ schemes pre-configured
Error checkManualCA reviewsAuto-validation (MPBF, DSCR, reconciliation)

How to Make a Project Report for Bank Loan — Step by Step

Using Cred by Fastlegal, you can generate a complete bank project report in under 60 seconds.

1
Register (30 seconds, free)

Create your account at cred.fastlegal.in — no credit card required. Google Sign-In available. You can generate and preview your report immediately.

2
Select your loan scheme

Choose from MUDRA (Shishu/Kishor/Tarun), PMEGP, PM Vishwakarma, MYUY, Stand-Up India, CGTMSE, or a general MSME bank loan. Each scheme generates a report in the correct format for that scheme.

3
Enter business and financial details

Fill in: business name, type, industry, location, loan amount, project cost breakdown (machinery, building, working capital), revenue assumptions, and applicant details. No financial knowledge required — the tool guides you through each field.

4
Your complete report is prepared (under 60 seconds)

All 14 sections are prepared for you: executive summary, business description, market analysis, project cost, financial projections (5-year P&L, balance sheet, cash flow), CMA data in IBA format, MPBF calculation (Tandon Method II), repayment schedule, DSCR, and SWOT analysis.

5
Review and edit any section

Open any tab — Business Description, Financials, CMA Data, SWOT — and edit the drafted content. All financial calculations update automatically when you change assumptions. The Financials tab shows DSCR for each year.

6
Download and submit

Download as Word (.docx) for easy editing before bank submission, PDF for email/upload, or Excel for the CMA data sheet. Submit to your bank branch with supporting documents (KYC, quotations, ITR).

Free watermarked preview · ₹499 for the clean bank-ready copy

Project Report for Business Loan — Is It Different?

"Project report for business loan" and "project report for bank loan" describe the same document — the format above works for both. What changes is who reads it. A public sector bank appraising a subsidised scheme loan weighs different sections than an NBFC pricing an unsecured business loan. Emphasise the right ones and approval gets materially faster.

Public Sector Bank

SBI, PNB, BOB, Canara, Union

Focus: Scheme compliance & DSCR
  • •Cost of project and means of finance must tally to the rupee
  • •Year-wise DSCR ≥ 1.25 (service) or 1.50 (manufacturing)
  • •CMA data mandatory above ₹5 lakh working capital
  • •Machinery quotations and Udyam certificate attached

Private Bank

HDFC, ICICI, Axis, Kotak

Focus: Banking turnover & repayment history
  • •12-month bank statement analysis carries more weight
  • •Revenue projections must reconcile to actual credits
  • •GST returns cross-checked against projected sales
  • •Shorter report accepted, but financials must be tight

NBFC / Fintech

Unsecured business loan

Focus: Cash flow & existing obligations
  • •Monthly cash flow statement matters more than 5-year P&L
  • •Existing EMI obligations must be disclosed fully
  • •Collateral section usually not required
  • •Faster sanction, higher rate — 16–24% p.a. typical
Applying under a subsidy scheme?A subsidy loan project report needs two extra things a plain business loan report doesn't: the margin money or subsidy shown explicitly in means of finance, and a repayment schedule computed on the full bank finance — not net of subsidy. See the PMEGP subsidy & EMI calculator for how that works in practice.

Project Report by Industry & Business Type

Frequently Asked Questions — Project Report for Bank Loan

What is a project report for bank loan?↓

A project report for bank loan (also called Detailed Project Report or DPR) is a formal document submitted to a bank when applying for a business loan. It describes your business plan, project cost, technical feasibility, market analysis, 5-year financial projections, CMA data, and loan repayment capacity. Banks use it to assess whether your business can repay the loan. It is the single most important document in any MSME, MUDRA, PMEGP, or MSME loan application.

What is the standard format of a project report for bank loan in India?↓

The standard format follows the IBA (Indian Banks' Association) structure: (1) Cover Page & Executive Summary, (2) Promoter Profile, (3) Business Description, (4) Market Analysis, (5) Technical Plan, (6) Project Cost Statement, (7) Means of Finance, (8) Machinery & Equipment, (9) Raw Material & Manpower Plan, (10) 5-Year P&L, Balance Sheet, Cash Flow Projections, (11) CMA Data (IBA format), (12) Working Capital (Tandon Method II), (13) Loan Repayment Schedule + DSCR, (14) SWOT Analysis & Declarations. This format is accepted by SBI, PNB, BOB, Canara Bank, and all nationalized banks.

Is a project report mandatory for bank loan?↓

Yes, for most business loans above ₹2 lakh. MUDRA Shishu (up to ₹50,000): a simple business plan suffices. MUDRA Kishor (₹50K–₹5L): project report strongly recommended. MUDRA Tarun (₹5L–₹10L): project report with CMA data is mandatory. PMEGP: project report is mandatory for all loans. MSME term loans above ₹25L: detailed project report with financials and CMA data is compulsory. Banks reserve the right to reject incomplete applications.

How long should a project report for bank loan be?↓

A standard bank project report for loans up to ₹25 lakh is typically 15–25 pages. For PMEGP (up to ₹50L) and MSME loans above ₹25L, a 25–40 page report is common. For large term loans (₹1Cr+), a comprehensive DPR of 40–80 pages may be needed with detailed technical annexures. Quality and accuracy of financial projections matter more than page count.

What is CMA data in a project report?↓

CMA (Credit Monitoring Arrangement) data is the standardized financial statement format prescribed by the Indian Banks' Association (IBA) for credit appraisal. It includes: Operating Statement (P&L in IBA format), Analysis of Balance Sheet, Comparative Statement of Current Assets and Liabilities, MPBF Calculation (Tandon Method II), Fund Flow Statement, Ratio Analysis (Current Ratio, DSCR, TOL/TNW), and Fixed Asset Schedule. CMA data is required for working capital (CC/OD) limits and term loans above ₹5 lakh at most PSU banks.

What is DSCR in a project report?↓

DSCR (Debt Service Coverage Ratio) = Net Operating Income ÷ Annual Loan Repayment (principal + interest). It measures whether your business can repay the loan from profits. Example: if annual net income is ₹3.6L and EMI is ₹2.4L, DSCR = 1.50. Banks require DSCR ≥ 1.25 for service/trading businesses and DSCR ≥ 1.50 for manufacturing. A DSCR below 1.0 means the business cannot repay the loan from operations — automatic rejection.

Why do banks reject project reports?↓

Top rejection reasons: (1) Revenue projections are unrealistically high (40%+ annual growth without market evidence). (2) DSCR below 1.25 — business cannot repay from projected profits. (3) CMA data inconsistencies — figures don't match across statements. (4) Historical financials (ITR) don't match the project report's claimed actuals. (5) MPBF calculation errors — loan amount exceeds the MPBF ceiling. (6) Missing sections — machinery quotations absent, manpower plan vague. (7) Promoter contribution below minimum (10–25% of project cost).

How much does a project report for bank loan cost?↓

A CA or consultant charges ₹3,000–₹15,000 for a project report depending on loan amount and complexity. Large DPRs (₹1Cr+) cost ₹15,000–₹50,000. With Cred by Fastlegal you preview the report free (watermarked), then pay ₹499 once for the clean PDF + Word + Excel — up to 60× cheaper than a CA. Subscription plans start at ₹999/month for multiple reports.

Can I write my own project report for bank loan?↓

Yes. You are not legally required to hire a CA to prepare a project report (though a CA can certify the financials for larger loans). Use Cred by Fastlegal: fill in your business details and the report is prepared with all 14 sections, correct DSCR/CMA calculations, and bank-standard formatting. Download as Word, PDF, or Excel. Review and edit any section. Thousands of Indian entrepreneurs have used this to get loans approved without hiring consultants.

What is the difference between a project report and a business plan?↓

A project report for bank loan focuses on financial viability and loan repayment capacity — it follows the IBA CMA format. A business plan is a broader strategic document focused on business model, market, and growth strategy for investors. For Indian bank loans, you need a project report (DPR), not a business plan. The two have significant overlap in sections like executive summary, market analysis, and financial projections, but the bank project report has additional sections like CMA data, MPBF, Tandon working capital, and repayment schedule with DSCR.

What is the difference between DPR and project report for bank loan?↓

DPR (Detailed Project Report) and project report for bank loan mean the same thing in the Indian MSME context. DPR typically refers to a more comprehensive document (common for infrastructure and large projects) while 'project report' is used for smaller MSME, MUDRA, and PMEGP loans. Both include business plan, project cost, financial projections, and CMA data. The terms are used interchangeably by bank managers and DIC offices.

How long does it take to make a project report for bank loan?↓

Traditional method (doing it yourself in Excel + Word): 3–7 days. Hiring a CA or consultant: 5–15 days. Using Cred by Fastlegal: under 60 seconds for initial generation; 20–30 minutes to review and customize. Every calculation (DSCR, CMA, MPBF, depreciation, repayment schedule) is done automatically from your inputs.

Related Guides

This is what you will generate — free

This is exactly what you get

A complete 14-section project report — the same document your bank officer will read. Every table below is real: the repayment schedule, the DSCR, the CMA workings, the balance sheet. Generate yours free, then pay ₹499 for the clean copy.

Project cost
₹10,00,000
Term loan sought
₹8,00,000
Promoter's margin
₹2,00,000 (20%)
Average DSCR
5.87 (norm ≥ 1.25)
Break-even
62% of Year-1 sales
Employment
3 existing + 3 new

Project Report

Sharma Electronics & Repair Services

Consumer electronics repair, servicing & spare-parts retail

Vaishali Nagar, Jaipur, Rajasthan

SchemeMUDRA Tarun
Loan applied for₹8,00,000
Total project cost₹10,00,000
ConstitutionSole Proprietorship

Submitted to the Branch Manager · Punjab National Bank, Vaishali Nagar, Jaipur

01

Executive Summary

Name of the unit
Sharma Electronics & Repair Services
Constitution
Sole Proprietorship
Promoter
Suresh Sharma (34 years)
Address of unit
Shop No. 12, Ground Floor, Vaishali Nagar, Jaipur — 302021
Nature of activity
Consumer electronics repair, servicing & spare-parts retail
NIC code
9521 — Repair of consumer electronics
Scheme applied under
Pradhan Mantri MUDRA Yojana — Tarun
Total project cost
₹10,00,000
Term loan requested
₹8,00,000 (80%)
Promoter's contribution
₹2,00,000 (20%)
Repayment
60 monthly instalments @ 10.50% p.a.

The unit has been in operation since 2019 and currently services 20–25 jobs a day from a 350 sq.ft. ground-floor shop, with a recorded customer base of 600+ households in the Vaishali Nagar catchment. The promoter proposes to expand the workbench capacity, add board-level diagnostic equipment and carry a spare-parts inventory so that 70% of repairs can be completed same-day instead of the present 3-day turnaround.

The project is assessed at a cost of ₹10.00 lakh, financed by a ₹8.00 lakh MUDRA Tarun term loan and ₹2.00 lakh of promoter's own contribution (20%). At the projected turnover the unit services its debt 5.87 times over on average, against the 1.25 minimum, and breaks even at 62% of Year-1 sales — leaving substantial cushion against a demand shortfall.

Recommendation: the proposal is technically feasible, commercially viable and financially sound. It is recommended for sanction of a term loan of ₹8.00 lakh repayable in 60 monthly instalments.

05

Project Cost

Cost of the project
ParticularsBasisAmount (₹)
Renovation & civil work200 sq.ft. additional area, electrical, ESD flooring1,20,000
Diagnostic & repair equipmentAs per quotations — Annexure IX2,40,000
Computers, software & service tools2 systems, billing software, tool kits80,000
Furniture, air-conditioning & display fixturesCounter, racks, 1.5 T AC60,000
Margin money for working capitalStock, receivables & operating cash5,00,000
Total project cost10,00,000

A 5% contingency is built into the civil and equipment estimates. All capital items are supported by three quotations each.

06

Means of Finance

Means of finance
SourceAmount (₹)% of project cost
Promoter's own contribution2,00,00020.00%
Term loan under MUDRA Tarun8,00,00080.00%
Subsidy / margin money grantNil—
Total10,00,000100.00%

Promoter's contribution is held in Savings A/c No. XXXXXX4417 with Punjab National Bank, Vaishali Nagar (statement enclosed). Debt–equity at inception is 4.00 : 1, improving to 1.65 : 1 by the end of Year 1.

For PMEGP, PMFME, NABARD and state-subsidy proposals this section additionally carries the margin-money subsidy workings, the subsidy-adjusted repayment and a second DSCR computed net of subsidy.

07

Machinery & Equipment

Plant, machinery and equipment proposed
EquipmentQtyRate (₹)Amount (₹)
BGA rework station with preheater195,00095,000
Digital storage oscilloscope with probes145,00045,000
Universal IC programmer135,00035,000
Ultrasonic PCB cleaning unit122,00022,000
Soldering / desoldering stations38,00024,000
Precision tool kits & ESD workbench29,50019,000
Total2,40,000

Suppliers: Fine Tools India (Jaipur), Sagar Electronics (Delhi), Techno Instruments (Jaipur). Quotations enclosed at Annexure IX. Delivery within 30 days of sanction; installation by the supplier at no extra cost.

09

Profitability Projections (5 Years)

Projected profit & loss account (₹ in lakh)
ParticularsYear 1Year 2Year 3Year 4Year 5
Service & repair income24.0028.3232.5736.8041.22
Sale of spares & accessories9.6011.3313.0314.7316.49
Total revenue33.6039.6545.6051.5357.71
Cost of spares & materials (45%)15.1217.8420.5223.1925.97
Gross profit18.4821.8125.0828.3431.74
Salaries & wages6.727.267.848.479.14
Rent1.441.511.591.671.75
Power & fuel0.720.780.830.890.95
Repairs & maintenance0.300.330.360.390.42
Marketing & business promotion0.360.400.440.480.52
Administrative & miscellaneous0.600.660.720.780.84
Insurance0.120.130.140.150.16
Total operating expenses10.2611.0711.9212.8313.78
EBITDA8.2210.7413.1615.5117.96
Depreciation (WDV, as per IT Act)0.860.660.520.420.35
EBIT7.3610.0812.6415.0917.61
Interest on term loan0.780.640.480.310.11
Profit before tax6.589.4412.1614.7817.50
Income tax (as applicable)0.300.620.951.351.80
Profit after tax6.288.8211.2113.4315.70

Revenue grows 18%, 15%, 13% and 12% over the five years, against 22% achieved by the unit in the last audited year. Capacity utilisation moves from 72% to 91%; the projections do not assume any increase in service rates.

10

Repayment Schedule & DSCR

Loan amount
₹8,00,000
Rate of interest
10.50% p.a. (reducing balance)
Tenure
60 months
Moratorium
Nil
Equated monthly instalment
₹17,195
Total interest over the tenure
₹2,31,707
Year-wise repayment schedule (₹)
YearOpening balancePrincipal repaidInterestTotal outgoClosing balance
18,00,0001,28,40477,9372,06,3416,71,596
26,71,5961,42,55563,7872,06,3415,29,041
35,29,0411,58,26548,0772,06,3413,70,776
43,70,7761,75,70630,6352,06,3411,95,070
51,95,0701,95,07011,2722,06,341Nil
Total8,00,0002,31,70710,31,705
Debt service coverage ratio (₹ in lakh)
ParticularsYear 1Year 2Year 3Year 4Year 5
Profit after tax6.288.8211.2113.4315.70
Add: depreciation0.860.660.520.420.35
Add: interest on term loan0.780.640.480.310.11
Cash available for debt service (A)7.9210.1212.2114.1616.16
Principal repayment1.281.431.581.761.95
Interest0.780.640.480.310.11
Total debt service (B)2.062.072.062.072.06
DSCR (A ÷ B)3.844.895.936.847.84

Average DSCR over the tenure: 5.87. The minimum acceptable to banks is 1.25; the unit crosses that threshold even if Year-1 revenue falls 60% short of projection.

11

Balance Sheet & Cash Flow Projections

Projected balance sheet (₹ in lakh)
ParticularsYear 1Year 2Year 3Year 4Year 5
LIABILITIES
Capital account (net of drawings)4.087.5012.1117.7424.44
Term loan — long-term portion5.293.711.95——
Term loan — current maturity1.431.581.761.95—
Sundry creditors (30 days)1.261.491.711.932.16
Other current liabilities & provisions0.300.350.400.450.50
Total12.3614.6317.9322.0727.10
ASSETS
Net fixed assets4.143.482.962.542.19
Stock of spares (45 days)1.862.202.532.863.20
Sundry debtors (10 days)0.921.091.251.411.58
Cash & bank balance5.447.8611.1915.2620.13
Total12.3614.6317.9322.0727.10
Cash flow statement — Year 1 (₹ in lakh)
SourcesAmountApplicationsAmount
Profit after tax6.28Capital expenditure5.00
Depreciation0.86Increase in stock1.86
Increase in creditors & provisions1.56Increase in debtors0.92
Term loan drawn8.00Repayment of term loan1.28
Promoter's capital introduced2.00Drawings4.20
Closing cash & bank5.44
Total18.70Total18.70
12

CMA Data & Working Capital Assessment

Working capital is assessed under the Tandon Committee Method II, the basis used by banks for limits up to ₹5 crore. The workings below are drawn from the Year-1 projections above.

Maximum permissible bank finance (₹ in lakh)
ParticularsAmount
Stock of spares1.86
Sundry debtors0.92
Cash & bank balance5.44
Total current assets (TCA)8.22
Sundry creditors1.26
Other current liabilities & provisions0.30
Current maturity of term loan1.43
Other current liabilities (OCL)2.99
Working capital gap (TCA − OCL)5.23
25% of TCA — stipulated margin2.06
Maximum permissible bank finance (Method II)3.18

No cash-credit limit is sought in this proposal; the assessment is presented because bank officers ask for it. Were the limit of ₹3.18 lakh availed, the current ratio would stand at 1.33 — above the 1.25 stipulated by IBA.

CMA statements included in the full report

  • Form I — particulars of existing and proposed limits
  • Form II — operating statement (actuals and projections)
  • Form III — analysis of the balance sheet
  • Form IV — comparative statement of current assets and current liabilities
  • Form V — computation of maximum permissible bank finance
  • Form VI — fund flow statement
  • Ratio analysis and holding-period statement
13

Key Ratios, Break-Even & SWOT

Key financial indicators
RatioYear 1Year 2Year 3Year 4Year 5Bank norm
Current ratio2.753.263.874.519.36≥ 1.25
Debt–equity ratio1.650.710.310.11Nil≤ 3.00
DSCR3.844.895.936.847.84≥ 1.25
Net profit margin18.7%22.2%24.6%26.1%27.2%—
Interest coverage9.415.826.348.7160.1≥ 2.00
Break-even analysis — Year 1 (₹ in lakh)
ParticularsAmount
Fixed costs (salaries, rent, admin, depreciation, interest)10.88
Variable costs (materials, power, maintenance)16.14
Contribution (revenue − variable costs)17.46
P/V ratio51.96%
Break-even sales20.94
Break-even as % of Year-1 revenue62.3%
Cash break-even as % of Year-1 revenue57.4%

Strengths

  • Nine years of promoter experience in the same line of activity; the unit is already running and profitable.
  • Only board-level repair capability in a 3 km catchment of 12,000 households.
  • 85% repeat customers — revenue is recurring rather than one-off.
  • Low fixed-cost base; the shop is rented at ₹12,000 a month with no owned-premises burden.

Weaknesses

  • Technical dependence on the proprietor for complex board-level work.
  • Informal book-keeping to date; a computerised billing and stock system is part of this project.
  • Brand recognition limited to the immediate locality.

Opportunities

  • Right to Repair framework improving access to genuine spares for independent repairers.
  • About 3,000 new households entering the catchment within 1 km.
  • Institutional tie-ups — schools, clinics and offices for annual maintenance contracts.

Threats

  • An authorised brand service centre opening within the catchment.
  • Import-duty-led increases in spare-parts prices.
  • Attrition of trained technicians to larger service chains.
Sample report · figures are illustrative · your report is built from your own business details

Free to generate · ₹499 for the clean PDF + Word + Excel · 30-day money-back guarantee

Generate Your Bank Project Report — Free

Complete IBA format · CMA data · DSCR · 5-year projections · Working capital

Accepted by SBI, PNB, BOB, Canara Bank, Union Bank & all nationalized banks

Free preview · ₹499 for the clean copy · 30-day refund