Investment-Grade Financial Model: Data Requirements Checklist

Why you need a data map

In a mixed-use project combining a 5-star hotel, a wellness centre, fine-dining restaurants and Branded Residences, the difference between a Pre-Feasibility Model and a model submitted to financial institutions, institutional investors and the BOI lies not in the complexity of the formulas, but in the quality and source of the data fed into it.

The most common problem is not a lack of modelling skill but the lack of a data map from the outset. Teams end up revising assumptions repeatedly as actual data trickles in, and when they submit the model to a bank or an investor, they cannot cite the sources behind their figures.

The sample project used

For illustration, assume a sample project on the west coast of Phuket: about 45 rai of beachfront land, a total investment of roughly THB 8,500–10,000 million, and a 36-month construction period, comprising 4 business units.

Initial assumptions: Year 3 ADR averages THB 18,000, occupancy 68%, and the Branded Residences price averages THB 95,000 per sq m. For ownership of condominium units, foreign buyers may hold under the 49% quota of the total unit area. For leasehold structures, the term and renewal rights must be checked against the latest law and a lawyer's opinion obtained.

Category 1: Investment budget and construction costs

A capex error of just 5–10% can reverse an investment decision, especially in luxury projects where cost per key can reach THB 25–45 million per room.

Land acquisition

Where the land is beachfront and partly within a conservation area, the EIA is a precondition for the building permit. If the main investor is a foreign party, holding the land through a Thai company requires Thai shareholders who genuinely invest, not nominees, and a written legal opinion should be obtained to support due diligence.

Hard Cost

Reference ranges for Phuket: hotel portion THB 75,000–110,000 per sq m, and top-tier pool villas or Sky Residences THB 95,000–140,000 per sq m.

Compare at least 3 EPC quotations against the benchmark. If the gap is no more than 8%, the market reflects real prices; if it exceeds 15%, go back and check the scope of work immediately.

Soft Cost

Typically 12–18% of hard cost for a luxury project, comprising architect fees of 5–8%, project management of 3–5%, permit fees, legal fees, construction insurance (CAR/EAR at about 0.3–0.5% of hard cost) and a loan arrangement fee of 0.5–1.5% of the facility.

FF&E and OS&E

For a 5-star hotel, FF&E is about THB 1.8–2.8 million per room and OS&E about THB 250,000–400,000 per room. This item must be approved by the operator and is usually designed by an international interior designer.

Category 2: Personnel

Personnel costs in a luxury hotel are around 28–35% of total revenue, higher than the industry average of 22–26%, because the staff-to-key ratio of a luxury 5-star hotel is 1.6–2.2 staff per room. The 180-room sample project therefore has about 320–380 staff, excluding about 45 in wellness and about 95 in restaurants.

Headcount Plan

Compile departmental org charts, job descriptions, reporting lines and, most importantly, a monthly headcount ramp-up schedule for the 12 months before opening.

Compensation Benchmarks

Benefits and statutory obligations

Includes employer social security contributions (check the latest rate and wage ceiling under the ministerial regulation as at the model date), provident fund of 5–15% on a matching basis, group health insurance of THB 3,500–8,000 per person per year, a service charge pool (typically 8–10% of revenue on which service charge is collected), staff meals at THB 90–130 per meal, overtime, severance pay under labour law, and performance bonuses.

Training

Pre-opening training for a luxury hotel is about THB 35,000–55,000 per person; ongoing training is 1.5–2.5% of payroll per year; and visa and work permit costs for senior foreign staff are about THB 35,000–60,000 per person per year.

Category 3: Revenue and operating assumptions

Revenue comes from five streams: rooms, food and beverage, spa and wellness, signature restaurants, and Branded Residences, from both sales and rental pool share.

Hotel Revenue Drivers

Start with a market report to define a compset of 5–10 comparable hotels, then use it as the basis for project ADR and occupancy over 5–10 years. Consider channel mix, seasonality, length of stay and source markets.

F&B and restaurants

The capture rate of hotel guests is typically 65–80% for breakfast (often included in the package), 35–50% for lunch and 40–55% for dinner. Banquet and wedding revenue averages 12–18% of total F&B revenue in Phuket.

Wellness and spa

Average revenue per treatment is THB 4,500–7,500 for the day spa and THB 18,000–60,000 per programme for medical wellness programmes. Use Global Wellness Institute reports as a reference for market growth, and check the latest figures before use.

Branded Residences

This is the fastest cash inflow in a mixed-use project because sales can open ahead of completion. Use independent market reports to set the brand premium against non-branded projects, with a reference range of about 25–45%. In the sample project, the average price is set at THB 95,000 per sq m for pool villas, with an expected net rental yield of 5–7% from the rental pool, which must be tested to confirm it is the real return after all expenses.

Category 4: Operating costs

Refer to the latest USALI standard (12th Revised Edition, effective from January 2026) so that figures can be compared correctly against industry benchmarks.

Rooms department expense, including payroll, linen, cleaning supplies and guest amenities, is about 22–28% of room revenue; F&B department expense is about 70–82% of F&B revenue; and spa department expense is about 55–68% of spa revenue.

For energy, the benchmark is 180–280 kWh/m²/year. Fixed charges comprise land and building tax (check the rates by type of use and the measures in force for the tax year of the model), property and business interruption insurance of about 0.18–0.28% of replacement cost per year, annual licence fees, and land rent in the case of leasehold.

Category 5: Sales and marketing

Split into pre-opening marketing and annual operating marketing. The pre-opening budget is recommended at 2.5–4.0% of Total Project Cost, or roughly THB 225–360 million on a THB 9,000 million project base. It covers brand launch, PR, photography, trade shows and digital assets. The model includes it in the funding requirement, but in the accounts it is expensed as incurred, like other pre-opening items.

Distribution cost must cover OTA commission of roughly 15–22%, channel manager subscription, GDS fees, the operator's CRS, the hotel group's loyalty programme costs, and travel agent commission of 8–12%.

Category 6: Management agreement and brand

The Hotel Management Agreement has the greatest impact on cash flow over 25–30 years, because it sets every tier of fees, the marketing contribution and the performance test.

The owner should negotiate a two-test failure performance test (both the GOP threshold and the RevPAR Index falling below 90% of the comp set) to preserve the right to replace the operator.

Category 7: Capital structure

For a mixed-use project of about THB 9,000 million, a suitable structure is 35–45% equity and 55–65% debt, with a 36-month construction loan converting into a 12–15-year term loan on opening. Presale proceeds from branded residences may reduce Peak Funding by 15–25%.

Debt

Obtain bank term sheets from at least 3 commercial banks to compare interest rate, LTV/LTC, tenor, amortisation, DSCR Covenant (generally not below 1.30x), 6-month DSRA, prepayment penalty and conditions for conversion to a term loan.

Equity

The documents comprise the shareholder agreement, equity drawdown schedule, investor hurdle rate, promote structure (for example, a 20% carry after investors achieve a 10% IRR) and reserved matters.

Alternative funding sources

Mezzanine debt at 12–16%, convertible notes for institutional investors, and Presale funds, for which escrow arrangements and transfer conditions must be tightly structured before they are counted as a funding source.

Category 8: Tax and legal

Consider applying for BOI promotion for the hotel business, checking the activity type, conditions and privileges under the latest BOI announcement. Plan for VAT refunds during construction, withholding tax (WHT) on management fees paid to a foreign operator under each country's double taxation agreement, and transfer pricing documentation for intragroup transactions.

Category 9: Technical and engineering

Institutional investors are giving ESG more weight, so technical information must be included in the Investment Memorandum: energy modelling (kWh/sq m), water use modelling, the LEED, EDGE or EarthCheck certification plan, solar PV study results, HVAC sizing and operating costs, and the backup power system.

The information systems to be specified in CAPEX are PMS, POS, channel manager, spa booking, F&B inventory, Wi-Fi infrastructure, CCTV and access control, including smart room technology, totalling about 4–7% of the FF&E budget.

The maintenance plan should set an annual CAPEX reserve starting at 1% of revenue in the first year and rising to 4–5% from year 5. Plan major refurbishment cycles every 6–8 years for soft goods and every 12–15 years for hard goods.

Category 10: Market intelligence and risk

The first document institutional investors ask for is a Feasibility Study by an independent hospitality consultant, costing roughly THB 2–4 million per project. It covers market demand, competitor pipeline, tourism forecast, air connectivity and cruise tourism.

• Political Risk Political risk insurance
• Climate Risk Sea level and storms
• Pandemic Sensitivity Simulate occupancy falling by 40–60% for 12–18 months
• Currency Risk USD/THB policy when most revenue comes from foreign tourists
• Earthquake/Tsunami Zone Assessment
• ESG Reporting framework (GRI or SASB), carbon footprint baseline, community impact plan and local hiring target, for which the industry benchmarks used as reference typically set 80–85%

Document layers at Investment Memorandum level

Approximately 800–1,200 pages in total, divided into 10 layers

Priority Matrix

Critical: required before the investment decision

• EPC quotations from at least 3 firms
• HMA term sheet from the selected operator
• Bank term sheets from at least 3 banks
• Feasibility Study from an independent consultant
• EIA approval or preliminary assessment results
• Land title document review

Important: before construction starts

• Complete detailed design and BOQ
• Operator pre-opening plan and headcount ramp-up
• Annual marketing plan
• BOI application and tax documents

Enhancement: during construction

• Detailed staffing plan by position
• Technology Infrastructure Specification
• ESG framework and carbon baseline
• Risk management plan and insurance programme

Data pack preparation budget

This table is the budget for the set of work needed to bring the model to investment grade. It is not the project's total soft cost, which must be calculated from actual hard cost at 12–18% as set out in Category 1.

Conclusion

A model built on assumptions suits preliminary studies, introductory investor presentations and internal go/no-go decisions. To upgrade it for bank funding (requires a bank term sheet and a verifiable DCF), equity fundraising (requires a Feasibility Study and an HMA term sheet) or BOI promotion (requires detailed CAPEX and an employment plan), data must be gathered systematically under this framework.

The key is not the complexity of the model but the quality of the input data and the ability to trace the source of every figure, so that it passes due diligence by every party, from the bank's credit department and the BOI committee to the auditors.

Model structure and build discipline

Once the data is ready, the model should have clearly separated functions: Cover, Assumptions, Sales Schedule, Construction S-Curve, OPEX, Debt, Tax, 3-Statements, Returns and Dashboard.

Model Audit Checklist

• No hard-coding in formulas, and every input in one place only
• Assets equal liabilities plus equity in every period
• Closing cash on the balance sheet matches the cash flow statement
• Scenario toggle works and error checks are zero everywhere
• No unnecessary circular references, especially in the interest calculation
• Record the version and change log, e.g. Project_Model_v1.0_YYYYMMDD
• Passes a 3-level review: self-review, peer review and independent review