How to Calculate Home Equity: A Home Value and Mortgage Balance Worksheet
home equityproperty valuemortgage planninghomeowner financesrefinancing

How to Calculate Home Equity: A Home Value and Mortgage Balance Worksheet

AAppraised Editorial Team
2026-11-08
7 min read

Learn how to calculate home equity using current value, mortgage balances, secured debt, selling costs, and a repeatable worksheet.

To calculate home equity, estimate your property's current market value, subtract the balance owed on loans secured against it, and then check the result as a percentage of the property's value. This worksheet explains each input, shows the difference between gross and usable equity, and gives you a repeatable method to revisit after mortgage updates, valuations, renovations, or major market changes.

Overview

Home equity is the portion of your home that you own financially. The basic calculation is:

Home equity = estimated current home value − outstanding secured debt

If a property is worth $400,000 and the remaining mortgage principal is $300,000, the estimated equity is $100,000. The calculation is straightforward, but the result depends heavily on two inputs: the quality of the property-value estimate and the accuracy of the debt balance.

Gross equity is not necessarily the amount you could take out or keep after selling. A sale may involve agent fees, legal or conveyancing costs, taxes, loan discharge charges, and other transaction expenses. A lender may also apply its own valuation, loan-to-value limits, affordability checks, and product rules before approving borrowing against the property.

It is useful to track three related figures:

  • Gross equity: current estimated value minus secured loan balances.
  • Equity percentage: gross equity divided by current estimated value, multiplied by 100.
  • Estimated net sale proceeds: current value minus loan balances and likely selling costs.

Equity can increase when you repay mortgage principal, improve the property, or benefit from a rise in comparable local sale prices. It can decrease if the property's market value falls, if you borrow more against it, or if selling costs rise.

How to estimate home equity

Use the following four-step worksheet. Keep the date beside every input so that you can tell when the estimate was prepared.

1. Estimate the current property value

Start with a realistic market estimate rather than the price you paid or the value shown on an old appraisal. Useful inputs may include recent comparable sales, local listings, a lender valuation, a qualified appraisal, or a reputable property-value estimator. Comparable properties should be as similar as possible in location, size, condition, age, layout, and land or lot characteristics.

Online estimates can be a useful starting point, but they may not reflect renovations, defects, unusual features, or rapid changes in a small local market. If the number matters for refinancing, a sale, estate planning, or a large borrowing decision, ask the relevant lender or professional what type of valuation it requires.

2. Confirm all secured debt

Use a recent mortgage statement or lender account summary. Record the outstanding principal, not simply the original loan amount. Check whether the statement's balance includes accrued interest, fees, or a payment due. If you have a second mortgage, home-equity loan, or secured line of credit, include its outstanding balance as well.

For a sale or loan payoff, request an official payoff figure when appropriate. A payoff amount can differ from the principal balance because of interest through a specified date, discharge fees, early repayment charges, or other contract terms.

3. Subtract debt from value

Apply this formula:

Estimated equity = estimated home value − mortgage balance − other secured loan balances

Do not subtract unsecured debts such as credit cards or personal loans from home equity. They may affect your budget and borrowing capacity, but they are not liens secured by the property.

4. Calculate the equity percentage

Use this formula:

Home equity percentage = (estimated equity ÷ estimated home value) × 100

This percentage helps compare your position over time even when the property's value changes. You can also calculate the loan-to-value ratio:

Loan-to-value ratio = (secured debt ÷ estimated home value) × 100

Equity percentage and loan-to-value ratio are complementary measures. If all secured debt is included and the figures use the same property value, they will generally add to 100%.

Inputs and assumptions

Create a simple worksheet with these columns: input, amount, date, source, and confidence level. The following table provides a practical structure.

InputWhat to recordWhy it matters
Estimated property valueCurrent value and valuation dateThe largest variable in the calculation
Mortgage principalOutstanding balance from a recent statementShows the debt secured by the primary mortgage
Other secured debtSecond mortgage, secured loan, or credit-line balancePrevents overstating equity
Recent improvementsWork completed, cost, and completion dateCost does not automatically equal added market value
Comparable salesDates, prices, and relevant similarities or differencesProvides context for the value estimate
Potential selling costsEstimated commissions, legal costs, taxes, and loan chargesHelps estimate net proceeds rather than gross equity

Keep assumptions conservative when making a financial decision. A renovation invoice shows what you spent; it does not prove that the same amount was added to the home's market value. Likewise, an asking price is not the same as a completed sale. Separate confirmed information from estimates and use a range when a single figure would create false precision.

For example, you might record a low, central, and high property-value estimate. Calculate equity under each scenario. This produces a more useful planning range than relying on one optimistic number.

Remember that equity is not the same as immediately available cash. A lender may decline a request, offer less than expected, or require a new valuation. Borrowing against equity also creates repayment obligations and interest costs. Before using equity for a refinance, renovation, investment, or other purpose, compare the complete cost and consider how a change in rates or income would affect the budget. Our mortgage refinance break-even guide can help organize that comparison.

Worked examples

Example 1: Basic gross equity

Assume an illustrative property-value estimate of $400,000 and a mortgage principal balance of $300,000. There are no other secured loans.

  • Estimated value: $400,000
  • Mortgage balance: $300,000
  • Estimated equity: $400,000 − $300,000 = $100,000
  • Equity percentage: $100,000 ÷ $400,000 × 100 = 25%
  • Loan-to-value ratio: $300,000 ÷ $400,000 × 100 = 75%

These figures describe the estimated ownership stake before selling costs. They do not guarantee that $100,000 could be borrowed or received in cash.

Example 2: Including a secured credit line

Now assume the same $400,000 property value and $300,000 mortgage, plus a $20,000 balance on a secured credit line.

  • Total secured debt: $300,000 + $20,000 = $320,000
  • Estimated equity: $400,000 − $320,000 = $80,000
  • Equity percentage: $80,000 ÷ $400,000 × 100 = 20%

Leaving out the credit-line balance would overstate equity by $20,000.

Example 3: Value range and estimated net proceeds

Suppose your research suggests a property value between $380,000 and $420,000. The mortgage balance is $290,000, and you set aside an illustrative $18,000 for possible selling expenses. The gross equity range is $90,000 to $130,000:

  • Lower estimate: $380,000 − $290,000 = $90,000 gross equity
  • Central estimate: $400,000 − $290,000 = $110,000 gross equity
  • Higher estimate: $420,000 − $290,000 = $130,000 gross equity

Using the central value, estimated net proceeds would be $400,000 − $290,000 − $18,000 = $92,000. The $18,000 is an assumption for illustration only; actual costs depend on the location, transaction, loan terms, and services used. For a broader view of transaction expenses, see the closing costs calculator guide.

When to recalculate

Update your worksheet at least when your mortgage statement, valuation evidence, or secured debt changes. A practical annual review is often enough for general planning, but recalculate sooner in these situations:

  • After a major renovation or structural improvement is completed.
  • When comparable local sales indicate a meaningful change in value.
  • Before requesting a refinance, home-equity loan, or secured credit line.
  • After making a large principal payment or changing the mortgage.
  • Before listing the property for sale or accepting an offer.
  • When reviewing retirement, estate, insurance, or household financial plans.
  • When a new appraisal or lender valuation becomes available.

At each review, write down the valuation date, debt balances, secured accounts included, assumptions about selling costs, and the reason for the update. Compare the new result with the previous worksheet, but avoid treating every change as a permanent trend. A single estimate can move because of the selected comparables, property condition, or timing.

For a useful next step, save a copy of this worksheet with your mortgage records, update the principal balance after each annual review, and maintain a low-to-high value range when uncertainty is material. If you are considering refinancing, review the complete monthly payment and break-even calculation rather than focusing on equity alone. If you are preparing to sell, pair the equity estimate with a realistic closing-cost budget and an up-to-date payoff figure. That process turns the question “How much equity do I have?” into a repeatable planning exercise.

Related Topics

#home equity#property value#mortgage planning#homeowner finances#refinancing
A

Appraised Editorial Team

Homebuying and Homeownership Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.