This content has been marked as final. Show 2 replies
I have a scenario analysis tab in my QV tab which allows the user to vary the Return on Investment (ROI) however I don't know how to recalculate the compounding return based on a slider value.
If user sets the ROI slider to 5% then a return of £100 is
Yr 1 = 100 * 105% = £105
Yr 2 = 105 * 105% = £110.25
Or the user could put the slider to a value of 10% so
Yr 1 = 100 * 110% = £110
Yr 2 = 110 * 110% = £121
The key to the problem is how can I take the output from Yr 1 and put it as the input for Yr 2?
Let me know if the above isn't clear.