Existing Loan Analysis Calculator

How long have I been paying on my loan? How much have I paid and how much more remains?

Are you paying on a loan and wondering how long you’ve been paying or how much longer you’ll be paying? Just enter your loan balance, interest rate, the original length of the loan, and the current monthly payment and this calculator will show you how long you’ve been paying and the remaining time to payoff, as well as how much interest and the total paid so far and how much interest and the total remaining to be paid.

Field Help

Input Fields

Title: A title for these calculator results that will help you identify it if you have printed out several versions of the calculator.

Loan Balance: The amount you owe on your mortgage or loan.

Interest Rate: The annual percentage rate you are paying for this loan.

Length of Loan: The original length of the loan. Also choose whether ‘Length of Loan’ is years or months.

Monthly Payment: The principal and interest portion of each monthly payment. This may not be the amount you write a check for each month. Depending on the type of loan, your actual payment may include other amounts for escrow, private mortgage insurance (PMI), fees, or property taxes.

Output Fields

Original Loan Amount: The calculated loan amount at the beginning of the loan.

To Date (column): How long you have been paying and how much you have paid toward this loan so far.

Remaining (column): Your remaining payments and the amount still to be paid on this loan.

Total (column): The total payments and amounts for this loan.

Length or Payoff Time: Amount of time until the loan is paid off.

Number of Payments: The number of payments you will make to pay off the loan.

Total Interest: The remaining total amount of interest you will pay over ‘Payoff Time’.

Total Paid: The remaining total amount of principal + interest you will pay over ‘Payoff Time’.

Annual Cost: The amount of money you will pay each year for this loan.

4 thoughts on “Existing Loan Analysis Calculator”

  1. Love this calculator! It is so simple to use. I am in the homestretch of paying our house off (only 13k!) and I used this to figure what I needed to send extra each month on the principal to correlate with my retirement date! Had I only known what a difference principal payments make, I would have started long ago!

  2. The monthly payment estimation is off by a wide margin. When I put in the correct one it tells me it takes 35 year to pay off a 30 year mortgage. This calculator does not compute the correct values.


Leave a Comment