You can purchase a new duplex for $2,000,000. The bank has quoted her an 75% LTV. The

Fantastic news! We've Found the answer you've been seeking!

Question:

You can purchase a new duplex for $2,000,000. The bank has quoted her an 75% LTV. The loan would be
amortized for 30 years, the annual interest rate is 5.5%. The annual NOI is $175,000. Determine the monthly
payment of the loan using the PMT function in excel