Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default cumulative return

hi how do i calculate cumulative return on the rate of return of
mutual funds
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default cumulative return

Can you provide some details? What do you have now? What do you expect to
see?

Regards,
Ryan--

--
RyGuy


" wrote:

hi how do i calculate cumulative return on the rate of return of
mutual funds

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default cumulative return

Cumulative return is simply the compounding of each of your returns.

Assume you started with an investment of $1, and you had returns of 7%,
5.5%, -2.3% and 14.2%.

Your ending value would be:
=1.07*1.055*.977*1.142

And your cumulative return would be the above result less the $1 you started
with.

In formula terms, if you have returns of i1 to in, your cumulative return
is:

=(1+i1)*(1+i2)*...*(1+in)-1

Regards,
Fred.

wrote in message
...
hi how do i calculate cumulative return on the rate of return of
mutual funds


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default cumulative return

General Solution:
http://www.investopedia.com/terms/c/...tivereturn.asp


Some Food for Thought:
http://finance.yahoo.com/funds/how_t...tive_Return s

Regards,
Ryan--

--
RyGuy


"Fred Smith" wrote:

Cumulative return is simply the compounding of each of your returns.

Assume you started with an investment of $1, and you had returns of 7%,
5.5%, -2.3% and 14.2%.

Your ending value would be:
=1.07*1.055*.977*1.142

And your cumulative return would be the above result less the $1 you started
with.

In formula terms, if you have returns of i1 to in, your cumulative return
is:

=(1+i1)*(1+i2)*...*(1+in)-1

Regards,
Fred.

wrote in message
...
hi how do i calculate cumulative return on the rate of return of
mutual funds



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default cumulative return

Investopedia has the correct calculation when you have the opening and
closing price of the security. However, the OP had a series of returns,
therefore the formula is different.

I also agree with Yahoo that you should use compound annual returns to
compare investments, but that's not what the OP asked for. He asked how to
calculated the cumlulative return, given a series of periodic returns.

Regards,
Fred.

"ryguy7272" wrote in message
...
General Solution:
http://www.investopedia.com/terms/c/...tivereturn.asp


Some Food for Thought:
http://finance.yahoo.com/funds/how_t...tive_Return s

Regards,
Ryan--

--
RyGuy


"Fred Smith" wrote:

Cumulative return is simply the compounding of each of your returns.

Assume you started with an investment of $1, and you had returns of 7%,
5.5%, -2.3% and 14.2%.

Your ending value would be:
=1.07*1.055*.977*1.142

And your cumulative return would be the above result less the $1 you
started
with.

In formula terms, if you have returns of i1 to in, your cumulative return
is:

=(1+i1)*(1+i2)*...*(1+in)-1

Regards,
Fred.

wrote in message
...
hi how do i calculate cumulative return on the rate of return of
mutual funds




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cumulative Return Natalie Excel Worksheet Functions 2 May 25th 06 01:16 AM
cumulative total dfisherkern New Users to Excel 1 February 17th 06 05:14 AM
cumulative total darkbearpooh1 Excel Worksheet Functions 7 January 27th 06 05:47 PM
Cumulative Sum kk Excel Worksheet Functions 1 June 16th 05 09:02 AM
Cumulative Frequency Chris Grant Charts and Charting in Excel 2 February 3rd 05 05:49 AM


All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"