Sample worksheet ED.xlsm

Hi I have now attached a simple file.

basically I begin with inserting a value in F3 and E26 in Rev + Cost worksheet.


cashflow sheet calculates cashflow over time.

and when I go to Sensitivity analysis sheet and insert a step size, it changes F3 and E26 values and calculates RV value when cashflow reaches 0 using CopyUntilZero.

i hope this explains the steps properly.