A loan calculator helps answer two different questions: what would the scheduled payment be, and how much interest would the borrowing cost over time? Keep both answers visible. Stretching repayment over more months can reduce each payment while increasing the total amount paid.
This guide covers hypothetical fixed-rate installment loans with equal monthly payments. It explains the arithmetic for a U.S. audience, not which loan to choose. The examples are not current rate quotes, approval promises or personalized financial advice.
Start with the balance, rate and number of payments
Enter the starting loan balance, the annual interest rate and the repayment term. Check whether the term field expects months or years: three years means 36 monthly payments. A calculator cannot fix an input entered in the wrong unit, even when its answer looks plausible.
Use the balance on which interest will be charged, which may differ from the cash received if fees are involved. Record fees separately until you know whether they are withheld from the proceeds, paid upfront or added to the balance. The same headline loan amount can describe different cash flows.
For the example below, assume a $12,000 starting balance, a hypothetical 9% annual interest rate, monthly interest calculated as the annual rate divided by 12, and the first payment one month after borrowing. There are no fees, missed payments, extra payments or rate changes.
Calculate the payment, then check total interest
For a standard fully amortizing loan, the payment formula is M = P × r ÷ [1 − (1 + r)−n]. P is the starting balance, r is the interest rate per payment period, and n is the number of payments. Here r is 0.09 ÷ 12, or 0.0075. Entering 9 instead of 0.09 in that calculation would produce a wildly different result.
Over 36 months, the example produces a payment of approximately $381.60. Using the unrounded payment, total scheduled payments are approximately $13,737.48. Subtracting the $12,000 principal leaves $1,737.48 in interest. Interest is the additional amount, not the entire repayment total.
Displayed payments are rounded to cents. Multiplying $381.60 by 36 gives $13,737.60, slightly above the unrounded calculation. A real schedule may adjust the final payment. Small differences caused by rounding are different from a large discrepancy caused by the wrong rate, term or balance.
See what a longer term changes
Keep the same $12,000 balance and hypothetical 9% rate, but extend repayment to 60 months. The estimated payment becomes $249.10, total payments become $14,946.02, and interest becomes $2,946.02, again calculated before rounding the monthly payment.
The five-year version lowers the monthly payment by about $132.50 while adding about $1,208.53 in interest over the full schedule. It also keeps payments going for two more years. These differences isolate the effect of term length; they do not assume a lender would offer the same rate for both terms.
The CFPB’s explanation of amortization describes how principal and interest share each payment and why a longer repayment term can increase lifetime interest. For a fair comparison, change one input at a time before comparing offers where several inputs differ.
Reproduce the result in a spreadsheet
Microsoft documents the Excel PMT function for constant payments and a constant interest rate. For the three-year example, enter =PMT(9%/12,36,-12000). The negative balance makes the returned payment positive under the function’s cash-flow sign convention. The omitted options assume a zero ending balance and payments at period end.
For a zero-interest loan with no fees, skip the formula’s division by zero and divide principal by the payment count. A $12,000 balance repaid over 36 months at 0% would be about $333.33 monthly, with a rounding adjustment and $0 interest. Fees could still make zero-interest borrowing cost more than the principal.
Keep the interest rate separate from APR
The CFPB distinguishes interest rate from annual percentage rate: APR reflects interest plus additional borrowing charges. Compare APR with APR, rather than comparing one offer’s APR with another offer’s interest rate.
The payment formula here needs the contractual interest rate. Substituting an APR that includes upfront fees does not automatically reproduce the lender’s payment schedule. If a calculator asks for APR, read its assumptions and fee treatment before interpreting its output. A payment estimate and a cost comparison serve different purposes.
Account for fees and limits before trusting the result
Suppose a hypothetical $300 fee is withheld from the $12,000 loan proceeds. The borrower receives $11,700 while the modeled repayment balance remains $12,000. For the 36-month example, payments exceed cash received by $2,037.48: $1,737.48 interest plus that $300 fee. This dollar calculation is not an APR calculation.
If the fee were instead financed on top of $12,000, the payment calculation would start with $12,300. Avoid adding the same financed charge twice. CFPB lists possible installment-loan fees and advises checking the lender’s disclosures to understand them.
This simple model does not cover variable rates, balloon payments, daily interest accrual or precomputed-interest contracts. Extra payments require a model that tracks when they reduce principal and any applicable charges. Save each scenario’s balance, rate, term, fees and assumptions, then reconcile the estimate with the actual payment schedule before relying on it.
A low calculated payment does not establish affordability. The calculator has no knowledge of other bills, income changes or emergency expenses. Its useful output is a reproducible estimate with clear limits, rather than a decision about whether borrowing is appropriate.
Optional supplies for keeping comparisons organized
An existing spreadsheet or notebook is enough. For paper comparisons, browse columnar accounting pads, removable page flags or document wallets. No purchase is needed to follow the calculations.
Leave a Reply