Looking for a suggestion for a formula to solve for a final cash flow given an XIRR target?
For example:
Formula in cell I3=XIRR($A2:I2,$A$1:I$1,0.1)
I've goal seeked for value in cell I2 that yeilds 20%, 30% and 40% IRR's. Looking for formula to do the same.
<TABLE style="WIDTH: 388pt...