Calculator overview
Inputs and outputs
This summary comes from the calculator's published input and output contract.
Inputs
- Prepaid Months Tax (required)
-
Unit months Default 6 Range 0 to 24
About this input
How many months of property tax the lender collects at closing to start the escrow account. Two to six is usual, and it depends on where the tax year sits relative to your closing date.
- Prepaid Months Insurance (required)
-
Unit months Default 12 Range 0 to 24
About this input
How many months of insurance are collected up front. The first full year is usually paid at closing, so twelve is common.
- Points Paid
-
When omitted Blank
Unit points Default Not set Range 0 to 10
About this input
Optional. Discount points bought to lower the rate, where one point is one percent of the LOAN. Leave blank if you are buying none. The rate reduction itself is not modelled here; the points calculator handles that trade.
- Title Insurance Rate (required)
-
Unit fraction Default 0.005 Range 0 to 1
About this input
Title insurance as a share of the price. Rates are regulated in some states and competitive in others, which is why this is an input rather than a constant.
- Recording Fees (required)
-
Unit currency Default 250 Range At least 0
About this input
What the county charges to record the deed and the mortgage, plus any transfer tax you are paying. Varies by county, not just by state.
- Purchase Price (required)
-
Unit currency Default 350000 Range At least 0
About this input
The agreed price of the home. Title insurance and transfer charges are usually set against this, not against the loan.
- Other Fees
-
When omitted Blank
Unit currency Default Not set Range At least 0
About this input
Optional. Anything else charged at closing that does not fit a line above: survey, pest inspection, courier, a heavy state transfer tax. Treated as a third-party fee.
- Appraisal Fee (required)
-
Unit currency Default 600 Range At least 0
About this input
What the lender charges to have the home valued. A flat fee, not a rate, and one of the few you cannot avoid.
- Annual Property Tax (required)
-
Unit currency/yr Default 4200 Range At least 0
About this input
The property tax bill for a full year. Used only for the months collected in advance, not for the monthly payment.
- Annual Insurance (required)
-
Unit currency/yr Default 1500 Range At least 0
About this input
The homeowner insurance premium for a full year.
- Origination Rate (required)
-
Unit fraction Default 0.01 Range 0 to 1
About this input
The lender's origination or underwriting charge as a share of the loan. One percent is common; some lenders charge nothing and price it into the rate instead.
- Loan Amount (required)
-
Unit currency Default 280000 Range At least 0
About this input
How much you are borrowing. Origination and points are charged on this, so the gap between price and loan matters to the total.
- Credits Applied
-
When omitted Blank
Unit currency Default Not set Range At least 0
About this input
Optional. Money the seller or the lender is putting toward your costs. Lenders cap credits at the costs they offset, so a credit larger than your costs will not simply be paid out.
Outputs
- Prepaid Items
-
Unit currency
About this output
Tax and insurance collected in advance. Not a cost of borrowing: this is money you would have paid anyway, moved forward, and it comes back to you as months when the escrow account covers the bill.
- Percent Of Price
-
Unit fraction
About this output
Total closing costs against the price. Two to five percent is the usual range for a purchase; above that, check whether prepaids are doing the work.
- Model Status
-
No unit declared
About this output
Reads OK, or explains why the inputs are not valid or why the estimate deserves a second look.
- Total Closing Costs
-
Unit currency
About this output
All three groups added. This is the figure most estimators report as a single number.
- Third Party Fees
-
Unit currency
About this output
Title insurance, recording and anything else. Some of these are shoppable in theory; in practice most are set by where the home is.
- Shoppable Share
-
Unit fraction
About this output
Lender fees as a share of the total. A low share means most of your closing costs are fixed by where you are buying, and shopping lenders will not move them much.
- Cost Of Borrowing
-
Unit currency
About this output
The total less the prepaids. This is what the loan actually costs you to obtain, and the figure worth comparing between lenders.
- Cash To Close Net
-
Unit currency
About this output
The same figure after credits from the seller or lender, floored at zero.
- Cash To Close
-
Unit currency
About this output
The down payment plus every closing cost. This is what you need available, and it is the figure people underestimate.
- Lender Fees
-
Unit currency
About this output
Origination, points and the appraisal. This is the group that actually changes when you change lender, which is why it is reported on its own.
- Down Payment Percent
-
Unit fraction
About this output
The down payment as a share of the price. Below twenty percent, conventional loans usually add mortgage insurance, which this estimate does not include.
- Down Payment
-
Unit currency
About this output
The price less the loan. Not a closing cost, but part of the cash you need on the day.
LogicCommons is in beta. If a result, label, or reference looks wrong, tell us here; we read every message.
Methodology
Purpose and model boundary
Use this calculator to itemise what you will be asked to pay on the day you close on a home, and to see how much of that bill is worth negotiating. It sorts every charge into three groups. Lender fees are origination, discount points and the appraisal. Third-party fees are title insurance, recording and anything else charged by someone other than the lender. Prepaid items are the months of property tax and homeowners insurance the lender collects in advance to open the escrow account. It then adds the down payment to give the cash you actually need to have available on the day.
The split is the point rather than a presentational choice. Only lender fees move much when you change lender; third-party fees are mostly set by where the home is; and prepaid tax and insurance are not a cost of borrowing at all, but money you owed anyway, collected early, which comes back to you as months when the escrow account pays the bill instead of you. A single combined total mixes the three and overstates what shopping for a lender can save.
The model boundary is narrow and it matters. Every rate and every fee is a number you supply. The calculator holds no fee schedule for any lender, title company or recording office, and it looks nothing up by state or county. It is an estimate built from your own figures, not a quote, and the documents that govern are the Loan Estimate your lender must give you after you apply and the Closing Disclosure that follows before closing.
The following are not modelled and will not appear in any figure on this page:
- Mortgage insurance. Below twenty percent down a conventional lender usually charges it, and it can carry a one-time up-front premium at closing as well as a monthly premium.
- The interest-rate reduction that discount points buy. Points are counted here as a cost only. The trade between a lower rate and the cash to buy it is a different calculation.
- Per-diem interest from the closing date to the first of the next month. It can be a few hundred dollars and it depends on which day you close.
- Escrow cushions beyond the months you enter. Lenders commonly hold an extra buffer on top of the months collected.
- Seller-paid costs beyond the single credits input, and the caps lenders place on how much of your costs a credit may offset.
- Transfer taxes in the states that levy them heavily, unless you enter them yourself in the other-fees input.
- Rate locks, lock extensions, and any fee charged after closing.
- Income tax. Nothing here is stated after tax, and no charge is treated as deductible or as added to basis.
Inputs and units
| Input | Unit | Accepted range | What it means |
|---|---|---|---|
| Purchase Price | $ | 0 or more, and above 0 to compute | The agreed price of the home. Title insurance and transfer charges are usually set against this, not against the loan. |
| Loan Amount | $ | 0 or more, and not above the price | How much you are borrowing. Origination and points are charged on this, so the gap between price and loan matters to the total. |
| Origination Rate | percentage | 0–100% | The lender's origination or underwriting charge as a share of the loan. One percent is common; some lenders charge nothing and price it into the rate instead. |
| Points Paid | points | 0–10, or blank | Optional. Discount points bought to lower the rate, where one point is one percent of the loan. Leave blank if you are buying none. The rate reduction itself is not calculated here. |
| Appraisal Fee | $ | 0 or more | What the lender charges to have the home valued. A flat fee, not a rate, and one of the few you cannot avoid. |
| Title Insurance Rate | percentage | 0–100% | Title insurance as a share of the price. Rates are regulated in some states and competitive in others, which is why this is an input rather than a fixed value. |
| Recording Fees | $ | 0 or more | What the county charges to record the deed and the mortgage, plus any transfer tax you are paying. Varies by county, not just by state. |
| Other Fees | $ | 0 or more, or blank | Optional. Anything else charged at closing that does not fit a line above: survey, pest inspection, courier, a heavy state transfer tax. Counted as a third-party fee. |
| Annual Property Tax | $/year | 0 or more | The property tax bill for a full year. Used only for the months collected in advance, not for any monthly payment. |
| Prepaid Months Tax | months | 0–24 | How many months of property tax the lender collects at closing to start the escrow account. Two to six is usual, and it depends on where the tax year sits relative to your closing date. |
| Annual Insurance | $/year | 0 or more | The homeowners insurance premium for a full year. |
| Prepaid Months Insurance | months | 0–24 | How many months of insurance are collected up front. The first full year is usually paid at closing, so twelve is common. |
| Credits Applied | $ | 0 or more, or blank | Optional. Money the seller or the lender is putting toward your costs. Lenders cap credits at the costs they offset, so a credit larger than your costs will not simply be paid out. |
Three inputs are optional and ship blank rather than at zero: Points Paid, Other Fees and Credits Applied. A blank reads as zero everywhere it is used, so leaving all three blank gives the plain case of no points, no extra charges and no credit. Blank and zero produce identical figures; the difference is only that a blank says you have not answered yet.
Governing relationships
Write P for the purchase price, L for the loan amount, A for the appraisal fee, R for the recording fees, T for the annual property tax and I for the annual insurance premium. Write the origination rate as ro and the title insurance rate as rt, both held as shares of one rather than as whole numbers, so one percent is 0.01. Write n for the points bought, O for the other fees and C for the credits applied, each read as zero when left blank. Write mT and mI for the months of tax and of insurance collected up front.
The down payment is the part of the price you are not borrowing:
- down payment = P minus L
The three groups are each a plain sum, and the two bases are deliberately different:
- lender fees = L × ro + L × n / 100 + A
- third-party fees = P × rt + R + O
- prepaid items = (T / 12) × mT + (I / 12) × mI
Origination and points are charged on the loan. Title insurance is charged on the price. The two are not interchangeable, and the division by 100 in the points term is what makes one point equal one percent of the loan rather than one percent expressed as a share of one. On a loan of 280,000, one and a half points costs 4,200. Charging the same points against a price of 350,000 would give 5,250, which is the most common error in this category of calculation.
From the three groups:
- total closing costs = lender fees + third-party fees + prepaid items
- cost of borrowing = lender fees + third-party fees, which is the total less the prepaid items
- cash to close = down payment + total closing costs
- net cash to close = the larger of zero and (cash to close minus C)
Three ratios describe the result rather than adding to it. Each returns zero rather than failing when its denominator is zero or below:
- shoppable share = lender fees / total closing costs
- total as a share of the price = total closing costs / P
- down payment as a share of the price = down payment / P
The second chart is a sweep rather than a single answer. For each down-payment share s from 3 percent to 40 percent in one-point steps, the loan is re-derived as P × (1 minus s) and the cash to close is recomputed with every other input held where you left it. The line rises more slowly than the down payment alone would, because each extra dollar of down payment is a dollar less of loan, and the charges levied on the loan fall with it. A flat marker line sits at your own cash to close so you can see where your down payment lands on the sweep.
Calculation sequence
- Apply the published input rules to every entry. A value outside its accepted range is rejected here and nothing is calculated.
- Read the three optional inputs, treating a blank as zero for points bought, other fees and credits.
- Calculate the down payment as the price less the loan.
- Calculate lender fees: origination on the loan, points on the loan, then the appraisal added as a flat amount.
- Calculate third-party fees: title insurance on the price, then recording and other fees added as flat amounts.
- Calculate prepaid items: the annual tax divided by twelve and multiplied by the months of tax, plus the annual insurance divided by twelve and multiplied by the months of insurance.
- Add the three groups to give total closing costs, and subtract the prepaid items again to give the cost of borrowing.
- Add the down payment to the total to give the cash to close, then subtract the credits and floor the result at zero to give the net cash to close.
- Calculate the three ratios: the shoppable share, the total as a share of the price, and the down payment as a share of the price.
- Build the down-payment sweep that the second chart reads, and build the four-way split that the first chart reads.
- Evaluate the status conditions below in order and return the first one that is true.
Outputs and interpretation
Three figures are the headline. Cash to close is what you need available on the day, and it is the figure people underestimate, because it carries the down payment as well as the fees. Total closing costs is the single number most estimators report, and it is the one to compare against another tool's total, remembering that tools differ in what they fold into it. The cost of borrowing is the total less the prepaid items, and it is the figure to put side by side between two lenders, because the prepaid tax and insurance would be owed whoever lent you the money.
| Output | Role | Unit | What it means |
|---|---|---|---|
| Total Closing Costs | headline | $ | All three groups added. This is the figure most estimators report as a single number. |
| Cost Of Borrowing | headline | $ | The total less the prepaids. This is what the loan actually costs you to obtain, and the figure worth comparing between lenders. |
| Cash To Close | headline | $ | The down payment plus every closing cost. This is what you need available, and it is the figure people underestimate. |
| Model Status | status | text | Reads OK, or explains why the inputs are not valid or why the estimate deserves a second look. |
| Cash To Close Net | detail | $ | The same figure after credits from the seller or lender, floored at zero. |
| Down Payment | detail | $ | The price less the loan. Not a closing cost, but part of the cash you need on the day. |
| Lender Fees | detail | $ | Origination, points and the appraisal. This is the group that actually changes when you change lender, which is why it is reported on its own. |
| Third Party Fees | detail | $ | Title insurance, recording and anything else. Some of these are shoppable in theory; in practice most are set by where the home is. |
| Prepaid Items | detail | $ | Tax and insurance collected in advance. Not a cost of borrowing: this is money you would have paid anyway, moved forward, and it comes back to you as months when the escrow account covers the bill. |
| Shoppable Share | detail | percentage | Lender fees as a share of the total. A low share means most of your closing costs are fixed by where you are buying, and shopping lenders will not move them much. |
| Percent Of Price | detail | percentage | Total closing costs against the price. Two to five percent is the usual range for a purchase; above that, check whether prepaids are doing the work. |
| Down Payment Percent | detail | percentage | The down payment as a share of the price. Below twenty percent, conventional loans usually add mortgage insurance, which this estimate does not include. |
The two charts read the same figures. The first splits the cash to close four ways, into the down payment and the three fee groups, so the relative size of each is visible at a glance. The second shows how the cash to close moves as the down payment share moves, with a flat marker at your own figure.
Validation and status logic
The workbook evaluates its status conditions in the order below and returns the first one that is true. Later conditions are never reached once an earlier one has matched, so the order is the precedence: a price of zero reports the price, even when the loan also exceeds it. The final row is the fallthrough that applies when nothing above it did.
| Condition | Returned status |
|---|---|
| Purchase Price <= 0 | NOT VALID: the price has to be above zero |
| Loan Amount < 0 | NOT VALID: the loan cannot be negative |
| Loan Amount > Purchase Price | NOT VALID: the loan is larger than the price, which this model does not handle |
| OR(Origination Rate < 0,Title Insurance Rate < 0) | NOT VALID: a fee rate cannot be negative |
| OR(Appraisal Fee < 0,Recording Fees < 0) | NOT VALID: a fee cannot be negative |
| OR(Annual Property Tax < 0,Annual Insurance < 0) | NOT VALID: an annual cost cannot be negative |
| OR(Prepaid Months Tax < 0,Prepaid Months Insurance < 0) | NOT VALID: months collected up front cannot be negative |
| AND(Points Paid <> "",Points Paid < 0) | NOT VALID: points bought cannot be negative |
| AND(Credits Applied <> "",Credits Applied < 0) | NOT VALID: a credit cannot be negative |
| Credits, coalesced > Cash To Close | CHECK: the credits exceed the cash you need, and lenders cap credits at the costs they offset, so confirm the excess is really payable to you |
| Percent Of Price > 0.06 | CHECK: total closing costs are above six percent of the price, which is high; check whether prepaids are inflating the total |
| AND(Down Payment Percent < 0.2,Down Payment Percent > 0) | CHECK: below twenty percent down, most conventional loans add mortgage insurance, which this estimate does not include |
| None of the preceding conditions applies | OK |
Thirteen rows, and six of the outcomes can be reached from this page: a price of exactly zero, a loan larger than the price, each of the three CHECK conditions, and OK. The other seven all test for a negative amount, rate or month count, and the published input rules refuse every one of those entries before any calculation is attempted, so they never surface here. They are the workbook's own defences, and they matter when you download the workbook and drive it yourself, where those input rules do not apply.
Credits, coalesced in the tenth row means the credits input with a blank read as zero. Points Paid <> "" and Credits Applied <> "" in the eighth and ninth rows are the tests for an optional input that has actually been filled in, which is why a blank never triggers them.
The two CHECK conditions that follow the credits test are ordered as they are for a reason. A total above six percent of the price is reported before a down payment below twenty percent, so a case that trips both reports the larger total first.
Assumptions and limitations
- Every fee and every rate is an input. The calculator holds no fee schedule and looks nothing up, so the quality of the result is entirely the quality of the figures you enter. Take them from your own Loan Estimate.
- Origination and points are charged on the loan; title insurance is charged on the price. A tool that charges points on the price reads high by the down payment's share, and the two totals are not comparable without correcting for that.
- Points are counted as a cost only. The rate reduction they buy is not modelled, so this calculator cannot tell you whether buying points is worthwhile.
- Prepaid items are exactly the months you enter, with no lender cushion on top, applied to a flat annual bill divided by twelve rather than to a real tax calendar. A lender that re-estimates either annual amount will collect something different.
- Mortgage insurance is excluded in every state of the model, including the state where the status says a conventional lender would charge it. The estimate is understated there by both the up-front and the monthly premium.
- Per-diem interest from closing to the first of the next month is excluded, and it is not small. Closing early in a month costs more of it.
- Credits reduce the cash to close and never the costs themselves. The caps lenders place on credits are not modelled, and neither are seller-paid costs arranged any other way.
- The shoppable share counts lender fees only. Some third-party services, title insurance among them, can also be shopped, so the share is a conservative reading of what is negotiable rather than a complete one.
- The down-payment sweep in the second chart holds every fee input fixed while it varies the loan. A real lender may price origination differently at a different loan size.
- All figures are nominal dollars on the closing date, not adjusted for inflation and not stated after tax.
Restrictions and non-computing states
Every required input must be present, and each must sit inside its published range: the price, the loan, the appraisal, the recording fees and both annual amounts cannot be negative; both rates must be between zero and one hundred percent; and both prepaid month counts must be whole numbers from zero through twenty-four. The three optional inputs, points bought, other fees and credits, may be left blank or filled with a value of zero or more; points are additionally capped at ten.
The price must be above zero for the model to answer. A price of exactly zero is accepted by the input rules but returns NOT VALID, because a total as a share of the price has no meaning and the cash to close becomes a negative number that describes nothing. A loan larger than the price is also refused: that is a state this model does not handle, and it is refused rather than approximated.
Everything else computes. The three CHECK conditions are not refusals; they return every figure and add a sentence saying what to look at.
Errors and warnings
Three different things can go wrong, and they are not the same event.
A rejected entry happens before any calculation. A value outside its published range never reaches the calculation at all, the page names the input that is out of range, and no figure changes. Nothing was computed, so nothing is shown as zero.
A NOT VALID or CHECK status is the model's own finding about inputs it accepted. NOT VALID means the combination does not describe a question this model can answer, and the figures beside it should not be read as an estimate. CHECK means the arithmetic completed and every figure is real, but something deserves your attention: a credit larger than the cash you need, a total above six percent of the price, or a down payment below twenty percent where mortgage insurance would normally apply and is not included here. The status text names which one it is.
A connection or calculation-service failure is neither of those. It means the calculation could not be reached or did not return, and it says nothing about your inputs. It is a matter of availability, never a finding, and it is never reported as a zero or as a valid result. Retry it; if it persists, the figures on the page are stale and should not be used.
References
The three-way split this calculator uses follows the way the closing bill is already laid out for you. The Consumer Financial Protection Bureau's explainer for the Loan Estimate walks through the form section by section: origination charges, the third-party services you cannot shop for, the services you can shop for, and the other costs, which include taxes, government fees and the amounts collected in advance. That form, not this page, is the authoritative estimate, and the CFPB's what is a Loan Estimate states that a lender must provide one within three business days of receiving your application.
The cash-to-close figure and the prepaid items are described on the CFPB's explainer for the Closing Disclosure, which sets out the amount you will actually have to pay at closing, the prepaid interest and first-year insurance premium commonly paid in advance, the initial escrow payment that opens the escrow account, and the requirement that the Closing Disclosure reach you three business days before closing. For the charges themselves, the CFPB's what fees or charges are paid when closing on a mortgage names appraisal fees, title insurance, government taxes and prepaid expenses among them.
Points here are charged on the loan, never on the price. The CFPB's discount points and lender credits states that one point equals one percent of the loan amount, and describes lender credits as the same calculation in reverse, which is the kind of credit the credits input accepts.
Title insurance is grouped with the third-party fees and is charged here against the price. The CFPB's owner's title insurance distinguishes the lender's policy, which protects the loan, from the optional owner's policy, which protects your own stake, and notes that the provider can usually be shopped for separately from the mortgage.
The status warning below twenty percent down rests on the CFPB's private mortgage insurance, which explains that a conventional loan with a down payment under twenty percent of the purchase price may require it, and that it is sometimes charged as a one-time up-front premium at closing as well as monthly. This calculator does not include it, which is why the status names the gap rather than filling it.
Nothing here is stated after tax. For how settlement costs, points and real estate taxes are treated, see the Internal Revenue Service's Publication 530, Tax Information for Homeowners.
The arithmetic is not taken from any of these sources. Each group is a plain sum of the amounts and rates you enter, which is standard financial mathematics, and the delivered workbook carries its own validation sheet: component checks against an independent implementation written before the workbook, whole-model figures in the shipped state, and invariants that hold in any state, including one that pins the cost of an additional point at one percent of the loan.
These sources provide consumer context; they do not supply the figures you enter and they do not certify the result. This calculator is informational and is not financial, legal, tax, real-estate or lending advice. Confirm every charge and every credit against the Loan Estimate and the Closing Disclosure from your own lender and settlement professional.
Found a problem, or have an idea?
Tell us if a result looks wrong, a label is unclear, or something is missing. We read every message.