Is there a formula that will calculate the last cash flow from a string of irregular cash flows to result in a predetermined IRR?
Is there a formula that will calculate the last cash flow from a string of irregular cash flows to result in a predetermined IRR?
This is a perfect use-case for Solver.
First, install Solver. (Click the File button or Office button > Add Ins > Look to the bottom of the window and select Excel Add-Ins from the drop-down menu and click Go > Put a check mark next to Solver Add-in and click OK.
Next, use solver:
Now you should have around 7,784.44 for the last value, which gives you a 5% IRR.