Overview

The Group Training Gym Financial Model provides a 5-year
annual forecast along with a month-by-month forecast of the business for the
first year. Included in the template you will find:

·        
The Income Statement, Balance Sheet and Cash
Flow Statement

·        
An Assumptions Section with key drivers for the
business specific to a Group Training Gym

·        
Supporting Schedules Section for PPE and Debt

·        
Graphs to visually display the Monthly Cash Flow
Statement and Annual Cash Flow

First is the Assumptions sections where assumptions are
entered in the cells for the projection periods. Assumptions focus on key
drivers specific to running a Group Training Gym. Here you will see assumptions
for different membership packages, from Unlimited classes to Single Drop In
Classes. Membership/Package Sales are driven by Monthly/Annual growth in rows
10 and 11 in model; this section can be modified to manual inputs for each
month without disrupting the model. There are sections in the Assumptions for
complementary items such as Supplements and Apparel.

The Income Statement includes some onetime and recurring
expenses that are unique to a fitness studio. Expenses can be added or
subtracted without disrupting the model. The Supporting Schedules section is
all formulas that are tied to the Assumptions and 3 Statement sections, so no
editing is necessary. Lastly, the Charts and Graphs sections displays the Cash
Flow Statement and Annual Cash Flow visually. The correlating data is above the
graphs and tied to the model with formulas so they will automatically adjust to
any modifications in the model. 

All cells in blue font are input cells where custom
information can be entered. All cells in black font are formulas set to
streamline the model. Sections are grouped to condense the model to view
sections individually.

Reviews Add a review
No reviews yet

More From D'Errico Financial Services LLC

Browse our top rated business templates. See All
Multi-Family Housing Rental Renovation Model
1,810
0
The Multi-Family Housing Rental Renovation model projects monthly future cash flows from the renovation and rental of a multi-family housing…
Real Estate Development Model
1,993
0
 The Real Estate Development model projects monthly future cash flows from a development property from the purchase of the land…
Consumer Loan Model
1,869
0
The Consumer Loan model breaks down the financing structure of a bundle of consumer loans absorbed by a lender. This…
Venture Capital Financial Model
1,982
4
The Venture Capital Returns Model is used to provide an analysis into an investment return for a VC fund. This…
DCF Valuation Financial Model
2,262
0
The DCF Valuation Model builds on the 3 Statement model by adding a business valuation component for investment through the…
Private Equity Financial Model
1,980
1
The Private Equity Acquisition Model provides a business valuation of a target company for investment. The Private Equity Acquisition Model…
See All