Your NOI vs. the lender's NOI

Income

UnitsGross potential rent ($/yr)Vacancy and credit loss (%)Other income ($/yr)

Expenses ($/yr)

Property taxesInsuranceUtilitiesRepairs and maintenancePayrollManagement fee (% of EGI)General and administrativeContract servicesMarketing

The lender's assumptions (edit to your lender's)

Lender's vacancy floor (%)Lender's management fee floor (%)Replacement reserves ($/unit/yr)Tax trend (%)Insurance trend (%)

Loan sizing

Loan rate (%)Amortization (years)Min DSCR (x)

Your NOI–

Lender's NOI–

Difference–

Loan on lender's NOI–

Loan lost to the gap–

Estimates only, not a loan quote.