You are in the process of buying a house. Your mortgage lender reviewed your credit score, employment history, debt-to-income ratio, and available funds you’ve set aside for the down payment. He quoted you a 2.75% interest rate for a 15-year loan, and a 3.50% rate for a 30-year mortgage loan. The house you want is $200,000 and you can make a 10% down payment. Using Excel, construct an amortization schedule for the amount you need to borrow from your mortgage lender for each loan option. Which of the two is a better financing decision, and why? Show all formulas required to perform these calculations and fully explain your decision making process.

Answer rating: 100% (QA)

Value of the House Payment Schedule at 275 for 15 Years Principal 200000 10 down Payment 20000 Year ... View the full answer