Six-Room Homestay: Break-Even, Lean Season and a Café Loan
Ananya and Rohit are setting up a six-room homestay near Sarnath, Varanasi. Project cost is ₹32 lakh: a ₹20 lakh term loan at 11% over seven years (EMI about ₹34,250 a month) and ₹12 lakh of their own funds. Monthly fixed operating cost, excluding EMI, is ₹58,000 - rent, salaries, electricity minimums, Wi-Fi, licence fees and marketing. The average room rate is ₹2,800 and variable cost is ₹700 per occupied room-night, covering breakfast, laundry, utilities and OTA commission. Capacity is 6 rooms × 30 nights = 180 room-nights a month. Their occupancy forecast is 4 months at 85%, 4 at 45% and 4 at 15%, driven by the pilgrimage and wedding seasons. They draw no salary yet, and they now want to add a ₹9 lakh rooftop café financed by a second loan at the same rate over five years, arguing that guests keep asking for dinner.
1. Calculate the monthly break-even occupancy and the annual profit at forecast, then give a viability opinion.
Read the worked answer
Contribution per room-night = 2,800 − 700 = ₹2,100. Monthly fixed cost including EMI = 58,000 + 34,250 = ₹92,250. Break-even = 92,250 ÷ 2,100 = 43.9, say 44 room-nights = 24.4% occupancy.
Annual demand = 180 × (4 × 0.85 + 4 × 0.45 + 4 × 0.15) = 180 × 5.8 = 1,044 room-nights (48.3%). Contribution = 1,044 × 2,100 = ₹21,92,400. Annual fixed cost = 92,250 × 12 = ₹11,07,000. Profit before tax ≈ ₹10,85,400.
Viability opinion: viable, but not comfortable. The break-even of 24% is comfortably below the forecast 48%, so the business can service the loan. However, the ₹10.85 lakh is before owners' salaries, depreciation and a replacement reserve; allow ₹3 lakh for salaries, ₹1.5 lakh for furniture and linen replacement and the surplus falls to about ₹6 lakh. Also, three months at 15% occupancy produce losses of roughly ₹35,000 each, so they need a cash reserve of at least ₹1.5 lakh before they are safe. Verdict: proceed, but fund the reserve before any expansion.
2. They propose cutting the lean-season rate to ₹1,900 to fill rooms. Evaluate the proposal with numbers and recommend an alternative.
Read the worked answer
At ₹1,900: contribution = 1,900 − 700 = ₹1,200. Break-even = 92,250 ÷ 1,200 = 76.9, say 77 room-nights = 43% occupancy, against a lean-season forecast of only 27 room-nights (15%).
Compare the lean-month loss:
- At ₹2,800 and 27 room-nights: 27 × 2,100 = 56,700; less 92,250 = loss of ₹35,550.
- At ₹1,900 and 27 room-nights: 27 × 1,200 = 32,400; less 92,250 = loss of ₹59,850.
For the discount to merely match the no-discount loss, occupancy must rise to (92,250 − 35,550) ÷ 1,200 = 47.25, say 48 room-nights - a jump from 27 to 48, about +78%. There is no evidence the market responds that strongly in a lean month, so a straight rate cut mostly transfers money to guests who would have come anyway.
Recommend instead: hold the rate and chase volume at the top of the funnel - direct bookings through a Google listing and WhatsApp to cut the OTA commission inside the ₹700 variable cost; two-night pilgrimage packages with a temple transfer and breakfast; tie-ups with two Varanasi travel agents for shoulder-month groups; and a modest weekday-only rate of ₹2,300 (contribution ₹1,600) rather than a blanket cut. Discount only where it produces incremental nights, and never below ₹700 plus a margin.
3. Should they take the ₹9 lakh café loan now? Advise with reasoning and state the conditions under which you would support it.
Read the worked answer
Numbers: a ₹9 lakh loan at 11% over five years costs about ₹19,570 a month, ₹2.35 lakh a year, added to existing debt service of ₹4.11 lakh. Total annual debt service becomes roughly ₹6.46 lakh against a pre-salary surplus of ₹10.85 lakh - serviceable on paper, but it adds ₹19,570 of fixed cost in every month, including the three loss-making lean months, while café revenue is seasonal.
Risks: the café needs kitchen staff, a licence, gas safety and food-cost control - a second business, not a menu addition; six rooms produce at most about 12–15 covers a night at full occupancy, so the café must earn from outside guests, which puts it into direct competition with established Sarnath restaurants; and they have no owner salary and no reserve yet.
Recommendation: defer, do not cancel. Conditions for support:
- Build a cash reserve of three months' fixed cost (about ₹2.8 lakh) first.
- Prove demand cheaply: run a limited dinner menu from the existing kitchen or a temporary counter for one full season and measure covers, average bill and food cost for 90 days.
- Bring in a partner or cook with café experience rather than hiring from scratch.
- Borrow only ₹5–6 lakh, keep the term at seven years to lower the EMI, and hold a contingency of 15%.
- Fund it from retained profit plus a smaller loan, not a second full loan on a business that is only months old.