real estate finance
"Put appropriate figures in corresponding cells "Sheet 1 "Annual Property Operating Data "Sheet 2 "Cash Flow Analysis "Sheet 3 "Alternative Cash Sales "Sheet 4 "Internal Rate of Return "Sheet 5 "Assumptions "Property Name " Annual Property Operating Data "Location "Type of Property " Purchase Price "Size of Property (Sq . m /Units " Plus Acquisition costs " Plus Loan Points "0 "Purpose of analysis " Less Mortgages "0 " Equals Initial Investment "0 "Assessed /Appraised Values "Land "0 "Improvements "0 "Amort "Loan "Personal Property "0 "Balance "Periodic Pmt "Pmts /Yr "Interest "Period "Term "Total "0 "0 "1st "0 "0 "12 "0 "0 "0 "2nd "0 "0 "12

"0 "0 "0 "Adjusted Basis as of "18-Oct-08 "0 /SQ m "ALL FIGURES ARE ANNUAL "or /Unit "of GOI "COMMENTS /FOOTNOTES "1 " POTENTIAL RENTAL INCOME "0 "2 " Plus : Other Income (affected by vacancy "3 " Less : Vacancy Cr . Losses "0 .07 "of "0 "0 "4 " EFFECTIVE RENTAL INCOME "0 "5 " Plus : Other Income (not affected by vacancy "6 " GROSS OPERATING INCOME "0 " OPERATING EXPENSES "7 " Real Estate Taxes "0 "8 " Personal Property Taxes "0 "9 " Property Insurance "0 "10 " Off Site Management "0 "11 " Payroll "0 "12 " Expenses /Benefits "0 "13 " Taxes /Worker 's Compensation "0 "14 " Repairs and Maintenance "0 " Utilities "0 "15 "0 "16 "0 "17 "0 "18 "0 "19 " Accounting and Legal "0 "20 " Licenses /Permits "0 "21 " Advertising "0 "22 " Supplies "0 "23 " Miscellaneous Contract Services "0 "24 "0 "25 "0 "26 "0 "27 "0 "28 "0 "29 " TOTAL OPERATING EXPENSES "0 "30 " NET OPERATING INCOME "0 "31 " Less : Annual Debt Service "0 "32 " Less : Funded Reserves "0 "33 " Less : Leasing Commissions "0 "34 " Less : Capital Additions "0 "35 "0 " Cash Flow Analysis "Property Name " Purchase Price "0 "Prepared For " Plus Ascuisition Costs "0 "Prepared By "0 " Plus Loan Points "0 "Date Prepared "18-Oct-08 " Less Mortgages "0 " Equals Initial Investment "0 "Mortgage Data "Cost Recovery Data "1st Mortgage "2nd Mortgage "Improvements "Personal Property "Amount "0 "0 " Value "0 "Interest Rate "0 "0 " C . R . Method "SL "Amortization Period "0 "0 " Useful Life "5 "Loan Term "0 "0 " In Service Date "38292 "Payments /Year "12 "12 " Date of Sale "40117 "Periodic Payment "0 "0 " Recapture "Annual Debt Service "0 "0 " Investment Tax "Points "Taxable Income "Year "2004 "2005 "2006 "2007 "2008 "2009 "1 " Potential Rental Income "0 "0 "0 "0 "0 "0 "2 Other Income affected by vacancy "0 "0 "0 "0 "0 "0 "3 "-Vacancy Credit Losses "0 "0 "0 "0 "0 "0 "4 Effective Rental Income "0 "0 "0 "0 "0 "0 "5 Other Income not affected by vacancy "0 "0 "0 "0 "0 "0 "6 Gross Operating Income "0 "0 "0 "0 "0 "0 "7 "-Operating Expenses "0 "0 "0 "0 "0 "0 "8 NET OPERATING INCOME "0 "0 "0 "0 "0 "0 "9 "-Interest - 1st Mortgage "0 "0 "0 "0 "0 "10 "-Interest - 2nd Mortgage "0 "0 "0 "0 "0 "11 "-Cost Recovery - Improvements "0 "0 "0 "0 "0 "12 "-Cost Recovery - Personal Property "13 "-Amortization of Loan Points "0 "0 "0 "0 "0...





