On the sheet, you'll see we've placed a number of services and a monthly membership as examples. We've pre-populated some numbers and formulas, but you can change the names of the services to match what you offer and replace the values with your own numbers. Be careful not to replace or delete the formulas in the cells that calculate for you, or you'll need to copy the original template and start over.

The top row is where you'll type in your specific services. Let's look at the first Column B as an example:

Next you’ll Calculate Profit and Targets
Row 7 of each column/service calculates the profit per booking after deducting your expenses.

In Row 10, the profit calculator will automatically show you how many sales of this service you need to make per month to hit your target.

Now, let's look at the far-right column for memberships. This part is a bit more complex but equally important.

The far right cell will calculate your revenue before expenses and then subtract your monthly expenses to show your revenue after expenses in 6I.

You'll see the profit per booking (7G) and the number of members needed to reach your target profits (10G).

And there you have it—a comprehensive guide to using The Stylepreneur Profit Planner & Rate Calculator. By understanding and adjusting your service prices and memberships, you can ensure that your business is both profitable and aligned with your goals. Remember, the key to success is continuous adjustment and knowing your worth.

After setting your prices, enjoy a complimentary 30-Minute Pricing Review with either Sarah or Erin.