# Share your net worth progression

**URL:** <https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798>\
**Category:** Investing / Portfolios\
**Created:** [November 29, 2020, 3:07pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798 "2020-11-29T15:07:54Z")\
**Posts on this page:** 20\
**Page:** 16

<div class="post-metadata">

**Author:** ![Jagermeister](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/jagermeister/32/8551_2.png) [@Jagermeister](https://forum.mustachianpost.com/u/Jagermeister)\
**Post date:** [May 26, 2021, 1:00pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/332 "2021-05-26T13:00:50Z")

</div>

Ah ok thanks 🙂 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.

---

<div class="post-metadata">

**Author:** ![dbu](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/dbu/32/1552_2.png) [@dbu](https://forum.mustachianpost.com/u/dbu)\
**Post date:** [May 26, 2021, 1:17pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/333 "2021-05-26T13:17:25Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![miriade](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/miriade/32/1663_2.png) [@miriade](https://forum.mustachianpost.com/u/miriade)\
**Post date:** [May 26, 2021, 1:28pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/334 "2021-05-26T13:28:49Z")

</div>

Total assets, not Net New Money.

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

---

<div class="post-metadata">

**Author:** ![MrCheese](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/mrcheese/32/2500_2.png) [@MrCheese](https://forum.mustachianpost.com/u/MrCheese)\
**Post date:** [May 26, 2021, 10:16pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/335 "2021-05-26T22:16:17Z")

</div>

> [@miriade](#):
>
> 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.

---

<div class="post-metadata">

**Author:** ![dbu](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/dbu/32/1552_2.png) [@dbu](https://forum.mustachianpost.com/u/dbu)\
**Post date:** [May 27, 2021, 6:25am UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/336 "2021-05-27T06:25:48Z")

</div>

> [@miriade](#):
>
> Although would be nice to see portfolio performances deduced of net new money…

I am myself trying to track NW accummulation vs. just pure savings, to gauge how much being invested has contributed to it. 🙂  
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)

 ![Screenshot_20210527-082408_Sheets](https://forum.mustachianpost.com/uploads/default/original/2X/5/5aef523aace883dd00dc2aee2a8095a70419f5cb.jpeg)

 ![Screenshot_20210527-082417_Sheets](https://forum.mustachianpost.com/uploads/default/original/2X/2/2094829a431adffc4470db383b57079193201be1.jpeg)

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

---

<div class="post-metadata">

**Author:** ![weirded](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/weirded/32/14916_2.png) [@weirded](https://forum.mustachianpost.com/u/weirded)\
**Post date:** [May 27, 2021, 11:07am UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/337 "2021-05-27T11:07:24Z")

</div>

> [@dbu](#):
>
> But that’s a bit of a different angle to what you had in mind, I believe.

I think this is what he was referring to, indeed

---

<div class="post-metadata">

**Author:** ![miriade](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/miriade/32/1663_2.png) [@miriade](https://forum.mustachianpost.com/u/miriade)\
**Post date:** [May 27, 2021, 12:35pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/338 "2021-05-27T12:35:23Z")

</div>

@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).

---

<div class="post-metadata">

**Author:** ![Barto](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/b/e9c0ed/32.png) [@Barto](https://forum.mustachianpost.com/u/Barto)\
**Post date:** [May 27, 2021, 1:30pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/339 "2021-05-27T13:30:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![danfaiz](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/d/8e8cbc/32.png) [@danfaiz](https://forum.mustachianpost.com/u/danfaiz)\
**Post date:** [May 28, 2021, 9:35pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/340 "2021-05-28T21:35:12Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![arturofich](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/arturofich/32/5221_2.png) [@arturofich](https://forum.mustachianpost.com/u/arturofich)\
**Post date:** [May 29, 2021, 7:23am UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/341 "2021-05-29T07:23:54Z")

</div>

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 😉  
Anyway, thanks for the feedback!

---

<div class="post-metadata">

**Author:** ![danfaiz](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/d/8e8cbc/32.png) [@danfaiz](https://forum.mustachianpost.com/u/danfaiz)\
**Post date:** [May 29, 2021, 10:25pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/342 "2021-05-29T22:25:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![arturofich](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/arturofich/32/5221_2.png) [@arturofich](https://forum.mustachianpost.com/u/arturofich)\
**Post date:** [May 31, 2021, 8:00am UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/343 "2021-05-31T08:00:49Z")

</div>

You’re totally right, it was a bug! Thanks for finding it and notifying me! 🙂 The [sheet is updated](https://docs.google.com/spreadsheets/d/170bLLaR_dfl6a16iWneDpOwCZoZCadtX-wvtgST4alw/edit?usp=sharing) 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 😉

---

<div class="post-metadata">

**Author:** ![dbu](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/dbu/32/1552_2.png) [@dbu](https://forum.mustachianpost.com/u/dbu)\
**Post date:** [May 31, 2021, 8:07am UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/344 "2021-05-31T08:07:40Z")

</div>

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 😁)

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).

---

<div class="post-metadata">

**Author:** ![arturofich](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/arturofich/32/5221_2.png) [@arturofich](https://forum.mustachianpost.com/u/arturofich)\
**Post date:** [May 31, 2021, 11:00am UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/345 "2021-05-31T11:00:00Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Broth](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/b/3ec8ea/32.png) [@Broth](https://forum.mustachianpost.com/u/Broth)\
**Post date:** [May 31, 2021, 11:43am UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/346 "2021-05-31T11:43:30Z")

</div>

> [@Cortana](#):
>
> And how do you exactly account for AHV? Do you have a formula?

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.

---

<div class="post-metadata">

**Author:** ![weirded](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/weirded/32/14916_2.png) [@weirded](https://forum.mustachianpost.com/u/weirded)\
**Post date:** [May 31, 2021, 4:44pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/347 "2021-05-31T16:44:25Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![1000000CHF](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/1000000chf/32/700_2.png) [@1000000CHF](https://forum.mustachianpost.com/u/1000000CHF)\
**Post date:** [June 1, 2021, 7:27pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/348 "2021-06-01T19:27:36Z")

</div>

![image](https://forum.mustachianpost.com/uploads/default/original/2X/1/101ca372e83369356ab2b4ac57f68ce2dda55b13.png)

---

<div class="post-metadata">

**Author:** ![MrCheese](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/mrcheese/32/2500_2.png) [@MrCheese](https://forum.mustachianpost.com/u/MrCheese)\
**Post date:** [June 1, 2021, 9:06pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/349 "2021-06-01T21:06:21Z")

</div>

Wow where did those 600k in March come from?

---

<div class="post-metadata">

**Author:** ![1000000CHF](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/1000000chf/32/700_2.png) [@1000000CHF](https://forum.mustachianpost.com/u/1000000CHF)\
**Post date:** [June 1, 2021, 9:17pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/350 "2021-06-01T21:17:06Z")

</div>

It’s not March but July last year, so it’s basically a year difference (I haven’t been updating my sheet because I wasn’t investing for a year - I got a little bit scared and a little bit confused with my life situation). And it’s not 600k, but 90k - jump from 204k to 295k.

---

<div class="post-metadata">

**Author:** ![MrCheese](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/mrcheese/32/2500_2.png) [@MrCheese](https://forum.mustachianpost.com/u/MrCheese)\
**Post date:** [June 1, 2021, 9:32pm UTC](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798/351 "2021-06-01T21:32:30Z")

</div>

Oh looks like my eyes are to tired and added a 0 everywhere. Good progress none the less

[Previous page](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798.md?page=15)

[Next page](https://forum.mustachianpost.com/t/share-your-net-worth-progression/4798.md?page=17)
