2) Assuming the following data, determine the following: You can purchase a new duplex for $800,000. The bank has quoted her an 80% LTV, and a 1.25 DCR (Debt Coverage Ratio). The loan would be amortized for 30 years, the annual interest rate is 3.50%. The annual NOI is $45,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