Loan Calculator

Loan Calculator Spreadsheet

The loan calculator. The one thing you wish you never had to use. This Microsoft Excel spreadsheet was orignally authored by a friend of mine, but with his permission I’ve made some modifications and posted it here for everyone to use.

[wpdm_file id=5]

Prepare For The Future

Before you make that big purchase see what your going to be paying each month. Simply put in:

  1. Amount of the loan
  2. Interest rate
  3. How many months the loan is going to be

and this spreadsheet will automatically tell you:

  1. Monthly payment
  2. Amount of money thrown away in interest
  3. How much of your payment is going to the principle each month

Pay It Off Quicker

One of the additions I’ve made is the ability to see how paying extra each month can affect the time it takes to pay down the loan and more importantly how much money you save that would be going to interest. Its absolutely amazing how much money you can save by paying even just $100 more a month.

One Response to “Loan Calculator”


Leave a Reply

Powered by WordPress. Designed by elogi.