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.
Apartment Conversion for Increased Rental Income Category: AutoCAD, Building Architecture, Building Regulations, Construction, Construction Management, Home Design, Interior Design, Project Management Budget: $750 - $1500 USD
4K Creative Promo Video Edit Category: After Effects, Animation, Color Grading, DaVinci Resolve, Final Cut Pro, Video Editing, Video Services Budget: $30 - $250 USD
