Jump to Main Content
USA flagAn Official Website of the United States Government
Industry Word

Blogs.Industry Word

Register

How to Project Your Basic Business Numbers

Comment Count:
13

Comments welcome on this page. See Rules of Conduct.

How to Project Your Basic Business Numbers

By Tim Berry, Guest Blogger
Published: April 24, 2012 Updated: May 19, 2012

I’m not a numbers person by nature. I was a writer first, then a journalist, before I got into business. I’ve learned the hard way, though, that managing the basic numbers is critical to business success. And if it’s your business, then you either manage them yourself or work with somebody you really trust.

With that in mind, here’s my summary of the most important and most basic numbers in the business, and how to manage projections and tracking and steering ahead with them.

1. Do a sales forecast

I know that’s hard for a lot of people, in a lot of businesses, but that’s really mainly because you think you’re supposed to predict the future correctly. That’s not really the point. What you want to do is break the future down into meaningful parts, like units, price per unit, and costs per unit. You won’t guess accurately, but if you have the components of it, then you can track the difference between what you expected (or hoped for) and what actually happened. And that leads to management.a sales forecast in rows and columns

What I mean, specifically, is set up a worksheet that goes monthly along the top for 12 months, with a column for the year that adds up the months, and then two other columns to the right for the second and third year. Then think strategically about your main lines of sales, summarizing down to 2-5 lines of sales. Those lines of sales become rows on the same worksheet. Project unit sales in a set of rows, then revenue per unit in another set, and then sales (as units times revenue) as a third unit. Then do direct cost per unit as a set of rows, and finally, sum direct costs as a fifth set of rows. And of course for all of these rows, you have the same columns running to the right: first 12 months, then the first-year total, then the annualized second and third years.

The math for this is simple and obvious. Units times revenue equals sales. Units times direct costs equals cost of sales. Add the months to get the first year. Then do the second and third years annually.  The illustration here shows an example for how this looks for the first three months, and you can imagine the rest of it flowing out to the right.

Although the math is simple, the assumptions aren’t. Try to find drivers that can help you project realistic numbers. For example, in a restaurant business you might draw a map of the chairs and tables and calculate how many lunches and dinners you can serve per day, week, and month. Or, in a web-driven business, calculate free traffic, paid traffic, conversion rates, and so forth. Always look for the assumptions you can track later. Hint: that tracking plan vs. actual is what drives management. I call it steering your business.

2. Estimate the expenses.

This is another worksheet. It has the same columns along the top as the sales forecast, namely 12 months, the first year total, and then the second and third year.

The rows in this worksheet are expense items. Normally you start with salaries, and then add in marketing expenses, fixed expenses like rent and utilities, salary-related expenses like payroll taxes and health insurance, and so forth.

The math is simple and obvious here, too, but the assumptions aren’t. But, if you think about it, if you’re going to be able to run a business well you probably have to have a pretty idea of what you’re paying in salaries, rent, utilities, marketing costs, and other expenses.

And you don’t have to be right. You just have to be specific so you can manage the differences.

3. Manage the plan vs. actual differences

This is where the management comes in. Once you’ve got your basic numbers projected, expect those projections to be wrong. And then you meet every month (even if it’s just you, set up the time) to look at what went right, what went wrong, and what adjustments to make.

And that’s called planning. 

About the Author:

Tim Berry

Guest Blogger

Founder and Chairman of Palo Alto Software and bplans.com, on twitter as Timberry, blogging at timberry.bplans.com. His collected posts are at blog.timberry.com. Stanford MBA. Married 44 years, father of 5. Author of business plan software Business Plan Pro and www.liveplan.com and books including The Plan As You Go Business Plan, published by Entrepreneur Press, 2008.

Comments:

Your advice is really helpful, set out a complete plan has always been the basic steps needed to do business. It will help you succeed in the way that you want.
Simple text cannot make any marketing campaign successful. It needs to be emphasized with the help of relevant graphics. However before one chooses to apply graphics for their pop-up stands, it is necessary to have a proper plan of action in place. A well-considered layout is a priority. The graphic should be relevant to the content displayed on the pop-up stands. It should be able to add something to it and enhance the user experience.
I agree graphics are very important, but do not underestimate the power of video. People are much less inclined to read nowadays (especially the generation that's online), so both video and quality graphics are key to a successful marketing campaign. Yet text is still pertinent, but it is how you use it. Not many people will read a full 1000 word blog post - no matter how riveting it is.
This post was edited to remove a link. Please review our Community Best Practices for more information about how best to participate in our online discussions. Thank you.
Well basic number computation is important in business when one is not aware with it better to study first. Numbers could be the language in business as it computes and tells how business status is, it is in good flow or ruin? Something like that. Those tips mentioned are simply the basic yet vital factor in doing business numbers.
Excellently written article, if only all bloggers offered the same level of content as you, the internet would be a much better place. Please keep it up!.Great tips, I would like to join your blog anyway.Waiting for some more review.Thank you This post was edited to remove a link. Please review our Community Best Practices for more information about how best to participate in our online discussions. Thank you.
Simple + Brilliant. In the past I've ignored all this number stocking, but as my business grows I see that these numbers ar not to be ignored at all, and could help me save some big bucks yearly. Thanks Tim
I had to read this twice. Very good article. I will have my wife read it since she handles our business expenses and account management.
The key question here is how to estimate the unpredictable expenses. I mean there are some things we cannot predict and those things can cause huge losses and lead to bankruptcy. IHMO when starting any business, we need to have a pretty big "safety fond" with about 30% from the total cost of all business spends.
Punjabi you have an interesting point on how to estimate unpredictable expenses. I think you manage predictable expenses precisely because you can't predict unpredictable expenses, and they will happen, so if you have a good planning process then you manage predicted expenses well and track your results and revise your plan often. Then when the unpredictable expenses happen -- and of course they will -- you have a plan with good projections so you can turn very quickly to tools to adjust expenses and revise the plan to accommodate the unpredictable expenses.  Thanks for the comment.  Tim 

Pages

Leave a Comment

You must be logged in to leave comments. If you already have an SBA.gov account, Log In to leave your comment.

New users, Register for a new account and join the conversation today!