How to Calculate Net Worth: A Simple Guide with a Free Template

Let’s talk about something that can change how you think about money: your net worth.

You might be earning a good income, paying your bills on time, and even putting some money aside every month. But have you ever stopped to ask yourself how much wealth you’re actually building?

Maybe your salary has increased, but you don’t feel much further ahead financially.

Or perhaps you’ve never looked at how to calculate net worth because it sounds complicated, time-consuming, or a little uncomfortable.

Here’s the thing: calculating your net worth isn’t about judging your financial situation. It’s about understanding it.

Once you know where you stand, you can make more informed decisions about where you want to go.

And the good news? You don’t need complicated financial software or an accounting background to get started. A simple spreadsheet and a few minutes of your time are enough.

Let’s break it down, step by step, using a simple net worth template you can create in Google Sheets or Excel. All figures in this guide are illustrative, and the method works the same in any currency.

What Is Net Worth?

Net worth is the value of everything you own, minus everything you owe. Accountants would recognise it as a personal balance sheet: assets on one side, liabilities on the other, and the difference between them.

That’s all net worth means. It isn’t your salary, and it isn’t the balance of your everyday account. It’s the financial position you’d be left with if every asset were counted at a realistic value and every debt were settled.

The Net Worth Formula: How to Calculate Net Worth in One Line

Calculating your net worth comes down to one straightforward formula:

Total Assets − Total Liabilities = Your Net Worth

In plain English, take everything you own that has financial value, subtract everything you owe, and the difference is your net worth.

For example, imagine you have $420,000 in assets and $185,000 in liabilities.

Your net worth would be $235,000.

That’s it. No complicated calculations required.

But here’s something worth remembering: your income and your net worth tell two different stories.

Your income shows how much money you earn. Your net worth shows the difference between what you own and what you owe.

You can earn a high salary without building much wealth. Equally, someone with a modest income may gradually build a strong financial position by saving consistently, managing debt, and making thoughtful decisions.

That’s why I believe calculating your net worth is a useful starting point for understanding your financial position. 

If you’d like to explore the difference between income and wealth further, read what wealth really means.

This is where a balance sheet tells a more honest story than a payslip. A payslip shows what comes in; a balance sheet shows what has been kept. Accountants look at both when they assess a business, and the same discipline works for a household. Income tells you about this year. Net worth tells you about every year that came before it.

Getting Started: Download Your Free Net Worth Template

Download the free Net Worth Worksheet: [Download the free Net Worth Worksheet]. It includes a step-by-step guide, a ready-made worksheet that calculates your totals automatically, a completed example and a tracker for future reviews. It works in Excel and Google Sheets.

Prefer to build your own? You don’t need an elaborate system to keep track of your finances.

I prefer starting with something simple. Open Google Sheets or Excel and create a spreadsheet with four columns:

• Item: What you’re recording, such as a savings account or mortgage.
• Category: Whether it is an asset or a liability.
• Current value: What it’s worth or how much you still owe.
• Source: Where you found the figure, such as a bank statement or investment account.

You can also add a date at the top of your spreadsheet so you know exactly when the figures were recorded.

Here’s an example of how your template might look:

In this example, total assets are $52,000, while total liabilities are $5,000. Your net worth is $47,000.

You can add more rows as needed and use simple spreadsheet formulas to calculate your totals automatically.

Before you start entering figures, make two decisions.

First, choose whether you’re calculating your individual net worth or your household’s combined net worth. Second, use the same currency and valuation date throughout.

These small steps help keep your calculations consistent and make future comparisons much easier.

Step 1: List Everything You Own

Let’s start with the positive side: your assets.

An asset is something you own that has financial value. Some assets are easy to value because their balances are readily available. Others require a little more thought.

The goal isn’t to list everything you have ever purchased. It’s to identify the assets that meaningfully contribute to your financial position.

Start with the easy ones

Open your banking and investment apps and look at your latest balances.

Include things such as:

• Cash and money in bank accounts.
• Savings accounts and term deposits.
• Shares, bonds, and managed funds.
• Retirement savings, such as a workplace pension, 401(k) or KiwiSaver account.
• Other investments you own.

Use the actual balances shown on your statements or accounts as at your chosen date.

Remember to count only assets you own. Expected future earnings, possible bonuses, and money you hope to receive aren’t part of your current net worth.

What about your house and car?

Property and vehicles can make up a significant portion of someone’s assets, but their current value may be different from what they originally cost.

Your house might have cost $600,000 when you purchased it. That doesn’t automatically mean it’s still worth $600,000 today.

Look at recent comparable property sales or obtain a reliable valuation to estimate its current market value.

The same principle applies to your car. Its value depends on factors such as its age, condition, mileage, and current market demand.

And don’t forget valuable personal belongings. Jewellery, collectibles, or other items with meaningful resale value may be worth including.

You don’t need to calculate the resale value of every chair, appliance, or piece of clothing. Focus on items that would make a meaningful difference to your overall position.

The important thing is to use realistic current values, not the prices you paid or the amounts you wish the assets were worth.

Don’t forget jointly owned assets

If you own a house with your partner, decide how much of its value belongs in your individual calculation.

For example, if you own a 50% share of a property valued at $800,000, your share is $400,000.

Apply the same principle to jointly owned savings, investments, and relevant debts. The exact treatment can depend on the ownership arrangements, so keep your approach consistent.

Step 2: Face the Liabilities

Now for the part people sometimes prefer to avoid: everything you owe.

A liability is a debt or financial obligation that reduces your net worth. Ignoring smaller balances might make your financial position look better on paper, but it won’t make the debt disappear.

Start by gathering your latest loan statements and account balances.

Your list may include:

• Outstanding mortgage balances.
• Student loans.
• Car loans.
• Credit card balances.
• Personal loans.
• Buy now, pay later balances.
• Other outstanding debts and relevant financial obligations.

Use the amount you still owe, not the original amount you borrowed.

For example, if you borrowed $30,000 for a car and have already repaid $18,000 of the principal, you would generally record the remaining loan balance, rather than the original $30,000.

The same applies to your mortgage. Record the outstanding balance, not the amount you initially paid for the property.

Avoid this common mistake

Let’s say your car is currently worth $12,000 and you still owe $4,000 on the loan.

You should record:

• Car value under assets: $12,000.
• Outstanding car loan under liabilities: $4,000.

Your net contribution from these two items is $8,000.

Don’t record the car as an asset worth $8,000 and then subtract the $4,000 loan again. That would count the debt twice and make your net worth appear lower than it actually is.

Once you’ve listed everything, review your records carefully. Check for forgotten credit card balances, duplicate entries, and debts that may not appear in your everyday banking app.

Being thorough now will give you a more reliable picture later.

Step 3: Calculate Your Net Worth

You’ve listed what you own and what you owe. Now it’s time to put the numbers together.

Add up the current values of all your assets. Then calculate the total of all your outstanding liabilities.

Finally, subtract the second figure from the first.

Total Assets − Total Liabilities = Net Worth

Let’s use a more detailed example.

Imagine your spreadsheet contains the following figures:

In this example, the calculation is:

$639,000 − $187,000 = $452,000.

Your net worth is $452,000.

The figures above are illustrative, not a financial benchmark or a target you need to achieve. Your own numbers will depend on your circumstances, including your income, assets, debts, and stage of life.

And remember, your spreadsheet doesn’t need to look perfect. What matters is that the figures are accurate, the categories are clear, and the calculation is consistent.

Step 4: Understand What Your Net Worth Really Means

Once you’ve calculated your net worth, you might be tempted to focus entirely on the final number.

But the number alone doesn’t tell you everything you need to know.

What if your net worth is positive?

A positive net worth means your assets are worth more than your liabilities.

That’s a useful starting point because it shows that, on paper, your assets exceed your debts.

However, it doesn’t automatically mean you have plenty of money available to spend. Much of your wealth might be tied up in property, investments, or retirement savings that you cannot readily access.

What if your net worth is negative?

A negative net worth means your liabilities exceed your assets.

That might feel discouraging, but it isn’t a verdict on your financial future.

Someone who has recently taken out a student loan or purchased a home may have a very different financial situation from someone accumulating high-interest consumer debt.

Instead of judging yourself by the result, look at what’s contributing to it.

Are your debts gradually decreasing? Are you building savings? Are there expenses or financial commitments you need to understand better?

These questions can help you identify what deserves your attention.

Remember that net worth isn’t the same as available cash

Imagine owning a property worth $700,000 with a mortgage of $400,000.

The property contributes $300,000 to your net worth before considering other assets, liabilities, and any costs associated with selling.

But that doesn’t mean you have $300,000 sitting in your bank account.

Property can take time to sell, and retirement savings may have access restrictions. Investments can also fluctuate in value.

That’s why it’s useful to understand both your overall net worth and how much money you can access when you need it.

Step 5: Track Your Progress Over Time

Here’s where calculating your net worth becomes particularly useful.

One calculation tells you where you stand today. Repeating it periodically helps you understand how your financial position is changing.

Save your spreadsheet with the date clearly recorded. Then review your net worth every six to twelve months, or more frequently if you have a specific reason to monitor it.

When you compare your results, ask yourself a few simple questions.

• Have my savings increased?
• Have I paid down any outstanding debts?
• Have my investments or property changed in value?
• Have I taken on new financial commitments?
• What explains the difference between my latest figure and the previous one?

Your net worth might increase because you’ve saved more, repaid debt, or benefited from changes in asset values. It might also decrease because you’ve made a major purchase, taken on new debt, or experienced a fall in investment values.

A change in either direction doesn’t automatically tell you whether you’ve made good or bad decisions. Understanding what caused the change is more useful than simply celebrating a higher number or worrying about a lower one.

Over time, this record can help you see patterns and make more deliberate decisions about your financial priorities. When you’re ready to think about what comes next, how to become wealthy through better decisions is a good place to start.

Net Worth: Common Questions

How do you calculate your net worth?

List everything you own at its current value, list everything you owe at its outstanding balance, then subtract the total liabilities from the total assets. The result is your net worth.

What is the net worth formula?

Total assets minus total liabilities equals net worth. Everything else in this guide is about getting those two totals right.

How do I determine my net worth if I own assets jointly?

Include only your share. If you own half of a property, count half its value and half of any shared debt secured against it. Whatever approach you choose, use it every time so your results stay comparable.

How often should I calculate my net worth?

Every six to twelve months is enough for most people. Calculating it too often can turn normal market movements into unnecessary worry.

Is there a net worth calculator I can use?

A spreadsheet like the one above works well and keeps the numbers in your hands. If you’d prefer an online tool, Ramsey Solutions has a free net worth calculator that can do the arithmetic for you. Either way, the value comes from understanding the figures, not just producing the total.

Conclusion

Calculating your net worth doesn’t need to be complicated or uncomfortable.

Start by listing what you own, record what you owe, and subtract your total liabilities from your total assets. A simple spreadsheet is enough to get started.

Then save your results and revisit them periodically. Look beyond the final number to understand what’s changing and why.

Your net worth isn’t a measure of your worth as a person. It’s a snapshot of your financial position.

The goal isn’t to compare yourself with someone else or chase an arbitrary number. It’s to understand where you stand today so you can make more informed decisions about tomorrow.

Start with the information you have, keep your records consistent, and build from there. Sometimes, the most useful financial step isn’t earning more money. It’s understanding what you already have.