How to Know if Your Financial Projections are Realistic

August 23, 2022 by Adam Hoeksema

The most common question I receive from ProjectionHub customers is “do my projections look realistic to you?”  I am always happy to provide feedback, but I wanted to share my approach with you as well so that you can determine whether your projections are realistic or not.  My approach differs between tech startups where the range of outcomes can vary dramatically compared to small businesses in stable industries with lots of industry data available.  Here are 5 things that I will look at to determine whether a set of projections could be realistic or not.  

Compare Projected Profit Margins to Industry Average

If you are using one of our financial projection spreadsheets, then I would go to the At a Glance tab and look at the Profit and Loss at a Glance table and look at the Net Income as a percentage of revenue, also known as the profit margin.  

looking at a profit and loss table to analyze realistic profit margins

If for example the particular set of projections I am looking at is for a fast casual restaurant and I see a 60% profit margin I would know the projections are unrealistic because a simple Google search will show us that the average profit margin for a fast casual restaurant is 6 to 9%. 

projections assumption research example

Review Cost of Goods Sold and Operating Expense Ratios

I follow a similar approach to review the Cost of Goods Sold and Operating Expense ratios.  Just Google “what is the typical cost of goods sold as a percentage of sales for industry xyz” and you will likely find a range that you can compare to your projected cost of goods sold percentage. 

Compare Projected Revenue to Actual Data

Next, I like to look at the total projected revenue over the 5 years and make sure that those revenue projections seem reasonable.  You can try to Google things like:

You might find that someone provided a great detailed blog post to answer your question.  If you can’t find a good source I have a couple more suggestions. 

Check Projected Revenue per Employee

Another quick check that can help you identify unrealistic projections is if your revenue per employee is outside of the norm. We studied 234 tech startups to find typical revenue per employee data that you can quickly compare against.

How do Projections Compare to Other Startups in a Similar Stage?

We studied 107 tech startups to see what they were forecasting for revenue broken down by business type and stage of business. Part of what makes your projections realistic is simply the fact that your projections are within the range of what other similar businesses are also projecting. Read the full study here (2022 Tech Startup Financial Projection Report)

Using one of our Financial Projection Templates is a good way to ensure reliable and realistic projections!

Does the Balance Sheet Balance? 

If everything is looking good so far, then I just check a couple more simple things.  Does the balance sheet actually balance?  

example of a balance sheet balancing

Check out our free balance sheet template if you are having trouble getting your balance sheet to balance. 

Does the Cash Balance Remain Positive? 

Finally, I check to make sure that your cash balance never drops below $0.  

example of positive cash flow

If you can pass all of these tests, then there is a good chance that your financial projections are realistic, or at the very least, should pass the scrutiny of a potential lender or investor.  

If you would like me to review your financial projections for free, just fill out this Projection Review Form and I will provide feedback ASAP. 

About the Author

Adam is the Co-founder of ProjectionHub which helps entrepreneurs create financial projections for potential investors, lenders and internal business planning. Since 2012, over 50,000 entrepreneurs from around the world have used ProjectionHub to help create financial projections.

Other Stories to Check out

Top 11 Startup Lawyers & Attorneys in California for 2022

Looking for a startup lawyer or attorney in California? Look no further! This article lists the top 11 startup lawyers and attorneys in California.

How To Start A Nursing Home Business With Little To No Experience

We’ve got some useful tips on how to start your nursing home, followed by how to find your staff and open your nursing home to its first residents

What is a Data Room for Investors - What to Include?

In this article, we hope to bring you up to speed on what exactly is a data room for potential investors, why it's important, and how to prepare one.

Have some questions?
Share with us and we contact you shortly.

FOLLOW
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
?