Active TopicsActive Topics  Display List of Forum MembersMemberlist  CalendarCalendar  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin

Fundamental
 The Equity Desk Forum :Market Strategies :Fundamental
Message Icon Topic: Portfolio Performance Post Reply Post New Topic
Author Message
anandv
Groupie
Groupie
Avatar

Joined: 04/Sep/2007
Location: India
Online Status: Offline
Posts: 58
Quote anandv Replybullet Topic: Portfolio Performance
    Posted: 07/Dec/2012 at 12:31pm
I wanted to understand how we measure portfolio performance. How some of our investment decisions have been in the past, validate assumptions. I had asked Basantji earlier and he advised to post this on TED as this would help all. I use the XIRR function which is the IRR taking into account the various intervals of cash-flows and present valuing them and finding the IRR. I felt this is a good way to check if our investment decisions have been right. I can see a lot of work on this. Now at times we sell our portfolios, take loans to buy property. I wanted to understand if I take these two sets of cash-flows (Purchase/Sale), Re-investments in Real Estate, Repayment of Loans etc and assess all assets at current market value, we will know the investment effectiveness of our portfolio and other investments. Can seniors in TED please respond. Basantji - If this is not the right forum, please redirect it appropriately.
Investing - Just Do It.
IP IP Logged
nikrod12
Senior Member
Senior Member


Joined: 15/Jun/2010
Location: India
Online Status: Offline
Posts: 608
Quote nikrod12 Replybullet Posted: 07/Dec/2012 at 8:57pm
XIRR is pretty good waay to measure CAGR performance. Make sure you include all transactions including ones where you sell out entire folio. If you want to calculate CAGR including dividends, you need to track dividend amounts along with dates as well. You can add dividends as normal incoming cash/sell trasaction in excel and XIRR will take care of it.
 
 
 
IP IP Logged
anandv
Groupie
Groupie
Avatar

Joined: 04/Sep/2007
Location: India
Online Status: Offline
Posts: 58
Quote anandv Replybullet Posted: 07/Dec/2012 at 9:32pm
Nikrod ji - thanks for your note.  Can you also address if Real Estate investments  can also be clubbed with the sell out of portfolio ? Is there any issue in clubbing these two different asset class investments. Also are there any indicators of what is a good XIRR ? Does this change if we are measuring performance for 1 year, 5 years, 10 years and so on ?
Investing - Just Do It.
IP IP Logged
nikrod12
Senior Member
Senior Member


Joined: 15/Jun/2010
Location: India
Online Status: Offline
Posts: 608
Quote nikrod12 Replybullet Posted: 07/Dec/2012 at 9:40pm
It depends on you. If you wish to measure your overall performance accross all asset classes, add real estates as well (inluding stamp duty/registration + maintainance / rent etc. costs). Or you can measure individual performance for stocks.
 
 
XIRR is very simple to use and if you have all transaction in separate sheets, it takes 5 mins to generate it. The period should not matter much. I personally measure my XIRR twice a year to get a general idea. But do not focus on the CAGR number too much. If you do good investments, CAGR will be taken care of. In the end the net worth matters more than any other number Smile.
 
 
 
 
 
 
IP IP Logged
anandv
Groupie
Groupie
Avatar

Joined: 04/Sep/2007
Location: India
Online Status: Offline
Posts: 58
Quote anandv Replybullet Posted: 07/Dec/2012 at 9:49pm
That makes absolute sense ! Thanks !
Investing - Just Do It.
IP IP Logged
rmani84
Newbie
Newbie


Joined: 13/Dec/2012
Location: India
Online Status: Offline
Posts: 5
Quote rmani84 Replybullet Posted: 13/Dec/2012 at 1:43am
It gets complicated when you bring in too many factors ... Like inflation, interest paid on loans, asset growth, equity investments and so on ...

Its simple if u keep it as "Overall Asset worth" which includes all that u have ...

And all loans and liabilities added out ...

That way, u can have a check on asset growth year on year ...

Cheers!
Mani
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
Bookmark this Page