LOCKDAY WORKSHEET

RICK ELMENDORF (NMLS #485091)  |  SVP of Mortgage Lending  |  571-249-5363  |  rick@loanwithrick.com
This is NOT a loan estimate. Your actual rate, payment, and costs could be higher. Get an official Loan Estimate before choosing a loan.
✓ PROJECT MY HOME® APPROVED LISTING — 1-0 lender-paid buydown applied (Year 1 at rate − 1%)
Loan Scenario
$832,750
STEP 2 — WHAT RATE SHOULD I USE?
Pick whichever is easiest — you can change it any time.
A
Don't know your rate? Start here. A sample rate is already filled in below so the worksheet works right now. Every number updates the moment you change it.
B
Check today's live pricing. VA buyers: varates.loanwithrick.com  ·  Everything else: rates.loanwithrick.com
Price a 0, 1, or 2-point quote, then type it into a slot below and tap Use.
C
Want me to price it for you? Call or text 571-249-5363 — or email me your scenario and I'll send back real numbers.
Points % is what the rate costs: positive = you pay, negative = lender credit back to you. More options exist and not all loan options are presented.
Two buttons, two jobs:
Use — prices that rate on this worksheet right now. Everything below updates.
Save — adds that option to the Loan Comparison so you can see it beside the others. It turns ✓ In once it's added.
Save up to three. Then tap Loan Comparison at the top to see them side by side.

▶ Watch: how to use this worksheet · how to check rates
Rate %Points %ShowCompare
Option 1
Option 2
Option 3
Buydown — the "Lower" Programs
PROJECT MY HOME® INCENTIVE — 1-0 BUYDOWN
Buydown funded by RATE as a lender credit on approved Project My Home® listings — it does not increase your cash to close. Project My Home® is a real estate marketing program, not a lender; all financing is provided by Rate, Inc. Illustration only — NOT a Loan Estimate.
$0
Estimated Monthly Payment
Estimated Cash to Close
Closing Costs
Prepaids & Escrows
Loan Comparison
How this works: on the Worksheet tab, type a rate and points into an option row and tap Save. It lands here. The ones marked ✓ Active — up to three — show side by side below, in the order you set with ◀ ▶. Edit any scenario in place; its name and its numbers both update.
Today's rates:  VA buyers → varates.loanwithrick.com  ·  All other programs → rates.loanwithrick.com
Price a 0, 1, or 2-point quote. More options exist and not all loan options are presented.
Your Saved Scenarios
Nothing here yet. On the Worksheet tab, enter a rate and points in an option row and tap Save — that adds it here. Or set up the whole worksheet and use the button above. Each one is named automatically.
Today's rates: VA buyers → varates.loanwithrick.com · all other programs → rates.loanwithrick.com
▶ VIDEO: How to add a rate option (coming soon)
Loan Comparison
Show every line item in all three columns
Estimated APR is calculated from the amount financed and payment stream shown and is an estimate only.
Amortization
All amortization runs at the note rate. A temporary buydown never changes the loan's amortization — it funds a buydown balance (paid by the seller or lender) that subsidizes the payment difference each month; any remaining buydown balance is applied to the loan payoff.
YrBeginningPrincipalInterestEnding
VA Entitlement
Seller Concessions (M26-7 Ch. 8-D)
Assumptions & Fees
Tax escrow months auto-set by state (3 standard; Maryland 9 = 6 up front + 3 escrow). Transfer/recordation shows the customary BUYER share by state; owner's title defaults to seller-paid where that is the custom (FL and most western states). Customs vary by county and contract — every figure above is editable, and estimated states are approximations pending verification.
Disclosures
The example of loan costs illustrated in this tool does not represent a "Loan Estimate of Closing Costs" that you will receive once you apply for a loan. This example is being provided to you for illustrative purposes only, and the amounts shown therein are only approximations. The actual amounts for each item may vary by town, property type, title vesting, or other factors, and there may be additional cost in any mortgage transaction, that are not detailed above. Lender credits are illustrative, you may not be eligible for a lender credit. Actual payment obligations may be greater. This is an approximate loan cost example, and does not constitute a loan approval, or a commitment to lend. As interest rates change daily, the monthly payment information listed above is subject to change. Assumes first lien position. The figures as shown are not an example of actual program terms. Your individual terms will vary. All approvals are subject to underwriting guidelines and applicant's credit profile. Not all applicants will be approved. Program rates, terms, and conditions are subject to change at any time. Taxes and Insurance are estimated based on the information provided paired with historical data for the location and property characteristics. The estimated Mortgage Insurance is based upon a variety of assumptions and conditions which include a borrower's loan type and term length, loan amount and down payment amount and are subject to change. Your estimated Mortgage Insurance quote may be high if your debt-to-income (DTI) ratio exceeds 45%. Get an official Loan Estimate before choosing a loan. Your actual rate, payment and costs could be higher. Contact Guaranteed Rate, Inc. D/B/A Rate for more information and up to date rates and to receive an official Loan Estimate.
Rick Elmendorf: NMLS ID #485091 (Nationwide Mortgage Licensing System, www.nmlsconsumeraccess.org) • ME - Licensed • VA - MLO-9918VA • TN - 485091 • SC - MLO - 485091 • FL - LO13779 • GA - 42415 • NJ - Licensed • WV - LO-485091 • ND - NDMLO485091 • AR - 485091 • AL - 485091 • MA - MLO485091 • TX - Licensed • CO - 100544653 • KY - MC915184 • NY - Licensed • PA - 104077 • MI - 485091 • KS - LO.0056990 • MD - 485091 • CA - CA-DFPI485091 • OH - MLO-OH.485091 • DC - MLO485091 • NC - I-153190 • IL - 031.0090398
Full corporate licensing for Guaranteed Rate, Inc. D/B/A Rate appears on the Disclosures tab of the LockDay Worksheet workbook and on any official Loan Estimate. Equal Housing Lender.
Rick Elmendorf
Rick Elmendorf
SVP of Mortgage Lending · THE ELMENDORF TEAM AT RATE
NMLS #485091
Rate — The Elmendorf Team
© 2026 Rick Elmendorf. All Rights Reserved. · Build v40 · loanwithrick.com · #12 in VA Loan Volume Nationwide — Scotsman's Guide 2025. Project My Home® is a real estate marketing program, not a lender; PMH-mode buydowns are funded by Rate, Inc. as a lender credit on approved listings. VA figures reflect the entitlement entered on the VA Loan Data tab. Conventional MI shown from placeholder factors pending live provider quotes. This is not a Loan Estimate or a commitment to lend.
High-Cost Counties (131)
Estimates only — NOT a Loan Estimate
Total Monthly (PITI)
$0/mo
Cash to Close
$0