0

How to Setup an Assets Spreadsheet

PUBLISHED Apr 6, 2022, 12:22:59 PM        SHARE

img
imgStaff Writer

How to Setup a Net Assets Spreadsheet

The key step in personal finance is knowing the truth of your financial situation. You can monitor your financial situation using basic math and a spreadsheet. When you can measure your financial health, you can then take steps to improve your finances.

You can setup an assets spreadsheet using Google docs or Microsoft excel. In this guide, we'll walk step-by-step on how to setup a successful net assets spreadsheet.

Set up spreadsheet

Open a Microsoft excel sheet or a Google Docs sheet.

Label the first column date. We will be updating this sheet once a week, so the date will correspond to a day of the week. We suggest Saturday as a good day to update your sheet.

Your flexible expenses tend to be spent on the weekend. Go into the weekend knowing your financial health. This will help your spending choices like eating out or seeing a movie.

In the next columns, add bank accounts, brokerage accounts, and retirement accounts. Each account will have its own separate column. Do not add a column for cash. These columns are your assets.

Next, add a column for your liabilities. Have a column for:

  • Each credit card (with the interest percentage)
  • Mortgage
  • Car Loan (not leasing amount)
  • Your student loan

Illiquid Assets

Add the following items to your asset category. These will be illiquid assets:

  • Value of car
  • Value of house

The value of your house minus the remainder of your mortgage is your home equity. When you sell your house this is cash you will receive.

The value of your car will depreciate over time while your house value will increase. Use kelley blue book to find the estimated value of your car.

Use Zillow to find the estimated value of your house. Check these values quarterly, as they will not dramatically change week over week.

Net Asset Calculations

Finally, in the last column we will setup a calculation. This calculation will give you a snapshot of your net assets.

In the last column, label it "Net Assets". In the first row beneath this column, place an equals sign. Then, click the first asset in this row. The cell coordinates will show after the equals sign. Add a plus sign after the coordinates. Continue this pattern until you get to the liabilities. Liabilities will have a negative sign. Your final calculation will look something like this:

=B2+C2+D2+-E2-F2-G2-H2

This is your total net assets.

Emergency Savings

Add together all the liquid assets you have. This will be savings accounts and stock accounts. These assets can be used for an emergency within a day.

Easy to Use Template

You can get an example template based on this guide here.



Sound investments
don't happen alone

Find your crew, build teams, compete in VS MODE, and identify investment trends in our evergrowing investment ecosystem. You aren't on an island anymore, and our community is here to help you make informed decisions in a complex world.

More Reads
Personal Finance for Beginners
Image

You can manage your personal finance today in 6 easy steps

What does it Mean to Own a Stock?
Image

When you own stock in a company you are an owner of a corporation. You've delegated management to an executive team led by a Chief Executive Officer. Their goal is to make money for the investors, which you are one of. The investors elect a board of directors to govern the company.

A Beginners Guide to Stock Investing in 5 easy steps
Image

Thanks to technology, investing in the stock market is easier than ever. In this guide we'll walk through 5 easy steps you can do today to start investing.

How to Protect Your Facebook Account from Hackers
Image

Have you ever received a friend request from somebody you were already connected with, only to see that person post an update that says, ‘don’t accept any friend requests from me, I’ve been hacked’?

How to Increase Traffic to Your StockBossUp Content
Image

StockBossUp is financial media 3.0. Our mission is to build user wealth using knowledge and technology. Content creators are the key to building this knowledge. In this article we'll share how content trends so that you can earn a share of our growing audience.

Strong But A Little Tired
Image

Market Commentary

Common Mistakes Made by New investors
Image

The biggest mistake new investors make is not managing the risk of their investments. The stock market is a money machine and not a slot machine. Watching for these common mistakes can improve your risk management and build wealth.

What are Safe Investments?
Image

Safe investments have a low possibility of loss. This safety comes with a tradeoff as the return on safe investments will be lower.

What are Risky Investments?
Image

Risky Investments have a high probability of loss. Risky investments may have a high upside, but not all risky investments are bad investments.

How do you Avoid Buying High?
Image

Avoid buying stocks at their high by monitoring the current market value and measuring the intrinsic value of a stock versus its current price.

Crypto’s Role in the Russian-Ukraine War: Everything you need to know
Image

It is not news that Russia and Ukraine are not on good terms, and the former head of the Soviet Union has gone to war with Ukraine over claims of allegiance with NATO. Russia has received a lot of backlash from the international community over this. In this article, we will be looking at how Crypto has played a pivotal role in the Russia-Ukraine war.

5 Ways to Promote Your Side Hustle Now
Image

A side hustle is a business opportunity that’s usually alongside of full-time employment. The great thing about a side hustle is that it can develop into an opportunity that allows you to quit your regular job and pursue that business entirely.

Yuga Labs Launches ApeCoin and DAO: Here is what to expect.
Image

If you have been in the crypto space as long as we have, we are sure you wouldn’t be alien to the Bored Ape Yacht Club and Yuga Labs. In this article, we will explore the ApeCoin, a token that was recently launched by Yuga Labs and what the future holds for the Bored Ape Yacht community.

New Investor Tips
Image

These new investor tips help to answer questions most new investors ask when they first start investing.

How Much Cash Should I Have in My Portfolio?
Image

You should not have any cash in your investment portfolio. Cash is a depreciating asset and its better to hold bonds, precious metals, or safe ETFs during market sell-offs.

Who Buys Stocks When Everyone is Selling?
Image

When everyone is selling stocks, market makers, traders, and long term investors are on the other side buying at lower prices.

Is it Worth Buying Less Than One Share?
Image

Buying less than one share is worth it. Fractional shares help retail investors jump into investing. But it's important to know what you lose when you buy fractional shares.

Should I Buy Red or Green Stocks?
Image

You should never buy stocks just because they are green or red. Let's explain why stocks are colored this way and why they should not effect you investment decision.

OK, but . . .
Image

Market Commentary