|
|
|
|
|
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 |
|
