Month end turns into a scavenger hunt. You pull a T12, reconcile a rent roll, paste in budget, then try to remember where you left last period's numbers. By the time the deck is stitched together, you have spent more time assembling than thinking. The friction is not the math. It is the repetition and the risk of small inconsistencies across tabs. This task cuts the assembly work and gives you one place to read the asset. Asset Management ~10 min to run Build Asset Management Dashboard Vic prompt Use Vic to build an asset management dashboard for one asset or a full portfolio using the latest T12 and rent roll. Purpose Gives a current view of asset or portfolio health without manual data pulls each period and cuts the typical 90-minute analyst effort to about 10 minutes. Inputs Performance Inputs Required Portfolio Scope Optional Period Optional Output Format Optional Outputs An Excel workbook with a header KPI strip and separate sections for operations, leasing, capital, and debt, each with budget and prior-period comparisons, plus a portfolio summary tab when scope covers more than one asset and a concise health narrative. Time saved Cuts the typical 90 minute analyst effort to about 10 minutes. How it works Hand Vic your performance inputs, usually a current T12 and rent roll. Point it at one asset or include a portfolio if you want a roll up. If you care about a specific period or output format, say so. Then run: "Use Vic to build an asset management dashboard for one asset or a full portfolio using the latest T12 and rent roll." The output is a single Excel workbook that is easy to move through. At the top is a KPI strip with key numbers and comparisons to budget and the prior period. Below that, the workbook splits into operations, leasing, capital, and debt. Each section follows the same pattern: current results, budget, prior period, with formatting that reads like an institutional report. On the operations side, you get rolling occupancy and economic occupancy, plus NOI against budget and last period. The leasing section tracks status and rollover so you can see what is coming due and what has moved. Capital and reserves sit in the same file, so you do not have to reconcile separate schedules. The debt section includes DSCR, debt yield, LTV, and maturity, which keeps the capital stack next to property performance. If you include more than one asset, the workbook adds a portfolio summary tab with a roll up row. This is where manual builds often break. Consistent mapping to a standardized chart of accounts and CRE number formatting keeps the roll up clean without hand edits. There is also a short written health read. It calls out items that are off plan based on the comparisons already in the file. It is concise. You can drop it into a monthly report or use it as a starting point before an asset call. The value is not a flashy chart. It is a repeatable structure that lines up operations, leasing, capital, and debt in one place, every period, without rework. You spend time on variance and decisions instead of hunting for numbers. For teams that run recurring reporting, the time change is real. Work that took about 90 minutes of analyst time comes back in roughly 10 minutes. More important, the output is consistent month to month, which makes trends easier to see and conversations easier to have. If you have ever double checked whether a variance is real or just a paste error, this fixes it. One workbook. Same structure every time. Clear comparisons and a direct read on what needs attention.