you are considerig a real estate investment with the following paramaters and a five year holding period calculate the unlevered NPV and IRR please make your calculations to the right of the data on this worksheet

Based solely on these calculations would you proceed witht the investment and why

Purchase Price : $$300,300,000$

Anticipated NOI $($year $1)$: $$2,400,000$

NOI growth rate : $3\mathrm{.}0\%$

Financing

DSCR $1\mathrm{.}30$

payment frequency Monthly

Mortgage rate $7\mathrm{.}0\%$

Mortgage rate per month $0\mathrm{.}5750\%$

Term $($years$)4$

Amortization $($years$)20$

Anticipated cap rate on sale $8\mathrm{.}0\%$

Required equity return $15,0\%$

Required WACC $11\mathrm{.}0\%$