You know the moment. A deal is moving, you have a program and a cost budget, and someone asks for yield-on-cost, spread to exit, and a clean IC page. The math is simple, but building the model and formatting it eats the afternoon. This task cuts that loop. You hand over the core assumptions and get back a complete development pro forma with the metrics everyone will ask for, organized in Excel with a short written read. Development ~20 min to run Build a Development Pro Forma Vic prompt Use Vic to build a development pro forma for a ground-up or value-add project with a defined cost budget, rent and expense assumptions, and an exit cap rate. Purpose A human analyst needs roughly 240 minutes for the same model; this task produces it in about 20 minutes so teams can test returns and prepare IC materials faster. Inputs Property Type Optional Development Program Optional Cost Budget Optional Rent And Expense Assumptions Optional Exit Cap Rate Optional Return Hurdle Optional Market Optional Outputs An Excel model containing Total Development Cost, untrended and trended stabilized NOI, yield-on-cost figures, development spread in basis points, completed value, development profit, profit-on-cost, and levered IRR with equity multiple versus the hurdle rate, plus a short written read. Time saved Turns roughly 240 minutes of manual work into about 20 minutes. How it works You give Vic the basics you already have: property type and development program, a cost budget, rent and expense assumptions, an exit cap rate, and, if you have it, a return hurdle and market context. The task builds a full model that rolls up Total Development Cost and a stabilized pro forma from your inputs. Run it with a simple command: "Use Vic to build a development pro forma for a ground-up or value-add project with a defined cost budget, rent and expense assumptions, and an exit cap rate." Vic produces two outputs. First is an Excel file. It includes Total Development Cost, untrended and trended stabilized NOI, and yield-on-cost in both views. It calculates the development spread in basis points against your exit cap and derives completed value from stabilized NOI and the cap rate. It also quantifies development profit and profit-on-cost so you can see how much value is created relative to cost. The model carries through to levered returns. You get a levered IRR and an equity multiple, set against the partnership hurdle if you provide one. You can answer standard IC questions without rebuilding tabs or reformatting outputs. Second is a concise written summary. It pulls the key numbers into a tight narrative you can drop into an investment memo or use to brief a principal. The point is clarity on cost, stabilized income, yield-on-cost, spread to exit, and whether the deal clears the hurdle. A few practical notes. The task handles both ground-up and major value-add programs. If your inputs are thin, you still get a coherent model, but the output tracks the quality of your assumptions. With a detailed cost budget and a clear rent and expense view, the results line up with how your team underwrites. What changes in practice is speed and consistency. A human analyst can build the same workbook, but it takes about four hours to get from a blank sheet to IC-ready. This task does it in about twenty minutes and keeps the structure consistent across deals. That makes it easier to compare yield-on-cost and spread across a pipeline without reworking every file. There is also a benefit in how the metrics sit together. Untrended and trended yield-on-cost next to the exit cap, with the spread in basis points and the completed value, force a clear read on whether the deal works. Pair that with profit-on-cost and the levered IRR versus the hurdle, and the decision set is in one place. If your current process involves stitching together an old template, fixing links, and rewriting the IC page, this replaces that loop. You keep control of the assumptions and get a model and summary ready for scrutiny.