"I take care of my things. After all, those of us as has few things to begin with must take care, lest we have fewer." - Erica Eisdorfer
logo

Go Back   Saving Advice > Financial Chit Chat > Investing & Banking

Investing & Banking stocks, bonds, banking interest rates, CDs and all other investment vehicles you want to talk about

Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old 04-10-2008, 07:32 AM
noppenbd noppenbd is offline
$ Saving College Sophomore
 
Join Date: Mar 2008
Posts: 888
Last Blog Entry: Refi Done Deal
Points: 2170.00
Donate
Default Calculating IRR?

Can anyone help me with calculating an internal rate of return for a portfolio? What tools do you use? So far the best I have found is to use is the XIRR function in Excel, but is pretty clunky. I want something that takes into account when I added to the investment, not just the overall investment versus the portfolio value. I think this is called the "Money Weighted Return" versus the "Time Weighted Return", which ignores when contributions were made.
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 07:42 AM
khilleme khilleme is offline
$ Saving First Grader
 
Join Date: Apr 2008
Posts: 6
Points: 70.00
Donate
Default

I don't have the calculation right off hand, but if you can find a financial management textbook it should be able to tell you. A financial calculator should be all you need. You need to know the weights of the stocks in your portfolio and the betas of each of those stocks I believe. It has been a little while though since I did it.
Reply With Quote
  #3 (permalink)  
Old 04-10-2008, 07:44 AM
sweeps sweeps is offline
Hopeless Optimist
 
Join Date: Oct 2005
Posts: 5,170
Points: 27012.30
Donate
Default

This blogger seems to have good success with XIRR(). He provides a sample spreadsheet.
Reply With Quote
  #4 (permalink)  
Old 04-10-2008, 08:00 AM
jIM_Ohio's Avatar
jIM_Ohio jIM_Ohio is offline
$ Saving Professor
 
Join Date: Feb 2007
Location: Milford, OH
Posts: 5,376
Last Blog Entry: Career change
Points: 27853.63
Donate
Default

Here are some threads

Investment return rate calculator


Rates of return calculation - Early Retirement Forums
__________________
  • General questions get general responses. Specific questions get better responses. Want a better answer? Re-read my signature LOL
Reply With Quote
  #5 (permalink)  
Old 04-11-2008, 06:38 AM
noppenbd noppenbd is offline
$ Saving College Sophomore
 
Join Date: Mar 2008
Posts: 888
Last Blog Entry: Refi Done Deal
Points: 2170.00
Donate
Default

I made up my own Excel spreadsheet using the XIRR function, and attached it to this post. Could somebody please sanity check it for me?
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Powered by vBulletin®
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.0.0 RC6 © 2006, Crawlability, Inc.

Copyright © 2012 SavingAdvice.com. All Rights Reserved.