I started serious Investing Journey in Jan 2000 to create wealth through long-term investing and short-term trading; but as from April 2013 my Journey in Investing has changed to create Retirement Income for Life till 85 years old in 2041 for two persons over market cycles of Bull and Bear.

Since 2017 after retiring from full-time job as employee; I am moving towards Investing Nirvana - Freehold Investment Income for Life investing strategy where 100% of investment income from portfolio investment is cashed out to support household expenses i.e. not a single cent of re-investing!

It is 57% (2017 to Aug 2022) to the Land of Investing Nirvana - Freehold Income for Life!

Click to email CW8888 or Email ID : jacobng1@gmail.com

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

Tuesday, 2 August 2011

XIRR is really simple to use!

Read? How are you measuring up with your investment return? (2)

Read? Have you started using CAGR or XIRR to measure your portfolio performance?

You just need to seperate into two different worksheets in your MS Excel file for 1) detailed recording of transactions and tracking of portfolio and 2) measuring of portfolio performance and returns on capital using XIRR.

Here are snapshots of examples:

Portfolio Tracking


Sometime, two steps are simpler than one step for all. Believe it or not.


  1. Hi CW, kindly check for the use of XIRR, you measure the portfolio performance since the start of your investment or on yearly basis?

    I have learnt to use XIRR from your blog but wondering hard in my mind on the use of XIRR is to measure the performance of one's portfolio on a yearly basis or since start of investment.

    Currently I use on yearly basis to know how my portfolio performance when compare to previous year. Is it right to use this way?

  2. Hi 1000 Miles,

    No problem with year-on-year XIRR or XIRR since investment as we just need to know how are we doing with our current investing strategies and benchmark this XIRR value against our investing goals.

    E.g. our investing goals may be

    1. Beating inflation of 4%
    2. Beating average market returns of 8%
    3. Double current portfolio in 10 yrs without adding capital
    4. etc.

    If XIRR is too low, then we may need to revise our investing strategies; otherwise we may not meet our investing goals.

    Generally, we would like to see this XIRR value to be more positive year after year and trending upwards. :-)

  3. Hi CW,
    Thanks for your advise and valuable knowledge.

    Ya, I managed to beat the increasing inflation and my target return.

    Another question is on CAGR. How would you calculate CAGR if there is continue increase in capital over the years? Is it (portfolio value over total capital to date) to the power (1/years investing) -1?

    Appreciate your advise. 10U

  4. Hi 1000 Miles,

    For investors who are still injecting new investing capital into their portfolio should use XIRR.

    For those not adding more capital, can choose either XIRR or CAGR. CAGR is commonly used when XIRR was not developed yet.

    Since MS Excel is commonly used, stick to XIRR


Related Posts with Thumbnails