Key Takeaways
This article provides a complete, India-focused framework for small hotel financial projections for DPRs and bank loans, written from the professional perspective of CA Manish Gugliya for ProjectReportBank.com. It covers every schedule, ratio and assumption a promoter needs to build a bankable detailed project report.
- A bankable small hotel DPR must integrate realistic occupancy and ADR assumptions with a projected Profit and Loss account, cash flow statement, projected balance sheet, DSCR calculation and break-even analysis, all built on internally consistent numbers.
- Banks in India focus on total project cost, means of finance, cash accrual and DSCR rather than just top-line turnover when assessing hotel term loans. Financial statements are essential for securing hotel funding.
- Hotel revenue assumptions (occupancy, ADR, F&B, ancillary) are inputs; hotel profitability, loan repayment capacity and DSCR are outputs. Confusing the two leads to projections that collapse under bank scrutiny.
- Revenue projections include room, F&B, and event income, while profitability is assessed through Gross Operating Profit and Net Operating Income at the operating level, then through net income and cash accrual at the debt-service level.
- Professionally prepared financial projections help both promoters and lenders understand feasibility, risks and repayment capacity before committing capital to a small or budget hotel project.
Explore Small Hotel Project Report Guides
Explore our complete Small Hotel Project Report and DPR guides covering setup cost, equipment, project cost, revenue, financial projections, occupancy, feasibility, project finance and bank loan assessment.
Introduction – Why Financial Projections Are Critical in a Small Hotel DPR
Small hotel financial projections convert the business concept (number of rooms, tariffs, facilities, staff, funding) into measurable financial outcomes for 5 to 7 years, specifically for Indian bank finance. They are the bridge between the physical hotel project and the lending decision.
For a small hotel project in India, say a 24-room budget hotel in Jaipur targeting operations from April 2027, the DPR’s projections form the backbone for term-loan appraisal and internal decision-making. In my project-finance practice, I see that projections are relied upon by promoters (to gauge feasibility), banks and NBFCs (to assess repayment capacity), tourism-finance institutions and sometimes government-subsidy or PMEGP authorities.
These projections are essential for assessing project feasibility, term-loan eligibility, working-capital needs and long-term financial performance. They are not “numbers made to please the bank.” Modeling requires input from local market data and realistic assumptions about occupancy and rates. Assumptions must be defensible; inflated occupancy or ADR gets challenged during credit appraisal because lenders compare your numbers against market research and competitor data.
Financial Projections Required in a Small Hotel DPR
A bankable small hotel DPR in India typically includes a full set of projected financial statements and supporting workings for at least 5 years (sometimes 7 to 10 years, depending on loan tenure). A project report includes an executive summary and market research alongside these financial schedules.
The key components include:
- Projected Profit and Loss statement (hotel income statement)
- Projected cash flow statement
- Projected balance sheet
- Detailed project cost and means of finance
- Term-loan repayment schedule with amounts and repayment dates
- Interest calculation on term loan and working capital
- Depreciation schedule
- Working capital assessment
- DSCR (Debt Service Coverage Ratio) computation
- Break-even analysis and break-even occupancy
- Key financial ratios and profitability analysis
These schedules are interconnected. Project costs feed into depreciation and interest. Operating assumptions drive revenue and expenses. The P&L drives cash accrual. Cash accrual drives DSCR and repayment capacity. All of this must reconcile in the projected balance sheet. If the loan repayment schedule does not match the balance sheet’s term-loan outstanding, or if the cash flow statement does not reconcile with P&L and working capital movements, lenders lose confidence in the entire report.
Banks expect to see both summary statements and detailed workings: occupancy build-up sheets, tariff schedules, salary breakdowns and similar backing data. A robust DPR for bank finance should include narrative explanation of assumptions alongside the numbers.
Key Assumptions Used for Small Hotel Financial Projections
Every financial model is only as reliable as its assumptions. A hotel’s financial model should include unique assumptions and variable costs rather than generic percentages. This section serves as a practical checklist.
Core operating assumptions:
- Number of rooms (e.g., 20 or 30), room categories (standard, deluxe)
- Available room nights (rooms x 365 days)
- Targeted occupancy ramp-up by year (e.g., 45% Year 1 to 72% Year 5)
- Average Daily Rate by category; annual tariff escalation (e.g., 5%)
- Seasonality affects hotel revenue expectations and staffing needs; model high, shoulder and lean months, especially for tourist destinations like Goa, Rishikesh or Shimla
- Occupancy forecasts should account for seasonal demand variations
Revenue assumptions beyond rooms:
- F&B revenue (restaurant, breakfast, room service); secondary revenue streams are additional income sources like food and beverage and event space
- Banquet/event income where applicable
- Laundry, parking, travel desk, conference facilities and other ancillary services
Operating cost assumptions:
- Staffing levels and salary bands across departments
- Food cost as a percentage of F&B sales (typically 28-35%)
- Utilities: electricity (6-9% of revenue), water, diesel for DG
- OTA and travel-agent commissions; distribution costs involve fees paid to online travel agencies
- Marketing, maintenance, insurance, admin overheads
Project-financing assumptions:
- Total project cost, promoter contribution percentage, term-loan amount
- Interest rate (e.g., 10-12% p.a.), moratorium period, repayment tenure
- Working capital limits
Accounting assumptions:
- Depreciation rates on building and hotel equipment
- Tax rate assumptions for income tax
- GST impact on room and F&B pricing (noted qualitatively)
Financial models must include occupancy and ADR forecasts. Hotels should benchmark their metrics against competitors for more accurate forecasts. In professional DPRs, I cross-check these assumptions against recent hotel projects and the specific location to avoid unrealistic projections. A SWOT analysis evaluates strengths, weaknesses, opportunities and threats, and is often included in the DPR narrative alongside financial data.
Room Revenue Projection – Occupancy, ADR and Ramp-Up
Room revenue is the primary driver of hotel profitability, and banks closely analyse the logic behind occupancy and ADR projections. Occupancy measures the percentage of available rooms sold.
The base formulas:
- Available Room Nights = Number of Rooms x 365
- Occupied Room Nights = Available Room Nights x Occupancy %
- Room Revenue = Occupied Room Nights x ADR
Here is an illustrative example for a 30-room budget hotel starting April 2027:
| Particulars | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Rooms | 30 | 30 | 30 | 30 | 30 |
| Available Room Nights | 10,950 | 10,950 | 10,950 | 10,950 | 10,950 |
| Occupancy % | 45% | 55% | 65% | 70% | 72% |
| Occupied Room Nights | 4,928 | 6,023 | 7,118 | 7,665 | 7,884 |
| ADR (₹) | 2,200 | 2,310 | 2,426 | 2,547 | 2,674 |
| Room Revenue (₹ Lakh) | 108.41 | 139.12 | 172.68 | 195.23 | 210.86 |
All figures are illustrative. Actual assumptions will vary by project.
Assuming 80-90% occupancy from day one in Indian tier-2 locations is unrealistic during credit appraisal. BrandSync’s KPI benchmarks show budget/economy hotels typically achieve 62-74% occupancy at stabilisation, not in year one. A gradual ramp-up is far more credible.
Hotels should model financial projections with a monthly approach for increased accuracy; seasonality can be layered on annual averages in the detailed Excel model.
ADR and RevPAR in Hotel Financial Projections
ADR and RevPAR are standard hotel metrics used by banks and investors to benchmark revenue assumptions against market data.
- ADR = Room Revenue ÷ Rooms Sold. Average Daily Rate is calculated as room revenue divided by rooms sold.
- RevPAR = Room Revenue ÷ Available Rooms, or equivalently ADR x Occupancy %. RevPAR combines room revenue and occupancy into a single metric.
In a budget hotel model, ADR should be based on realistic achieved rates (after discounts and OTA commissions), not rack rates printed on the tariff card. The difference matters: if your rack rate is ₹3,000 but average realisation after OTA commissions and discounts is ₹2,200, the projection must use ₹2,200.
Quick comparison:
| Scenario | Occupancy | ADR (₹) | RevPAR (₹) |
|---|---|---|---|
| A | 65% | 2,200 | 1,430 |
| B | 65% | 2,800 | 1,820 |
Same occupancy, ₹600 higher ADR in Scenario B; RevPAR jumps by ₹390. This difference, over 10,950 room nights, translates to ₹42.7 lakh in annual room revenue. When reviewing small hotel DPRs, I cross-check ADR and RevPAR against nearby competing hotels and OTA listing data to validate assumptions.
Food & Beverage and Ancillary Revenue Projections
For most small/budget hotels in India, F&B and ancillary income support room revenue rather than driving the entire business, but they still matter for cash flow and profitability.
F&B revenue sources:
- In-house restaurant, buffet breakfast for room guests, room service, small café, minibar
- Modelling approaches: covers x average spend per cover, or percentage of room revenue (typically 20-40% depending on concept and location)
Ancillary revenue:
- Laundry, airport/station transfers, parking fees, conference room hire, travel desk commission, early check-in/late checkout fees, extra-bed charges, event services
Only income streams genuinely planned for the proposed hotel should be included. Avoid bloating projections with hypothetical departments (spa, large banquet hall) that are not part of the project cost.
For a detailed breakdown of how hotel room, F&B and other income streams are structured, refer to the small hotel revenue model. This article focuses on how those revenue assumptions flow into full financial projections, P&L, cash flow, balance sheet and DSCR.
Total Revenue Projection – Consolidating Room, F&B and Other Income
Lenders and investors first look at consolidated hotel revenue before drilling into departmental revenue. The DPR must summarise all sources clearly.
| Particulars (₹ Lakh) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Room Revenue | 108.41 | 139.12 | 172.68 | 195.23 | 210.86 |
| F&B Revenue | 27.10 | 34.78 | 43.17 | 48.81 | 52.72 |
| Other Income | 5.42 | 6.96 | 8.63 | 9.76 | 10.54 |
| Total Revenue | 140.93 | 180.86 | 224.49 | 253.80 | 274.12 |
F&B is assumed at ~25% of room revenue; other income at ~5%. Growth in F&B and other income correlates with room occupancy trends (breakfast and laundry revenue move broadly in line with room nights sold). Seasonal or event-based spikes (festivals, wedding season, conferences) can be embedded at monthly level in the Excel model, but DPR tables are usually annualised. This consolidated total revenue table becomes the starting point for building the projected profit and loss statement and checking overall financial performance.
Operating Expense Projections for a Small Hotel
Underestimating expenses is one of the most common reasons DPRs look attractive on paper but fail in hotel operations. Banks and experienced CAs are quick to spot unusually low cost ratios.
Major expense heads:
- Salaries and wages (front office, housekeeping, F&B, kitchen, security, management)
- Cost of food and beverages consumed
- Housekeeping and laundry supplies
- Electricity, water, diesel/fuel for backup power
- Repairs and maintenance
- OTA commissions (often 15-25% of room revenue booked through OTAs)
- Sales, marketing and advertising
- Software/PMS expenses
- Insurance, licence renewals, property taxes
- Administrative and miscellaneous operational expenses
- Management fees, if applicable under a brand or management contract
Cost classification matters for break-even and sensitivity analysis:
- Fixed costs are unchanging overhead expenses like property rent, insurance, key management salaries and property taxes
- Variable costs change with occupancy levels and include items like cleaning supplies, guest amenities, food cost, laundry and OTA commissions
- Semi-variable costs include utilities and certain staff positions that scale partially with occupancy
Illustrative operating-expense breakdown at Year 3 (stabilised):
| Expense Head | ₹ Lakh | % of Revenue |
|---|---|---|
| Salaries & Wages | 44.90 | 20.0% |
| F&B Cost of Goods | 15.11 | 6.7% |
| Utilities (Power, Water, Fuel) | 24.69 | 11.0% |
| Housekeeping & Laundry | 6.73 | 3.0% |
| OTA Commissions | 15.71 | 7.0% |
| Marketing & Sales | 6.73 | 3.0% |
| Repairs & Maintenance | 4.49 | 2.0% |
| Insurance & Licences | 3.37 | 1.5% |
| Admin & Misc. | 6.73 | 3.0% |
| Other Expenses incurred | 4.49 | 2.0% |
| Total Operating Expenses | 132.96 | 59.2% |
Realistic salary provisions, power costs and OTA commission assumptions are red-flag areas for bank credit teams reviewing hospitality projections. If these look too low relative to industry benchmarks, expect queries.
Projected Profit & Loss Account (Hotel Income Statement)
The projected Profit and Loss statement, or hotel income statement, summarises revenue, operating costs and profitability. It is one of the first pages bankers read in a small hotel DPR. Hotel income statements show revenue and profit over time. Income Statement (P&L) forecasts total expected revenues minus operational expenses to show profitability.
Structure: Total Revenue → Operating Expenses → Gross Operating Profit / EBITDA → Depreciation → Interest → Profit Before Tax → Tax → Profit After Tax
| P&L (₹ Lakh) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Total Revenue | 140.93 | 180.86 | 224.49 | 253.80 | 274.12 |
| Operating Expenses | 109.93 | 132.63 | 132.96 | 147.21 | 156.25 |
| Gross Operating Profit | 31.00 | 48.23 | 91.53 | 106.59 | 117.87 |
| Depreciation | 22.40 | 22.40 | 22.40 | 22.40 | 22.40 |
| Interest on Term Loan | 33.00 | 31.28 | 27.09 | 22.91 | 18.72 |
| Interest on WC | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 |
| Profit Before Tax | (26.40) | (7.45) | 40.04 | 59.28 | 74.75 |
| Tax (25%) | 0.00 | 0.00 | 10.01 | 14.82 | 18.69 |
| Net Profit (PAT) | (26.40) | (7.45) | 30.03 | 44.46 | 56.06 |
Illustrative example only. Actual projections depend on project-specific assumptions.
Projected profitability statements estimate hotel profits for 3-5 years. Gross Operating Profit reflects a hotel’s operating efficiency. While turnover growth matters, banks and promoters should focus on EBITDA margin, net profit margin and recurring cash accrual because these determine long-term hotel profitability and debt service capacity. As of June 2020, average hotel profit margin was around 18%, though this varies by segment and market cycle.
Depreciation, Project Costs and Capital Expenditure
Depreciation is a non-cash expense reflecting the gradual write-down of the hotel’s assets, but it affects accounting profit, tax and net worth, so it must be projected correctly. Capital Expenditures (CapEx) are funds set aside for maintenance and refurbishments over the hotel’s life.
Major fixed-asset categories:
- Land and building (land is not depreciated)
- Interior works and civil finishing
- Furniture and fixtures
- HVAC and electrical systems
- Kitchen and laundry equipment
- Computers, PMS and IT infrastructure
- Vehicles, if any
Fixed capital investment covers construction, furniture, and equipment costs. The small hotel setup cost in India article provides a detailed breakdown of these costs. For detailed item-wise cost guidance on small hotel equipment, furniture and FF&E cost, refer to the dedicated article on ProjectReportBank.
Example: Out of a ₹5 crore total project cost, assume ₹4 crore is depreciable (excluding freehold land). Using a blended straight-line rate yielding roughly ₹22.40 lakh annual depreciation, this flows directly into the projected income statement and reduces net block on the projected balance sheet each year.
Interest on Term Loan, Working Capital and Term-Loan Repayment Schedule
Interest and principal repayment are critical for DSCR and loan approval. A common modelling mistake is applying the interest rate on the original principal for the full tenure; interest on a term loan should be calculated on the reducing balance.
Term-loan amortisation (₹3 crore loan, 11% p.a., 1-year moratorium, 8-year repayment):
| Year | Opening Balance (₹ Lakh) | Principal Repayment (₹ Lakh) | Interest (₹ Lakh) | Total Debt Service (₹ Lakh) | Closing Balance (₹ Lakh) |
|---|---|---|---|---|---|
| 1 (Moratorium) | 300.00 | 0.00 | 33.00 | 33.00 | 300.00 |
| 2 | 300.00 | 37.50 | 31.28 | 68.78 | 262.50 |
| 3 | 262.50 | 37.50 | 27.09 | 64.59 | 225.00 |
| 4 | 225.00 | 37.50 | 22.91 | 60.41 | 187.50 |
| 5 | 187.50 | 37.50 | 18.72 | 56.22 | 150.00 |
The loan repayment schedule outlines amounts and repayment dates. Working capital interest is projected separately, based on average utilisation of sanctioned cash credit or overdraft limits, typically tied to inventories and receivables.
Changes in moratorium, tenure and interest rate directly affect annual instalments and DSCR. The capital structure determined in the small hotel project cost and means of finance flows directly into this term-loan and interest schedule.
Projected Cash Flow Statement – Profit vs Cash
A profitable hotel on paper can still face cash shortages if cash flow is weak. Cash flow projections help anticipate periods where revenue may not cover expenses. This is why banks insist on projected cash flow statements alongside P&L. Cash flow statements show expected inflows and outflows of cash.
The projected cash flow statement starts from Profit After Tax, adds back non-cash items like depreciation, adjusts for working-capital movements (inventories, receivables, payables), subtracts capital expenditure and deducts loan principal repayments to show net cash position.
| Cash Flow (₹ Lakh) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| PAT | (26.40) | (7.45) | 30.03 | 44.46 | 56.06 |
| Add: Depreciation | 22.40 | 22.40 | 22.40 | 22.40 | 22.40 |
| Add: Interest on TL | 33.00 | 31.28 | 27.09 | 22.91 | 18.72 |
| Cash Accrual | 29.00 | 46.23 | 79.52 | 89.77 | 97.18 |
| Working Capital Changes | (8.00) | (3.00) | (2.50) | (1.50) | (1.00) |
| Less: TL Repayment | 0.00 | 37.50 | 37.50 | 37.50 | 37.50 |
| Less: Interest Paid | 35.00 | 33.28 | 29.09 | 24.91 | 20.72 |
| Net Cash Movement | (14.00) | (27.55) | 10.43 | 25.86 | 37.96 |
For hotel projects, early years often have tighter cash flow due to ramp-up and heavy interest burden. The model must demonstrate that the hotel has enough cash to pay EMIs, salaries and utilities even in lean months. Most banks derive DSCR inputs from these cash-flow and loan-schedule workings.
Projected Balance Sheet and Working Capital Requirement
The projected balance sheet shows the hotel’s financial position at year-end. A balance sheet summarizes hotel assets and liabilities. It must reconcile with the P&L, cash flow, project cost and term-loan schedules.
Assets side:
- Fixed assets (net of depreciation); the hotel’s assets include land, building, FF&E
- Current assets: inventory of F&B and consumables, trade receivables from OTAs/corporate clients, cash and bank balance, advances and deposits
Liabilities and equity:
- Share capital / promoter contribution
- Reserves and surplus (retained profits flowing from P&L)
- Term-loan outstanding (reducing per repayment schedule)
- Working-capital borrowing
- Trade creditors and other current liabilities
Working capital is needed for day-to-day hotel operations. Working capital covers day-to-day operational expenses of hotels. Hotel working-capital dynamics differ from manufacturing: a large proportion of room revenue is received upfront (walk-in guests, prepaid OTA bookings), but OTA/corporate receivables can create 30-45 day collection cycles.
Illustrative working-capital computation:
| Component | Days | ₹ Lakh |
|---|---|---|
| F&B/Consumables Inventory | 15 days | 1.86 |
| Trade Receivables | 30 days | 18.71 |
| Less: Trade Creditors | 20 days | 7.30 |
| Working Capital Gap | 13.27 | |
| Bank Finance (75%) | 9.95 | |
| Promoter Margin (25%) | 3.32 |
DSCR for a Small Hotel Project – Loan Repayment Capacity
Debt Service Coverage Ratio measures the hotel’s ability to service its term-loan obligations from its own cash generation. It is a key metric for bank loan decisions and the most scrutinised ratio in a hotel DPR.
Formula:
DSCR = (Net Profit After Tax + Depreciation + Interest on Term Loan) ÷ (Interest on Term Loan + Principal Repayment)
Or equivalently: Cash Accrual ÷ Total Debt Servicing
Numerical example (Year 3):
- Cash Accrual = ₹30.03 + ₹22.40 + ₹27.09 = ₹79.52 lakh
- Total Debt Service = ₹27.09 + ₹37.50 = ₹64.59 lakh
- DSCR = 79.52 ÷ 64.59 = 1.23
Lenders look at yearly DSCR as well as average DSCR across the loan period. RBI’s sector-specific thresholds for hotels suggest yearly DSCR should be at least 1.00 and average DSCR at least 1.20. Many banks apply stricter internal benchmarks. DSCR must be at least 1.5 in every loan year for approval under several hospitality lending schemes. A DSCR of 1.5 is required for loan approval in hospitality in many institutional guidelines.
A weak DSCR in early years, even if later years are strong, raises concerns. In professional DPR and CMA Data preparation, I cross-check DSCR against realistic occupancy and ADR assumptions rather than adjusting assumptions to “push DSCR up.”
Break-Even Analysis and Break-Even Occupancy
Break-even analysis determines sales needed to cover hotel costs. The break-even point indicates when hotel revenue covers costs. For hotels, the most useful metric is break-even occupancy.
Formulas:
- Contribution per Room Night = ADR – Variable Cost per Room Night
- Break-Even Room Nights = Total Fixed Costs ÷ Contribution per Room Night
- Break-Even Occupancy % = (Break-Even Room Nights ÷ Available Room Nights) x 100
Example (Year 3):
- ADR: ₹2,426; Variable cost per room night: ~₹800
- Contribution per room night: ₹1,626
- Annual fixed costs (incl. fixed salaries, insurance, property costs, depreciation, interest): ~₹92 lakh
- Break-Even Room Nights = 92,00,000 ÷ 1,626 = 5,658
- Break-Even Occupancy = 5,658 ÷ 10,950 = 51.7%
With projected Year 3 occupancy of 65%, there is a 13.3 percentage-point cushion above break-even. Banks look at this margin to judge whether the project can handle seasonal dips and competitive pressure.
Sensitivity Analysis – Base, Conservative and Optimistic Scenarios
Hospitality projects are particularly sensitive to changes in occupancy and ADR. Even a 10 percentage-point drop in occupancy can sharply reduce DSCR.
| Scenario | Year 3 Occupancy | ADR (₹) | Revenue (₹ Lakh) | EBITDA (₹ Lakh) | DSCR |
|---|---|---|---|---|---|
| Optimistic | 70% | 2,550 | 248.00 | 102.00 | 1.40 |
| Base Case | 65% | 2,426 | 224.49 | 91.53 | 1.23 |
| Conservative | 55% | 2,300 | 183.00 | 62.00 | 0.96 |
The conservative case shows DSCR below 1.0, which means the hotel cannot fully service its debt from operations in that scenario. This illustrates why banks test assumptions carefully.
In my project-finance practice, sensitivity analysis is used to stress-test whether the small hotel can still service debt during weaker-than-expected years without constant promoter support. The printed DPR may show limited scenario tables, but the underlying Excel model should allow easy testing of different assumptions.
Illustrative 5-Year Small Hotel Financial Projection – Integrated Example
Disclaimer: This is a purely illustrative 5-year projection for a hypothetical 30-room budget city hotel in a tier-2 Indian city, opening FY 2027-28. Actual projections require customised assumptions.
| Particulars | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Rooms | 30 | 30 | 30 | 30 | 30 |
| Occupancy % | 45% | 55% | 65% | 70% | 72% |
| ADR (₹) | 2,200 | 2,310 | 2,426 | 2,547 | 2,674 |
| Room Revenue (₹ L) | 108.41 | 139.12 | 172.68 | 195.23 | 210.86 |
| F&B + Other (₹ L) | 32.52 | 41.74 | 51.81 | 58.57 | 63.26 |
| Total Revenue (₹ L) | 140.93 | 180.86 | 224.49 | 253.80 | 274.12 |
| Operating Expenses (₹ L) | 109.93 | 132.63 | 132.96 | 147.21 | 156.25 |
| EBITDA (₹ L) | 31.00 | 48.23 | 91.53 | 106.59 | 117.87 |
| Depreciation (₹ L) | 22.40 | 22.40 | 22.40 | 22.40 | 22.40 |
| Interest (TL + WC) (₹ L) | 35.00 | 33.28 | 29.09 | 24.91 | 20.72 |
| PAT (₹ L) | (26.40) | (7.45) | 30.03 | 44.46 | 56.06 |
| Cash Accrual (₹ L) | 29.00 | 46.23 | 79.52 | 89.77 | 97.18 |
| TL Repayment (₹ L) | 0.00 | 37.50 | 37.50 | 37.50 | 37.50 |
| DSCR | 0.88 | 0.67 | 1.23 | 1.49 | 1.73 |
| Average DSCR (Yrs 1-5) | 1.20 |
Commentary: The hotel shows accounting losses in Years 1 and 2 due to low occupancy and heavy interest burden. DSCR becomes comfortable from Year 3 onward as occupancy stabilises. By Year 4-5, cash accrual comfortably exceeds debt service. The average DSCR over 5 years at 1.20 meets the minimum threshold under Horwath HTL and RBI benchmarks for the hotel sector, though individual banks may require higher. The hotel’s financial performance improves steadily as room occupancy reaches stabilised levels.
This example is for educational guidance only and cannot replace a personalised hotel financial projection model tailored to a specific location and funding structure.
How Banks Analyse Small Hotel Financial Projections in India
Bank credit officers do not look at one statement or ratio in isolation. They read the entire financial story from project cost to DSCR and security.
Key aspects typically reviewed:
- Total project cost: land, building, FF&E, pre-operative expenses. How much investment is involved, and is it realistic?
- Means of finance: promoter contribution vs term loan; whether promoter equity is adequate and timed properly
- Occupancy and ADR assumptions: compared against existing hotels in the market, OTA data and industry benchmarks
- Projected revenue and EBITDA: do operating departments generate adequate margins?
- Break-even occupancy: is projected occupancy well above break-even?
- Cash accrual and DSCR: does the hotel generate enough cash for debt servicing in each year?
Lenders also consider qualitative factors: promoter background, hotel management experience, location quality, competition, proposed online/branding strategy and available collateral. They compare projected hotel financial statements with market data and question any numbers that appear over-optimistic.
The chain that must hold together: Project Cost → Means of Finance → Revenue and Expenses → Profitability → Cash Accrual → Loan Repayment → DSCR → Projected Balance Sheet. Inconsistencies along this chain are common causes of delays in hotel loan proposals.
Common Mistakes in Small Hotel Financial Projections and DPRs
As a practising Chartered Accountant, I frequently encounter recurring errors in hotel project reports that reduce their credibility with banks.
Revenue-side mistakes:
- Assuming 70-80% occupancy in Year 1 without existing brand or market presence
- Ignoring seasonality and treating revenue generation as flat over 12 months
- Inflating ADR beyond what the local market supports
- Overstating F&B and banquet income, especially for budget hotels without separate banquet infrastructure
- Not adjusting for OTA commission impact on net ADR
Cost-side mistakes:
- Underestimating salaries (especially kitchen, housekeeping and security staff)
- Inadequate electricity and diesel provision (backup power costs in tier-2 cities can be 8-12% of revenue)
- Ignoring pricing strategies for lean months that may require discounting
Technical modelling mistakes:
- Calculating interest on full original loan amount throughout tenure instead of reducing balance
- Incorrect or missing depreciation schedule
- Preparing a cash flow statement that does not reconcile with P&L and loan schedules
- Balance sheet not balancing because retained earnings do not match cumulative PAT
- Artificially adjusting assumptions to achieve a desired DSCR, which looks good on paper but collapses during appraisal or actual operations
Careful review by an experienced professional, cross-checking projections against real-world financial data, and running feasibility analysis with conservative scenarios can reduce such errors and improve the quality of a bankable hotel project report.
FAQs – Small Hotel Financial Projections and DPRs
Many promoters have similar practical questions when preparing hotel financial projections for a DPR or bank loan. Here are the most common ones.
How many years of financial projections should a small hotel DPR include?
Most Indian banks expect at least 5 years of projected Profit and Loss, cash flow statement and projected balance sheet. For term loans with longer tenures (8-10 years), some lenders may ask for extended projections covering the full repayment period. The first 2-3 years should clearly show occupancy ramp-up, while later years demonstrate stabilised profitability and DSCR.
Are hotel financial projections mandatory for getting a bank loan in India?
For term loans above basic limits (MSME loans, tourism loans, PMEGP projects and regular bank term loans), banks almost always require a structured hotel project report with financial projections. Even when not formally mandated, professionally prepared projections help the promoter understand financial viability and prepare for discussions with credit officers. Three financial statements (P&L, cash flow, balance sheet) form the core of any hotel DPR for bank finance.
What is the difference between a hotel income statement and a cash flow statement?
The hotel income statement (P&L) shows accounting profitability: revenue, operating expenses, depreciation, interest and net profit. The cash flow statement tracks actual cash inflows and outflows, including working capital changes and loan repayments. A hotel can show profit after tax but still face cash shortages if receivables are high or loan instalments are large, which is why both statements are needed. Cash flow statements track cash inflows and outflows for hotels, and they reveal the hotel’s financial health and financial standing more accurately than profit alone.
How is break-even occupancy calculated for a small hotel?
Break-even occupancy = (Total Fixed Costs ÷ Contribution per Room Night) ÷ Available Room Nights x 100. Contribution per room night is ADR minus variable cost per room night. If a hotel’s fixed costs are ₹92 lakh per year, contribution is ₹1,626 per room night and available room nights are 10,950, break-even occupancy works out to about 52%. This tells the promoter and the bank what minimum room occupancy is needed before the hotel starts generating a net profit.
Can a template alone replace professional help for preparing a hotel DPR?
Generic templates can help structure basic financial projections, but they often assume flat occupancy, generic expense percentages and simplified DSCR calculations that may not satisfy bank scrutiny. Market analysis, demand assessment and operating performance benchmarking require project-specific work. For projects involving too much money or complex financing, working with an experienced professional to customise assumptions and ensure internal consistency is usually advisable.
Conclusion – Using Small Hotel Financial Projections to Build a Bankable DPR
Robust small hotel financial projections are not about filling tables with optimistic numbers. They demonstrate whether realistic occupancy and ADR, grounded in market demand and operating capacity, can generate sufficient profitability, cash flow and DSCR to sustain the hotel project over its loan tenure. The business plan behind the numbers matters as much as the numbers themselves.
A complete DPR should integrate operating assumptions, projected profit and loss account, projected cash flow forecast, projected balance sheet, break-even and DSCR calculations into one coherent financial story. When these are prepared or reviewed carefully, checking consistency from project cost and means of finance through to loan repayment and balance-sheet strength, both the risk of project failure and the risk of loan stress reduce.
CA Manish Gugliya and ProjectReportBank.com assist entrepreneurs, hotel promoters and MSMEs in India with preparing detailed project reports, CMA Data, small hotel project report financial projections, DSCR analysis and bank-finance documentation. Each bank takes its own independent credit decision based on its appraisal; no professional can guarantee loan approval, but a well-prepared DPR positions the proposal for informed evaluation.
Explore More Small Hotel Project Report Guides
Continue exploring our Small Hotel DPR guides covering setup cost, equipment, project cost, revenue, financial projections, occupancy, feasibility, project finance and bank loan assessment.