Skip to main content
Free toolkit for real estate investors

The AI Deal Room

A 15-file toolkit for investors who underwrite their own deals. It covers the full lifecycle: source, screen, underwrite, diligence, finance, and report. Every file is a real working asset, the same caliber a paying client receives.

Built for active acquirers in multifamily and commercial: syndicators, private-capital buyers, and small funds. If you read the OM yourself and build the model yourself, this is for you.

Download the pack

Want the system, not just the files?

Get the full pack once, then use the walkthrough below to see exactly what is inside and how to run it.

Get The AI Deal Room

Enter your details and the full 15-file toolkit downloads right away. No cost.

We will email you occasionally about real estate AI. Unsubscribe anytime.

What is inside

Fifteen files: five Claude Skills, seven Excel models, two reference documents, and a guide. Not a listicle. Every one is built to be used on a live deal.

5 Claude Skills

Instruction sets your AI follows. No code, no setup.

7 Excel models

Every formula live. Edit the blue cells only.

2 reference documents

The red-flags checklist and the LP update template.

1 Start Here guide

Walks all 15 files in the order to run them.

One deal runs through all 15 files

Every worked example uses the same synthetic deal: Northgate Apartments, a 96-unit garden-style value-add property in Charlotte, NC. A figure you see in the OM extraction is the same figure in the Pro-Forma Model and the same figure in the LP update.

That consistency is the point. You can trace a number end to end and see exactly how the files connect. The deal is invented, so there is no real client data anywhere in the pack.

The deal lifecycle, stage by stage

You can use any file on its own. You get more out of them run in order.

Stage 01

Source

Define what you buy and keep every deal visible.

Buy-Box WorksheetExcel model

Set your acquisition criteria once: target markets, asset classes, vintage range, return hurdles, deal-breakers. The Deal Screener reads the same field names, so your criteria carry straight over.

Deal Flow TrackerExcel model

One row per deal from first contact to close. Stage, next action, and the date that action is due. Keeps ten deals visible at once.

Stage 02

Screen

Decide in 60 seconds whether a deal is worth your time.

60-Second Deal ScreenerClaude Skill

Paste a broker email or listing and your buy-box. Claude computes the five numbers that matter, runs them against your criteria, lists the obvious red flags, and tells you one thing: skip, request the package, or worth underwriting.

Deal Red-Flags ChecklistReference PDF

The deal-killers experienced operators catch on a first read, organized into income, expense, market, and financing flags. Walk it before you spend money on third-party reports.

Stage 03

Underwrite

Turn an OM into a defensible five-year model.

OM-to-Underwriting ExtractorClaude Skill

Give Claude the OM. It pulls every financial figure into a structured Deal Sheet, sections A through J, and quarantines the broker pro-forma separately. The output drops into the Pro-Forma Model's Inputs tab.

Multifamily Pro-Forma ModelExcel model

The core underwriting model. Returns a full five-year pro-forma, a sized loan tested against LTV, LTC, DSCR, and debt yield, levered IRR, equity multiple, cash-on-cash by year, and a two-way exit sensitivity grid. All formulas, no manual math.

T-12 and Rent Roll AnalyzerClaude Skill

Paste your T-12 and rent roll. Claude normalizes both, computes the diagnostic metrics, and flags every anomaly: non-recurring income, below-market management fees, taxes that have not been reassessed.

Underwriting Assumptions LibraryExcel model

Market-standard ranges for vacancy, credit loss, expense ratios, reserves, and exit cap rates, organized by market tier and asset class. A starting point when you do not have local data. Override any line with confirmed actuals.

Stage 04

Diligence

Track every workstream once you are under contract.

Due Diligence ChecklistExcel model

93 items across eight workstreams: financial, physical, legal and title, lease audit, third-party reports, insurance, operations, and closing. A progress summary updates automatically as you work through it.

Lease AuditClaude Skill

Paste your rent roll and lease abstracts. Claude builds a cross-check grid, compares every field, and flags every discrepancy. The output is a prioritized list of open items for your attorney.

Stage 05

Finance and Capital

Size the loan and tell the deal to an LP.

Debt Sizing CalculatorExcel model

Enter NOI, price, total cost, and the four lender constraints. The calculator tells you which constraint is binding and what loan you actually get, with a rate sensitivity table.

LP Deal Summary GeneratorClaude Skill

Paste the key outputs from your Pro-Forma Model. Claude drafts a structured one-page LP summary: the opportunity, the business plan, projected returns, key risks, and the equity ask. Run it by your counsel before sending.

Stage 06

Manage and Report

Report to investors and watch the portfolio.

LP Update TemplateWord document

A quarterly investor update with every section pre-structured: occupancy and NOI versus pro-forma, capital projects, cash management, risks, and the distributions table. Replace the bracketed placeholders with your figures.

Portfolio TrackerExcel model

One row per owned asset: purchase price, capex, current value, NOI, loan balance, LTV, cash-on-cash, equity, and unrealized gain. A live read of how the portfolio is tracking against your original underwriting.

How it works

Skills

A Claude Skill is a folder of instructions. No code, no API, no setup. Drop it into your Claude, paste the input, and it follows the method. Each skill ships with a worked example.

Models

Open the Excel files in Excel, Google Sheets, or Numbers. Every model opens pre-filled with the Northgate deal so you see it calculate. You only edit the pale-blue input cells.

Documents

The red-flags checklist is a reference you read before diligence. The LP update template is an editable Word file with the structure already built. Replace the placeholders with your figures.

Want the system, not just the files?

Two ways to go further with NextAutomation.

Work with us

Have us build the sourcing-to-reporting pipeline these files only hint at. Custom AI systems for your firm.

Apply to work with us

Join the community

Live builds, the template library, and a room of operators using AI on real deals. from $49/mo.

Join the community