As from April 2013 my Journey in Investing is to create Retirement Income for Life till 85 years old in 2041 for two persons over market cycles of Bull and Bear.

Click to email CW8888 or Email ID :

Welcome to Ministry of Wealth!

This blog is authored by an old multi-bagger blue chips stock picker uncle from HDB heartland!

"The market is not your mother. It consists of tough men and women who look for ways to take money away from you instead of pouring milk into your mouth." - Dr. Alexander Elder

"For the things we have to learn before we can do them, we learn by doing them." - Aristotle

It is here where I share with you how I did it! FREE Education in stock market wisdom.

Think Investing as Tug of War - Read more? Click and scroll down

Important Notice and Attention: If you are looking for such ideas; here is the wrong blog to visit.

Value Investing
Dividend/Income Investing
Technical Analysis and Charting
Stock Tips

Thursday, 4 August 2011

XIRR is really simple to use! (2)

Read? XIRR is really simple to use!

You may have been using XIRR to measure portfolio performance and may have faced these two common issues:

  1. Cash withdrawal from your portfolio for spending (exchange your investment dollars to enjoy life)
  2. Cash injection into your portfolio as new capital for investing

Cash Withdrawal will improve XIRR

See the following examples for Investor A . His XIRR and his investment portfolio.

His XIRR as on 31 Dec 2011 since investment = 14.3%

Assuming he has decided to withdraw $10K cash  from his investment portfolio for his overseas holidays trip.

So after withdrawing $10K from his investment portfolio, his XIRR will look like this:

His XIRR immediately improves from 14.3% to 14.5%. The more money he spent from his investment portfolio and more his XIRR improves. This is really NONSENSE!!!

For cash withdrawal from investment portfolio, we will have to make pro rated adjustment to both Capital and Realized Gains.

Here is the Maths:

Firstly, you have to express Capital and Realized Gains in the investment portfolio as ratio:

  1. Capital as ratio of Total Capital and Realized Gain
  2. Realized Gains as ration of Total Capital and Realized Gain
See an example of withdraw $10K from the investment portfolio for Investor A.

After his cash withdrawal of $10K from his investment account; his XIRR dropped slightly from 14.3% to 13.6% , partly due to the effect of Unrealized losses in his portfolio.

Cash injection into your portfolio as new capital for investing

When you have spare cash from your earned income that you want to invest. There is no need to immediately inject it into your investment portfolio as NEW capital and account it in XIRR formula if you haven't use this cash to purchase any stocks yet. This will help to make your XIRR looked much better. Similarly, don't deceive yourself by removing some old capital in your investment portfolio and improves XIRR too. LOL

1 comment:

  1. Hi CW,

    I think another option would be looking down to the portion of portfolio one sell, then subtract the realized P/L to the amount one withdraw. Just that more tedious work.


Related Posts with Thumbnails