How to Track Your Net Worth Progress to Your First $100k in a Spreadsheet

You’ve set a target — your first $100,000 net worth — and now you want to actually watch yourself close in on it, month by month, instead of just hoping you’re getting there. Maybe you’re at $30k, maybe $70k, and you want a progress bar, a percentage, and an honest estimate of when you’ll cross the line. This guide shows you how to build exactly that in a spreadsheet: the milestone, the monthly tracking, and a projected finish date based on your own numbers.

A net worth goal without tracking is just a wish. The reason milestone tracking works is the same reason a progress bar keeps you clicking “next” — visible, quantified progress is motivating in a way that a distant goal never is. And the first $100k has a reputation for being the hardest stretch precisely because the early progress feels slow, which makes seeing every inch of it matter even more.

Step 1: Pick Your Definition and Your Number

First decide which net worth you’re chasing:

• Total net worth — everything you own (including home equity and cars) minus everything you owe.
• Investable / liquid net worth — only cash and investments minus debts, ignoring house and vehicles.

Lots of people chasing their first $100k track the investable figure, because it reflects money that’s genuinely compounding rather than equity locked in a house. Either is valid — just pick one and keep it consistent, or your progress line won’t mean anything. Then set your target: $100,000.

Step 2: Record Where You Are and the Gap

Log your current net worth and calculate the gap to your goal. Say you’re starting here:

That “40%” is already motivating — you’re further along than it probably feels. The gap ($60,000) is your actual target to close.

Step 3: Log It Monthly and Split the Gain

Each month, add your new net worth. But do one extra thing that makes the first-$100k grind bearable: split your monthly gain into money you added versus growth.

Early on, notice how almost all the progress comes from the “saving” column — growth on a $40k balance is small. That’s why the first $100k feels hard: you’re doing it mostly by hand. Watching the “growth” column slowly get bigger each month is the payoff, because it’s proof that compounding is starting to help. By the time you’re near $100k, growth is doing a meaningful share of the work — which is exactly why the next $100k tends to come faster.

Step 4: Project Your Finish Date

Here’s the part that turns a tracker into a motivator. Take your average monthly gain and divide the remaining gap by it:

Using the example above, the average monthly gain is about $1,767. The remaining gap after April is $100,000 − $45,300 = $54,700.

$54,700 ÷ $1,767 ≈ 31 months — so, a little over two and a half years from now, on your current pace.

That’s a conservative straight-line estimate; because your “growth” slice keeps rising as your balance grows, the real finish will likely come a bit sooner. But even the plain projection does the job: it turns “someday” into a date you can circle on a calendar and aim at.

Step 5: Let It Update Itself

The whole system is just three living numbers — how far you’ve come (%), how far is left ($), and your projected date — recalculated each month from a single net worth entry. Do the ten-minute monthly update on the same day each time, and your progress bar advances on its own.

A net worth tracker spreadsheet built for this has the milestone math, the monthly snapshot, and the trend chart already wired up — you enter your balances and watch the percentage climb toward 100%. The Net Worth & Investment Tracker also separates your investment growth from what you’ve contributed and folds in retirement projections, so once you hit your first $100k you can point the same sheet at the next milestone without rebuilding anything.

For the underlying month-by-month system, see the pillar: how to track net worth and investments in one spreadsheet.

The Bottom Line

Reaching your first $100k is mostly about staying motivated through a slow start, and nothing motivates like visible progress. Pick your definition (total or investable), record your current net worth and the gap, log it monthly, and split each gain into saving versus growth so you can watch compounding wake up. Divide the remaining gap by your average monthly gain for a projected finish date. Set it up once, update ten minutes a month, and turn a distant goal into a progress bar you get to fill in.