Hello community,

***Edition: I got the insight from the community there was a logical error in my calculations with respect to amount invested in ETF. I am keeping the original notes*** ***~~crossed out~~*** ***and adding the new assumptions and results. The conclusion has also changed.***

I’ve seen some posts related to this one but still unclear thus creating a new one to have a good discussion.

[Original Results ](https://preview.redd.it/7wt357ln495c1.png?width=790&format=png&auto=webp&s=59ac3d9e6cb00a4aa63d10de4ec2dfbd95b5d393)

[New Results](https://preview.redd.it/o2zjzlw1rm5c1.png?width=765&format=png&auto=webp&s=da657ccc19e2ba13725da62a22a54259432f0d47)

​

**Background**:

I’m considering subscribing to the third pillar pension scheme. I got an offer from Foyer and I am no sure whether it is financially a good option to take.

I made a small Excel model for this end.

*The file is located here. Sheet Calc 1.0 shows the* ***original*** *numbers. Sheet Calc 2.0 shows the* ***new figures.*** *The only change is the amount invested into the ETF.*

[https://www.dropbox.com/scl/fi/qup7dezdttu89jv684326/ETF-vs-Pension-Analysis\_shared.xlsx?rlkey=m4gvyk8vxdsgiqrootopkhaag&dl=0](https://www.dropbox.com/scl/fi/qup7dezdttu89jv684326/ETF-vs-Pension-Analysis_shared.xlsx?rlkey=m4gvyk8vxdsgiqrootopkhaag&dl=0)

​

**1.1 Pension plan mechanism**:

€3200 tax deductible paid over 12 installments per year. I would invest the funds in the most aggressive of all – LU0090697987, which has had a performance of **9.44% p.a.** over last 10 years as per this source: [https://www.finanzen.ch/fonds/capitalatwork-foyer-umbrella-contrarian-equities-at-work-c-lu0090697987](https://www.finanzen.ch/fonds/capitalatwork-foyer-umbrella-contrarian-equities-at-work-c-lu0090697987)

I understand its a minimum commitment of 10 years for it to qualify for the tax deduction. Exiting would incur in fees.

**1.2 Pension plan Taxes**

* I am assuming a personal effective tax rate of 39%. This means that after tax declaration I can get €3200 x 39% = €1,248 back every year from year #2. Below I will assume I reinvest this 100% into a cheap ETF
* Taxation at maturity or payout: I have read it should lie between 15 and 21%. This depends on personal situation and country where you live. To be conservative, assuming 20%.

**1.3 Pension plan Fees**

I got this offer:

* Entry fees (per transaction) = 2%. Thus 266.67 x 0.02 = €5.33
* Management fees = 0.1% per month of the amount in the fund

**1.4 Pension plan return**

* Investing 266.66 euros per month minus 5.33 for net investment €261.33
* Paying 0.1% monthly management fees. This means that (1+0.1%)\^12 – 1 = 1.207% effective fees p.a. However, in my Excel I calculate all on a monthly basis
* I am 34.5 years old. This means that after 367 months (aged 65) the portfolio will be **€400.2k** (see XLS)
* I reinvest the €3200 \* 39% tax rate = €1248 every year *from year #2* over the same timeframe to a cheap ETF. I am assuming S&P which has had return over last 10Y of 11.39% and usually is offered at TER of 0.07%. This would give **€280.8k** at maturity

**1.5 Result**

* Foyer taxes at payout are 20%, leaving **€322.1k** of Foyer
* In Lux there are no capital gain taxes. If I live there, I get the **€280.8k**
* However, to be conservative I assume I will live in Germany where capital gain tax is about 26.5% (excl. church taxes). Thus, net I get **€216.2k**

Thus, at the end, I will have invested €97.9k (367 periods x €266.66 euros) into the fund and €37.4k into the ETF and at maturity I will get **602.9k** back if I live in Lux, or **€538.3k** back if I live in Germany.

​

**2.1 ETF mechanism**

~~For real comparison, one has to assume one invests not €3200/12 in an ETF but only the amount considering the tax benefit i.e. €3200/12\*(1-39%) = €162.67~~

I invest into an ETF the same €3200 in monthly installments.

**2.2 ETF Taxes**

I assume in invest in an ETF which accumulates capital. Thus, no taxes until retirement assuming zero withdrawals.

Taxes upon withdrawal in Lux are zero if the asset is held at least for 6 months. I will assume 100% of the portfolio meets this criterion.

In Germany, taxation on ETFs depends on whether they distribute dividends or accumulate them. On distributing you pay taxes on the dividends, on accumulating you pay taxes on the fictive value increase. However, there is a threshold p.a. of €1000 of capital income where in Germany you don’t pay taxes. For simplicity, I assume accumulating ETF and exclude the YoY taxation but charge it all at maturity. The capital gains tax excl. church tax is 25% \* (1+5.5%) = is 26.375%.

A guide (in German) for taxation of ETFs is here [https://www.justetf.com/de/news/etf/etf-und-steuern-das-neue-investmentsteuergesetz-ab-2018.html](https://www.justetf.com/de/news/etf/etf-und-steuern-das-neue-investmentsteuergesetz-ab-2018.html)

**2.3 ETF Fees**

As noted above, I assume 0.07%, which is common for S&P 500 with a cheap broker on a savings plan i.e. no extra costs on the transaction.

**2.4 ETF Return**

As noted above, historically over last 10Y IE00B5BMR087 has returned 11.39%.

[https://www.finanzen.ch/etf/ishares-core-sp-500-etf-ie00b5bmr087](https://www.finanzen.ch/etf/ishares-core-sp-500-etf-ie00b5bmr087)

2.5 ETF Result ***(with revision)***

* Portfolio value at maturity is at **~~€466.9k~~** **€765.3k.**
* In Lux without capital gain tax, you get **~~€466.9k~~** **€765.3k.** In Germany, under assumptions above I would get **~~€358.7k~~** **€588.1k**
* Of course, it is unlikely I would liquidate my portfolio all at once in one go but I assume this for comparison purposes. In reality, it is to be expected that I would be doing rebalancing to fixed income assets. I ignore this, too.

​

**3.0 Overall Result and Conclusion**

* With my numbers, considering capital gain tax (in Germany), ~~Private Pension~~ **~~€538.3k~~** ~~beats private ETF~~ **~~€358.7~~** ETF **€588k** beats Private Pension **€538k**
* Without capital gain tax (in Lux), ~~it still beats it at~~ **~~€602.9k~~** ~~versus~~ **~~€466.9k~~** the result is more pronounced with gap of **€162k** favourable for ETF
* **This is only** **~~possible if and only if~~** **despite you reinvest the tax benefit returned from the finance ministry**
* ~~I made a sensitivity analysis and the amount you need to reinvest of tax benefit to achieve the same result at maturity. This amounts to~~ **~~€212~~** ~~p.a. living in Germany or~~ **~~€643~~** ~~living in Luxembourg.~~

[Previous Results ](https://preview.redd.it/bea266w8595c1.png?width=799&format=png&auto=webp&s=f318650edd6003722ef218ada00d61928c428d02)

[New results](https://preview.redd.it/t0achcpzqm5c1.png?width=765&format=png&auto=webp&s=ae8da0f8f959555b2d36a24c225e17c457b4118c)

**4.0 Further pros/cons of pension fund**

* Pro: Money is better protected in cases of law suits, divorces, private bankruptcy, etc.
* Pro: Forces you to invest due to contractual obligation
* Cons: It is not liquid
* Cons: Someone else manages your money and at very high fees
* Cons: It only makes sense if you reinvest the tax benefit fully into a cheap and well performing ETF. In reality, it is difficult to expect one to diligently do it over >30Y

​

This conclusion ~~differs~~ is in lien with the one I saw on two other posts (links below). Can you please confirm whether my calculations and assumptions are correct? What are you thoughts on that ? Am I missing anything ?

Thank you!

​

Similar posts I reviewed before doing this analysis:

[https://www.reddit.com/r/Luxembourg/comments/lgcnr1/luxembourg\_private\_pension\_plan\_is\_it\_worth\_it/](https://www.reddit.com/r/Luxembourg/comments/lgcnr1/luxembourg_private_pension_plan_is_it_worth_it/)

[https://www.reddit.com/r/Luxembourg/comments/c1zab3/pension\_plan\_with\_foyer\_did\_i\_make\_a\_mistake/](https://www.reddit.com/r/Luxembourg/comments/c1zab3/pension_plan_with_foyer_did_i_make_a_mistake/)

by DonTaquero

5 comments
  1. Bravo for the detailed post! Your approach is different from the other posts as you consider that you will reinvest the tax benefit. That gives you the extra revenue that makes it more profitable. You also mention that you will rebalance the ETF into fixed income assets, certainly at lower income, but that can make it again less profitable, depending on your strategy there.

  2. Probably one of the best analyses I’ve seen on any financial topic on this sub over the past couple of years.

    Only things you aren’t speaking to are the additional 7% solidarity tax, and the (I assume) high chance that you would receive pay increases taking you into the 40% and 41% brackets over the coming 30 years. Whilst we don’t know the effective tax rates during this time, it is almost certain to factor in at some point. Overall though the impact is probably pretty equivalent for either option.

    I went for the 3rd pillar after my analysis, and for what it’s worth Foyer’s fee structure is significantly cheaper over the lifetime compared with the rest of the options in the market (as at Dec 21).

  3. I did the exact same thing and concluded that the tax benefit outweighs the cons even if I hate feeding the insurances to this degree.
    Couple of things I included in my considerations:
    – allocate 100% in a guaranteed return fund with lower management fees. I consider this like a low yield savings account with guaranteed capital and cumulative tax benefit.
    – stopped at 60 years instead of 65
    – included the possibility to stop contributing whenever I please, i.e. if I retire early and want to move abroad between 50 and 60 i just let it run to 60 and then cash out.

    There is no way this product would ever be sold if it weren’t for the tax benefit. Taxpayers are effectively subsidizing big insurance companies, it’s so sad that this product is being sold as taking your pension matters in your own hand to have a safe retirement. If the legislator were after that, they’d allow for a proper scheme in which the taxpayer can choose to invest into whatever they want at much lower fees.

    Btw, small correction to OP: you’re assuming a marginal tax rate of 39%, not an effective one.

  4. Thanks for this very interesting and detailed analysis. However I think that you did a slight logical error and **double-counted** the tax benefit of the pension plan in your comparison, which as a result underestimates the return of your ETF plan.

    You are correct and smart to assume that you reinvest the tax benefit of the pension plan to calculate the return of the pension plan. But if you do that and want to have a valid comparison with the ETF plan, you have to assume that you invest the same amount in the ETF plan (3.200 €) than in the pension plan. But in your example you subtract your marginal tax rate from the gross amount that you invest per year, and as a result only invest 61%*3.200=1952€ in the ETF plan. Therefore you double count the tax benefit.

    To illustrate and better explain my point here an example. A comparison between plans is valid, if for a given gross income you arrive at the same net disposable income after taxes and investment. Given a salary of 100.000€/year (for simplicity I assume a **flat** tax rate of 39% instead of the marginal rates):

    **Pension plan:**

    * Gross: 100.000 €
    * Investment: 3.200 € –> Amount left: 96.800 €
    * Tax (39%): 0.39*96.800=37752€ –> Amount left: 59.048€
    * Tax benefit reinvested: 3200*0.39=1248€ –> Amount left: **57.800€**

    **ETF plan** (with your reasoning):

    * Gross: 100.000 €
    * Tax (39%): 39.000€ –> Amount left: 61.000€
    * Investment: (1-0.39)*3200=1952€ –> Amount left **59.048** €

    So you would have more money left in your ETF plan example, hence why you would need to invest 3.200€ and not 1.952 €. (To calculate the precise net amount left you would need to calculate with the marginal tax rates and not a flat rate as I did. But the results and conclusions should not be impacted too much by this simplification)

    To summarize, you do an analysis with a slight mistake in my opinion, and therefore also get to the wrong conclusion that it is beneficial to invest into the pension fund instead to invest in ETFs. The short-term tax benefit of pensions plans does generally not offset the higher costs of them in the long term in comparison to an all ETF plan (Even more so when you consider that you have to pay taxes when your pension plan is paid out to you). Hence it is in my opinion advisable to invest only in ETFs (stocks and bonds) and not in a pension plan.

  5. I did a similar calculation few months back when the Foyer salesmen were bugging me.

    |**.**|**Annual Figures**|**Input**|**Inscription**|**Management**|**.**|**.**|
    :–|:–|:–|:–|:–|:–|:–|
    |**.**|**.**|**€ 3,200.00**|**2.00%**|**1.20%**|.|.|
    |.|.|.|.|.|.|.|
    |**Year**|**Input Sum**|**Effective Cost**|**Costs**|**Costs**|**Investment Sum**|**Investment / Input**|
    |1|€ 3,200.00|€ 1,839.68|€ 64.00|€ 38.40|€ 3,097.60|96.80%|
    |2|€ 6,400.00|€ 3,679.36|€ 64.00|€ 37.17|€ 6,196.43|96.82%|
    |3|€ 9,600.00|€ 5,519.04|€ 64.00|€ 74.36|€ 9,258.07|96.44%|
    |4|€ 12,800.00|€ 7,358.72|€ 64.00|€ 111.10|€ 12,282.97|95.96%|
    |5|€ 16,000.00|€ 9,198.40|€ 64.00|€ 147.40|€ 15,271.58|95.45%|
    |6|€ 19,200.00|€ 11,038.08|€ 64.00|€ 183.26|€ 18,224.32|94.92%|
    |7|€ 22,400.00|€ 12,877.76|€ 64.00|€ 218.69|€ 21,141.63|94.38%|
    |8|€ 25,600.00|€ 14,717.44|€ 64.00|€ 253.70|€ 24,023.93|93.84%|
    |9|€ 28,800.00|€ 16,557.12|€ 64.00|€ 288.29|€ 26,871.64|93.30%|
    |10|€ 32,000.00|€ 18,396.80|€ 64.00|€ 322.46|€ 29,685.18|92.77%|
    |11|€ 35,200.00|€ 20,236.48|€ 64.00|€ 356.22|€ 32,464.96|92.23%|
    |12|€ 38,400.00|€ 22,076.16|€ 64.00|€ 389.58|€ 35,211.38|91.70%|
    |13|€ 41,600.00|€ 23,915.84|€ 64.00|€ 422.54|€ 37,924.84|91.17%|
    |14|€ 44,800.00|€ 25,755.52|€ 64.00|€ 455.10|€ 40,605.75|90.64%|
    |15|€ 48,000.00|€ 27,595.20|€ 64.00|€ 487.27|€ 43,254.48|90.11%|
    |16|€ 51,200.00|€ 29,434.88|€ 64.00|€ 519.05|€ 45,871.42|89.59%|
    |17|€ 54,400.00|€ 31,274.56|€ 64.00|€ 550.46|€ 48,456.97|89.08%|
    |18|€ 57,600.00|€ 33,114.24|€ 64.00|€ 581.48|€ 51,011.48|88.56%|
    |19|€ 60,800.00|€ 34,953.92|€ 64.00|€ 612.14|€ 53,535.34|88.05%|
    |20|€ 64,000.00|€ 36,793.60|€ 64.00|€ 642.42|€ 56,028.92|87.55%|
    |21|€ 67,200.00|€ 38,633.28|€ 64.00|€ 672.35|€ 58,492.57|87.04%|
    |22|€ 70,400.00|€ 40,472.96|€ 64.00|€ 701.91|€ 60,926.66|86.54%|
    |23|€ 73,600.00|€ 42,312.64|€ 64.00|€ 731.12|€ 63,331.54|86.05%|
    |24|€ 76,800.00|€ 44,152.32|€ 64.00|€ 759.98|€ 65,707.56|85.56%|
    |.|Total effective costs|€ 44,152.32|.|Total investment|€ 65,707.56|.|
    |.|Effective gains|€ 7,131.48|.|Net after taxes|€ 51,283.80|.|
    |.|**Total return**|**16.15%**|.|.|.|.|
    |.|**CAGR**|**0.63%**|.|.|.|.|

    What I’m doing here is simply calculating the cost/advantage of putting the money into the scheme itself. That gets you a 16.15% gain over 24 years, or a miserable CAGR of 0.63%. The “effective cost” is the money you pay out of pocket outside of the tax deduction to reach that 3200€ investment limit.

    I don’t take into account the actual fund performances because that is not something exclusive to the third pillar, and I can go by myself and look at what the Foyer fund offerings are using as their investments: https://www.capitalatwork.com/wp-content/themes/capitalatwork/documents/FINRPT_UMB_ANN_202212_EN.pdf

    (Also: the funds under management they have is absolute peanuts, for example that fund is only 165M)

    The 100% “ESG Equities at Work” with the highest gains are listed on page 64 of that PDF, and in my view they are complete trash.

    The gains in my view are just too low for the fact that your money is stuck somewhere where you can’t access it, and also stuck with an investment instrument that is probably severely underperforming compared to you just doing your own thing, or even using ETFs in the worst case.

    It might be good for people who “leave it and forget it” type of thinking, but especially the management fees that firms are asking for this is just way too large for a passive investment.

Leave a Reply