Why do sponsors keep showing me trailing 12 on properties that were 60 percent occupied for half of it

The T12 is doing a lot of work here, and the assumption carrying the most weight is that the renovation period represents a temporary aberration rather than an ongoing operating risk. If units turned slowly, if concessions are still being burned off, or if the rent growth on restabilized units is newer than 90 days, the T12 NOI is closer to a best-case trailing number than a baseline.

What you actually want is trailing 3-month NOI annualized, with the rent roll dated and unit-by-unit. Not a leasing PDF. A dated, signed rent roll with lease start dates, current rent, and any concessions outstanding. If the sponsor cannot produce that within 48 hours, the operating data is not organized well enough to underwrite from, and that is its own signal.

The exit cap assumption is the second problem. A 5.8 exit cap on pro forma stabilized NOI that includes rent growth not yet in the rent roll means you are buying current-occupancy risk and paying for a future-income assumption at a compressed cap rate. That math works when the market is tightening and execution is clean. In Mesquite specifically, you would want to know where submarket vacancy sits today relative to the asset's current occupancy, and whether the rent premiums on renovated units are holding or getting discounted to lease.

The risk you have not named: renovation-period concessions that run off the books. Sponsors sometimes grant free-rent concessions to fill units quickly post-renovation, and those show up as occupied on the rent roll but distort effective gross income. Ask for a concession schedule alongside the rent roll.

Ask the sponsor to send you three things: a dated rent roll with lease start dates and concession detail, trailing 3-month actual collections (not scheduled), and the submarket vacancy report they are using to support the 5.8 exit cap. What did they say when you asked for the rent roll directly?

The undated leasing PDF is the tell for me. Any sponsor who has actually stabilized asks their property manager to pull a dated rent roll in about ten minutes, so the absence of dates is not an accident.

For Mesquite specifically, the submarket has had enough new supply pressure that a 5.8 exit cap on projected rent growth is doing real work. DFW as a whole has been compressing but Mesquite is not Uptown, and you're underwriting a renovation story on top of a supply story at the same time.

What does their actual T3 occupancy number look like if you back it out of the leasing update yourself using unit count and quoted gross potential rent?

The 5.8 exit cap on rent growth they haven't hit yet is the part that would make me put the deck down. In Mesquite right now you've got new supply pressure from the broader DFW pipeline, and if that pro forma is assuming 3 to 4 percent annual rent bumps to get to the stabilized NOI they're capping out on, that's two assumptions stacked on top of each other, either of which can break the return. My Shreveport LP position had a similar structure in the deck, blended occupancy from a period that included six months of tenant build-out on the retail floor, and the sponsor presented it as though lease-up risk was already behind us. It wasn't. We were looking at a number that reflected maybe seven months of anything resembling normal operations.

What I started asking for after that deal, and what I'd ask for here, is a monthly NOI bridge going back 18 months, month by month, not blended, so you can see exactly when the property crossed whatever occupancy threshold the sponsor is calling stabilized and how long it has held there. On that Shreveport deal the honest number was four months at target occupancy, not twelve, and the delta between the T12 NOI and the run-rate NOI once I built the bridge was about $38,000 annualized. Not deal-killing on its own but it repriced the risk. What does their current rent roll show for actual signed leases versus leases in process, and have they separated those two columns anywhere in what they sent you?

What's the trailing 90-day collected rent, not scheduled, not projected, actually collected and deposited?

The T3 and T6 collected revenue, not scheduled rent, is what actually anchors a stabilized NOI claim after a renovation lease-up, and a sponsor who cannot produce it by unit, with move-in dates, is asking you to underwrite a projection dressed as history.

The piece worth flagging separately: renovation lease-ups in Mesquite right now are competing with a lot of new Class A product in the DFW suburbs, so the assumption that they can hold stabilized occupancy once the concession period burns off deserves its own line in your model, not just a cap rate sensitivity. If the rent growth in that pro forma NOI was needed to hit the 5.8 exit and they have not actually seasoned those rents for at least two full rent cycles, the exit cap is doing double duty, compressing on optimistic NOI and optimistic income simultaneously.

What does the debt structure look like, specifically whether there is a floating rate bridge loan with an extension tied to a DSCR test, because that is where a lease-up that runs six months long stops being a patience problem and becomes a capital call?

Ask them for the actual rent ledger out of their property management software, not a summary someone built in Excel. Yardi or Appfolio will spit out a collected cash report by month that nobody can backdate.

What was the renovation scope, full unit turns or just common areas and roofs? Because if they were doing hallways during that low-occupancy window, there's no mechanical reason rents jump post-reno and that 5.8 exit cap is already assuming a story they haven't told you yet.

The occupancy curve is what I want before anything else: specifically, what month did they cross 85 percent and hold it for 30 consecutive days, because that date tells you how many months of genuinely stabilized income actually exist in that T12 window. If it was November, you have maybe two months of real data dressed up as twelve.

What is the current physical occupancy versus economic occupancy on that rent roll?