Skip to content
eEveryday
Today—

Home closing-cost planner — sensitivity table

Estimate buyer cash to close from down payment, fees, credits and prepaid items. Build a multi-point table showing how purchase price changes the main result.

Five planning modes, one calculator topic

These modes share an underlying model, not five unrelated formulas. This advanced mode is excluded from search indexing. Visit the main home closing-cost planner calculator for the topic overview.

Planning mode: Build a multi-point table showing how purchase price changes the main result. Adjust the inputs to fit your situation. Related tools share an underlying model, with distinct calculation, reverse-solve, comparison and sensitivity functions.

Your numbers

$
$
points
%
%
$
$
$

Sensitivity analysis

5 comparison points

Purchase price ranges from $200,000 to $600,000.

Purchase price: $200,000
$32,000
Purchase price: $300,000
$50,000
Purchase price: $400,000
$68,000
Purchase price: $500,000
$86,000
Purchase price: $600,000
$104,000
Baseline — Down payment
$60,000
Baseline — Estimated closing costs
$12,000
Baseline — Prepaid escrow and insurance
$3,500
Baseline — Credits
−$2,500
Baseline — Deposit already paid
−$5,000

Assumptions to check

  • Use your final closing disclosure for actual amounts.

How this is calculated

Evaluate the model at evenly spaced input values, rounded to the allowed input step. Down payment + closing costs + prepaid items − credits − funds already paid.
  1. 1Keep all other model inputs constant.
  2. 2Each row reports the same headline measure, not a separate forecast.

Assumptions and limits

  • Closing disclosure, local transfer taxes, lender fees and escrow requirements determine actual cash due.
  • Use your final closing disclosure for actual amounts.

Practical guide

Understanding home closing-cost planner — sensitivity table

Everyday editorial team · GEOINNOVATION CO., LTD · Published · Updated

What this calculation is for

Cash to close is different from both the home’s purchase price and its monthly payment. A purchase can fit the payment budget while still requiring more upfront cash than the buyer has available.

How the method works

The model adds down payment, percentage-based closing fees and named prepaids, then subtracts entered credits and earnest money already paid. A prior deposit reduces the remaining cash due rather than the total economic purchase cost. The displayed model uses: Cash to close = down payment + estimated fees + prepaid items − credits − deposit already paid.

A worked example

For an illustrative home closing-cost planner scenario, use Purchase price: 400000 $; Down payment: 15 %; Closing-cost estimate: 3 %; Seller or lender credits: 2500 $; Prepaid tax, insurance and escrow: 3500 $; Earnest-money deposit already paid: 5000 $. The modeled estimated cash to close is $68,000. These are example assumptions, not current prices, official benefit amounts or personalized advice.

Assumptions and real-world differences

Actual credits can be limited by the loan program, and prepaid taxes or insurance may overlap a quoted fee estimate. Use the lender’s current disclosure and verify that each cost is counted once. Closing disclosure, local transfer taxes, lender fees and escrow requirements determine actual cash due.

Reading the purchase price sensitivity table

The tool evaluates the same model across a range of purchase price values while holding other assumptions constant. Choose a realistic low value, high value and number of points. Each row reports the same headline measure; the table is a set of conditional calculations, not a probability distribution or a forecast. Input-step rounding can make nearby rows equal.

Reproduce this tool’s example

These fixed example inputs are independent of edits you make above. Enter them in this tool to reproduce the result, then replace them with your own assumptions.

Minimum purchase price
200,000 $
Maximum purchase price
600,000 $
Number of comparison points
5 points
Down payment
15 %
Closing-cost estimate
3 %
Seller or lender credits
2,500 $
Prepaid tax, insurance and escrow
3,500 $
Earnest-money deposit already paid
5,000 $

Sensitivity analysis: 5 comparison points

Purchase price ranges from $200,000 to $600,000.

  • Purchase price: $200,000: $32,000
  • Purchase price: $300,000: $50,000
  • Purchase price: $400,000: $68,000

Frequently asked questions

Does earnest money eliminate part of the down payment?
It generally contributes toward transaction cash already paid; the tool treats it as a credit against the remaining amount.
Which inputs should I check before using this home closing-cost planner estimate?
Check purchase price, down payment, closing-cost estimate, seller or lender credits, prepaid tax, insurance and escrow, earnest-money deposit already paid. Match each field’s unit and time period, then compare the detailed rows rather than treating the headline alone as the complete answer.
Does the most favorable row show the most likely outcome?
No. The table assigns no likelihood to any row. It shows how the result responds to the chosen assumption, and you remain responsible for selecting a plausible range.

More in Home buying

View all 25 in Home buying →