The Loan Balance Calculator can be used to track variable payments on any monthly installment loan. This includes auto, RV, or personal loans, certain types of promissory notes, contracts for deed, 1st and 2nd mortgages, and so on.
And it can be used from either a lender's perspective, or from a borrower's perspective.
Specifically, the calculator will create an editable monthly payment schedule for a time period of your choosing.
From there you can then change the default payment amounts to match the actual payment amounts, and you can make adjustments to the principal balance (up or down) for any month that falls within the selected time frame.
In other words, for any monthly payment period, the calculator will allow you to:
Plus, you can set the calculator's amortization method to either US Rule or Normal (negative amortization).
And finally, once you have the payment schedule changed to match the actual, you can then view and print out a revised loan amortization schedule. This will allow you to simply begin where you left off when you need to make further revise the schedule.
If you are using a newer version of your web browser software (one that supports HTML5 Local Storage), you can now save your entries between visits -- for any number of loans.
However, please keep in mind that the saved entries can only be accessed from the device and web browser they were saved with. Also, Local Storage is not 100% reliable, and no backup method exists, so be sure to keep your paper records.
If the principal repayment is ahead of schedule, I recommend you use the Loan Pay Off Calculator instead.
Or, if you are looking to calculate the current balance on a loan that you have been making the prescribed monthly payments on, please visit the much simpler Remaining Balance Calculator.
While I credit my current level of financial harmony to a host of personal spending and borrowing rules, two rules that have served me extremely well are:
Why? Because all too often I have seen close relationships permanently dissolved by matters of money -- namely when one borrows money from the other.
Even in cases where one person is paying the other as per the repayment schedule, each looks at the other differently -- with "differently" ranging from not looking the other in the eye as often as they used to, to avoiding any contact with the other at all.
For that reason, and because I'm a very family oriented person, I simply refuse to put my relationships with friends and loved ones at risk over money.
Now that isn't to say that I never help out my friends and family when they ask for money, because I do. But my rule is, if I don't have the money to give to them as a gift without putting myself in financial peril, they don't get the money. Instead I simply tell them that I value our relationship too much to put something so dangerous between us, and then come up with other ways I might be of assistance.
On the other hand, if I do give a friend or relative a sum of money, and that person is moved to pay me back, they know its only because they want to and not because I was expecting it. In that light, the repayment is simply gift back to me.
Of course, if you're familiar with my stance on borrowing, you'll know that I always try to talk friends and family into managing their incomes in such a way that it reduces the need to borrow money from anyone in the first place. In turn, this keeps many of them from bringing up the subject in the first place ... to avoid the lectures and I told you so's. ;-)
From the borrower's perspective, negative amortization can be very costly -- especially if the missed payment occurs early on in the repayment schedule. The following mini calculator helps to illustrate this point.
I suggest you pause the video after watching each section. Then use that section of the calculator. Then continue watching the video for a demonstration of how to use the next section.
With that, let's use the loan balance calculator to revise a loan amortization schedule that has been skewed by payments that have been different from the original terms.
Check Out My Other Super
Free Loan Calculators
To Help You To
Calculate Your ...
Loan name: Optional: If you will be printing the loan amortization schedule, enter the name of the loan here.
If your web browser supports Local Storage, you can also add multiple loans to the drop-down list, and then save their individual payment entries between visits.
To add a loan, select New, complete the top section of the calculator and then click the Add button.
To add/edit payments for a loan, select the name from the menu, enter/edit the payments, and then click the Save Changes button.
To remove a loan from the list, select the loan and click the Delete button.
Beginning principal balance: Enter the dollar amount of the principal balance that coincides with the month and year you would like the payment schedule to start.
Annual interest rate of the loan: Enter the annual interest rate as stated on the original loan agreement. Enter as a percentage (for .06, enter 6%).
Original loan term in months: Enter the number of monthly payments as stated in the original loan agreement. Note that if you type in the number of years, the loan balance calculator will automatically populate the payments field with the correct number of months.
Monthly principal and interest payment amount: Enter the monthly principal and interest payment as stated in the original loan agreement. If you leave this field blank the calculator will calculate the monthly payment for you based on the entered principal, rate, and term.
Month and year to start amortization: Select the month and enter the 4-digit year you would like the payment schedule to begin. The loan balance calculator will use the month and year to create a schedule of payments wherein each payment can be changed to match the actual amounts paid.
Month and year to end amortization: Select the month and enter the 4-digit year you would like the payment schedule to end. Note that you can extend the schedule beyond the original term for cases where missed payments have postponed the payoff date.
Amortization method: Select US Rule if it is illegal in your state to charge interest on unpaid interest (unpaid interest will be escrowed). Otherwise, if you select Normal then unpaid interest will be added to the principal as it occurs (causing negative amortization).
Create Editable Payment Schedule button: Clicking this button will populate the large blank window with a scrollable payment schedule. You can then change the listed payment amounts to their actual amounts, as well as enter an adjustments that have occured (principal-only payments, late fees, etc.).
Clear Saved Payments: Click this button to clear out all entered and edited payment amounts for the selected loan.
Clear All Saved Data: Click this button to clear out all loans and their entered and edited payment amounts.
Pmt # column: This column will list the month number for each of the payments that fall within beginning and ending dates.
Month/Year column: This column will list the month and year of the payments that fall within beginning and ending dates.
Payment column: This column will list the defaultpayment amount for each month that falls within beginning and ending dates. You can change these to reflect instances where the actual payment made was more or less than amount listed (enter zero if payment was skipped all together). Note that the Revised Balance column will update as you make changes.
Adjustments column: Use the fields in this column for adding late fees to the principal balance (enter as negative number, e.g. enter -10 for a $10 fee), or for cases where a second payment is made during any one month (enter as positive number). Note that the Revised Balance column will update as you make changes.
Revised Balance column: This column will display the revised month-to-month loan balance based on your entries in the Payment and Adjustments columns. Note that the loan balance calculator will recalculate this column as you adjust the payment amounts and late fees.
Principal paid during amortization period: The total of the amounts applied to the principle during selected repayment period.
Interest charges for the amortization period: The total of the interest charges that have accrued during selected repayment period.
Principal balance at end of amortization period: This is the balance owed as of the last month of selected repayment period (includes the payment amount for that month).
Escrowed unpaid interest: If you selected US Rule and any of your payments (less any fees) were not large enough to cover the interest charge for their respective payment periods, the unpaid interest will be escrowed -- the total of which will display on this line. Otherwise, if Normal amortization is selected, unpaid interest will be added to the principal in the period it occurred (causing negative amortization) and a zero will be displayed on this line.
Total owed at end of amortization period: This is the balance owed as of the last month of selected repayment period (includes the payment amount for that month), plus any escrowed unpaid interest.
Show Revised Amortization Schedule button: Clicking this button will display a revised amortization schedule below this row, and enable the Printer Friendly Revised Amortization Schedule button located beneath the schedule. Then, to create a printer friendly version for printing, click the button displayed below the revised schedule once it is no longer grayed out.
Printer Friendly Revised Amortization Schedule button: If enabled, clicking this button will open the revised amortization schedule in a new, printer friendly window for printing, Printing this report will enable you to start from where the schedule left off instead having to start all over.