Property Assumptions: Purchase Price: Year 1 PGI: PGI Growth Rate (Annual): Annual Vacancy and Collection Loss (VCL): Operating Expenses (OER): Terminal Capitalization Rate for Sales Price Anticipated Holding Period: Maximum LTV: Interest Rate: Amortization Period: Payments Per Year: $4,000000 $600,000 3% 5% 35% .09 Capitalize NOI (Year 4) 3 Years 70% 5% 30 Years 12 Discount (Hurdle) Rate (Unleveraged & levered): 15% 1. What is the Loan Amount using the LTV Ratio? 2. What is the Initial Investment (Cash or Equity Investment)? 3. What is the Loan Balance at the end of 3 years? 4. What is the Annual Debt Service (ADS)? 5. What is the Unleveraged IRR and NPV? 6. What is the leveraged IRR and NPV? 7. What is the DCR for Years 1-3? 8. What is the NOI for Years 1-4? 9. What is the "Going In" (aka overall) Capitalization Rate? 10. What is the Cash on Cash (BTCF) for Years 1-3? 11. What is the Mortgage Constant? 12. Based on the NPV's and IRR's (unleveraged and leveraged, hurdle rates), do you recommend purchasing this property? Please explain.