calculate-loan

01 Loan payments

Closing Cost Net Sheet: What It Is & How to Read One

Calculator No. 01-21776 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A closing cost net sheet is a one-page estimate that shows your expected cash to close on a home purchase—what you’ll pay at the closing table after accounting for the purchase price, loan amount, deposits, and all prorated fees. You enter the sale price, loan terms, and estimated fees, and the sheet nets them into a single dollar figure you need to bring. This article explains how to build and read one, what each line means, and where the numbers come from.

Formula

The cash-to-close formula is straightforward arithmetic:

Cash to Close = Purchase Price − Loan Amount + Closing Costs + Prorated Taxes & Prepaids − Earnest Money Deposit

  • Purchase price (p) – the agreed sale price in dollars.
  • Loan amount (l) – the mortgage principal, usually purchase price minus down payment.
  • Closing costs (e) – lender fees, title insurance, appraisal, recording, and other settlement charges.
  • Prorated taxes & prepaids (t) – property taxes, homeowners insurance, and interest paid in advance, prorated to the closing date.
  • Earnest money deposit (dep) – the deposit you already paid when the offer was accepted; it reduces the cash you bring at closing.

All values are in dollars. The formula assumes the down payment is already reflected in the loan amount—if you enter both, the loan amount should equal price minus down payment, but the calculator doesn’t enforce that; it simply nets what you type.

Worked Example

Using the defaults from the calculator above:

  1. Purchase price = $300,000
  2. Loan amount = $240,000 (20% down)
  3. Closing costs = $8,000
  4. Prorated taxes & prepaids = $2,500
  5. Earnest money deposit = $5,000

Cash to close = 300,000 − 240,000 + 8,000 + 2,500 − 5,000 = $65,500.

That’s the amount you’d need to bring to closing, usually as a wire transfer or cashier’s check. The down payment portion is $60,000, plus $10,500 in fees and prepaids, minus the $5,000 you already put down.

Assumptions

  • The loan amount is fixed and the down payment is not separately added—it’s embedded in the loan amount.
  • Closing costs and prepaids are estimates; the final figures come from the Closing Disclosure.
  • No seller concessions, lender credits, or points are included unless you add them to the costs or subtract them from the loan.
  • The earnest money deposit is assumed already paid; if you haven’t paid it yet, enter 0.

This is estimate arithmetic for education, not financial advice. Your lender’s official Closing Disclosure gives the exact, legally binding numbers.

Why a Net Sheet Matters

A net sheet is the first realistic look at how much cash you need on closing day. Many buyers focus only on the down payment and are surprised by the additional thousands in fees and prepaids. The net sheet forces you to see the total upfront cost before you’re deep into the contract.

It also helps you compare offers. If two lenders quote the same interest rate but one has higher origination fees, the net sheet shows the difference in cash required. You can use it to decide whether to negotiate seller concessions or ask the lender to lower fees.

Real estate agents often provide a net sheet early in the process, but the numbers are rough until the lender issues a Loan Estimate. The final version appears on the Closing Disclosure, which you receive at least three business days before closing.

Common Mistakes on a Net Sheet

  • Forgetting the earnest money – if you already paid $5,000, that’s not extra cash you need; it’s already in the deal.
  • Double-counting the down payment – if you enter the loan amount as the price minus down payment, don’t also add the down payment separately.
  • Ignoring prepaids – property taxes and insurance for the first year are often due at closing, not just the monthly payment.
  • Using the list price instead of the contract price – if you negotiated a lower price, use that number.
  • Assuming the seller pays all closing costs – that’s a negotiation point, not a default; if the seller contributes, subtract that amount from your costs.

Net Sheet vs. Loan Estimate vs. Closing Disclosure

These three documents serve different purposes:

  • Net sheet – a quick, informal estimate, often created by an agent or buyer, using best guesses for fees.
  • Loan Estimate – a standardized three-page form from the lender within three days of your application, with itemized costs and a clear cash-to-close figure.
  • Closing Disclosure – the final, legally binding document you receive three days before closing; it must match the Loan Estimate within certain tolerances.

The net sheet is useful for planning and budgeting, but the Loan Estimate and Closing Disclosure are the documents that actually govern the transaction. If the Closing Disclosure differs significantly from the net sheet, ask your lender why.

How to Get Accurate Numbers for Your Net Sheet

To make a net sheet as accurate as possible, gather these from your lender and agent:

  • Loan amount – from your pre-approval or loan application.
  • Origination fee – lender charges for processing the loan.
  • Title insurance – lender’s policy and optional owner’s policy; costs vary by state and price.
  • Appraisal fee – usually $300–$600, but can be higher.
  • Recording fee – county fee to record the deed and mortgage.
  • Property taxes – prorated from the closing date to the end of the tax year.
  • Homeowners insurance – first year’s premium is often due at closing.
  • Prepaid interest – daily interest from closing to your first mortgage payment.

Your lender is required to give you a Loan Estimate with these items, so you can use that document to fill in the net sheet with real numbers.

Frequently Asked Questions

What’s the difference between cash to close and closing costs?

Closing costs are the fees and prepaids you pay to finalize the loan—lender charges, title insurance, appraisal, taxes, and insurance. Cash to close is the total amount you must bring to closing, which includes your down payment plus closing costs, minus any earnest money deposit and seller credits. In other words, closing costs are one component of cash to close.

Can I roll closing costs into my loan?

Sometimes, but not always. If the home appraises for more than the purchase price, you might be able to finance the closing costs by increasing the loan amount, but this is limited by the loan-to-value ratio and lender rules. More commonly, you can ask the seller to pay a portion of closing costs as a concession, which effectively reduces your cash to close. Your lender will tell you what’s allowed.

Why is my net sheet different from the Loan Estimate?

The net sheet is an informal estimate, often based on averages and guesses. The Loan Estimate is a formal document prepared by the lender using actual fees from service providers. Differences can arise from title insurance costs, appraisal fees, or tax prorations that weren’t known when the net sheet was created. Always rely on the Loan Estimate for planning.

Do I need to bring the full cash to close as a check?

Most closings require a wire transfer or cashier’s check for the exact amount, as personal checks are rarely accepted. The closing agent will give you final instructions and the exact amount a day or two before closing. Wiring has a risk of fraud, so always verify the wiring instructions by phone with the closing agent.

What happens if I bring less cash than the net sheet shows?

You can’t close without the full amount, unless you negotiate a change, such as a seller concession or a higher loan amount. If you can’t cover the shortfall, you may need to postpone closing or renegotiate the contract. That’s why it’s critical to review the net sheet early and confirm you have the funds.

The result from this calculator is an estimate; your lender’s Closing Disclosure gives the exact figures.

Related

Formula used
in p | Purchase price | $ | 300000 | 1 | 100000000
in d | Down payment % | % | 20 | 0 | 100
in l | Loan amount | $ | 240000 | 1 | 100000000
in e | Estimated closing costs | $ | 8000 | 0 | 1000000
in t | Prorated taxes & prepaids | $ | 2500 | 0 | 1000000
in dep | Earnest money deposit | $ | 5000 | 0 | 1000000
out cash | Cash to close | $ | p - l + e + t - dep | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →