Purchase Price: $15M, 12,500SF, GPR: $44.50, 10-year hold period, Full Service Lease - at year 5 Expense Stop and turns to a NNN lease, Operating Expenses $14.50/SF, LTV 50%, 10-year treasury 4.75%, Lender's Risk Premium 2.50%, 25 year amortization, Interest Only, Going-Out Cap 7.5%.

- Going-In Cap Rate?

- Annual Rate of Return?

- Total Return at Year 10?

- Sale Price?

- What is the all-in loan interest rate?

- What is the monthly loan payment (use =pmt formula in Excel or a financial calculator)?

- What is the annual debt service?

- What is the loan balloon payment?

- What is the residual amount at year 10?

- What is the cash equity?

- What is the return on capital appreciation?

Answer rating: 100% (QA)

To solve this problem we need to make the following calculations GoingIn Cap Rate GoingIn Cap Rate G... View the full answer