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?
