#$2$ Assuming the following data, determine the following:

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

$1\mathrm{.}30$ DCR $($Debt Coverage Ratio$).$ The loan would be amortized for $30$ years, the annual interest

rate is $7\mathrm{.}75\%.$ The annual NOI is $$90,000.$

a$)$ Determine the maximum amount of the loan based on the LTV

b$)$ Determine the monthly payment of the loan using the PMT function in excel

c$)$ Determine the DCR $-$ Debt Coverage Ratio