On Excel,

A. Build a mortgage amortization schedule with the following abilities: 1: Can show PMI costs 2: Can incorporate extra principal payments 3: Displays grand totals of interest, principal and PMI payments

B. Run a real life mortgage scenario for a potential future house (assume you have a 5% down payment).

C. How much interest will be paid over the life of the loan? How much interest will be paid during the first 5 years?

D. How much principal will be paid over the life of the loan? How much principal will be paid during the first 5 years?

E. How many years until your loan balance is half the original loan amount?

F. How much PMI will you pay over the life of the loan? (assume PMI costs 0.75% of the original loan balance annually and assume PMI payments stop once the loan-to-value drops below 80% of original purchase price)

G. Create a line graph of the principal balance throughout the life of the loan.

H. If you paid an extra $20 dollars a month on your mortgage payment, how much would you save in PMI and interest payment?