generating random cash flow with same IRR

  • Thread starter Thread starter l
  • Start date Start date
L

l

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
IRR the same for very different cash flows 3
IRR, with cash flows in non-adjacent cells 6
IRR 18
IRR Problem 2
IRR formula for monthly cash flows 3
calculating IRR 2
Working with arrays as arguments 6

Back
Top