Key Takeaways
- Validate every line of the seller's financials against independent data sources before building your pro forma.
- Post-sale tax reassessment and imputed management fees are the two most commonly missed expense adjustments.
- Build three scenarios and decide on the conservative case—if it works there, base and optimistic provide upside.
- Frame investment memos for the audience: returns for equity partners, safety metrics for lenders.
This lesson recaps the applied underwriting skills covered in Track 2: data gathering and validation, revenue and expense benchmarking, multi-year pro forma construction, stress-testing, and investment memo presentation. Test your ability to apply these skills with the review questions below.
Data Validation Recap
Applied underwriting starts with professional skepticism. Validate rents against market comps (Apartments.com, CoStar), vacancy against submarket data (CBRE, Marcus & Millichap), and expenses against NAA/IREM benchmarks. The most critical adjustments are typically: post-sale property tax reassessment, imputing management fees for self-managed properties, and adding missing expense categories. If the seller's OER is below 35%, expenses are almost certainly understated.
Pro Forma and Stress-Testing Recap
Multi-year pro formas apply category-specific growth rates (not blanket escalation) and model CapEx as lump-sum items. Exit assumptions use a reversion premium of 25-50 basis points above going-in cap rate. Stress-testing identifies break-even points for vacancy, rent growth, interest rates, exit cap, and CapEx surprises. Always model three scenarios (conservative, base, optimistic) and make acquisition decisions based on the conservative case. Investment memos follow a standard structure, with framing adjusted for the audience—returns for partners, safety for lenders.
Key Takeaways
- ✓Validate every line of the seller's financials against independent data sources before building your pro forma.
- ✓Post-sale tax reassessment and imputed management fees are the two most commonly missed expense adjustments.
- ✓Build three scenarios and decide on the conservative case—if it works there, base and optimistic provide upside.
- ✓Frame investment memos for the audience: returns for equity partners, safety metrics for lenders.
Sources
Common Mistakes to Avoid
Accepting seller-provided T-12 financials at face value without independent verification
Consequence: Revenue is inflated and expenses understated, causing the buyer to overpay by 10-20% relative to true asset value
Correction: Cross-reference every line item against market comps, utility bills, tax records, and third-party benchmarks before building the pro forma
Failing to impute management fees and post-sale tax reassessment in the expense pro forma
Consequence: Underwriting understates true operating costs by 8-15%, inflating projected NOI and leading to overleveraged acquisitions
Correction: Always include a management fee line item (even for self-managed properties) and model property taxes at the post-acquisition assessed value
Building only a base-case scenario without downside or stress-test projections
Consequence: The deal appears profitable under optimistic assumptions but fails under realistic vacancy or expense shocks
Correction: Build three scenarios (conservative, base, optimistic) and make the investment decision on the conservative case
Test Your Knowledge
1.A seller presents a T-12 with a 28% operating expense ratio. What should you conclude?
2.When modeling an exit, what is a conservative reversion premium above the going-in cap rate?
3.Which audience should you lead with DSCR and stress scenarios when presenting a deal?