Latest Updates: monthly and annual three statement model added as well as a capitalization table.
Starting up a golf course requires an investment in construction and operational reserve. This 5-year financial model was designed in an input / output style whereby the user enters assumptions about the initial investment and revenue/expenses and the output summaries will be automatically generated monthly and annual pro forma details.
To start things off, the user enters assumptions about the costs of each hole (up to 18) and land/building. Then, there are inputs for revenue. This includes two types. The first is course fees and the second is ancillary income for things such as a clubhouse restaurant. The main premise behind how revenue is generated is a capacity model where there are so many potential games that can be played in a given day based on average length of time it takes to finish a game to how much time is in-between each group of golfers.
There are also inputs for playable days per month, hours open per day, average price per round, and average players per round.
Operating expenses are populated based on a fixed cost schedule where the user configures the start month of each line item and the monthly fixed cost in each year. Up to 5 slots are available to enter expenses as a direct percentage of revenue. Other one-time capex items that happen over the course of the financial forecast and one-time startup costs not already accounted for in the construction of the holes are entered in their own schedule.
As far as raising equity for the project, up to 6 rounds are possible with a separate amount raised and valuation for each. The resulting profit share and equity splits will update as the month and amount are entered for each round that is applicable based on your funding strategy. There is a resulting IRR and DCF Analysis for each investment round as well as the remaining owner equity contribution that is required if applicable.
More summary reports were built to show yearly break even revenue, an executive summary that aggregates data from the annual pro forma detail, and a wide range of visualization.