Jump to content

How to calculate total TER of ETF portfolio


theshidoshi

Recommended Posts

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
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!

  • Like 1
Link to comment
  • 1 month later...

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
      16,607
    • Total Posts
      79,295
    • Total Members
      65,096
    • Most Online
      7,522
      10/06/21 10:53

    Newest Member
    Madiha
    Joined 30/11/21 23:07
  • Posts

    • PONZI SCHEME 2 The  articleD by Kevin Stankiewicz makes an interesting point and the definition he points out is ALSO true, in my view.    "Ponzi scheme is a type of fraud whereby crooks steal money from investors and mask the theft by funneling returns to clients from funds contributed by newer investors."    But taking it as it is then we can apply it to various other areas, seemingly. FOR EXAMPLE:    Q.E. encourages and creates greater and greater debt build up, and entraps all financially into  over debtedness, as encouraged by  the Monetary Theory used by the FED. In the end it collapses and various clever but complex solutions are advised by the same people who used flawed theories as being gospel truth.  A financial nuclear bomb gone off, markets crashes big time, a recession or depression ensues. All suffer. The flaws in the system are ignored or not recognised, during the frency of making a billions in profit. So, we have a roller coaster system.    Majority of companies and millions of people who were not involved in it suffer AND THE COUNTRY'S TAXPAYER HAS TO PAY FOR it ALL THOSE SUBSIDES THAT THE GOVERNMENTS ARE ADVISED TO DO (PLAUSIBLE REASONS USED ). It becomes covert stealing by funneling indebted businesses and banks who's debts get shifted to the central banking system or by tax write offs so effectively charging the government, by "professional" advise, to take on toxic debts to "save" the economy and the system from "collapsing", and the politicians from losing popularity or the Office.    Now, as reported in the media, a Debt Jubilee is being considered as a "solution". It has been used is past history too. But it did NOT WORK IN THE PAST AS WE HAVE ENDED UP WITH A SIMILAR PROBLEM NOW.     Those who have studied the financial history and John Law and the "Mississippi Scheme and bubble, and the "South Sea Bubble" that was in the similar time using his idea gives rise to out current system.    The Banking System was supposed to be a fractional system where a portion of income from depositors is supposed to be used for lending. Today this has been made extremely complex by lending x amount and this end product is again it is used as a derivative. Risk taking has gone in a frency. It just needs a major collapse,  to create a falling domino effect.    So, the question comes back to:   WHAT IS A PONZI SCHEME?    AND WHO RECOGNISES THE PRIMARY CAUSE, THE WHY OF THE WHOLE SITUATION IN THE PRACTICE OF FINANCE AND ECONOMICS. FOR GOOD RULES AND GUIDELINES OF PAST GENERATIONS HAVE BEEN OVER LOOKED.    CAN ANYONE FIGURE THOSE OUT?    “I cannot teach anybody anything. I can only make them think”    “Strong minds discuss ideas, average minds discuss events, weak minds discuss people.” ― Socrates      
    • Exactly This !! Chris Sky, right then and now. All adds up to enforced Chinafication.     Meanwhile, The very strict mask mandate in Germany is clearly ... err ... not working.       And of course ... Triple vaxed doctor gets Covid, passes it to another triple vaxed doctor. Solution: more boosters and keep banning those unvaccinated super spreaders from society. Two Israeli doctors infected with Omicron, hospital says | Reuters   And 1 sane politician.  
    • it's all in the thread, shame you never read it before jumping in with your opinion of it, it would save a lot of your time and confusion.
×
×
  • Create New...