⚡ Promptolis Original · Money & Finance
💳 Mortgage Loan Comparison Optimizer
Mortgage comparison grounded in APR-vs-rate math, points break-even analysis, total-cost-over-hold-period framework — shop 3-5 lenders + save $30-60K over loan lifetime.
Why this is epic
Mortgage is the biggest loan most people ever take. A 0.125% rate difference = $10-20K over 30-year term. A 0.5% difference = $40-60K. Yet most borrowers accept the first lender's offer without shopping. This optimizer trains proper comparison methodology in 15 minutes.
APR-based comparison (not rate-based). APR bakes in fees + points, making lender offers comparable apples-to-apples. Most borrowers compare rates and miss that 'lower rate + higher fees' often costs more than 'higher rate + lower fees'.
Points break-even math: points cost / monthly rate savings = break-even months. If longer than your expected hold, points are waste. Most borrowers pay points without running this math — this tool prevents it.
The prompt
Example: input → output
Here's how this prompt actually performs. Real input below, real output from Claude Opus 4.
Scenario: First home purchase Loan amount: $400,000 Down payment: 10% ($40K) on $440K home Credit score: 760 Loan options: - Lender A: 30yr fixed, 7.125%, APR 7.28%, $4,200 fees, no points - Lender B: 30yr fixed, 6.875%, APR 7.15%, $5,800 fees, 0.5 points ($2,000) - Lender C: 30yr fixed, 7.0%, APR 7.12%, $3,500 fees, no points - Lender D: 15yr fixed, 6.25%, APR 6.45%, $4,000 fees Time horizon: 7-10 years expected in home Debt-to-income: 36% Analyze.
Your Mortgage Comparison Analysis — $400K First Purchase
Loan Option Comparison Table
| Lender A | Lender B | Lender C | Lender D (15yr) | |
|---|---|---|---|---|
| Rate | 7.125% | 6.875% | 7.0% | 6.25% |
| APR | 7.28% | 7.15% | 7.12% | 6.45% |
| Fees | $4,200 | $5,800 | $3,500 | $4,000 |
| Points | None | 0.5 ($2K) | None | None |
| Monthly P&I | $2,694 | $2,627 | $2,661 | $3,432 |
| Monthly diff vs A | baseline | -$67 | -$33 | +$738 |
Lender C has the lowest APR for 30-year options (7.12%). Lender D (15yr) has lowest APR overall (6.45%) but $738/month higher payment.
Total Cost Analysis Over Your Hold Period (7-10 years)
Lender A (7.125%, $4,200 fees, no points)
- Year 1 payments (12 × $2,694): $32,328 total
- Year 7 interest paid cumulatively: ~$175,000
- Year 10 interest paid cumulatively: ~$243,000
- Fees at close: $4,200
- Total cost 10 years: $247,200
Lender B (6.875%, $5,800 fees, 0.5 points $2,000)
- Year 1 payments: $31,524 total
- Year 7 interest cumulative: ~$168,000
- Year 10 interest cumulative: ~$233,000
- Fees + points at close: $7,800
- Total cost 10 years: $240,800
Lender C (7.0%, $3,500 fees, no points) ⭐
- Year 1 payments: $31,932 total
- Year 7 interest cumulative: ~$172,000
- Year 10 interest cumulative: ~$239,000
- Fees at close: $3,500
- Total cost 10 years: $242,500
Lender D (6.25% 15yr, $4,000 fees)
- Year 1 payments: $41,184 total
- Year 7 interest cumulative: ~$119,000
- Year 10 interest cumulative: ~$151,000
- Total interest over 15 years: ~$217,000
- Fees at close: $4,000
- Total cost 15 years: $221,000
- Savings vs 30yr over 15 years: ~$25-30K
Best Fit for Your Situation
If monthly cash flow constrained (most borrowers):
Lender C is best. Lowest APR among 30-year options, lowest fees, no points to break even on. Clean deal.
If you have strong monthly cash flow ($3,432/mo comfortable):
Lender D (15yr) is mathematically best. Save $25-30K in interest. Build equity 2x faster. But requires disciplined cash flow + emergency reserves.
What about Lender B (6.875% with points)?
Break-even: points cost $2,000 / monthly savings of $67 vs Lender A = 30 months. You expect 7-10 years, so break-even IS achievable. But compared to Lender C (lower APR + lower fees), Lender B requires upfront cash for no significant long-term benefit over Lender C.
The Verdict
For 10-year hold at 10% down, moderate cash flow: Lender C
For aggressive debt payoff + wealth building, strong cash flow: Lender D
Don't choose: Lender A (highest APR among options) or Lender B (higher fees without meaningful APR advantage)
Points Break-Even Analysis (for Lender B)
Points cost: $2,000 (0.5 points = $2,000 on $400K loan)
Monthly savings vs Lender A: $67
Break-even months: 2,000 / 67 = 30 months (2.5 years)
Your expected hold: 7-10 years.
Break-even achievable — you'd save $67/month for ~4.5-7.5 years AFTER break-even. Total advantage over Lender A: $3,000-6,000.
But Lender C (without points) is cheaper overall than Lender B. So points here = no advantage unless Lender C weren't available.
General rule: Only pay points if you're 95%+ confident you'll hold past break-even AND no better rate available without points.
Red Flags in Offers
Check each offer for:
1. Prepayment penalty (ask explicitly: 'Is there any prepayment penalty on this loan for the first 5 years?')
2. Escrow waiver fees (some lenders charge $500-1,500 to waive escrow — usually not worth it)
3. Mortgage broker fees vs lender fees (broker fees are separate; ensure quotes include EVERYTHING)
4. Rate lock expiration (30 / 45 / 60 days — longer locks cost more but protect you)
5. Origination fee (typical 0.5-1%; >1% = shop harder)
6. Discount points already baked into 'rate' (some lenders quote low rate but add 0.5-1 point of discount not in 'fees' line — make them show it explicitly)
None of your 4 quotes obviously have these red flags, but VERIFY with each lender in writing.
Questions to Ask Each Lender (Before Choosing)
1. 'What's the all-in APR including every cost?'
2. 'Are there any prepayment penalties? First 3 years? First 5 years?'
3. 'How long is your rate lock?'
4. 'What's your time-to-close commitment?'
5. 'Do you sell the loan to a servicer? If yes, who?'
6. 'What's your origination fee vs broker fees vs third-party fees breakdown?'
Compare the written Loan Estimate (LE) forms — federal law requires a standardized LE document. Don't compare verbally; compare documents.
Negotiation Leverage
You have 4 offers. That's leverage. Tell Lender C (your top pick): 'I have a competitive offer from Lender B at 6.875% with points for $2,000. Can you match or beat APR of 7.12%?'
Typical outcome: Lender C may offer 6.95% with no points, saving another 0.05% — worth ~$6K over 10 years.
Don't leverage weakly: Specifically mention the competitor + the specific rate. Vague 'others offered lower' doesn't motivate.
Key Takeaways
- Your best 30-year option is Lender C (lowest APR 7.12%, lowest fees $3,500, no points complexity).
- Lender D (15yr) saves $25-30K if you can afford $738/mo higher payment.
- Lender B points are marginal — break-even 30 months works but Lender C is simpler + cheaper.
- Lender A is worst — highest APR, skip.
- Use Lender B as negotiation tool against Lender C. Try to drop Lender C to 6.95%.
- Save $30-60K over loan lifetime by shopping 3-5 lenders. Worth 2 hours of comparison.
- Verify prepayment penalties + rate lock in writing with each lender.
- Get Loan Estimate (LE) document from each — federal standardized form, easier to compare.
NOT financial or loan advice. Work with licensed loan officer for actual loan decision. Consider fee-only financial advisor for $400-600 engagement to validate approach on this size purchase — often pays for itself in saved mistakes.
Common use cases
- First-time homebuyers comparing 3-5 lender offers
- Refinance candidates calculating break-even vs current mortgage
- Homeowners deciding 15-year vs 30-year term
- Borrowers evaluating 'buy down rate with points' decisions
- Investment property buyers (higher rates, different economics)
- VA/FHA-eligible borrowers comparing government vs conventional
- Jumbo loan borrowers (>$766K) where lender differences are larger
- Anyone with offers from big bank + credit union + online lender
- Borrowers worried about hidden fees or prepayment penalties
- Anyone making a $300K+ loan decision wanting to verify they're getting best terms
Best AI model for this
Claude Opus 4 or GPT-5 Thinking for multi-lender detailed comparison. Any LLM for basic APR comparison.
Pro tips
- APR > interest rate. APR bakes in fees + points. Compare APRs for apples-to-apples lender comparison.
- Shop 3-5 lenders minimum. 0.125% difference = $10-20K over 30-year term.
- Points break-even: points cost / monthly savings = break-even months. Longer than your hold = waste.
- Get Loan Estimate (LE) form from every lender — federal standardized format, apples-to-apples.
- Ask explicitly about prepayment penalties. Some loans charge 2-5% of principal for refinancing in first 3-5 years.
- Rate lock length matters: 30/45/60/90 days. Longer lock = higher rate but protects during delays.
- 15yr vs 30yr: 15yr saves $100K+ in interest but higher payment. 30yr gives flexibility to prepay voluntarily.
- PMI avoidance at 20% down = effective rate reduction of 0.25-0.75%. Factor in before down payment decision.
- Credit score impact: 760+ prime pricing, 720-759 +0.125-0.25%, 680-719 +0.25-0.5%, below 680 significant penalty.
- Use competing offers as negotiation leverage. 'Lender X offered APR 7.12%, can you match?' works.
Customization tips
- For REFINANCE scenarios, add break-even analysis: closing costs / monthly savings = months until break-even. If break-even longer than your expected hold, don't refinance. Rate drop of 0.5-0.75% from current rate is typical minimum justification.
- For FIRST-TIME BUYERS with <20% down, PMI is a factor. PMI typically 0.5-1.5% annually of loan. If you have 15% down, consider: $400K loan at 0.7% PMI = $2,800/year extra cost until you hit 20% equity. Running math on 6-12 month delay to save more down payment vs. start now with PMI matters.
- For VA LOANS (military/veteran eligible), VA loan typically beats conventional: 0% down, no PMI, typically 0.25-0.5% better rate. VA funding fee 2.3-3.6% of loan replaces PMI but is lower total cost. Compare VA option always if eligible.
- For FHA LOANS (low-down-payment alternative), 3.5% down but PMI is lifetime (not removable at 20% equity like conventional). Usually only better than conventional if <10% down. Otherwise conventional is cheaper.
- For JUMBO LOANS (>conforming limit, typically >$766K), rates often 0.25-0.5% higher than conforming. Jumbo shopping more important — difference between jumbo lenders can be 0.25%+. 5-7 lenders recommended for jumbo.
- For ARM LOANS (adjustable-rate mortgage), compare carefully to fixed. ARM rate savings 0.25-0.5% typically vs fixed. But when ARM resets at year 5-7, rate could rise dramatically. Only worth it if: you're confident you'll sell/refi within reset period AND starting rate differential justifies risk.
- For DSCR or INVESTOR LOANS (rental property purchases), rates typically 0.75-1.5% higher than conventional. Requirements different (property income-based, not personal income). Shop specialized investor lenders, not big banks.
- For CONSTRUCTION LOANS, entirely different product (interest-only during build, converts to permanent at completion). Compare bank-by-bank; terms vary wildly. Usually requires 20-25% down + strong income verification.
- If offered a rate significantly below market (e.g., 2% below current averages), that's a red flag. Either high points being buried, or 'teaser rate' that resets, or lender fees are hidden elsewhere. Demand written APR and Loan Estimate.
- For HIGH-COST MARKETS where 20% down is $150K+, PMI becomes mathematically better than waiting to save. $1,500/year PMI vs $50K market appreciation while you save another 3-5% down — buy now with PMI often wins. Run specific math.
Variants
Purchase Loan (Conventional)
Standard conventional mortgage comparison
Refinance Break-Even
Current mortgage + new offer + break-even analysis
15yr vs 30yr Decision
Monthly affordability vs total interest trade-off
VA Loan Comparison
Military/veteran eligible, 0% down, no PMI analysis
FHA Loan Comparison
3.5% down, lifetime MI consideration
Jumbo Loan (>$766K)
Higher rates, specialized lenders, more shopping required
DSCR / Investor Loan
Rental property financing, 1-1.5% higher rates
Frequently asked questions
How do I use the Mortgage Loan Comparison Optimizer prompt?
Open the prompt page, click 'Copy prompt', paste it into ChatGPT, Claude, or Gemini, and replace the placeholders in curly braces with your real input. The prompt is also launchable directly in each model with one click.
Which AI model works best with Mortgage Loan Comparison Optimizer?
Claude Opus 4 or GPT-5 Thinking for multi-lender detailed comparison. Any LLM for basic APR comparison.
Can I customize the Mortgage Loan Comparison Optimizer prompt for my use case?
Yes — every Promptolis Original is designed to be customized. Key levers: APR > interest rate. APR bakes in fees + points. Compare APRs for apples-to-apples lender comparison.; Shop 3-5 lenders minimum. 0.125% difference = $10-20K over 30-year term.
Explore more Originals
Hand-crafted 2026-grade prompts that actually change how you work.
← All Promptolis Originals