Population agent built for RealAI Pro Forma Template v4

The template arrived already clean — no prior deal to strip out. It's a full acquisition pro forma: T12 → 10-year projection → Sources & Uses → senior/mezz debt schedule → unlevered/levered returns with exit analysis → optional GP/LP promote waterfall → rent/sales comps → 3-table sensitivity grid, all summarized on one page. I traced every input against its formula chain, mapped 40+ scalar inputs and two comp tables to their exact write cells and sourcing rules, and stress-tested the generated agent's write rules on a scratch copy: placeholder inputs recalculated with zero errors, Sources & Uses balanced, and a price increase correctly dragged the cap rate and levered IRR down — confirming the mapping is sound before you run it for real.

Files:
1. RealAI_Pro_Forma_Template_v4_agent.md      (the population agent)
2. RealAI_Pro_Forma_Template_v4_briefing.md   (the user-facing summary)

Built for: RealAI_Pro_Forma_Template_v4 (2).xlsx
Status: ready

To put it to work: go to Agents → New Agent, paste the agent file's contents in as its prompt, and attach the working workbook (RealAI_Pro_Forma_Template_v4 (2).xlsx) — the cell coordinates only match that exact copy. It isn't set up or registered yet; that page is what creates it.