Projecting your future net worth


Yesterday, I was playfully googling my name may be out of vanity and boredom. In doing so, I happened to bump into a comment that I wrote to a Filipino personal finance blogger in 2010.

The post reminded me of 3 things:

  1. my household net worth in April 2010 was $330,000
  2. my own mortality
  3. the responsibility to give back.

There is no doubt that I’m going to give away some of my wealth when I die. Not just for estate planning purposes (an estate worth roughly over $5 million dollars is taxed by Uncle Sam), but also for generously extending my legacy.

But what kind of wealth am I talking about? Is this the kind of wealth that will significantly benefit the community or just my loved ones?  Would this wealth transcend generations potentially changing my family tree?

I really don’t know. The most that I can do is to perform a very simple historical projection.

The first step is to determine the average rate my net worth grew for the known periods (i.e. average growth rate). The second step is to apply the same rate to the projected periods.

How to calculate the growth rate

The math involved is very simple. Say, your net worth last year grew from $100,000 to $130,000. The growth rate for this period is calculated as ($130,000 – $100,000)/$100,000 = 30%.

The formula for calculating the growth rate for a specific period:

(Ending net worth – Starting net worth)/ Starting net worth

You can obtain the average growth rate by applying the following formula:

(Growth rate in Period 1 + Growth rate in Period 2 + … Growth rate in Period n) /
Number of Periods

Determine average growth rate

Here’s what else I know, in addition to the number in 2010:

  • Our net worth was over $100K when we purchased our home in 2004
  • Current net worth as of this writing is somewhere around $975K

Running the numbers in Excel, the average growth rate that I came up with is 20%.

Here’s what the chart looks like.

This chart shows that we have a net worth of around $328K in 2010. This closely resembles the number that I mentioned in the comment section of the WordPress blog.

This also shows that my net worth grew by roughly $900,000 in the span of 12 years.

Apply the rate on projected periods

Of course, there are many factors that will affect our growth rate in the coming years, among them:

  • our investment returns
  • savings rate
  • tax rates.

As far as the first point is concerned, we certainly have no control over the price of MSFT, AAPL or GOOG stocks. But we certainly do have control over our spending.

If the great recession of 2008 did not stop us from having a 20% growth rate, I don’t see any of these factors slowing us down.

Also, we love what we do. We both love our careers. I write financial web application software for a living and I see myself doing it until I retire.

All these considered, I’ve applied the same 20% growth rate. This is by no means a highly optimistic number.

Here’s what the chart looks like for our last 15 working years:

The projected net worth when my wife and I both turn 60 is an astounding $15,000,000. At 3% inflation rate, this is equivalent to 10 million dollars in today’s money.

In this chart, our net worth is projected to grow by 10 million dollars in the next dozen of years. Contrast this to the first chart where it grew by only $900,000 for the same length of time.

This phenomenon is referred to as the “power of compounding interest”- where the interest applied on top of the interest works exponentially in your favor.

Let’s go much further than that and do a projection of our ending net worth, with the assumption that we both continue to live until the age of 90.

Applying a lower growth rate in retirement

Age 60 to 70 years

Here we stop working so growth rate is cut by half to 10%. But with 15 million dollars and no mortgage to pay off, we can afford to travel the world once every quarter. With this kind of money, the interest alone when invested at 5% is worth $750K annually. Our retirement income will be supplemented by dividends and rental properties that we will buy in cash. Half of our assets will be in fixed-income investments like bonds and CDs.  It is also in this period where my wife’s pension will start to kick in. Projected net worth is $42,000,000 by the end of this period. At 3% inflation rate, this is roughly equivalent to 20 million dollars in today’s money. Thanks to a low-key lifestyle and continued allocation in stocks for the significant portion of our portfolio.

Age 70 to 80 years

The growth rate is cut by half to 5%. At this age bracket, we probably will be less active. But hopefully, we can continue to travel the world at least twice a year and enjoy other leisure activities. We will also start taking the required social security distributions maximizing the value. Majority of our portfolio will be in very conservative investments like bonds and CDs. I am also hopeful that by then interest rates will be higher. Projected net worth at the end of this period is $72,000,000. At 3% inflation rate, this is roughly equivalent to 25 million dollars in today’s money.

Age 80 to 90 years

The growth rate is -5% because this is the wealth reduction phase as we will start giving generously to various charities that we care about. We will continue to enjoy a good life not available to many. Health problems may kick in but this is hardly a financial concern when you have insurance and millions of dollars in the bank.

At the end of this period, our estate would still be worth roughly $48,000,000. This means that we have given away around 13 million dollars in today’s money. Because at 2% growth rate, it would have grown to $91,000,000, if we weren’t as charitable.

By then we would have already established a charitable trust that will distribute our assets to our heirs efficiently without the cost, delay, and publicity of probate court. There would still be over 12 million dollars in today’s money to leave for my heirs to enjoy.

Instead of dying quietly, we will have the rare opportunity to greatly impact the lives of the people around us in a positive way.

It is in this phase that we will give like no one else in my family tree.

Only time can tell if my projection is right on the money.

No Comments

Leave a Reply

Your email address will not be published.

CommentLuv badge

This sheet tells you when to get out of the rat race

One of my favorite movies of all-time is American Beauty. The 1999 award-winning film stars Kevin Spacey who played Lester Burnham, a 40-something guy who hated his job and was on the brink of a mid-life crisis. The inflection point was when he saw his daughter’s gorgeous 16-year-old cheerleader friend, Angela Hayes (Mena Suvari), perform during a half-time dance routine at a high school basketball game.
Lester becomes so infatuated with Angela that he began having sexual fantasies with her. He becomes obsessed with youth that he started to live his life like he just graduated from high school. And when he was told that he was about to get laid off, he instead blackmailed his boss for $60,000. He then quits work anyway choosing to work as a crew in a fast-food chain instead– the position with, in his own words, the least amount of responsibility.
But what really caught my attention is the scene where Lester Burnham wonders in his cubicle while seeing a reflection of his image on the monitor, which resembles a guy trapped in a jail cell. With the numbers on the spreadsheet forming the jail bars in his mind, it’s pretty obvious that he felt imprisoned by his job and wanted an escape. A feeling that many people can sympathize.

9 signs you probably won’t need a retirement nest egg

It’s a fact, people in developed countries are living longer. For instance, life expectancy for women is predicted to surpass 90 years in South Korea by 2030, according to the study published in The Lancet, one of the world’s oldest and most respected medical journals. Of course, the study assumes …

FIRE, FART, or neither, the choice is yours

When it comes to your finances, there are two extremes to model yourself on, FIRE or FART (acronyms below) — that is if you want to be an extremist. The third option is neither, and that’s completely fine. The choice to quit the rat race at either 35 or 95 is completely your own …

Skip to toolbar