Skip to content
CRE Agents LogoCRE Agents
All Posts
Asset Management

Stop guessing your reserves and build a real capex plan

Turn scattered inputs into a clean, multi-year reserve schedule with ranked projects and clear funding gaps.

VicVic
February 10, 20263 min read
Stop guessing your reserves and build a real capex plan

You know the drill. Someone asks for a five year capex plan and you start pulling from a property condition report, last year’s budget, and a half trusted reserve schedule. Twenty minutes in, you are still deciding what counts as immediate versus recurring.

Then comes the awkward part. You need to show whether reserves are sufficient and which projects make sense to do. That often turns into a rough guess dressed up as a model.

Asset Management
~10 min to run
Build a Multi-Year CapEx Reserve Plan
Vic prompt
Use Vic to build a capex reserve plan for a 180-unit multifamily property with a current reserve balance of $520,000.
Purpose
A complete reserve plan prevents funding gaps and supports accurate NOI projections. The task reduces preparation time from roughly 90 minutes to 10 minutes.
Inputs
Property DetailsRequired
Property Condition ReportOptional
Reserve BalanceOptional
Business PlanOptional
Output FormatOptional
Outputs
An editable Excel workbook with inputs, immediate needs list, recurring replacement schedule, discretionary projects ranked by ROI, and a year-by-year reserve roll-forward that flags shortfalls.
Time saved
Turns roughly 90 minutes of manual work into about 10 minutes.

How it works

This task builds a complete multi year capital plan from the inputs you already have. Provide basic property details and add a property condition report, current reserve balance, or a business plan if you have them. If some inputs are missing, it still returns a structured plan based on what you provide.

Run it with a single line: "Use Vic to build a capex reserve plan for a 180-unit multifamily property with a current reserve balance of $520,000."

The output is an editable Excel workbook meant for real use. It starts with a clear set of inputs, then splits capital needs into three buckets: immediate needs, recurring replacement, and discretionary value add projects. That simple split clears up a common source of confusion, especially when different stakeholders use different definitions.

Immediate needs are listed so you can see what cannot wait. Recurring replacement is scheduled across years, which gives you a steady view of predictable cycles like roofs, HVAC, and interiors. Discretionary projects are ranked by return on cost and payback, so you can explain why one project moves ahead of another.

The piece most teams struggle to build cleanly is the reserve roll forward. This task produces a year by year view that reconciles beginning balance, contributions, and planned spend. It flags shortfalls so you can see exactly when the plan breaks, not just that it might break.

Contribution levels are set within the same framework. Instead of picking a round number, you get a contribution that lines up with the schedule of needs. That makes conversations with ownership or lenders more direct because the math is visible and consistent.

The workbook follows standard CRE formatting and is ready to edit. You can adjust assumptions, move projects between years, or change scope without rebuilding the structure. For acquisitions, it plugs into underwriting. For asset management, it becomes a plan you can update as conditions change.

This is not about adding detail for its own sake. It cuts the friction of assembling a plan so you can focus on decisions. Which projects drive return. When to spend. How much to hold back. Those calls get easier when the plan underneath is tight.

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.