Disclaimer: The information provided in this blog is for general informational purposes only and does not constitute legal, tax, or accounting advice. Nothing on this site should be relied upon as a substitute for professional advice from a licensed attorney, CPA, or financial advisor. Please consult a qualified professional before making any financial or legal decisions.
By the end of this guide, you will know how to create business financial projections: a 12-month monthly forecast and a 3-year annual outlook covering revenue, expenses, profit, and cash. These are often called pro forma statements, meaning financial statements built from assumptions about the future rather than from recorded transactions. Before you start, gather your past financial statements if the business is operating (or realistic market research if it is a startup), open a spreadsheet tool such as Excel or Google Sheets, and set aside three to four hours.
Step 1: Define the Purpose, Time Horizon, and Format of Your Projections
Start by deciding who will read the projection. A forecast for your own planning can be rough and fast. One for a bank loan needs documented assumptions and clean statements. One for investors needs a clear growth story and defensible scenarios. The audience sets the level of detail and the time horizon.
A standard setup is monthly detail for year one, then quarterly or annual figures for years two and three. Monthly detail matters in year one because that is where cash shortfalls show up. Lenders commonly ask for three to five years of projections, and requirements vary by lender and loan program, so confirm what yours expects (as of 2026) before you build.
Next, set up the spreadsheet so every number traces back to a single input. Create these tabs:
- Assumptions: growth rates, prices, conversion rates, payment terms, wage rates, and every other input, each with a source.
- Revenue: the sales forecast, driven only by the assumptions tab.
- Expenses: cost of goods sold, operating expenses, and payroll.
- Income Statement, Cash Flow, and Balance Sheet: the three core statements, built by formula from the tabs above.
The rule that keeps the model honest: never type a number directly into a calculation. If a price changes, you change it once on the assumptions tab and everything downstream updates.
Step 2: Gather Your Historical Data and Market Inputs
If your business is operating
Pull two to three years of income statements and balance sheets from your bookkeeping software, along with bank-reconciled cash records. Then read them for distortions. A lost anchor client, a one-time equipment sale, a pandemic-style shutdown, or an unusually large contract can make a past year a poor guide to the next one. Note each of these events in a short list, and decide whether to adjust the baseline or simply exclude the event from your trend calculations.
Reconcile before you rely on anything. If the books have not been reconciled to bank statements, errors such as miscategorized expenses, missing invoices, or duplicated entries will flow straight into your forecast and compound with every growth assumption you layer on top. Fixing a six-month-old miscategorization now is far cheaper than explaining a wrong projection to a lender later.
If you are a startup
With no history, your inputs must come from outside. Useful sources include:
- Industry association reports and published benchmarks for margins and typical costs.
- Competitor pricing, taken from their websites, menus, or rate cards.
- Written quotes from suppliers, landlords, insurers, and software vendors.
- Conversations with owners of similar businesses about realistic ramp-up times.
Record the source and date next to every figure as you collect it. You will paste these into the assumptions tab in later steps, and a reader who asks "where did this come from?" should get a direct answer.
Step 3: Build Your Sales Forecast From the Bottom Up
There are two ways to forecast sales. A top-down forecast starts with a large market and assumes you capture a slice of it. A bottom-up forecast starts with your actual capacity and activity, such as customers, leads, and prices, and builds to a total. The top-down claim "we'll capture 1% of the market" is a common misconception about what makes a forecast credible. Lenders and investors distrust it because it says nothing about how you will win a single customer. Use market size only as a ceiling check on your bottom-up numbers.
Pick the driver formula that fits your business:
- Customers x average price x purchase frequency (a subscription, salon, or repeat-purchase business).
- Leads x conversion rate x average order value (a services firm or online store).
For example, imagine a landscaping company that expects 60 estimate requests in March, closes 40% of them, and averages $1,800 per job. March revenue is 60 x 0.40 x $1,800 = $43,200. Put the 60, the 40%, and the $1,800 on the assumptions tab, then let the revenue tab calculate each month.
Then adjust for two realities. Seasonality: use your history, or industry patterns, to vary lead volume by month rather than spreading sales evenly. Ramp-up: new products, locations, and hires rarely produce full results immediately, so phase them in over several months.
Finally, build three scenarios: conservative, expected, and optimistic. Change only the key drivers, such as lead volume and conversion rate, and write down what each scenario assumes. A single optimistic scenario is not enough. It gives the reader no way to see what happens if things go less well, and a lender will want exactly that view.
Step 4: Project Your Costs: COGS, Operating Expenses, and Payroll
Separate costs into two groups. Cost of goods sold (COGS) is variable and scales with sales: materials, direct labor, merchant fees, shipping. Operating expenses are the costs of running the business regardless of volume: rent, software, insurance, marketing, professional fees. Model COGS as a percentage of revenue or a per-unit cost, and operating expenses as monthly amounts with their own growth or step changes.
Once you have COGS, calculate gross margin: revenue minus COGS, divided by revenue. Compare it to your history or to industry norms. A projected margin far above what comparable businesses earn is a red flag that you have left out a cost.
Payroll
Model payroll fully loaded, meaning wages plus employer payroll taxes, workers' compensation, and benefits. A $50,000 salary costs materially more than $50,000. Payroll tax rates and wage bases change, so check current figures (as of 2026) with the relevant agencies or your CPA rather than relying on a rate remembered from a prior year.
Items that are easy to miss
- Planned hires, with start months, not just annual headcount.
- Supplier price increases, which can erode margin if you do not raise your own prices.
- Owner compensation, whether as salary or distributions. Leaving it out makes profit look better than it is.
- Loan interest, depreciation on equipment, and an income tax estimate. Ask your accountant which rate and method apply to your entity type.
Step 5: Create the Projected Income Statement
Now link the tabs. On the income statement, pull revenue from the revenue tab and COGS and expenses from the expenses tab, using formulas only. Build down the page in this order: revenue, COGS, gross profit, operating expenses, operating income, interest and taxes, and net income. Do this for each month of year one, then for each of years two and three.
Next, sanity-check the result. Compare gross margin and net margin against your historical figures or industry benchmarks. Scan the monthly columns for any jump you cannot explain. If net income doubles in August, find the cause: a missing expense, a formula that skipped a row, or a revenue assumption that kicks in too early. Every unusual month should have a reason you can state in one sentence.
Then calculate your break-even point, the sales level at which profit is zero. The formula is:
Break-even revenue = fixed costs / contribution margin ratio
The contribution margin ratio is revenue minus variable costs, divided by revenue. For example, suppose fixed costs are $18,000 per month and variable costs are 55% of sales, so the contribution margin ratio is 45%. Break-even revenue is $18,000 / 0.45 = $40,000 per month. Compare that figure to your monthly revenue forecast and note the first month the business is expected to exceed it. That month is worth showing explicitly in the model, because lenders and investors will look for it.
Step 6: Build the Cash Flow Projection and Balance Sheet
Profit is not cash, and this is the most common misreading of a forecast. Several things move cash without appearing on the income statement, or appear at different times:
- Customer payment terms: a sale made in March on net-30 terms appears as March revenue but arrives as cash in April (this balance is accounts receivable).
- Inventory purchases: cash leaves when you buy stock, but the cost hits the income statement only when it sells.
- Loan principal payments: repaying principal reduces cash but is not an expense.
- Equipment purchases: cash goes out at once, while depreciation spreads the cost over years.
Structure the cash flow tab for each month as: beginning cash + cash in - cash out = ending cash. Each month's ending cash becomes the next month's beginning cash. Cash in includes customer collections (use your payment-terms assumption, not the sales figure), loan proceeds, and owner contributions. Cash out includes supplier payments, payroll, operating expenses, taxes, debt payments, and equipment.
Find the month with the lowest ending cash. That figure is your funding need or required buffer. If the low point is negative, you need financing, faster collections, or lower spending before that month. If it is positive but thin, consider how much cushion you want. Working capital, which is current assets minus current liabilities, is a useful companion measure of short-term health.
The balance sheet
Build a simple projected balance sheet: cash (from the cash flow tab), receivables, inventory, equipment net of depreciation, payables, loans, and equity. Equity rolls forward by adding net income and owner contributions and subtracting distributions. Then test it: assets must equal liabilities plus equity in every period. If they do not, the cause is almost always a broken link or a sign error, such as a loan payment added instead of subtracted. Check the first month that fails, since later errors usually trace back to it.
Step 7: Stress-Test, Document Assumptions, and Schedule Updates
A forecast is only useful if you know how it breaks. Run a few sensitivity checks by changing one input at a time on the assumptions tab:
- Reduce sales by 20%.
- Make customers pay 30 days later than expected.
- Raise costs by 10%.
After each change, look at the lowest cash month. Whichever variable pushes cash negative first is your biggest vulnerability, and it tells you where to focus: tighter collections, a larger buffer, or more flexible costs.
Then make sure every assumption on the assumptions tab has a source beside it: historical average, supplier quote, industry benchmark, or your own judgment, labeled as such. The goal is that a lender, investor, or advisor can challenge any number and find where it came from.
Finally, set a review rhythm. Compare actuals to projections every month and write a one-line explanation for any large variance. Update the forecast quarterly, rolling it forward so you always have twelve months ahead. Projections that are set once and never revisited stop being useful within a few months. Before you submit the model to a lender or investor, have a CPA or financial advisor review it, and confirm any program-specific requirements (including any SBA templates) as of 2026.
Keeping Your Projections Accurate After the First Draft
Before you share the model, confirm that the income statement, cash flow, and balance sheet tie together and that every assumption is documented. Then put a monthly actual-versus-projected review on your calendar, and consider asking a qualified accountant to look over the model.
Schedule a call and discover how we can help your business grow.