How to Build Quality Financial Projections
How to Build Quality Financial Projections
•“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
How to Build Quality Financial Projections - To learn more about this author, visit Donovan Wadholm's Website.
Like this article? Share it with your friends
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
How to Build Quality Financial Projections - To learn more about this author, visit Donovan Wadholm's Website.
Like this article? Share it with your friends
 | |
 |
No article feedback found. |
| |
Leave Your Feedback |
 | |
| |||
|
I've created this section on my site to share some of the incredible tools that I've used to build my business. I hope you too can benefit from them and look forward to hearing your feedback on the reviews! - Visit Evan Carmichael's Website |
|||
Leanne Hoagland-SmithAre your sales where you want them to be? Will you be one of the few who achieves sales or business success or one of the many who have failed to change? Are you tired of being told you are like everyone else? Then you may find my first book on sales of interest. Be the Red Jacket in the Sea of Gray Suits, The Keys to Unlocking Sales available at Amazon or at http://www.processspecialist.com/red-jacket.htm. This book is a reflection of my no-nonsense approach to improving sales to overall business results. If you are truly committed to making sustainable changes, then I can help you secure a positive return on your investment because I focus on executable solutions not telling you the problems you already know you have. From training to corporate (group) coaching to executive one on one coaching, my approach is to assess, create awareness, build a goal driven action plan and then execute. The bottom line question is "Not do you or your employees know it, but do you or they want to do it?" Please call for a free strategy session at 219.759.5601. - Visit Leanne Hoagland-Smith's Website |
|||
Dianne CramptonDianne Crampton is an executive leadership coach, team culture consultant, author and president of TIGERS Success Series, Inc. Dianne has been helping CEO's and Executives connect their employees to their core values and goals for over 20 years using the trademarked TIGERS team culture process, which stands for trust, interdependence, genuineness, empathy, risk and success. To download a free white paper on behaviors that build strong teams and behaviors that will predictably tear them down go here. Dianne's contribution to the 2010 Pfeiffer Consulting Journal (an imprint of John Wiley and Sons Publishers) entitled TIGERS Hearted Teams is available in November 2009. Her new book TIGERS Among Us: 5 Winning Business Team Cultures And Why, Three Creeks Publishing will release in March 2010. To receive publishing discounts, subscribe to the free TigerTracks Newsletter here. - Visit Dianne Crampton's Website |
|||
Cheryl MatthynssensCheryl is a life skills coach, licensed Chemical Dependency Counselor and a 20 year entrepreneur. Cheryl's dedication to achieving a life of balance led to her expanding her teaching from the simple managing of life's daily challenges to adding financial well being as well. A direct marketer with DrinkACT, she is gaining ground in the online community with her concepts of making sure business owners, entreprenuers and employees have well rounded life styles. She opened up a small affiliate site - The Balance Guide- to help others find resources for mental and emotional well being. Visit Cheryl's blog to see more of the diversity beyond business she has began offering online at www.thebalanceguide.blogspot.com - Visit Cheryl Matthynssens's Website |
|||
|
To learn more about the Evan Elite Author Program please contact us. | |||
 | |
|  |
Subscribe to Donovan's articles
 | |
|
|  |
 | |
|
| |
 | |||||||
|
 | ||
 |
||
 |
||
 |
||
|
| ||
 |
| Have you written articles that would be of value to entrepreneurs? Become an expert on our site by publishing them! Expose yourself to a wide audience, drive more traffic to your website and get more sales! Click Here for details. |
|
|
 |
| Modeling the Masters: Learn the true secrets behind Walt Disney's business success factors & grow your company! Video produced by Phanta Media |
|
|
 |
"Learn straight from Evan how you can Make a Full Time Income (And More) from a Website"
Click Here To Learn More |
|
|
|
|
Get advice & tips from famous business owners, new articles by entrepreneur experts, my latest website updates, & special sneak peaks at what's to come!
|
|
|
 Find & Keep Profitable Clients Relationships and Referrals Instant Quotes Zero Based Budgeting Managing Growth |
|
 | ||
 |
Top 50 Blogs For Startups
Top Blogs To Watch In 2009 | |
 |
Top 50 SEO Posts - 2008
Top SEO Posts of the Year | |
| ||
 | ||||
| ||||
|
| ||||
| ||||
|
|
|
|
|
|||
|
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 and Sean Combs!
|
|
|
| ||||||||||||
| ||||||||||||
|
|
||||||||||||