How to Calculate Net Worth in 15 Minutes (With a Free Spreadsheet Template)

Most people know their salary. Far fewer know their actual net worth. Those are two very different numbers, and only one of them tells you whether you’re genuinely building wealth. Calculating your net worth takes about 15 minutes with the right spreadsheet — and this guide walks you through every step, from gathering account balances to interpreting the result.

You’ll need a free spreadsheet template, your account login credentials, and roughly 15 minutes of focused time. That’s it.

What Net Worth Actually Is (And Why It Matters)

Net worth is the difference between everything you own and everything you owe. It’s your true financial snapshot — one number that summarizes your complete money picture better than income, savings rate, or credit score alone.

Your salary tells you how much money comes in. Your net worth tells you how much has actually stayed. Someone earning $200,000 a year with $400,000 in debt and no investments has a lower net worth than someone earning $60,000 who has been steadily saving and investing for a decade.

Net worth also reveals a problem that most people don’t catch until it’s too late: spending faster than you earn. If your net worth is flat or declining month over month, you’re not building wealth — you’re treading water or going backward, regardless of how large your paycheck looks.

According to the Federal Reserve’s Survey of Consumer Finances (most recently updated for 2022), the median U.S. household net worth is approximately $192,700. The mean is significantly higher at around $1.06 million, skewed upward by high earners. Knowing where you stand gives you a real benchmark.

Despite how useful this number is, most people never calculate it even once. A 15-minute exercise that most personal finance professionals consider foundational simply gets skipped. This guide is designed to make sure you don’t skip it.

The Simple Formula: Assets – Liabilities = Net Worth

The math is not complicated:

Net Worth = Total Assets − Total Liabilities

Your result will be either positive (you own more than you owe) or negative (you owe more than you own). A negative net worth is common for people in their 20s carrying student loans and is not automatically a crisis — but it needs to be tracked and reversed over time.

• Assets include cash, investments, retirement accounts, real estate, vehicles, and business equity — any resource that has current monetary value.
• Liabilities include your mortgage balance, car loans, credit card balances, student loans, and any other money you currently owe to someone else.

A properly set-up spreadsheet handles the subtraction automatically. You enter balances; the template does the arithmetic. The only input that requires judgment is making sure each number is accurate and current.

Assets: Everything You Own at Current Market Value

The key phrase is current market value, not what you paid and not what you think it’s worth. Use real, verifiable numbers from recent account statements or independent valuation tools.

Cash and Bank Accounts

• Checking accounts
• Savings accounts (including high-yield savings)
• Money market accounts
• Cash management accounts (e.g., Fidelity CMA, SoFi Checking)

Use the current available balance shown in your online banking portal at the time you run the calculation.

Investment Accounts

• Taxable brokerage accounts (Fidelity, Schwab, Vanguard, etc.)
• Mutual funds held outside retirement accounts
• Individual stocks and ETFs

Use the current market value shown in your brokerage dashboard, not your cost basis or purchase price.

Retirement Accounts

• 401(k) and 403(b) plans
• Traditional IRA and Roth IRA
• SEP-IRA or SIMPLE IRA (if self-employed)
• Pension plans: use the current present value if available, or a reasonable estimate

Real Estate

Use the current estimated market value of your property, not the purchase price. Tools like Zillow’s Zestimate or a recent appraisal are reasonable proxies. If you own rental property, use a similar approach based on comparable sales in your market. Market value estimates carry some uncertainty — note this when reviewing your total.

Vehicles

Use Kelley Blue Book (kbb.com) or NADA Guides (nadaguides.com) to get the current private-party or trade-in value of each vehicle you own. Do not use what you paid — depreciation makes purchase price irrelevant here.

Business Equity

If you’re self-employed or a business owner, include your estimated ownership stake at fair market value. This is inherently an estimate unless you’ve had a formal valuation. Use a conservative figure if uncertain.

Cryptocurrency

If you hold Bitcoin, Ethereum, or other digital assets, record the current USD value as of the date you’re running the calculation. Crypto values fluctuate daily, so this snapshot will vary over time.

Other Assets (Optional)

High-value jewelry, art, collectibles, or other illiquid assets can be included if they have meaningful value and a verifiable market. For most people, these are minor enough to skip without affecting accuracy. Don’t guess — if you’re not sure of a realistic value, leave it out rather than inflate your total.

➤ Free Guide: 5 Ways To Automate Your Retirement

Liabilities: All Debts and Obligations Listed

List every outstanding balance you currently owe. Use the current payoff balance from your lender’s website — not the original loan amount, not the minimum payment.

Mortgage and Home Loans

• Mortgage: Log into your mortgage servicer (e.g., LoanCare, Mr. Cooper, Chase) and record the current outstanding principal balance.
• HELOC: Record the amount currently drawn and owed on any home equity line of credit.
• Home equity loan: Include the outstanding balance if separate from your primary mortgage.

Auto Loans

Record the current balance owed on each vehicle loan. Log in to your lender (e.g., Toyota Financial, Ally, local credit union) to get an exact figure.

Credit Card Balances

Use the current statement balance or the current amount owed as shown in your card portal — not your credit limit. If you pay in full each month and carry no balance, enter zero.

Student Loans

Include both federal loans (viewable at studentaid.gov) and any private loans. Record the total outstanding principal balance across all loans combined.

Personal and Installment Loans

Any personal loans, medical debt in repayment, or other installment debt still being paid off should be listed here.

Investment-Related Debt

If you’ve borrowed against a margin account or taken a securities-backed loan, include the outstanding balance.

Other Material Obligations

Include significant medical debt, legal obligations, or business liabilities if they represent real money you owe. Skip small amounts that won’t meaningfully affect the total.

Free Spreadsheet Templates: Download One and Start Today

You don’t need to build a spreadsheet from scratch. Several well-maintained, genuinely free templates are available with no credit card required and no upsell attached.

Google Sheets and Microsoft Excel both support the same formula logic. Choose whichever platform you already use. If you’re starting from scratch with no preference, Google Sheets requires no software installation and is accessible from any browser.

The Tiller template is worth noting for its auto-sync capability — it pulls live balances from connected bank, credit card, and investment accounts via the Tiller Money Feeds service. Tiller offers a free trial, though ongoing use requires a paid subscription after the trial period. All other templates listed above function with manual data entry and remain free with no ongoing cost.

The 15-Minute Walkthrough: How to Calculate Your Net Worth Right Now

Here’s exactly how to go from zero to a completed net worth calculation. Follow each step in order.

Step 1 — Gather Statements and Log In (5 minutes)

Open a browser and log in to every financial account you hold: bank accounts, brokerage, 401(k), mortgage servicer, auto lender, credit card portals, and student loan servicer. Have all tabs open simultaneously so you can pull balances quickly. This step takes the most time if you need to reset forgotten passwords.

Step 2 — Enter Asset Balances (4 minutes)

In your spreadsheet, enter the current balance for each asset category. Work from top to bottom: cash first, then investments, then retirement accounts, then real estate (use Zillow for a quick estimate), then vehicles (KBB private-party value), then any other assets. Use exact numbers, not round estimates.

Step 3 — Enter Liability Balances (3 minutes)

Switch to the liabilities section of your spreadsheet. Enter the exact current balance for each debt: mortgage, HELOC, auto loans, credit cards, student loans, and any personal or other debt. Check the payoff balance or current balance shown in each lender’s portal — not a statement from three months ago.

Step 4 — Review the Auto-Calculated Total (3 minutes)

Your spreadsheet will automatically subtract total liabilities from total assets and display your net worth. Review the number, then scroll through each line to check for obvious errors: a missed account, a typo, or a duplicate entry. If the number looks wildly off, the most common culprit is entering a mortgage purchase price instead of the current balance, or using purchase price instead of market value for real estate or vehicles.

Pro tip: Write the date next to your result. Net worth is a snapshot, not a permanent number. Dating each entry is what makes tracking meaningful over time.

Interpreting Your Number: What It Reveals About Your Financial Health

Once you have your number, here’s how to read it:

• Positive net worth: You own more than you owe. You’re financially solvent. The question now is whether the number is growing.
• Negative net worth: You owe more than you own. This is common for people in their 20s and early 30s with student loans, and it’s not automatically a crisis — but it should be actively improving over time.
• Growing month over month: You’re building wealth. Income is outpacing spending and debt accumulation.
• Flat or declining: Either investment markets are down (a temporary factor) or you’re overspending. Look at whether liabilities are rising before blaming market volatility.

Age-Based Benchmarks (from the Federal Reserve 2022 Survey of Consumer Finances)

The median is more useful than the mean for most comparisons. Median figures represent the midpoint of the actual population; means are pulled upward by very high earners at the top of each bracket.

These benchmarks are descriptive, not prescriptive. They tell you where the median American stands, not what you should target. Use them as a reference point, not a grade.

What to Do Next: Monthly Tracking and Your Action Plan

A single calculation is useful. Monthly tracking is transformative. Here’s how to turn this 15-minute exercise into a long-term financial habit.

Set a Recurring Monthly Update Date

Pick a consistent date — the first of the month, the last Sunday of the month, or any day that aligns with when your accounts settle. Add it to your calendar. A 10-minute monthly update is all it takes to maintain an accurate picture over time.

Track the Trend, Not Just the Number

A single net worth figure tells you where you are. Six to twelve months of figures tell you where you’re going. Most spreadsheet templates include a section to log monthly or annual snapshots so you can chart progress over time. If your net worth has grown by $15,000 over the past 12 months, you have evidence that your financial decisions are working — far more motivating than checking a savings account balance in isolation.

Identify What’s Driving Change

• If net worth is negative or declining, identify your largest liability. That debt is the single most impactful item to address.
• If net worth is stagnant despite income, look at where spending is occurring. Flat net worth often reflects a pattern of earning and consuming without accumulating.
• If net worth is growing, decide whether your next priority is aggressive debt payoff, increased retirement contributions, or saving toward a specific goal.

Run Scenarios

Your spreadsheet is a planning tool, not just a reporting tool. Try these calculations:

• What happens to your net worth in 12 months if you put an extra $300/month toward your highest-interest debt?
• If you increase your 401(k) contribution by 2%, how does that change your retirement account balance in five years?
• If you sell a vehicle and replace it with a less expensive one, how much does that shift your net worth?

Schedule a Quarterly Strategy Review

Monthly updates track the numbers. A quarterly review is where you make decisions. Every three months, look at your trend line and ask: Is the current strategy working? Have any major life changes occurred — a new job, a bonus, a large expense — that should change your priorities? Adjust as needed based on actual results rather than assumptions.

Bottom Line

Calculating your net worth is a 15-minute task with multi-year implications. The formula is straightforward — assets minus liabilities. The only inputs required are accurate, current account balances. Free templates from sources like Vertex42, Tiller, and Money Guy remove every technical barrier.

The number you arrive at is neither a grade nor a guarantee. It’s a starting point. Tracked consistently over time, it becomes the clearest signal available for whether your financial decisions are actually building wealth or simply maintaining the status quo.

Download a template, open your account tabs, and spend 15 minutes this week to get your number. That single calculation is more informative than years of monitoring individual account balances in isolation.

This article is for informational purposes only and does not constitute personalized financial, tax, or legal advice. Net worth benchmarks cited from the Federal Reserve’s 2022 Survey of Consumer Finances.