How to Calculate Loan Comparison
Compare two loan options side by side — payments, total costs, and total interest.
The Formula
payment = P*(r*(1+r)^n)/((1+r)^n-1)The loan comparison formula uses the mathematical relationship: payment = P*(r*(1+r)^n)/((1+r)^n-1). Each variable in the formula represents a measurable quantity that affects the final result.
What Each Variable Means
Every value in the loan comparison formula, what it measures, and the value used in the worked example on this page:
| Variable | Type | Example value |
|---|---|---|
| Loan Amount | Input (you provide) | $300,000 |
| Loan 1 Interest Rate | Input (you provide) | 6.5 % |
| Loan 1 Term (Years) | Input (you provide) | 30 |
| Loan 2 Interest Rate | Input (you provide) | 7 % |
| Loan 2 Term (Years) | Input (you provide) | 15 |
| Loan 1 Monthly Payment | Result (calculated) | — |
| Loan 2 Monthly Payment | Result (calculated) | — |
| Loan 1 Total Cost | Result (calculated) | — |
| Loan 2 Total Cost | Result (calculated) | — |
| Loan 1 Total Interest | Result (calculated) | — |
| Loan 2 Total Interest | Result (calculated) | — |
| Interest Difference | Result (calculated) | — |
Step-by-Step Method
- 1Write down the values you know: Loan Amount, Loan 1 Interest Rate, Loan 1 Term (Years), Loan 2 Interest Rate, Loan 2 Term (Years).
- 2Substitute your known values into the formula: payment = P*(r*(1+r)^n)/((1+r)^n-1).
- 3Work through the arithmetic in the standard order of operations — parentheses first, then exponents, then multiplication and division, then addition and subtraction.
- 4Check that your result carries the correct unit and falls in a reasonable range for the problem.
- 5Verify your answer with the interactive Loan Comparison Calculator — it solves the same formula instantly.
Worked Example
Take a concrete case: loan amount = $200,000, with the other inputs at the typical values from the variables table above. Substituting into the formula gives loan 1 monthly payment = 1264.14, loan 2 monthly payment = 1797.66, loan 1 total cost = 455088.98, loan 2 total cost = 323578.18, loan 1 total interest = 255088.98, loan 2 total interest = 123578.18, interest difference = 131510.80. These numbers are solved by the same engine that powers the Loan Comparison calculator, so you can reproduce them exactly by entering the same inputs there.
| Loan Amount | Loan 1 Monthly Payment | Loan 2 Monthly Payment | Loan 1 Total Cost | Loan 2 Total Cost | Loan 1 Total Interest | Loan 2 Total Interest | Interest Difference |
|---|---|---|---|---|---|---|---|
| $1,000 | 6.32 | 8.99 | 2275.44 | 1617.89 | 1275.44 | 617.89 | 657.55 |
| $200,000 | 1264.14 | 1797.66 | 455088.98 | 323578.18 | 255088.98 | 123578.18 | 131510.80 |
| $300,000 | 1896.20 | 2696.48 | 682633.47 | 485367.27 | 382633.47 | 185367.27 | 197266.20 |
| $400,000 | 2528.27 | 3595.31 | 910177.95 | 647156.36 | 510177.95 | 247156.36 | 263021.60 |
| $500,000 | 3160.34 | 4494.14 | 1137722.44 | 808945.44 | 637722.44 | 308945.44 | 328777.00 |
| $600,000 | 3792.41 | 5392.97 | 1365266.93 | 970734.53 | 765266.93 | 370734.53 | 394532.40 |
| $800,000 | 5056.54 | 7190.63 | 1820355.91 | 1294312.71 | 1020355.91 | 494312.71 | 526043.20 |
| $900,000 | 5688.61 | 8089.45 | 2047900.40 | 1456101.80 | 1147900.40 | 556101.80 | 591798.60 |
| $1,000,000 | 6320.68 | 8988.28 | 2275444.88 | 1617890.89 | 1275444.88 | 617890.89 | 657554.00 |
How each result changes as loan amount changes, holding the other inputs constant.
Practice Problems
1. 30yr vs 15yr mortgage: You enter Loan Amount $300,000, Loan 1 Interest Rate 6.5%, Loan 1 Term (Years) 30, Loan 2 Interest Rate 7%, Loan 2 Term (Years) 15 — what does the calculator return?
Answer: The calculator returns Loan 1 Monthly Payment $1,896.20, Loan 2 Monthly Payment $2,696.48, Loan 1 Total Cost $682,633.47, Loan 2 Total Cost $485,367.27, Loan 1 Total Interest $382,633.47, and 2 more more results for Loan Amount $300,000, Loan 1 Interest Rate 6.5%, Loan 1 Term (Years) 30, Loan 2 Interest Rate 7%, Loan 2 Term (Years) 15.
2. With Loan Amount $312,500, Loan 1 Interest Rate 6%, Loan 1 Term (Years) 30, Loan 2 Interest Rate 6.75%, Loan 2 Term (Years) 30, what are the results?
Answer: With Loan Amount $312,500, Loan 1 Interest Rate 6%, Loan 1 Term (Years) 30, Loan 2 Interest Rate 6.75%, Loan 2 Term (Years) 30, the results are Loan 1 Monthly Payment $1,873.60, Loan 2 Monthly Payment $2,026.87, Loan 1 Total Cost $674,494.34, Loan 2 Total Cost $729,672.86, Loan 1 Total Interest $361,994.34, and 2 more more results.
Frequently Asked Questions
What is the formula for loan comparison?
The formula is: payment = P*(r*(1+r)^n)/((1+r)^n-1). Compare two loan options side by side — payments, total costs, and total interest.
What values do I need to calculate loan comparison?
You need loan amount, loan 1 interest rate, loan 1 term (years), loan 2 interest rate, loan 2 term (years). The calculator produces loan 1 monthly payment, loan 2 monthly payment, loan 1 total cost, loan 2 total cost, loan 1 total interest, loan 2 total interest, interest difference from those inputs.
What is the loan comparison when loan amount is $200,000?
With loan amount = $200,000, the result is loan 1 monthly payment = 1264.14, loan 2 monthly payment = 1797.66, loan 1 total cost = 455088.98, loan 2 total cost = 323578.18, loan 1 total interest = 255088.98, loan 2 total interest = 123578.18, interest difference = 131510.80. This is worked through in full in the example on this page.
Related Topics
Use the Interactive Calculator
Skip the manual math — get instant results with our free Loan Comparison calculator.
