Saturday 2 October 2010

Business Plan Financial Projections: Stop Worrying About Being Right ...

Translate Request has too much data
Parameter name: request
Translate Request has too much data
Parameter name: request

Business plan financial projections seem daunting because

they are so uncertain. This very uncertainty, however, is

what makes preparing them easy because you can't possibly be

right. You can't predict the future. None of us can. All you

can be is competent in the way you prepare your business plan

projections.

Before you finalize your business plan this year, consider

these six caveats to preparing your business plan financial

projections:

1. Don't offer pull-out-of-the-air, "conservative"

guesstimates about getting some percentage of the overall

market demand or year-over-year growth.

It is a mistake to assume that business investors will

appreciate your being conservative with your business plan

financial projections in the early years of your business.

Don't think for a Wall Street minute that presenting

"conservative" business plan financial projections indicates

"realism" to prospective business investors. Business investors

invest for one reason: to earn a return on their money. How

long the money is invested influences the amount of the return

earned. Let's say a business investor wants to triple an

investment. Well, if that investment triples in 3 years, the

return is 44%. If it triples in five years, the return is

25%. Adding just two years to the investment period nearly

halves the return! Now do you see why time is so important

to a business investor? Here are a few other examples: let's

say a business investor wants to:

Make 5 times an investment in 3 years = 71% return

Make 5 times an investment in 5 years = 38% return

Make 7 times an investment in 3 years = 91% return

Make 7 times an investment in 5 years = 48% return

Make 10 times an investment in 3 years = 115% return

Make 10 times an investment in 5 years = 59% return

So, while you may find it attractive to figure out how to

make "just a living" until the business venture proves

itself, you now understand why business investors want sales

and earnings to grow absolutely as fast as possible, without

being deceived, in your business plan financial projections.

On the whole, business investors are risk averse only to the

extent that they don't want to lose their money or tie it up

in a low return investment. Typically when you make the claim

that your business plan financial projections are "conservative",

it usually just means that you have no idea how and why you'll

achieve a certain level of sales within a certain time frame.

Interesting, these kinds of estimates, provided that you've

done some good thinking about market segments and overall

demand, often turn out to be too low. Remember, it's just as

bad to underestimate your sales, as it is to overestimate

them.

2. Avoid calculating costs as a straight percentage of

revenues.

Sure it's easier to do things this way, especially with

Excel and other business plan financial projection software.

Costs are real, however. You need to know what they are very

specifically. If you've done your homework in developing

your business plan, then you should already have this information,

or at least the basis of it. Just estimate and calculate your

costs on a product-by-product basis.

With these warnings in mind, use the following steps to

develop your business plan financial projections:

Think about what percentage of the overall market share your

competitors already own. Assume that they will continue

their present trends in growth. (Note: some competitors may

already be trending down and losing market share.) Temper

your market share estimates with some discussion of how your

entry into the market will affect these trends. Then,

estimate the percent of total, potential demand that remains

available to you.

Now, based on the limitations of your operations plans,

calculate how much of this remaining available demand you

can achieve. This is a very simple calculation. Start with

your overall productive unit capacity and factor it by the

expected yield of sellable product, then multiply these unit

sales by their respective selling prices and voila, you have

the revenue numbers for your business plan financial projections.

Let's take an example.

Your research indicates that 2 out of every 10 females age

23 to 55 will under go some type of non-invasive cosmetic

treatment in your area. Your research also shows that this

number is expected to grow 20% each year over the next 5

years. There are 40,000 females in your target market. You

identified four competitors in your target market. These

four competitors currently handle on average 6 procedures a

day. You plan to start a non-invasive cosmetic treatment

center that uses the most advanced technology and is thus

capable of performing an average of 7 procedures a day.

Using this data you calculate the following statistics

about your market and market potential:

Total market 40,000 females x 20% = 8,000 procedures per

year

4 competitors x 6 procedures x 250 days = 6,000 procedures

per year

Available procedures: 8,000 less 6,000 = 2,000 per year

Your productive capacity: 7 procedures a day x 250 days =

1,750 or 21.875% of the total market. The average selling

price for a procedure is $400. Thus, the revenue for the first

year in your business plan financial projection would be 1,750

procedures times $400 or $700,000.

Now, let's say you're were projecting 2,200 procedures per

year. This would mean that you would have to alter your

operating plan to be able to perform 2,200 procedures. You

would also have to demonstrate how you would capture an

additional 200 procedures from your competitors.

Granted this is an over simplified example, but it should

give you a feel for how this process works.

Regarding price, in most cases you should have a clear idea

of how to price your product or service. There are usually

other, similar products or services out on the market.

Unless your competitive advantage is a cost reduction and/or

unless price is a critical basis of competition, just

estimate the value of your improvement and add it on to the

average price currently offered in the marketplace. In order

to make this estimate, you'll have to be talking to

potential users. Find out what they pay now. Find out how

they feel about the current price. Ask them if they'd be

willing to pay more and how much more. If you ask enough

people, you'll get a general idea.

3. Never determine price on the basis of a margin you think

is attractive.

The market will pay you only for the value you deliver,

which is determined by the consumer paying the final price.

It's easy to make the mistake of thinking that a 20%, 40% or

even a 60% margin is great. Never considering that if the

product or service you're offering provides a real

advantage. If you do this, you may be grossly

underestimating the price you can get in the marketplace and

underestimating your business plan financial projections.

Consumers don't think in terms of margins. They could care

less about what you ought, "reasonably", to get for your

product. That's why you must find out the most that they'll

pay. This is the value of your product or service. Come up

with some reasonable basis for determining this real value.

Keep in mind the obvious: If the consumer's value on the

final product or service is less than your cost plus a

reasonable profit to keep your business growing, you're in

trouble. Your business model will not be sustainable and your

business plan financial projections useless.

Now calculate the costs of manufacturing and distributing

your product. These costs flow directly from your revenues

estimates and operations plan. How much will it cost to

purchase what equipment and materials, hire what personnel,

engage in what selling efforts, pay what accountants and

lawyers, rent what kind of space and so forth, to achieve

the revenues you're showing in your business plan financial

projections. You must be very specific. Project your costs

over time. Keep them tied to the units you need to sell to

achieve the revenues in your business plan financial

projections.

Obviously, costs and revenues work hand in hand.

4. Keep your fixed cost low.

Keep in mind that none of these revenues and the cost

estimates are going to be perfectly accurate, which means

the amount of profit or cash available to pay "fixed" cost

isn't going to be accurate either. As a result, you can lose

your shirt trying to pay for equipment, a receptionist, or

other activities that don't contribute to the sole objective

of making sales. Wherever possible, rent space, rent time on

equipment, answer your own phones, etc. To the extent that

you keep costs variable in your business plan financial

projections, you can cut back when sales are slower than

expected. It's the worst situation to have a big,

well-furnished office with an expensive secretary who

needs the job, when the money isn't coming in. High fixed

costs in your business plan financial projections also send

the wrong message to investors that you know more about the

"form" of doing business than about actually making money.

Now pull all your numbers together to prepare the financial

statements that summarize your business plan financial

projections. You need three basic statements: cash flow

analysis, income statements, and balance sheets. All of

these come directly from the above calculations. Your cash

flow analysis indicates when and what amounts of capital

infusion you'll need to start and sustain your business plan.

Make your income and balance sheet projections on the

assumption that you'll get the capital. For the first year

or two of your business plan financial projections, present

each of these statements on at least a quarterly basis.

Monthly is best. I suggest doing a 24- or 36-month projection

depending on your growth plans and changes in the industry that

you foresee. Follow these monthly or quarterly projections with

annual projections till you cover a span of 5 years.

Finally, run through some "what-if" scenarios or sensitivity

analysis. Though you business plan financial projections should

be based on your best, and best-supported estimates of costs

and revenues, you know you can't be 100% right. That's why it's

important to identify those elements or assumptions of your

business plan financial projections that you feel are most

uncertain. Write out the nature of the uncertainty and the range

you think the estimates will fluctuate up or down. Then change

the estimates accordingly and re-run all your statements.

Pay close attention to how your business plan financial

projections, especially cash flows, change when you change

each assumption. This will help you determine how much

"cushion" you have available and, if business isn't going

according to plan, at what point cash will become an issue.

5. Do not simply assume that costs and revenues may be

"off", up or down, by some percentage.

Again, I know that Excel makes it easy to do this. For all

the same reasoning as above, stay focused on the assumptions

and details that make up your business plan financial projections.

It's the details you need to examine for their sensitivity and

their impact on the bottom line. You only need to alter those

specific items that you're most uncertain about. If it's revenues

that you're worried about, is it the price, the volume, or

both that concerns you most? How big a swing in the estimate

are you worried about, in what direction and why? If it's

your cost projections that are keeping you awake at night,

which cost elements and why? Things like rents and labor

costs can be determined fairly accurately. But maybe you're

unsure about materials or labor availability or how

efficiently you can produce your products or provide your

services. Maybe you'll have to pay extra to ensure their

availability. This kind of thinking forms the basis for running

"what-if" or sensitivity analysis on your business plan financial

projections.

6.Do not include every possible business

plan financial projection scenario in your business plan.

Both you and your investors need to know what aspects of the

business plan financial projections are most uncertain,

represent the most risk, in what direction, why, and how

they affect the bottom line. Having hundreds of alternative

scenarios to sort through is like a man with two watches

showing two different times... he never knows what time it is.

Lots of alternative business plan financial projections also

indicate that you're not too sure about anything. This is an

impossible way to communicate with business investors, manage

your business, or make important decisions. It's much more

effective to identify the risky areas of your plan, tell why

and how they impact the bottom line and what actions you

plan to take if they occur. This helps you and your business

investors stay focused on the high impact areas and to think

clearly about whether other factors should be considered as

well. It also lends more credibility to your talents and

increases the likelihood of your plan's success.

Finish this discussion with a summary of the critical

aspects of your plan and related contingency plans. If

you've followed all these steps, then you can figure out

what you'll do if your actual performance turns out to be

different than your business plan financial projections.

Remember, you're purpose is to demonstrate to business investors

that you're competent; worrying about protecting their investment

and running a business, not just flying by the seat of your pants.








Mike Elia is a chief financial officer and an advisor to venture capitalists and leverage buyout specialists. For more information about business plans and raising capital for your business or to review his business plan manual, visit Business Plan Secrets Revealed.


No comments:

Post a Comment