If you borrow $400,000 at an APR of 4% for 15 years, you will pay more per month than if you borrow the money for 30 years at 4%. However, you will pay much more in interest over the life of the loan. Answer the questions below (10 points): a. What is the monthly payment on the 15-year mortgage, to the nearest cent? (Be sure to use Excel to calculate the monthly payment.)

b. What is the total interest paid on the 15-year mortgage?

C. What is the monthly payment on the 30-year mortgage, to the nearest cent?

d. What is the total interest paid on the 30-year mortgage?

e. How much more interest in paid on the 30-year loan?