Entertainment, Financial Model, Game Centers & Arcades, Hospitality, Sports & Fitness, Tourism & Attractions, Wellness

10-year Financial Projections, Accounts Payable, Accounts Receivable, Average Order Value (AOV), Break-Even, Budgeting, Business Valuation, Cash Flow Analysis, Cash on Cash Yield, Cost Calculation, Cost Projections, Crew Planning, Dashboard, DCF Model, Debt Security, Debt Service Coverage, Discount Rate, Financial Debt, Financial Model, Financial Ratios, Financing, Forecast

This template is a detailed and user-friendly financial model that takes into account the specifics of an Indoor golf business case. Still, it also can be used to assess the viability of similar businesses 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 the supporting sales of food and drink.

To project the revenue, the model considers key assumptions such as the 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 users to develop scenarios based on the variation of key metrics: utilization rates, prices, and operational costs. After modeling the scenarios, the user can compare different them 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.

The template provides information from a hypothetical business model for an Indoor Golf Lounge for demonstration purposes. 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 the DCF method

File Versions:
1) Excel Template – 1 full Excel Model Template (.xlsm) & 1 Macro Documentation (.pdf)
2) PDF Demo – 1 PDF model template preview / demo (.pdf)