How to use
- Replace the example inputs with your loan and property figures.
- Select Calculate to update the estimate and any schedule.
- Change one assumption at a time, then compare the result with the earlier scenario.
How this calculation works
The worksheet adds origination, settlement, appraisal, recording and transfer charges. Prepaid interest, insurance and the initial escrow deposit are tracked separately. Down payment is then added, and credits plus earnest money already paid are deducted.
Cash to close = down payment + fees + prepaids + escrow − credits − paid deposit
Worked example
Illustrative inputs — not a quote or a local average.
- Cash down payment
- $80,000.00
- Origination charges
- $1,500.00
- Title and settlement
- $1,800.00
- Appraisal fee
- $600.00
- Recording charges
- $150.00
- Transfer taxes
- $800.00
- Prepaid interest
- $700.00
- Prepaid insurance
- $1,800.00
- Initial escrow deposit
- $1,500.00
- Seller and lender credits
- $1,000.00
- Earnest money already paid
- $5,000.00
Estimated remaining cash to close: $82,850.00. Closing fees and transfer taxes: $4,850.00. Prepaids and initial escrow: $4,000.00.
Reading the result
The fee subtotal describes transaction charges. Prepaids and escrow mainly describe payment timing and funds reserved for bills. Separating them helps explain why two quotes with similar lender charges can require different cash at closing. Compare equivalent closing dates when prepaid interest differs.
Before acting on the estimate
Use the actual Loan Estimate and later Closing Disclosure to replace these example amounts. A credit may have program restrictions; the arithmetic does not establish what a lender permits. A deposit should only be deducted if it has already been paid and will be credited at settlement.

Questions, answered
Are these fees typical for my state?
No. Every starting amount is illustrative and should be replaced with a property-specific quote.
Why separate initial escrow from fees?
Escrow is money reserved for bills, rather than simply a lender charge.