The Super Analyst
deals@thesuperanalyst.ai
Institutional underwriting, automated

Send a rent roll.
Get back a full underwriting model.

Built by Longacre Asset Management. If you're underwriting a multifamily building in New York City, send us the rent roll in whatever shape you have it — a complete model comes back to your inbox. One email, one workbook, however many buildings are in the deal. Nationwide coverage is in beta. We read everything in your package and pull the public record on the property; where a figure isn't published, the model flags exactly which cell to fill in, and everything recalculates. No account, no upload portal, no price to negotiate first.

Email deals@thesuperanalyst.ai Free. No signup. Most models are back in under 10 minutes; very large portfolios take longer.
Example output illustrative

142 Ashcroft Avenue, Bronx

Units
36
Rent-stabilized
14 flagged
Tax record
pulled
Violations
3 found
Built from a PDF rent roll, no T-12 attached
See it work

From inbox to finished model.

An animated walkthrough of the pipeline — not a recording, the actual sequence every deal runs through.

pipeline.trace
01 — received
PDF
170 Hawthorne St — Rent Roll.pdffrom sender@example.com
02 — building
✓ parsed 24 units, flagged 6 rent-stabilized
✓ read the published tax bill; pulled violations history (New York City)
✓ T-12 shown alongside for reference
… writing Inputs, Returns tabs
03 — delivered
InputsRent RollUnit MixIncome & ExpensesViolationsReturns
Model sent back to your inbox as a ready-to-open file.
Why free

We're not selling software.

Longacre Asset Management buys multifamily real estate. Every deal that comes through this pipeline is one more we get to see and underwrite efficiently — that's the actual mechanism, not a marketing line, and it's why this stays free no matter who sends it or what it's for. It also makes the model a little sharper along the way. You get a real model in minutes, at no cost. If a deal isn't a fit for us, that's the end of it on our side — it's still entirely yours to shop. The model itself is a plain Excel file, emailed straight to your inbox — no dashboard to log into, nothing to renew, no strings attached. It's yours to keep.

At Longacre, we're actively working AI into how we run our business, and this pipeline is one concrete piece of that — not a demo, a tool we use ourselves on every deal that comes in.

Track record
Unique deals underwritten
60
Units underwritten
9,968
Recent runs

What the pipeline actually produced.

Two illustrative examples, built the same way every submission is — no price or valuation shown, just what came in and what came back.

142 Ashcroft Ave
Bronx · 36 units
PDF rent roll
Rent-stabilized14 of 36
Violations found3 open
Tax recordpulled
delivered in 6m 40s
Ridgewood 4-Building Package
Queens · 88 units
Excel + T-12
Buildings consolidated4
Sales historyfound on 2 of 4
Expense linesT-12 shown alongside
delivered in 9m 12s

Addresses and figures above are illustrative composites, not a specific client's deal.

What it's built from

Send what you have. We fill in what you don't.

The model is built from the documents you send and the public record on the building itself — not a template with your address typed in. It comes back unpriced: type a purchase price into the model and the returns fill in.

You send
  • Rent roll — Excel, CSV, or a text-based PDF. Scans and photos of a printed rent roll can't be read. A rent roll tab buried inside a larger Excel workbook, such as a sponsor model or a T-12 workbook, is found.
  • The property address — read from the rent roll, the offering memorandum or your email. If it isn't in any of them, we ask you by reply; we never guess one.
  • T-12 / operating statement, if you have one — used as a reference alongside the model; it does not set the model's expense assumptions.
  • Offering memorandum, if there is one — pulled for context, not required.
  • Attach the files to your email. Links to Dropbox, Drive or similar aren't opened.
We pull automatically
  • Tax bill — the published bill, from the city's Department of Finance records. If a bill isn't published, the model flags the cell, you enter it, and the model recalculates; a tax is never estimated.
  • Violations history — building- and unit-level, from New York City's records.
  • Sales & financing history — prior transactions on the property, from New York City's public records.
  • Expense lines — per-unit underwriting benchmarks, each one yours to overwrite in a single cell.
  • Market rents — on a Market Rent tab, from nearby listings, our own rent database and published HUD, Zillow and Census indexes. The rent in the model is the one you type.
What "we pull automatically" means

On New York City deals: six live calls to the city's own records.

Not a cached lookup table and not a market-wide estimate — each New York City submission queries the city's own open-data systems for that specific tax lot, the same records a diligence team would pull by hand.

DOF Property Taxes
NYC Open Data

Reads the property's tax bill as published in the city's DOF records. If a bill isn't published, the model flags the cell for you and recalculates once you enter it — never estimated.

Why it matters: a real, filed tax number in the model — not a per-unit rule of thumb.
DOF Abatements
rgyu-ii48

Checks every active tax-abatement program on the lot — J-51, 421-a/421-g, ICAP/ICIP — with start and end dates.

Why it matters: an abatement expiring mid-hold is a tax cliff; J-51 also triggers rent stabilization for its duration.
DOB + ECB Violations
3h2n-5cm9

Pulls Department of Buildings paper violations and the Environmental Control Board hearings that adjudicate them.

Why it matters: open DOB violations are exactly what surfaces late in a lender's diligence — here on day one.
HPD Violations
NYC Open Data

Aggregates Housing Maintenance Code violations by class, from cosmetic issues up to conditions that stall financing.

Why it matters: Class C violations — no heat, lead paint, vermin — can stop a deal outright.
ACRIS Sales History
City Register

Joins three ACRIS datasets to reconstruct the property's recorded transfer history — price, date, buyer, seller.

Why it matters: a real comp on the actual asset, not a market-wide estimate.
PLUTO Building & Zoning
NYC DCP · quarterly

The city's master tax-lot file — year built, building class, unit count, and zoning FAR.

Why it matters: cross-checks the rent roll's unit count and flags unused air rights.

All six run automatically, per building, on every submission — nothing here requires you to send more than the rent roll.

Market rent

You choose the market rent. We show you what's around it.

The model never assumes a market rent for you. Each building gets a Market Rent tab with one box per unit type for your rent. Leave it empty and the model uses no market rent. Beside it, every figure says where it came from and how many buildings stand behind it.

Nearby listings

Current asking rents near the building, each building counted once, with the count shown. Fewer than three buildings reads as thin.

Our rent database

Rents from rent rolls in our own database, with the date of each reading and whether the roll said the unit was free-market.

Published indexes

HUD, Zillow and Census rent figures for the area, shown for reference. They are never counted as comps.

Your rent

Type a monthly rent for a unit type and it becomes the market rent of that building's free-market units. Rent-stabilized and unmarked units are never changed.

Assumptions

Institutional defaults. Yours to overrule.

The model doesn't hand you an empty spreadsheet, and it doesn't hide its math either. It starts from defaults built on real underwriting practice, and every one of them sits in the open, on the Inputs tab, for you to change.

Taxes

Read from the published tax bill where we have it. If the bill isn't there, the model flags the exact cell, you enter the figure from the bill, and the whole model recalculates. We never guess a tax.

Insurance & expenses

Per-unit benchmarks, not a flat guess. Every line sits on the Inputs tab; swap in your own number in one cell.

Rent roll

What you sent, as sent. Free-market units earn a market rent only when you type one; a vacant rent-stabilized unit with no legal rent on the roll is assumed at $1,250 a month, and the model says so.

Cap rate & returns

A starting point for the deal, not a claim about what it's worth.

The number that matters is the one you land on, not the one the model started with. Open it, change what you'd change, and it's yours. Or reply to the email with a change, such as “price $20M” or “exit cap 5.5%”, and we send back the updated model.