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

Blogs.Industry Word

Register

How to Project Expenses for a New Business

Comment Count:
9

Comments welcome on this page. See Rules of Conduct.

How to Project Expenses for a New Business

By Tim Berry, Guest Blogger
Published: August 27, 2013

People often ask me how they can project basic numbers for a new business that hasn’t started yet. I’ve done some things already, in this space, on how to do that for a new product and a sales forecast (links in the last paragraph). In this post I’m offering the same kind of advice for projecting expenses.

Why expenses? Because if you estimate sales and cost of sales (also called direct costs or cost of goods sold, alias COGS) and can also estimate expenses, then you have everything you need for projected (also called pro-forma) profit or loss. And that gets you well on your way to the basic business numbers you need.

Here’s what I recommend for estimating expenses of a new business:  

  1. Set up an empty spreadsheet with room for row labels in the leftmost column, then 12 columns for months to the right of that, and a column for the first year on the far left. Make that rightmost column add up the numbers in the 12 monthly columns to its left.
  2. Set up a section in it named “People” or something like that. For me, that’s just an empty row with a title in the leftmost column. In the rows below that, you’re going to list the people the business needs. Think of that as one person per row (such as Leslie the chef and Terry who waits on tables) or, in a more ambitious plan, groups of people, like chefs, people to bus tables, people to wait on tables, etc.
  3. Start the list with the people the business needs to launch. Identify them in the leftmost row and put their monthly gross salary across the row in the months.
  4. Add to the list the people you think -- you guess, you imagine -- the business will need to add as it gets through those first 12 months. Show which month you guess you’ll need them by typing their estimated gross earnings beginning in the column for that month, and continuing to the end of the year.
  5. Set up a row called “Subtotal” that ends the section by adding up all the numbers in the rows above it. Use your spreadsheet to do that simple math.
  6. Set up a section named for overhead or fixed expenses or whatever you want to call rent, utilities, Internet access, and other expenses you’ll pay to be in business. Label each of them accordingly, and estimate what each will cost, month-by-month, for the year. Not all expenses will apply from month one. Some will start later. And some will increase as the people increase. And among these rows make sure you have one that estimates employer taxes and health insurance and benefits. Use your spreadsheet to make that estimate depend on the subtotal for people costs in the section above it. If you have no idea, take your total gross compensation and estimate 25% of that, in this row, for these additional expenses. The rest of this is educated guessing, and you should educate your guess. Take office rent as an example: call some real estate people who rent offices, so you have an educated guess. The same for insurance (call brokers), utilities and so forth.  Finish this section with a subtotal row that adds these expenses up to a subtotal.
  7. Set up another section for other expenses or discretionary expenses or something like that use it to list your educated guesses for expenses such as marketing, advertising, research, consulting, commissions and so forth.  Make your educated guesses, calling on people you know, people you might use as vendors and your industry experience. Make a subtotal row for this section too.

When you’re done, you have projected expenses.  

I’ve posted before on how to do sales and costs of sales, on this blog, specifically 5 tips to help you forecast sales and 4 Practical Ways to Forecast a New Product, and especially this video on how to do a sales forecast.

When you’ve finished the expense projection I’ve described here, plus the sales and costs of sales projections I’ve explained in those other posts, you can combine them to project profits. Well, technically you have what you need for EBITDA, which stands for “earnings before interest, taxes, depreciation and amortization,” and is a good stand-in for profits.

These are really useful estimates for planning and budgeting. And they are relatively easy to do from the standpoint of the math and finance. The hard part is getting the assumptions right. But that’s why we do plan vs. actual analysis, and management; and you can’t analyze plan vs. actual unless you have plan.

 

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:

Much appreciated a lot! A standout among the most helpful and shrewd bit of thinking of I came crosswise over in weeks! You simply made my day as I was required to set up a schedule from plans in respect to how to enhance costs for an approaching undertaking. http://www.tesorierolaw.com
i think anyone who has started a business will tell you is we often under-estimate our expenses and over-estimate our revenue leading to a liquidity crisis in startups
i think anyone who has started a business will tell you is we often under-estimate our expenses and over-estimate our revenue leading to a liquidity crisis in startups
Thanks a ton! One of the most useful and insightful piece of writing I came across in weeks! You just made my day as I was asked to prepare a list of ideas as to how to optimize expenses for an oncoming project.)
i think anyone who has started a business will tell you is we often under-estimate our expenses and over-estimate our revenue leading to a liquidity crisis in startups
There are a lot of project management software and tools which are created specially for running a business (small business as well!). Some software development companies offer free trial for a certain period just to understand, whether the soft suits your demands or not. Though of course, being able to pre-count your expenses in advance - this is really a big deal. The article is good, thank you.
I feel it would be better to review your current bank statements to see what your total expenses are . If these were all necessary it provides a break even point.Using Quickbooks will give a series of profit and loss reports that project total spending. This method is better than using a spreadsheet because it is reconciled.
i think anyone who has started a business will tell you is we often under-estimate our expenses and over-estimate our revenue leading to a liquidity crisis in startups
Profmuluka: Thanks for the addition. What I've seen is that some people do as you suggest and are too optimistic, but some other people will be so careful and conservative that they will underestimate revenue and overestimate expenses.  When in doubt, conservative is better, I think, because it lowers risk. But these projections are about reducing undertainty and managing decisions, so the ideal is to have an estimate that helps you make the right decisions. Aim for a good educated guess. 

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!