Skip to main content

XIRR

I bought 500 shares on 1 January 2007 at Rs 220, 100 shares on 10 January at Rs 185 and 50 shares at Rs 165 on 18 May 2008. On 21 June 2008, I sold off all the 650 shares at Rs 655. What is the return on my investment?
XIRR is used to determine the IRR when the outflows and inflows are at different periods. Calculation is similar to IRR's. Transaction date is mentioned on the left of the transaction.

In an excel sheet type out the data from the top most cell as shown here. Outflows figures are in negative and inflows in positive. In the cell below with the figure 4,25,750, type out

=XIRR (B1:B4,A1:A4)*100

Hit enter. The cell will show 122.95%, the total return on investment.

Also used for: Calculating MF returns, especially SIP, or that for unit-linked insurance plans.

Popular posts from this blog

Mutual Fund Review: Kotak Opportunities

    DESPITE a portfolio of around 57 stocks, a large-cap tilt and exposure to derivatives, debt and cash, it is not a fund for the cautious. True to its calling, it scouts for opportunities and doesn't hesitate in taking concentrated sector and stock bets. This leads to extreme returns. In the bull phase (June 15, 2006 to January 8, 2008), it delivered 91.26 per cent against the 81.29 per cent average of other opportunity funds. Unsurprisingly, it shed higher in the bear hug of 2008. While in the recent run up (March 9, 2009 to June 30, 2010) it delivered 85 per cent against its peers 87 per cent. Its charm lies in its capability to identify sector trends ahead of time. In 2005, it rode the FMCG wave and the move paid off. In the first quarter of 2006, it focused on metals. In 2007, its exposure to construction and metals that resulted in a superb performance. In 2008, it was overweight on the least-hit FMCG sector, which helped it get away with an average fall. More recently...

How to invest in the Stock Markets?

Invest In Tax Saving Mutual Funds Online Download Tax Saving Mutual Fund Application Forms Buy Gold Mutual Funds Call 0 94 8300 8300 (India)   One of the trickiest things in life is making a decision when to enter and exit the stock market. Investing in the stock markets is all about timing. Yet the timing is never right .Stocks never seem to reach the optimum price one wants .When share prices are expected to fall down to abysmal levels they rise and are soon out of one’s price range. When share prices are at low levels one keeps waiting for them to hit rock bottom and when they rise one has missed the bus. Stock markets are all about keeping one’s emotions in check. One must stand the true test of time.   What are interest rate sensitive stocks? When interest rates rise consumers who purchase expensive items such as cars on credit might postpone them. Discretionary spending is cut .Customers might postpon...

ASBA Option for Initial Public Offer (IPO)

IPO (initial public offering) applicants, particularly the unsuccessful ones, often have to face a double whammy of sorts. On the one hand they fail to get allotment of shares and on the other, they lose out on the interest during the period their money is locked —that is, if they have opted for the traditional method of issuing cheques for depositing the application money. However, if they choose the ASBA (Application Supported by Blocked Amount) facility, they can circumvent this problem. But do note that you cannot decide to make two applications – one by way of cheque payment and the other through ASBA. If you do so, it could be rejected on the grounds that it constitutes multiple applications. Introduced by Securities and Exchange Board of India ( Sebi ) in 2008, using ASBA has become mandatory for all non-retail investors. Retail investors, though, continue to have the option of choosing between the old and new mechanisms. However, it is in your interest to opt for ASBA. He...

ELSS Mutual Funds are the Best Tax Saving Investment for young Investors

Investing ELSS Mutual Funds Online     When it comes to investments made for the purpose of tax savings under Section 80C of Income Tax Act, Public Provident Fund (PPF), Life Insurance premiums and Equity Linked Savings Schemes (ELSS ) are among the most popular choices, especially for young investors. However, as far as wealth creation is concerned, there is simply no comparison between ELSS and the rest of the 80C investment options. It is often seen that, when we compare different investments we are influenced by personal opinions, either our own or that of others. However, objective comparison should always be based on actual data. In this blog we will see how much wealth could have been created in the last 15 years by investing in ELSS. Why have we chosen a time horizon of 15 years? The term of one of the most popular tax saving investments, PPF, is 15 years. Hence it is appropriate to c...

Birla SunLife FTP Series Dividend

Download Tax Saving Mutual Fund Application Forms Invest In Tax Saving Mutual Funds Online Buy Gold Mutual Funds Leave a missed Call on 94 8300 8300   Birla SunLife Mutual Fund Dividend   Birla Sun Life Mutual Fund has announced dividend under the dividend option of Birla SL FTP Series GY Reg-D , Birla SL FTP Series GY Reg-DQ , Birla SL FTP Series GY Direct-D and Birla SL FTP Series DA-D .   The quantum of dividend will be the entire distributable surplus as on the record date. The record date has been fixed as May 08, 2014. For further information contact Prajna Capital on 94 8300 8300 by leaving a missed call Leave a missed Call on 94 8300 8300 Leave your comment with mail ID and we will answer them OR You can write back to us at PrajnaCapital [at] Gmail [dot] Com ---------------...
Related Posts Plugin for WordPress, Blogger...
Invest in Tax Saving Mutual Funds Download Any Applications
Transact Mutual Funds Online Invest Online
Buy Gold Mutual Funds Invest Now