1. Build a mortgage amortization schedule with the following abilities: Can show PMI costs Can incorporate extra principal payments Displays grand totals of interest, principal and PMI payments 2. Run a real life mortgage scenario for a potential future house (assume you have a 5% down payment). 3. How much interest will be paid over the life of the loan? How much interest will be paid during the first 5 years? 4. How much principal will be paid over the life of the loan? How much principal will be paid during the first 5 years? 5. How many years until your loan balance is half the original loan amount? 6. 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) 7. Create a line graph of the principal balance throughout the life of the loan. 8. If you paid an extra $20 dollars a month on your mortgage payment, how much would you save in PMI and interest payment? 1. Build a mortgage amortization schedule with the following abilities: Can show PMI costs Can incorporate extra principal payments Displays grand totals of interest, principal and PMI payments 2. Run a real life mortgage scenario for a potential future house (assume you have a 5% down payment). 3. How much interest will be paid over the life of the loan? How much interest will be paid during the first 5 years? 4. How much principal will be paid over the life of the loan? How much principal will be paid during the first 5 years? 5. How many years until your loan balance is half the original loan amount? 6. 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) 7. Create a line graph of the principal balance throughout the life of the loan. 8. If you paid an extra $20 dollars a month on your mortgage payment, how much would you save in PMI and interest payment