Commercial Real Estate Mortgage Qualifier
Annual Income
Total potential rent from all units
CAM reimbursement
Property tax reimbursement
Insurance reimbursement
Percentage rents
Misc. other income
Number of inside square feet
Total potential annual income
Expenses
Vacancy factor
Vacancy losses
EGI Effective Gross Annual Income
Management fees
Management cost
Other annual expenses
Property taxes
Maintenance
Utilities
Insurance
Legal/accounting
Misc other expenses
Labor
TOTAL other annual expenses
Reserves per sq.ft.
Annual reserves
Allowance for Tenant Improvements and leasing psf
TI and Leasing
NOI Net operating income, annual
DSCR Debt service coverage ratio
Maximum P and I monthly mortgage payment
permitted for this DSCR
Interest rate per year
Amortization period of loan (months)
Maximum possible mortgage
Spreadsheet copyright of
www.Mortgage-investments.com
2003-2005