Upload a listing's offering memorandum, T12, and rent roll to Claude Cowork for a first-pass value-add review: normalized NOI, below-market units, CapEx questions for the inspection, and opening, target, and walk-away offers
Carl Mcknight, a rental property investor in Tennessee, posted a full breakdown on the BiggerPockets Real Estate Technology forum of a 47-unit Class C apartment property in Kentucky, built in 1972, with all utilities paid by the landlord and 74.5% occupancy. He downloaded the offering memorandum, T12, and rent roll (and suggests Crexi or LoopNet for investors without broker relationships) and uploaded the files to a Claude Cowork agent. According to the post, the agent researched the local market (crime rate, affordable housing supply, comparable rents, and vacancy rates), and the T12 review found management fees recorded in only 5 of 12 months; normalizing the management fee at 8.5% of effective gross income lowered NOI from the seller's stated $161,691 to $147,055. The rent roll review listed eight occupied units paying below market rent, a $23,040 a year loss to lease, and broke out vacancy by unit type, with 7 of 16 studios vacant. The agent also questioned the RUBS utility billing upside: if market rents in the area already include utilities, billing tenants for utilities pushes the all-in cost above comparable properties. The post ends with a CapEx inspection list for a 1972 building and an opening, target, and walk-away offer table on a bridge loan. Mcknight says the analysis took about 10 minutes, compared with hours of data entry a year earlier.
At a glance
- Tools used
- ClaudeClaude Cowork →
- Category
- Investing & underwriting
- Audience
- investor
- Difficulty
- No-code setup
- Source
- Using Claude Cowork to Underwrite a Deal in 10 mins.
Carl Mcknight (BiggerPockets forums) · Forum post · Mar 12, 2026 - First step
- Put the offering memorandum, T12, and rent roll for one deal you already underwrote by hand into one folder, run the review in Claude Cowork, and compare Claude's normalized NOI and loss-to-lease numbers line by line with your own spreadsheet.
Compliance note: Treat Claude's review as a first pass: check every number against the T12 and rent roll, confirm market rents and RUBS rules locally (some states and cities restrict ratio utility billing), and get inspections before any earnest money goes non-refundable.
Suggested prompt
Written by this directory, inspired by the source. Replace the [bracketed] parts.
Review the offering memorandum, T12, and rent roll in this folder for a value-add multifamily deal: [folder]. 1. T12: list total income and each expense line by month. Flag any expense line that is missing or drops to $0 in some months, normalize that line (management fee at [8.5%] of effective gross income unless I say otherwise), and show as-stated NOI next to normalized NOI. Flag any month where total income jumps above the 12-month average as a possible one-time bump. Flag repairs and maintenance, payroll, and insurance that look low per unit for the building's age and class, and list deferred-maintenance questions for the seller and the inspector. Ask the seller for the current insurance renewal quote and show normalized NOI using that premium in place of the T12 insurance line. If the seller provides 12 months of bank statements, reconcile deposits against T12 income. 2. Rent roll: occupancy and average rent by unit type, every occupied unit paying below [market rent by unit type], and the annual loss to lease. 3. Utilities: who pays each utility, cost per unit per year, and whether comparable rents in [market] include utilities, before counting any RUBS income. 4. CapEx: list inspection questions based on the year built. 5. Offers: opening, target, and walk-away prices with cap rate on normalized NOI, cash-on-cash, and DSCR at [loan terms]. Cite the file and line for every number, and mark any number you estimated.
Get 50 AI Prompts for Real Estate Agents, free
Subscribe to the Daily 5 and download the 48-page PDF right away. The prompts help with:
- Getting more leads from the contacts already in your CRM
- Faster follow-up, so no text or inquiry goes unanswered
- Less time on listing descriptions, paperwork, and showing instructions
- Copy-paste prompts tested by working agents, brokers, and landlords
- Five new real-world AI use cases every weekday morning in the Daily 5
Confirm by email. Unsubscribe in one click. Review every AI draft for accuracy and fair housing compliance before you send it.