Ideal Home Worksheet

Are You In Your Ideal Home?

Equity-to-Purchase Analysis · Multi-Scenario Modeling

A consumer-facing residential mortgage analysis tool that compares the financial implications of remaining in your current property against one or more alternative purchase scenarios. Calculate disposable equity, target down payment, principal-and-interest obligations, and full PITI housing payments against your stated affordability ceiling.

JJ Mazzo · Executive Vice President · NMLS 186548
Residential Affordability Modeling

Compare Multiple Scenarios. Find Your Ideal Home.

Enter your current property and household debt profile once, then build one or more ideal-home purchase scenarios to compare side by side. All calculations update in real time and are illustrative only — not a Loan Estimate, pre-approval, or commitment to lend under TILA-RESPA (Regulation Z) or any other federal disclosure requirement.

Inside the Playbook
  • Homeowner & Renter Conversation Scripts
  • The "Two Ponds" Prospecting Strategy
  • Real-Time Ideal-Home Math
  • Handling the Results — Objection Frames
  • 6-Step Execution Playbook
  • Free Co-Branded Marketing Resources
Scan For The Calculator
QR code — Ideal Home Calculator (lead-gated)
Ideal Home Calculator
1

Affordability Ceiling & Household Debt Profile

State the maximum monthly housing payment (PITI) you are comfortable carrying and disclose total monthly non-housing debt obligations. This establishes the qualifying benchmark against which each scenario is evaluated.

$
Target maximum monthly PITI (principal, interest, taxes & insurance).
$
Auto loans, revolving credit, student loans, installment debt — used for DTI awareness.
2

Current Home — Disposition & Equity Position

Project net equity available from the sale of your current primary residence after seller-paid closing costs (estimated at 7% of gross sale price, inclusive of commissions, title, escrow, transfer fees and customary credits) and retirement of the existing first-lien mortgage.

$
Anticipated gross sale price (CMA, recent appraisal, or AVM).
%
Default 7% — commissions, title, escrow, transfer taxes & staging.
$
Unpaid principal balance on existing first-lien plus any HELOC / second lien.
Estimated Selling Costs
$0
Mortgage Payoff
$0
Equity From Current Home
$0
3

Ideal-Home Purchase Scenarios

Build and compare multiple replacement-property scenarios. Adjust the contract price, note rate, amortization term, and escrowed taxes & insurance for each. The model uses standard fully-amortizing PMT methodology and assumes a fixed-rate, fully-disclosed conventional purchase loan.

4

Scenario Comparison & Affordability Assessment

Side-by-side analysis of each ideal-home scenario against your stated monthly affordability ceiling. Scenarios flagged "Within Limit" project a total PITI at or below your ceiling; "Over Limit" scenarios exceed it and may require purchase-price, down-payment, or rate-strategy adjustment.

Audit-Compliant Considerations

  • Total PITI should be evaluated against gross monthly income; conventional underwriting commonly targets a 43% maximum back-end DTI (28% front-end housing ratio guidance per FHFA / GSE conventional loan parameters).
  • Estimated selling costs at 7% are a market-average placeholder; actual costs vary by jurisdiction, brokerage agreement, and recording fees, and should be confirmed by your listing agent and escrow officer.
  • This worksheet excludes private mortgage insurance (PMI), HOA dues, mortgage insurance premiums (MIP), Mello-Roos or special assessments, and supplemental property tax bills — itemize separately for an accurate qualifying payment.
  • Loan amounts above conforming loan limits trigger jumbo pricing, tighter reserve requirements, and stricter qualifying ratios.

Recommended Next Steps

  • Schedule a full loan consultation to convert these projections into a Loan Estimate (TILA-RESPA Integrated Disclosure) within three business days of a complete application.
  • Pull tri-merge credit, document income and assets, and request a pre-approval with verified credit, capacity, and collateral assumptions.
  • Coordinate with a licensed real estate professional for a current comparative market analysis on both the disposition and replacement properties.
  • Confirm tax deductibility of mortgage interest and property taxes with a licensed CPA — eligibility depends on filing status, itemization, and the §163(h)(3) qualified residence indebtedness cap.
Audited Disclosure & Compliance Notice

This worksheet is for illustrative and educational purposes only. It is not a Loan Estimate, Closing Disclosure, pre-qualification, conditional approval, or commitment to lend. No application has been taken, no credit has been pulled, and no underwriting decision has been rendered. Figures are based entirely on user-provided inputs and standard fully-amortizing payment math.

All loans are subject to underwriting approval. All borrowers must meet minimum credit score, loan-to-value (LTV), debt-to-income (DTI), reserve, employment, and program-specific requirements to qualify for any mortgage product. Rates, fees, and program availability are subject to change without notice and may vary based on credit profile, occupancy, property type, and market conditions. Certain restrictions apply — contact JJ Mazzo for current eligibility details.

JJ Mazzo · NMLS 186548 · Mazzo Group of CrossCountry Mortgage, LLC · NMLS 3029 · 31351 Rancho Viejo Road, Suite 204, San Juan Capistrano, CA 92675. Licensed to do business in AZ, CA, OR, WA. Equal Housing Opportunity Lender. Verify state licensing at www.nmlsconsumeraccess.org.

Next Steps

Convert Your Analysis. Speak With a Licensed Advisor.

These projections are most accurate when reviewed alongside a current credit profile, verified income, and a property valuation. Contact the Mazzo Group to convert this worksheet into a fully underwritten loan strategy with rate-lock options.

Equal Housing Opportunity. All loans subject to underwriting approval. Certain restrictions apply — call for details. All borrowers must meet minimum credit score, loan-to-value, debt-to-income, and other requirements to qualify for any mortgage program. This communication is for illustrative purposes only and is not a Loan Estimate, commitment to lend, or interest-rate lock. CrossCountry Mortgage, LLC · NMLS 3029 (www.nmlsconsumeraccess.org). JJ Mazzo · Executive Vice President · NMLS 186548. 31351 Rancho Viejo Road, Suite 204, San Juan Capistrano, CA 92675. Licensed in AZ, CA, OR, WA.

Mazzo Group CrossCountry Mortgage