Jump to content

How to calculate total TER of ETF portfolio


Guest theshidoshi

Recommended Posts

Guest theshidoshi

How to calculate total TER for an ETF portfolio

renderTimingPixel.png

Hi guys

I am a new investor and as I have been learning about ETF portfolio structuring and key things such as keeping a low TER.

I am shifting my portfolio to ETF portfolio and I am not sure how to calculate an aggregate TER for the portfolio. I am not sure I am doing the total TER calculation for all 7 ETFs correctly.

Example of my ETF structure:

Percentage of holding - ETF - TER

  1. 40% in CSP1 TER 0.07%
  2. 20% in CUKX TER 0.07%
  3. 10% in IUKP TER 0.40%
  4. 10% in GBDV TER 0.45%
  5. 10% in SWDA TER 0.20%
  6. 5% in EMIM TER 0.18%
  7. 5% in SGLN TER 0.25%

 

Do I calculate it in the following way:

A) Sum of all 7 ETF TERs = 1.62%

B) Average of all 7 ETF TERs = 0.23%

C) Or more complex calculation considering the TER of each ETF in relation to its position size (e.g 40% in CSP1 with TER of 0.07% vs. 5% in EMIM with TER of 0.18% means its a lot cheaper than the simple addition of both TERs)

 

Any explanation with an example would be most helpful.

Thank you

Link to comment

Hi @theshidoshi

The answer is C. You need to weight the TER of each ETF by its weight in your portfolio.

In Excel, if you had the weights in column A and TER’s in column B, you could use the SUMPRODUCT function to find the TER for your portfolio.

I’ve calculated this for you and I got a TER of 0.1685%. Let me know if you've got any other questions!

Kind regards,

Sam

Link to comment
Guest theshidoshi
2 hours ago, samd_IG said:

Hi @theshidoshi

The answer is C. You need to weight the TER of each ETF by its weight in your portfolio.

In Excel, if you had the weights in column A and TER’s in column B, you could use the SUMPRODUCT function to find the TER for your portfolio.

I’ve calculated this for you and I got a TER of 0.1685%. Let me know if you've got any other questions!

Kind regards,

Sam

Thank you so much. I learnt a lot. I do have one question. My example above is the future weighting.

 

I tried it with my current portfolio I am trying to restructure and got a TER that is much much lower than I expected. I tested with our example above and ot worked but when applied to my current holdings it comes up with 0.05% which I find strange

 

Below is the ETF table (currently only 25% of my ISA portfolio)

Symbol - TER - Weighting

CSP1 0.07% 8.62%
CUKX 0.07% 3.99%
IUKP 0.40% 2.47%
EMIM 0.18% 1.02%
GBDV 0.45% 3.59%
SWDA 0.20% 3.18%
SGLN 0.25% 1.65%

 

I used the formula:

=SUMPRODUCT(A1:A7,B1:B7)

Answer 0.05%

 

How is that possible with such low TER?

Link to comment
1 hour ago, theshidoshi said:

Below is the ETF table (currently only 25% of my ISA portfolio)

If you are just finding the TER for the portion of your portfolio that is invested in assets that have an annual expense then I would recommend either using weights for this part that sum to 100%, or to gross up the weights as shown in the screenshot below.

Both methods should get to the same answer, which I've calculated as 0.19% (2 d.p)

TER.PNG.0e438cb85d2164dfb59a2bd534fbafda.PNG

TER2.PNG.ff87db95403900d90e7cf13f70c0aaad.PNG

 

That should do the trick. Let me know if you've any other questions!

Link to comment
  • 1 month later...
Guest theshidoshi

I just wanted to say thank you. This has worked for me beautifully now in Excel. I completely understand it.

 

Now I am learning how to do this in Python as it is a language I am trying to learn for Finance & Investing.

 

Many thanks

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • General Statistics

    • Total Topics
      20,788
    • Total Posts
      89,814
    • Total Members
      40,697
    • Most Online
      7,522
      10/06/21 10:53

    Newest Member
    RandomSyntax
    Joined 09/12/22 15:09
  • Posts

    • Week ahead 12/12/22: Fed, BoE, ECB decisions With little or no corporate data we focus in on central bank decisions at the Federal Reserve (Fed), Bank of England (BoE) and European Central Bank (ECB). IGTV senior analyst, Joshua Mahony, discusses trades around the volatility index, the VIX, EUR/USD and the S&P 500.      
    • Charting the Markets: 9 December FTSE 100, DAX 40 and CAC 40 regain lost ground ahead of US PPI data. EUR/USD, GBP/USD, and AUD/USD look to continue their bullish two-month trend. And gold and natural gas edge higher but oil prices keep falling.         This is here for you to catch up but if you have any ideas on markets or events you want us to relay to the TV team we’re more than happy to.
    • EUR/USD, GBP/USD and AUD/USD look to continue their bullish two-month trend EUR/USD, GBP/USD and AUD/USD look set to continue their bullish momentum, with recent worries cast aside for now.    Joshua Mahony | Senior Market Analyst, London | Publication date: Friday 09 December 2022  EUR/USD continues to push higher after recent pullback EUR/USD has seen a more upbeat tone over the second half of the week, with the dollar strength seen on Monday and Tuesday fading to give way to another push higher for this pair. Markets appear to be in a state of flux, with inflationary concerns reemerging in the wake of last Friday’s jump in US average earnings. Today sees the release of the US producer price index (PPI) inflation figure, bringing potential volatility if we see factory prices head higher. China certainly has little to worry about on that front, with both consumer price index (CPI) (1.6%) and PPI (-1.3%) well below target thanks to cheap Russian fuel and lockdown restrictions. For EUR/USD, we would need to see a move back below the $1.029 swing-low to bring about a fresh bearish signal after two-months of upside for the pair. Until then, the bulls remain in the driving seat. Source: ProRealTime GBP/USD pushing back into key resistance GBP/USD also saw a somewhat downbeat start to the week, with the pair heading lower from the crucial $1.2293 swing-high resistance level. That August high provides a crucial hurdle up ahead for bulls, with a push through that point bringing expectations of another leg higher from here. The uptrend in place over the course of the past two-months has brought expectations of further upside unless we see that ongoing pattern of higher lows end. With that in mind, a bullish view holds unless the price falls back below the $1.19 level. Keep an eye out for the UK consumer inflation expectations figure released at 9.30am this morning. Source: ProRealTime AUD/USD struggling to maintain recovery pace AUD/USD has similarly been attempting to regain ground today, with the gains seen across EUR/USD and GBP/USD failing to carry through here. This could signal a potential waning of the bullish momentum, with the fact that these pair have been slowing in their ascent of late serving to highlight the potential for another bearish reversal in the near-future. That would tally up with what is happening in equity markets, which have shown initial tentative signs of a turnaround before long. With that in mind, watch out for a break back below the $0.664 level to signal a bearish turn for this pair. Until then, the uptrend evident over the past two-months does remain in play. Source: ProRealTime
×
×
  • Create New...