Why Track Your Net Worth?
Your net worth is the single most important measure of your financial health. It’s the total value of everything you own (your assets) minus everything you owe (your liabilities). Tracking it provides a clear, honest snapshot of your financial position.
It helps you measure progress over time, make better financial decisions, and stay motivated. Seeing the number grow as you pay off debt or build savings is a powerful reinforcement of good financial habits. For a recent graduate, who may start with a negative net worth due to student loans, tracking this figure is not about judgment; it's about establishing a starting point for a journey toward financial stability and wealth creation.
Setting Up Your Spreadsheet
You don’t need fancy software; a simple spreadsheet in Google Sheets or Microsoft Excel is perfect. Create a new sheet and structure it with your financial items listed in rows down the first column. Across the top, create columns for your asset and liability categories, followed by five value columns labelled: 'Q1 (Jan-Mar)', 'Q2 (Apr-Jun)', 'Q3 (Jul-Sep)', 'Q4 (Oct-Dec)', and 'Annual Change'. This quarterly structure encourages regular check-ins without making it a daily obsession. The goal is to see the trend over time, and a quarterly snapshot is ideal for this.
Listing Your Assets
Assets are resources with economic value that you own. For a fresh graduate in India, these will be straightforward at first. In your spreadsheet, create rows for common assets under a main 'Assets' heading. These should include: Cash and Bank Balances (Savings and current accounts), Investments (like mutual fund SIPs, PPF, EPF, and any direct stocks), and Physical Assets (the realistic resale value of a vehicle, laptop, or gold). Don't worry if this list is short to begin with. The purpose of this exercise is to build a foundation that will grow as your career progresses.
Accounting for Your Liabilities
Liabilities are what you owe to others. It's crucial to be honest and thorough here. Under a 'Liabilities' heading in your spreadsheet, list all your debts. Common liabilities for young Indians include: Education Loans (list the outstanding principal), Credit Card Debt (any balance you carry month-to-month), Vehicle Loans, and any personal loans or money borrowed from family. For each quarter, you will update the outstanding balance of each loan. Watching these numbers decrease is one of the most satisfying parts of tracking your finances.
The Magic Formula: Calculating Net Worth
At the bottom of your 'Assets' section, create a row called 'Total Assets' and use the SUM function to add up all your asset values for each quarter. Do the same for your liabilities, creating a 'Total Liabilities' row. The final step is the net worth calculation itself. Below everything, create a bolded row named 'Net Worth'. The formula in this cell for each quarter is simple: Total Assets - Total Liabilities. Your spreadsheet will now automatically calculate your net worth each time you update your asset and liability figures.
The Quarterly Review Habit
This framework is designed for a quarterly rhythm. At the end of every March, June, September, and December, set aside 30 minutes to update your sheet. Log into your bank, investment, and loan accounts, and input the current values. This regular check-in does more than just update a number; it forces you to confront your financial reality. Are your savings growing? Is your debt shrinking? This habit builds financial awareness and helps you course-correct if your spending gets off track or if you want to accelerate your goals. The 'Annual Change' column will clearly show your progress year on year, which is a fantastic motivator.
