You just got a rent roll from a broker. It’s a PDF, maybe a messy spreadsheet, and every column is labeled differently than the last one you saw. You need to know occupancy, loss-to-lease, which leases are expiring, and whether anyone’s behind on rent. But first, you’d have to spend 30 minutes just cleaning the data into something usable. So it sits in your inbox. Not because you don’t know what to do with it, but because you don’t have 45 minutes right now to wrestle a rent roll into shape and then actually analyze it. The deal moves forward without the detail it deserves. That’s exactly what this task is built to fix. underwriting 10 min Analyze Multifamily Rent Roll Cleans a multifamily rent roll into a standardized Excel file. Optionally runs a full analysis covering occupancy, loss-to-lease, lease expirations, delinquency, and actionable recommendations, delivered as both a written chat summary and an interactive, branded dashboard artifact you can print, share, or use in asset management meetings. Who It’s For Multifamily investors, asset managers, and acquisitions professionals who need to move quickly from raw rent roll to real insight. What You Get Back A cleaned, standardized Excel file and (optionally) a full written analysis plus an interactive, branded dashboard you can print or share. Why It Matters Turns 45 minutes of manual data cleanup and analysis into a 10-minute workflow, so you can underwrite faster and walk into meetings prepared. Task Inputs Rent Roll File Required The multifamily rent roll to analyze (PDF or Excel). Include Analysis Required Whether to run occupancy, LTL, expiration, and delinquency analysis with polished visual on top of the cleaned rent roll. Additional Context Optional Anything the AI should know: property name, specific concerns, asset management meeting prep notes, market context, etc. Skills Used Multifamily Rent Roll Analysis Considerations Multifamily Rent Roll Analysis Artifact Tools Used Parse Multifamily Rent Roll Get Brand Assets for Personalization What This Task Does You upload a multifamily rent roll (PDF or Excel) and tell the task whether you want a full analysis or just a clean file. If you have specific context (property name, a concern you want flagged, notes for an upcoming meeting), you drop that in too. From there, the Real Estate Analyst (with Memory) takes over. It parses and standardizes the rent roll into a clean Excel file with consistent columns and unit mix analytics. If you opted into analysis, it runs the full suite: occupancy and projected occupancy, loss-to-lease with severity breakdowns, lease expiration exposure, delinquency (when balance data is available), and actionable recommendations tied to specific units. It even pulls your firm’s branding and builds an interactive dashboard you can print, screenshot, or pull up in a meeting. The whole process takes roughly 10 minutes of your time. The AI does the rest. Who This Task Is For Anyone who touches multifamily rent rolls regularly and is tired of spending more time cleaning data than actually making decisions with it. This task is built for: Acquisitions analysts who need to quickly evaluate a new deal’s rent roll before deciding whether to dig deeper Asset managers who prep for monthly or quarterly property reviews and need clean data and clear talking points Portfolio managers who oversee multiple properties and want a standardized view across their holdings Capital markets professionals who need to package rent roll data for lenders or investors on a tight timeline In short: if you already have a rent roll, this task gives you a clean file, a full analysis, and a presentation-ready dashboard. Why It Matters A rent roll is the foundation of every multifamily underwriting decision. Occupancy, pricing, lease risk, collections: it all starts there. But most rent rolls arrive in formats that require significant cleanup before you can do anything useful with them. You already know this. You’ve spent the time reformatting columns, reconciling unit counts, and building your own summary tables more times than you’d like to count. The blocker isn’t skill. It’s bandwidth. When you’re juggling multiple deals or managing a portfolio, the rent roll analysis that should take priority gets pushed to the bottom of the list because the setup work alone takes 45 minutes. Without the analysis, you walk into meetings less prepared. Renewal conversations happen without knowing which units have the biggest loss-to-lease gaps. Delinquency patterns go unnoticed until they become real problems. The data was always there; you just didn’t have time to pull it apart. This task compresses 45 minutes of manual work into 10. That’s not just faster. That’s the difference between reacting to your portfolio and managing it. That’s the multiplier. What the Output Looks Like The output from this task include