1. Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on a $320,000 home, with a $15,000 down payment. [Please be good to the forests and cut and paste only the first and last few rows of the table, not the whole thing.]
2. Using the amortization table you built for the previous question, answer the following [Again, just cut and paste the segment of the amortization table that helps you answer the question.]:
a. How much money will you still owe on the loan after making one full year of payments?
b. How much money will you still owe on the loan after making 15 full years of payments?
c. If you want to refinance after 8 years of making payments, how much financing would you need to secure from your bank to do so?
d. How much money can you expect to pay in interests alone during the full life of the mortgage?