Skip to Content
ToolsNet worth worksheet

Net worth worksheet

This worksheet walks you through adding up everything you own, everything you owe, and the difference between them. Print it or copy the tables into a spreadsheet, then fill it in from your latest statements.

What this measures

Your net worth is everything you own minus everything you owe, measured on one date and reduced to one number. Everything you own is your assets: cash, accounts, property, and anything else with a resale value. Everything you owe is your liabilities: loans, balances, and any other debt with your name on it.

It is the starting point of Take stock, the first step of the planning process, because every later decision needs to know where you are starting from. Goals are set against it, and progress is measured from it.

Before you start

A few decisions made now keep the worksheet honest.

  • Pick one date. Every figure on the page should be as of the same day, usually the closing date of your most recent statements.
  • Gather the latest statement for each account. Use the statement, not your memory of it. Log in to anything you have not checked in a while.
  • Use today’s market value, not what you paid. A home is worth what a buyer would pay this month, a car what a private sale would bring, an investment what it closed at on your date. Purchase price is history.
  • Round to the nearest hundred. Precision to the dollar takes time and adds nothing.
  • Decide whose net worth this is. One person or one household, chosen up front and kept the same throughout. For a household, list joint accounts and joint debts once, and each person’s own accounts as well.

What you own

List every asset under its category. One example row is filled in for each category to show what belongs there; the values are made up. Add as many rows as you need.

Cash and equivalents means money you could spend this week: checking, savings, and money market balances. Deposit insurance protects those balances up to a federal limit per depositor at each bank (see this year’s figures). Investment accounts can be sold from at any time; retirement accounts carry tax rules on when you can take money out. For a home or a vehicle, use a value you could defend to a stranger, not the one you hope for.

ItemValueNotes
Cash and equivalents
Checking account$4,000Statement balance
Investment accounts
Brokerage account$15,000Value on the date
Retirement accounts
Workplace retirement plan$60,000Balance on the date
Home and other property
Home$300,000Recent local sales
Vehicles
Car$12,000Private-sale value
Other things of value
Jewelry$2,000Resale value
Total owned

Leave out anything you could not actually sell. Furniture rarely brings much, and a pension is a stream of income rather than a balance.

What you owe

List every liability the same way. Use the payoff balance shown on the statement, not the monthly payment and not the original loan amount. Include debts to people as well as debts to institutions: a loan from a relative is still a loan. Tax you know you owe but have not paid belongs here too.

ItemValueNotes
Mortgage
Home mortgage$240,000Payoff balance
Vehicle loans
Car loan$8,000Payoff balance
Student loans
Student loan$20,000All loans combined
Credit cards
Credit card$3,000Statement balance
Other debts
Loan from a relative$5,000Due next year
Total owed

The result

Add up each table, then subtract the second total from the first.

LineAmount
Total owned$
Total owed$
Net worth$

Using the example rows above, the assets add up to $393,000 and the debts to $276,000, so the example net worth is $117,000. If your total owed is larger than your total owned, the result is negative. Write it down anyway, minus sign and all. It is a number, not a grade.

What the number does and does not tell you

A negative net worth is common early in adult life and means nothing by itself. A recent graduate with student loans often starts below zero, and a new homeowner may sit near zero for years. The number says where you are, not where you are headed.

The trend across dates matters more than the level. One figure is a photograph. Two, a year apart, show direction, and direction tells you more than either number alone. Keep every worksheet you fill in.

Not every dollar on the page is a dollar you could spend. A tax-deferred account owes income tax on the way out, so its spendable value is less than its balance; Tax efficiency explains how each kind of account is taxed. Retirement runway covers how those balances turn into income over time. A home is worth its full value only when sold, and selling costs money and takes time.

A large asset with a matching loan nets to little. In the example, the $300,000 home and the $240,000 mortgage together add $60,000 to net worth, not $300,000. Owning a big thing and owning it outright are different, and the worksheet shows the difference.

What to do with it

Carry the two totals and the result into Take stock, where they join your income, spending, insurance, and documents to complete the picture. The net worth figure is the baseline that later reviews are measured against.

Repeat the worksheet once a year, on roughly the same date, or sooner after a major change: a home bought or sold, a new job, a marriage or divorce, an inheritance, or a large debt paid off.

Net worth is a balance. The other half of taking stock is cash flow, the money coming in and going out each month. The cash flow worksheet walks you through it the same way.

For advisors

A client’s self-prepared net worth statement is a starting point for the first meeting, not a figure to enter into a plan. Walk through it line by line against source documents, and expect to correct the usual things: purchase price where market value belongs, balances from different dates, a home valued at hope, and debts left off because they are informal or embarrassing. Retirement accounts usually appear at gross balance with no note of the tax owed on withdrawal, and jointly held items are often counted for one spouse or both without saying which. Record the statement date, the source of every figure, and which lines are estimates. The corrected version becomes the baseline for every later review, so date it and keep the client’s original alongside it.