Loan Assistant

Questions? E-mail us or call us 302-234-9857, 8AM to 10PM U.S. East Coast Time 7 days a week

Home
Products/Add-ins
Complete Product/Add-in List New Add-ins Trial Versions Accounting Add-ins Business and Risk Analysis Add-ins Charting Add-ins Data Add-ins Downloadable Macro Books Free Add-ins Specialty Add-ins Time Saving Add-ins
Add-in Collections
Productivity Suite Accounting Collection Business Analysis Collection Charting Collection Data Collection Macro Book Collection Risk Analysis Collection Time Saving Collection
Download
Download Information Download Purchased Software Download Upgrades Download Trial Versions Download Free Products
Support
Support How to Contact Us Top Support Questions Money Back Guarantee Ordering FAQ's Product FAQ's How to Open and Use Our Products Excel Questions and Answers Excel Problems & Solutions Links to other Excel sites How to repair Microsoft Excel Need more help? Let us connect computers
Company
About Add-ins.com LLC How to Contact Us Customer Feedback Policies License Agreement

Loan Assistant
An add-in product for Microsoft Excel

Do quick loan calculations
Create detailed loan calculations
for each month in loan
Show the impact of making additional payments
Track interest and principal payments
on existing loans

The Loan Assistant add-in for Microsoft Excel is a full featured financial tool for managing and understanding loans. It is compatible with Microsoft Excel 2003, Excel 2007, Excel 2010 and Excel 2013.

With the Loan Assistant, you will know 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 also lets you track principal and interest payments on existing loans. This feature allows you to:

Enter the date and amount of each payment
Prorate the interest for the initial month of the loan based on the day that interest starts
Add additional borrowings in any month and prorate the interest in the first month on these borrowings
Get detail reports for all years of the loan or on any year of the loan. The reports show the interest charged, the interest paid, the beginning and ending balances by month, what payments have been made, and how much of the payments is for interest and for principal.
Loans can start any time not just the 1st of the year. Payments can be delayed for months or years from the start of the loan.
View PDF's of the reports:

For new loans the Loan Assistant 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.

The following is part of the loan summary information of a new loan. You may change any blue entry on this page to see alternative results:

Loan summary