Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
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.
For Example....
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.
Thanks
You can use Above function in this case.
More help can be given if you can provide some sample data.
Hi Anthony,
How about using the power statement as this is in effect a compound interest calculation:
100 * Pow(1.1,YearNumber)
and that should provide the value moving forward through your chart
Hope this helps!