The Lifetime-Net Worth-Simulator

Happy Memorial Day everyone!!

While you’re out reflecting and celebrating today, let me suggest another fun (and FREE) activity to include for your enjoyment: Filling out this Lifetime-Net Worth-Simulator!

[UPDATE: spreadsheet no longer online…]

From a new blogger on the scene, Money Is a Solved Problem, who wants to help in his own way of giving you freedom :) And considering it’s only his 2nd post on the blog, I’d say he’s off to a great start!

liftetime net worth spreadsheet

[Download spreadsheet here (Excel)]

The currency is currently set to Euros (€) as he lives in Sweden, but as he notes, “If you do not like € replace it with $. If you are living in 2950 when both do not exist anymore, replace them with your currency. I hope Excel is still a thing in 2950.” Lol….

But here’s why I like this compared to others – it shows the FULL CYCLE of your money and not just to your *retirement date*! Even though that latter half is the part most of us don’t want to see as it has our money going in the OPPOSITE direction, haha…

But since that’s the circle of life, it helps to give you a better overall picture of things :)

It can also help you with the following according to him by playing around with the variables a little:

  • How powerful compound interest can be
  • How inflation can eat up your savings!
  • How your income, expenses and annual investment returns affect your long term worth
  • That you can amass a lot of money working at a normal job and keeping expenses low
  • That you need a very high income if you want to become a billionaire ;)
  • And overall how NOT to run out of money when you’re older

Here’s the link to his full blog post on it to learn more: The Lifetime-Net Worth-Simulator
And then here’s the direct download link again to it: Simulator Spreadsheet

Let me know if it gives you any epiphanies!! :)

[UPDATE: spreadsheet no longer online…]

******
PS: to put things in even more perspective, pair this with your Lifetime Wealth Ratio!

(Visited 155 times, 1 visits today)

Get blog posts automatically emailed to you!

12 Comments

  1. Steve May 25, 2020 at 9:23 AM

    Already retired so no real epiphanies, but love the idea. Very creative and quite innovative.

    Nicely done. ;)

    1. J. Money May 25, 2020 at 10:47 AM

      Do you already track when your last dollar will disappear? Or leave that for Future Steve to worry about? :)

  2. DJ @MyMoneyDesign May 25, 2020 at 11:13 AM

    Let’s be real – Excel will always be a thing!

    Thanks for sharing this. I always love the ingenuity of the spreadsheets that personal finance bloggers come up with.

    1. J. Money May 25, 2020 at 3:00 PM

      We’re a special group, lol…

  3. Josh Edwards May 26, 2020 at 1:40 AM

    Great post J,
    Long time follower who started his own blog yesterday (I gave you credits on my first post as one of the bloggers who influenced me) ;)

    I’d love to guest post for you once I get to a more advanced stage in my own blog.

    Hope your well and staying safe my friend!

    1. J. Money May 27, 2020 at 6:21 AM

      Rock on man – welcome to the club!! I hope you really enjoy it!

  4. Roger OConnor May 26, 2020 at 4:57 PM

    Have always liked the concept you created on the Lifetime Wealth Ratio. Would love to see an update on what you think about the categories you set before you go. After more than a decade of doing this, my guess is you might have a bit more insight now that when you first published the concept.

    1. J. Money May 27, 2020 at 6:46 AM

      Hey dude! Glad you liked that!!

      I’m not sure what you mean by “categories”, but it is a good reminder to update the ol’ LWR in my spreadsheet as it’s def. been a while :) I’ll have to find a way to make it go viral more so more people start paying attention! It really is a great way to put your entire life’s earnings and savings in perspective!

      1. Roger OConnor May 28, 2020 at 11:55 AM

        Was thinking about these categories you said you only put a few minutes of thought into
        0%-10% – Meh
        10%-25% – Now we’re cooking!
        25-50% – You’re on fire, baby! Give me your number!
        50-100% – Marry me.
        100%-1,000% – How do I get into your will?

        Would be interested to know if you had any additional thoughts on what a reasonable target should be. Possibly by age.

        1. J. Money May 28, 2020 at 5:31 PM

          Ahhhh, yeah – they still look pretty good to me! I suppose you can factor in age or other variables, but then again the point is really just to motivate yourself to keep climbing and look at things in a different light, so I think it still accomplishes that keeping it nice and simple as it is. But you’re more than welcome to tweak it to better push yourself! Whatever it takes to keep that fire lit! :)

  5. steveark May 26, 2020 at 6:11 PM

    That’s pretty cool. I wonder what it would have predicted for me 40 years ago? I would not have guessed my pay would have gone from x to 24x. Or that I’d receive a 7 figure windfall I absolutely did not need after already achieving financial independence. But I also would have guessed 10% inflation and 15% raises, because that’s what the 80’s were like. I did run it from my 21 year old perspective, oddly it was pretty close to actual even though actual inflation did not stay high. Plus it says I’ll die with 40 million. I better go look at private jets!

    1. J. Money May 27, 2020 at 6:48 AM

      Haha rock on..

      Glad you got that windfall AFTER you hit financial freedom too! It’s like a prize for putting in all that hard work! Lol…