Hospitality Financial Model - (Safari Lodge / Resort Project)

I am seeking an experienced hospitality financial analyst to assist with building an independent preliminary financial model and underwriting review for a proposed safari lodge / resort development project in East Africa (Kenya, Maasai Mara region).
This is NOT a standard real estate development model and not a residential or commercial property exercise. I specifically require someone with demonstrable experience in hotels, resorts, lodges, serviced apartments, or hospitality asset underwriting.
To build a realistic, flexible and transparent Excel-based financial model that evaluates the commercial viability of a proposed 16–24 key safari lodge (likely ~20 keys) including:
• Revenue modelling
• Operating cost structure
• Management/brand fees
• Capital expenditure
• Investor returns
Scope of Work
Initial Consultation (important)
You will first review a short project overview document and discuss assumptions with me via a video call) . You should also challenge my assumptions where necessary.
Revenue Model
Build a hospitality-style revenue model including:
ADR (Average Daily Rate)
Occupancy ramp-up over 5–10 years
Seasonality (high/low safari season)
Ancillary revenues (F&B, beverages, activities, spa, guiding, etc.)
Stabilised year assumptions
Operating Cost Model
Prepare a realistic operating cost structure appropriate to a remote lodge environment, including:
staffing (high service ratio environment)
food & beverage cost
utilities (power generation, water, fuel logistics)
maintenance
insurance
distribution & marketing costs
Hotel Management Agreement Assumptions
Incorporate typical hospitality operator/brand fee structures:
base management fee
incentive fee
central reservation/marketing contributions
pre-opening and technical service fees (modelled or amortised)
Capital Cost Inputs
I will provide estimated development cost ranges. You should structure these into:
hard construction costs
infrastructure
FF&E
pre-opening costs
contingency
Financial Outputs
The model should generate:
annual cash flow (10 years)
EBITDA/GOP
owner cash flow
IRR (equity)
NPV
break-even occupancy
sensitivity analysis (ADR vs occupancy vs cost)
Sensitivity Analysis
Very important:
Model how returns change if:
ADR is lower than expected
occupancy fluctuates
costs increase
operator fees vary

Deliverables
• Fully transparent Excel financial model (not locked)
• Assumption sheet (clearly editable)
• Scenario analysis (base / conservative / optimistic)
• written commentary explaining key drivers and risks

must be grounded in real hospitality operational logic rather than generic real estate modelling.

I am looking for someone who can also provide professional judgement and question assumptions, not simply populate a spreadsheet. Please include your availability and relevant experience in your response. I expect this project to be the first of several hospitality and development-related analyses. I would ideally like to establish a longer-term working relationship with a consultant who understands my projects and can assist with future modelling, scenario testing, and investment analysis on an ongoing basis.
Consistent availability and the ability to work together over time will be valued when selecting a candidate.