How to Know if Your Financial Projections are Realistic

August 23, 2022

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.  Some industries do have very high gross profit margins, coffee shop gross profit margins can be as high 90%, so it is not an automatic red flag if you are projecting high gross profit margins, it is the high net profit margins that are often a red flag.

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

How to Start an Airbnb Business? (And How Much You Can Earn!)

Learn the basic steps to get started opening your very first Airbnb or short-term rental unit. We walk through what you can expect to earn as well!

How to Start, Build or Buy a Strip Mall Business

In this article, we will do a deep dive to understand the financial details of starting, building, or buying a commercial strip mall property so you can learn how to do it too.

How To Start A Solar Farm & Get The Most Out Of Your Investment

Learn how to start a solar farm and maximize your return on investment with this comprehensive guide. Find out the best locations, equipment, and processes for setting up and running a successful solar farm. Get the most out of your solar venture with expert advice and helpful tips.

Have some questions?
Let us know and we'll be in touch.

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