What does the tax notice do to your bid? (EN)

3:08 · English · Acquisitions

Watch this video

Enter your details to access the library. We'll email you a code to verify your address.

See how we use your data in our Privacy Policy.

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.

Fifth Dimension for deal teams

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