Expense Ratio Calculator

Created by Arturo Barrantes
Reviewed by Steven Wooding
Based on research by
Dariusz Filip Expense Ratio as an Effect of Fund Attributes' Impact Annales Universitatis Mariae Curie-Skłodowska (April 16, 2019)See 1 more source
Morningstar Morningstar's Annual Fund Fee Study Finds Investors Saved Nearly $6 Billion in Fund Fees in 2019 (June 9, 2020)
Last updated: Nov 24, 2022

The expense ratio calculator is a fantastic tool that helps you to understand how much you will pay for the performance of your exchange-traded funds (ETF) investments. In other words, it simplifies even the most effortless security, the ETFs. In this article, we will cover what an ETF is and how the expense ratio is related to it. We will also discuss what is a good ETF expense ratio and conclude by comparing it to famous ones: the SPY ETF and the ARKK ETF.

What is an ETF?

An ETF is a type of security that allows you to invest in a group of different companies at once. It is similar to a basket of several stocks. Components of an ETF are also known as holdings and are always diversified, meaning that you will find several different companies in the basket.

The main advantage of an ETF is that it allows you to quickly diversify your investment without needing a lot of money. For example, let's start with probably the most famous ETF: SPDR® S&P 500® ETF Trust (NYSEARCA: SPY). It contains approximately 500 companies which are known as the most representative of the USA stock market. Three of its components are:

  • Apple (SPY portfolio weight 6.40%);
  • Microsoft (SPY portfolio weight 5.40%); and
  • Amazon (SPY portfolio weight 4.47%).

Those three represent 16.27% of the total ETF, or in other words, there is 83.73% of the SPY portfolio weight distributed in other companies. The current cost of this ETF is 357 USD (November 23th, 2020), meaning that your 357 USD investment will be distributed in the 500 companies accordingly to their portfolio weight, without requiring you to buy each of these stocks.

However, ETFs are not free. Please keep reading to find out what are their costs and how it impacts your investment performance.

What is the expense ratio?

The expense ratio is a fee charged by mutual funds and ETF providers for the concept of managing the assets in the fund. We can call it the maintenance fee of the investment. It usually ranges between 0.1 to 1%, but it can go as low as 0.045%, like in the SPY case, and up to 2.95%, like in the case of Global X SuperDividend® Alternatives ETF (NASDAQ: ALTY).

But, how it affects the return of your investment? Well, all ETFs and mutual funds have a yearly historical performance expressed in a percentage (in our expense ratio calculator it's called: Yearly expected investment return \small \rm{ Yearly \ expected \ investment \ return}). That is probably the most advertised value because it shows how much money the ETF and fund are expecting to be making in the next years.

However, that's not the money you receive. The actual performance of your investment is the ETF/fund performance minus the Expense ratio \small \rm{ Expense \ ratio} you will have to pay every year.

Here it is important you remember the effect of the compound interest and the time value of money concept. Both explain how important those fees are. You might think that 0.1% is nothing, but if you add it to the compound interest calculator and simulate its effect through several years, it might become a relevant chunk of your money.

What is a good expense ratio?

According to Morningstar, the average ETF price is 0.45%. So, at first sight, any ETF expense ratio above that value has to justify its costs with an outstanding performance.

There are three main points we have to take into consideration when choosing an ETF as a long term investment:

  • We should always look for an ETF with a historical return higher than the general market's return. We can take the 10 years return of the SPY as a benchmark: 13.59%.

  • When we already have found a great Yearly expected investment return \small \rm{ Yearly \ expected \ investment \ return}, we should look at the primary holdings and analyze its risk.

  • Whenever it is possible to predict inflation through the duration of the investment, we should consider it as a yearly interest rate we should beat. If you are interested in to a calculator that includes effects of inflation, see investment calculator.

So, how to calculate the effect of the expense ratio?

If you already understand how to calculate the future value of money and future value of an annuity this will be easy as pay. If you don't, we suggest checking the future value calculator

The calculation has two parts. The first considers an initial investment for which we will use the formula for the money's future value. The second one considers a yearly periodic investment for which we will use the formula for the future value of an annuity.

We will start defining the variables:

  • I0\small \rm{I_{0}}= Initial investment, or our first deposit;

  • PI\small \rm{PI} = Yearly periodic investment or the money we invest every year;

  • n\small \rm{n} = Duration of investment, or the amount of time we will leave our money to grow;

  • reffective\small \rm{r_{effective}} = Effective investment return which will represent the real compounding rate our investments will have, discounting fees;

  • rexpected\small \rm{r_{expected}} = Expected investment return, based in the historical performance of the ETF; and

  • Er\small \rm{Er} = Expense ratio.

Then, the formula for Initial investment future value(FVI)\small \rm{Initial \ investment \ future \ value (FVI)}:

FVI=Io×(1+reffective)n FVI = I_o \times (1 + r_{effective})^n

where:

  • reffective\small \rm{r_{effective}} is the result of reffective\small \rm{r_{effective}} - Er\small \rm{Er} ,

and for the Periodicinvestmentfuturevalue(FVPI)\small \rm{Periodic investment future value (FVPI)}:

FVPI=PI((1+reffective)n1)/reffective FVPI = PI * ((1 + r_{effective})^n - 1) / r_{effective}

Finally, for the future value of the total investment (FVTI), we will have:

FVTI=FVI+FVPIFVTI = FVI + FVPI

If this was too much, don't worry, we integrate all of them into our expense ratio calculator, so you can play with the numbers as you wish until you get it.

How much does the expense ratio cost you?

For this calculation, we need to use the formulas mentioned above twice. First, considering a certain expense ratio and then without it. Consequently, we will have two future values for the total investment, which, after being subtracted, will result in the total cost.

ETFcost=FVTIwithoutexpenseratioFVTIwithexpenseratioETF_{cost} = FVTI_{withoutexpenseratio} - FVTI_{withexpenseratio}

Of course, our beloved expense ratio calculator includes this functionality already.

Real example: SPY ETF vs. ARKK ETF

For this comparison, we will analyze two of the most famous and trendy ETFs of this year 2020: ARKK ETF vs. SPY ETF.

ARKK is an ETF that covers probably the most innovative and disruptive companies. Let's take a brief look: Tesla (NASDAQ: TSLA) is an electrical vehicle automaker that already provides self-driving vehicles. This company, by the 20th of November, represents 9.71% of the total ETF. Moreover, SLACK (NYSE: WORK) is a company that provides a digital communication platform for work. It currently represents 3.27% of the ETF.

So, suppose we follow the next investing scheme:

Initialinvestment=10,000USD\small \rm{Initial investment = 10,000 USD}

Yearlyperiodicinvestment=5,000USD\small \rm{Yearly periodic investment = 5,000 USD}

Also, imagine we started at the inception of the ETF that was six years ago. Then, by considering the historical return since its beginning, which can you can find on the ARKK's webpage, we get:

Durationofinvestment=6years\small \rm{Duration of investment = 6 years}

Yearly expected investment return=30.97%\small \rm{Yearly \ expected \ investment \ return = 30.97 \%}

Expense Ratio ARKK=0.75%\small \rm{Expense \ Ratio \ ARKK = 0.75 \%}

Thus, by using our friendly expense ratio calculator, we get the following results:

Future value of total investment=112,890.45 USD\small \rm{Future \ value \ of \ total \ investment = 112,890.45 \ USD}

TotalcostofETF=2,916.27USD\small \rm{Total cost of ETF = 2,916.27 USD}

If you enable the advanced mode of the expense ratio calculator, you can get extra information such as the effective investment return you had, how much the initial investment and periodic investment grew.

Effectiveinvestmentreturn=30.22%\small \rm{Effective investment return = 30.22 \%}

Initialinvestmentfinalvalue=48,760.27USD\small \rm{Initial investment final value = 48,760.27 USD}

Periodicinvestmentfinalvalue=64,130.17\USD\small \rm{Periodic investment final value = 64,130.17 \USD}

Now, we are going to do the same calculation but with the SPY ETF information:

Yearlyexpectedinvestmentreturn=13.59%\small \rm{Yearly expected investment return = 13.59 \%}

ExpenseRatioSPY=0.0945%\small \rm{Expense Ratio SPY = 0.0945 \%}

and by using our Expense Ratio Calculator, we get:

Futurevalueoftotalinvestment=63,510.74\USD\small \rm{Future value of total investment = 63,510.74 \USD}

TotalcostofETF=207.66\USD\small \rm{Total cost of ETF = 207.66 \USD}

Similar to the case before, the extra information of the advanced section is:

Effectiveinvestmentreturn=13.49%\small \rm{Effective investment return = 13.49 \%}

Initialinvestmentfinalvalue=21,373.31\USD\small \rm{Initial investment final value = 21,373.31 \USD}

Periodicinvestmentfinalvalue=42,137.43\USD\small \rm{Periodic investment final value = 42,137.43 \USD}

As a conclusion, we can say the following:

  • It is clear to see that the compound interest effect over time of the Effectiveinvestmentreturn\small \rm{Effective investment return} can do a significant effect on your money.

  • Moreover, the expense ratio calculator shows us the cost of each expense ratio, a difference of 2,916.27207.66=2,708.61USD\small \rm{2,916.27 - 207.66 = 2,708.61 USD}, which could definitely have hurt us if the ARKK ETF would not have had such a fantastic return. Consequently, we should only accept a high expense ratio if the Yearlyexpectedinvestmentreturn\small \rm{Yearly expected investment return} will cover the costs.

Finally, do not forget that high returns usually are connected with high risk meaning that the ETF may have low-return years. So it is strongly recommended to check how diversified the security is, especially the leading positions. You can conduct a quick but pretty complete analysis of them using our set of financial calculators.

Arturo Barrantes
Initial investment
$
Yearly periodic investment
$
Yearly expected investment return
%
Expense Ratio
%
Duration of investment
yrs
Future value of total investment
$
Total cost of ETF
$
Check out 152 similar investment calculators 📈
401kAfter-tax cost of debtAltman Z-Score… 149 more
People also viewed…

Bond yield

Our bond yield calculator will help you to calculate the rate of return of your bond investments.

Coffee kick

A long night of studying? Or maybe you're on a deadline? The coffee kick calculator will tell you when and how much caffeine you need to stay alert after not sleeping enough 😀☕ Check out the graph below!

Test grade

With this test grade calculator you'll easily find out the test percentage score and grade.

Turnover rate

If you want to learn what is turnover rate, or estimate it for your company, use this turnover rate calculator.
Copyright by Omni Calculator sp. z o.o.
Privacy policy & cookies
main background