Loan Payment Formula

How to Calculate Loan Payments

Four Methods:

If you know how to calculate a loan payment, you can plan out your budget so there are no surprises. Using an online loan calculator is recommended, simply because of how easy it is to make mistakes when calculating long formulas on a regular calculator. It is critical to include taxes and insurance when calculating a mortgage payment as this will be required by most lenders. (See "Warnings.")


Sample Calculator

Using an Online Calculator

  1. Open an online loan calculator.You can click the calculator in the "samples" section at the top of this page, then open it with Google Drive, or download it to open with Excel or another spreadsheet program. Alternatively, visit one of the following links:
    • and are both simple calculators that also show a full table of your payment schedule, including remaining debt.
    • is useful for loans with unusual payment or compounding intervals. For example, Canadian mortgages are typically compounded semi-annually, or twice a year. (The calculators above assume the interest is compounded monthly, and payments are made monthly.)
    • You can make your own loan calculator in Excel, similar to the wikiHow sample above.
  2. Enter the loan amount.This is the total amount of money borrowed. If you are calculating a partially paid loan, enter the amount of money you have left to pay.
    • This field may be labeled "base amount."
  3. Enter the interest rate.This is the current annual interest rate on your loan, in percentage form. For instance, if you pay a 6% interest rate, type in6.
    • The compounding interval does not matter here. The interest rate specified should be the nominal annual interest, even if interest is calculated more frequently.
  4. Enter the loan term.This is the amount of time you plan to spend paying off the loan. Use the amount of time specified on the loan conditions to calculate the minimum monthly payment required. Use a shorter amount of time to calculate a higher monthly payment that would pay off the loan sooner.
    • Paying the loan off sooner will also mean less total money spent.
    • Read the label next to this field to determine whether the calculator uses months or years.
  5. Enter the start date.This is used to calculate the date when you'll finish paying off the loan.
  6. Hit calculate.Some calculators will automatically update the "Monthly Payment" field after you enter the information. Others wait until you hit "calculate," then give you a chart or graph showing your payment schedule.
    • The "Principal" is the amount of the original loan left, while "Interest" is the remaining additional charge.
    • These calculators will display information for a "fully amortized" loan payment schedule, which means you will pay exactly the same amount each month.
    • If you pay less than the amount displayed, you will end up paying a single extra-large payment at the end of the loan term, and you will end up paying more money total.

Calculating Loan Payments Manually

  1. Write down the formula.The formula to use when calculating loan payments isM = P * ( J / (1 - (1 + J)-N)).Follow the steps below for a detailed guide to using this formula, or refer to this quick explanation of each variable:
    • M = payment amount
    • P = principal, meaning the amount of money borrowed
    • J = effective interest rate. Note that this is usually not the annual interest rate; see below for an explanation.
    • N = total number of payments
  2. Be careful about rounding results partway through.Ideally, use a graphing calculator or calculator software to calculate the entire formula in one line. If you are using a calculator that can only handle one step at a time, or if you want to follow the steps in detail below, round to no fewer than four significant digits before moving on to the next step. Rounding to a shorter decimal could result in significant rounding errors in your final answer.
    • Even simple calculators usually have an "Ans" button. This enters the previous answer into the next calculation, which is more accurate than calculating it below.
    • The examples below are rounded after each step, but the final step includes the answer you would get if you finished the calculation on one line, so you can check your work.
  3. Calculate your effective interest J.Most loan terms mention the "nominal annual interest rate," but you probable aren't paying your loan off in annual installments. Divide the annual interest rate by 100 to put it in decimal form, then divide it by the number of payments you make each year to get the effective interest rate.
    • For example, if the annual interest rate is 5%, and you pay in monthly installments (12 times per year), calculate 5/100 to get 0.05, then calculate J= 0.05 / 12 =0.004167.
    • In unusual cases, interest rates are calculated at a different interval than payment schedule. Most notably, Canadian mortgages are calculated twice a year, despite the borrower making payments twelve times a year. In this case, you would divide the annual interest by two.
  4. Note the total number of payments N.The loan term may already specify this number, or you may need to calculate it yourself. For example, if the loan term is 5 years and you'll be paying in twelve monthly installments each year, your total number of payments will be N = 5 * 12 =60.
  5. Calculate (1+J)-N.First add 1+J, then raise the answer to the power of "-N." Make sure to include the negative sign in front of the N. If your calculator can't handle negative exponents, instead write this as 1/((1+J)N).
    • In our example, (1+J)-N= (1.004167)-60=0.7792
  6. Calculate J/(1-(your answer)).On a simple calculator, first calculate 1 - the number your calculated in the previous step. Next, calculate J divided by the result, using the effective interest rate you calculated above for "J."
    • In our example, J/(1-(answer)) = 0.004167/(1-0.7792) =0.01887
  7. Find your monthly payment.To do this, multiply your last result by the loan amount P. The result will be the exact amount of money you need to pay each month in order to pay off your loan on time.
    • For example, if you borrowed ,000, you would multiply your answer from the last step by 30,000. Continuing our example above, 0.01887 * 30000 =566.1dollars per month, or 6 and 10 cents.
    • This works for any currency, not just dollars.
    • If you calculated our example all on one line of a fancy calculator, you would get a more accurate monthly payment, very close to 6.137, or about 6 and 14 cents each month. If we instead paid 6 and 10 cents each month like we calculated with the less accurate calculator above, we would be slightly off by the end of the loan term, and would need to pay a few dollars extra to make up for it (less than 5 in this case).

Understanding How Loans Work

  1. Understand fixed-rate versus adjustable-rate loans.Every loan falls into one of these two categories. Make sure you know which applies to yours:
    • Afixed-rateloan has an unchanging interest rate. The monthly payment amount for these will never change, as long as you pay them on time.
    • Anadjustable-rateloan periodically adjusts its interest rate to match the current standard, so you could end up owing more or less money if the interest rate changes. Interest rates are only recalculated during the "adjustment periods" specified on your loan term. If you find out what the current interest rate is a few months before the next adjustment period happens, you can plan ahead.
  2. Understand amortization.Amortization refers to the rate at which the initial amount borrowed (the "principal") is reduced. There are two common types of loan payment schedules:
    • Fully amortizedloan payments are calculated so you can pay the exact same amount each month for the entire duration of the loan, paying off the principal and the interest with each payment. The calculators and formulas above all assume you want this kind of schedule.
    • Interest onlyloan payment plans give you cheaper initial payments during the specified "interest only" period, because you are only paying off the interest, not the initial "principal" you borrowed. After the interest only period runs out, your monthly payments will jump to a significantly higher amount, because you'll start paying off the principal as well as the interest. This will cost you more money in the long run.
  3. Pay more money early to save money in the long run.Adding an extra payment will reduce the total amount of money the loan will cost you in the long term, since there is less money for interest to accumulate on. The earlier you do this, the more money you will save.
    • On the other side of the coin, paying less than the monthly payment you calculated above will result in more total money spent over the long term. Also note that some loans have a minimum required monthly payment, and you could be charged additional fees if you fail to meet this.

Community Q&A

  • Question
    If I pay extra, is it always applied to the principle?
    wikiHow Contributor
    Community Answer
    In most cases you have to tell them you want the money to go to the principle, otherwise they will put it towards the interest.
  • Question
    I have a loan with a balance of ,500 and payments are 0 per month. Is there a program I can use to calculate the interest on the balance after each payment?
    wikiHow Contributor
    Community Answer
    Contact your bank or finance company and they can tell you how much of each payment goes toward the principal and how much is paid in interest.
  • Question
    I borrowed 0,000. The monthly interest is 4%. I can pay it without term. How to compute payment without loan term?
    wikiHow Contributor
    Community Answer
    It is not possible to calculate a loan payment without knowing the term (length) of the loan. If there is not a term set for you, you can either make whatever amount payment you want (keeping in mind that the smaller your payments, the higher the interest you will accumulate), or decide for yourself how long you want to pay it off in and calculate the payments based on that term.
  • Question
    What is the monthly repayment for a loan of 8,310 at 6.74% over 360 months?
    wikiHow Contributor
    Community Answer
    Loan Amount = 8,310.00 Interest Rate = 6.74% Monthly Payment = ,172.52 Total Interest paid in 360-month payment = ,063,796.49
  • Question
    How do I figure how much my income determines how much I can borrow for a home?
    wikiHow Contributor
    Community Answer
    It will be typically be based on your monthly income. The monthly payment should be lower than 30% of your monthly salary.
  • Question
    What formula can I use to calculate interest paid on a short term (less than a year) loan if I have the amount borrowed and the gross amount repaid within a specified time frame?
    Top Answerer
    If you're referring to the entire repayment period of the loan, just subtract the amount borrowed from the total amount of all the payments. What's left is the interest paid.
  • Question
    If I would like to take out a loan of R8,000, and I pay R452 per month for 24 months, and R257 per month for 60 months, what is the percentage increase between the repayment of 24 months and 60 months?
    wikiHow Contributor
    Community Answer
    The longer you pay a loan, the more interest that gets added. You can go 60 months if that helps you out with the money. You can go 60 months but pay it off in 30 months; it will save you money as well.
  • Question
    How can the bank give a restructuring program to a loan not paid on time?
    Andrew Serrano
    Top Answerer
    You are not entitled to a loan restructuring unless granted by federal or state law. You agree in your contract that, without fault, you will make said payment on time every month without fail. If they allow an exception, it is solely at the bank's discretion.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.

Quick Summary

To calculate loan payments using a loan calculator, start by entering the loan amount and interest rate into the spaces provided. Next, enter the loan term and the start date, then hit the "Calculate" button. Some calculators will automatically update the "Monthly Payment" field after you enter the information, while others may give you a chart or graph showing your payment schedule.

Did this summary help you?
  • You may find other formulas for calculating payments.These are equivalent and should give the same result.


  • Your actual mortgage payment will be more than the amount you have calculated which represents only P&I (principal and interest). To arrive at your loan payment, you must add an escrow amount which typically includes T&I (taxes and insurance—property taxes and homeowner's insurance plus mortgage insurance, if it is required by your lender). The use of the escrow account is usually imposed by the mortgage lender and is usually non-negotiable.
  • "Adjustable rate" loans or mortgages, also called "variable rate" or "floating rate," can have their payment amounts change drastically if interest rates rise or fall. The "adjustment period" on these loans tells you how often the interest rates are recalculated. To see if you could handle the worst-case scenario, calculate the loan payments that would result if you hit the specified "cap" of interest rates.

Related wikiHows

Sources and Citations

Article Info

Featured Article

Categories: | |

In other languages:

Español: , Русский: , Italiano: , Português: , Français: , Bahasa Indonesia: , العربية: , Tiếng Việt: , Deutsch: , 한국어: 

Thanks to all authors for creating a page that has been read 642,049 times.

Video: How to calculate loan payments in Excel | tutorial

How to Calculate Loan Payments
How to Calculate Loan Payments images

2019 year
2019 year - How to Calculate Loan Payments pictures

How to Calculate Loan Payments recommend
How to Calculate Loan Payments recommend photo

How to Calculate Loan Payments pictures
How to Calculate Loan Payments images

How to Calculate Loan Payments How to Calculate Loan Payments new pictures
How to Calculate Loan Payments new foto

pics How to Calculate Loan Payments
photo How to Calculate Loan Payments

Watch How to Calculate Loan Payments video
Watch How to Calculate Loan Payments video

Communication on this topic: How to Calculate Loan Payments, how-to-calculate-loan-payments/
Communication on this topic: How to Calculate Loan Payments, how-to-calculate-loan-payments/ , how-to-calculate-loan-payments/

Related News

The New Wedding Style: Be a Best Dressed Guest
8 Low-Impact Workouts That Torch Calories
Happy Birthday Victoria Beckham 7 Stilettos That Are Posh SpiceWorthy
All About Wedding Food: 4 Kinds of Reception to Choose From
Prom Chignon Hairstyles 2012
Quarter Life Crisis: 3 Reasons Its Good for You
Actress Elizabeth McLaughlin on the Zara Top She Can’t Stop Wearing
She took photos with her co-star Vanessa Morgan
20 Instant Pot Hacks Every Cook Should Know
How to Make Hooks and Hangers from Old Cutlery
How Those Processed Snack Foods Can Affect Your Kids Health

Date: 11.12.2018, 01:31 / Views: 72433