I'll need your Excel financial modeling template to get started — this is what I'll introspect to build your personalized population agent.

I found the model's full structure. Before generating the agent, I need to flag something.

Finding: This workbook is fully populated with a specific deal — "The Ridley," a 301-unit property at 12517 Beach Blvd, Jacksonville, FL, with a $65M purchase price, named rent/sale comps, live financing terms, and a filled waterfall structure — not a blank template.

RealAI Pro Forma template mapped and ready — population agent generated

Your uploaded workbook is a full multifamily acquisition model (Assumptions → Pro Forma → Debt Schedule → Returns Summary → Waterfall, with Rent/Sales Comps, Market & Demographics, and Tenant Intelligence exhibits, and a fully self-computing Sensitivity grid). It came in populated with a real example deal, not a blank template, so per your choice I cleaned it — comp tables, T12 financials, financing/waterfall terms, and market/tenant data cleared to blank inputs; house-standard defaults (waterfall promote tiers, closing/disposition costs, reserves) left in place.

Files delivered:

1. RealAI_Pro_Forma_Template_clean.xlsx — the blank runtime workbook the generated agent targets
2. RealAI_Pro_Forma_agent.md — the population agent: field guide with every input's cell coordinate, source class (datamart/user-required/forecast-backfill/template-default), intake design, retrieval plan, write/validation rules, and goal-seek protocol
3. RealAI_Pro_Forma_briefing.md — the plain-language summary of what gets pulled automatically vs. what you'll be asked for

Status: ready_with_limitations Limitation: the automated cleaning pass is judgment-based — please spot-check the cleaned workbook (especially the waterfall toggle and financing block) before running your first live deal through it.

A few notes worth flagging directly: the T12's Vacancy & Credit Loss line must be entered as a negative number (the model's sign convention — the agent enforces this automatically going forward), and the Sensitivity sheet needs no manual data-table step — it's fully formula-driven already.