a) Find the monthly mortgage payment

b) FInd the EGI in year 1

c) Find the NOI in year 1

d)Fing PGI in year 3

e)Find the Levered BTCF in year 3

f)Find MI in year 4

g)Find vacancy and collection losses in year 5

h)Find the Sale price of the property in year 5

i)Find the selling costs for the property in year 5

Property: Purchase Price $6,785,000 $0 Acquisition Costs Year 1 PGI $1,289,150 PGI Growth Rate/year 5.0% Year 1 Miscellaneous Income $271,400 Miscellaneous Income Growth Rate/year 3.6% Annual Vacancy and Collection Losses/year 7.0% $514,608 3.4% Year 1 Operating Expense Operating Expense Annual Growth Rate Year 1 Capital Expenditures Capital Expenditures Annual Growth Rate $66,164 1.8% 5 Holding period (years) Property to be sold for NO16 capitalized at (Terminal Cap Rate): Selling Expenses in year 5 14.2% 7.3% 79% 6.03% Financing: LTV Loan rate (APR) Loan Costs (% of Mortgage Value) Loan term (years) Monthly Amortization / monthly payments 1.30% 30 Pre-tax Required Return 43.00% Property: Purchase Price $6,785,000 $0 Acquisition Costs Year 1 PGI $1,289,150 PGI Growth Rate/year 5.0% Year 1 Miscellaneous Income $271,400 Miscellaneous Income Growth Rate/year 3.6% Annual Vacancy and Collection Losses/year 7.0% $514,608 3.4% Year 1 Operating Expense Operating Expense Annual Growth Rate Year 1 Capital Expenditures Capital Expenditures Annual Growth Rate $66,164 1.8% 5 Holding period (years) Property to be sold for NO16 capitalized at (Terminal Cap Rate): Selling Expenses in year 5 14.2% 7.3% 79% 6.03% Financing: LTV Loan rate (APR) Loan Costs (% of Mortgage Value) Loan term (years) Monthly Amortization / monthly payments 1.30% 30 Pre-tax Required Return 43.00%