Detailed Project Report
Solar and Electric Air Cooler (Dual-Power)
—
Prepared on: 13 November 2026 · Prepared with Building Business DPR (buildingbusiness.in)
01 Project at a glance
- Total project cost
- ₹5.84 L
- Term loan from bank
- ₹5.25 L
- Promoter’s contribution
- ₹0.58 L
- Sales · Year 3
- ₹0.00 L
- Profit after tax · Year 3
- ₹-4.06 L
- Average DSCR
- -2.90
- 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
Make plastic-body air coolers that run on mains electricity and also on a battery charged by a small solar panel.
| Main product or service | Solar and Electric Air Cooler (Dual-Power) |
|---|---|
| Installed capacity per year (at 100%) | 10,000 units |
04 Market
- Households in small towns and villages with frequent power cuts
- Shops and small offices that want a portable cooler
- Cooler and appliance dealers
- Solar product dealers
- Sale through appliance and cooler dealers before summer
- Sale through solar product shops
- Direct sale in rural markets and fairs
05 Plant and machinery
| Item | Qty | ₹ | Total ₹ |
|---|---|---|---|
| Bench vice (× 2) | 1 | 16,000 | 16,000 |
| Cooling ducts (× 3) | 1 | 48,000 | 48,000 |
| Drilling machine, ½ inch capacity | 1 | 24,000 | 24,000 |
| High-voltage tester | 1 | 17,000 | 17,000 |
| Ammeter and voltmeter (× 2) | 1 | 4,000 | 4,000 |
| Megger (insulation tester) | 1 | 7,000 | 7,000 |
| Solar battery connectors (× 2) | 1 | 5,000 | 5,000 |
| Digital multimeter | 1 | 5,000 | 5,000 |
| Watt meter | 1 | 4,000 | 4,000 |
| Variable transformer (8 amp) | 1 | 6,000 | 6,000 |
| Dies for cooler bodies (× 3 types) | 1 | 4,00,000 | 4,00,000 |
| Finishing and cutting tools | 1 | 20,000 | 20,000 |
| Total | 5,56,000 |
Pre-filled from: MSME-DI Ranchi project profile — Electric / Solar Cooler. Prices in older reports will have gone up — enter today’s quotations.
06 Raw materials
- Solar panel, 25 W — 300 a month at ₹4,000 each = ₹12,00,000
- Battery, 36 AH (the kind used in cars) — 300 a month at ₹3,000 each = ₹9,00,000
- Fan motor — 300 a month at ₹1,500 each = ₹4,50,000
- Plastic granules — 1,800 kg a month at ₹110 per kg = ₹1,98,000
- Pump motor — 300 a month at ₹300 each = ₹90,000
- 3-core cable sets, 3 m each — 300 sets a month at ₹180 = ₹54,000
- Speed switches and pump switches — 300 a month at ₹120 = ₹36,000
- Packing boxes — 300 a month at ₹110 = ₹33,000
- Screws, nuts, washers and steel spring rod — 250 kg a month at ₹80 per kg = ₹20,000
- Wiring sets — 300 sets a month at ₹60 = ₹18,000
- Packing tape — 100 rolls a month at ₹45 = ₹4,500
07 Cost of project
| ₹ in lakh | |
|---|---|
| Plant and machinery | 5.56 |
| Contingency | 0.28 |
| Total fixed capital | 5.84 |
| Working capital margin | 0.00 |
| Total project cost | 5.84 |
08 Means of finance
| ₹ in lakh | % | |
|---|---|---|
| Promoter’s contribution | 0.58 | 10.0 |
| Term loan from bank | 5.25 | 90.0 |
| Total | 5.84 | 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.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 |
| Insurance | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 |
| Total cost of operations | 3.03 | 3.03 | 3.03 | 3.03 | 3.03 | 3.03 | 3.03 |
| Operating profit (EBITDA) | -3.03 | -3.03 | -3.03 | -3.03 | -3.03 | -3.03 | -3.03 |
| Depreciation | 0.88 | 0.74 | 0.63 | 0.54 | 0.46 | 0.39 | 0.33 |
| Preliminary expenses written off | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Interest on term loan | 0.57 | 0.49 | 0.40 | 0.31 | 0.23 | 0.14 | 0.05 |
| Interest on working capital | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Profit before tax | -4.47 | -4.26 | -4.06 | -3.88 | -3.71 | -3.55 | -3.40 |
| Income tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Profit after tax | -4.47 | -4.26 | -4.06 | -3.88 | -3.71 | -3.55 | -3.40 |
12 Cash flow
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Profit after tax | -4.47 | -4.26 | -4.06 | -3.88 | -3.71 | -3.55 | -3.40 |
| Depreciation | 0.88 | 0.74 | 0.63 | 0.54 | 0.46 | 0.39 | 0.33 |
| Cash accruals (PAT + depreciation) | -3.59 | -3.52 | -3.43 | -3.34 | -3.25 | -3.16 | -3.07 |
| Term loan repaid | 0.40 | 0.81 | 0.81 | 0.81 | 0.81 | 0.81 | 0.81 |
| Owner’s drawings | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Surplus after repayment | -4.00 | -4.33 | -4.24 | -4.15 | -4.06 | -3.97 | -3.88 |
| Cash and bank | -4.00 | -8.33 | -12.56 | -16.71 | -20.77 | -24.74 | -28.63 |
13 Projected balance sheet
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Capital (own + subsidy) | 0.58 | 0.58 | 0.58 | 0.58 | 0.58 | 0.58 | 0.58 |
| Reserves and surplus | -4.47 | -8.73 | -12.80 | -16.67 | -20.38 | -23.94 | -27.34 |
| Term loan outstanding | 4.85 | 4.04 | 3.23 | 2.43 | 1.62 | 0.81 | 0.00 |
| Working capital loan | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total liabilities | 0.96 | -4.11 | -8.98 | -13.67 | -18.18 | -22.54 | -26.76 |
| Net fixed assets | 4.96 | 4.22 | 3.59 | 3.05 | 2.59 | 2.20 | 1.87 |
| 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 | -4.00 | -8.33 | -12.56 | -16.71 | -20.77 | -24.74 | -28.63 |
| Total assets | 0.96 | -4.11 | -8.98 | -13.67 | -18.18 | -22.54 | -26.76 |
14 Ratios and break-even
| Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Debt service coverage ratio (DSCR) | -3.11 | -2.33 | -2.50 | -2.69 | -2.93 | -3.20 | -3.53 |
| Break-even (% of capacity used) | — | — | — | — | — | — | — |
| Cash break-even | — | — | — | — | — | — | — |
| Average DSCR | -2.90 |
|---|---|
| Lowest DSCR | -3.53 |
| Payback period | — |
15 Depreciation
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Depreciation | 0.88 | 0.74 | 0.63 | 0.54 | 0.46 | 0.39 | 0.33 |
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 | 5.25 | 0.57 | 0.40 | 4.85 |
| 2 | 4.85 | 0.49 | 0.81 | 4.04 |
| 3 | 4.04 | 0.40 | 0.81 | 3.23 |
| 4 | 3.23 | 0.31 | 0.81 | 2.43 |
| 5 | 2.43 | 0.23 | 0.81 | 1.62 |
| 6 | 1.62 | 0.14 | 0.81 | 0.81 |
| 7 | 0.81 | 0.05 | 0.81 | 0.00 |
17 Licences and registrations
- Udyam registration
- GST registration
- Factory licence
- Trade licence from the local body
- BIS certification where a Quality Control Order applies
- State Pollution Control Board consent where applicable
18 Government schemes that may apply
- Credit Guarantee Fund Trust for Micro and Small Enterprises (CGTMSE)
19 Sources
- MSME-DI Ranchi project profile — Electric / Solar Cooler — https://dcmsme.gov.in/ELECTRICAL%20PRODUCTS/ELECTRIC%20SOLAR%20COOLER.pdf
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.