Indoor Golf Business Model

Description
This template is a detailed and user-friendly financial model that takes into account the specifics of an Indoor golf business case, but it also can be used to assess the viability of similar business such as traditional bowling alleys, miniature golf, bars, lounges, etc.
The model assumes the revenues will be derived from hourly leases of golf simulator stations and from the supporting sales of food and drink.
To project the revenue, the model takes into account key assumptions such as utilization of the available hours, hourly rates (differentiating between daytime, evenings, weekends and weekdays) , and the average food & drink order per person. For expenses, the model uses a combination of fixed and variable costs, and then generates the three financial statements as well as the relevant metrics of the business.
The model allows the user to develop scenarios based upon the variation of key metrics, namely utilization rates, prices and operational costs variation. After modeling the scenarios, the user can make a comparison of different scenarios side-by-side.
The template is monthly in nature, and it is a 100% unlocked Excel file with fully transparent formulas that can be further tailored to suit your particular needs.
The user only needs to input information into the cells formatted in the dark blue font in the Assumptions sheet, any other formats are formulas or labels.
For demonstration purposes, the template is provided with information from a hypothetical business model for an Indoor Golf Lounge. The data must be erased/adjusted to fit the user's needs.
The maximum horizon for this model is six (6) years.

Model Structure:
 
Intermediate Sheets (calculation sheets):
•         Revenue Model: The revenue is projected in this sheet using an easy to follow logic (Usable hours -->  utilization rates ---> hourly rates --->  revenue);
•         Staff: Calculation of Wages & salaries based on the hiring plan set in the assumptions sheets, 
•         Debt Model: The user can model up three loans and a revolver facility to cover any cash shortfall (the inputs for the debt are all inputted in assumptions sheets)
•         Capex: In this sheet, based on the inputs set in the assumptions sheets, the investment and depreciation are calculated on a monthly basis;
•         Working Capital: Calculation of the working capital requirement by using the collection, payment, and duration of storage period assumptions.
Outputs:
•         Executive Summary:  Summary of the main KPIs, main drivers and Dynamic Charts
•         Cases Overview:  In this sheet, the user can analyze all the scenarios side-by-side (the user must run the macro to update the scenarios)
•         Yearly Financial Statements: Yearly P&L, Balance sheet, and cash flow
•         Monthly Financial Statements: Monthly P&L, Balance sheet, and cash flow
•         Cases Overview: In this sheet, the user can analyze all the scenarios side-by-side (the user must run the macro to update the scenarios)
•         Business valuation using DCF method