Hi , I am trying to set up a formula (for IRR).

Input final cash figure at D12 .- Dates from A1 to E1, Cash flow Values from A3 to E3.
Formula elsewhere using the above.
This will generate an IRR, but I want to input a range of final cash figures into D12.
So set up a new row of final cash values(say A20 to G20), these should put their values in D12, and under the row of A20 to G20 the IRR calculations should display its value.
This is easily done by adjusting the IRR calculation each time. - but .

Is there a way to do this, i.e. set up a calculation that reads a cell (D12) , and then run through a series of possible values. These calculations will get very complicated (i.e. several hundred cash flows) - and it would be great to be able to produce a sensitvity analysis/table of figures by substituing several end values, and seeing how this effects the figures.