Time-Weighted Returns?
Dave
time-weighted rates of return?
I want to check out the performance on a few investments (401K, brokerage
account etc..) without having to pay and hassle with a portfolio accounting
type of software package. Something simple that will just generate my
performance numbers. TIA
Dave
alan
Why not just use an Excel spreadsheet. I'm not sure what you mean by "time
weighted" rate of return, but the Excel function XIRR provides the internal
rate of return for a series of cash flows that occur at irregular time
periods. This is essentially your average annual rate of return, which
takes into account the timing of all cash inflows and outflows.
Alan
Dave wrote in message <7sg94j$qh5$1...@winter.news.rcn.net>...
FinCoach
account etc..) without having to pay and hassle with a portfolio accounting
type of software package. Something simple that will just generate my
performance numbers. TIA
///////////////
Lotus or Excel will provide all the assistance one needs to perform nearly any
and all financial analysis one might need.
T. Rex
PaulMaf
>Date: Fri, 24 September 1999 03:44 PM EDT
>Message-id: <7sg94j$qh5$1...@winter.news.rcn.net>
>
>Does anybody know of any good software that can be used to calculate
>time-weighted rates of return?
That is better known as the "Compounded
Annual Rate of Return"
The easiest software to use is Quciken which autmatically does it for you once
you imput all the data.
Using Quicken has the added advantages of providing you a method to better
control your finances overall as well as doing some very basic financial
planning. If you use it properly, you can then export your information every
year directly into either best selling tax preparation software, cutting down
tax prep time.
Microsoft Money supposedly (I haven't checked it yet) does it too.
Your next best bet is as someone else already suggested, preparing an Excel (or
any good spreadsheet program's) spreadsheet and use the IRR functions to do the
calculations for you.
Dave
>>time-weighted rates of return?
>
>That is better known as the "Compounded
>Annual Rate of Return"
>
>The easiest software to use is Quciken which autmatically does it for you
once
>you imput all the data.
>
I've never heard of a "compounded annual rate of return", of course there
any many things I have never heard of, is there any site on the web that
discusses these?
I have heard of time-weighted and dollar-weighted rates of return. There are
a number of different methodologies for calculating time-weighted returns.
These approaches are used by investment professionals and are performed by
many high end portfolio accounting packages. One popular formula approved by
the Association of Investment Management Research (AIMR) is called the
Modified Dietz calculation. It takes into account cash flows in and out of
an investment, and weights them according to the amount and when they occur
in a compounding period. This approach is necessary to accurately calculate
your performance numbers for a 401K for instances, because you have cash
being invested at different times throughout the year and the amounts can
change.
At any rate I could not find any information on how quicken or money
calculate returns. I suspect they use the simpler (and less accurate)
approach of just dollar-weighted returns, does anyone know? Thanks,
Dave
Paul Maffia
>I've never heard of a "compounded annual rate of return", of course there
>any many things I have never heard of, is there any site on the web that
>discusses these?
I have no idea about any web sites. But Compounded Average Annual Rate of
Return (I inadvertently left out the "average" in my original response) is
the basic standard used in all investment calculations. All accepted
methods are based on it.
>I have heard of time-weighted and dollar-weighted rates of return. There are
>a number of different methodologies for calculating time-weighted returns.
>These approaches are used by investment professionals and are performed by
>many high end portfolio accounting packages. One popular formula approved by
>the Association of Investment Management Research (AIMR) is called the
>Modified Dietz calculation. It takes into account cash flows in and out of
>an investment, and weights them according to the amount and when they occur
>in a compounding period. This approach is necessary to accurately calculate
>your performance numbers for a 401K for instances, because you have cash
>being invested at different times throughout the year and the amounts can
>change.
As you describe AIMR, it is nothing more than a method of performing IRR
which itself, when properly performed, takes into account both the
dollar amounts and timings of all cash flows in an investment(s).
>At any rate I could not find any information on how quicken or money
>calculate returns. I suspect they use the simpler (and less accurate)
>approach of just dollar-weighted returns, does anyone know? Thanks,
Quicken, as do all professionals, use a method based on IRR.
All formulas for rates of return used in investment calculations are
derived from the basic time value of money formulas; i.e. Future Value,
Present Value, Future or Present Value of an annuity, IRR, etc..
--
Paul M.
Michael Sullivan
Paul Maffia <pau...@eskimo.com> wrote:
>>At any rate I could not find any information on how quicken or money
>>calculate returns. I suspect they use the simpler (and less accurate)
>>approach of just dollar-weighted returns, does anyone know? Thanks,
>Quicken, as do all professionals, use a method based on IRR.
Is that the most recent version? I have version 6.0 for the Mac (which is
admittedly a good 3-4 years old), and AFAICT it doesn't calculate IRR, the
only return calculation I can get it to do accurately is a very simplistic
one where it takes the current market value and divides by the amount
invested for a total return over however long. When I try to get it to
calculate a Compounded average annual ROR, I get silly numbers indicating
the calculation is doing something ridiculous.
Since I put my money in at even intervals I can make simplifying
assumptions to find my own CAAROR, and a relatively simple spreadsheet
suffices. OTOH, it would be nice to have Quicken do this for me. If it
really works accurately in the new version, that would be worth the
upgrade.
Michael
Thomas Price
> Is that the most recent version? I have version 6.0 for the Mac (which is
> admittedly a good 3-4 years old), and AFAICT it doesn't calculate IRR, the
> only return calculation I can get it to do accurately is a very simplistic
> one where it takes the current market value and divides by the amount
> invested for a total return over however long. When I try to get it to
> calculate a Compounded average annual ROR, I get silly numbers indicating
> the calculation is doing something ridiculous.
The newer versions of Quicken will generate a report showing IRR. It's called
something like "Investment Performance" with "Internal Rate of Return" as a
subtitle. You can't get this number in the regular portfolio view.
--
Tom Price
"We have entered a new financial age. The old rules no longer apply."
Alan B. Coleman, dean of Southern Methodist University's business
school in the August 13, 1979 BusinessWeek article "The Death of Equities".
PaulMaf
>Date: Wed, 29 September 1999 04:06 PM EDT
>Message-id: <7stkef$b0h$1...@panix7.panix.com>
>
>In article <7sre80$1bj$1...@eskinews.eskimo.com>,
>Paul Maffia <pau...@eskimo.com> wrote:
>
>>>At any rate I could not find any information on how quicken or money
>>>calculate returns. I suspect they use the simpler (and less accurate)
>>>approach of just dollar-weighted returns, does anyone know? Thanks,
>
>>Quicken, as do all professionals, use a method based on IRR.
>
>admittedly a good 3-4 years old), and AFAICT it doesn't calculate IRR, the
>only return calculation I can get it to do accurately is a very simplistic
>one where it takes the current market value and divides by the amount
>invested for a total return over however long. When I try to get it to
>calculate a Compounded average annual ROR, I get silly numbers indicating
>the calculation is doing something ridiculous.
I don't know about the Mac version, but the Wintel version has had this
capability almost from the beginning. I suspect that the Mac version does to.
Since you indicate that you have tried top get it to do so, that indicates to
me the capability is there.
If it is and is, in fact, calculating "ridiculous numbers" I can only conclude
that you are doing something wrong as far as either how to enter the data or
how to execute the coammand properly. Check your manual and/or customer service
for how to get ikt to work properly.
The ability to properly calculate Compounded Average Annual Return was one of
the factors that allowed Quicken to supplant Managing Your Money as the
software of choice.
Until almost the last two or three versions of MYM, it was otherwise the much
better product. Then Quicken finally caught up on an overall basis. Combined
with MYM's comapny internal prolems (essentially it was kind of the disregarded
child of a large organization that lost interest in the product) Quicken then
became, overall, the better product and effectively killed off MYM.
Dave
for calculating rates of return, while it may be built on the concept of
IRR it is very different and much more accurate. Below is a link about
XIRR, similar to IRR.
http://www.fairmonttech.com/faq.html
Anyone using a spreadsheet or even Quicken can get an estimate of what
their return is but performance measurement is much more involved than
the calculate Quicken uses (IRR).
There’s also a good book by David Spalding on the subject that clearly
defines that deficiencies of using an IRR to calculate investment
performance measurement. At any rate happy number crunching to all,
Barry K
I use Low end portfolio management software that can use modified dietz. I
have a portfolio that I add and withdraw money periodically and wanted to
track how I was really doing. This el-cheapo software has worked wonders.
See www.hamiltonsoftware.com for EZ Ror Pro.
The simplest explanation for IRR vs. Time Weighted return is: IRR (Money
weighted return) shows how your money grew (or didn't grow?), while Time
Weighted return shows how your money manager did. Time weighted return
removes the distortion you get if you made a big withdrawal the day before
the market crashed of doubled. It is a much more accurate method of
evaluating a money manager.
HTH,
Barry K
bka...@NOSPAMusa.net
Dave <d...@erols.com> wrote in message news:37F2B8...@erols.com...