Financial Projections for Startups [Template + Course Included]

If you have a stable, existing business, then it is possible that the best approach to creating sales projections is simply to take last year’s numbers and apply a growth rate based on your expectations of growth.  Since that approach is quite straightforward I am not going to spend any time on that today. Our Existing Business Forecast Template will be perfect for you in this scenario.  

We are going to focus on more of a first principles approach.  I am going to outline two different approaches that I often take when building a financial model.  First a capacity approach and then a customer funnel approach.  

Capacity-Based Revenue Projections

I use a capacity-based approach to revenue projections when a company is pretty certain to have demand for their products or services and their revenue is more of a function of your price x capacity.  

Here are some examples of businesses where I would take a capacity-based approach. 

Farming Projections

For a farm, your revenue forecast is going to be based on how many acres you are farming x the yield per acre x the price per unit for your crop.  You don’t really need to worry about whether you have a customer or not.  Since most crops are commodities you won’t need to find a customer, you simply sell into the ready made market at the market price. 

Trucking Projections

Trucking is similar in the sense that as long as you have a valid license and a working truck, you will be able to find loads to deliver.  The question is more about how many trucks do you have, how many miles per day can each truck drive and what price will you be able to earn per mile.  Again this is about capacity and price, not whether or not you can find a customer.  This is the approach we take to show how a trucking business with one truck can generate $400k in annual revenue. 

Daycare Facility

A daycare facility will also be able to calculate a capacity based on the size of the facility and the teacher-to-student ratio requirements.  Once you have your capacity it is mostly a function of pricing to determine your revenue forecast.  You can see a screenshot from our daycare financial forecast tool to see how we think about modeling this type of business. 

‍

I would say most tech businesses do not fall into a capacity-based projection approach. 

For tech companies, I typically use a customer funnel-based approach to forecasting revenue. 

Customer Funnel-Based Revenue Projection Approach

These are companies where your customer might not even know your product or service exists and might not know that they want it or need it so you are going to have to really go out and market and sell.  You will likely have a customer funnel that will have leads that convert into customers over time.  

Here are some examples of business models where I would use a customer funnel approach to financial modeling. 

B2B SaaS Projections

For a B2B SaaS product you will probably have an advertising budget and a sales team that will drive leads that your team will work to qualify.  Then some percentage of those sales qualified leads will turn into customers.  You will need assumptions for things like:

• A monthly ad budget 
• Cost per click to attract a website visitor
• Percentage of website visitors that become sales qualified leads
• Percentage of sales qualified leads that the sales team converts into customers
• Average monthly spend per customer

DTC Product Forecasting

For direct to consumer product companies you will have a similar customer funnel.  Once you get to a customer, then you might have assumptions like:

• Average order value
• % of customers that become repeat customers
• How often do repeat customers repurchase

Consumer Apps 

For a consumer mobile app you will need assumptions for things like:

• Monthly ad budget
• Cost per download
• Organic / word of mouth downloads
• % of customers that download the app that convert into active users
• % of active users that churn each year
• Average monthly spend per active user per month

So this should give you an idea of the structure of assumptions that you will need in order to approach creating projections, but I just left you with a bunch of assumptions that you have no idea how to fill in with realistic data.  

Next I want to show you what I would do in order to research and find good data for your sales projections. 

Creating sales projections based on data

So how do you know how many people are searching on Google for terms that are relevant to your product or service?  How do you know how much it would cost to advertise and get a click for that term?  How do you know what a reasonable conversion rate is from a website visitor to a customer?  How do you know what the average order value is for an ecommerce business like yours, etc? 

I recorded an entire course on this, but I have listed some tools and some slides below to show you my typical research process. 

As you will notice in the slides, I start out be simply doing Google research to try to find reasonable assumptions for as many of the key assumptions as I can.  

From there, I like to use the following tools:

• Ahrefs - I use this tool for competitor research to determine how much organic traffic my competitors are getting and thereby how much organic traffic my website might get over time. 
• Google Trends - I use Google Trends to see seasonality trends in a business. 
• Google Adwords Keyword Tool - I use this tool to forecast how much it will cost per click to attract a website visitor, and to see search volume for certain keywords.
• Bizminer - You can use Bizminer industry reports to get an idea of key industry ratios to get an idea of whether your projections are realistic for your industry. 

Forecasting operating expenses

When forecasting expenses I like a couple of different resources to help me forecast my expenses and ensure that my expense projections are within industry standards. 

Expenses for Small Businesses

Bizminer - You can use Bizminer industry reports to get an idea of key industry ratios.  For example, you can determine if the average company in your industry spends 10% on rent or 12% on rent. 

Expenses for Tech Startups

SaaS Capital - You can use this report from SaaS Capital to get an idea of the spending categories as a % of revenue for tech companies.  This is specifically focused on SaaS, so if you are in ecommerce or a hardware startup you will need to find a similar source for your industry.  You can see an example of the expense ratios from SaaS Capital below:

‍

Salary projections

When forecasting salaries I actually take two different approaches.  I typically start out by projecting specific salaries and positions for the first 24 months of the projection.  Then after that, I simply include salaries in larger buckets of operating expenses like General & Admin, R&D, and Sales & Marketing.  When you are raising investment the investors will likely want to know your specific use of funds for the first 18 to 24 months, but after that they will understand that it is impossible to predict exact positions, timing and salaries, so transitioning to an expense as a % of revenue makes sense.  You can see how this looks in one of our financial models for a B2B SaaS company: 

Detailed Salary Projections for the First 24 Months:

‍

Salaries included in operating expense categories as a percentage of sales for year 3 and beyond:

‍

Startup Cost Forecasting

When forecasting your startup costs, your specific location, concept, size and scale of business will make a dramatic difference in what it costs to launch your business.  I don’t recommend that you just take the first “average startup cost” number that you find in a Google search because your specific situation matters.  You will need to do your own research for each startup cost, but I have actually found it helpful to use ChatGPT to ask for a list of common startup expenses for business XYZ so that I don’t forget any common expenses. 

Existing business vs. startup vs acquisition forecasting

I have already mentioned this before, but I commonly take a different approach to creating projections for an existing business compared to a startup compared to modeling a business acquisition.  

Existing Business Projections

When modeling a projection for an existing business I like to use our existing business budgeting template that allows me to enter in historical revenue and expenses and use that as a baseline to build a forecast by increasing or decreasing expenses and revenue based on my plans. 

Startup Projections

For a startup, I would use one of our 70+ industry specific financial projection templates and start from the ground up.  You would use the research process outlined in this article to create your projections. 

Forecasting a Business Acquisition

For creating projections for a business that you are looking to acquire I would use our acquisition financial model which will allow you to enter in historical financials from the target business, but it will also allow you to make adjustments to the balance sheet and revenue and expenses for a post acquisition pro forma. You can’t simply use the existing balance sheet and income statement because both will likely change quite a bit after the sale of the business.