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 Details Required Property Condition Report Optional Reserve Balance Optional Business Plan Optional Output Format Optional 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.