Borrowing

Loan payment calculator

See the monthly payment and total cost of a fixed-rate loan.

Your numbers

USD · Free to use
Calculator inputs
Use the interest rate, not APR.
Whole months. 60 = 5 years.

Enable JavaScript to use this calculator. Reload if the controls remain unavailable.

Example values. Enter your own numbers.

Your calculation

Example inputs

Your result will appear here. Enter your numbers and select Calculate.

Enable JavaScript to download the inputs and results shown above.

Download Excel templates .xlsx Four templates · 254 KB · sample values, not your current calculation
About these Excel downloads

“Download my calculation” saves your current inputs and displayed results, with an editable estimate on the same worksheet. It is created on your device. The separate template download contains sample values.

Personal downloads support whole-cent amounts up to $1 billion, annual rates from 0% through 100% with up to four decimal places, and terms up to 50 whole years or 600 months. Results must be no more than $1 trillion. If an Excel rounding difference prevents a faithful export, use Copy results or Print results to keep the calculation shown here.

Fixed-rate monthly payments, principal and interest only. Use the interest rate, not APR. Fees and lender-specific payment schedules are excluded.

How this calculation works

Enter the amount borrowed, the fixed annual interest rate, and the number of months over which you will repay the loan. For a five-year loan, enter 60 months. The result shows the estimated monthly principal-and-interest payment, total interest, and total repayment.

Use the stated interest rate. APR can include lender fees and is not interchangeable with that rate. This calculator does not convert APR into an interest rate or add fees. Payments start one month after borrowing and are made at the end of each month.

P = amount borrowed; n = number of monthly payments
r = annual interest rate (%) ÷ 1,200
Monthly payment = P × r ÷ [1 − (1 + r)−n]
At 0% interest: monthly payment = P ÷ n
Total repayment = unrounded monthly payment × n
Total interest = total repayment − P
A worked example

For $10,000 borrowed at 6% annual interest over 60 months, the estimated monthly payment is $193.33. Using the unrounded payment, total repayment is $11,599.68 and total interest is $1,599.68. At 0% interest over the same term, the payment is $166.67 and total repayment is $10,000.

What this estimate includes

  • All monetary amounts are in U.S. dollars. The amount and annual interest rate must be nonnegative; the term must be a positive whole number of months within the supported numeric range.
  • The interest rate stays fixed. Monthly interest uses the annual rate divided by 12. Payments are equal, made at the end of each month, and reduce the ending balance to zero.
  • Fees, taxes, insurance, changing rates, extra or late payments, balloon balances, and deferred payments are excluded. The estimate does not reproduce a daily-interest schedule.
  • Totals use the full unrounded payment. Displayed currency is rounded to cents, so multiplying the displayed payment by the term may differ from the displayed total. Lenders may round each payment and adjust the final payment.
  • A lender’s payment dates, rounding, fees, or interest-accrual method can produce a different amount. This is not a loan offer, approval, or affordability assessment.
  • Values whose payment or interest cannot be reliably represented are rejected with a readable precision error. A positive interest rate is not silently treated as zero.

Common questions

How do I calculate a monthly loan payment?

Use the amount borrowed, the monthly interest rate, and the number of payments in the formula above. The monthly rate is the entered annual interest percentage divided by 1,200. At a zero interest rate, divide the amount borrowed by the number of months.

Should I enter the interest rate or APR?

Enter the stated annual interest rate. APR incorporates additional loan charges, so entering it as the interest rate may produce a different payment. This tool does not model fees or convert APR.

Can I use this for a personal or auto loan?

Yes, when the loan uses the fixed-rate monthly-payment model described here. Enter the amount actually financed. Add-on charges, daily interest, taxes, insurance, and lender-specific terms may change what you owe.

What does a 0% loan show?

The amount borrowed is divided by the number of payments, total interest is zero, and total repayment equals the amount borrowed. This excludes fees that a lender may charge even when interest is zero.

Why does the displayed payment times the term differ from the total?

The payment is displayed to cents, but totals use the unrounded payment. For the default example, $193.33 × 60 is $11,599.80, while the full-precision total rounds to $11,599.68. A real lender may adjust the last payment after rounding scheduled payments.

Does this include an amortization schedule or extra payments?

The on-page calculator and “Download my calculation” show the equal monthly payment and totals. The separate “Download Excel templates” workbook includes an editable Loan Schedule worksheet that starts with sample values, not the inputs currently on this page. Extra payments and balloon balances are not modeled.