In: Finance
You are looking at buying a house with a $180,000 loan amount. You have 2 options for this loan: 1) 15 Year Loan, you can get a monthly interest rate of 0.3% monthly. A) What is your monthly payment? B) What is the total amount you would pay out of pocket over the life of the loan? C) How much interest have you paid?
2) 30 year Loan, you can get a monthly interest rate of 0.3125% monthly. A) What is your monthly payment? B) What is the total amount you would pay over the life of the loan? C) How much interest have you paid?
Please do on excel and show formula/calculations