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 Type Optional Asset Program Optional Component Inventory Optional Condition Report Optional Cost Escalation Rate Optional Lender Reserve Requirement Optional Market Optional 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.