Excel : How to increase value month by month by a fixed percentage | FerrariChat
Buy

Excel : How to increase value month by month by a fixed percentage

Discussion in 'Technology' started by amenasce, Oct 20, 2010.

This site may earn a commission from merchant affiliate links, including eBay, Amazon, Skimlinks, and others.

  1. amenasce

    amenasce Three Time F1 World Champ
    Silver Subscribed

    Oct 17, 2001
    34,578
    Full Name:
    Joe Mansion
    #1 amenasce, Oct 20, 2010
    I start with 100 and want to increase that by 15% every month. How do i do that?

    Thanks !

    Andrew
     
  2. Far Out

    Far Out F1 Veteran

    Feb 18, 2007
    9,768
    Stuttgart, Germany
    Full Name:
    Florian
    #2 Far Out, Oct 20, 2010
    Mathematically speaking,

    x(n+1) = x(n) * 1,15

    ?
     
  3. rob lay

    rob lay Administrator
    Staff Member Admin Miami 2018 Owner Social Subscribed

    Dec 1, 2000
    64,188
    Southlake, TX
    Full Name:
    Rob Lay
    #3 rob lay, Oct 20, 2010
    Last edited by a moderator: Sep 7, 2017
    I just had to do it. :)
    Image Unavailable, Please Login
     
  4. amenasce

    amenasce Three Time F1 World Champ
    Silver Subscribed

    Oct 17, 2001
    34,578
    Full Name:
    Joe Mansion
    #4 amenasce, Oct 20, 2010
    Rob, sorry, i forgot to add that i need to show the monthly value increased by 15%

    So i'll have 100/115/132.5 etc..
     
  5. rob lay

    rob lay Administrator
    Staff Member Admin Miami 2018 Owner Social Subscribed

    Dec 1, 2000
    64,188
    Southlake, TX
    Full Name:
    Rob Lay
    #5 rob lay, Oct 20, 2010
    Last edited by a moderator: Sep 7, 2017
    here you go, that's actually easier, just copy down however many rows you need.
    Image Unavailable, Please Login
     
  6. amenasce

    amenasce Three Time F1 World Champ
    Silver Subscribed

    Oct 17, 2001
    34,578
    Full Name:
    Joe Mansion
    #6 amenasce, Oct 20, 2010
    Perfect thanks !!
     
  7. Etcetera

    Etcetera Two Time F1 World Champ
    Silver Subscribed

    Dec 7, 2003
    24,232
    Full Name:
    C6H14O5
    #7 Etcetera, Oct 20, 2010
    Do you have a good F1 standings spreadsheet? Mine sucks.
     
  8. wax

    wax Five Time F1 World Champ
    Lifetime Rossa

    Jul 20, 2003
    52,465
    SFPD
    Full Name:
    Dirty Harry
    #8 wax, Oct 20, 2010
    15% monthly = scam.
     
  9. rob lay

    rob lay Administrator
    Staff Member Admin Miami 2018 Owner Social Subscribed

    Dec 1, 2000
    64,188
    Southlake, TX
    Full Name:
    Rob Lay
    #9 rob lay, Oct 20, 2010
  10. BubblesQuah

    BubblesQuah F1 World Champ
    Silver Subscribed

    Nov 1, 2003
    13,242
    Charlotte
    #10 BubblesQuah, Oct 20, 2010
    Compounded just once a month?
     

Share This Page