LOANS CALCULATOR

Loan Comparison Calculator

Compare two fixed-rate offers by payment and lifetime borrowing cost. Optionally enter when you plan to repay or refinance to compare costs and remaining principal at that point.

Calculator

Borrowing amount
Offer A
%
months
Offer B
%
months
Planned holding period
payments
Assumes remaining principal is settled immediately after this payment. Zero compares upfront costs at origination.
YOUR RESULTS
Offer A minus offer B borrowing cost-13,446.01
Offer A monthly payment
10,379.18
Offer B monthly payment
8,766.62
Offer A interest plus fees
127,750.66
Offer B interest plus fees
141,196.66
Lower full-term borrowing cost
Offer A
Payment month used for horizon comparison
72
Offer A interest plus fees through horizon
127,750.66
Offer B interest plus fees through horizon
141,196.66
Horizon cost: offer A minus B
-13,446.01
Lower borrowing cost through horizon
Offer A

Full-term costs are compared. Enable a holding period to compare an earlier sale, refinance or full repayment.

Full-term interest plus fees

  • Offer A interest plus fees127,750.66
  • Offer B interest plus fees141,196.66
Offer comparison
Offer comparison
OfferTerm (months)Monthly paymentInterestUpfront feeTotal paid including principalInstallments paid through horizonPrincipal remaining at horizonInterest plus fees through horizon
A6010,379.18122,750.665,000.00627,750.66622,750.660.00127,750.66
B728,766.62131,196.6610,000.00641,196.66631,196.660.00141,196.66
Page guide

Monthly payment versus full-term borrowing cost

Borrowing cost is interest plus the entered upfront fee, excluding the principal you receive and repay. A negative A-minus-B difference means offer A costs less over its full term. Monthly payment and total cost answer different questions. With a planned holding period, horizon cost is interest accrued through completed scheduled installments plus the upfront fee. Remaining principal is shown separately. Negative horizon difference favors A; the winner can differ from the full-term result. With the option off, the horizon comparison uses both completed loan terms.

The formula

Monthly payment = P × r ÷ [1 − (1 + r)^(-n)]. Interest plus fees = monthly payment × n − P + upfront fee.

P is the common amount borrowed, r is each nominal annual interest rate divided by 1,200, and n is that offer’s monthly payment count. Zero-rate payments are P ÷ n. Fees are paid separately at the start and are not financed into the balance. At a horizon of k payments, use the smaller of k and each offer’s term. Remaining principal is the present value of its unpaid installments. Horizon borrowing cost = installments paid + remaining principal + upfront fee − original principal, equivalent to interest paid plus fee. Principal settlement is not itself a borrowing cost. At zero payments only the fee has been incurred.

A smaller payment can still cost more

Borrow 12,000 with zero interest. A twelve-month term requires 1,000 monthly; a twenty-four-month term requires 500. If upfront fees are 100 and 200 respectively, the longer offer has the smaller payment but costs 100 more overall.

How to use this calculator

  1. Enter the common amount borrowed.
  2. Enter each offer’s contract rate, whole monthly term and separately paid upfront fee in its own group.
  3. Optionally enable a planned exit after a whole number of payments. Compare full-term and horizon costs along with each remaining principal amount.

Make the comparison consistent

Use the contractual interest rate rather than an APR that already includes fees. Entering an APR and then adding those fees again can double-count costs. If fees are financed, the amount borrowed and payment calculation change; this model assumes a separate upfront payment.

A lower full-term total may not be cheaper if you refinance or repay early. The optional holding period compares interest and upfront fees through the same payment month and shows what principal still needs settlement. Each loan stops generating payments and interest at its own maturity. This comparison does not discount cash flows or include exit penalties.

Compare an earlier repayment date

If you intend to refinance after twelve payments, compare costs through month twelve rather than assuming the entire contractual term. Upfront fees are already paid and are not prorated or refunded. The table shows cumulative installments and remaining principal so that a lower payment is not mistaken for lower interest cost.

A horizon beyond one offer’s maturity includes only that offer’s completed payments and leaves zero principal. A zero-month horizon compares the initial fees with the original principal still outstanding. Future fees, accrued daily interest and potential prepayment charges need a separate dated lender quote.

Assumptions & limitations

What this calculation assumes

  • Both loans are fixed-rate, fully amortizing monthly loans.
  • Payments occur at each month-end with no missed installments.
  • Without an enabled horizon, each loan is held for its full term. An enabled horizon assumes settlement immediately after the specified scheduled payment.

What to keep in mind

  • No variable rates, balloon payments, insurance, taxes, or early-repayment penalties are included.
  • Results are estimates and do not replace lender disclosures.

Common questions

Does a lower rate always win?

No. A longer term or larger fee can outweigh a rate reduction. Inspect the total interest and fees as well as the quoted rate.

Why are the two principal amounts identical?

The tool compares offers funding the same need. Comparing unequal amounts would mix borrowing cost with the size of the loan.

Why can the lower-cost offer change at an earlier date?

Different rates generate interest at different speeds, while upfront fees are paid immediately. A fee that is recovered over a full term may not be recovered before your planned repayment date.

Sources & further reading

Reviewed on