Zoo / Park / Aquarium - Construction and On-Going Operational Cash Flow Model

This model includes financial assumptions and logic specific to constructing and running a Zoo or similar operation.

by Jason Varner
smarthelping.com - Financial Modeling for EveryoneFollow 151

220 views|Start the discussion!|Bookmark Add to cart - $70.00

Description
The nice thing about this template is all of the granular assumptions that will allow for a more precise projection of the cash flow happenings that come along with constructing and running a Zoo / Aquarium / Park.

There are up to 10 modules that allow the user to show the on-going costs per exhibit module. There are three main cost areas. They include:
- Cost per animal (on a daily / monthly / annual basis).
- General monthly costs per exhibit.
- Startup construction costs.

The on-going animal costs can change across each of the 5 years and you can pick the months construction is planned to take place and the month animals are moved in. This will dynamically effect the overall cash flow in the monthly and annual summaries.

There are also separate assumptions to account for general park-related on-going costs and other one-time startup costs related to the park itself as well as potential future capital expenditures in a given month over the 5-year plan.

For revenues, there are multiple streams. The user can pick the opening month of the park and the estimated annual visitors and include an annual growth rate for visitors.

There is logic to account for seasonality if the park plans to have more visitors in certain months and less in other be defining a % in each of the 12 months of the year and that will define the amount of annual visitors that flow into that month.

There are 3 pricing tiers to account for adult, senior citizen, and children ticket prices. If that doesn't apply you can just use one of the slots or two and zero-out what is not applicable. The user can define the % of visitors that make up each type of ticket buyer.

Most Zoos and parks get funding from donors and the government so I have assumptions for annual contributions of both sources as well as startup donations.

A separate tab was setup for staff costs and you can define the start month of each staff type, their annual salary, and their count across 5 years.

In general, all of the above assumptions will work together to show the startup and monthly cash flows (in and out). This gives a good sense of the amount of funding needed over time.

Plenty of visuals were also added (charts/graphs) to help see what the result of the assumptions are.

Because these kinds of organizations are often non-profits, certain things were not done (like investor distributions and the naming of key line items).

This Best Practice includes
1 Excel template and 1 tutorial video