Share your net worth progression

Hello! Recently I found out the google sheet “Homemade Net Worth Calculator” that you set up together with Mr. Golden Pioche. Great! If I got it right, some of the cells are connected to google Finance, and it gets automatically updated; but if I download the file as .xls and I use it ‘offline’, is it possible to keep these cells connected to the daily financial info?

I haven’t use it yet, but it seems very useful. Merci et bon week-end!

1 Like

Hey Architect,
Thanks for the question. Indeed, the sheet uses googlefinance, but it’s only for currency exchange (EUR->CHF, USD->CHF, …), and not to fetch the price of stocks or such things. I wanted to keep the sheet flexible and easily customisable for any use.

If you use Excel, you can just modify the related cells and use techniques explained here or here (found with a quick search engine query).
Note that it’ll not work if you are really “offline”, but otherwise it should work.

Enjoy :slight_smile: (I fancy feedback regarding the sheet, don’t hesitate to write me, thanks!)

1 Like

Wait… but in this progression you are counting your monthly/yearly salaries that you set aside and then you invest into assets, right?

It should be simple - you just make a (monthly/quarterly/yearly) snapshot of all your accounts / asset values.
So part of your income could be sitting either on the bank account, be poured over into brokerage account, or a new car (which you would probably “model depreciate” accordingly).

1 Like

Ah ok thanks :slight_smile: So it includes savings from monthly salaries.

At first I thought this was just progression of already invested money and seeing it growing 50% I was reall thinking… what did I get wrong with ETFs giving an avg. of 10% yearly? Or are these guys going wild with high volatile investments? But that is not considered wise for FIRE.

It could be any of the mixes of those. :grin:
Crypto jumps, bonus payouts, RE reevaluations etc.
It serves as a solid motivation, don’t get overly involved in comparisons. :slight_smile:

1 Like

Total assets, not Net New Money.

Although would be nice to see portfolio performances deduced of net new money…

That would be just net worth minus monthly income… would certainly be lower by a somewhat fixed amount for most of the months.

I am myself trying to track NW accummulation vs. just pure savings, to gauge how much being invested has contributed to it. :slight_smile:
Looks a little something like this.
Started investing “properly” only with beginning of 2019, and the effect of it is markedly clear. (With 2 lucky strong years of course)

But that’s a bit of a different angle to what you had in mind, I believe.

1 Like

I think this is what he was referring to, indeed

@dbu as said by @weirded, that is exactly what I had in mind.

Savings can differ per month or during the year, think bonus, taxes, unexpected expenses. It is interesting to see what amount was pumped in, and what was gained due to market.

Unfortunately, I have not tracked like this for the past 20 years of data I have…

This point came to my wife after I mapped all my net worth, divided by asset category. She asked me if my portfolio was “biting the market” or what was the performance of my assets… I can’t say, as I cannot separate growth due performance from those due to savings (net new money).

2 Likes

If you track how you much you saved during the year from salary you can estimate your annual investment return with a simplified formula:

Investment return =

Net Worth End of Year
/
( Net Worth Start of Year + [ (net Savings during Year) /2] )

-1

It assumes you saved evenly over the year, in my opinion it is not value adding to do any more detailed calc than this

My number for 2020 was just over 10% including 2nd pillar and cash

1 Like

Hi,
I’ve also noticed that the various graphs don’t take in consideration the currency exchange.
For example if I have 60k USD in stock A and 55K CHF in stock B, in the graphs it will show that Stock A has more % weight on my portfolio, due to the absolute value taken in consideration

Hey @danfaiz
Funny because I updated the sheet yesterday, specifically to fix this issue. Now the charts in the “Stocks” and “Crypto” tabs show the values converted in CHF. Check it and tell me if it’s what you wanted :wink:
Anyway, thanks for the feedback!

1 Like

Thanks to you for the work!
Regarding the YTD % I am not sure to understand the formula, if you dont mind explaining?
As there is “net worth on 1st of January” (B31), I guess the whole column B for your January net worth, is to be filled up at the end of the month.
To make thing easier with number, if I start the year with 10chf (B31), and at the end of January I Have 15 chf, my YTD % increased of 50% (B29/B31).
But if at the end of February if have 20 chf, I should have an increase of 100% of my networth, but with your formula (C29/B26) it shows 66%
shouldn’t u always divide every YTD month by the B31?

An other little feedback: as the currency fluctuate, I actually do the exchange on that given day at the end of the month
index(GOOGLEFINANCE("CHFEUR","price","2020/01/31"),2,2)
Or, if I use the automatic today date with the standard googlefinance("CHFEUR") formula, I will then “freeze” the cell value at the end of the month, by copying and pasting just the value of the cell, so my graph doesn’t change in time and I know exactly how much I really had at the end of that month

3 Likes

You’re totally right, it was a bug! Thanks for finding it and notifying me! :slight_smile: The sheet is updated now.

And regarding your last remark, you’re right as well. The way the sheet works now, we’ll see old net worth values change slightly because of the exchange rate. Your suggestion will fix this, but it’ll add complexity to the sheet (have to change things if we use it next year, and stuff like this). I have to think of a way to make it work in an easy way. We can discuss this in pm, as I’m not sure it is interesting for everyone here.

Btw, the sheet is currently in french. If someone is interested to have it in English, please like this post, so that I know and can start the translation :wink:

3 Likes

Since you snapshot it just once a month, why even introduce complexity with having “live” forex rates?
(I don’t see how it would “add complexity”, as you state, to remove the currency conversion :grin:)

What I do is just literally google “X eur to chf” (or whatever your base tracking currency is) on the date of data entry, and put that into the sheet.
Then maybe keep another column which tags the original account currency (EUR/CHF/USD).

1 Like

I meant that adding currency exchange for a specific date would add complexity when one wants to reuse the sheet for another year for example. Of course, removing the currency conversion remove complexity ahah. What I did in my previous sheet is that I have a cell in my sheet that converts currency X to currency Y, then I type the CHF value in the cell, as you said. It’s the easiest, I agree on this!

I did not. Only reevaluate it when informing the Bank that I will rent it out. Value increased and they decrease the amortization from 7k to 4k annually, as the apartment was evaluated for 250k more than I bought it 7 years ago.

As each sheet would be valid for a certain year anyway, you can add the reference to the year in a specific cell (e.g. in the first) tab and then embed it in the index formula which @danfaiz pointed out to make it more abstract / reusable

Nice document by the way

1 Like
By reading and partipating to this forum, you confirm you have read and agree with the disclaimer presented on http://www.mustachianpost.com/
En lisant et participant à ce forum, vous confirmez avoir lu et être d'accord avec l'avis de dégagement de responsabilité présenté sur http://www.mustachianpost.com/fr/