Watch Me Model an Apartment Acquisition Deal with Our Latest Claude Skill (AI Agent Skill)

Why It Matters

By automating data‑intensive underwriting steps, the AI skill accelerates deal evaluation while preserving the need for expert oversight, giving real‑estate firms a competitive edge in a fast‑moving market.

Key Takeaways

• AI skill automates apartment acquisition underwriting, speeding analysis.
• Skill integrates Excel model, input registry, and output schema.
• Works across Claude, ChatGPT, Gemini; upload .skill file.
• User defines role and target IRR; AI solves price.
• Human reviews AI outputs, ensuring model assumptions remain accurate.

Summary

The video introduces ACRE’s new AI skill that plugs into its decade‑old apartment acquisition model, enabling analysts to underwrite core‑plus multifamily deals faster. The skill is packaged as a .skill file that, once uploaded to platforms like Claude, ChatGPT, or Gemini, reads the embedded Excel model, input registry, and output schema to automate data entry and calculations.

Key functionality includes recognizing role‑specific prompts, ingesting broker pro‑formas, rent rolls, and expense sheets, then solving for a price that meets a user‑defined unlevered IRR target. In the demo, the analyst asks the AI to price “The Falls” acquisition at an 8.5% unlevered IRR, and the AI returns a headline price of $118.8 million (≈$365 per unit, 5.3% cap) while flagging assumptions for human review.

Notable moments feature the prompt “I’m an acquisition analyst. Help me underwrite this apartment acquisition,” the AI’s clarification questions about pricing methodology, and its ability to populate the Excel model’s rent roll and expense tabs automatically. The system also displays its internal “thinking” log, showing iterative error‑checking before finalizing outputs.

The rollout signals ACRE’s broader strategy to embed AI companions across its 70‑plus real‑estate models, promising faster deal triage while still demanding professional oversight. Analysts can now run multiple underwriting scenarios in parallel, freeing time for strategic decision‑making, but must retain deep modeling expertise to validate AI‑generated results.

Original Description

In this video, I walk through using our latest Claude Skill with the A.CRE Apartment Acquisition Model to underwrite a multifamily acquisition deal. The video demonstrates how the AI Skill works alongside the Excel model and how the AI can help populate model inputs, analyze deal documents, and solve for acquisition pricing based on a target unlevered IRR. This is not a replacement for knowing real estate financial modeling but it is a powerful way to speed up underwriting workflows when used by professionals who understand the model and the deal. To download the latest version of the model with the AI Skill, visit the accompanying blog post: https://www.adventuresincre.com/multifamily-apartment-acquisition-model-in-excel/

00:00 - Introduction to the Apartment Acquisition AI Skill

00:48 - Important Note on AI and Real Estate Modeling Knowledge

01:28 - Overview of the Apartment Acquisition Model

01:52 - Introducing the Accelerator Case Study

02:46 - AI Skill Compatibility and Installation

03:55 - Prompting Claude to Underwrite the Deal

04:44 - Inside the Structure of the Claude Skill

06:03 - Claude Begins Reviewing the Deal

06:34 - Setting the Pricing Target

07:19 - Claude Processes the Underwriting Inputs

07:51 - Reviewing the AI-Generated First Pass

09:02 - Final Thoughts and What’s Coming Next

Join the community of CRE professionals leaning into AI: https://aiedge.ac/join

View all of the models in our Library of Real Estate Excel models: https://www.adventuresincre.com/library-real-estate-excel-models/

Learn to build institutional-quality real estate models: https://www.adventuresincre.com/accelerator/

SUBSCRIBE: https://www.youtube.com/user/sburtonhome?sub_confirmation=1