How to build an occupancy-cost bridge into the cash forecast
The 13-week cash forecast is a key tool for a controller or fractional CFO. You build it for small and midsize tenant clients. It is also where occupancy cost often goes wrong. Rent shows up as one repeating line. CAM gets folded into rent or left out. CAM means common area maintenance, the shared upkeep cost the landlord bills back. The yearly true-up lands as a surprise. The true-up is the year-end fix between estimates and actual cost. Property tax pass-throughs hit on a schedule the forecast misses. The forecast looks clean until a bill arrives. Then the client finds a cash gap that should have shown up six weeks earlier. For more, see why occupancy cost is more than just rent.
The fix is not a fancier model. The fix is a working bridge. It pulls every lease cash flow into one forecast line. It splits the steady items from the periodic ones. And it updates as news arrives during the year. I built CAMAudit to run on the same files this bridge uses. The bridge and the statement review share inputs. Those are the lease, the abstract, last year's statement, and the billing pattern.
13-week cash forecast: A rolling forecast of expected cash receipts and disbursements for the next thirteen weeks, updated weekly or biweekly. The 13-week horizon is short enough to be reliable from observable inputs (open AR, open AP, scheduled debt service, payroll calendar) and long enough to surface cash issues in time to act on them. The forecast is most useful when each major recurring expense category has a documented forecasting basis (run rate, contract amount, schedule of known periodic payments) and a method for updating when assumptions change. Occupancy cost benefits from a dedicated bridge because the cash pattern includes both monthly and periodic components.
Why one rent line falls short
The rent line in a forecast shows the monthly base rent. For most leases, that one payment also holds the monthly CAM, tax, and insurance estimates. They all ride in the one check the client sends the landlord. A controller sees a clean number on the ledger. They assume occupancy cost is covered.
Three things break that view.
First is the yearly true-up. After the year ends, the landlord adds up actual costs. Then it compares them to the estimates the tenant paid. If actuals run higher, the tenant owes a balance. That balance is not in the monthly rent line. It is a one-time payment. It often runs three to ten percent of yearly base rent. It lands sixty to one hundred eighty days after year end.
Second are the periodic pass-throughs. Some landlords bill property taxes apart from the monthly estimate. They send one or two payments a year on the tax due dates. These bills are large. Their timing is known. But they hide from the monthly rent line.
Third are direct-pay utilities and services. The client pays electric, gas, internet, and maybe janitorial straight to the vendor. The landlord does not touch these. They are still part of occupancy cost. They usually sit under utilities or facilities in the forecast. But they are not tied to the rent line. So the rent line is the wrong number for an occupancy talk.
The bridge links all of these. Then the forecast and the client talk use the same number.
What the bridge looks like
The bridge is a small working schedule. It has one row per lease. It has a column for each of the next thirteen weeks. The rows for a typical tenant client are:
Base rent (contractual monthly amount). Monthly CAM estimate (the CAM portion of the monthly landlord billing). Monthly real estate tax estimate (if the landlord includes it in monthly billing). Monthly insurance estimate (same condition). Periodic real estate tax pass-throughs (if the landlord bills these separately). Periodic insurance pass-throughs (same condition). Annual CAM reconciliation balance (modeled estimate). Direct-pay utilities (run-rate average). Direct-pay services (janitorial, security, anything paid outside the landlord). Other landlord bills (one-time charges, amendments, special assessments).
Each weekly cell holds the cash you expect to pay that week. Steady items fill the weeks the bill is due. Those are base rent, monthly estimates, and direct-pay utilities. Periodic items fill only the weeks the bill should land. Those are the yearly true-up and the periodic taxes.
The weekly total is the occupancy cash for that week. The total across thirteen weeks is the full cash exposure. The client can see both numbers.
How to model the periodic items
The yearly true-up is the most common periodic item. It adds the most to the bridge. The starting estimate is last year's actual balance. Then you adjust for any known change.
Say last year's true-up showed a balance due of $14,200. Say nothing big has changed. Occupancy is steady. No major tax change. No amendment. Then the bridge models a $14,200 balance for this year. It lands in the week last year's statement arrived. Now say the tax bill rose by twelve percent. Say taxes are about forty percent of the base. Then the bridge raises the estimate by about five percent. The estimate is not exact. It is close enough and you refine it through the year.
Tax pass-throughs that bill apart from the monthly estimate are easier. The county due dates are public. Last year's amount is known. You fold in any expected change. The bridge sets the payment for the week of the due date.
Insurance pass-throughs work like taxes. The renewal date is on the lease abstract or from the landlord. The amount is last year's billing with any known change.
One-time landlord bills are the hardest. By nature, they are not scheduled. The bridge handles them with a buffer line. That is a small reserve for landlord items you cannot model. Size it at one to three percent of yearly occupancy cost. Base that on the client's history with the landlord.
"The single best change I made to the cash forecasts I worked with was breaking occupancy cost out of the rent line and forcing the periodic items to live as separate forecast rows. Once the annual reconciliation has its own row, the question is not whether it surprises the client. The question is just how accurately the row is sized." - Angel Campa, Founder of CAMAudit
How to keep the bridge current
The bridge is not a fixed schedule. It updates when news arrives. The trigger events are easy to spot.
A new landlord bill arrives. You post the bill and update the year-to-date cost. Then you refine the estimate for any periodic items left. Say the monthly CAM estimate just rose eight percent. The bridge picks up the new rate for the rest of the year.
The yearly true-up arrives. This is the biggest update. The actual amount replaces the estimate. The timing locks in. The bridge resets the baseline for next year.
A property tax bill arrives or changes. The bridge updates the periodic line.
An amendment is signed. The bridge updates base rent and the escalation schedule. It also updates any share or cap change the amendment made. A share is the slice of cost the tenant owes by space.
The pace is light. It is a thirty-minute update each month. You spend longer at year end and at amendment time. The result is a forecast that does not surprise the client.
How the bridge helps the close
The bridge is also a close-week tool. During the close, you review a landlord bill. The bridge shows if that bill fits the year-to-date forecast. Say the monthly CAM estimate just rose twenty percent. Say the bridge still had the old rate. The close now has a flag a bookkeeper might miss. Say the yearly true-up comes in well above the bridge estimate. You know right away. You can run the rest of the review with that in mind.
The bridge and the close are two views of the same lease activity. Keeping the bridge feeds the close. Running the close updates the bridge. That two-way feed keeps both reliable.
A client can now see the next thirteen weeks of occupancy cash. That includes the true-up that used to land as a surprise. That client sees the firm as ahead of the curve, not behind it. It is the line between a one-off job and an advisory one. The bridge is what makes it possible.
Frequently Asked Questions
What is an occupancy-cost bridge?
An occupancy-cost bridge is a working schedule that aggregates all the cash flows associated with a commercial lease (base rent, CAM estimates, real estate tax pass-throughs, insurance pass-throughs, annual reconciliation balances, direct utility payments) into a single forecast line that ties to the cash forecast. The bridge separates run-rate occupancy cost from one-time or annual items so the forecast reflects both the steady payments and the periodic spikes.
Why does occupancy cost belong in the cash forecast separately from rent?
The rent line in most cash forecasts captures only the contractual base rent and possibly the monthly CAM estimate. It does not capture the annual reconciliation balance, real estate tax pass-throughs that bill once or twice per year, insurance pass-throughs, or direct utility costs that are economically part of occupancy. A forecast that shows only the rent line understates true occupancy cost and produces unpleasant surprises when the annual or semi-annual items hit cash.
Where do the annual reconciliation amounts come from in the forecast?
The estimated annual reconciliation amount comes from prior-year actual reconciliations adjusted for any known changes. If the prior year produced a balance due of $14,200, the controller can model a similar balance for the current year and refine the estimate as the year progresses. If a major change is known (an amendment, a property tax increase, a structural occupancy change), the estimate adjusts for that change. The forecast is not pretending to predict the exact reconciliation.
How often should the occupancy-cost bridge be updated?
At least monthly during the standard close, and sooner if a triggering event occurs (a new landlord bill, an amendment, a known property tax adjustment, an unexpected pass-through). The bridge is a working document, not a year-start projection that goes stale. The controller updates it when new information arrives.
Should the forecast show occupancy cost at the gross level or the net level?
Both, with the gross level as the primary view. The gross occupancy cost includes everything the client pays (base rent, CAM estimates, tax pass-throughs, insurance pass-throughs, direct utilities, reconciliation balances). The net level optionally shows occupancy cost net of any pass-through credits the client has received. Showing only net hides the cash exposure; showing only gross obscures any recoveries. Both views give the client a complete picture.