Finance · 109 calculators
Loan Offers Calculator
Two loan offers can be compared on the monthly payment or on the total cost. The two rankings are often different, and the difference is exactly what the fee is for.
Last updated
Cheaper offer saves
$680.89
- Monthly payment difference
- $125.35
- Offer A monthly payment
- $477.53
- Offer B monthly payment
- $352.17
- Offer A total cost of credit
- $3,901.74
- Offer B total cost of credit
- $4,582.63
- Offer A interest
- $3,651.74
- Offer B interest
- $4,582.63
Values update as you type. This calculator covers the single scenario its formula assumes — see Common Mistakes for what it leaves out.
The formula this calculator uses
payment = principal x r / (1 - (1+r)^-n); total cost = payment x n - principal + upfront fee
- P
- Principal borrowed, the same for both offers
- r
- Monthly interest rate, the annual rate divided by twelve
- n
- Number of monthly payments
- C
- Total cost of credit, interest plus any upfront fee
How to check the result by hand
- 1
Convert each annual rate to a monthly one
Divide each offer's rate by twelve. A 5.5% offer has a monthly rate of 0.4583%, and every figure below is driven by that monthly figure.
- 2
Compute the monthly payment for each offer
Use the amortisation formula with the number of months in each term. The same principal at a longer term always produces a smaller monthly payment.
- 3
Multiply out to find the interest
Payment times months gives everything paid. Subtracting the original principal leaves the interest, which grows with the term far faster than the rate changes.
- 4
Add any upfront fee to the interest
The fee is a cash cost of the borrowing, so it is added to the interest. This is conservative, because it does not discount the fee for being paid early.
- 5
Compare the two totals, and the two payments separately
Rank on total cost for the cheap answer and on monthly payment for the affordable answer. When the two rankings disagree, the term length is the reason.
Common Questions
How does the Loan Offers Calculator work?
£25,000 over five years at 5.5% with a £250 fee costs £3,901.74 in total. Over seven years at 4.9% with no fee the total is £4,582.63, even though the monthly payment is £125.35 lower.
What do I need to enter in the Loan Offers Calculator?
It takes 7 inputs: Principal borrowed, Offer A annual rate (percent), Offer A term in years, Offer A upfront fee, Offer B annual rate (percent), Offer B term in years, Offer B upfront fee. Fields that expect a unit say so next to the label.
Where does Cheaper offer saves come from?
It comes from M = P x r / (1 - (1+r)^-n) — the payment that clears the principal exactly over n payments, with interest charged monthly on the outstanding balance. Negative exponents are allowed directly in the expression.
What is the most common mistake with the Loan Offers Calculator?
Comparing only the monthly payment. A longer term always gives a smaller payment and always costs more in total. Ranking on the payment alone systematically favours the longest loan on the list.
For worked examples, common mistakes and the limits of this formula, read the full How To Compare Loan Offers page.
