The 5 Rent Roll Reconciliation Audits:

1. Lease Expiration Staggering (Rollover Risk): Graph lease expiration dates across all 12 forward months. Red flag: If more than 15%–20% of leases expire in a single quarter (especially November–January during winter leasing slowdowns), the property faces severe seasonal cash flow distress.
2. Security Deposit Reconciliation: Sum all tenant security deposits on the rent roll and verify that the exact dollar amount matches the bank statement for the seller’s segregated security deposit trust account. Any shortfall must be credited to the buyer at closing on the settlement statement.
3. Renovated vs. Unrenovated Unit Premia: Segregate classic unrenovated units from renovated units. Verify the actual achieved premium (Effective Premium = (text{Current Rent}_{text{renovated}} – text{Current Rent}_{text{classic}})). If the broker claims a $150 premium but the rent roll shows only a $45 spread on signed leases, the value-add business plan must be downsized.
4. Resident Delinquency & Eviction Status: Check resident account balances. Residents with balances exceeding $1,000 are typically in active legal eviction. Underwrite these units as 100% vacant and budget an immediate post-close turnover expense ($1,200 turn cost plus legal fees).
5. Concession Addendums: Audit whether reported lease rates are “gross contract” or “net effective.” Sellers often write leases stating $1,400/month with an unrecorded side addendum granting “2 months free,” rendering the true net collection only $1,167/month.

A sponsor acquires a 150-unit garden community. 100 classic units are renovated at $8,000 per unit (quartz countertops, stainless steel appliances, modern vinyl plank flooring, undermount sinks, and LED lighting fixtures). The renovation achieves a proven $175/month rent premium with 5% underwritten vacancy in a 6.0% exit cap rate market:

• Total Capital Invested: 100 units × $8,000 = $800,000
• Gross Annual Revenue Increase: 100 units × $175 × 12 = $210,000/yr
• Net Effective NOI Increase (after 5% vacancy): $210,000 × 0.95 = $199,500/yr
• Annual Unlevered Cash Return on Cost: ($199,500 / $800,000 = mathbf{24.94%})
• Gross Property Value Created: ($199,500 / 0.060 = mathbf{$3,325,000})
• Net Equity Created for Investors: ($3,325,000 – $800,000 = mathbf{+$2,525,000})

For every $1.00 spent on renovations, the partnership created $4.16 in gross property value, generating a 3.16x net equity multiple on renovation capital.

1. T12 Revenue Trend Analysis: Verify whether monthly revenues are trending upward, flat, or declining over the trailing 12 months. Discard T12 averages if the last 3 months (T3) show deteriorating collections.
2. Rent Roll vs. T12 Revenue Cross-Check: Multiply total occupied units on the rent roll by average in-place rent. Ensure the annualized product matches within 2% of the trailing 3-month rental income line item on the T12.
3. Concession Fade Test: Confirm whether the seller granted concessions that expire right after closing, leaving the buyer with above-market lease rates that immediately face tenant non-renewal.
4. Loss-to-Lease Capture Velocity: Model how quickly leases roll over to capture the loss-to-lease gap. Assume a conservative 50% tenant renewal rate and 30 days of turnover vacancy between tenants.
5. RUBS Recovery Audit: Reconcile the utility expense account against the RUBS income account month-by-month. Ensure tenant billbacks do not exceed legally mandated local municipal caps.
6. Bad Debt Eviction Reserve: Audit the accounts receivable ledger. Identify tenants behind on rent by 30, 60, and 90+ days. Budget full legal eviction costs ($800–$1,500/unit) for all 60+ day delinquencies.
7. Off-Balance-Sheet Payroll: Determine if on-site employees receive free housing. Verify that the market rent for staff units is added to GPR and offset by an equal compensation charge in payroll.
8. Property Tax Millage Verification: Contact the local county property tax assessor. Obtain the exact millage rate, equalization ratio, and date of next reassessment. Underwrite full reassessment based on contract purchase price.
9. Insurance Loss Run Scrutiny: Review 5 years of historical insurance claims. Prior claims for roof hail damage, slip-and-falls, or tenant water leaks will inflate insurance premiums by 25% to 50%.
10. Capital Expenditure vs. R&M Audit: Request invoices for all expenditures categorized by the seller as “Capital Additions.” Shift routine maintenance (appliances, carpeting, paint) back into operating expenses.
11. Third-Party Contract Cancellation Terms: Review all vendor agreements (laundry leasing, cable TV bulk agreements, waste management). Identify 30-day termination without penalty clauses.
12. Physical Unit Walk-Through (100% Inspection): Walk every single unit, including occupied units, vacant units, models, and down units. Inspect under-sink plumbing, breaker boxes, and HVAC serial numbers.
13. HVAC & Roof Age Assessment: Tabulate the exact manufacture dates of all HVAC condensers and air handlers. Units older than 12–15 years must be budgeted for immediate replacement in the CapEx schedule ($4,500–$6,500 per unit).
14. Deferred Exterior Maintenance Audit: Retain a licensed structural engineer or commercial inspector to assess foundation settling, parking lot asphalt cracks, balcony railings, and sewer main lines via video scope.
15. Operating Reserve Buffer Sizing: In addition to down payment equity and closing costs, require an unrestricted operating cash reserve equal to 3 to 6 months of operating expenses plus debt service.