Choosing whether to lock a mortgage rate or wait for a potentially better quote is a cost-and-risk decision, not simply a forecast about where rates may go. This worksheet helps you compare lock periods, lender credits, extension charges, float-down terms, payment changes, and closing-date uncertainty using the figures in your latest loan estimate or mortgage offer.
Overview
A mortgage rate lock usually sets the interest rate and, in some cases, specified loan terms for a stated period while the lender processes the application. A float means the rate remains subject to change until you lock it or the loan closes. The exact meaning, eligible products, expiration rules, and fees depend on the lender, loan type, market, and jurisdiction.
The decision has two sides. Locking can protect your budget if rates rise, but a longer lock may come with a higher rate, a fee, or less flexibility if your purchase is delayed. Floating may preserve access to a lower rate if market pricing improves, but it exposes you to higher payments, increased cash requirements, or a change in affordability before closing.
Do not compare the headline rate alone. Compare the total cost of each option over a period that matters to you, such as the first five years, and include the risk of a delayed closing. A lender credit, discount points, underwriting fee, rate-lock charge, extension fee, or revised closing-cost estimate can change which offer is more economical.
For wider transaction planning, pair this exercise with a mortgage payment comparison worksheet and the home closing costs planner. Those tools help place the rate decision alongside taxes, insurance, legal or settlement charges, inspections, and other costs.
How to estimate
Start with two scenarios: Option A: lock now, and Option B: float or lock later. If the lender offers several lock periods, create a separate row for each one. Use the same loan amount, term, repayment structure, property taxes, insurance assumptions, and expected closing date in every row.
- Record the rate and points. Write down the interest rate, annual percentage rate if supplied, discount points, lender credits, and any other rate-related charge. A lower rate may require more money at closing.
- Calculate the principal-and-interest payment. Use the lender’s payment figure where available, or a mortgage calculator using the exact loan amount, term, and rate. Keep taxes, insurance, association dues, and mortgage insurance separate so the rate comparison is not confused with the total housing payment.
- Estimate the interest-rate break-even point. If locking costs more but gives you a lower rate, divide the additional upfront cost by the monthly payment saving. The result is the approximate number of months needed to recover that cost. This is only a comparison tool; it does not account for taxes, refinancing, prepayment, or changes in the loan balance.
- Price a delayed closing. Ask what happens if the lock expires before settlement. Add the stated extension fee, any rate adjustment, per-day charge, re-lock requirement, or change to lender credits. Request the answer in writing because the treatment of an expired lock varies.
- Stress-test the floating option. Enter a higher rate as a planning case and recalculate the payment, cash needed at closing, and affordability measures. This is not a prediction. It shows whether an adverse move would make the purchase uncomfortable or cause the loan to fail an underwriting condition.
- Check the improvement option. If a float-down or renegotiation feature exists, record when it can be used, whether the request must be made before closing, whether there is a fee, and whether the lender must approve the new rate. Do not assume a float-down is automatic.
A simple comparison formula is:
Estimated cost of an option = upfront rate costs + extra payment during the comparison period + delay or extension costs − lender credits.
For a fuller household budget, include the result in your home affordability workbook. A rate that appears manageable in isolation may be unsuitable once maintenance, moving costs, emergency savings, and closing fees are included.
Inputs and assumptions
Before completing the worksheet, gather the most recent written figures from each lender. At minimum, capture:
- Loan amount, repayment term, loan type, and whether the rate is fixed or variable after closing.
- Quoted rate, annual percentage rate where provided, points, lender credits, and rate-related fees.
- Lock duration, lock start date, expiration date, and the event that starts the lock clock.
- Whether the lock is available for the selected property, loan program, occupancy type, and borrower profile.
- Extension rules, including the fee basis, maximum extension period, and whether the rate or credit changes.
- Re-lock rules if the original lock expires or the loan changes materially.
- Float-down or renegotiation terms, including eligibility, timing, fees, and any limits on the improved rate.
- Expected closing date, appraisal status, underwriting status, document deadlines, and known transaction dependencies.
Separate facts from assumptions. The closing date in a purchase contract is an estimate, not always the date the loan can fund. Appraisal delays, title or conveyancing issues, document corrections, property repairs, inspection negotiations, seller delays, and changes to the borrower’s finances can affect the schedule. Review the accepted offer to closing timeline to identify dependencies that may matter for the lock period.
Also distinguish a rate lock from a guarantee that the loan will close at that rate. A lock may be conditional on complete documents, an acceptable valuation, underwriting approval, and compliance with the lender’s terms. Ask what happens if the loan amount, property, borrower, or loan program changes.
When comparing lenders, keep the comparison fair. A lower rate paired with higher points is not necessarily cheaper. Likewise, a lender credit may reduce cash needed at closing while increasing the rate or long-term interest cost. Consider both immediate cash and the period you expect to keep the loan. For an independent property-value review before finalizing the loan amount, see the comparable sales and offer-price worksheet.
Worked examples
Example 1: Paying more for certainty. Assume a buyer compares a 30-day lock with a 60-day lock. The 60-day option has a higher rate and no separate extension charge, while the 30-day option has a lower rate but may require an extension if closing slips. The buyer estimates that the lower-rate option saves a set amount each month. The break-even calculation is the extra upfront cost of the 60-day lock divided by the monthly saving from the 30-day lock. If the expected closing date is close to the 30-day expiration and several dependencies remain unresolved, the buyer should also add the possible extension cost to the short-lock scenario. The result may justify the longer lock even if its initial quote is less attractive.
Example 2: Floating with a defined risk limit. Another buyer has a closing date several weeks away and is considering floating. The buyer records the current payment, then runs a planning case at a higher rate. If the higher payment still fits the household’s budget and the lender confirms that the loan remains within qualification limits, floating may be a tolerable risk. If the higher case would require reducing reserves, changing the down payment, or failing an affordability test, locking may offer valuable certainty. The calculation does not predict the market; it clarifies the cost of being wrong.
Example 3: Evaluating a float-down. Suppose a lender allows a rate improvement under defined conditions after a lock. Compare the locked payment and upfront charges with the payment under the improved rate, then confirm whether the lender charges a fee or removes a credit. Check the deadline and documentation requirements. A float-down is useful only if its conditions are understood and the expected saving exceeds any associated cost.
In each example, write down the decision rule before looking for a new quote: for example, “Lock if the higher-rate stress case makes the payment unaffordable” or “Choose the longer lock if the likely extension cost exceeds the price of certainty.” A clear rule reduces the temptation to change strategy based on every small market movement.
When to recalculate
Revisit the worksheet whenever a lender issues a revised loan estimate, changes the rate or credit, or presents a new lock period. Recalculate immediately if the purchase price, down payment, loan amount, property type, occupancy, loan program, or expected closing date changes.
Recheck the numbers when the appraisal or inspection leads to a renegotiated price, when repairs affect the transaction schedule, or when underwriting requests documents that may delay approval. If you are comparing a new quote with an existing lock, ask whether switching lenders would restart the application process, create new fees, or put the closing date at risk.
Before the lock expires, confirm the expiration time and the lender’s process for extending or relocking. Do not wait until the last business day to ask. Obtain written confirmation of the rate, lock period, credits, points, extension terms, and conditions. Keep the latest comparison beside your closing-cost estimate and update your cash-to-close figure.
Finally, review the worksheet whenever market rates move materially or your personal budget changes. The right choice is not always the option with the lowest possible rate. It is the option whose total cost, cash requirement, and closing risk remain acceptable under realistic scenarios. Once the loan closes, retain the final disclosures and use the actual payment and closing figures to improve future mortgage comparisons, refinancing break-even calculations, or long-term home-equity planning.