The yellow cells are for your inputs.
Sheet protection is enabled, but you can disable it to edit all formulas and cells.
No macros were used, so no problems from this side.
See the Screenshots and download the free PDF Demo for more information.

The idea of this financial model is a golf range with a restaurant, as the concept of Topgolf in the USA. The model assumes to set up a building with golf bays and a restaurant. The concept lays the focus more on entertainment and fun and less on golf itself. Many customers will be non-golfers, that just want to have a good time. Customers can rent golf bays by the hour, that are well equipped with furniture, monitors, and golf equipment, and they are encouraged to consume food and drinks directly in the bay.

Includes the following:

Tab Assumptions
- Golf bays
- Customers per bay
- Rent per month
- Av. F&B check/customer
- Conversion F&B sales
- Utilization model & modification
- Bay utilization
- Max. Bay rental/week/hour
- Conversions for Extra sales
- Pricing
- Sales per week
- COGS
- Expenses in % of Sales
- Bay Rental Sales, F&B Sales, Extra Sales, and Customers
Tab Personnel
- Management
- F&B Personnel
- Kitchen time/meal min
- Service time/meal min
- Service time/beverage min
- Meals per customer
- Beverages per customer
- Cook salary/month
- Waiter salary/month
- Working days/week
- Cooks
- Waiters
- Cost for Cooks/week
- Cost for waiters/week
- F&B Personnel cost/week
- Further staff
- Personnel Requirements Kitchen in employees
- Personnel Requirements Service in employees
Tab Financing
- Building
- Bay Equipment
- Restaurant Equipment
- Financing
- Interest Rate
- Tax Rate
Tab Income (monthly)
- % of Base Case
Tab Income (5-year annual)
- Growth Rates
Tab Rent

You must log in to submit a review.