About this video
Ellie underwrites a multifamily acquisition and connects a tax reassessment in the data room to NOI, loan coverage and the bid price.
Full description
Brackenfield Crossing, a multifamily acquisition: Ellie reads the diligence room by category and finds a property tax reassessment that changes year-one NOI and the going-in yield. The notice also triggers the covenant basis in a separate loan agreement, so coverage and the bid move together. Refresh of the Initial Underwriting and Data Room Summarizer demos.
Key points
- Data room summarised by category before underwriting
- Tax reassessment traced into NOI, yield and loan coverage
- Replaces the Initial Underwriting Loom demo
Transcript
Larchfield is a multifamily underwriting demo about Brackenfield Crossing, a 312 unit community in Chandler, Arizona. The marketing pack sets the starting point and the investment committee decides this week. Here, Ellie walks through the diligence behind it. The broker's guide price is $69.5 million. The data room brings together the marketing case, property financials, and legal diligence. Ellie is asked to explain every movement. The largest change is tax.
The county has reassessed, but the broker's pro forma still carries the old figure. Year 1 net operating income falls to $3.47 million. yield 5% not 5.7. The other diligence assumptions each trace to a source down to the aars. The recommendation proceed at $66 million or below, not 69 1/2. Next, does the revised deal still comply with the debt? The loan agreement says coverage must use the reassess tax once notice is issued. Notice has been issued.
So coverage is 1.256 times, not the broker's 1.39. It passes a floor of 1.2, but with only 4.45% of headroom, tested quarterly with no right to cure. From there, Ellie produces the committee workbook with the supporting document beside every figure. It bridges the marketing case to the diligence case line by line and shows what each change costs. The dashboard starts with the case as marketed, then what diligence moved, covenant coverage, and the effective purchase price on yield.
The final output is the investment committee brief. It carries the recommendation. Click a figure and the source document opens beside it. Here, the county's notice of value with the evidence behind every conclusion. This is what a general model is likely to miss. The tax notice is not just another assumption. Ellie concludes the deal works at $66 million or below, not 69 a half because it activates wording in a separate loan document changing income yield covenant headroom and the bid at once. Ellie follows that dependency back to the loan agreement. One diligence room in one decision ready underwrite out.
From data room to cited IC memo
Video details
- Roles
- Owner, Investor / LP, Lender
- Processes
- Acquisitions, Due Diligence
- Geographies
- US
- Markets
- United States
- Tags
- author-demo-2, underwriting, multifamily, refresh