<< Start-up Sales Projections Part 1 – Coming Soon >>

Well the summer break is officially over and school is back in session.  Welcome back!

In Part 1 we discussed developing “a reasonable range of sales” using the breakdown method which takes a market and estimates the sales based on market capture.  For some types of businesses where the potential market is too large (Nationwide/Worldwide) or is not granular enough we can use the “Buildup Method.”  The Buildup method takes your variable costs (merchandise/inventory/cost of sales), your fixed costs (rent, utilities, payroll, etc) and your average selling price per unit and figures the break even point. Once you know your break even point then it is just a matter of setting sales goals to achieve profitability.

Let’s use the same hypothetical maternity clothing store in Fargo, ND as an example.  Again the numbers in this example are not 100% real but they are pretty close and should give you a good idea of how to use this method.

The Buildup Method

The basic formula for break even point in terms of units sold is:

BEP = Fixed Costs / (Selling Price Per Unit – Cost of Goods Sold Per Unit)

Where:

Fixed Costs = Total Operating Expenses Per Month or Year

Selling Price = Average Selling Price Per Unit

Cost of Goods = Average Cost of Goods Per Unit

*Don’t forget Order of Operations – Solve the ( ) first then divide!

So, in the example above if the average price of maternity shirts, underwear and pants is $22.50 and the average COGS is $12.50 that means that the contribution margin is $10.00 per item sold.  The annual operating expenses (not including inventory of course) is $75,000 so $75,000/$10 = 7500 units or articles of clothing sold.

That means that this clothing store will have to sell 625 items a month or 144 items a week or about 20 items a day.  Alternatively we can multiply those numbers by $22.50 to determine the annual, monthly or daily sales goal to achieve break even point.  Past the point of break even every dollar of sales contributes  $0.44 to the bottom line of this business.

Because the annual break even point of this company is $170,000 the entrepreneur starting this company will have to analyze the break even point against the potential market for this type of business (determined in part 1 as $380,000 a year) is large enough to take on the risk of starting this business.  If they believe that their reasonable range of sales of $380,000 plus or minus 10%, 20% or 30% is correct then they would probably proceed with starting the business.  However if the data for the market showed a total market of only $200,000 and Break Even is $170,000 this would probably not be a good opportunity at all.

Remember, projecting sales for a start-up is not about being right…it’s about what happens if you are wrong.  Every aspiring entrepreneur should complete a scenario analysis raising and lowering sales and expenses to create a best, worst and expected scenario.  Your success in the long run and ability to stay in business is dependent on it!

<< Business Plan Templates - Startup Sales Projection Part 1 >>

Probably one of the most uncomfortable things a first time entrepreneur has to attempt is their first set of financial projections.  Frequently I hear the following:

• “Well…I don’t know how many people will buy from me!”
• “I just took a WAG (wild ass guess).”
• “This is so stupid…why am I doing this!”
• “How the hell am I suppose to know?!?”

To all of them my answer is “YOU are the expert in the business you are starting and You have to set some expectations for the banks and/or investors.”

As you may have heard, “Financial projections are part art and part science”.

So what does that mean?

It means that you won’t know really how to do them until you have done them.  Sure there are some things you can estimate based on your knowledge and experience with a particular type of business, but the rest has to come from research. And, that research, is part of the overall business plan.  In other words, the “part art” is the educated guess or the assumptions you base your projections on, which inturn is based on your expectations.  Your expectations are based on the research you completed in the written section of your business plan, that is the “part science”.

Regarding the comments above, the last one: “How am I suppose to know?!?” is peticularaly troubling. As mentioned before, you are suppose to be the expert.  But also, you should have done the research to set your expectations based on a reasonable set of (documented) assumptions.  Banks and investors will expect you to know your stuff upside down and backwards.  If you bring in a boiler plate business plan with canned financial projections, or ones written primarily by another person with numbers that you can’t explain, you won’t be getting any money any time soon.

After all that I hear:  “Well, all of that’s nice, but I still don’t know technically how to complete my financial projections.”  So here is the process:

1. Make sure you have a solid financial projection program to begin with. It can be a standalone program or excel templates but make sure the three statements (Income Statement, Balance Sheets, and Cash Flows) are interconnected.
   
2. A well researched and written business plan is a must. Every section of the business plan holds key data related to the financial statements.
   
3. Build a Beginning Balance Sheet or Sources and Use of Funds. Your Operations Plan should have laid out the assets you need to purchase to get started (Building / Equipment / Furniture & Fixtures / Inventory).  Get firm quotes from several sources on each.  Then document your funding based on sound business banking criteria including proper equity injection.  Finally, your balance sheet should “balance” – i.e. sources of funds=uses of funds (otherwise they wouldn’t call it a balance sheet!).
   
4. Build your sales / revenue projections. The data in the Market Potential section of your business plan or independent Marketing Plan will help you bracket your expectations for sales but in general, Sales projections are determined two ways: Driven from market data:  Target market size is determined in units or dollar volume and you estimate the amount of that market you can capture…bracketed by competitive factors (number, advantages, price) and industry factors (growth, decline, obsolescence). Driven from budgets:  When pursuing a broad market strategy it is better to determine break even point then estimate a sales goal to reach break even and eventually profitability.
   
5. Build your expense projection. Again, the information you compiled in your operations plan and other parts of your business plan will help you determine appropriate business overhead expenses. For example your location/building will determine your lease, utility, maintenance, insurance and property taxes.  Your inventory section will help you determine cost of goods sold and cash flow terms such as accounts payable.  The marketing section will help you budget your advertising and promotion expense.  And, your personnel section will help you forecast your salaries and wages, payroll taxes and benefits.

There is no great mystery to building financial projections.  With the right forecasting software, it can be fairly simple to do.  And now that we have demystified the “art and science” of it, you have the tools you need to get started and confidently plan the launch of your new business idea.

On a final note, you don’t have to go it alone.  There are business consultants located at Small Business Development Centers all across the country.  These counselors are usually well versed in business planning and helping your produce solid financial projections for your business.  So look them up and get started today!