Expense Ratio Calculator
The expense ratio calculator is a fantastic tool that helps you to understand how much you will pay for the performance of your exchangetraded 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 (
). 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 their costs are 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 (
).But how does it affect the return on 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). 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 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
, 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
as a benchmark: 13.59%. 
When we have already found a great 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:

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

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

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

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

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

$\small \rm{Er}$ = Expense ratio.
Then, the formula for Initial investment future value (FVI):
where:
 $\small \rm{r_{effective}}$ is the result of $\small \rm{r_{effective}}  \rm{Er}$;
and for the periodic investment future value (FVPI):
Finally, for the future value of the total investment (FVTI), we will have:
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 $\small\rm Er$ 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.
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:
vs. .ARKK is an ETF that covers probably the most innovative and disruptive companies. Let's take a brief look: Tesla (
) is an electrical vehicle automaker that already provides selfdriving vehicles. This company, by the 20th of November, represents 9.71% of the total ETF. Moreover, SLACK ( ) 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:
Initial investment = 10,000 USD
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 you can find
, we get:Duration of investment = 6 years
Yearly expected investment return = 30.97%
Expense ratio of 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
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.
Effective investment return = 30.22%
Initial investment final value = 48,760.27 USD
Periodic investment final value = 64,130.17 USD
Now, we are going to do the same calculation but with the
:Yearly expected investment return = 13.59%
Expense Ratio SPY = 0.0945%
and by using our expense ratio calculator, we get:
Future value of total investment = 63,510.74 USD
Total cost of ETF = 207.66 USD
Similar to the case before, the extra information of the advanced section is:
Effective investment return = 13.49%
Initial investment final value = 21,373.31 USD
Periodic investment final value = 42,137.43 USD
In conclusion, we can say the following:

It is clear to see that the compound interest effect over time of the 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 $\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 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 lowreturn years. So it is strongly recommended to check how diversified the security is, especially the leading positions.