Excel calculator · Fillable PDF · Word · Letter & A4

Free Net Worth Worksheet (Excel Calculator, Fillable PDF, Word)

Net worth is one number: everything you own minus everything you owe. It is the figure that tells you whether the year's saving, paying down and investing moved you forward, and it is what a lender or a financial planner asks for first. This worksheet lists the usual assets and liabilities so nothing is forgotten, totals them, and comes in a yearly tracker version so the same sheet shows the trend.

Formats
Excel, PDF, Word, ODS, ODT
Paper
US Letter and A4
Calculates
Yes, in Excel and ODS

Updated November 8, 2026

Filled-in example of the Net worth statement design
Filled-in example: Net worth statement. The downloads are blank and fillable.

Choose a design

3 Net Worth Worksheet designs, each in five file formats

Every design comes as a fillable PDF for US Letter and A4, a Word document and an Excel workbook. OpenDocument versions (ODT, ODS) are the same layouts for LibreOffice and OpenOffice users.

Net worth statement - filled-in example

Net worth statement

Fifteen asset lines and twelve liability lines with the common items pre-labelled, each with an institution or notes column, totals for both, and net worth calculated at the bottom. A personal balance sheet on one page.

OpenDocument: ODT · ODS

Net worth tracker, year by year - filled-in example

Net worth tracker, year by year

Asset and liability categories down the side, five year-end columns across. Excel totals each column, calculates net worth per year and the change from the year before. Landscape.

OpenDocument: ODT · ODS

Simple net worth calculator (large print) - filled-in example

Simple net worth calculator (large print)

Eight asset lines and six liability lines in a larger type size with wide boxes, for people who want the number without the detail: a quick annual check-in or a teaching sheet for a teenager or a personal finance class.

OpenDocument: ODT · ODS

All files are free for personal, household, classroom and internal business use. The PDFs are fillable in Adobe Reader, Chrome, Edge, Firefox and Preview; they do not calculate totals. The Excel files calculate line amounts and totals for you.

What is on the net worth worksheet

Assets
Everything you own that has a resale value: account balances, investments at today's price, your home at what it would sell for, vehicles at private-sale value. Use current values, not what you paid.
Retirement accounts
Include the full balance of 401(k), 403(b), IRA and similar accounts even though taxes are due on withdrawal; most planners count them at face value and note the tax separately. A defined-benefit pension can be left out or counted at its cash value if the plan states one.
Home value
A recent appraisal, or the average of two online estimates. Do not count the equity here; list the full value as an asset and the mortgage as a liability. The difference is your equity.
Vehicles and valuables
What a private buyer would pay this month, not the insured value. Furniture and electronics are usually left out: they sell for a fraction of their cost.
Liabilities
Every balance you owe today: mortgage, car loan, student loans, credit cards (the statement balance, even if you pay in full), personal loans, taxes due. Not monthly payments; balances.
Net worth
Total assets minus total liabilities. A negative number is common early on (student loans, a new mortgage) and is not a crisis; the direction of change year to year is what matters.

Why track net worth rather than income

Income measures the flow of money in; net worth measures what stays. Two households with the same salary can be in very different positions after ten years depending on what they saved, what they borrowed and how their assets grew. Checking the number once a year, on the same date, shows whether the extra mortgage payments, the 401(k) increase or the car purchase moved it the way you expected. It also surfaces things a budget hides: a growing credit-card balance that is being serviced but not shrinking, or a car that lost a third of its value.

Lenders ask for essentially this document when you apply for a mortgage or a business loan (a personal financial statement), and a financial planner starts from it. Keeping one updated saves an afternoon of digging through accounts when you need it.

How to fill it in

  1. Pick a date (year end, or your birthday) and use balances as of that date. Log into each account; do not estimate.
  2. Assets: enter current balances and current market values. For the home, use one method every year so the change is real, not a change in estimate.
  3. Liabilities: enter the payoff balance from each lender's statement, including the credit-card balance even if you will pay it off next week.
  4. Read the totals and the net worth line. In Excel the three are calculated; on paper, add each column and subtract.
  5. Write the number in the yearly tracker, and note anything that explains a jump (bonus invested, car bought, market drop).
  6. Keep the statement with your tax records. Next year, start from this one.

What to leave out

  • Future income, inheritances, or the value of your degree. Net worth is what you could liquidate today.
  • Household contents and clothing, unless genuinely valuable and insured as such.
  • Frequent-flyer miles and reward points.
  • Expected tax refunds, unless already filed.
  • A business you own, unless you can defend the value (a recent offer, a multiple of earnings, or book value).

Reading the result

Compare yourself with yourself. The median US household net worth is around $190,000 (Federal Reserve Survey of Consumer Finances, 2022 data) and varies enormously by age, so national figures are of limited use. More useful: is net worth growing by at least what you saved this year? If not, an asset fell in value or a debt grew. Is the share of your net worth in your home above 70%? Then you are house-rich and cash-poor, and the emergency fund line deserves attention. Are liabilities falling every year? Those are the questions a planner asks of this page.

Editing the Word and Excel versions

In Excel the totals and net worth are formulas; add lines inside a section and the sums still include them if you insert rows above the total. Rename the pre-filled asset and liability labels to your own accounts. The yearly tracker calculates each year's totals and net worth; replace "Year 1" to "Year 5" with actual years. The budget planner handles the monthly flow that moves these balances, and the debt payoff tracker follows the liabilities side in detail.

Questions

What counts as an asset?

Anything you own that could be sold or withdrawn for money: bank balances, investments, retirement accounts, property, vehicles, business interests, valuables with a resale market, and money others owe you. Use current values.

Should I include my house in net worth?

Yes, at its current market value, with the mortgage listed separately under liabilities. Some people keep a second figure excluding the home ("liquid net worth") because they cannot spend the house; the worksheet makes both easy to read.

Should I include my car?

Yes, at private-sale value, with any loan under liabilities. A car usually shows negative equity for the first years of a loan, which is useful to see.

How often should I calculate net worth?

Once a year is enough for most people, on the same date. Quarterly if you are paying off debt aggressively and want the motivation. Daily tracking is noise.

Is a negative net worth bad?

It is common in your twenties and after buying a first home with a small down payment. What matters is that it rises each year. If it is falling while your income is steady, the budget planner will show where.

Related printables

Templates that go with this one

Documents from the same workflow. Each has its own designs and file formats.