solve for final cash flow

  1. H

    Difficult (if not impossible) XIRR question: Solving for final cash flow given and XIRR target?

    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...

Some videos you may like

This Week's Hot Topics