A new business forecast is one of the simplest tools a creative agency can use to stop reacting to its revenue and start managing it. Most studios track what they've earned. Fewer track what they're likely to earn in the next 60, 90, or 120 days. That gap is where cash flow surprises live.
West Melbourne Studios builds a rolling new business forecast into its planning rhythm because the alternative is making hiring, spending, and capacity decisions on gut feel. This guide covers how to structure a forecast that's honest, usable, and worth updating every week.
What a new business forecast actually is
A new business forecast is a weighted probability view of your pipeline. It's not a wishlist and it's not a guaranteed revenue number. It assigns a likelihood to each active opportunity and multiplies that by the deal value to produce a weighted revenue figure you can plan against.
The distinction matters. An unweighted pipeline is just a list of names and numbers. A weighted forecast tells you: if your current conversion rates hold, here's roughly what you'll close this quarter. That's a number you can actually use when deciding whether to hire a contractor, take on a large overhead, or push into a quiet period with confidence.
A basic forecast has four columns: the prospect or project name, the estimated deal value, the probability of closing (as a percentage), and the expected close date. The weighted value is simply the deal value multiplied by the probability. Sum the weighted column and you have your forecast.
How to assign probabilities honestly
This is where most forecasts go wrong. Agencies assign probability based on how much they want the work, not how likely they are to win it. A 70% probability attached to every opportunity in your pipeline is just optimism dressed as data.
Build a probability scale tied to defined stages. A lead you've had one call with sits at 15%. A prospect who has reviewed your proposal and asked a follow-up question sits at 40%. A client who has verbally agreed to proceed but hasn't signed sits at 75%. A signed agreement sits at 95% (not 100%, because things still fall over before the first invoice). These thresholds keep everyone anchoring to facts, not feelings. If you've already established a creative agency services agreement template, the signed stage is clear and unambiguous.
Review your conversion data from the past two years before you set these percentages. If your studio closes 30% of proposals, a stage labelled "proposal sent" should sit around 30%, not 60%. Forecast accuracy depends entirely on your probability inputs reflecting real history.
What to include beyond project revenue
New business forecasts in creative agencies often miss two categories that meaningfully affect the picture.
The first is retainer renewals. A retainer coming up for renewal in 8 weeks isn't guaranteed revenue. It's a probability. Flag it in your forecast with a renewal probability based on the health of that relationship and any signals from the client. If you've built a creative agency retainer agreement with clear renewal terms, your probability estimate here will be more grounded.
The second is upsell and expansion within existing clients. A client currently in production on one project who has expressed interest in a follow-on campaign is a live opportunity. These tend to close faster and at higher rates than cold new business. Treat them as separate line items in the forecast, not as assumed add-ons.
How often to update the forecast
Weekly is the right cadence for most agencies. It sounds like overhead but takes less than 30 minutes once the structure is in place. The goal isn't to produce a perfect document. It's to force a weekly conversation about where things actually stand.
Move opportunities between stages when something real happens: a call, a proposal submission, a decision, a delay. Don't update probabilities based on how you feel about the client this week. Move the number only when a concrete stage-gate has been passed or missed.
Archive completed forecasts every quarter. After 12 months you'll have enough data to compare forecast versus actual revenue. That comparison is the most valuable output of the whole exercise. It tells you where your probability assumptions are systematically off, and lets you recalibrate.
Common mistakes to avoid
Three errors appear in almost every first attempt at this.
- Including dead leads you haven't called in 60 days. Dead weight in the pipeline inflates your forecast and creates false confidence. Set a rule: if there's been no contact in 8 weeks, the opportunity moves to "dormant" and exits the active forecast.
- Forecasting revenue instead of cash. A $40,000 project that closes in week one but doesn't pay its final invoice until week 14 doesn't solve a week-three cash problem. Track expected payment dates, not just close dates.
- Only tracking new clients. New business includes any revenue not yet confirmed, whether from a stranger or an existing account. Limiting the forecast to new logos underestimates its usefulness.
Connecting the forecast to capacity and budgeting
A new business forecast is most useful when it sits alongside your capacity plan. If your weighted forecast shows $120,000 in probable revenue over the next 60 days and your current team is already at 80% capacity, you know now that closing all of it will require additional resource. That's a decision you can make before you're in a scramble.
Feed the forecast into your annual budget review process as well. A studio that keeps 12 months of rolling forecast data can spot seasonal patterns in its pipeline, identify which types of work it wins most reliably, and set new business targets that reflect reality rather than aspiration. If you're building that budget from scratch, a structured approach to writing your agency's annual budget gives the forecast a financial home to land in.
None of this requires specialist software. A shared spreadsheet with clear column definitions and a weekly update habit is enough to start. The discipline matters more than the tool.