How to Do Financial Projections for a Business Plan: A Step-by-Step Guide

May 6, 2026
Budgeting
Subsribe to our Newsletter: Bridging the Deficit

Weekly Expert Insights on Financial Planning and Strategy

Whether you're preparing a business plan for investors, a board presentation, or internal strategic planning, the financial projections section is where credibility is built or lost. Get it right, and you demonstrate that you understand the economics of your business. Get it wrong, and even a great strategy loses its persuasive power.

Here's a practical, step-by-step guide to building financial projections that are both realistic and useful—grounded in actual data, not wishful thinking.

Step 1: Build Your Revenue Model on Drivers, Not Assumptions

The most common mistake in business plan projections is starting with a top-line revenue number and working backward. "We'll do $10M next year" isn't a projection—it's a wish. Credible revenue projections are built from drivers: customer acquisition rates, average deal size, retention rates, pricing assumptions, and seasonal patterns.

If you have historical data, use it as the foundation. The FP&A Trends Survey found that organizations using dynamic, driver-based models are nearly three times more likely to rate their forecasts as good or great compared to those using basic models (77% vs. 27%). Driver-based projections aren't just more accurate—they're more defensible when investors or board members push back on your assumptions.

Step 2: Map Your Expense Structure with Precision

On the expense side, the biggest line item for most businesses is people. The Bureau of Labor Statistics reports total compensation averaging $43.93 per hour, with benefits adding 30.9% on top of wages. For service businesses, payroll can represent 40% to 80% of revenue.

For business plan projections, model workforce costs at the position level wherever possible: specific roles, planned hire dates, salary ranges, and benefit structures. A planned Q3 hire affects the annual P&L differently than a Q1 hire. This level of detail makes your projections more accurate and shows investors you understand the timing of your costs, not just their magnitude. Our article on a reasonable approach to headcount forecasting provides practical methods for this.

Step 3: Don't Forget Cash Flow

A profitable business plan can still fail if cash runs out. Cash flow projections are often the weakest section of a business plan because they require thinking about timing—when revenue actually arrives versus when it's recognized, when expenses are paid versus when they're incurred, and how capital expenditures and financing activities affect liquidity.

Project cash flow monthly for the first year and quarterly for years two through three. If your business has seasonal patterns, cash flow projections should reflect them. Our article on whether cash flow forecasting software is right for your team explores the tools and approaches available.

Step 4: Build Multiple Scenarios

No single projection will perfectly predict the future. The AFP's 2026 research found that only 38% of organizations use structured scenario planning—but those that do show significantly higher planning effectiveness. For a business plan, presenting base, optimistic, and conservative scenarios demonstrates that you've thought through the range of outcomes and understand the key sensitivities.

For each scenario, document the assumptions clearly. What changes between scenarios? Customer acquisition rate? Deal size? Hiring pace? Market timing? When the assumptions are explicit, investors and board members can evaluate the logic—not just the numbers.

Step 5: Connect Projections to Infrastructure

Here's where many companies stumble: they build beautiful business plan projections in standalone spreadsheets that aren't connected to their actual financial data. When the plan is approved and execution begins, there's no automatic way to track actuals against projections. The finance team ends up manually comparing two disconnected systems—the plan in one spreadsheet and the actuals in the GL.

Modern planning platforms solve this by housing both your projections and your actuals in the same environment, connected to the GL. As the business executes against the plan, variance is visible in real time. You don't wait for month-end close to discover you're off track—you see it continuously and course-correct proactively. For a deeper look at what these platforms offer, see our article on what budget forecasting really means.

Step 6: Tell the Story

Numbers without narrative are hard to evaluate. Every projection should be paired with a clear explanation of what's driving the numbers, what assumptions are most sensitive, and what the key risks and opportunities are. When a board member asks "what happens if the product launch is delayed by a quarter?"—the financial section of your business plan should make that answer easy to construct.

Workday's research on CFO evolution identifies financial storytelling as a critical leadership skill—the ability to translate complex models into narratives that inform decisions. Your business plan projections are the first test of that capability.

Step 7: Plan for Ongoing Tracking

A business plan projection that can't be tracked against actuals is a one-time exercise. The best projections are designed from the start to connect to ongoing measurement. Define which metrics you'll track monthly and quarterly. Establish the variance thresholds that trigger a reforecast. Build the projection in a way that allows easy comparison to actuals as they arrive.

The AFP's 2026 research found that organizations using structured scenario planning show higher effectiveness across all dimensions. That structure includes not just the initial projection, but the ongoing discipline of comparing projections to reality and adjusting course as needed. For a practical look at how this works, our article on strategic budgeting and planning considerations provides a useful framework.

The Tools Matter

Business plan projections built in standalone spreadsheets serve their purpose initially. But as the business grows and the projections need to connect to actuals, support rolling updates, and enable scenario analysis on the fly, the spreadsheet approach reaches its limits. A 2024 study found 94% of business spreadsheets contain errors—a risk that grows with every linked file and every contributor.

Purpose-built planning platforms designed for growing businesses handle the full lifecycle: initial projections, actuals tracking, variance analysis, rolling forecasts, and scenario modeling—all on connected data. For guidance on choosing the right tool, see our guide to choosing FP&A software.

  • Error message label
  • Error message label
  • Error message label
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Stay in the loop!

Sign up for our newsletter to stay up to date with everything Centage.

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

Keep reading...

Interviews, tips, guides, industry best practices, and news.

View all Resources