Detailed Project Report
Community-Based Village Tourism
—
Prepared on: 13 November 2026 · Prepared with Building Business DPR (buildingbusiness.in)
01 Project at a glance
- Total project cost
- ₹15.75 L
- Term loan from bank
- ₹14.18 L
- Promoter’s contribution
- ₹1.58 L
- Sales · Year 3
- ₹0.00 L
- Profit after tax · Year 3
- ₹-6.07 L
- Average DSCR
- -1.16
- 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
A village group runs homestays, guided walks, cultural shows and farm visits for tourists, and keeps the income in the village.
| Main product or service | Community-Based Village Tourism |
|---|---|
| Installed capacity per year (at 100%) | 10,000 units |
04 Market
- Domestic weekend and holiday travellers
- Foreign tourists seeking village life
- Schools, colleges and research groups
- Wellness travellers
- Own website and social media
- Responsible travel agencies and tour operators
- Tourism board listings and travel marts
- CSR and educational partnerships
05 Plant and machinery
| Item | Qty | ₹ | Total ₹ |
|---|---|---|---|
| Solar water heaters (× 10) | 1 | 3,50,000 | 3,50,000 |
| Eco-friendly waste management system | 1 | 2,00,000 | 2,00,000 |
| Trekking and outdoor equipment | 1 | 3,00,000 | 3,00,000 |
| Cultural performance equipment | 1 | 1,50,000 | 1,50,000 |
| Communication equipment | 1 | 2,00,000 | 2,00,000 |
| Homestay furniture and bedding (× 10) | 1 | 1,50,000 | 1,50,000 |
| Community kitchen equipment | 1 | 1,00,000 | 1,00,000 |
| Visitor centre furnishings | 1 | 50,000 | 50,000 |
| Total | 15,00,000 |
Pre-filled from: Uttarakhand DUY project profile — Sustainable Agriculture Community-Based Tourism Initiatives. Prices in older reports will have gone up — enter today’s quotations.
06 Raw materials
- Food supplies for guest meals — local produce sourced in the village
- Traditional furniture and décor — the profile advises buying from local artisans
07 Cost of project
| ₹ in lakh | |
|---|---|
| Plant and machinery | 15.00 |
| Contingency | 0.75 |
| Total fixed capital | 15.75 |
| Working capital margin | 0.00 |
| Total project cost | 15.75 |
08 Means of finance
| ₹ in lakh | % | |
|---|---|---|
| Promoter’s contribution | 1.58 | 10.0 |
| Term loan from bank | 14.18 | 90.0 |
| Total | 15.75 | 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.32 | 0.32 | 0.32 | 0.32 | 0.32 | 0.32 | 0.32 |
| Insurance | 0.08 | 0.08 | 0.08 | 0.08 | 0.08 | 0.08 | 0.08 |
| Total cost of operations | 3.27 | 3.27 | 3.27 | 3.27 | 3.27 | 3.27 | 3.27 |
| Operating profit (EBITDA) | -3.27 | -3.27 | -3.27 | -3.27 | -3.27 | -3.27 | -3.27 |
| Depreciation | 2.36 | 2.01 | 1.71 | 1.45 | 1.23 | 1.05 | 0.89 |
| Preliminary expenses written off | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Interest on term loan | 1.53 | 1.33 | 1.09 | 0.85 | 0.61 | 0.37 | 0.13 |
| Interest on working capital | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Profit before tax | -7.17 | -6.61 | -6.07 | -5.57 | -5.12 | -4.69 | -4.29 |
| Income tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Profit after tax | -7.17 | -6.61 | -6.07 | -5.57 | -5.12 | -4.69 | -4.29 |
12 Cash flow
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Profit after tax | -7.17 | -6.61 | -6.07 | -5.57 | -5.12 | -4.69 | -4.29 |
| Depreciation | 2.36 | 2.01 | 1.71 | 1.45 | 1.23 | 1.05 | 0.89 |
| Cash accruals (PAT + depreciation) | -4.81 | -4.60 | -4.36 | -4.12 | -3.88 | -3.64 | -3.40 |
| Term loan repaid | 1.09 | 2.18 | 2.18 | 2.18 | 2.18 | 2.18 | 2.18 |
| Owner’s drawings | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Surplus after repayment | -5.90 | -6.78 | -6.54 | -6.30 | -6.06 | -5.82 | -5.58 |
| Cash and bank | -5.90 | -12.68 | -19.23 | -25.53 | -31.59 | -37.42 | -43.00 |
13 Projected balance sheet
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Capital (own + subsidy) | 1.58 | 1.58 | 1.58 | 1.58 | 1.58 | 1.58 | 1.58 |
| Reserves and surplus | -7.17 | -13.78 | -19.85 | -25.43 | -30.54 | -35.23 | -39.53 |
| Term loan outstanding | 13.08 | 10.90 | 8.72 | 6.54 | 4.36 | 2.18 | 0.00 |
| Working capital loan | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total liabilities | 7.49 | -1.30 | -9.55 | -17.31 | -24.61 | -31.48 | -37.95 |
| Net fixed assets | 13.39 | 11.38 | 9.67 | 8.22 | 6.99 | 5.94 | 5.05 |
| 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 | -5.90 | -12.68 | -19.23 | -25.53 | -31.59 | -37.42 | -43.00 |
| Total assets | 7.49 | -1.30 | -9.55 | -17.31 | -24.61 | -31.48 | -37.95 |
14 Ratios and break-even
| Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Debt service coverage ratio (DSCR) | -1.25 | -0.93 | -1.00 | -1.08 | -1.17 | -1.28 | -1.42 |
| Break-even (% of capacity used) | — | — | — | — | — | — | — |
| Cash break-even | — | — | — | — | — | — | — |
| Average DSCR | -1.16 |
|---|---|
| Lowest DSCR | -1.42 |
| Payback period | — |
15 Depreciation
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Depreciation | 2.36 | 2.01 | 1.71 | 1.45 | 1.23 | 1.05 | 0.89 |
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 | 14.18 | 1.53 | 1.09 | 13.08 |
| 2 | 13.08 | 1.33 | 2.18 | 10.90 |
| 3 | 10.90 | 1.09 | 2.18 | 8.72 |
| 4 | 8.72 | 0.85 | 2.18 | 6.54 |
| 5 | 6.54 | 0.61 | 2.18 | 4.36 |
| 6 | 4.36 | 0.37 | 2.18 | 2.18 |
| 7 | 2.18 | 0.13 | 2.18 | 0.00 |
17 Licences and registrations
- Homestay registration with Uttarakhand Tourism Development Board
- FSSAI basic registration (food service)
- Gram Panchayat NOC
- Tourism Department registration
- GST (above the turnover threshold)
- Adventure activity permits and Forest Department permission where needed
18 Government schemes that may apply
- Pradhan Mantri MUDRA Yojana (PMMY) – Shishu, Kishor, Tarun, Tarun Plus
- Credit Guarantee Fund Trust for Micro and Small Enterprises (CGTMSE)
- Stand-Up India
19 Sources
- Uttarakhand DUY project profile — Sustainable Agriculture Community-Based Tourism Initiatives — https://duy-heduk.org/downloads/project-profiles/community_based_tourism.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.