How to Calculate Loan Payments: Step-by-Step Formulas and Examples

The Standard Loan Payment Formula

For a fixed-rate amortizing loan, the monthly payment is calculated using a standard formula. This formula applies to loans where you make equal payments over a set term, and each payment covers both the interest accrued during the period and a portion of the principal.

The formula is: M = P × r × (1+r)^n / [(1+r)^n - 1], where M is the monthly payment, P is the principal (the amount borrowed), r is the monthly interest rate, and n is the total number of monthly payments.

This formula assumes a fixed interest rate and equal monthly payments. It does not apply to variable-rate loans or loans with deferred payment or bond structures.

• Ensure the interest rate is in monthly terms: divide the annual rate by 12 (or by 1200 if using a percentage).
• The number of payments n is the loan term in years multiplied by 12.
• The result gives the payment for principal and interest only; other costs like taxes, insurance, or fees are not included.

Sources: Universal Class, Bankrate

Inputs You Need: Principal, Rate, Term

To use the formula, you need three inputs: the principal, the annual interest rate, and the loan term. The principal is the amount you borrow. The annual interest rate is usually quoted as an Annual Percentage Rate (APR), which expresses the cost of borrowing as a yearly percentage. To convert this to a monthly rate, divide by 12 (or by 1200 if using a percentage in APR terms).

The loan term is the duration of the loan. Multiplying the number of years by 12 gives the total number of monthly payments. For example, a 30-year loan has 360 monthly payments.

When you use the formula, the interest rate you input is the rate used for the payment calculation. If your APR includes fees, it may not be the same as the rate used in the payment formula.

• Principal (P): the amount borrowed, before fees are added.
• Monthly interest rate (r): annual rate divided by 12 (or 1200 when using a percentage).
• Number of payments (n): loan term in years multiplied by 12.

Sources: Universal Class, Bankrate

Worked Example: Personal Loan

Let’s walk through a typical personal loan scenario. Suppose you borrow $10,000 at an annual interest rate of 6% for 3 years. First, convert the annual rate to a monthly rate: 6% / 12 = 0.5% per month, or 0.005 as a decimal. The total number of payments is 3 years × 12 = 36.

Now plug these values into the formula. Using a calculator or spreadsheet, you will find that the monthly payment is approximately $304.22. Over the life of the loan, you will pay a total of about $10,952.00, meaning the interest cost is about $952.00.

This example assumes no additional fees and a fixed interest rate. If fees are added, the payment will be higher.

• Principal = $10,000
• Monthly rate = 0.005 (0.5%)
• n = 36
• Payment ≈ $304.22

Sources: Universal Class, Bankrate

Worked Example: Auto Loan

Now consider an auto loan of $25,000 with an annual interest rate of 4.5% for 5 years. The monthly rate is 4.5% / 12 = 0.375% per month, or 0.00375. The number of payments is 5 × 12 = 60.

Using the formula, the monthly payment comes out to about $466.07. The total paid over the loan term is about $27,964.20, so the interest cost is roughly $2,964.20.

Again, this calculation is for principal and interest only. If you add fees or taxes, the payment will change.

• Principal = $25,000
• Monthly rate = 0.00375 (0.375%)
• n = 60
• Payment ≈ $466.07

Sources: Universal Class, Bankrate

Using Spreadsheet Functions

Spreadsheets offer built-in functions that automate the loan payment calculation. These functions use the same inputs as the formula: the monthly interest rate, the number of payments, and the present value (or principal). In most spreadsheet programs, you can use a payment function to get the monthly payment.

For example, using the personal loan figures above, you would enter the monthly rate, the number of payments, and the principal into the spreadsheet’s payment function. The function will return a negative value, indicating a payment.

The spreadsheet function is a convenient way to perform the calculation, but it still only covers principal and interest. It does not automatically account for taxes, insurance, or fees.

• The function requires the monthly interest rate (annual rate divided by 12).
• It also requires the total number of payments (years multiplied by 12).
• The principal is the present value of the loan.
• The result is a negative number because it is an outgoing payment.

Sources: Universal Class, Bankrate

Common Mistakes and How to Avoid Them

One common mistake is using the annual interest rate directly in the formula without converting it to a monthly rate. Always divide by 12 (or 1200 if using a percentage) to get the correct monthly rate.

Another error is confusing the rate you use in the formula with the APR when the APR includes fees. The formula typically uses the rate for the payment calculation, so if you use the APR, your payment may differ from the actual payment.

Rounding errors can also cause small discrepancies. Lenders may round the payment to the nearest cent, and your manual calculation might differ by a few cents. That is normal and not a cause for concern.

• Use the monthly rate, not the annual rate.
• Check whether the rate you use is the one for the payment calculation, not the APR if it includes fees.
• Accept minor rounding differences.

Sources: Universal Class, Bankrate

Handling Fees and Other Costs

Loan fees, such as origination fees, can affect the total cost of a loan. These fees are often a small percentage of the loan amount and may be added to the initial loan balance.

When using a loan payment calculator or spreadsheet, you normally input the loan amount (the principal) and the interest rate. The resulting payment typically includes only principal and interest, not taxes, insurance, or closing costs. Be sure to add those separately if you need an estimate of your total monthly obligation.

For adjustable-rate mortgages, the interest rate is composed of an index plus a margin. The initial payment is set only for the initial period and may increase later, so the fixed-rate formula does not apply beyond that period.

The 28% rule of thumb suggests that your total monthly housing payment should be at or below 28% of your pre-tax monthly income. This is a guideline, not a strict rule, and it varies by individual circumstances.

• Fees can be added to the principal, increasing your payment.
• Calculator estimates usually exclude taxes, insurance, and fees.
• ARMs have initial payments that may change, so the formula only works for the initial period.
• The 28% rule is a common affordability benchmark.

Sources: FinAid, Consumer Financial Protection Bureau, Investopedia, Bankrate