Excel model
Villa & Boutique Hotel Financial Model (Excel)
The 5-year model we use to test villa and boutique hotel projects in Bali and Lombok. Change the yellow cells, read the answer: capital needed, EBITDA, cash flow, IRR and break-even occupancy.
Sent to your email right after payment. Secure checkout by Xendit: card, bank transfer or e-wallet.
Excel modelWhat you get
- Inputs sheet: keys, ADR and yearly growth, occupancy ramp-up (years 1–5), F&B and other revenue, OTA share and commission, staff, utilities, maintenance, marketing, lease, land premium, construction, FF&E, pre-opening, contingency, working capital, tax, exit multiple.
- Capex: total capital required, including contingency and six months of working capital.
- P&L 5 years: rooms, F&B, OTA commissions, regional hotel tax handled as pass-through, staff (with THR), GOP, EBITDA, corporate income tax, free cash flow.
- Summary: capital required, year-3 EBITDA and margin, 5-year IRR with exit, payback, break-even occupancy, and a check against the PT PMA investment threshold.
- Sensitivity grid: EBITDA at every combination of ADR and occupancy.
Who it is for
Foreign and Indonesian investors, owners and developers planning a 4 to 30-key villa resort or boutique hotel in Indonesia or elsewhere in Southeast Asia, who want to check the numbers before talking to a builder or a bank.
Pre-filled example
The file opens with a realistic 10-key Lombok example so you can see how every line works before entering your own figures. All formulas are open; nothing is locked.
Pair it with
The Indonesia Villa & Hotel Investor Checklist 2026 (structure, land, licences, red flags).
Planning tool, not financial, legal or tax advice. Digital product: instant download after payment.
