With Payment Schedule

Original Size

About dates - if you want to create a schedule that accurately reflects a loan's origination date (the day the money is borrowed) and the first payment date followed by regularly scheduled payments, then use our amortization schedule.

Don't over pay, don't under collect. If you need to track payments on the exact date they are paid (or missed) for whatever amount, then use our time value of money calculator.

Since the calculator will solve for multiple unknowns, it can easily be used to answer the following questions:

- How much can I borrow?
- What would my payment be?
- What is the lending rate?
- How long will it take to pay off my loan?
- What date is my loan paid off?

This calculator will solve for any one of four possible unknowns: "Amount of Loan", "Total Scheduled Periods" (term), "Annual Interest Rate" or the "Periodic Payment".

Enter a '0' (zero) for one unknown value.

The term (duration) of the loan is a function of the "Total Scheduled Periods" and the "Payment Frequency". If the loan is calling for monthly payments and the term is four years, then enter 48 for the "Total Scheduled Periods". If the payments are made quarterly and the term is ten years, then enter 40 for the "Total Scheduled Periods".

Normally you would set the "Payment Method" to "Arrears" for a loan. This means that the monies are lent on one day and the first payment isn't due until one period after the funds are received.

If the first payment is due on the day the funds are available, then set "Payment Method" to "Advance". This is typical for leases.

The "Amortization Method" should be set to "Normal" (level payments) unless you have a specific reason to set it to another method. &Fixed Principal" causes the amount allocated to principal to be the same each period which result in decreasing payments.

Loan Carrying Cost: Interest Reduction Techniques

On a more general note, we have been discussing details about loans, some structured with unusual details, over several decades. At this point, we believe our software calculators can create a schedule for any custom loan that exists. If you have a loan with unusual terms, please ask.

Hopefully you'll find this loan calculator as well as all the financial calculators on this site to be useful tools. Why not take another sip of your favorite beverage and explore for a few minutes? Start by checking out The Reading Room. Here you'll find a half dozen articles, written by professionals, about money.

Please tell me how you use this calculator. Are you using it personally or professionally? What feature is important to you? If it didn't meet your needs, why? Your feedback will help me make improvements. Complete sentences aren't necessary! :)

Can you guys put back the old calculator because this one doesn’t work if the payment frequency is daily and compounding is monthly.

It does now.

Isn’t working what I try to calculate number of payments with biweekly payments/monthly compounding. Get an error message saying “Cannot calculate term when initial period is irregular length. Dates must match frequency.”

That’s not so much an error message as a message that tells the user about a limitation the calculator (at this time) has — it can’t calculate the term when the compounding and payment frequencies don’t match. If you set compounding to be the same as payment, you can calculate term. Term calculations are imprecise anyway (because it’s not possible to have 3/4 of a payment period, for example) which is what you would most likely need when you pick a payment amount.

Further, even after the calculators are updated to allow calculating term with mixed payment and compounding frequencies, the difference you’ll get with monthly/biweekly and monthly/monthly might be a period less. Do the calculation with monthly/monthly then change to monthly/biweekly using the term calculated to run the schedule. Depending on the rounding, you can adjust the term by a period, if you desire.

Since you are using biweekly payments, would this biweekly loan calculator be a better choice for you?

Sorry if TMI.

On the schedule the print is so small when printed that it is difficult to read even after enlarging it.

Printing does vary from browser to browser and even between different versions of the same browser. (This is due to inconsistent standards.) Please tell me what browser and version you are using and I’ll try to take a look. Also, is the problem when you are printing the schedule, or just using the print button on the calculator?

FYI: I test with current version of Chrome and IE 11. Chrome gives the best results but IE 11 should also be ok.

Using the same input information, I get two different final payments with this calculator and the amortization calculator. With this calculator the final payment is $92.00, but using the mortgage calculator with the exact same information, the last payment is $99.09. Why is this?

Input info: term 36 months

Principal: $4000.00

Interest: 2.0%

Payment: $115.00/mo

Compounding: Monthly

Payment: Monthly

I would like to suggest that for this Loan calculator a start date be optional. As is, it assumes the start date at the first day of the month following the input month.

I think I answered my own question: one uses advance payment, the other uses “arrears” payment, meaning interest is figured for the month, whereas the advance payment would be less 30 days interest. Or something like that I think. So then, is a mortgage considered Advance or Arrears? It would seem to be Advance, yet it was the larger final payment. So, I’m still confused.

Before we get into details, because I’m not clear exactly on just what calculators we are talking about, the final payment may seem to vary between two calculators due to various options, particularly the final payment rounding option (which users do not, in all cases, have access to setting only because I want to try to keep some things as simple as possible).

In addition to this calculator you mentioned both Amortization Calculator (Schedule) and Mortgage Calculator. These are two different calculators on this site. I think you are only referring to the Mortgage Calculator, correct?

If you use the Amortization Schedule, then you have full control over both the loan date and the first payment date – which lets you set an irregular first period if necessary.

Generally, mortgage or loans are payment in arrears. All payment in advance means is that the first payment happens on the same date as the day the monies are lent. If the first payment is paid on any day after the day the monies are lent, then we have payment in arrears. (With payment in advance there is no interest collected with the first payment only.)

When I enter your values into both this loan calculator and the mortgage calculator and set the payment amount to $115.00 month, I get the same final payment of $99.09, leaving a 0 balance.

Feel free to ask anything else if this is not clear.