keepITcool,

Yes, the dividends are periodic, so you are right I can
use IRR in place of XIRR.

For the purposes of this exercise, the original (i.e.
before the constant is added to the dividends) IRR returns
are in the range 4.6% - 9.5%, and thus in order to achieve
the target of 17.5% (for each of them), the dividends will
ALWAYS need to increase.

Thus the "constant" value that is added to each dividend
will always be greater than zero, and hence there is no
need to include a check for whether the dividend becomes
negative.

Hope this helps.

Stuart.




-----Original Message-----
i'm trying to see if i can come up with an alternative to
xirr

are we always talking annual (or periodic) dividends?
in which case irr is faster then xirr, as you dont need
the dates

and presumably i can come up with an alternative compute..

do you include a check that when you modify your
dividends with a
constant, that no dividend shall become negative?



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Stuart" wrote:

I have managed to locate this in the Tools menu, but it
will not let me install it (not sure if this is due to
my
employer's security structure or if I'm doing something
wrong).

What is this anyway?? Are there any alternative
methods?


-----Original Message-----
Stuart, have you tried solver addin?

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Stuart Steven"
wrote:

Hi There,

I am doing NPV/IRR analysis, and I want to be able
to automate the
following:

Thus I can change cell B3 (the constant amount to be
added to each
dividend payment), and do this iteratively until
cell A3 displays an
IRR of 17.5%.

This is OK, but I have 100+ sets of these to do as
an option
appraisal, and was wondering if there was a macro
(or a combination
of worksheet functions) that could do this
automatically.


Many Thanks for your help,

Stuart.


.



.