How to Calculate Any Loan Payment: Formula, Examples & Key Inputs

What a Loan Repayment Calculator Does

A loan repayment calculation is a method that estimates the monthly payment on a loan using a standard mathematical formula. For most mortgages, lenders calculate the principal and interest payment based on the loan amount, loan term, and interest rate. The same formula applies to many other amortizing loans, such as auto loans and personal loans.

In an amortizing loan, a portion of each fixed monthly payment goes toward principal and interest. Early in the loan term, more of the payment goes toward interest, and later more goes toward principal. A repayment calculator applies this principle to determine the level monthly payment that will fully pay off the loan by the end of the term.

Sources: Consumer Financial Protection Bureau

The Standard Amortization Formula

The formula for the monthly payment on a fixed-rate amortized loan is:

M = P × [ r(1 + r)^n ] / [ (1 + r)^n - 1 ]

Where M is the monthly payment, P is the loan principal, r is the monthly interest rate (annual rate divided by 12), and n is the number of monthly payments.

• M: monthly payment
• P: loan principal (the amount borrowed)
• r: monthly interest rate = annual interest rate ÷ 12
• n: total number of monthly payments = loan term in years × 12

Sources: Wikipedia, Investopedia, TransUnion, JPMorgan Chase

Key Inputs: Loan Amount, Interest Rate, and Term

To use the loan payment formula, you need three key inputs: the loan amount (principal), the annual interest rate, and the loan term. Convert the annual interest rate to a monthly rate by dividing by 12, and multiply the loan term in years by 12 to get the number of monthly payments.

For example, a 30-year mortgage has 360 monthly payments (30 × 12). An auto loan might have a 60-month term, which is 5 years.

Note that the formula uses the loan's nominal interest rate, not the APR. APR can include fees and other costs, so the payment formula result may differ from a lender's quoted payment.

Sources: Investopedia, TransUnion

Worked Example: Step-by-Step Calculation

Let's calculate the monthly payment for a $200,000, 30-year fixed-rate mortgage at a 7% annual interest rate. This example is based on a CFPB regulatory example.

Step 1: Convert the annual interest rate to a monthly rate. r = 7% / 12 = 0.5833% per month, or 0.005833 as a decimal.

Step 2: Determine the total number of monthly payments. n = 30 years × 12 = 360 payments.

Step 3: Plug the numbers into the formula: M = 200,000 × [0.005833(1.005833)^360] / [(1.005833)^360 - 1].

Step 4: Calculate the result. The monthly payment is approximately $1,331.

Sources: Consumer Financial Protection Bureau

How to Interpret Monthly Payment and Total Interest

The monthly payment from the formula is the amount that goes toward principal and interest. For a $200,000, 30-year mortgage at 7%, the monthly payment is about $1,331.

To see how much of each payment goes to interest, multiply the current outstanding balance by the monthly interest rate. The principal portion is the total monthly payment minus the interest for that period. Early in the loan, most of the payment goes to interest; later, more goes to principal.

Sources: Consumer Financial Protection Bureau, Investopedia, JPMorgan Chase

Using the Formula in Spreadsheet Software

You can replicate the loan payment calculation in spreadsheet software using a built-in function. For example, in Excel or Google Sheets, the PMT function uses the same inputs: rate (monthly), nper (number of payments), and pv (principal).

Identify the monthly rate (annual rate/12), the total number of payments (term in months), and the loan amount as a negative value. The function returns the monthly payment. You can also build the formula manually in a cell using the standard amortization equation.

Spreadsheet software makes it easy to compare scenarios by changing the loan amount, rate, or term.

Sources: Consumer Financial Protection Bureau

Adjusting for Interest Compounding and Payment Frequency

The standard formula assumes monthly compounding and monthly payments. For loans with different compounding frequencies, such as daily or quarterly, the formula may need adjustment. However, most fixed-rate amortized loans, including mortgages, compound monthly.

For simple-interest loans, interest is calculated on the actual outstanding balance, and the payment calculation may differ from the amortization formula. The CFPB notes that simple interest loans calculate interest daily, which can cause slight variations in the payment amount depending on the payment date.

When using a calculator that asks for payment frequency (monthly, biweekly, etc.), ensure the interest rate and number of periods are aligned. For biweekly payments, you would divide the annual rate by 26 and multiply the term in years by 26.

Sources: Consumer Financial Protection Bureau, Wikipedia

Common Errors and How to Avoid Them

A common mistake is failing to convert the annual interest rate to a monthly rate. Using the annual rate directly in the formula will produce a payment that is far too high. Always divide by 12 before applying the formula.

Another error is using the loan term in years instead of the number of monthly payments. Multiply years by 12 to get n.

Rounding the monthly rate too aggressively can also skew the result. Keep several decimal places until the final step.

Finally, remember that the formula gives the principal and interest payment only. It does not include taxes, insurance, or other fees, which can make the actual total monthly payment higher.

Sources: Consumer Financial Protection Bureau

Using the Calculator for Different Loan Types

The amortization formula works for any fixed-rate, fully amortizing loan, such as auto loans, personal loans, and fixed-rate mortgages. However, it does not apply to loans with adjustable rates, interest-only loans, or balloon loans.

For an adjustable-rate mortgage (ARM), the interest rate can change, and the monthly payment may go up or down. A fixed-rate mortgage has an interest rate that remains the same for the entire loan term.

A balloon loan has a shorter term than the amortization period, and the monthly payments are based on a longer amortization schedule, leaving a large final payment due at the end. Some loans allow negative amortization, where payments are less than the interest due, causing the loan balance to increase over time.

Sources: Consumer Financial Protection Bureau

Limitations of the Calculation and When to Seek Professional Advice

The amortization formula assumes a fixed interest rate and regular, fully amortizing payments. It does not account for fees, insurance, taxes, or other charges that may be part of an actual total monthly payment. For example, mortgage payments often include homeowners' insurance and property taxes.

The formula is designed for amortizing loans and may not be accurate for simple-interest loans, interest-only loans, or loans with variable rates or payment frequency other than monthly. Actual loan payments may vary due to fees, insurance, rounding, payment frequency, and lender-specific calculations.

If you are considering a loan with unusual terms, or if you need a precise estimate for budgeting, consult a financial professional or your lender. They can provide a detailed amortization schedule and explain any additional costs.

Sources: Consumer Financial Protection Bureau

Definition of Each Variable in the Formula

The variables in the loan payment formula are:

M is the monthly payment amount. This is the payment required to fully amortize the loan over n months at the monthly interest rate r.

P is the loan principal, or the original amount borrowed. It does not include upfront fees or other costs.

r is the monthly interest rate, calculated as the annual nominal interest rate divided by 12.

n is the total number of monthly payments. For a 30-year loan, n is 360.

These variables must be consistent: the interest rate must match the payment period (monthly), and the number of payments must be the total count over the loan term.

Sources: Wikipedia, Investopedia, TransUnion

Derivation of the Formula from Amortization Principles

The amortization formula is derived from the principle that the present value of an annuity (a series of equal payments) equals the loan principal. The present value of a stream of monthly payments M at a monthly interest rate r, discounted back to today, must equal the loan amount P.

The sum of the present values of all n payments is P = M × [1 - (1 + r)^(-n)] / r. Solving for M gives the standard formula: M = P × [ r(1 + r)^n ] / [ (1 + r)^n - 1 ].

This derivation assumes that payments are made at the end of each month and that interest is compounded monthly. It ensures that each payment covers the interest that has accrued since the last payment, and the remainder reduces the principal, so the balance reaches zero after n payments.

Sources: Wikipedia, Investopedia

Second Worked Example with Different Numbers

Let's work through another example with a $560,000 30-year mortgage at a 9% annual interest rate, from a TransUnion example.

Step 1: Convert the annual interest rate to a monthly rate. r = 9% / 12 = 0.75% per month, or 0.0075 as a decimal.

Step 2: Number of payments = 30 × 12 = 360.

Step 3: Plug into the formula: M = 560,000 × [0.0075(1.0075)^360] / [(1.0075)^360 - 1].

Step 4: The result is a monthly payment of $4,506.

This example shows how the formula works for different loan amounts and rates. You can substitute your own numbers to get an estimate for your situation.

Sources: TransUnion

How to Use the Formula in Spreadsheet Software

In a spreadsheet, you can calculate the monthly payment with the PMT function.

Alternatively, you can enter the formula directly: =200000 * (0.07/12 * (1+0.07/12)^360) / ((1+0.07/12)^360 - 1).

Use the spreadsheet to explore how changing the loan amount, rate, or term affects the payment. This is useful for comparing different loan offers or planning a budget.

Sources: Consumer Financial Protection Bureau

Adjustment for Interest Compounding (e.g., Daily, Monthly)

The standard formula assumes monthly compounding, which aligns with monthly payments. For loans with daily compounding, such as some simple-interest loans, the interest is calculated daily on the current principal balance. This can result in a slightly different total interest compared to monthly compounding, especially if payments are not exactly on schedule.

For a simple-interest loan, the monthly payment may vary if the number of days between payments changes. In contrast, the amortization formula assumes a fixed monthly period.

If a loan compounds at a different frequency, you would need to adjust the periodic rate and the number of periods accordingly. For daily compounding, you would use a daily rate and the number of days in the term.

Sources: Consumer Financial Protection Bureau

Understanding the Input Fields: Loan Amount, Interest Rate, Term, Payment Frequency

When using a loan repayment calculator, you need to understand each input field:

Loan amount: the principal you borrow. This is the amount on which interest is calculated.

Interest rate: the annual nominal rate. The calculator will usually convert this to a monthly or periodic rate for the formula.

Term: the length of the loan in years or months. This determines the number of payments.

Payment frequency: how often you make payments (monthly, biweekly, etc.). The calculator will adjust the rate and number of periods accordingly.

It's important to identify the required values correctly; small changes can have a significant impact on the monthly payment.

• Loan amount: the principal
• Interest rate: annual rate (divide by 12 for monthly)
• Term: length in years or months
• Payment frequency: monthly, biweekly, etc.

Sources: Investopedia, TransUnion

How to Interpret the Monthly Payment Output

The monthly payment output is the amount you would pay each month to fully amortize the loan over the specified term at the given interest rate. It includes both principal and interest portions.

This amount does not include any additional fees, taxes, or insurance that may be required. For a mortgage, your actual total monthly payment may be higher because of these costs.

When comparing loan offers, focus on the monthly payment and the total interest paid over the life of the loan. A lower monthly payment may result in more total interest if the term is longer.

Sources: Consumer Financial Protection Bureau

Calculating Total Interest and Total Cost

To calculate the total cost of a loan, multiply the monthly payment by the number of payments.

This calculation helps you see the true cost of borrowing and compare different loan scenarios. For instance, a shorter-term loan may have a higher monthly payment but less total interest.

Remember that this calculation includes only principal and interest; other costs like taxes and insurance are separate.

Sources: Consumer Financial Protection Bureau

Adjusting Inputs to Compare Different Scenarios

One of the most useful features of a loan calculator is the ability to change inputs to see how they affect your payment. For example, increasing the loan term reduces the monthly payment but increases the total interest paid.

Similarly, a lower interest rate will reduce both the monthly payment and the total interest. You can also compare the impact of a larger down payment (which reduces the loan amount) or a shorter loan term.

By running multiple scenarios, you can make an informed decision about what loan terms are most suitable for your budget.

Common Mistakes When Using Calculators

One common mistake is entering the annual interest rate without dividing by 12 for monthly payments. This can overstate the monthly payment dramatically.

Another is using the loan term in years instead of the number of payments. Remember to multiply by 12 for monthly payments.

Some calculators round the result to the nearest dollar, which is fine for estimates, but you should be aware that actual payments may differ by a few cents.

Also, check whether the calculator includes fees or other costs in the payment. Many calculators show only principal and interest, so your actual payment may be higher.

Limitations of Online Calculators

Online calculators are useful for estimates, but they have limitations. They typically assume a fixed interest rate and monthly compounding, which may not match your actual loan terms.

They also do not include hidden costs like origination fees, mortgage insurance, or property taxes. For a precise figure, consult your lender or a financial professional.

Additionally, different calculators may produce slightly different results due to rounding or differing assumptions about compounding and payment timing.