Sheet $1$: Apartments

Going Out

$7\mathrm{.}15\%$ Cap Rate

$3\mathrm{.}15\%$ Cost of Sale

$9\mathrm{.}25\%$ Discount Rate

Going in Cap

$6\mathrm{.}65\%$ Rate

Max Loan to

$90\%$ Value

Required

$1\mathrm{.}25$ DSCR

$4\mathrm{.}85\%$ Loan Rate

$30$Loan Term

Sheet $2$: Office

Apartment

Based on the going in cap rate what would be the purchase price $?$

Based on the maximum LTV and the value from above how much can be borrowed?

What would the monthly payment be on that loan?

Based on the maximum debt service coverage ratio and the purchase price found how much can be borrowed?

What would the monthly payment be on that loan?

What is the actual maximum amount that could be borrowed?

What is the NPV of the property for this use if borrowing the maximum about allowed $($levered NPV$)?$

What is the IRR of the property for this use if borrowing the maximum about allowed $($levered IRR$)?$

What is the maximum amount that should be paid for a non$-$negative all equity NPV $($unlevered NPV$)?$

What is the all equity IRR $($unlevered IRR$)?$

Office

Based on the going in cap rate what would be the purchase price $?$

Based on the maximum LTV and the value from above how much can be borrowed?

What would the monthly payment be on that loan?

Based on the maximum debt service coverage ratio and the purchase price found how much can be borrowed?

What would the monthly payment be on that loan?

What is the actual maximum amount that could be borrowed?

What is the NPV of the property for this use if borrowing the maximum about allowed $($levered NPV$)?$

What is the IRR of the property for this use if borrowing the maximum about allowed $($levered IRR$)?$

What is the maximum amount that should be paid for a non$-$negative all equity NPV $($unlevered NPV$)?$

What is the all equity IRR $($unlevered IRR$)?$

Recommendation

What should be the recommended use of the property?

Why is this the recommended use of the property?