Amortization Spreadsheet and Graph

Cause you really can’t have enough tools to compare home loans.

I suspect if you are looking for one of these already, then you are likely to be able to ferret out all the nuances, but here are the main features of v1.0:

  • Displays 3 down-payment only amortization schedules
  • Displays 1 Combo or second loan (good for avoiding Mortgage Insurance (MI) or if you don’t have down-payment money)
  • Graphs the 4 loans by total cost
  • Calculates principle and interest payments
  • Estimates MI from an MI Factor value
  • Allows for estimated Tax and Insurance values
  • Tracks actual payments and check numbers
  • Recalculates P and I if your actual payment exceeds your PITI (principle, interest, tax, insurance) payment

Mortgage Comparisons.xls

Creative Commons License

This work is licensed under a slightly modified Creative Commons Attribution-Noncommercial-Share Alike 3.0 License. Specifically, you CAN make commercial use of the work; you CANNOT sell the work or derivatives.

Leave a Reply

Your email address will not be published. Required fields are marked *