How to Compare Loan Offers Side by Side: A Step-by-Step Worksheet

When you receive more than one loan offer, it is tempting to pick the one with the lowest advertised rate or the smallest monthly payment. Both numbers can be misleading on their own. A low rate may come with a large arrangement fee, and a small monthly payment often means a longer term and more interest overall. The most reliable way to choose is to lay the offers out side by side, using the same set of questions for each. This guide gives you a simple worksheet you can copy into a notebook or spreadsheet.

Step 1: Make sure you are comparing like with like

Offers are only comparable if they describe roughly the same loan. Before you start, check that each one is for the same amount and, ideally, the same term. If one lender quotes 10,000 over three years and another quotes 12,000 over five years, the numbers will not tell you much. Ask each lender for a quote on identical terms, or use their online calculators to adjust the amount and length so they match.

Also confirm whether each offer is a firm offer or just an estimate. Many lenders show an illustrative rate before a full credit check, and the final rate can be different.

Step 2: Build your comparison worksheet

Create one column per offer and one row for each item below. Fill it in using the loan documents and key information sheets, not just the advertising.

Item	Offer A	Offer B	Offer C
Amount borrowed
Term (months)
Interest rate (fixed or variable)
Annual percentage rate (APR)
Upfront or arrangement fees
Monthly payment
Total amount repayable
Early repayment charges
Late payment fees
Required add-ons (insurance, membership)

Step 3: Focus on the total amount repayable

If you only look at one number, make it the total amount you will repay over the life of the loan, including all mandatory fees. This is the clearest measure of what the money really costs you. Subtract the amount borrowed from the total repayable to get the total cost of credit.

Consider two simple examples for a loan of 10,000 over three years:

Offer A: monthly payment of 330, no fees. Total repayable: 330 × 36 = 11,880. Cost of credit: 1,880.
Offer B: monthly payment of 315, plus a 400 arrangement fee. Total repayable: 315 × 36 + 400 = 11,740. Cost of credit: 1,740.

Here Offer B is cheaper overall despite the fee. Change the fee to 700 and Offer A becomes cheaper. Only by writing the totals down can you see which way the balance tips.

Step 4: Use APR as a cross-check, not the final answer

The APR combines the interest rate with most compulsory fees and expresses them as a yearly rate, which makes it a useful shortcut for comparison. However, it has limits. It assumes you keep the loan for the full term, so it does not reflect early repayment charges. It may exclude optional products and some conditional fees. And a representative APR in an advert may only be offered to a portion of applicants. Use APR to spot obvious outliers, then confirm with the total amount repayable.

Step 5: Check flexibility and conditions

Cost is not the only factor. Two loans with the same total cost can behave very differently when your circumstances change. For each offer, note:

Fixed or variable rate: a fixed rate keeps payments predictable; a variable rate can rise.
Overpayments: can you pay extra or settle early, and is there a charge for doing so?
Payment date flexibility: can you choose or change the date to match your pay day?
Hardship options: what does the lender say about payment breaks or restructuring if you struggle?
Security: is the loan unsecured, or does it require collateral or a guarantor?

Give each item a simple rating, such as good, acceptable or poor, so the qualitative factors sit alongside the numbers.

Step 6: Test the monthly payment against your budget

The cheapest offer is not the right one if you cannot comfortably afford its payment. Take your current monthly budget and subtract each offer’s payment. Ask yourself whether you would still have room for savings, irregular costs and an unexpected bill. A slightly longer term with a lower payment may be the safer choice, as long as you understand that it usually means paying more interest in total. Write down the minimum buffer you want to keep each month and rule out any offer that breaks it.

Step 7: Watch for red flags

While filling in the worksheet, watch for warning signs that should take an offer off the table regardless of its numbers:

A request for payment before the loan is released.
Pressure to sign the same day or claims that the offer will disappear within hours.
Missing or vague information about fees and the total amount repayable.
Insurance or other products added by default without clear explanation.
A lender you cannot verify as authorised or registered where you live.

Making the final decision

Once your worksheet is complete, the choice usually becomes clear. Rank the offers by total amount repayable, remove any that fail your budget test or show red flags, and then use flexibility and conditions to decide between those that remain. Keep the completed worksheet with your loan documents. It records why you chose the loan and gives you a ready-made template the next time you need to borrow.