Black & Gold Country Club budget model

A new country club has no operating history, so a single budget number is the least useful thing you can hand someone. The model needed to project costs and revenues in a way that let assumptions be changed and the consequences read off immediately.

• Used Power Query for data preparation, so refreshing inputs did not mean rebuilding the model.
• Integrated data dynamically with XLOOKUP and VLOOKUP rather than hard-coding references, keeping the model resilient as inputs changed.
• Implemented Scenario Manager so cost and revenue projections could be compared across assumption sets instead of overwritten.
• Presented results through tables and charts aimed at the decision, not at the arithmetic.

• A budget model projecting costs and revenues for a new country club under multiple scenarios.
• Insights presented through tables and charts that made the shape of the trade-offs legible to a non-modeler.
• A structure that survives changing inputs — the difference between a model and a spreadsheet.

• Excel modeling
• Power Query
• Scenario Manager
• XLOOKUP / VLOOKUP
• Data visualization