2 Replies Latest reply: Jul 4, 2014 4:58 AM by Alessandro Saccone RSS

    Cumulative Sum future

    Gino Matteoni

      Hi,

       

      It's possible to have a table like this:

       

      YearProfit %Value
      2014101000,00
      201520???
      201610???
      201710???
      201830???
      201915???

      I have the initial value 1000 and the possible future profit in %, and i want to calculate the value for the future

      for 2015 the value is 1000 + 10%=1100

      for 2016 the value is 1100+20%=1320 etc etc

       

      the complete result from excel is here:

      YearProfit %Value
      2014101000,00
      2015201100,00
      2016101320,00
      2017101452,00
      2018301597,20
      2019152076,36

       

       

      Thanks,

      GM.