FIN-650 Topic 3 DQ 1- You are in the process of buying a house. Your mortgage lender reviewed your credit score……

A+ Tutorials

FIN-650 Topic 3 DQ 1

Managerial Finance – Time Value of Money and Valuation of Fixed Income Securities

Grand Canyon University (FIN-650-O500)

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.