generating random cash flow with same IRR
 

Hi all

is there a way i can ask excel to change the amounts received in
several years, but keeping the IRR always the same? is a variation of
Goal seek i imagine.

More in general, can Excel generate several numbers keeping the Sum
constant?
thanks

generating random cash flow with same IRR
 

no one?

On Fri, 10 Aug 2007 11:59:07 -0400, l wrote:

Hi all

is there a way i can ask excel to change the amounts received in
several years, but keeping the IRR always the same? is a variation of
Goal seek i imagine.

More in general, can Excel generate several numbers keeping the Sum
constant?
thanks

generating random cash flow with same IRR
 

Hello,

If you want to generate random numbers with a given sum you can use:
http://www.sulprobil.com/html/randsum1.html

Regards,
Bernd