Three seller documents read end to end and tied against each other. Building name, location and tenants removed; the city is not named, and every money figure is scaled by one constant factor (ratios and ties unchanged). Every figure below carries the page or cell it came from.
The rent roll and the T-12 agree with each other and with the OM's in-place rent. The gap is in the pro forma: the OM's "in-place" NOI of $614,475 is 32% above the trailing actual and 19% above the NOI we would underwrite ($517,544). Almost half of the lift is expense cuts that the T-12 itself does not support. At 1.25x DSCR that is about $1.0M of loan proceeds riding on assumptions.
OM "in-place" column against the T-12 actual, line by line (OM p.32–33; T-12 totals).
| Line | T-12 actual | OM in-place | Effect on NOI | Supported by the file? |
|---|---|---|---|---|
| Rental income (net) | $774,170 | $838,833 | +$64,663 | Mostly. OM figure is after 5% vacancy and 0.25% bad debt. Current rent roll annualises to $848,772; T-12 is low because of lease-up early in the year. |
| Parking | $30,641 | $43,587 | +$12,946 | Partly. January billed $2,980 = $35,760 a year. |
| Insurance | $98,583 | $60,907 | +$37,676 | No. Assumes $34,800 for liability and property against $72,477 paid. Needs a bound quote. |
| Maintenance | $58,356 | $32,625 | +$25,731 | No. See finding 1: months after renovation run higher, not lower. |
| Contract services | $41,742 | $23,925 | +$17,817 | No. Same as above. |
| Management fee | $40,862 | $27,267 | +$13,595 | Only with a new manager at 3%. Current fee is 4.9% of income. |
| Electric | $22,784 | $17,912 | +$4,872 | Doubtful. Dec–Jan bills ($2,714 and $2,984) match Feb–Mar; the spike looks seasonal. |
| Payroll | $15,377* | $43,500 | −$28,123 | Conservative. *The OM's "payroll" is leasing commissions (T-12 account 66010); there is no on-site payroll today. |
| Taxes | $38,251 | $39,833 | −$1,582 | See finding 3 on abatement. |
| NOI | $466,880 | $614,475 | +$147,595 | Revenue +$77,609; expense cuts +$69,986 |
The OM halves maintenance and contract services ($100,098 to $56,550), saying February–May were inflated by renovating vacant units. In the T-12, repairs, turnover and contract lines average $8,242 a month in Feb–May and $9,286 a month in Jun–Jan. The months after the renovation cost more.
T-12 accounts 60000–63000, 65100 · OM p.31 note on electric, p.33Actual premium is $98,583 ($1,972 per unit). The OM uses $60,907. Until a bound quote says otherwise, the actual premium is the number to underwrite.
T-12 account 70000 · OM p.31 insurance summaryReal estate tax is $28,014 a year ($560 per unit) for a 50-unit building after its redevelopment. That level is consistent with a tax abatement. If it ends inside the loan term, taxes reset to the full assessment. Ask for the abatement certificate and its end date.
T-12 account 68010 · OM, redevelopment section29 of 48 leases expire by July 2026; 15 of them in April and May. Rents are in place, but the next six months decide whether the run-rate holds.
Rent roll, lease end columnDeposits held total $136,938, about 1.9 months of rent. Some units hold roughly two months; deposits above local limits on some units come to about $39,000. Unless part of it is pet or last-month money, it is a refund liability that transfers with the asset.
Rent roll, deposits held columnThe OM adds $103,878 of below-market leases. Its comp set averages $1,565 for a one-bed, but the top of the set are recent new builds; the subject is an older building converted to apartments. Only 6 of 50 units carry a market rent in the rent roll, so loss-to-lease cannot be checked from the seller's own data.
OM p.26 rent comps · rent roll market rent summary$2,399 owed across 8 units, one of them more than a month ($1,720). Prepayments of $6,416. Concessions under 0.5% of rent.
Rent roll, balance due · T-12 account 41500Loan size at 1.25x DSCR, 30-year amortisation, and a 9% debt yield. Rates are illustrative; swap in your own.
| NOI basis | NOI | DSCR 1.25x @ 6.25% | DSCR 1.25x @ 6.75% | Debt yield 9% |
|---|---|---|---|---|
| T-12 actual | $466,880 | $5.06M | $4.80M | $5.19M |
| Titleman lender NOI | $517,544 | $5.60M | $5.32M | $5.75M |
| Run-rate, last 3 months × 4 | $546,154 | $5.91M | $5.61M | $6.07M |
| Broker in-place | $614,475 | $6.65M | $6.32M | $6.83M |
Titleman lender NOI: full-occupancy rent $882,180 less 5% vacancy and 0.5% credit loss, other income at the last-three-month run-rate ($61,332), T-12 expenses as reported plus $261 per unit of replacement reserves.