Your quotes, one basis

Refinance offer worksheet

Lenders quote in different shapes: one leads with a low rate and heavy points, another with no points and higher closing costs. This worksheet puts up to three offers you actually received on one basis. For each offer it computes the monthly principal and interest, the points cost in dollars, the total upfront cost, and the break-even month against your current loan, with the arithmetic shown for every figure.

  • Runs only on numbers you type in
  • Nothing you enter leaves your browser
  • No rate is prefilled or suggested

Short answer

Use this worksheet once you have real quotes. Enter the rate, points, closing costs, and term from each Loan Estimate, using offers only, and it compares monthly principal and interest and the break-even month side by side from your own numbers. No lender rate is shown or prefilled here. If you do not have quotes yet, start with the lender directory to pick lenders to ask.

This worksheet runs only on the numbers you type in. It does not pull, prefill, or suggest any rate, and nothing you enter leaves your browser: there is no account, no submission, and no tracking of your figures. Copy the rate, points, closing costs, term, and loan amount from each Loan Estimate you received, then compare the offers on the same basis.

Your current loan

Fill in every field for this offer to see its payment and break-even math.

Fill in every field for this offer to see its payment and break-even math.

Fill in every field for this offer to see its payment and break-even math.

Compare offers only on the same basis: the same loan amount, the same term, points counted the same way, and closing costs taken from the Loan Estimate sections for lender and third-party charges. Prepaid taxes, insurance, and escrow deposits are left out because you owe them on your current loan too. This worksheet gives educational estimates from your inputs, not a loan offer.

How to fill it in

  • Use the Loan Estimate each lender gave you. Copy the loan amount, interest rate, points, and the closing cost total that excludes prepaids and escrow deposits.
  • Keep the basis identical across offers: same loan amount and, where you can, the same term. If one offer uses a different term, its payment is not directly comparable, and the break-even line says so by its size.
  • Judge an offer by its break-even month against how long you expect to keep the loan, not by its rate alone. The Stay or Refi Calculator adds the stay-horizon interest comparison once you have a leading offer.
  • Choosing between the offers themselves rather than against the loan you already have? The Loan Estimate comparator totals each offer's closing costs plus interest over the years you expect to keep it and names the cheaper offer over that horizon.

The formulas used

Monthly principal and interest uses the standard fixed-rate amortization formula, the same one on the methodology page. Points cost is the points percentage multiplied by the loan amount. Total upfront cost is closing costs plus points cost. Monthly saving is your current payment minus the offer payment, both computed from your inputs. Break-even months is total upfront cost divided by monthly saving, rounded up to the next whole month.

Common questions

Why does this worksheet not show me today's rates?

Because a published rate is not a quote for your loan, and this site does not publish lender rates. Get written Loan Estimates from lenders in the lender directory, then compare those real offers here.

Where do the points and closing costs come from?

From your Loan Estimate. Points appear in the loan terms and origination charges; closing costs are the lender charges and third-party services, excluding prepaid taxes, insurance, and escrow deposits. The closing cost guides walk through each section.

Is anything I type sent anywhere?

No. The worksheet computes in your browser only. There is no submit button, no account, and no storage of your figures.

Sources and verification

Arithmetic from the amortization and break-even formulas shown on the methodology page. Closing cost categories follow Consumer Financial Protection Bureau guidance on the Loan Estimate. This worksheet provides educational estimates from your inputs, not a loan offer.