You need to enable javascript to run this app
Documentation menu

Docs / Reports

Refinance reports

Show a borrower their current mortgage next to one or two refinance options, with the savings math worked out for them.

A refinance conversation lives or dies on one question: "what does this actually save me?" A refinance report answers it visually — the borrower's current mortgage sits beside up to two proposed loans, with the savings math worked out for them.

Create one

Open Clients, pick your client, and click New report. Choose Refinance — "Current loan vs. 1 or 2 proposed loans." (The client's Quick actions card has a New refinance report shortcut that skips the chooser.) The type is fixed once the report is created; if you need a purchase comparison or a single-loan breakdown instead, start a new report.

Each proposed loan comes from a fee sheet marked as a refinance — pick Refinance when you create the fee sheet, or tick its Refinance? checkbox later. Only that client's refinance fee sheets appear in the pickers. Under Refinance loans, choose a fee sheet for each slot and give it a short Fee Sheet label the borrower will recognize ("30-yr fixed," "15-yr cash-out").

A slot you leave on its placeholder has no fee sheet behind it, so LendrTech does not know its escrows, fees or credits — it shows the terms you typed and leaves the payment, APR, costs and cash-to-close blank rather than printing figures that aren't comparable with the costed option beside them.

Enter the current mortgage

The Current Mortgage section is what makes the report a refinance story. Enter the remaining balance, monthly payment, interest rate, and months remaining. Optionally break the payment down — principal & interest, homeowner's insurance, real estate taxes, mortgage insurance, HOA dues — and add a total for monthly consumer debts if you're pitching debt consolidation. These fields drive every savings figure on the report.

Balance, rate, term and principal & interest over-determine each other: any three fix the fourth. When the figure you typed for principal & interest is more than half a percent away from what the balance, rate and term imply, the builder says so — and offers you both ways to reconcile them:

  • Use N months replaces the months remaining with the payoff date the payment you entered actually implies. This is usually the right one when the borrower has been paying extra principal: their payment is what the note says, their balance is below schedule, and it is the remaining term that is stale.
  • Use $X P&I replaces the payment with what the balance, rate and term imply. Right when the payment was simply mistyped.

It never blocks a save, and it never applies either fix by itself — an ARM, a recast, an interest-only period and a borrower who overpays every month all diverge legitimately. The report always measures against the months remaining you typed, so the number in the builder is the number on the page.

It is worth a look either way, because a wrong P&I moves every savings figure and every break-even on the report.

The savings framing

The live preview shows what the borrower will see:

  • Savings summary — the monthly payment difference against the current mortgage, with the total spelled out beneath it. When every option costs more than staying put, the card says so rather than offering a saving.
  • Debt consolidation summary — the alternative headline when the refi rolls consumer debt into the loan, ending in a net savings figure. You can show one of these two summaries, not both. Its three top lines are Current Monthly Mortgage, Other Monthly Debts and Total Monthly Debts — every figure in the card is a monthly payment, never a balance. It names which option it describes, and it assumes you sized that loan to pay the debts off — LendrTech does not resize the loan for you. When money comes back to the borrower the figure is headed Cash to You; when debts are being consolidated it says so, because the proceeds and the retired debts are the same money.
  • Savings over N months — one bar per option over the horizon you pick, from 12 months out to 360 months (30 years); the options past five years are labelled in years as well as months, so you can state the saving over the life of the loan you are selling. Measured against the current mortgage. There is no bar for the current mortgage itself: it is the baseline every bar is measured from, so its own bar could only ever read $0.00.
  • Break-even — a runway under the payment-difference chart: one bar per option showing how far into the savings horizon that option's payback lands, with what it costs up front and what it saves each month. Same figures as the break-even row in the analysis panel; it is on the web report only, not the PDF.
  • Monthly payment difference and monthly payment breakdown charts, plus a comparison table with a Refinance/Payoff row in place of a purchase price. When a refinance hands the borrower money rather than asking for it, the Cash to Close row reads Cash to You.

The analysis panel

Refinance analysis answers the questions the payment alone doesn't, for each option. It opens with a one-line takeaway — what happens to the payment, what it takes to get there, and what happens to the payoff date — and then shows the rows behind it:

  • Pays back its costs in — how many months of savings it takes to recoup the closing costs, net of credits. It compares the charges a refinance actually changes: principal, interest, mortgage insurance and other monthly loan charges. Property taxes, hazard insurance and HOA are left out, because a refinance changes none of them and including them would make break-even move on a property-tax typo. Prepaids are left out for the same reason — the old escrow is refunded after payoff, and the new loan's per-diem stands in for interest you would have paid anyway. If the new payment is higher, or unchanged, there is no break-even, and the panel says so instead of printing a month count.
  • Total interest on this loan and interest saved vs. staying put — the honest bottom line, and the one that catches a lower payment that costs more overall because the term was extended.
  • Paid off in — the new term, and how much sooner or later than today.
  • Loan-to-value and home equity after closing. Both need an Estimated Value on the fee sheet; without one they show a dash rather than measuring against the payoff.
  • Cash at closing — what the borrower brings, or Cash to You when the refinance hands them money. Money brought to the table to pay the balance down is not counted as a cost of the refinance: it stays the borrower's equity, and it is the thing that makes the payment fall. When a cheque is mostly principal the row says how much of it lands on the balance, so a five-figure cash-to-close and a short break-even read as the two facts they are.

The panel is on by default for new reports. A report you saved before it existed opens without it until you tick the box. It carries into the PDF, minus loan-to-value and equity.

The Include rows and Include charts checkboxes control what appears in the static report, and each chart's help text is editable. Include rows choices apply to the downloaded and emailed PDF too; the PDF's charts always use a standard layout. See the report builder for the full tour.

Save, send, and view

Click Save to keep it — it's titled "Refinance Report for" your client by default, and you can rename it in the Theme & title section. Saved reports live on the client's Reports tab and on the Reports page in the sidebar.

Click Send to email it (the button appears once the client has an email address on file). The borrower gets the PDF attached plus a link to the static version, and you're CC'd. The static report link opens the report straight away — there's nothing for the borrower to sign in to or confirm. More in sharing reports with borrowers.

Saved reports of all types count toward your plan's report allowance; Max is unlimited. Details are on the pricing page.