The brokers least rattled by lumpy income are not the ones with the steadiest deals. They are the ones who can see the lumps coming. A simple cash flow forecast turns the uncertainty of commission income into a plan: you still have gaps, but you know when, and you can prepare instead of scramble. This guide shows you how to forecast leasing income off a weighted pipeline, how to handle the execution-occupancy lag that trips up most attempts, and how to use the downloadable model to do it.
The downloadable forecast model does the math for you. Enter your live deals on the Pipeline tab, your commission, win probability, net percentage after splits, and the months you expect execution and occupancy, and set your starting cash and monthly expenses on the Monthly Forecast tab. It projects your income, net cash flow, and running balance across twelve months, so the gaps show up before they arrive. The rest of this guide explains the thinking behind it.
Most brokers who try to forecast make one of two mistakes. They either count every pipeline deal at full value, which produces a wildly optimistic picture, or they count only signed deals, which is too pessimistic to plan with. The fix is to weight each deal by its probability of closing, and to place the income in the months it will actually arrive, not the month the deal closes. Get those two things right and a forecast becomes genuinely useful.
For each live deal, take the gross commission, multiply by your realistic probability of winning it, and multiply by your net percentage after any co-broke and house split. That gives a weighted, take-home expected value for each deal. A $80,000 commission at 90 percent probability and a 70 percent net works out to an expected $50,400 to you. Summing weighted expected values across the pipeline is far more realistic than either full value or signed-only.
This is the step that makes a leasing forecast accurate, and the one generic templates miss. Your commission does not arrive in one month. It splits, the execution half around signing, the occupancy half months later behind the build-out. So each deal's expected value has to be split and placed in two different months. The execution half goes in the month you expect to sign, the occupancy half in the month you expect occupancy. Spread across a pipeline, this is what produces the realistic, lumpy income line you actually live with. The reason the occupancy half lands so much later is the subject of the guide on the 50/50 trap.
With expected income placed in the right months, subtract your monthly expenses to get net cash flow, then carry a running balance from your starting cash. Now the forecast earns its keep: the months where the balance dips toward or below zero are your gaps, visible in advance. Those are the months to plan for, with reserves, by timing a tax payment carefully, or by advancing an earned commission that is stuck behind occupancy.
A forecast is only useful if it changes what you do. When it shows a gap two or three months out, you have lead time to respond: lean on your reserve, push to close a deal sooner, time discretionary spending around it, or line up an advance on a commission that will be earned but not yet paid during the gap. The forecast does not remove the lumpiness, it gives you the runway to handle it calmly. It pairs directly with the reserve work in the guide on building a cash reserve and the smoothing strategies in the guide on smoothing income.
A forecast is a living document, not a one-time exercise. Update probabilities as deals progress, move months as timelines shift, and add new deals as they enter the pipeline. A forecast you refresh monthly is worth far more than a detailed one built once and forgotten, because the value is in always seeing the next few months clearly.
Weight each pipeline deal by its probability and your net percentage, split each into an execution half and an occupancy half placed in the months they will actually pay, then subtract expenses and carry a running balance. The template does this automatically.
Because leasing commissions pay in two parts, execution and occupancy, often months apart. Placing both halves in the same month overstates near-term cash and hides the gaps. Splitting them is what makes a leasing forecast accurate.
Monthly, at least. Update probabilities, shift months as timelines change, and add new deals. The value is in always having a clear view of the next few months, which only a current forecast provides.
This guide and the template provide a general planning tool for commercial real estate brokers and are not financial advice. Projections are estimates based on your inputs.
