Skip to content
CRE Agents LogoCRE Agents
All Posts
Asset Management

A clean CapEx reserve plan without the spreadsheet grind

Turn a messy component list into a lender-ready reserve model with clear buckets and a funding path.

VicVic
April 20, 20263 min read
A clean CapEx reserve plan without the spreadsheet grind

You know the moment. You have a condition report, a partial component list, and a lender asking for a documented reserve. The numbers sit in different places and the schedule does not reconcile to anything you can defend.

So you open Excel and start stitching. Useful lives, remaining lives, inflated costs, per unit math, per square foot math, then a funding plan that has to tie to a balance the lender will accept. It is easy to miss a link.

Asset Management
~10 min to run
Develop CapEx Reserve Plan
Vic prompt
Use Vic to build a CapEx and replacement reserve plan for a property with a full component schedule and lender reserve requirements
Purpose
A documented reserve plan prevents surprise capital calls and satisfies lender conditions. The model replaces roughly two hours of manual work with a consistent, auditable output in about ten minutes.
Inputs
Property TypeOptional
Asset ProgramOptional
Component InventoryOptional
Condition ReportOptional
Cost Escalation RateOptional
Lender Reserve RequirementOptional
MarketOptional
Outputs
An Excel workbook containing the component schedule, reserve sizing, bucketed needs, funding plan with running balance, and lender-reserve tie-in, plus a short narrative summary of the plan.
Time saved
Turns roughly two hours of manual work into about ten minutes.

How it works

Give Vic whatever you have. A component inventory, a recent condition report, a target escalation rate, and any lender reserve requirement. Property type, market, and asset program help, but it will run on partial inputs.

Run it with: Use Vic to build a CapEx and replacement reserve plan for a property with a full component schedule and lender reserve requirements.

Vic builds an Excel workbook that schedules each building component by remaining useful life and replacement cost. Costs are inflated using your rate, and every line rolls into a reconciled total. The model sizes the annual reserve two ways, per unit and per square foot, so it matches how your team budgets and how your lender underwrites.

The schedule is split into Immediate, Short Term, and Long Term buckets. It sounds basic, but it changes how the plan reads. Immediate items show what cannot wait. Short Term frames the next few years of cash needs. Long Term shows the steady state funded through operations. The buckets tie back to the component list, so nothing drifts.

There is also a funding plan. The workbook separates upfront capital from ongoing contributions and carries a running reserve balance. This is where ad hoc models tend to break. The balance ties to the lender requirement you provide, so the plan shows compliance instead of a guess.

You also get a short written summary. It states the headline reserve level, the pressure points in the Immediate bucket, and how the funding approach reaches a compliant balance. It is concise enough to drop into a memo or send with a draw package.

A few details that matter in practice. The model reconciles the total reserve back to the component schedule, which speeds review and makes audits cleaner. Per unit and per square foot outputs are both there, so you do not have to rework the file for different audiences. The buckets also give you a simple way to explain why a higher reserve today can reduce surprises later.

This replaces a couple hours of manual build with a consistent output in about ten minutes. More important, it removes the quiet risk in a hand built sheet where one broken link can change the answer. You end up with a file you can defend in front of a lender and a summary you can send as is.

Vic

Written by

Vic

Vic is the seasoned CRE pro behind CRE Agents. He gives the AI you already use (Claude, ChatGPT, and more) the methods and data to do commercial real estate work well.