What the Refinance Analysis Builder actually produces

MORTGAGE REFINANCE ANALYSIS Borrower: [Name — not supplied] Property Address: [Address — not supplied] Property Value: $595,000 (recent appraisal) Analysis Date: [Current date] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ CURRENT LOAN PROFILE: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Loan Type: 30-year Fixed Original Loan Amount: [Not supplied — inferred from balance and remaining term] Current Loan Balance: $412,000 Interest Rate: 7.25% Remaining Amortization: 22 years (264 months remaining) Current Monthly P&I: $2,813 Current LTV Calculation: LTV = Balance / Property Value = $412,000 / $595,000 = 69.2% [Verify appraisal and assessed value for accuracy] Current Annual Interest Cost (Year 1, est.): $2,813 × 12 = $33,756 [Exact annual interest depends on current amortization schedule — verify] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ PROPOSED REFINANCE LOAN PROFILE: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Loan Type: 30-year Fixed Proposed Loan Amount: $415,000 (Current balance $412,000 + $25,000 cash-out for kitchen renovation – $22,000 financed closing costs [verify exact financed amount]) [NOTE: If closing costs are paid out-of-pocket, proposed principal = $437,000] Interest Rate: 6.375% New Loan Term: 30 years (360 months) Estimated Closing Costs: $6,800 Proposed Monthly P&I: $2,478 (calculated for $415,000 at 6.375% over 30 years) [If closing costs are financed: Proposed principal = $415,000 + $6,800 = $421,800 Monthly P&I = $2,514 — verify with exact financed amount] Proposed LTV Calculation: LTV = $415,000 / $595,000 = 69.7% (or $421,800 / $595,000 = 70.8% if costs financed) [At this LTV, PMI is not typically required; verify current PMI rules and lender policy] Proposed Annual Interest Cost (Year 1, est.): $2,478 × 12 = $29,736 [Verify against amortization schedule] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ MONTH-BY-MONTH COMPARISON (P&I ONLY): ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ CURRENT (7.25%) PROPOSED (6.375%) MONTHLY SAVINGS ─────────────── ───────────────── ────────────── Monthly P&I: $2,813 $2,478 $335 [NOTE: Savings assumes no change in property tax, insurance, or HOA. Verify with full payment estimate including taxes, insurance, and escrow.] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ CASH-OUT ANALYSIS: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Renovation Loan Amount: $25,000 Funding Source: Cash-out from refinance (financed into new loan) Use: Kitchen renovation Cash-out Percentage: $25,000 / $415,000 = 6.0% of new loan Cash-out considerations: — Cash-out refinances typically carry slightly higher rates than rate-and-term refi [Verify if proposed 6.375% already reflects cash-out adjustment] — Borrower is financing the renovation cost, so the $25,000 is added to the new loan balance, increasing total debt — Renovation must meet lender's improvement standards (verify with lender) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ TOTAL INTEREST COMPARISON (ESTIMATE — VERIFY WITH TESTED CALCULATOR): ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Remaining interest on current loan (22 years at $2,813/mo, 7.25%): Estimated total remaining interest: ~$328,000 – $360,000 [Verify exact figure from current amortization schedule] Total interest on proposed loan (30 years at $2,478/mo, 6.375% on $415,000): Estimated total interest: ~$477,000 – $510,000 over 30 years [Verification required: This is the total interest over the FULL 30-year term, not a direct comparison since the term extends 8 years beyond the current loan.] ⚠️ CRITICAL NOTE ON "TOTAL SAVINGS": Direct comparison of total interest is misleading because: — Current loan: 22 years remaining (264 months) — Proposed loan: 30 years (360 months) — The proposed loan extends the payoff by 8 years, which increases total interest To fairly compare, use one of two methods: A) Compare total amount paid (principal + interest) in the same timeframe (e.g., compare both loans over a 22-year period) B) Calculate interest savings by amortization year and assess payoff date [Calculate exact comparison using tested mortgage calculator — do not assert total savings figures without verified input.] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ BREAK-EVEN ANALYSIS (ROUGH FRAMEWORK — VERIFY): ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Closing costs on refinance: $6,800 Monthly P&I savings: $335 Break-even calculation (rough): Break-even months = $6,800 / $335 = ~20 months Interpretation: If the borrower remains in the home for 20+ months, the monthly savings will recoup the closing costs paid. After 20 months, the refinance is cash-positive. ⚠️ This assumes: — No change in property tax, insurance, or escrow costs — Closing costs of exactly $6,800 (verify in Loan Estimate) — No prepayment penalties on current loan (verify current loan terms) — Borrower does NOT pay off the loan early (paying off early extends break-even) Given the borrower's stated goal of staying 7+ years, the 20-month break-even is easily achieved. [Verify break-even using exact Loan Estimate figures, including: — Actual APR on both loans — Any change in property tax, insurance, or escrow — Any prepayment penalties — Exact closing costs to be financed vs. paid from pocket] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ VERIFICATION CHECKLIST (MUST COMPLETE BEFORE FINAL RECOMMENDATION): ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ □ Exact APR on both current and proposed loans (not just rate) □ Actual closing costs to be financed vs. paid from pocket □ Prepayment penalty status on current loan (if any) □ PMI/MIP status on proposed loan (verify LTV-based requirement) □ Property tax, homeowners insurance, and escrow changes (if any) □ Confirmation that cash-out for renovation is permitted per lender guidelines □ Exact amortization schedules for both loans □ Current and proposed loan program details (conforming, jumbo, FHA, VA, etc.) [verify against current FHA MIP rates or PMI rules — these change] □ Remaining balance on current loan (confirm $412,000) □ Recent property appraisal ($595,000 confirmed)

REFINANCE SAVINGS SUMMARY ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ MONTHLY PAYMENT SAVINGS: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Current Monthly P&I: $2,813 Proposed Monthly P&I: $2,478 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Monthly Savings: $335 Annual Savings (P&I): $335 × 12 = $4,020 [NOTE: This is principal & interest only. Total monthly payment includes property tax, insurance, and escrow. Verify full payment change in Loan Estimate.] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ CLOSING COSTS & BREAK-EVEN: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Estimated Closing Costs: $6,800 Monthly Savings: $335 Break-Even Period: $6,800 ÷ $335 = ~20 months Interpretation: After 20 months (approximately June 2027), the monthly savings will have recouped the closing costs. Any additional months beyond the break-even point represent net savings. Borrower's Holding Period: 7+ years (84+ months) Net Savings Over 7 Years: ($335 × 84 months) – $6,800 = $21,340 [ESTIMATE — verify with actual Loan Estimate and tested calculator] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ TOTAL INTEREST COMPARISON (FRAMEWORK): ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⚠️ IMPORTANT: The two loans have different remaining terms, so a direct "total interest" comparison is misleading. Instead, use this framework: SCENARIO A: Borrower pays off CURRENT loan over remaining 22 years Remaining interest cost: ~$328,000–$360,000 [Verify from current amortization schedule] SCENARIO B: Borrower refinances and pays off in 22 years (early payoff) Refinance for 30 years, but pay off in 22 years Interest cost in first 22 years: ~$310,000–$340,000 [Verify with tested calculator using early-payoff amortization] Difference: ~$18,000–$50,000 in interest savings over 22 years [Estimate — verify with exact calculator] SCENARIO C: Borrower refinances and pays over full 30 years Total interest cost: ~$477,000–$510,000 (30-year full amortization) [This is HIGHER total interest because the loan extends 8 years.] This scenario is appropriate only if the borrower wants the lower monthly payment and does not plan to accelerate payoff. ⚠️ Choose the scenario that matches your goals and cash flow situation. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ CASH-OUT BENEFIT: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Kitchen Renovation Funding: $25,000 (financed into new loan) Annual Interest Cost for $25K: ~$1,594 per year at 6.375% [This is the cost of financing the renovation.] If paid from savings instead: Savings foregone: Interest/investment returns on $25,000 [Consider opportunity cost of using cash reserves.] ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ BOTTOM-LINE SAVINGS: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Monthly Payment Savings: $335 per month Break-Even Period: ~20 months Estimated 7-Year Net Savings: ~$21,340 [This assumes the borrower pays according to the loan term and does not accelerate payoff. Savings reduced if property taxes or insurance increase.] Cash-Out Benefit: $25,000 for home renovation at 6.375% financing Critical Conditions: ✓ Borrower staying 7+ years (goal aligns with break-even) ✓ Low closing costs ($6,800) relative to monthly savings ✓ Rate reduction (7.25% → 6.375%) improves cash flow ✓ Lower LTV (69.2%) removes PMI risk ✓ Kitchen renovation adds home value (verify ROI) All figures labeled "ESTIMATE — verify in Loan Estimate and with tested calculator."

PROFESSIONAL REFINANCE RECOMMENDATION ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ RECOMMENDATION: PROCEED WITH REFINANCE ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Based on the supplied profile and figures, the proposed refinance aligns well with your stated goals and financial situation. Here's why: ✓ STRONG RATE IMPROVEMENT Current rate (7.25%) → Proposed rate (6.375%) = 0.875% reduction This is a meaningful rate cut that improves your cash flow immediately. ✓ MONTHLY SAVINGS ARE SUBSTANTIAL Monthly P&I savings: $335 ($4,020/year) Break-even period: ~20 months Your 7+ year holding period far exceeds break-even, so the refinance is cash-positive well before you sell or move. ✓ CLOSING COSTS ARE REASONABLE $6,800 in closing costs is ~1.6% of the new loan amount — within typical range for refinances. The monthly savings ($335) quickly pay this down. ✓ FAVORABLE LOAN-TO-VALUE LTV: 69.2% (at $412K balance) or 69.7% (with $25K cash-out) At this LTV, you avoid PMI and maintain strong equity position in the home. ✓ CASH-OUT SUPPORTS YOUR RENOVATION GOAL Kitchen renovation funding ($25,000) is financed at the lower 6.375% rate, which is cheaper than using credit cards or home equity lines (typically 8–12%). Kitchen improvements often add value to the home (typically 50–80% ROI). [Verify that the proposed renovation ROI supports the cash-out decision.] ✓ PAYMENT REDUCTION IMPROVES CASH FLOW Lower monthly payment gives you breathing room for the renovation process and ongoing home maintenance. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ CRITICAL CONDITIONS FOR THIS RECOMMENDATION: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Before signing, confirm the following via your Loan Estimate: 1. APR Verification Confirm the exact APR on the proposed 30-year loan is 6.375% (or within 0.05% of this rate). 2. Closing Costs & Financing Verify that: — Closing costs are exactly $6,800 (or explain any variance) — You understand whether costs are paid from pocket or financed into the loan — If financed, confirm the new loan balance ($415,000 + $6,800 = $421,800) and the resulting monthly payment ($2,514 instead of $2,478) 3. Property Tax & Insurance Confirm whether property tax or homeowners insurance rates have changed. If so, recalculate your total monthly payment change (not just P&I). 4. Prepayment Penalty on Current Loan Verify that your current 30-year fixed loan has NO prepayment penalty. (Most do not, but confirm.) 5. Home Renovation Plan Confirm that your kitchen renovation budget is realistic at $25,000 and that the planned improvements will add value to the home. 6. Rate Lock & Timing Lock your rate as soon as the Loan Estimate is confirmed to protect against rate fluctuations during processing (typically 30–45 days). ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ NEXT STEPS: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1. Request full Loan Estimate from your lender (CFPB-required disclosure) 2. Review and compare the current loan vs. proposed loan side-by-side 3. Verify all closing costs and confirm financing/payment method 4. Order property appraisal (required, typically 5–10 days) 5. Order title search and insurance commitment (required, typically 5–10 days) 6. Lock your rate once Loan Estimate is confirmed 7. Coordinate renovation contractor and timeline to align with cash-out funding 8. Submit all required documentation (income verification, recent pay stubs, 2 months bank statements) to speed underwriting 9. Work with lender on appraisal and title contingencies (typically resolved within 10–14 days) 10. Receive "clear to close" approval and schedule closing (typically 5–10 days after final underwriting) Total estimated timeline: 30–45 days from application to closing. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ WARNING SIGNS (Do NOT proceed if any of these apply): ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⚠️ Do NOT refinance if: — You plan to sell or move within 20 months (break-even period) — Your credit score has dropped significantly since original loan — You have recent late payments or missed payments — Your income is unstable or employment is at risk — You cannot afford the $6,800 in closing costs — Your kitchen renovation budget is uncertain (cash-out may not be justified) — Property value has declined below $595,000 (LTV would increase) — Current loan has a prepayment penalty that exceeds your savings If any of these apply, contact me to discuss alternatives. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ CONCLUSION: ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ The refinance is financially sound and aligns with your goals: • $335/month payment reduction improves cash flow • 7+ year holding period ensures the refinance pays for itself • $25,000 cash-out for renovation at a favorable rate • Low LTV (69%) protects your equity and avoids PMI Proceeding makes sense. Next step: Request and review the official Loan Estimate to confirm all terms before committing.