Underwriting AI for multifamily

AI for underwriting.
From the T12 to a price you can defend.

Drop the OM, the T12 and the rent roll. Every assumption is rebuilt, checked and questioned before you offer.

Watch one deal, start to finish

Three files in. An offer out.

Building B: no water bill
Example data
Marlowe Court · 64 units
T12Marlowe_Court_T12.xlsxreading…
38 lines mapped · reconciles to its totals
Rent rollMarlowe_Court_RentRoll.xlsxreading…
64 units · 59 occupied
OMMarlowe_Court_OM.pdfreading…
31 pages · 6 figures to confirm
Found in your documents
!Building B shows no water line; Building A shows $11,240 a year
!No management fee on the statement
!The tax bill is the seller's: it resets at the sale

An invented property, for illustration. Hover to hold a step; click a step to jump.

Document intake

Documents

The T12 is mapped line by line and reconciled to its own totals. The rent roll becomes a unit mix. An offering memorandum's figures are listed for you to confirm, and never enter the model on their own.

Documents
3 files read
T12Trailing-12 statement.xlsx
RRRent roll Oct.pdf
OMOffering memorandum.pdf
Trailing 12, mapped
Gross Potential Rentgpr$446,400
Water / Sewerutilities$24,000
Repairs & Maintenancerepairs$20,000
Real Estate Taxestaxes$21,000
The spreadsheet

Model

Unit mix, debt, growth rows, a ten-year pro forma, the waterfall. Blue cells are yours, everything else is formula, and every row shows how it is computed. It recalculates as you type.

Deal
40-unit value-add
ModelDocumentsReview
Value at cap
$4,106,837
DSCR, year 1
1.12x
Expense ratio
35.8%
Pro formaYr 1Yr 2Yr 3
Gross potential rent$478,044$492,385$507,157
Vacancy-$47,804-$49,239-$50,716
Effective gross income$415,898$428,375$441,226
Operating expenses$148,954$153,423$158,025
Net operating income$266,944$274,953$283,201
Live review

Coach

Cells turn red, amber or green as you type. Each highlight carries the rule, the reason, and a one-click fix you can accept or overrule. What the model cannot prove becomes a question for the person who can answer it.

Reviewing · 40-unit value-add
live
Economic vacancy0%10%FIX
Physical occupancy is not vacancy.
Property taxes$21,000$42,000FIX
Reassessed at the offer price, not the seller's bill.
Management fee4.0%6.0%FIX
Always charged, even when self-managed.
In-place rents$37,200/morent roll?ASK
From the rent roll and the T12, never the summary.
Exit-cap escalator+0.15+0.15PASS
Escalated every year. No compression.
Expense ratio
26.2%35.8%
DSCR, year 1
1.44x1.12x
Value at 6.5% cap
$5.26M$4.11M
The deal desk

After the model, the work starts. Try it.

One at a time. Move a slider, press a lever: the live ones run the same engine as the workspace, on a sample 40-unit deal.

Set your own criteria. Every deal is measured against them, hard limits apart from preferences.

Outside your criteria
  • Going-in cap rate6.56%≥ market 7.00%
  • DSCR, lowest year1.16x≥ 1.25x
  • Avg cash-on-cash1.7%≥ 7%
  • IRR to investors-2.9%≥ 15%
  • Equity multiple0.87x≥ 1.80x
  • Cash flow every yearpositivenever negative
01 / 08 · Acquisition Criteria
The full review

A second opinion on every assumption.

Never buy on someone else's numbers. The review ends in a verdict on each assumption, the price the corrected model supports, a stress test, and the questions to send before you offer.

PASSFIXASK
Live · the same engine as the workspace

Move the price. Watch the gates.

A 40-unit sample deal at a 7.0% market cap rate, 70% loan-to-value, 6.5% for 25 years. Nothing below is an estimate: every figure is recomputed by the model on each change.

Coach · FIX — Vacancy is economic, not physical. The conservative start is 10%; a property manager's written figure can bring it to 7%, never lower.
Value at a 7.0% cap
$3.56M
price $3.00M
DSCR, year 1
1.47x
≥ 1.25x
Avg cash-on-cash
5.8%
≥ 7%
LP IRR
10.5%
≥ 15%
Equity multiple
1.58x
≥ 1.80x
Year-1 NOI
$249K
expense ratio 43.3%
01 · Input
OMT12RENT ROLL
PDF · Excel · CSV
02
ENGINE
03 · Output
PASSFIXASK
A verdict on every assumption
The engine

Code computes. The coach explains. The two never trade places.

10,440
figures cross-checked between the two models on every test run
2
independent implementations of the model that must agree to the cent
3
verdicts on every assumption: pass, fix or ask
0
numbers estimated by the AI. Code computes; the coach explains
vekstio

Bring the deal you are looking at this week.

Start from a blank model or drop the documents. The first review takes about as long as reading the OM.