Are you not coming money more than the sale of units, publishing a worthless emerging markets Small Cap ETF?

In the past I have made two spreadsheets to help (and possibly you) watch What it feels like to sell and spend units from a portfolio In the past:

1. Sales and spend units of RTWO, a UCITS, accumulating, more quality and small factor fund with 16.3 years of actual unity history that goes back to September 2008. | Spreadsheet copy link
2. Sales and spend units of IJR, a US invested, distribution, S&P 600 Small Cap Fund with 24.6 years of actual unity history that goes back to June 2000. | Spreadsheet copy link

Both spreadsheet enable you to “feel”:

1. If you see if you start with $ 1 mil and spend it, your portfolio will still be $ 1 mil with different desired income.
2. Coordinate your income and tune to see how much you can push the boundaries of the expenses.
3. Answer The question makes selling units really the portfolio, or is Kyith that if you lower your initial income that is extracted to a conservative number, you can retain capital fairly well.
4. How does it feel to see that you are going down $ 1 mil.
5. See how variable your income is as the income that adapts to actual inflation.
6. These are actual ETF NAV, so you won’t come to Kyith with apologies such as “But these are index benchmark returns and no returns for funds …”

The IJR or Ishares Core Small Cap is only price, which means that it does not include the dividend payment. Not the most accurate, but I can tell you that if the returns are tailored, it also tells you something to play with the numbers. First, it is almost started in the depths of that challenging period of 2000-2002 and Covid went through GFC.

Today I am going to add a funky-size-based index ETF to my list of spreadsheets that you can try.

The index I designed, this spreadsheet is on that of State Street SPDR MSCI Emerging Markets Small Cap Ucits ETF (Ticker: EMSD).

You can make access and make a copy EMSD – Simulation of the Spreadsheet of Portfolio Easters by clicking on this link.

A bit about this index -based ETF:

1. The aim of Index ETF is to MSCI Emerging Markets Small Cap Index (You can view MSCI Emerging Markets Small Cap Index factsheet here))
2. Fund will be taken in on 13 May 2011 (about 14 years of NAV history)
3. Accumulating, which means that it re -invests one of the underlying payment.
4. Domicile in Ireland (15% underlying withholding tax due to the double tax treaty between Ireland and the US, 0% containing tax from fund to investor because deduction tax is 0% for non-residents, not wealth tax)
5. USD expressed.
6. Total cost ratio of 0.55% PA

The spreadsheet has monthly NAV from the fund from 16 May 2011 to 01 August 2025. There are also corresponding data on the consumer price index (CPI) for the period to simulate inflation.

Inflation in these 14 years is 2.57% PA.

The fund compiled average growth is 3.87% PA. The volatility measured by standard deviation is 13.91%.

Kyith, why did you wasted your efforts to create a spreadsheet with a nonsense index spending less than 4% after 14 years?

Well … it’s exactly for this reason.

Because I notice that the creation of the establishment can be what you considered ‘nonsense’.

The table below shows the performance of the fund for different time periods:

The 3, 5, 10-year returns can be what you consider decent for the return of equity, but I noticed that the start result is 4.14% PA, this is no surprise to me see how emerging markets have performed.

First, this is my blog and I am interested in finding some things:

1. I am more interested in seeing the result of realistic, systematic sales units from a stock index that is fleeting, and do not perform well.
2. The index itself may have a more negative series of returns than Would kill your income strategy If you invest 100% $ 1 million of your portfolio in it.
3. You are more interested in testing a strategy that you know will succeed or may die? For me it is the last, because if you know it will succeed, why are you worried about?
4. You get more appreciation if the strategy is based on having lucky returns or it works because it sets up for both happy and unfortunate situations.
5. This is a 100% emerging markets, Small Cap with shares, which is usually not what your adviser will advise on income. People feel that volatility is crazy, small caps are incredibly risky, bad returns, Not suitable for income at all.
6. The fund comprises the total cost ratio.

Well, with this spreadsheet you can push the boundaries.

So I first set the spreadsheet with $ 1,000,000 and we start from the beginning of 16 May 2011.

You can use the drop -down list on the start date to change when you want to start your expenses.

We try to spend 4% of the first portfolio That is $ 3333 monthly. The income will adapt based on the actual inflation of last month, so that you get inflation -corrected income.

Your extracted income rise from $ 3,333 monthly to $ 4,794 a month today after 14 years.

The $ 1 MIL portfolio is going down $ 659,289 Today. You can see the change in the portfolio value during this pension experience. The portfolio reached a low point of $ 423k after 108 months (9 years).

If your pension is 30 years old and in the middle of the point your portfolio is 62% of the original capital, would you feel safe?

What if you have a plan to “die with zero” hahaha.

The spreadsheet also calculates the monthly income from an annual basis by the prevailing portfolio value. We call this the annualized SWR.

My spreadsheet will teach you what all these terms mean.

This graph shows the annual current SWR.

This number tells you:

1. If your SWR is now low enough, if you retire today, it is publishing this income, how long the lake can take. If the number is still very low, your income flow -corrected in inflation is still damn healthy.
2. It shows you that you may want to manage risky by spending less. I would usually place it at around 7-8% current SWR. The area marked in yellow is where the portfolio value went so much compared to the portfolio value. You may want to adjust your income that has been extracted by 10%.

The current annual SWR at the end (August 2025) is 8.73%which is more than 7-8%. This number lasts ($ 4794 x 12) / $ 659,289.

This species shows that the return for this challenging period may not be able to overcome inflation. Although equity to the north of 6% should give nominal returns, we may have to acknowledge that this is a challenging order.

What if we start issuing $ 2,500 a month or an initial 3% safe admission (SWR)?

I would often tell the readers to use 3% on your current portfolio value to estimate how much income for inflation you can possibly extract from the portfolio that can last a long, long time.

Based on my research If you spend lower than a first 3%, this can take longer than 40 years.

We can change the spending on the spreadsheet to show this.

You start with $ 2,500 monthly income and at the end the income takes up to $ 3,596 monthly. Absolutely lower than the use of a 4%, but let’s see if the portfolio looks better:

At the end of the 14 years, the portfolio remains with $ 923k or only 8% less than initial.

You can see that the lowest dip of the portfolio to $ 496,576 was in April 2020. Not to be vary from 4% optical for some people.

But the portfolio value is like this today, so much different.

What is the income / portfolio -valueratio (current SWR) today?

Note this time, the current annual SWR never went above 7% In every month. The highest was 6.88% in that challenging period.

The end SWR is 4.67%, indicating that it can still take a while.

What if we start issuing $ 2,080 a month or an initial 2.5% safe recording rate (SWR)?

The 2.4-2.5% after cost rate is what I hope to assume if they want their inflation-corrected income to be eternal. It is good to see what this looks like.

The portfolio value ends at more than $ 1 mil, at $ 1,056,295.

But your income is 30% less. Worth to be conservative?

The highest that the prevailing SWR went on was 5.3% and today it is 3.4%. Very healthy still.

Epilogue.

Most people try to look for the fund or the investment that perform well, thinking that the return will always be 8-15% PA and that will give them the income they want.

Your return in the future is a series of outcome and one of the outcome can be similar to this MSCI -Op -Opwiksten Small Cap ETF.

Most people will not invest in nonsense (disclosure: this is 0.7% of my Daedalus income portfolio) because they see 4% PA return because they have eliminated Liao.

You know … Some things you invest instead can experience this 4% PA

And if you retire, this is a result that you do not expect mentally.

You fear it because you are afraid that if the return is so nonsense, you will not be able to achieve your financial goal, that is to have a nature of income that you wanted to last long enough.

And so … sometimes I look at seemingly worthless things, so that you might have an answer that you continue to avoid.

If you want to trade these shares I mentioned, you can open an account Interactive brokers. Interactive Brokers is the leading cheap and efficient broker I use and trust to invest my investments and trade in Singapore, the United States, London Stock Exchange and Hong Kong Stock Exchange. This allows you to trade shares, ETFs, options, futures, forex, bonds and funds worldwide of a single integrated account.

You can read more about my thoughts about interactive brokers in These interactive brokers Deep Dive series, Starting making it easy and financing your interactive broker account.

Kyith is the owner and some writer behind investment canals. Readers coordinate investment canals to learn and build stronger, stronger power foundations, how to have a passive investment strategy, to know more about investing in Reit’s and the notes and bolts of active investing.

Readers also follow Kyith to learn how to plan well for financial security and financial independence.

From 2004 to 2019, Kyith worked as an IT operational engineer. He is currently working as a senior solutions specialist in insurance. All opinions about investment canals belong to him and do not represent the views on providing.

You can view Kyith’s current portfolio herethat uses his Free Google Stock Portfolio Tracker.

His favorite investment broker is Interactive brokersAs a result of which he is able to invest in the effects of various stock markets around the world, at very low commission rates, without retention, near spot currency rates.

You can read more about Kyith here.