Hotel & Restaurant 7-Year Proforma

I need a comprehensive Excel proforma for a new hotel with an integrated restaurant, covering a full seven-year hold from groundbreaking to exit. The workbook must handle the development build-out phase, annual ramp-up, and stabilized operations while keeping Net Profit Margin as the headline metric throughout every schedule.

Revenue growth has to be broken down by department—Rooms and Food & Beverage—so I can adjust ADR, occupancy, covers, and check averages independently. Other revenue streams can be grouped, but these two need separate, clearly linked growth schedules that roll into the consolidated P&L.

Please base your build on an industry-specific template that reflects standard USALI hotel statements and restaurant cost structures rather than a generic layout. The file should be fully unlocked, cleanly laid out, and ready for lender or investor scrutiny.

Deliverables
• One Excel model (.xlsx) with monthly detail rolling to annual summaries for seven years, showing revenue, departmental costs, GOP, EBITDA, cash flow, and residual sale proceeds
• Development tab outlining land, hard/soft costs, funding draw schedule, and interest during construction
• Assumptions tab with color-coded, clearly labeled inputs and scenario toggles
• Sensitivity analysis centred on Net Profit Margin
• Brief PDF or on-sheet notes explaining model logic and key cell references

Acceptance Criteria
All statements reconcile; Net Profit Margin and cash-flow totals match across tabs; input ranges can be adjusted without errors; and the workbook’s structure is easy to audit.

If you have recent experience building hotel or mixed-use hospitality models and are comfortable with dynamic Excel tools such as data tables and lookups, I’d love to see your approach and timing.