Light blue pie charts and calculator floating on beige background

How to Create a Financial Forecast

By Bryce Warnes on January 21, 2019

Maybe your goal is world domination. Maybe you just want a sustainable side hustle. Either way, financial forecasting helps you understand the steps you need to take—and the numbers you need to hit—to make growth happen for your business.

Plus, if you ever go looking for more funding, you’ll need financial forecasts to prove that your business is on track for growth.

Here’s everything you need on hand, and the steps you can take, to produce a reliable financial forecast.

What is a financial forecast?

A financial forecast tries to predict what your business will look like (financially) in the future. Pro forma statements are how you make those predictions somewhat concrete.

Pro forma statements are just like the financial statements you use each month to see how your business is performing. The only difference is that you prepare pro forma statements in advance, for future months and years.

There are three key pro forma statements you should be familiar with:

Depending on your goals, these statements will cover different time spans. If you’re creating a financial forecast for your planning purposes, you should create pro forma statements covering six months to one year in the future.

If you’re presenting your forecast to a lender or investor, though, you should create pro forma statements covering the next one to three years.

Financial forecasting vs. budgeting

When you create a budget for your business, you plan to set aside money for certain costs, taking into account your income and expenses. The budget you make may be based on info from your financial forecast, but it’s distinct from the forecast itself.

Think of financial forecasting as a prediction, and budgeting as a plan. When you make a financial forecast, you see what direction your business is headed in, based on past performance and other factors, and use that to anticipate the future.

When you make a budget, you plan how you’re going to spend money based on what you expect your finances to look like in the future (your forecast).

For instance, if your financial forecast for next year says you’ll have an extra $5,000 in revenue, you might create a budget to decide how it will be spent—$2,000 for a new website, $1,000 for Facebook ads, and so on.

Accounting 101: Set Your Finances up the Right Way

Learn the fundamentals of small business accounting, and set your finances up for success with this free guide.

Three steps to creating your financial forecast

Ready to peer into the crystal ball and see the future of your business? There are three steps you need to follow:

  1. Gather your past financial statements. You’ll need to look at your past finances in order to project your income, cash flow, and balance.

  2. Decide how you’ll make projections. Besides past records, there’s other data you can draw on to make your projections more accurate.

  3. Prepare your pro forma statements. Pour a coffee and get ready to crunch some numbers.

Step one: Gather your records

If you’re not looking into the past to see how your business has grown, you’re not really forecasting—you’re just guessing.

You’ll need to gather past financial statements so you can see how your business has developed over time, and then project that development into the future.

Your bookkeeper or bookkeeping software should generate financial statements for you. If you don’t have either, and you don’t have financial statements, you’ll need to take care of that before you can start forecasting. You need complete bookkeeping in order to get the transaction history you base your financial statements on.

Put aside the task for financial forecasting for the moment, and learn How to Catch Up on Your Bookkeeping.

Once your books and financial statements are up to date, you’ll have everything you need to start planning for the future.

Step two: Decide how you’ll make your forecast

Depending what resources you choose to use, the type of forecast you create will fall between two poles—historical and researched-based.

Almost every financial forecast includes a little bit of historical forecasting, and a little bit that’s research-based. The blend you choose will depend on your needs and the resources at your disposal.

Remember, the goal is to create a realistic, useful forecast—without breaking the bank or eating up all your time.

Historical forecasting

When you use your financial history to plot the future, it’s historical forecasting. You’re looking at your last few annual Income Statements, Cash Flow Statements, and Balance Sheets to see how fast you’ve grown in the past. From there, you can make a guess about how fast you’ll grow this year.

The benefit of this is that it’s relatively easy to do and doesn’t take a lot of time, money, or expertise. The drawback is that you’re only using info about your own business, and not looking at broader market trends—like what your competition has been up to.

Historical forecasting is a good bet if you’re forecasting for modest growth, or else creating a quick-and-dirty forecast for your own use—not putting together a presentation for potential investors.

Research-based forecasting

When you do research about broader market trends, you’re using research-based forecasting. You may look at how your industry has performed over the past ten years, investigate new technologies and consumer trends, or try to measure the progress of your competitors. You might look at how companies similar to yours have planned their own growth.

The benefit of research-based forecasting is that you get a detailed, nuanced view of how your business could grow, taking into account a lot of different factors. And it’s the kind of forecast that investors and lenders want to see.

The drawback is that researched-based forecasting can be expensive. You may find you need to hire outside consultants and researchers to handle the heavy lifting.

Research-based forecasting is a good choice if you’re courting investors, or planning on rapid, aggressive growth. It’s also good if your company is brand new, and doesn’t have a lot of financial history to draw on for making projections

Step three: Create pro forma statements

Once you’ve collected the information you need to build your forecast, you can create pro forma statements.

We’ll cover the three key financial statements here. Whether you use all of them is up to you.

If you’re creating a quick forecast for your own planning, you may only need to create pro forma Income Statements. If you’re presenting to lenders or investors, you’ll want to use all three.

Rule of thumb: Any form you’d use in the month-to-month operation of your business should be created pro forma. For instance, if you move a lot of cash around every month, and you rely on Cash Flow Statements to make sure you’ve got enough money on hand to pay your vendors, then it’s wise to create pro forma Cash Flow Statements as part of your forecast.

Creating the pro forma Income Statement

First, set a goal—a projection—for sales in the period you’re looking at.

Let’s say you made $30,000 in sales this year. Next year, you want to make $60,000. So, your total sales will increase by $30,000.

Set a production schedule that will let you reach that goal, and map it out over the time period you’re covering. In our example, there will be 12 Income Statements in the year to come (one each month). Map out that $30,000 increase in sales over the 12 statements.

You could do this by increasing sales a fixed amount every month, or gradually increasing the amount of sales you make per month. It’s up to your instincts and experience as a business owner.

Then, it’s time for the “loss” part of “Profit and Loss.” Calculate the cost of goods sold for each month, and deduct it from your sales. Deduct any other operating expenses you have, as well.

It’s important to take every expense into account so you get an accurate projection. If part of your plan is quadrupling your online advertising, be sure to include an expense that reflects that.

Once you’re done, your pro Forma Income Statements show you how much you can expect to earn and how much you can expect to spend in the time ahead.

Example Pro Forma Income Statement:

Karen’s Falafel Warehouse

2019 (current) $ 2020 $ 2021 $
Sales Revenue 15,000 19,000 23,000
Cost of Sales (6,000) (9,000) (11,000)
Gross Profit 9,000 10,000 12,000
Operating Expenses
Rent 1,000 1,000 1,000
Web hosting 600 600 600
Advertising 3,000 3,000 3,000
Total Operating Expenses (4,600) (4,600) (4,600)
Operating Income 4,400 5,400 7,400
Net Income 4,400 5,400 7,400

Creating the pro forma Cash Flow Statement

You create a pro forma Cash Flow Statement a lot like the way you’d create a regular Cash Flow Statement. That means taking info from the Income Statement, and using the Cash Flow Statement format to plot out where your money is going, and how much you’ll have on hand at any one time.

Your projected cash flow can tell you a few things. If it’s in the negative, it means you’re not going to have enough cash on-hand to run your business, according to your current trajectory. You’ll need to make plans to borrow money and pay it off.

If your net cash flow is positive, you can plan on having enough surplus cash on hand to pay off loans, or save for a big investment.

Example Pro Forma Cash Flow Statement:

Ruth’s Raccoon Rescue and Rehabilitation Center

2019 (current) $ 2020$ 2021 $
OPENING BALANCE 15,000 16,000 18,000
CASH RECEIVED FROM
Donors 86,000 88,000 93,000
Souvenir Shop 1,000 900 800
Total Cash Received 87,000 88,900 93,800
CASH PAID FOR
Supplies 33,000 35,000 36,000
Rent 24,000 24,000 24,000
Income Tax 8,000 8,600 8,800
Total Cash Paid 64,000 67,600 68,800
Net Cash Flow Operations 23,000 22,300 25,000

Creating the pro forma Balance Sheet

Drawing on info from the Income Statement and the Cash Flow Statement lets you create pro forma Balance Sheets. But you’ll also need previous Balance Sheets to make this useful—so you can follow the story of how your business got from “Balance A” to “Balance B.”

The Balance Sheet will project changes in your business accounts over time. That way, you can plan where to move money, when.

Example Pro Forma Balance Sheet:

Big Bill’s Budget Wedding Videos

2019 $ 2020 $ 2021 $
ASSETS
Current Assets
Checking Acct. 12,000 15,000 18,000
Savings Acct. 34,000 40,000 44,000
Accounts Receivable 3,000 1,000 2,000
Inventory 14,000 17,000 21,000
Total Current Assets 63,000 73,000 86,000
NON-CURRENT ASSETS
Video Equipment 13,000 13,000 13,000
Car 7,000 7,000 7,000
Total Non-Current Assets 20,000 20,000 20,000
Total Assets 83,000 93,000 106,000
LIABILITIES & EQUITY
Current Liabilities
Accounts Payable 10,000 9,000 11,000
Line of Credit 23,000 20,000 19,000
Total Current Liabilities 50,000 45,000 43,000
Non-current Liabilities
Loan 40,000 36,000 32,000
Total Liabilities 90,000 81,000 75,000
EQUITY
Owner’s Capital 30,000 30,000 30,000
Retained Earnings 45,000 56,000 65,000
Total Equity 75,000 86,000 95,000
Total Liabilities & Equity 165,000 167,000 170,000

Best, worst, and normal case projections

Whether you’re the kind of person who always sees the glass half full, or the kind who always sees it half empty, it’s a good idea to take into account different possible outcomes for your business.

Humans aren’t very good at predicting the future. Consider creating three different forecasts: One for the best case scenario, one for the worst, and one for the middle or “regular” scenario.

  • Maybe the t-shirts you buy wholesale for your online store go up in price, like they did last year. Factor that into your worst case scenario.

  • Maybe t-shirt prices stay the same, plus your new advertising plan takes off, and you get more business. Consider that the best case.

  • Maybe everything more or less stays the same. Let’s call that the regular case.

The best/worst/regular trifecta is also useful when you’re making a budget for your business. For example, in January you might budget for a regular scenario. In this case, that means monthly sales revenue of $8,000.

However, in February say your revenue hits $10,000, and in March it’s $11,000. At that point, you may want to adjust your budget to the best case to scenario—since you’ll now have more money to reinvest in your business.

At the end of the day, the more robust your forecast, the better you’ll be able to plan the future of your business, and think on your feet. Plus, you’ll impress investors and lenders, by proving you’ve considered (almost) every possible outcome.

The better you understand how financial statements work, the easier you’ll find it to create financial forecasts. Before you start forecasting, take a look at our brief overview of how to read financial statements.

Cartoon illustration of an income statement

Do Your Own Bookkeeping with an Excel Income Statement Template

Enter your transactions into this Excel template, and voila! You get a ready-made Income Statement. Perfect for entrepreneurs who aren't ready for full-fledged accounting software.


This post is to be used for informational purposes only and does not constitute legal, business, or tax advice. Each person should consult his or her own attorney, business advisor, or tax advisor with respect to matters referenced in this post. Bench assumes no liability for actions taken in reliance upon the information contained herein.

Friends don’t let friends do their own bookkeeping. Share this article.

Want a free month of bookkeeping?

Sign up for a trial of Bench. We’ll do one month of your bookkeeping and prepare a set of financial statements for you to keep. No pressure, no credit card required.

Decorative patterns