Which of the two is a better financing decision and why


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.

Solution Preview :

Prepared by a verified Expert
Business Management: Which of the two is a better financing decision and why
Reference No:- TGS01561550

Now Priced at $20 (50% Discount)

Recommended (98%)

Rated (4.3/5)