Detailed Project Report
City Tours and Excursions
—
Prepared on: 13 November 2026 · Prepared with Building Business DPR (buildingbusiness.in)
01 Project at a glance
- Total project cost
- ₹36.75 L
- Term loan from bank
- ₹33.08 L
- Promoter’s contribution
- ₹3.68 L
- Sales · Year 3
- ₹0.00 L
- Profit after tax · Year 3
- ₹-10.32 L
- Average DSCR
- -0.58
- 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
Guided half-day and full-day city tours, walking tours and same-day trips out of town, run with two own AC vans.
| Main product or service | City Tours and Excursions |
|---|---|
| Installed capacity per year (at 100%) | 10,000 units |
04 Market
- Business and conference visitors
- Visitors for weddings, education and healthcare
- Local residents with guests
- Corporates, housing societies, senior citizens and college groups for excursions
- Own website
- Hotel front desks
- Online travel platforms
05 Plant and machinery
| Item | Qty | ₹ | Total ₹ |
|---|---|---|---|
| Air-conditioned 15–20 seat vehicles (× 2) | 1 | 30,00,000 | 30,00,000 |
| Website, printed literature and initial souvenir stock (× 1 lot) | 1 | 5,00,000 | 5,00,000 |
| Total | 35,00,000 |
Pre-filled from: SIDBI Stand-Up Mitra project profile — City Tour and Excursions. Prices in older reports will have gone up — enter today’s quotations.
06 Raw materials
- Bottled drinking water and souvenirs for each customer — ₹15.00 L a year in year 2
- Fuel — ₹5.00 L a year in year 2
- Food and beverage on excursions — ₹10.00 L a year in year 2
07 Cost of project
| ₹ in lakh | |
|---|---|
| Plant and machinery | 35.00 |
| Contingency | 1.75 |
| Total fixed capital | 36.75 |
| Working capital margin | 0.00 |
| Total project cost | 36.75 |
08 Means of finance
| ₹ in lakh | % | |
|---|---|---|
| Promoter’s contribution | 3.68 | 10.0 |
| Term loan from bank | 33.08 | 90.0 |
| Total | 36.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.74 | 0.74 | 0.74 | 0.74 | 0.74 | 0.74 | 0.74 |
| Insurance | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 |
| Total cost of operations | 3.80 | 3.80 | 3.80 | 3.80 | 3.80 | 3.80 | 3.80 |
| Operating profit (EBITDA) | -3.80 | -3.80 | -3.80 | -3.80 | -3.80 | -3.80 | -3.80 |
| Depreciation | 5.51 | 4.69 | 3.98 | 3.39 | 2.88 | 2.45 | 2.08 |
| Preliminary expenses written off | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Interest on term loan | 3.58 | 3.10 | 2.54 | 1.98 | 1.42 | 0.86 | 0.30 |
| Interest on working capital | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Profit before tax | -12.89 | -11.59 | -10.32 | -9.17 | -8.10 | -7.11 | -6.18 |
| Income tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Profit after tax | -12.89 | -11.59 | -10.32 | -9.17 | -8.10 | -7.11 | -6.18 |
12 Cash flow
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Profit after tax | -12.89 | -11.59 | -10.32 | -9.17 | -8.10 | -7.11 | -6.18 |
| Depreciation | 5.51 | 4.69 | 3.98 | 3.39 | 2.88 | 2.45 | 2.08 |
| Cash accruals (PAT + depreciation) | -7.38 | -6.90 | -6.34 | -5.78 | -5.22 | -4.66 | -4.10 |
| Term loan repaid | 2.54 | 5.09 | 5.09 | 5.09 | 5.09 | 5.09 | 5.09 |
| Owner’s drawings | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Surplus after repayment | -9.92 | -11.99 | -11.43 | -10.87 | -10.31 | -9.75 | -9.19 |
| Cash and bank | -9.92 | -21.91 | -33.34 | -44.21 | -54.52 | -64.27 | -73.46 |
13 Projected balance sheet
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Capital (own + subsidy) | 3.68 | 3.68 | 3.68 | 3.68 | 3.68 | 3.68 | 3.68 |
| Reserves and surplus | -12.89 | -24.48 | -34.80 | -43.97 | -52.07 | -59.17 | -65.36 |
| Term loan outstanding | 30.53 | 25.44 | 20.35 | 15.27 | 10.18 | 5.09 | 0.00 |
| Working capital loan | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total liabilities | 21.31 | 4.64 | -10.77 | -25.03 | -38.21 | -50.41 | -61.68 |
| Net fixed assets | 31.24 | 26.55 | 22.57 | 19.18 | 16.31 | 13.86 | 11.78 |
| 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 | -9.92 | -21.91 | -33.34 | -44.21 | -54.52 | -64.27 | -73.46 |
| Total assets | 21.31 | 4.64 | -10.77 | -25.03 | -38.21 | -50.41 | -61.68 |
14 Ratios and break-even
| Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Debt service coverage ratio (DSCR) | -0.62 | -0.46 | -0.50 | -0.54 | -0.58 | -0.64 | -0.70 |
| Break-even (% of capacity used) | — | — | — | — | — | — | — |
| Cash break-even | — | — | — | — | — | — | — |
| Average DSCR | -0.58 |
|---|---|
| Lowest DSCR | -0.70 |
| Payback period | — |
15 Depreciation
| Year → (₹ in lakh) | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Depreciation | 5.51 | 4.69 | 3.98 | 3.39 | 2.88 | 2.45 | 2.08 |
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 | 33.08 | 3.58 | 2.54 | 30.53 |
| 2 | 30.53 | 3.10 | 5.09 | 25.44 |
| 3 | 25.44 | 2.54 | 5.09 | 20.35 |
| 4 | 20.35 | 1.98 | 5.09 | 15.27 |
| 5 | 15.27 | 1.42 | 5.09 | 10.18 |
| 6 | 10.18 | 0.86 | 5.09 | 5.09 |
| 7 | 5.09 | 0.30 | 5.09 | 0.00 |
17 Licences and registrations
- Shops and Establishments registration
- GST
- Tourist vehicle permits and registration from the Regional Transport Office
- Police permission for parking at tourist spots
- State tourism department registration for tour operators where available
18 Government schemes that may apply
- Stand-Up India
- Credit Guarantee Fund Trust for Micro and Small Enterprises (CGTMSE)
19 Sources
- SIDBI Stand-Up Mitra project profile — City Tour and Excursions — https://www.standupmitra.in/Default/ViewFile/?id=1516809498438_City%20Tours%20%26%20Excursions.docx&path=ProjectProfile
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.