NEW Version updates
-Commission based Employees have been included in Payroll calculations
-Option to calculate income from booth rentals has been added to the Scenario Tab
Highly-sophisticated and user-friendly Hair and Beauty Salon financial model providing advanced financial projection for a 5-Year Business Plan.
This template is a flexible tool for owners/CFOs of a Hair and Beauty Salon and is suitable for all stages of the business cycle (start-up, early-late stage, maturity). It includes all necessary data needed to forecast the company’s financial and operational activities, business valuation, and professional presentation through charts & graphs.
The model is fully customizable and is designed for a wide variety of users, from those with little or no accounting or Excel experience to those who may be well versed in finance, accounting, and the use of Microsoft Excel.
The template includes Input Tabs (Gold color) and Output Tabs (Dark-Blue Color).
Users must fill in only the cell formatted as Gray Fill- Blue Font included in the Input Tabs.
1. Salon Setup
4. Fixed Assets Depreciation & Loan Amortization
5. Service Cost Breakdown
6. Sales – Cost of Sales
7. Service Profitability Analysis
1. First Year Monthly Financials (3 Statement Model)
2. 5-Year Forecast (3 Statement Model)
3. Financial Ratios (KPIs) Dashboard
4. Charts and Graphs
5. Business Valuation
6. Executive Summary
Detailed instructions on the use of the model are included in the Excel File.
For any inquiry/modification, please contact me via: [email protected] or you can also use the contact button.
Our customers were also interested in...
My wife and I are in the process of opening our first salon. I am a numbers guy, I have to see it to believe it. I went back through all the financials and I was just overwhelmed with numbers and calculations. I had all of the data, but couldn’t make sense of the data. I found this tool and it is exactly what i needed. A highly sophisticated tool to look at all the details to map out the next 5 years. Two adjustments were needed which were taken care of imediatly. I highly recommend this!!
1 of 2 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?