Detailed Project Report
RCC Spun (Hume) Pipes
—
Prepared on: 13 November 2026 · Prepared with Building Business DPR (buildingbusiness.in)
01 Project at a glance
- Total project cost
- ₹26.72 L
- Term loan from bank
- ₹17.37 L
- Promoter’s contribution
- ₹2.67 L
- Subsidy
- ₹6.68 L
- Sales · Year 3
- ₹0.00 L
- Profit after tax · Year 3
- ₹-7.78 L
- Average DSCR
- -1.03
- Break-even (% of capacity used)
- —
02 Promoter and unit
| Promoter name | — |
|---|---|
| Business / firm name | — |
| Legal form | Proprietorship |
| Address of the unit | — |
| Applicant category | General · Rural |
03 The project
Spin concrete around a steel cage in a rotating mould to make drainage, sewer, culvert and irrigation pipes.
| Main product or service | RCC Spun (Hume) Pipes |
|---|---|
| Installed capacity per year (at 100%) | 10,000 units |
04 Market
- Public Health Engineering and Public Works departments
- Irrigation, agriculture and forest departments
- National Highways and municipal corporations
- Panchayats and approved civil contractors
- Supply to contractors executing government works
- Government tenders
- Private builders and farms
05 Plant and machinery
| Item | Qty | ₹ | Total ₹ |
|---|---|---|---|
| Pipe moulding machine, 2 m length, with 10 HP motor | 1 | 3,00,000 | 3,00,000 |
| Gauge (cage) winding machine (× 2) | 1 | 1,10,000 | 1,10,000 |
| Concrete mixer | 1 | 1,10,000 | 1,10,000 |
| Collar winding drum with stand (× 2) | 1 | 75,000 | 75,000 |
| Pipe moulds 100–600 mm dia, 2 m, with accessories (× 40) | 1 | 8,00,000 | 8,00,000 |
| Collar moulds with end rings (× 40) | 1 | 5,50,000 | 5,50,000 |
| Gantry with pull-push trolley | 1 | 3,00,000 | 3,00,000 |
| Testing equipment (× 1 lot) | 1 | 1,00,000 | 1,00,000 |
| Electrification and installation (× 1 lot) | 1 | 2,00,000 | 2,00,000 |
| Total | 25,45,000 |
Pre-filled from: KVIC Project Profile — RCC Spun Pipe (PMEGP); PMEGP sample project report — RCC Spun Pipe (prepared by Udyami/Samadhan). Prices in older reports will have gone up — enter today’s quotations.
06 Raw materials
- Cement — the reports print the cement : stone metal : sand proportion as 1:2:5:2:5
- Coarse and fine aggregate, sand — bought locally
- Mild steel and HT rods and bars for cages — cage design as per IS 458
- All raw material together — ₹30.00 L a year in the KVIC PMEGP profile; ₹90.00 L in year 1 of the Samadhan report
07 Cost of project
| ₹ in lakh | |
|---|---|
| Plant and machinery | 25.45 |
| Contingency | 1.27 |
| Total fixed capital | 26.72 |
| Working capital margin | 0.00 |
| Total project cost | 26.72 |
08 Means of finance
| ₹ in lakh | % | |
|---|---|---|
| Promoter’s contribution | 2.67 | 10.0 |
| Subsidy | 6.68 | 25.0 |
| Term loan from bank | 17.37 | 65.0 |
| Total | 26.72 | 100.0 |
| Working capital loan (outside project cost) | 0.00 |
09 Key assumptions
| Selling price | ₹0 per units |
|---|---|
| Raw material & packing cost | ₹0 per units |
| Capacity used each year | 60% · 70% · 80% · 80% · 80% · 80% · 80% |
| Term loan interest rate (% a year) | 11% · 84 months (Moratorium 6) |
| Working capital method | Turnover method (RBI) · Working capital interest (% a year) 11% |
| Income tax rate | 25% |
| Yearly price and cost rise | 0% |
10 Production and sales
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Capacity used | 60% | 70% | 80% | 80% | 80% | 80% | 80% |
| Production (units) | 6,000 | 7,000 | 8,000 | 8,000 | 8,000 | 8,000 | 8,000 |
| Sales | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
11 Projected profitability
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Sales | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Raw material and packing | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Power and fuel | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Salaries and wages | 2.88 | 2.88 | 2.88 | 2.88 | 2.88 | 2.88 | 2.88 |
| Rent | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Administration | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Selling and distribution | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Repairs and maintenance | 0.53 | 0.53 | 0.53 | 0.53 | 0.53 | 0.53 | 0.53 |
| Insurance | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 |
| Total cost of operations | 3.55 | 3.55 | 3.55 | 3.55 | 3.55 | 3.55 | 3.55 |
| Operating profit (EBITDA) | -3.55 | -3.55 | -3.55 | -3.55 | -3.55 | -3.55 | -3.55 |
| Depreciation | 4.01 | 3.41 | 2.90 | 2.46 | 2.09 | 1.78 | 1.51 |
| Preliminary expenses written off | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Interest on term loan | 1.88 | 1.63 | 1.34 | 1.04 | 0.75 | 0.45 | 0.16 |
| Interest on working capital | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Profit before tax | -9.44 | -8.58 | -7.78 | -7.05 | -6.39 | -5.78 | -5.22 |
| Income tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Profit after tax | -9.44 | -8.58 | -7.78 | -7.05 | -6.39 | -5.78 | -5.22 |
12 Cash flow
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Profit after tax | -9.44 | -8.58 | -7.78 | -7.05 | -6.39 | -5.78 | -5.22 |
| Depreciation | 4.01 | 3.41 | 2.90 | 2.46 | 2.09 | 1.78 | 1.51 |
| Cash accruals (PAT + depreciation) | -5.43 | -5.18 | -4.88 | -4.59 | -4.30 | -4.00 | -3.71 |
| Term loan repaid | 1.34 | 2.67 | 2.67 | 2.67 | 2.67 | 2.67 | 2.67 |
| Owner’s drawings | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Surplus after repayment | -6.76 | -7.85 | -7.56 | -7.26 | -6.97 | -6.67 | -6.38 |
| Cash and bank | -6.76 | -14.61 | -22.17 | -29.43 | -36.40 | -43.07 | -49.45 |
13 Projected balance sheet
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Capital (own + subsidy) | 9.35 | 9.35 | 9.35 | 9.35 | 9.35 | 9.35 | 9.35 |
| Reserves and surplus | -9.44 | -18.02 | -25.80 | -32.85 | -39.24 | -45.02 | -50.24 |
| Term loan outstanding | 16.03 | 13.36 | 10.69 | 8.02 | 5.34 | 2.67 | 0.00 |
| Working capital loan | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total liabilities | 15.95 | 4.69 | -5.76 | -15.48 | -24.54 | -32.99 | -40.88 |
| Net fixed assets | 22.71 | 19.31 | 16.41 | 13.95 | 11.86 | 10.08 | 8.57 |
| Preliminary expenses not written off | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Current assets (stock and debtors) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Cash and bank | -6.76 | -14.61 | -22.17 | -29.43 | -36.40 | -43.07 | -49.45 |
| Total assets | 15.95 | 4.69 | -5.76 | -15.48 | -24.54 | -32.99 | -40.88 |
14 Ratios and break-even
| Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Debt service coverage ratio (DSCR) | -1.10 | -0.82 | -0.89 | -0.96 | -1.04 | -1.14 | -1.25 |
| Break-even (% of capacity used) | — | — | — | — | — | — | — |
| Cash break-even | — | — | — | — | — | — | — |
| Average DSCR | -1.03 |
|---|---|
| Lowest DSCR | -1.25 |
| Payback period | — |
15 Depreciation
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Depreciation | 4.01 | 3.41 | 2.90 | 2.46 | 2.09 | 1.78 | 1.51 |
Written-down value method at Income-tax Rules block rates (building 10%, plant & machinery 15%, furniture 10%, computers 40%). Change them if your CA uses other rates.
16 Term loan repayment
| Year | Opening | Interest | Term loan repaid | Closing |
|---|---|---|---|---|
| 1 | 17.37 | 1.88 | 1.34 | 16.03 |
| 2 | 16.03 | 1.63 | 2.67 | 13.36 |
| 3 | 13.36 | 1.34 | 2.67 | 10.69 |
| 4 | 10.69 | 1.04 | 2.67 | 8.02 |
| 5 | 8.02 | 0.75 | 2.67 | 5.34 |
| 6 | 5.34 | 0.45 | 2.67 | 2.67 |
| 7 | 2.67 | 0.16 | 2.67 | 0.00 |
17 Licences and registrations
- Udyam
- GST
- BIS ISI mark to IS 458 — expected by government departments buying pipes
- Pollution control board consent (dust from mixing)
- Registration as a vendor with PWD, Jal Nigam or municipal bodies
18 Government schemes that may apply
- Prime Minister's Employment Generation Programme (PMEGP)
- Pradhan Mantri MUDRA Yojana (PMMY) – Shishu, Kishor, Tarun, Tarun Plus
- Credit Guarantee Fund Trust for Micro and Small Enterprises (CGTMSE)
19 Sources
- KVIC Project Profile — RCC Spun Pipe (PMEGP) — https://pmegp.msme.gov.in/Home/DownloadDocument?fileName=Documents/ProjectSampleReport/RCC_SPUN_PIPE_%28_MINERAL_BASED_INDUSTRY_%29.pdf
- PMEGP sample project report — RCC Spun Pipe (prepared by Udyami/Samadhan) — https://pmegp.msme.gov.in/Home/DownloadDocument?fileName=Documents/ProjectSampleReport/RCC_Spun_Pipe_%28_Samadhan_Projects_%29.pdf
- KVIC Project Profile — R.C.C. Spun Pipe (Gramodyog Rojgar Yojana / PMEGP) — https://pmegp.msme.gov.in/Home/DownloadDocument?fileName=Documents/ProjectSampleReport/R.C.C_%28_MINERAL_BASED_INDUSTRY_%29.pdf
- DGFT — ITC(HS) classification of export and import items — https://www.dgft.gov.in/CP/?opt=itchs-import-export
This report is a projection from the figures entered by the promoter. It is not a bank appraisal or a guarantee of a loan or subsidy. Check every figure with current quotations and your chartered accountant before submitting it.