Suppose that you obtain a ten-year $ 100,000 loan to purchase a house and the annual interest rate is 7 percent, what should be your monthly payment of principal and interest for the next ten years? (Hint: In the Excel PMT process, convert the annual interest rate and payment periods to the monthly rate and payment periods).

Suppose the length of the loan is twenty years in Question 5, what should your monthly payment of principal and interest be for the next twenty years?