Average Daily Temperature Monthly Rainfall

Multiple Loan Calculator

Use this simple loan calculator for analysing and comparing multiple personal loans.

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.
The form is generic and can be used for any international currency.
Payment amounts can be adjusted to show the affect on the loan term length and this can be done to analyse up to four loans.
The 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 shown, are for guidance only and professional debt advice should 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.

Instructions

Complete at least one loan criteria table up to a maximum of four.
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.

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

EMail: IT Services at Peak Weather