You’ve collected two or three loan offers. The rates look similar, the monthly payments are in the same neighborhood, and each lender insists theirs is the best deal. How do you actually choose? The answer is a loan comparison worksheet — a structured, line-by-line template that forces every offer through identical math, exposing the true cheapest option and the hidden costs that marketing glosses over. Lenders present offers in whatever format flatters them; your worksheet normalizes them.
This guide gives you the complete worksheet: every line to fill in, where to find each number, how to score the results, and the judgment calls no worksheet can make for you. Pair it with the calculators from our best loan calculators guide, and you’ll evaluate offers like a professional underwriter. Educational information, not financial advice.
Key Takeaways
- Never choose between loan offers on headline rate or monthly payment alone — compare total lifetime cost through identical line items.
- The worksheet has four sections: loan basics, upfront costs, ongoing costs, and scenario tests.
- Get every number from official disclosures (Loan Estimates, offer letters), not from verbal quotes or advertisements.
- Rank offers by total cost first; use monthly payment and flexibility as tiebreakers.
- Re-run the worksheet if anything changes — rates, fees, or your timeline — before signing.
Why You Need a Worksheet (Not Just a “Best Rate”)
Loan offers are engineered to be hard to compare. Lender A advertises a low rate with origination fees buried in the fine print. Lender B offers a slightly higher rate with zero fees but a prepayment penalty. Lender C’s “low monthly payment” comes from a longer term that doubles total interest. Each presentation highlights its strength and obscures its cost — and human brains are bad at holding six variables across three offers simultaneously.
The worksheet solves this by fixing the comparison frame: same rows, same definitions, same math, for every offer. Once normalized, the cheapest offer usually reveals itself immediately — and when two offers are genuinely close, the worksheet’s scenario section shows which one is more robust to your uncertainty.
This is the same normalization principle behind our APR and total-cost calculator guidance: the number that matters is total dollars out of your pocket, computed identically for each contender.
Section 1: Loan Basics — The Identity of Each Offer
Create one column per offer (Offer A, B, C) and fill these rows first:
| Worksheet row | Where to find it |
|---|---|
| Lender name and loan program | Offer letter / Loan Estimate |
| Loan amount | Your application (same across offers, usually) |
| Interest rate (note: fixed or variable) | Loan Estimate, page 1 |
| If variable: index, margin, caps, first adjustment date | Loan Estimate / note |
| Loan term (months) | Loan Estimate |
| Monthly principal & interest payment | Loan Estimate, projected payments |
| Prepayment penalty? (terms) | Loan documents / ask directly |
| Rate lock period and expiration | Lock agreement |
Why each row matters: the rate type determines whether the numbers below are promises or starting points. The term drives total interest more than the rate does. Prepayment penalties change the economics of every future decision (refinance, extra payments, sale). And the lock expiration creates your decision deadline — know it.
Common trap: comparing a 30-year offer against a 15-year offer on monthly payment. Different terms aren’t comparable offers — normalize the term first, or compare total cost at a common horizon.
Section 2: Upfront Costs — What You Pay to Get the Loan
Upfront costs are where offers diverge most deceptively. List every one:
| Worksheet row | Where to find it |
|---|---|
| Origination / lender fees | Loan Estimate, Section A |
| Application / underwriting / processing fees | Loan Estimate, Section A |
| Points / discount fees (and the rate they buy) | Loan Estimate; ask for the buydown math |
| Appraisal fee | Loan Estimate, Section B |
| Title, settlement, recording fees | Loan Estimate, Sections B–C |
| Prepaid interest / escrow deposits | Loan Estimate, Sections F–G |
| Total upfront cash required | Sum — your comparison number |
How to think about points: paying points (prepaid interest) buys a lower rate. Whether it pays off depends entirely on how long you keep the loan — divide the points cost by the monthly payment savings to get the breakeven in months. If you’ll sell or refinance before breakeven, points are a donation to the lender.
The key insight: upfront costs hit hardest on short horizons. A fee-heavy offer can look cheap over 30 years and expensive over 5. Your realistic hold period — not the full term — is the denominator that matters. This is the same breakeven logic as refinancing analysis: upfront costs must be amortized over the time you’ll actually hold the loan.
Section 3: Ongoing Costs — What You Pay Every Month and Over Time
| Worksheet row | Where to find it / how to compute |
|---|---|
| Monthly P&I payment | Loan Estimate |
| Monthly mortgage/tax/insurance escrow (if applicable) | Loan Estimate; tax assessor for accuracy |
| Monthly insurance premiums specific to the loan (e.g., mortgage insurance) | Loan Estimate; ask when it drops off |
| Total monthly outlay | Sum |
| Total interest over full term | Amortization schedule |
| Total of all payments (P&I over full term) | Amortization schedule |
| Total lifetime cost (payments + all upfront fees) | Your ranking number |
| APR | Loan Estimate (computed, for reference) |
Ranking rule: sort offers by total lifetime cost, lowest first. That’s your primary ranking. Then check the monthly outlay ranking — if the cheapest lifetime offer has a monthly payment you can’t comfortably afford, it’s not actually available to you, and the ranking must respect your cash-flow constraint.
Mortgage insurance nuance: if an offer requires it, note the monthly cost and the cancellation terms — when it drops off (by schedule, by request at a threshold, or automatically) changes the total cost meaningfully. Two offers with the same rate can differ by thousands in insurance costs alone.
Section 4: Scenario Tests — Stress-Testing the Winner
The worksheet’s final section protects you from optimizing for a future that doesn’t happen:
Scenario A — you exit early. Recompute total cost assuming you sell, refinance, or pay off in 5–7 years instead of full term. Fee-heavy offers with low rates often lose this scenario badly — the upfront costs never amortize.
Scenario B — rates move (variable-rate offers). Model the payment at the first adjustment cap and the lifetime cap. If the worst case breaks your budget, the offer’s current cheapness is a trap.
Scenario C — you pay extra. Model an extra monthly principal payment you could sustain. Offers with prepayment penalties or minimum-interest clauses punish this; clean offers reward it. The best offer for an aggressive payer may differ from the best offer for a minimum payer.
Scenario D — income shock. Which offer’s required payment leaves you the most breathing room if income drops 20%? The cheapest lifetime offer isn’t the best if its payment is fragile.
An offer that wins the base case but loses every scenario is a fair-weather offer. Prefer the one that’s cheapest across the scenarios you consider plausible — robustness beats optimization.
Where to Find Every Number (and What to Do When You Can’t)
The Loan Estimate (mortgages). US law standardizes this three-page disclosure — it’s designed exactly for worksheet comparison. Use it; it’s the most borrower-friendly document in lending. Key pages: page 1 (rate, payment, costs summary), page 2 (fee breakdown by section), page 3 (total interest, APR, servicing).
For non-mortgage loans, disclosures vary. Demand in writing: the full fee schedule, the APR, the total of payments, prepayment terms, and variable-rate mechanics. A lender that won’t put numbers in writing is telling you something — listen. For personal loans specifically, our secured vs unsecured guide covers which structure to evaluate first; for business borrowing, the term loan vs line of credit comparison comes before the worksheet.
When a number is missing: mark the row “TBD” and get it before deciding. Never fill gaps with assumptions favorable to the lender. And beware verbal quotes that differ from written ones — the written disclosure governs, always.
Rate lock documentation: get the lock terms in writing — rate, points, lock period, and what happens if closing slips past expiration. An expired lock can reprice your whole worksheet overnight.
Scoring the Worksheet: From Numbers to Decision
With all rows filled, decide in this order:
1. Eliminate on constraints. Any offer whose monthly outlay strains your budget, whose worst-case variable scenario breaks you, or whose lender won’t document terms — out, regardless of lifetime cost.
2. Rank survivors by total lifetime cost. Lowest wins the primary ranking.
3. Apply scenario results. If the lifetime winner loses badly in your most plausible alternative scenario (early exit, rate rise), downgrade it. The robust runner-up may be the better real-world choice.
4. Price the intangibles. Lender responsiveness, servicing reputation, flexibility on closing timelines — these have real value, especially for purchases with deadlines. A slightly pricier offer from a reliable lender can beat a cheaper one from a chaotic operation. But quantify “slightly” — intangibles justify small premiums, not large ones.
5. Negotiate with the worksheet. Here’s the worksheet’s secret superpower: take your completed comparison to your preferred lender and show them the gap. “Your total cost is $X higher than Offer B because of Y fee — can you match?” Lenders negotiate fees far more often than borrowers assume, and a worksheet turns haggling into arithmetic. Come with specifics, not vibes: name the fee, name the competing number, ask for the match. Even partial concessions — a waived origination fee, a lender credit toward closing costs — shift the lifetime ranking. And if the lender won’t budge, you have a ranked list of alternatives ready: the worksheet is both sword and shield.
A Filled Example: Walking Through Two Offers
Theory is good; a worked illustration is better. Imagine two offers on the same loan amount and term (simplified illustrative numbers — your worksheet will use real disclosures):
Offer A: slightly lower rate, 1% origination fee, standard closing costs, no prepayment penalty.
Offer B: slightly higher rate, zero origination fee, slightly lower closing costs, no prepayment penalty.
Section 1 looks nearly identical — same amount, same term, rates within a hair of each other. Section 2 diverges: Offer A’s origination fee plus closing costs totals noticeably more upfront cash than Offer B’s leaner structure. Section 3 is where the decision forms: compute total lifetime cost for each. Offer A’s lower rate saves a little each month, but the upfront fee takes years to earn back — run the breakeven: fee divided by monthly savings. If breakeven lands at year six and you might move in year five, Offer B wins despite the higher rate. If you’re certain you’ll hold the full term, Offer A’s lifetime total edges ahead.
Section 4 then asks the uncomfortable questions: what if you refinance in year four when rates drop? Offer A’s unamortized fee becomes dead money; Offer B shrugs. The worksheet doesn’t just rank — it narrates each offer’s risk story. That’s the level of understanding that turns a good decision into a confident one.
Keeping the Worksheet After Signing
Don’t file the worksheet away once the loan closes — it becomes a living document:
Refinance monitoring. When rates move, your completed worksheet is the baseline for breakeven math: current remaining cost vs. new offer’s total cost. No rebuilding from scratch.
Extra payment planning. The amortization rows show exactly what extra payments save. Revisit yearly: can you increase the extra amount? The worksheet quantifies the reward.
Insurance and escrow audits. Escrow analyses arrive yearly and often contain errors or drift. Your worksheet’s original tax/insurance rows are the reference for spotting them.
The next loan. Every future borrowing decision starts from this template. Save a blank copy — your second worksheet takes half the time and benefits from everything the first one taught you.
Comparing different loan amounts. Keep the amount constant across offers. If one lender suggests borrowing more “because you qualify,” that’s a different decision — run a separate worksheet.
Ignoring the hold period. Ranking by 30-year total cost when you’ll likely move in 7 years misranks fee-heavy offers. Always run the early-exit scenario.
Forgetting opportunity cost of upfront cash. Money paid in fees at closing can’t be invested or held as reserves. On large fee differences, this matters — though it’s usually secondary to the direct cost comparison.
Treating APR as the whole answer. APR is a useful summary but it standardizes imperfectly and assumes full-term holding. Use it as a cross-check on your worksheet ranking, not a replacement for it.
Letting the monthly payment decide alone. The lowest payment usually means the longest term or the most fees — i.e., the highest total cost. Payment matters for affordability; it must never be the selection criterion by itself.
Analysis paralysis. The worksheet serves the decision; it isn’t the decision. Once offers are ranked and scenarios run, choose. An extra week of shopping rarely beats the cost of a rate lock expiring. Set a decision deadline when you start the worksheet — the lock expiration is a natural one — and honor it.
Trusting the lender’s summary instead of your worksheet. After all your careful work, a loan officer may present a “summary comparison” showing their offer winning. Smile politely and trust your own normalized numbers. Their summary uses their assumptions; your worksheet uses yours. If their summary disagrees with your worksheet, ask them to explain the discrepancy line by line — the explanation itself is informative.
Adapting the Worksheet for Different Loan Types
Personal loans: simpler — fewer fee categories, no escrow. Focus rows: origination fee, rate, term, prepayment terms, total cost. Our personal loan vs credit card and secured vs unsecured comparisons cover the structural choices feeding into the worksheet.
Auto loans: watch dealer-arranged financing markups, add-on products (extended warranties, GAP insurance) bundled into the amount financed, and prepayment terms. Compare the dealer’s offer against a direct lender’s on identical amounts.
Business loans: add covenant rows (financial ratios, restrictions), collateral terms, and guarantee scope. The business credit card vs business loan and term loan vs line of credit guides cover which structure to worksheet in the first place. Business worksheets also benefit from a cash-flow timing row — when payments hit relative to revenue cycles — since a loan that’s cheap on paper but payable in your worst month is a different proposition.
Refinancing: the worksheet compares remaining cost of the current loan (not original cost) against total cost of the new loan including closing costs — plus the breakeven month. Never compare a refinance offer against the original loan’s original terms; compare against what’s left. And model the reset honestly: a refinance that lowers your payment by extending the term may increase total remaining cost — the worksheet’s lifetime row catches what the payment row hides.
Frequently Asked Questions
How many offers should I compare?
Three is the sweet spot for most borrowers — enough to see the market range, few enough to manage deeply. Get all three within a focused shopping window so rate movements don’t distort the comparison and inquiries cluster as one shopping event.
Should I include my current lender’s offer?
Yes — especially for refinancing, where the current lender may waive fees to retain you. But evaluate it on the worksheet like any other; incumbency deserves no premium.
What if two offers are nearly tied?
Choose on scenarios and intangibles: which survives your plausible bad cases, which lender is more reliable, which has cleaner prepayment terms. Near-ties mean the financial difference is small — optimize for robustness and peace of mind.
Can I use this worksheet for comparing a 15-year vs 30-year term?
Yes — run the worksheet twice (once per term) with the same lender, then compare the two completed worksheets. This separates the term decision from the lender decision, which is exactly the clarity the 15 vs 30 year mortgage framework calls for.
How do I handle a lender that won’t provide written numbers?
You don’t — you eliminate them. A lender unwilling to document an offer before you commit is a lender whose numbers won’t survive scrutiny. There are always other lenders.
Should I tell lenders I’m comparing offers?
Yes. Lenders expect comparison shopping on significant loans, and transparency often improves offers — fee waivers and rate matches are common when they know they’re competing. Your worksheet is leverage; use it openly.
The Bottom Line
A loan comparison worksheet turns an apples-to-oranges pile of offers into a ranked, scenario-tested decision. Fill the four sections from written disclosures, rank by total lifetime cost, stress-test the winner against your realistic alternatives, and negotiate with the numbers in hand. The hour it takes is among the highest-ROI hours in personal finance — the gap between the best and worst offer on a major loan routinely runs into thousands.
Keep the completed worksheet after signing: it’s your baseline for every future refinance decision, your reference for escrow audits, and your template for the next loan. And remember what the worksheet can’t do — it can’t tell you whether to borrow at all, or how much risk your household should take. Those are judgment calls; the worksheet just makes sure the math behind them is honest. Pair it with the affordability discipline from our calculators guide, and you’ll borrow with unusual clarity — the kind that shows up years later as interest saved, options kept open, and well-earned confidence in every borrowing decision you make. Educational information, not financial advice.