Upon request from a reader, I thought I would discuss how I built a simple net worth worksheet that quickly calculate my net worth every 6 months. You can build this for yourself at home – and you don’t even need to spend the money to buy fancy application. I use Microsoft Excel (unless you want to – it’s a fine spreadsheet, but there are pretty good free options)!
In accounting, net worth is defined as assets minus liabilities. Essentially, it is a measure of what an entity is worth. For an individual, it represents the properties owned, less any debt the person has.
You may own a car or a home—or have money in the bank. Add it all up, and it can seem substantial. But to truly know what you own, you have to factor in what you owe.
The combination of what you own (your assets) and what you owe (your liabilities) makes up your personal net worth.
ASSETS – LIABILITIES = NET WORTH
Knowing your net worth is important for two reasons:
- It lets you understand your current financial situation.
- It gives you a reference point for measuring progress toward your financial goals.
Ideally, as you continue to earn and save, your net worth will grow. If your net worth is low or in the red, you’ll need to work on saving more and spending less. To watch your progress, calculate your net worth now and recalculate it once or twice a year.
How to review and calculate your personal net worth statement.
Setting up a net worth statement is as easy as creating a simple checklist and doing some basic maths.
1. List your assets (what you own), estimate the value of each, and add up the total. Include items such as:
- Money in your bank accounts
- Value of your investment accounts
- Your car / motorcycle
- Your Pension savings (Jamsostek/DPPK/DPLK)
- Market value of your home
- Business interests
- Personal property, such as jewelry, art, and furniture
- Cash value of any insurance policies
2. List your liabilities (what you owe) and add up the outstanding balances. Include items such as:
- Car loan
- Credit card balance
3. Subtract your liabilities from your assets to determine your personal net worth.
Below is the sample net worth worksheet that I use to calculate personal net worth for my client. Your net worth is just a starting point to have something to compare against in the future.
Below is the sample of a personal net worth calculation:
- Cash: Rp 100.000.000
- Investment & JAMSOSTEK: Rp 300.000.000
- House: Rp 1.500.000.000
- Personal Jewelry: Rp 100.000.000
- Car: Rp 300.000.000
- Life Insurance : Rp 500.000.000
- Total Asset: Rp 2.800.000.000
- Mortgage (KPR) : Rp 1.100.000.000
- Vehicle: Rp 200.000.000
- Credit Card: Rp 100.000.000
- Total: Rp 1.400.000.000
Each person’s financial situation and goals are unique and it is difficult to establish a generic ideal net worth that applies to everyone. You will have to determine your ideal net worth – where you want to be in the near-term and long-term future.
Your ideal net worth may be much more or much less than the amount indicated by the guideline, depending on your lifestyle and goals.
Have you done your personal net worth calculation this year?