Start With the Formula
Net worth is total assets minus total liabilities. That is the entire basis of the spreadsheet. It does not depend on how much you earn, where you live, or what your friends drive. It measures what you own minus what you owe, valued in cash terms, on a specific date.
Open a new spreadsheet and put that formula at the top before entering anything else. Then build two blocks. The asset block holds positive numbers. The liability block holds negative numbers. Sum both and you get your net worth.
A net worth spreadsheet is not a budget. A budget tracks income and expenses over time. The spreadsheet is a balance sheet snapshot. You still need the budget to run your month. You use the spreadsheet to see if the overall machine is building wealth.
Divide the Sheet Into Assets and Liabilities
Use one row per account, not one row per category. If you have three bank accounts, they get three rows. If you have two credit cards, they get two rows. That granularity lets you spot stale balances and small errors before they become big ones.
On the asset side, list everything you own that has cash value. Cash accounts, brokerage accounts, retirement accounts, real estate, vehicles, business interests, and large personal property. On the liability side, list everything you owe. Mortgages, auto loans, student loans, credit card balances, personal loans, tax debt, and unpaid medical bills. A balance with a 0% promotional rate still belongs there. The rate affects your repayment strategy, but the balance affects your net worth.
What Counts as an Asset
The label asset means something you can convert to cash. Checking and savings accounts count. Certificates of deposit count, even if you have to pay a penalty to break the term. Money market funds count. Brokerage accounts count at their current market value. Retirement accounts count at their current balance. A Health Savings Account counts if you treat it as a long term investment vehicle. A home counts at market value. A rental property counts at market value, with the mortgage listed separately. A car counts at realistic resale value. A business counts if you own equity in it and can assign a value, even a rough one. Jewelry and art count only if the amount would actually move your total.
What Counts as a Liability
A liability is an obligation that gives someone a legal claim on your money or property. Credit cards count every dollar of the statement balance, not the minimum payment. Loans count the principal you still owe, not the total cost over the life of the loan. A mortgage counts the outstanding balance, not the original amount. A home equity line of credit counts even if you have not drawn all of it. Back taxes, unpaid court judgments, and money you borrowed from relatives all count.
If the number appears on a billing statement and you are legally responsible for it, it belongs in the liability block.
Price Assets Like a Buyer, Not an Owner
The net worth number depends entirely on the values you type in. Use the amount you could realistically get if you sold the asset today, not the amount you paid and not the amount you hope to receive next decade. That is a mark to market approach.
For bank accounts, use the available balance. For investment accounts, use today’s market value or the latest statement. For a house, use a conservative number based on comparable sales or an appraisal. For a car, use private party resale value, not sticker price. For crypto, art, or collectibles, use the last actual trade and apply a haircut if the market is thin. An estimate that is slightly low is safer than one that is aggressively high. Low estimates keep your planning honest.
The Worked Example
Run a simple version to see the logic.
Assets: checking 4,300, savings 12,800, brokerage 27,400, 401(k) 51,200, car 9,500. Total assets 105,200.
Liabilities: credit card 1,900, student loan 14,500, car loan 6,300. Total liabilities 22,700.
Net worth is 105,200 minus 22,700, which equals 82,500.
That is the number to watch. If three months later net worth is 84,000, you have progress. If it is 81,000, something needs attention, either spending, repayment, or market movement. The sheet tells you the direction and the size of the change.
The Formula Setup That Keeps the Math Honest
Use a sum formula at the bottom of each block and make the net worth cell reference those totals. Never type the net worth number by hand. Manual entries invite stale numbers and arithmetic mistakes.
Add a valuation date column to every row. Not every account updates on the same day, so a date tells you which balance is fresh and which one is old. Add a note column as well. A note like statement or market estimate explains how you priced the item. Six months later, that note keeps you from treating a rough guess as a firm number.
How Often to Refresh the Numbers
Update your cash and investment accounts monthly. Update real estate and vehicle values quarterly unless there is a major market shift. Run the whole sheet on the same day each month. Thirty minutes is enough.
Do not update daily. Daily tracking makes a long term tool feel like a slot machine. The number moves, and most of the movement is noise. Monthly refresh is calm, consistent, and actionable. If you are about to apply for a loan, refinance, or make a major purchase, update the sheet before the decision. That is when current numbers matter.
The Danger of Counting the Wrong Numbers
Most errors are classification errors, not math errors.
Do not count the same dollar twice. If a portion of your brokerage account sits in cash, it belongs in that brokerage row, not as a separate cash row. Do not include a bonus that has not hit your bank account. Money you expect is not an asset yet. Do not include an inheritance still in probate. If you cannot access it today, it does not belong in net worth.
On real estate, list the house on the asset side and the mortgage on the liability side. That is correct. The difference is equity. The failure to list the mortgage is what makes the number wrong.
Cash value life insurance can be included at its surrender value. Term life has no cash value and should not appear. A pension is a future income stream, not a current asset. If you want visibility, add it as a separate line, calculated on your own assumptions, but keep it out of the main net worth total. Social Security is the same. The spreadsheet gets more accurate when it only counts money you can convert to cash today.
When the Number Is Negative
A negative net worth is not a reason to stop tracking. It is the exact reason to start. Many people begin with student loan balances larger than their account balances. That shows up as a negative number. The spreadsheet turns that situation from a vague source of stress into a specific gap. You can measure the gap every month. You can watch it shrink as you pay down principal and build savings. The day it crosses zero is quotable and real. If you never track it, that day has no date.
What Net Worth Does Not Tell You
Net worth is a stock, not a flow. It shows what you have at this moment, not how much you added through your own effort. A rising stock market can push net worth up even when you saved nothing. A correction can push it down even when you did everything right. That gain that lives only on your screen is a paper gain until you sell it.
That is why you should track contributions separately. Create a row or a tab for new money added to savings and investments each month. When net worth climbs, you can tell which part came from your behavior and which part came from market movement. That protects you from false confidence in bull markets and false guilt in bear markets.
Net worth is also not a report card on your worth as a person. It measures financial position only. It does not measure your work ethic, your generosity, or your value to the people around you. The spreadsheet is a tool, not a mirror.
The Takeaway and the Risk
Build the spreadsheet now with imperfect numbers. Put in the balances you have, the debt you know, and the property you can price. An approximate total is fine for the first month. The accuracy compounds with each update.
The risk is hidden in your assumptions. If you price assets like an optimist and liabilities like a procrastinator, the spreadsheet will be a polished lie. The formula cannot fix bad inputs. Update monthly, value assets at realistic sellable prices, classify every account correctly, and the net worth spreadsheet becomes one of the most valuable financial pages you own. It cannot tell you the future, but it will keep score.
Leave a Reply