Hair Salon Chain Financial Model Excel Template by Henry Sheykin - Financial Models https://finmodelslab.com/ Last version published: 08/05/2019
COVER PAGE
Here you may input a name of the model.
2
TIME SERIES INPUTS Financial year end in the model - input the last month of the financial year. If you don't need to assume for the financial years, simply type in Dec. First Financial Year in the model - input the very first financial year you want to start from. If you have entered Dec in the Financial year end in the model, then, your calendar year equals the financial year.
3
DASHBOARD
4
DASHBOARD
Top Left Side: Core salon assumption - in this table you have the option to enter ten names of your salons. Then input some salon launch assumption and revenue assumption for each salon. Extra product assumptions - you can enter three additional products that you sell in your salon and some assumptions about them.
5
DASHBOARD
Top right side: In order to correctly forecast the inventory level, you should enter a safety stock assumption. The corporate tax rate is a really important indicator. So you definitely must input it.
6
DASHBOARD Top Center side: Debt assumption - here you have the option to enter 3 debt and a grant. For a grant, you just need to input an amount and select launch date. Output Currency - insert the currency sign $/€/ ¥/£ or type in USD/EUR/GBP or any other abbreviation. Denomination - use denomination if you want to show outputs in thousands, millions or billions. Currency exchange rate - enter the currency
7
Salon General Expense assumptions
8
Salon wages assumption - you have to input FTE per salon, annual salary, monthly bonus, tax rate and annual salary raise per position. Core Expense assumption - here you may enter monthly rent&utilities, monthly cleaning and other monthly expense individually for each salon. The Average Store Fixed Expenses assumptions section is about fixed expenses list, amount, periodicity, launch/end
Salon General Expense assumptions
9
On this sheet, you can see two group of tables. The first about company level capital expenses and the next one is about average salon capital expenses. You have to give a name of categories, choose payment delay, input amount and choose how this amount is going to be paid. One-time when the company set up or, one-time when new salon setup or, each time new stylist/receptionist hired.
Head Office Fixed Expenses & Wages
10
Head Office Fixed Expenses & The wages tab allows to easily calculate salaries for head office Wages staff categories.
11
Use 1 line per employee/category, and simply type in the hire date, fire date, and annual salary. "Next, use the head offie staff numbers section to type in FTE count for each year individually.“ An increase of FTEs means that you are going to hire additional FTE's. In case of decrease FTEs means you fired some FTEs. New FTEs will be hired/fired on Jan of the relevant year. "If there are raises or changes in salaries, simply type in the annual Salary raise per position in the appropriate columns.
In addition, you should input some assumptions about head office fixed expenses: - category, - amount,
The model will automatically calculate this cost going forward until the fire date.“
- periodicity, - launch date, - end date and
Finally, Monthly bonus as a % of monthly salary can be applied to every line as well as personal tax can be applied on top of
- yearly growth rate.
Variable Expenses
Enter in the list of variable expenses you want to forecast in the rows Variable expense. And type in the percentage of revenue to be spent.
12
Capitalization Table
13
Cap table require some manual manipulation to make accurate.The structure enables you to make the necessary modifications.The Cap Table model takes you through multiple rounds of financings. Showing how issued shares to new investors and cost per share impact the investment received. After each round, you will see the ownership, % changes. This is how dilution works.
Financial Statements Summary
14
The Summary sheet is a Summary of the key financial reports of the model. Moreover, you have the options to select the year to see detailed outputs.
Valuation The model can do the valuation of distribution of current cash flow to Investors Discounted Cash Flow, and valuation based Perpetuity Growth method.
15
Financial Charts
Here you can visually track key financial performance over five years or 24 months.
16
Operational Charts
At this tab, you can track some internal operational indexes that can be useful for analysis of the internal activity of the salon chain
17
Thank you very much for your interest in my tools! If you enjoyed using my model, please let people know about your experience! Give 5-star feedback here & share this page across social networks If you have any suggestions or ideas of how to make this model more useful, don't hesitate, just send me a PM - Henry Sheykin