$0 Refinancing Decision Worksheet & Break-Even Calculator — Quick-Start Checklist

Refinance Decision Worksheet vs. Mortgage Broker: Which Should You Use First?

Refinance Decision Worksheet vs. Mortgage Broker: Which Should You Use First?

The short answer: use a decision worksheet first, then a mortgage broker second. A worksheet runs the math before you talk to anyone with a financial stake in the outcome. A broker is valuable for execution once you already know the refinance makes sense — but a broker's pre-analysis is structurally biased toward recommending a close, because a broker earns nothing when you stay put.

This is not an indictment of mortgage brokers. It is the structural math of the industry. Understanding when each tool serves your interests — and in what order — is the actual decision most homeowners get wrong.


What a Mortgage Broker Actually Does

A mortgage broker is an intermediary who shops your loan application across multiple wholesale lenders. They do not lend their own money. Their value is access to lender pricing that retail borrowers cannot reach directly, and the ability to handle the paperwork-heavy underwriting process.

How brokers are compensated:

  • Origination fees paid by you at closing: typically 0.5% to 1.5% of the loan amount
  • Yield Spread Premium (lender credit): the lender pays the broker a commission for placing your loan at a rate above the floor pricing

On a $350,000 mortgage, broker compensation runs $1,750 to $5,250. This is earned when the loan closes. It is forfeited when you decide not to refinance.

This creates a structural incentive problem. When a broker runs a "refinance analysis" for you, they are performing that analysis as someone who is paid by the transaction. Their analysis is almost always correct about the mechanics — the rate, the payment, the simple break-even. What it systematically omits are the factors that might make the transaction a net loss: the amortization reset penalty, the equity break-even (which is 50%–100% longer than the payment break-even), the opportunity cost of closing costs, and the option value of waiting if rates are still falling.


What a Decision Worksheet Does

A decision worksheet is a pre-committed analytical framework you complete before talking to any lender or broker. It does not care what answer it produces. It forces you to input your actual numbers and calculates the outcome those numbers justify.

A well-designed refinancing worksheet runs calculations that no free online tool and no commission-driven broker presentation will show you:

  • Payment break-even: the simple number everyone calculates (closing costs divided by monthly savings)
  • Amortization-adjusted break-even: the true net worth crossover point, accounting for the equity you stop building when you reset your amortization schedule — this number is consistently 50%–100% longer than the payment break-even
  • Lifetime interest comparison: the total interest paid under the current loan vs. the refinanced loan over their full terms
  • Equity position trajectory: month-by-month comparison of your balance under the current path vs. the refinanced path
  • NPV-adjusted analysis: the net present value of the refinance transaction, discounted at your opportunity cost of capital
  • 6-hurdle decision framework: a sequential checklist that a refinance must pass — holding period, amortization position, LTV cushion, prepayment penalty, NPV, and option value of waiting — before the transaction is financially sound

Head-to-Head Comparison

Factor Mortgage Broker Analysis Refinancing Decision Worksheet
Cost Free upfront; $1,750–$5,250 at closing if you proceed Fixed cost, paid regardless of what you decide
Financial stake in outcome Paid when you close; earns nothing when you stay No stake — produces the same math either way
Amortization reset analysis Rarely included; most broker presentations use simple break-even Core calculation; shows equity position crossover
Lifetime interest comparison Sometimes shown; usually framed optimistically Calculated under both paths with no framing bias
"No-closing-cost" decoder Unlikely to quantify the true cost of rate-premium structures Explicit: models rolled-in costs vs. higher rate vs. cash payment
Country-specific tax/penalty rules Variable; depends on broker expertise Covered: US IRS rules, Canadian IRD, UK ERC windows, AU LMI
Best for Executing a refinance you have already decided to pursue Deciding whether to pursue a refinance at all

Free Download

Get the Refinancing Decision Worksheet & Break-Even Calculator — Quick-Start Checklist

Everything in this article as a printable checklist — plus action plans and reference guides you can start using today.

Who This Is For

  • Homeowners who received a call or letter from a lender recommending a refinance and want to verify the math independently before responding
  • Homeowners 5 to 15 years into their mortgage who suspect the amortization reset could wipe out the rate savings
  • Homeowners with a 2020–2021 rate in the 2.5%–3% range being pitched cash-out refinances at current rates above 6%
  • Anyone who has been told a refinance is a "no-brainer" and wants the worksheet that proves or disproves that claim

Who This Is NOT For

  • Homeowners who have already decided to refinance and just need someone to shop lenders and manage paperwork — a broker is the right tool for that
  • Homeowners in the early years of a new mortgage (under 3 years old) where simple payment break-even is the dominant consideration
  • UK homeowners whose fixed-rate deal has already expired and reverted to the Standard Variable Rate — in that case, the decision is already made (remortgage immediately), and broker execution is the priority

The Structural Problem with "Free" Broker Analysis

The reason most homeowners get broker analysis first is that it feels free. No upfront cost, no commitment, just a conversation. But the analysis is not actually free — the cost is the hidden framing.

Broker presentations universally present the simple break-even: closing costs divided by monthly payment savings. If a refinance costs $6,000 in closing costs and saves $250 a month, the simple break-even is 24 months. The broker tells you this and asks when you plan to sell.

What the presentation does not show: if you are 10 years into a 30-year mortgage and refinance into a new 30-year term at a lower rate, the amortization reset means the early months of the new loan are heavily weighted toward interest, not principal. You lose the amortization advantage you built over 10 years. On a $300,000 balance, this can add $28,000–$48,000 in total lifetime interest — turning a transaction that "breaks even in 24 months" into one that costs you more money than it saves over the full holding period.

The simple break-even ignores this entirely. The broker has no incentive to model it. The free Bankrate calculator has no incentive to model it either (it generates mortgage leads). The decision worksheet models it because it has no stake in the answer.


The Right Sequence

  1. Run the worksheet before calling anyone. Input your current loan balance, remaining term, interest rate, and the proposed new rate with estimated closing costs. Calculate both break-even figures and the lifetime interest comparison.

  2. If the worksheet shows the refinance is a net positive, calculate the rate threshold at which it makes sense — not just today's rate, but the minimum rate drop required to pass all six hurdles given your specific amortization position.

  3. Then engage a mortgage broker with specific instructions: shop for X rate with closing costs under Y, provide Loan Estimates (not informal quotes) from at least three lenders for side-by-side APR comparison.

  4. Use the closing cost worksheet to review the Loan Estimates and separate negotiable lender fees from non-negotiable third-party charges.

This sequence gives you the analytical independence of a fee-only financial planner plus the execution capability of a broker — without paying $200–$400 per hour for the planning step.


Country-Specific Notes

US: The broker's commission is disclosed on the Loan Estimate under "Origination Charges." Compare it across multiple Loan Estimates — this fee is negotiable.

Canada: Mortgage brokers in Canada are often compensated entirely by lender "finder fees," meaning their service appears free to you. The IRD prepayment penalty risk is the critical variable a worksheet must model before you engage any broker for a mid-term refinance.

UK: Independent mortgage advisors operate under FCA regulations and must disclose their fee structure. A full independent advisor charges a flat fee (typically £400–£1,500) and is not commission-dependent. This is structurally similar to using a worksheet: unbiased analysis before execution.

Australia: Mortgage brokers are required to act in your best interest under ASIC regulations following the Best Interests Duty reform. The clawback risk (broker commission clawback if you exit within 12–18 months) means brokers have an incentive to recommend lenders with lower churn — worth understanding before you proceed.


FAQ

Can I use a mortgage broker and a worksheet together? Yes — and this is the recommended approach. Use the worksheet to determine whether the refinance makes financial sense and to calculate the minimum acceptable rate. Then use the broker to execute if the worksheet confirms the transaction passes all six hurdles.

Does a mortgage broker charge if I decide not to refinance? Typically no — broker compensation is contingent on closing. This sounds borrower-friendly but creates the incentive problem: the broker's analysis is performed by someone who gets paid only when you say yes.

What does "amortization-adjusted break-even" mean? It is the point at which your net equity under the refinanced loan exceeds what it would have been under the original loan. Because refinancing resets your amortization schedule to year one (early payments heavily weighted toward interest), your equity growth slows for the first several years after refinancing. The amortization-adjusted break-even is consistently 50%–100% longer than the simple payment break-even.

Is a fee-only financial planner better than a worksheet? A fee-only planner can provide personalized advice and ask questions a worksheet cannot. At $200–$400 per hour, a thorough refinance analysis typically costs $400–$800. A worksheet provides the same mathematical analysis for a fraction of the cost and is appropriate for most homeowners without complex tax situations.

What is a Loan Estimate and why does it matter? A Loan Estimate is a standardized 3-page document lenders are legally required to provide within 3 business days of a loan application. It discloses the interest rate, APR, closing costs, and monthly payment in a format designed for comparison shopping. Never compare refinance offers using informal quotes or rate sheets — always compare Loan Estimates.


If you are trying to determine whether your refinance makes financial sense before talking to any lender or broker, the Refinancing Decision Worksheet & Break-Even Calculator walks you through the six-hurdle framework, both break-even calculations, and the amortization reset analysis — the complete math that any commission-driven analysis has a structural incentive to omit.

Get Your Free Refinancing Decision Worksheet & Break-Even Calculator — Quick-Start Checklist

Download the Refinancing Decision Worksheet & Break-Even Calculator — Quick-Start Checklist — a printable guide with checklists, scripts, and action plans you can start using today.

Learn More →