Peak District and UK Weather Peak District and UK Weather

Multiple Loan Calculator and Comparison

A simple calculator for analysing and comparing multiple personal loans.



Enter Loan Criteria
Loan #1
Loan Name
Starting Balance
Interest Rate
Monthly Payment
No. of Years
Payment Day
 
Loan #2
Loan Name
Starting Balance
Interest Rate
Monthly Payment
No. of Years
Payment Day
 
Loan #3
Loan Name
Starting Balance
Interest Rate
Monthly Payment
No. of Years
Payment Day

Instructions

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:


Monetary values are displayed to the nearest whole number.
The form is generic and can be used for any international currency.