Put the investment in cell A1 AS A NEGATIVE
Fill the next 18 rows with the actual cash flows. If there are none for the
first 15, just enter zeros. Then use =IRR(a1:A19)*12


"rflegeis" wrote:

Trying to get an irr for an 18 month income stream, with all the income in
the last 3 months. Thanks for your help