5-Year Pub P&L Projections
Budget: £10 – £20 GBP
I need a clear five-year profit-and-loss projection for a medium-sized pub that seats between 50 and 150 guests. Our only revenue stream for now is food and drink sales, so every assumption should revolve around menu pricing, average spend per head, seasonal footfall and cost of goods sold.
Please build the model in Excel (or Google Sheets if you prefer) with the formulas left visible so I can test different scenarios later. I want annual summaries backed by monthly tabs that show sales, direct costs, labour, overheads, depreciation and net profit. Sensitivity tables on at least two key drivers—average cover count and beverage margin—will help me see the upside and downside quickly.
Deliverables
• Editable Excel workbook with five-year P&L, monthly and annual views
• Clearly stated assumptions section and change-driven calculations (no hard-coding in the results)
• Two-way sensitivity analysis on cover count and gross margin
• Brief walkthrough note explaining the structure of the file and how to adjust assumptions
I’ll mark the job complete once the numbers reconcile, calculations are traceable, and the sensitivity tables recalculate accurately when I tweak the inputs.
Please build the model in Excel (or Google Sheets if you prefer) with the formulas left visible so I can test different scenarios later. I want annual summaries backed by monthly tabs that show sales, direct costs, labour, overheads, depreciation and net profit. Sensitivity tables on at least two key drivers—average cover count and beverage margin—will help me see the upside and downside quickly.
Deliverables
• Editable Excel workbook with five-year P&L, monthly and annual views
• Clearly stated assumptions section and change-driven calculations (no hard-coding in the results)
• Two-way sensitivity analysis on cover count and gross margin
• Brief walkthrough note explaining the structure of the file and how to adjust assumptions
I’ll mark the job complete once the numbers reconcile, calculations are traceable, and the sensitivity tables recalculate accurately when I tweak the inputs.