• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Start Here
  • Work with David
  • Our Services
  • Contact
Young Adult Money

Make more. Save more. Live better.

  • Blog
  • Credit Cards
    • Rewards
    • Cash Back
    • Travel
    • Airlines
    • Hotels
    • Balance Transfer
    • Student
    • Business
  • FREE Budget Spreadsheet
  • FREE Student Loan Spreadsheet
This Just In... Check out the latest travel rewards credit card offers

How to Create a Net Worth Spreadsheet

By David Carlson / Last updated: May 17, 2020 / Budgeting, COVID, Debt, Download, How To, Personal Finance

We may receive compensation from companies mentioned within this post via affiliate links. Read our full advertiser disclosure. Opinions, reviews, analyses & recommendations are the author’s alone, and have not been reviewed, endorsed or approved by any of these entities.
Pin90
Share5
Tweet
Email
Buffer2
Share
97 Shares

 
A net worth spreadsheet can help you stay on top of your money. Here's how to create a net worth spreadsheet, including a free download.I used to not give much attention to my net worth.

That doesn’t mean I didn’t care about it. I was just more focused on increasing my income and lowering my expenses.

The way I see it, your net worth will continue to move in the right direction as long as you are consistently paying down debt, increasing your income (when possible), and keeping expenses at a reasonable level.

One thing changed where I focused my attention: COVID.

Since COVID took a hold in the United States, I’ve created a net worth spreadsheet – which you will be able to download for free later on – that I update almost every day.

Why do I do this? It gives me a sense of control.

I’m not alone. When there is uncertainty in the economy it is a natural tendency to look at your options. This is especially true if you are unemployed due to COVID but is also true even if you remain employed. We don’t know how the COVID story ends, so it makes sense to understand what cash you have available, what other assets you have at your disposal, and what debt is on your books.

Regardless of the reason you want to track your net worth, the good news is that it’s really easy to create a net worth spreadsheet. It doesn’t have to be complicated. It may require you to log into a bunch of accounts, but I think that’s a good thing.

I’m a big spreadsheet nerd and I like the control it offers. It’s worth mentioning that there is a more automated way to track your net worth.

Personal Capital is a tool that allows you to connect your bank and credit card accounts, among other things (student loans, car loans, mortgage) to automatically calculate your net worth. They use bank-grade security. It’s free and worth checking out. I use Personal Capital but since COVID have been using my spreadsheet since I want a bit more control.

Check out Personal Capital

 
For those who think like me…the way they make their money is through their Certified Financial Planner (CFP) services. They sent me regular communications until I emailed them a couple years ago and said I don’t want to be contacted by my assigned CFP. I haven’t been bothered by them since.

Let’s dive into the steps in creating a net worth spreadsheet.

 

How to Create a Net Worth Spreadsheet

 
Let’s get started creating our net worth spreadsheet. You can follow these steps or click here to jump to the bottom of the page where you can download a free template.

First, open a blank spreadsheet (thank you captain obvious).

The way I like to view my net worth is a tiered approach. We’ll start with cash. This is money in a checking or savings account.

Since COVID I have become a proponent of the jumbo emergency fund which is what I call a 12-month emergency fund. Having your cash in a separate section will make it easy to understand exactly how much you have in case of an emergency.

 
Net Worth Spreadsheet Cash

 
Next I recommend adding any non-retirement investments you may have. This could be any stocks, mutual funds, or vested employee stock.

The reason why I like adding this next is because if you become unemployed there’s a chance you will eventually exhaust your cash savings. While it’s not ideal to have little control over when you sell these investments, they are an additional safety net that can help you avoid going into debt while you are out of work.

 
Net Worth Spreadsheet Cash and NonRetirement Investments

 
One thing I do in my net worth spreadsheet is calculate how long my cash and investments will last me. In this example the $17k of cash would amount to approximately $3k/month if it was stretched across six months and $1.4k/month for twelve months.

But let’s include the non-retirement investments as well. If you group the cash and the non-retirement investments together and assume $3k/month of expenses, these assets would last you one year and seven months.

As I mentioned, since COVID I have changed my thinking on emergency funds. I now target twelve months worth of expenses for my emergency fund. In addition I have targeted an additional twelve months worth of expenses in no-retirement accounts.

 
Net Worth Spreadsheet with Emergency Fund

 
The next thing I like to add in is a Health Savings Account, or HSA. If you don’t know what an HSA is read our HSA Guide. If you have one and haven’t been contributing, now is a good time to evaluate whether or not that’s the right decision. I’m a big fan of Health Savings Accounts, especially for those in their 20s and 30s.

I list this as a third category because it’s an additional emergency fund, but it’s specific to medical costs. It’s still a great security blanket but it’s not quite as liquid as cash or non-retirement investments.

 
Net Worth Spreadsheet Cash NonRetirement HSA

 
Finally I add the estimated value of my house in the equation. This clearly leaves off things like vehicles and alternative investments like gold and bitcoin, and anything that you could potentially sell to create cash flow.

You can certainly include these assets in your calculation. I chose to leave our vehicles off because of how unpredictable things are with COVID.

 
Net Worth Spreadsheet Assets

 
Next we will move on to debt. In the first section I recommend including things like credit card debt, personal loans, auto loans, and a mortgage if you have one.

 
Net Worth Spreadsheet Debt No Student Loans

 
Where this gets interesting is with student loan debt.

If you are pursuing student loan forgiveness, either through Public Service Loan Forgiveness (PSLF) or Income-Driven Loan Forgiveness, I think it can be extremely motivating to carve out that debt separately.

After all, if you are going for PSLF the debt should, in theory, be forgiven tax-free. While it hasn’t happened yet, you should be using that future state of your finances as motivation to stick with the plan of achieving loan forgiveness.

 
Net Worth Spreadsheet Debt with Student Loans

 
And that’s all there is to it! You can download a copy of the net worth spreadsheet for free below.

You may also want to check out how to create a budget in a spreadsheet as well as my automated budget spreadsheet (free to download).

Join our Online Community to Receive your FREE Net Worth Spreadsheet


 

Check out some of our favorite personal finance resources:

Are you getting the best credit card rewards? Check out the top cash back credit card offers (updated daily)

Make extra money: 15 ways to make money from your computer

  • Get our FREE Automated Budget Spreadsheet and our Student Loan Spreadsheet

Get the First Chapter Free!

Student Loan Solution Cover - 3D

Join our online community and get the first chapter of the book Student Loan Solution absolutely FREE!

Pin90
Share5
Tweet
Email
Buffer2
Share
97 Shares

David Carlson

David Carlson is the founder of Young Adult Money. He is a nationally recognized speaker and the author of Student Loan Solution (2019) and Hustle Away Debt (2016). His opinions have been featured on such media outlets as The New York Times, The Washington Post, Cheddar, NBC's KARE11, and more.
Connect:

Comments Policy

Comments, responses, and other user-generated content is not provided or commissioned by this site or our advertisers. Responses have not been reviewed, approved, or otherwise endorsed by this website or its advertisers. It is not the responsibility of advertisers or this website to ensure that all comments and/or questions are answered. With all that being said, please comment away!

Primary Sidebar

Credit Cards

  • Best Travel Rewards Cards
  • Best Balance Transfer Cards
  • Best Cash Back Credit Cards
  • Best Business And Side Hustle Credit Cards
  • Best Student Credit Cards

Start a Blog:

How to Start a Blog that Makes Money
 

Top Posts

  • 15 Ways You Can Make Money From Your Computer Right Now
  • When You Should and Shouldn’t Refinance Student Loans
  • How Much Money You Will Need to Make $1,000 in Dividends

Free Spreadsheets & Downloads

  • Free Automated Budget Spreadsheet
  • Student Loan Repayment Spreadsheet
  • The Ultimate Personal Finance Checklist
  • 401k Spreadsheet to Analyze your Options
  • Wedding Budget Spreadsheet
  • 52 Week Money Challenge Spreadsheet and Printable

First Chapter Free!

Join our online community and receive the first chapter of Student Loan Solution absolutely FREE.

If you don't see the email in your inbox, please check your spam folder.

Connect:

Categories:

Search:

Get the New Book!

Student Loan Solution: 5 Steps to Take Control of Your Student Loans and Financial Life is available on Amazon by clicking here, or by clicking on the graphic below.

Make more. Save more. Live better.

Site Directory:

  • About
  • Contact
  • Advertise
  • Recommendations
  • Finance Tools
  • Credit Cards
  • Insurance
  • Banking
  • Investing

Disclaimer | Privacy Policy

Feedback? Questions?
Contact us and let us know what you think.

Connect:

Search This Site:

Copyright © 2012–2024 Young Adult Money, LLC / All Rights Reserved
Designed by LizTheresa.com / Developed by Nuts and Bolts Media

Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Statistics

Marketing

Features
Always active

Always active
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}
Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}