Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
  • Hair Salon - 10 Year Excel Financial Model
Originally published: 10/03/2018 16:30
Last version published: 12/10/2018 10:02
Publication number: ELQ-67482-7
View all versions & Certificate
certified

Hair Salon - 10 Year Excel Financial Model

A financial planning tool designed specifically for the logic needed to project revenue and costs for a hair salon.

barber shopcash flow projectionfinancial forecastfinancial modelhair salonirrpro formaroisensitivity analysis

Description
The model goes for a period of up to 10 years.

You can start building your business case in the light yellow tabs.

Note that you don't have to fill in everything, only fill in what makes sense for your future plans.

On the 'control' tab, you will begin by entering the start year, your scenario (low/base/high), any financing and the month you plan to exit as well as the valuation multiple. Additionally, this area allows you to turn an entire income stream on or off.
The scenario part, will adjust the head counts / products sold count / services sold count that exist on the 'revenue base' tab that you enter.

This is a nice way to set a base and then easily hit a button to control if you do a given % better or worse than that without having to re-set all the numbers.

The 'Revenue Base' tab is where you build up the 3 main revenue streams. You can pick the month in your forecast that each item begins (for ramping purposes) and choose the price of each item line as well as the monthly count of sales over the course of 10 years.

Don't do anything on the 'rev1' tab. It is where all the formulas are to easily adjust your base assumptions based on the scenario chosen.

The 'Costs' tab has 4 main modules. They include the startup costs, which are costs inherent to starting the business. You also have running monthly costs and on those you can pick the start month as well. Then there is the CapEx, which would be any projects you plan on doing in the future that will cost money. It could be a renovation, new equipment purchases, or what have you.

The monthly and annual P&L's are where the data from your input tabs aggregate. The monthly will show all the various revenues per each hair cut type / other services revenue types / and other product revenue. It will also display the monthly costs / variable costs, give you an EBITDA and go all the way through to your exit valuation, loan payback at exit, and debt service.

The 'financing' tab will populate from the 'control' tab based on those financing inputs and this is a simple amortization schedule that feeds into the P&L's accordingly.

This business tool includes
1 Excel template and 1 tutorial video

Acquire business license for $45.00

Add to cart

Add to bookmarks

Discuss

Further information

Test out various assumptions within the context of operating a hair salon in order to see the resulting cash requirements / financial projections.

When you are trying to forecast cash flow for up to 10 years, including an exit scenario at any month within the 10 years.

A business that does not have similar revenue and expense logic as a hair salon.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Jason Varner

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Hair Salon - 10 Year Excel Financial Model?

The user community and author are here to help. Go ahead!

please wait...