| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Compounded Growth & the XIRR Function
I have a series of all positive numbers for which I would like to calculate
the compounded growth rate per period. However the XIRR function requires at least one positive and one negative value. Is there an alternative that will allow me to calculate the compounded growth rate using all positive values? Thank you in advance for your cooperation. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating Compounded Growth & the XIRR Function
No.
All rate of return calculations need at least one positive and one negative number. If you are dealing with starting and ending values (eg, invested $1000, got back $1200), you just change the sign on one of them to get the return calculated. To help you further, we need to know what the 'positive numbers' represent. Are they cash flows, period ending values, or periodic returns? -- Regards, Fred "SJT" wrote in message ... I have a series of all positive numbers for which I would like to calculate the compounded growth rate per period. However the XIRR function requires at least one positive and one negative value. Is there an alternative that will allow me to calculate the compounded growth rate using all positive values? Thank you in advance for your cooperation. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating Compounded Growth & the XIRR Function
They are monthly revenues. Thank you for your assistance.
"Fred Smith" wrote: No. All rate of return calculations need at least one positive and one negative number. If you are dealing with starting and ending values (eg, invested $1000, got back $1200), you just change the sign on one of them to get the return calculated. To help you further, we need to know what the 'positive numbers' represent. Are they cash flows, period ending values, or periodic returns? -- Regards, Fred "SJT" wrote in message ... I have a series of all positive numbers for which I would like to calculate the compounded growth rate per period. However the XIRR function requires at least one positive and one negative value. Is there an alternative that will allow me to calculate the compounded growth rate using all positive values? Thank you in advance for your cooperation. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating Compounded Growth & the XIRR Function
OK. Presumably at the end of the period, the revenues have grown to some final
figure. You would create a table of the revenues in one column, and the corresponding date in another. The last entry would be the value the revenues have grown to (as a negative number), and the valuation date. Feed these two ranges to XIRR, and it will calculate the rate of return for you. -- Regards, Fred "SJT" wrote in message ... They are monthly revenues. Thank you for your assistance. "Fred Smith" wrote: No. All rate of return calculations need at least one positive and one negative number. If you are dealing with starting and ending values (eg, invested $1000, got back $1200), you just change the sign on one of them to get the return calculated. To help you further, we need to know what the 'positive numbers' represent. Are they cash flows, period ending values, or periodic returns? -- Regards, Fred "SJT" wrote in message ... I have a series of all positive numbers for which I would like to calculate the compounded growth rate per period. However the XIRR function requires at least one positive and one negative value. Is there an alternative that will allow me to calculate the compounded growth rate using all positive values? Thank you in advance for your cooperation. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating Compounded Growth & the XIRR Function
Thank you very much for your assistance.
"Fred Smith" wrote: OK. Presumably at the end of the period, the revenues have grown to some final figure. You would create a table of the revenues in one column, and the corresponding date in another. The last entry would be the value the revenues have grown to (as a negative number), and the valuation date. Feed these two ranges to XIRR, and it will calculate the rate of return for you. -- Regards, Fred "SJT" wrote in message ... They are monthly revenues. Thank you for your assistance. "Fred Smith" wrote: No. All rate of return calculations need at least one positive and one negative number. If you are dealing with starting and ending values (eg, invested $1000, got back $1200), you just change the sign on one of them to get the return calculated. To help you further, we need to know what the 'positive numbers' represent. Are they cash flows, period ending values, or periodic returns? -- Regards, Fred "SJT" wrote in message ... I have a series of all positive numbers for which I would like to calculate the compounded growth rate per period. However the XIRR function requires at least one positive and one negative value. Is there an alternative that will allow me to calculate the compounded growth rate using all positive values? Thank you in advance for your cooperation. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating growth with negative numbers | Excel Worksheet Functions | |||
| Calculating market growth rates | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| My XIRR function has dropped out, analysis toolpak doesn't fix. | Excel Worksheet Functions | |||
| XIRR Function Error | Excel Worksheet Functions | |||
Linear Mode
