What Is Net Worth and Why Should You Care?
Your net worth is the single most important measure of your financial health. The formula is simple: what you own (your assets) minus what you owe (your liabilities). A high salary is great, but if your spending and debts grow just as fast, you may not
be building actual wealth. Tracking your net worth provides a clear snapshot of your financial position, stripping away the noise of monthly income and expenses. Regularly calculating it helps you measure your progress over time, make smarter financial decisions, and stay motivated. Think of it as your personal financial report card—a tool that shows you whether your habits are helping you move forward or holding you back.
Step 1: Setting Up Your Spreadsheet
You don’t need fancy software. A simple spreadsheet in Google Sheets or Microsoft Excel is all it takes. Open a new sheet and create a clean layout. You’ll want four main columns: one for the item name (e.g., “Savings Account”), one for the category (“Asset” or “Liability”), and one for the value. Create two main sections. The top section will be for your Assets and the bottom section will be for your Liabilities. At the very bottom, create three final rows: Total Assets, Total Liabilities, and finally, Net Worth. This simple structure is the foundation of your automated calculator.
Listing Your Assets
Assets are anything you own that has monetary value. For a fresh graduate in India, this list is usually straightforward. Start by listing all your assets and their current market value. Common examples include: Cash in your savings and checking accounts; Investments like mutual funds (through SIPs), stocks, or Public Provident Fund (PPF); Your Employee Provident Fund (EPF) balance; The value of any vehicle you own; and Fixed or recurring deposits. Don't worry if the list feels short at first. The goal is to get a complete and honest picture of everything you own. As you progress in your career, this list will naturally grow.
Accounting for Your Liabilities
Liabilities are any debts you owe. Being thorough here is crucial for an accurate calculation. Common liabilities for young adults include: Student education loans; Outstanding credit card balances; Personal loans; and A vehicle loan. List each debt and the total amount you still owe. It can be uncomfortable to see these numbers written down, especially if they are high. However, acknowledging your debts is the first step toward creating a plan to reduce them, which is one of the most effective ways to increase your net worth over time.
The Simple Formulas for Automation
This is where the magic happens. Instead of manually adding everything up, you’ll use basic formulas to do the work for you. Let’s assume your asset values are in cells C2 through C10 and your liability values are in cells C12 through C15. To calculate your Total Assets: In the cell next to “Total Assets,” type =SUM(C2:C10) and press Enter. This formula automatically adds up all your asset values. To calculate your Total Liabilities: In the cell next to “Total Liabilities,” type =SUM(C12:C15) and press Enter. This adds up all your debts. To calculate your Net Worth: Finally, in the cell next to “Net Worth,” type a simple subtraction formula, like =C11-C16 (using the cells where your asset and liability totals now appear). Your spreadsheet will now show your real-time net worth. Every time you update an asset or liability value, the totals will recalculate instantly.
Make It a Quarterly Habit
Calculating your net worth isn’t a one-time task. The real power comes from tracking it consistently. A quarterly check-in is a perfect cadence—frequent enough to see trends but not so often that you obsess over minor market fluctuations. At the end of each quarter, update the values for each of your assets and liabilities. You can create new columns for each new quarter (e.g., Q1 2027, Q2 2027) to see a historical record of your progress. This regular habit provides accountability and tangible feedback on your financial decisions. Seeing your net worth grow, even by a small amount, is incredibly motivating and reinforces healthy financial habits like saving and paying down debt.
