Why a CapEx reserve should come from the building, not a rule of thumb
“Budget 5% of rent for CapEx” is easy to remember and easy to get wrong. A building with a new roof and a ten-year-old boiler does not need the same reserve as a building whose windows, parking lot and water heaters are all approaching the end of their useful life in the same decade. The reserve should come from the inventory, not from a rule of thumb.
Start with what is actually in the building
A practical CapEx reserve planner in Excel is a component list: roof, siding, windows, HVAC, water heaters, plumbing lines, electrical panel, flooring by type, appliances, paving, fencing, laundry, common areas. For each item you care about, you need a remaining life (from age or from condition), a replacement cost you can override when a bid arrives, and a year the cost is likely to land.
From that list you can roll a 10-year schedule by system, flag items already past a typical useful life, and convert the plan into a recommended reserve per unit per year. Value-add projects — a remodel you chose, not a replacement you cannot defer — belong in their own rows so they do not masquerade as maintenance.
What this does to the deal, and to the year
On an acquisition, moving from a flat percentage to a year-by-year plan often changes cash flow more than it changes net operating income, because the heavy years were being hidden. After you own the building, the same plan becomes the budget you compare to actual invoices. Mid-year overruns should be allowed to update a reforecast, so you can see the effect on cash flow and returns before December.
Published useful lives and national-average costs are a starting point, not a bid. They vary by region, by building quality and by when you last requested prices. Get local quotes, then type over the estimate. MultiFamilyBooks includes a 123-component library with cited useful-life ranges and 2026 US average costs, a regional multiplier, and a schedule you can feed into the pro forma or into actual-versus-forecast tracking.
This article is for education. Costs and lives are estimates. MultiFamilyBooks is a tool to make your numbers easier. It isn't tax, legal or investment advice, so have a CPA review your numbers before you file or buy.