Multiple Loan Calculator and Comparison
A simple calculator for analysing and comparing multiple personal loans.
- Projections of yearly interest
- Yearly reduction amounts
- Term remaining
- Annual balances
- Interest paid
- Total amount paid
This is a calculator for the purpose of calculating year end balances for loans where the monthly payment
amount is known and interest is calculated on a monthly basis.
Payment amounts can be adjusted to show the affect on the loan term length for the analysis of up to three loans.
The balance data can be easily copied from the results table to Microsoft Excel for your own use.
None of the data entered in the loan table or results table are stored away from your own device.
Note this disclaimer: all calculated amounts displayed are for guidance only and professional debt advice should always be sort where necessary.
Select and highlight the table contents then copy and paste to Excel for further analysis then save to your local device.
Complete at least one loan criteria up to a maximum of three.
A year end balance, e.g. +1 Year is the balance after all payments including interest on the loan at that point have been made.
Mandatory fields are:
- Interest Rate (APR)
- Monthly Payment
- Starting Balance (This can be the current balance or the original loan amount)
- No. of Years (This can be the original term or number of years left using the current balance as the starting balance)
Monetary values are displayed to the nearest whole number.
The form is generic and can be used for any international currency.