How to Calculate Net Worth in Excel (and the Three Adjustments Most Trackers Skip)

Net worth is what you own minus what you owe. The formula is one subtraction. The work is deciding what goes into each side and at what value.

Two people with the same accounts can report net worth figures that differ by tens of thousands of dollars. One counts the house at the Zillow estimate. The other counts it at what they would actually walk away with. One counts the car at what they paid. The other counts it at what a buyer would pay today. Neither is lying. They are just measuring different things.

This guide builds a net worth sheet in Excel from one worked household. Then it covers the three adjustments that matter most, and how to read the month-over-month change so it tells you something.

Step 1: one table, one row per account

Put every account in a single table. Do not split assets and liabilities into separate blocks. A single table lets one formula handle both sides, and it makes adding a new account a one-row job.

| A: Account | B: Type | C: Group | D: Value | |---|---|---|---| | Checking | Asset | Cash | 4,200 | | Savings (emergency fund) | Asset | Cash | 18,000 | | Brokerage | Asset | Invested | 32,500 | | 401(k) | Asset | Retirement | 86,000 | | Roth IRA | Asset | Retirement | 21,000 | | Home (market estimate) | Asset | Property | 640,000 | | Car (private-party value) | Asset | Property | 14,500 | | Mortgage | Liability | Property | 412,000 | | Auto loan | Liability | Property | 9,800 | | Student loans | Liability | Other debt | 23,400 | | Credit card balance | Liability | Other debt | 2,300 |

Enter every value as a positive number, including the debts. The Type column decides the sign. This avoids the most common net worth bug, which is a debt typed as a positive number and then added instead of subtracted.

Turn the range into an Excel Table (Ctrl+T) and name it NW. Formulas that point at the table name expand on their own when you add a row.

Step 2: the net worth formula

` Total assets: =SUMIFS(NW[Value], NW[Type], "Asset") -> 816,200 Total liabilities: =SUMIFS(NW[Value], NW[Type], "Liability") -> 447,500 Net worth: =assets - liabilities -> 368,700 `

That is the whole calculator. Everything after this is about making the inputs honest and the output readable.

One ratio is worth adding next to it:

` Debt to assets: =liabilities / assets -> 54.83% `

This shows how much of what you hold is financed. It falls as you pay down debt and as assets grow, so it improves even in months when net worth looks flat.

Step 3: the views that answer real questions

Total net worth is dominated by the house for most homeowners. In this example the home equity is $640,000 minus $412,000, or $228,000. That is 61.8% of the $368,700 total. You cannot spend home equity without selling or borrowing, so a second view helps.

Use the Group column to build them:

` Excluding home and car: =SUMIFS(NW[Value], NW[Type], "Asset", NW[Group], "<>Property")

Accessible now (cash and taxable investments only): =SUMIFS(NW[Value], NW[Type], "Asset", NW[Group], "Cash") + SUMIFS(NW[Value], NW[Type], "Asset", NW[Group], "Invested")

The same household is worth $368,700, or $136,000 outside the house and car, or $29,000 that it could reach this month without selling property or touching retirement accounts. All three numbers are correct. The third one is the one that matters if a job ends.

Step 4: three adjustments most trackers skip

1. The home at what you would net, not what it is listed at

An online estimate is a guess at the sale price. You do not keep the sale price. Agent commissions, transfer taxes, and closing costs come out first. A planning figure of 6% of the price is common.

` Selling cost: =640000 * 6% -> 38,400 `

That one line lowers net worth by 10.4%. Put the rate in its own input cell so you can change it. Some people also apply a haircut to the estimate itself, because automated values can miss in either direction.

2. The car at today's resale value

A car bought for $31,000 that would sell for $14,500 today should be on the sheet at $14,500. Carrying it at cost overstates net worth by $16,500, or 4.5% here. Update it once or twice a year from a pricing guide. Do not try to track it monthly, because the noise is larger than the signal.

3. Pre-tax retirement money is not all yours yet

A traditional 401(k) balance of $86,000 has income tax owed on it when you withdraw. The Roth IRA does not. If you assume a 22% rate in retirement, the tax claim is:

` Deferred tax: =86000 * 22% -> 18,920 `

You do not have to subtract it. But if you compare your net worth with someone who holds the same amount in a Roth, you are comparing different things unless you do.

The car is already on the sheet at resale value, so only the other two come off. The adjusted figure is:

` =368700 - 38400 - 18920 -> 311,380 `

That is 15.5% below the headline number. A tracker that also carried the car at cost would show $385,200, so the full gap from that sheet to this one is $73,820, or 19.2%. Pick one convention, write it in a note at the top of the sheet, and keep it. Consistency matters more than which convention you pick, because the trend is what you are tracking.

Step 5: reading the monthly change

Put one column per month and copy the net worth formula across. The change is simple:

` Change: =this_month - last_month `

In this example last month was $361,900, so the change is $6,800. That number mixes two very different things: money you saved and markets moving. Split them.

Add up what you put in during the month:

| Source | Amount | |---|---| | 401(k) contribution with match | 1,500 | | Brokerage deposit | 500 | | Transfer to savings | 800 | | Mortgage principal paid | 950 | | Auto loan principal paid | 380 | | Student loan principal paid | 210 | | Total saved | 4,340 |

Paying down principal counts, because it lowers a liability by exactly the amount paid. The interest part of the payment does not count.

The transfer to savings only counts as saving if checking ended the month where it started. Moving $800 from checking to savings changes nothing on its own. If checking fell by $800 in the same month, the two cancel and the saved total is $3,540. The clean rule is to add the change in checking to the table, positive or negative.

The employer match is in the 401(k) line. It is real money, but it is not your behavior, so some people list it on its own row to see what they saved themselves.

` Saved: 4,340 Valuation change: =6800 - 4340 -> 2,460 `

So $4,340 of this month's gain came from your behavior and $2,460 came from prices. In a good market month the second number is large. In a bad month it is negative and can swamp the first. The saved line is the one you control. If it stays steady while net worth bounces around, the plan is working.

Five mistakes that distort the number

  1. Debts typed as negatives and then subtracted again. A negative mortgage minus a SUM turns a liability into an asset. Keep every value positive and let the Type column handle the sign.
  2. Skipping the credit card because you pay it in full. Your checking balance already includes the money that will pay the card. List checking and leave out the card, and net worth is overstated by the card balance, $2,300 here.
  3. Mixing snapshot dates. Take every value on the same day, ideally the last day of the month. A brokerage balance from the 30th and a loan balance from the 15th do not describe one moment.
  4. Percentage change on a small base. Going from $5,000 to $10,000 is +100%, which says nothing useful. When net worth is near zero or negative, track the dollar change.
  5. Updating the home every month. Monthly estimate swings will drown out your actual saving. Revalue the house once a year, or hold it at purchase price and track the mortgage paydown only.

Summary

Written with AI assistance and checked by recalculation. For education and planning only, not financial advice.

If you would rather not build this from scratch, the Numbersmith Annual Budget and Net Worth Tracker tracks seven asset and five liability lines by month, calculates net worth and the month-over-month change, and charts it next to your budget.