Tweet

How to Build Quality Financial Projections

Written by: Donovan Wadholm

Article Overview: “Financial projections are part art and part science”. So what does that mean? It means that you won’t know 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. Find out how to get them done in this article.

How to Build Quality Financial Projections

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 I answer “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 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 intern 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 particularly 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 stand alone 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. 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!

Or if you just can’t seem to find the answer you are looking for, ask me! I am always happy to help an entrepreneur in need!

Good Luck
Mr BizPlan

Related Articles
  Part 8: Financials
  Which Business Plan Software is For Me
  Writing The Plan
  How to get bank funding in five essential steps
  Business Plan Key Elements

Article Tags: assumptions, banks, boiler plate, business plan, educated guess, entrepreneur, financial projection, financial projections, hell, investors, money, science, wag, wild ass



Related Forum Posts
How to valuate a business - Hi Garth - here is how we did it at Northern Crown Capital when I was helping them raise venture capital for Toronto-based entrepreneurs. Assume the start date is 2003 so 2008 projections are 5 years out: How Northern Crown Capital Valuates a Business 2008 Financial Projections Earnings Before Tax $5,865,000 Tax Rate 42% Taxes $2,463,300 Net Earnings $3,401,700 Amount Seeking to Raise Today $3,500,000 Discounted Value of Future Opportunity, 5 Years Out 2008 P/E Ratio 15 Value of Company in 2008 $51,025,500 Discount Rate Applied 30% Year 2008 $51,025,500 Year 2007 $35,717,850 Year 2006 $25,002,495 Year 2005 $17,501,747 Year 2004 $12,251,223 Value of Company at Investment in 2003 $12,251,223 Less: Investment Amount $3,500,000 Present Value $8,751,223 Discount for Risk & Private Company 40% Less: Discount for Risk & Private Company $3,500,489 Private Company Value $5,250,734 Present Value (What the Owner Keeps) $5,250,734 60.00% Financing (What the Investor Gets) $3,500,000 40.00% Total $8,750,734 100.00% I hope this helps!
Future Financial Corporation - I've never heard of Future Financial Corporation is this a new company?
Re: Great start, but no finish - My advise is FOCUS on your business. Focusing is the main factor to succeed on business. If you have a great idea, then follow it only, don't look anywhere else. It is especially essential in an online business. Because there are a lot of mind blowing sales letters promising millions dolllars or overnight success, people find it difficult to concentrate on one business and they lose their energy. Concept is simple. 1- Have a good idea; 2- Build your business on it; 3- Monetize your business; 4- Promote it; 5- Build list of responsive customers; 6- Maintain You Business. Focusing and not fearing from competition (instead you can learn from competitiors) are main tips of billionaires ,BTW. Orxan
Re: What makes a good sales rep? - Quality of a good salesman. Believe in yourself Know your product like the back of your hand Resufe to take no for an answer Be passionable about your product
Re: How to do Link Building? - Be diligent. Build blogs.Pay attention to the contents.


Share this article with your friends. Fund someone's dream.

Leave a comment below or share on the left and you'll help support entrepreneurs in Africa through our partnership with Kiva. Over $50,000 raised and counting - Please keep sharing! Learn more.

Tweet

Newsletter

Get advice & tips from famous business
owners, new articles by entrepreneur
experts, my latest website updates, &
special sneak peaks at what's to come!

Name:
Email:

Popular Articles

Bootstrapping Your Start Up Business.

Building a Business From 30,000 Feet

How To Be Happy at Work? Acknowledge Yourself

Suggestions

Email us your ideas on how to make our
website more valuable! Thank you Sharon
from Toronto Salsa Lessons / Classes for
your suggestions to make the newsletter
look like the website and profile younger
entrepreneurs like Jennifer Lopez.