Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
I would combine your income and average out your age
Why is this difficult for a younger person?
Say you are 35 and earning 100K. That means your net worth should be 400K. Ok.. that may be not possible for many people.
Problem is if you go younger.
Try calculate a 20 yr old on 60k as to what their net worth should be.
I think this formula is a load of rubbish.
My preference would be to work out how much you need for retirement based on the income you want for retirement and the return you expect to be generated from your assets to create that income (e.g. if you want $50k p.a. and expect to earn 5%, you will need $1,000,000). You can then work out how you're tracking by how close you're getting to your final goal and how long you've got to get there.
I have attached something close to what you asked for
Inputs go into the yellow cells (all in Col B).
Cell B17 is where you can experiment.
Age & Year cols will be shaded in green if you have enough investments.
I had to zip the file because the system didn't let me upload xlsx.