Loan Assistant for Microsoft Excel Description:

The Loan Assistant tells you in advance what your loan payments will be for any loan. It also generates amortization tables showing the amount of principal, unpaid balance and interest by week, month, or year. Easily change information on your loan and see the results instantly. See the effect of making early payments on the interest and loan payments.

The Loan Assistant then creates a detailed Excel workbook that contains:

payment schedules,
interest amortization tables,
annual interest and principal amounts,
and graphs of the loan payments.

You can change any of the loan assumptions and immediately see the impact. You can also enter advanced payments and one time irregular payments and see how much interest you save by doing so.