Question

You want to buy your dream house. You currently have $15,000 saved and you need to have a 10% down payment plus an additional 5% of the loan amount for closing costs. Assume the cost of the house is $956,216. You can earn 7.5% per year in a savings account per year. How long will it be before you have enough money for the down payment and closing costs?

Given your current credit, you secure a 15-year fixed rate mortgage at 3.12%. Calculate your monthly mortgage payment; you must pay the home loan on the 1st of each month.

In Excel, create an amortization schedule for your home loan. You must pay the home loan on the 1st of each month.

Now, consider the possibility of being able to make one additional mortgage payment per year for each of the 15 years. How much will you save in interest payments?

Answer 1

Total Down payment and Closing cost required (FV)= Down payment+Closing cost= 956216*10%+5%*956216=$143432.4

Interest rate=7.5%, PV=15000, nper=?

Now, if it takes x number of years to have enough money for the down payment and closing cost, then

15000*(1+7.5%)^x=143432.4

or, x= 31.21 or 31 years (Approx)

Hence, it will take 31 years to have the required amount.

Now, Loan amount (PV)=956216*(1-10%)=$860594.4, monthly interest rate=3.12%/12=0.26%, nper=15*12=180 months, PMT=?

Hence, your monthly payment would be $5977.36

Below is the amortization schedule for the same:

Now, if you are able to make one additional payment each year. then below is the amortization schedule:

Here total interest payment= 1055501.31-860594.4=$194906.91

Earlier total interest payment= 5977.36*180-860594.4=$215330.4

Hence, you will save interest amount= (215330.4-194906.91)=$20423.49