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.
Users who purchased Hair / Beauty Salon Financial Model, also purchased:
|Industry||Financial Model, Retail|
|Summary||Plan out the financial side of your new hair salon / beauty outlet. The business plan goes up to 10 years and has plenty of granularity.|
|Screenshots / Pictures||
|Use Cases||Amortization, Break-even, Business Valuation, Cash Flow Analysis, Cash Flow Projections, Cash on Cash Yield, Cash-on-Cash, CFO, DCF, Debt, Debt Amortization, Debt Schedule, Debt Service Coverage, Financial Feasibility, Financial Modeling, Financial Projections, Financing, Forecast, Forecasting, Franchise Model, IRR, NPV, Pro-Forma, ROI, Sensitivity Analysis, Startup, Startup Business Model, Terminal Value, Valuation|
Let me tell you this, you have done a great job in explaining the overall model for the Hair/Salon store. The article is written in a super easy language and even a layman can understand it very well.
4 OUT OF 5 STARS from my side to this amazing review. Keep up the good work.
Help other customers find the most helpful reviews
Did you find this review helpful?