Discussion Question 1
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.
Discussion Question 2
To live comfortably in retirement, you decide you will need to save $2 million by the time you are 65 (you are 30 years old today). You will start a new retirement savings account today and contribute the same amount of money on every birthday up to and including your 65th birthday. Using TVM principles, how much you must set aside each year to make sure that you hit your goal target goal if the interest rate is 5%? What flaws might exist in your calculations, and what variables could lead to different outcomes? What actions could you take ensure you reach your target goal?