How it works
Amortize both offers with rounded monthly interest and a final balance adjustment; compare all payments plus upfront fees.
Input definitions
- Loan principal
- Enter the value in the labeled unit.
- Offer A annual rate (%)
- Enter the value in the labeled unit.
- Offer A months
- Enter the value in the labeled unit.
- Offer A upfront fees
- Enter the value in the labeled unit.
- Offer B annual rate (%)
- Enter the value in the labeled unit.
- Offer B months
- Enter the value in the labeled unit.
- Offer B upfront fees
- Enter the value in the labeled unit.
A worked example
- Loan principal
- 10000
- Offer A annual rate (%)
- 6
- Offer A months
- 36
- Offer A upfront fees
- 100
- Offer B annual rate (%)
- 8
- Offer B months
- 36
- Offer B upfront fees
- 0
Assumptions & limits
Entered single-currency amounts and fixed rates; monthly interest and two-decimal half-up rounding. No tax, lending approval, changing rates or live market data.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Should I compare monthly payments or total loan cost?
Compare both: a longer term can lower the payment while increasing total interest. This tool includes upfront fees and shows each offer’s payment, interest and total cost.
How does Compare two loan offers work?
Amortize both offers with rounded monthly interest and a final balance adjustment; compare all payments plus upfront fees.
What are the limits of Compare two loan offers?
Entered single-currency amounts and fixed rates; monthly interest and two-decimal half-up rounding. No tax, lending approval, changing rates or live market data.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.