A free worksheet builder for loan officers. Enter up to four loan scenarios for one borrower — program, purchase price, down payment, rate, points, lender fees, title, recording, prepaids, escrow months, mortgage insurance, and lender or seller credits — then download a branded multi-page Loan Comparison PDF to send to the borrower.
Build the first column from your locked pricing, then press Duplicate and change only what moves: a different program, a higher purchase price, a buydown, or a larger seller credit. Every duplicate keeps your fee template, so a second or third option takes seconds. Your contact block and fee template stay in your browser for the next borrower.
Page one is the side-by-side comparison grid: loan purpose, purchase price, down payment, total loan amount, loan-to-value, interest rate, estimated APR, points and price, lock period, total closing costs, seller credit, estimated monthly cost (PITI), and cash to or from closing. Each scenario then prints its own page with principal and interest split from taxes, insurance, and escrows, cash at closing, and itemized loan costs and other costs grouped the way a Loan Estimate presents them.
It is an illustration built only from the figures you enter. It is not a Loan Estimate, a rate lock, or a commitment to lend, and final pricing, rate, and closing costs are subject to credit approval and underwriting review. The disclosure prints on every page of the PDF. APR is an estimate calculated from the points, origination fee, credit report fee, and prepaid interest you entered.