Refinance Savings Calculator for Brokers

The form your customers fill out

A live calculator, not a static quote request. Your customer enters their details and watches the number update on the spot, which is what turns a browser into a booked job.

What it calculates

Shows live monthly savings, new payment and break-even month as the homeowner enters current and new terms
Keeps your real Excel refi worksheet: PMT on old and new loans, closing-cost rollup and break-even logic
Captures each homeowner as a warm lead with balance, current rate and projected savings already calculated
Update target rates, closing-cost assumptions or cash-out rules later just by asking Claude
Backtest against past refis so the savings you advertise match deals you actually closed

Why it closes more deals

⚡

A live number closes deals

Customers who see a real estimate the second they enter their details are far likelier to book than ones told to call for a quote. The number is the hook.

📊

Runs your most complex spreadsheet

Multi-tab workbooks, lookup tables, tiered rates, conditional line items, the lot. If the math runs in Excel, CalcForms runs it behind a clean form.

🔁

Update it by chatting

Prices move. Ask Claude to change a rate, add an option, or insert a step and the live form updates in seconds. No developer, no redeploy.

🎯

Backtest before you publish

Run your last 20 real jobs through it and tune the formula until the live estimate matches what you actually charge. Ship it once it lines up.

How this form was built

No template builder and no code. One message to Claude with the CalcForms connector switched on:

✦ Claude with the CalcForms connector

Build a refinance savings calculator from my refi worksheet. Run PMT on the current loan and on a new 30-year loan at the new rate, show the monthly savings, then divide closing costs by monthly savings for the break-even month. Flag when break-even is under 24 months.

Done. I built Refinance Savings Calculator with your pricing and deployed it to forms.badabingapp.cc. The math runs server-side and every submission is saved with the inputs and email. Want to add a field or change a rate? Just tell me.

Build this exact form

CalcForms is a connector you add to Claude once. After that you build and edit forms just by chatting.

Add CalcForms to Claude. Open the Add custom connector dialog, name it Calcforms, and paste https://forms.badabingapp.cc. One time, about 60 seconds.
Paste the prompt below. Claude builds the form, wires in your math, and hands you a live URL.
Share it, then tweak by chatting. Put it on your site or send the link. Change a rate or add a field later just by asking.

Copy this prompt into Claude

"Build a refinance savings calculator from my refi worksheet. Run PMT on the current loan and on a new 30-year loan at the new rate, show the monthly savings, then divide closing costs by monthly savings for the break-even month. Flag when break-even is under 24 months."

Example run: A homeowner with 320,000 dollars left at 7.25 percent enters a new rate of 6.125 percent and 6,500 dollars in costs. The form shows about 245 dollars saved per month and a 27-month break-even, then sends you the lead with balance and savings attached.

New to connectors? A connector (an MCP server) is a secure link between Claude and an app. The CalcForms connector lets Claude build, deploy, and update real calculator forms for you, all from the chat window.

Formulas it supports

Current payment: PMT(current_rate/12, years_left*12, -balance)
New payment: PMT(new_rate/12, 360, -(balance + rolled_costs))
Monthly savings: current_payment - new_payment
Break-even month: closing_costs / monthly_savings
Lifetime interest saved: (current_payment * years_left*12) - (new_payment * 360)

FAQ

Does it show the break-even point, not just the new payment?

Yes. It divides closing costs by monthly savings to show the break-even month, so the homeowner sees exactly when the refi starts paying off.

Can it handle rolling closing costs into the loan?

Yes. Your worksheet logic carries over, so costs can be added to the new balance or paid out of pocket, whichever your scenario uses, and the payment updates live.

Can I tweak the assumptions as rates fall?

Ask Claude to update target rates or cost assumptions and the live calculator changes instantly, so your funnel always reflects current market rates.

Build yours in the next 10 minutes.

Your first form is free. No credit card.

Start free →