Assuming we ARE talking periodic payments:

irr = rate where PV equals= initial invest

just compute the pmt needed for the difference
in PV and initial invest..

assume:
Target interest in B1 = .175
Init investment in C2 = -13000
Returns in D2:Q2 say 2000

NPV - invest in B2=NPV(B1,D2:Q2)+C2
Constant adj in A2=PMT(B1;COLUMNS(D2:Q2);B2;0)

tada... !!


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.


.