Hotel-Restaurant Proforma for 71 Keys

I need a complete, investment-grade financial model that covers both the 71-key hotel and its accompanying restaurant for a new build in the United States. The workbook should lay out clear revenue forecasts, operating expenses, and profit margins for each component, then roll them up into an overall project view that an investor or lender can immediately grasp.

Please structure the model in Excel (or Google Sheets if that is your normal workflow) with transparent, editable assumptions. Separate operating statements for the rooms division and the F&B outlet, followed by a consolidated P&L and cash-flow summary, will make review easier at my end.

To be considered, share past work that demonstrates your experience building hospitality proformas; screenshots or redacted files are fine. If our approaches align, I will provide brand positioning details, proposed ADR, occupancy ramp-up, seating counts, and cap-ex figures so you can finalize the model.

Key acceptance criteria
• All formulas visible and un-locked
• Year-one monthly detail, then annual projections to year ten
• Clear KPI outputs such as ADR, RevPAR, GOP%, NOI, and F&B cost-of-sales
• A one-page dashboard summarizing hotel + restaurant performance

I look forward to seeing examples of models you have produced for similar U.S. projects.