Browsing "Personal Finance & Economics"

Mortgage Amortization Calculator

The 6 sheets in this spreadsheet compare the total principle and interest payments for the following scenarios:

$75,000 15-year mortgage @ 3.25%

$75,000 30-year mortgage @ 4.1%

$150,000 15-year mortgage @ 3.25%

$150,000 30-year mortgage @ 4.1%

$250,000 15-year mortgage @ 3.25%

$250,000 30-year mortgage @ 4.1%

Please download the file and complete the assignment for this week.

Click here to download: Mortgage amortization schedule1