How Does it Work?

It is so simple!

The system is an essential tool to help ensure your business venture will be successful and profitable. With the capacity to manage up to two years of financial forecasts, the software can be used not only when starting or buying your business, but just as importantly, for your ongoing budgeting and business planning needs.

I have modified this software hundreds of times, spent thousands of dollars with Accountants, Bookkeepers and Spreadsheet Specialist in getting it to work specifically for operating your hair or beauty business.

$ 42.50 UD

Buy from 2CO

User friendly!

The spreadsheets have been designed so as to be user friendly. All reports in the workbook are linked, meaning data is only ever entered once. The software automatically recalculates the effect of any changes made in one section throughout other linked spreadsheets.

The software is unique in its ability to forecast sales and profitability of individual products & services with differing margins. For salons which have both high and low margin products, the “sales mix” of these products can dramatically affect overall profitability.

The format of the software enables you to input your set-up costs, monthly expenses, cost and selling prices for each product or service, and individual monthly sales forecasts. The information you include in these sections will help you to prepare full financial statements for your business including monthly profit & loss statements, monthly cash flow projections, and balance sheets. It is imperative the figures you put into the program are both realistic and accurate to ensure your projections are viable and achievable.

The system has six industry specific worksheets that follow with five critical reporting pages.

The “SMART SALON BUSINESS PLAN SOFTWARE”

What's In The System?

Worksheets Included	Reports Included
Set Up - Worksheet	Balance Sheet - Worksheet
Start Up Expenses - Worksheet Expenses - Worksheet Components - Worksheet Products & Services - Worksheet Sales – Worksheet	Profit & Loss - Worksheet
Expenses - Worksheet	Cash Flow Statement - Worksheet
Components - Worksheet	Tax Calculator - Worksheet
Products & Services - Worksheet	Tax Table - Worksheet
Sales – Worksheet

Worksheets

Set Up - Worksheet

The “Set Up” tab is where you will start.

In this spreadsheet you simply enter the business name, along with the year and month you plan on starting the business. The month and year you nominate will be automatically transferred to every other spreadsheet in the workbook, and you will be able to forecast and estimate figures over a period of two years from that time.

Start Up Expenses - Worksheet

This sheet allows you to calculate the financial requirements of starting your business. By entering values for the necessary items, you can calculate the total cash outlay required to start the business. You can also list your sources of finance in this section, and if you elect to spread your start up expenses over a period of time you can allocate them accordingly.

Expenses - Worksheet

In this section you can estimate the costs you will incur on a monthly basis in running your business. Expenses of an ongoing nature can be broken into two groups – fixed and variable costs.

Components - Worksheet

This sheet allows you to list over 50 items. Fill in the details for each component including the

1.The component description, e.g., “Shampoo and Conditioner” used on each client:

2.The ‘Buy Price:

3.Quantity purchased, e.g., the number of these units used on each client:

4.Unit description (just for your reference):

5.Percentage waste factor:

Products & Services - Worksheet

The products and services sheet makes it possible for you to analyse the individual products/services you offer to your clients, using the component details from the previous section. This will give you the total cost of producing the product or service, allowing you to see the gross margin on each item you sell.

From this information, the program will calculate the gross profit margins and percentages for each product or service your business intends to sell, and changes can be made accordingly.

Sales – Worksheet

Here you can estimate the quantity of each product you will sell each month over a period of two years.

Balance Sheet - Worksheet

The Balance sheet brings together various details from previous worksheets to itemise your assets, liabilities and owner’s equity in order to give you an indication of exactly how your business plan is going to pan out.

Profit & Loss - Worksheet

This report is the first sheet that does not require any user input. This is where your prior approximations of expenses and cost of goods can have a big bearing on the position of your business. Gross profit, net profit, cumulative profit and revenue percentages.

Cash Flow Statement - Worksheet

The cash flow sheet shows cash received and cash disbursed, and the sources for each, as well as the cash balance for each month of your forecast. You will be able to tell which months are going to require additional cash, and you can adjust items as you see fit.

Tax Calculator - Worksheet

This will automatically use the current tax tables issued by your taxation and revenue department, this will give you an accurate understanding of your taxation liability and commitments.

Tax Table - Worksheet

This table displays the most up to date taxation threshold figures, all you need to do is add the relevant figures provided by your taxations or revenue department.