Back

Commercial Real Estate Mortgage Qualifier
   
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 income  
   
Expenses    
Vacancy factor  
Vacancy losses  
EGI Effective Gross Income  
   
Management fees  
Management cost  
   
Other expenses    
Property taxes  
Maintenance  
Utilities  
Insurance  
Legal/accounting  
Misc other expenses  
Labor  
TOTAL other expenses  
   
Reserves per sq.ft.  
Annual reserves  
Allowance for Tenant Improvements and leasing psf  
TI and Leasing  
   
NOI Net operating income  
 
DSCR Debt service coverage ratio  
 
Maximum P and I mortgage payment permitted for this DSCR
 
Interest rate  
Amortization period of loan (months)  
 
Maximum possible mortgage  
     
Spreadsheet copyright of  
A&N Poligraph  
2003-2005  

Back

Copyright ©2004-2005 A&N Poligraph

Sponsored By © A&N Poligraph