Returns- Preferred, Cash on Cash, IRR, Equity Multiple

Assume your investor requires a 6% preferred return and a 7 year hold. Also, assume an 80/20 cash flow split after the pref. in favor of the investor. Create separate models for each loan option.

For each property, what is the best loan option for returning the highest returns to your investor? Why?

What are your income and expense trending assumptions for each property? Why?

What is your average cash on cash return to the investor over the hold period?

What is your exit cap rate for each property? Why?

What is the IRR to the investor?

What is the investors equity multiple?

Does your original value make sense in any of the scenarios? If yes, why? If not, why and what price does?

What Additional information is needed?

Total rent revenue = GPR Vacancy Loss

= 1,000,000 50,000 10,000

= $940,000

NOI = Total rent revenue Total expenses

= 940,000 (300,000 + 175,000)

= 940,000 475,000

= $465,000