On these stated assumptions, refinancing from 8% to 6.5% comes out about $34,108 ahead over a 7-year stay after $6,000 of closing costs.
The widest gap in this set. This is where big drops make refinancing tempting, and where the term restart does the most quiet damage if you compare lifetime interest instead of the payment.
The stated example
Inputs: $400,000 balance, 27 years left, new 30-year term, $6,000 of closing costs, 7-year stay.
Measure
Stay at 8%
Refinance to 6.5%
Monthly principal and interest
$3,017
$2,528
Monthly change
$489 less per month
Break-even on closing costs
Month 13
Interest over a 7-year stay
$214,148
$174,040 plus $6,000 costs
Net over the stay
$34,108 ahead by refinancing
Lifetime interest if held to term
$61,369 less with the refinance after costs
What drives this particular drop
A 1.5 point drop on $400,000 changes the payment by $489 a month before costs, against $6,000 of fees, so the fees are repaid in month 13.