Sales Comparison

Options
spurschic1@yahoo.com
spurschic1@yahoo.com Registered Posts: 94 Regular contributor ⭐
Hi All,

I want to compare 2 revenue figures for 2007-2008 to find out what the increase is, I know I'm being blonde but what is the formula?

Thanks :thumbup1:

Comments

  • Bookworm55
    Bookworm55 Registered Posts: 479 Dedicated contributor 🦉
    Options
    Are you after something more sophisticated than:

    Y2 revenue - Y1 revenue = increase in revenue

    or (Y2 revenue - Y1 revenue)/Y1 revenue = % increase in revenue

    eg 2007 revenue = £10 million, 2008 revenue = £12 million

    Increase = 12-10= £2 million

    (12-10)/10 = 2/10 = 20% increase
  • spurschic1@yahoo.com
    spurschic1@yahoo.com Registered Posts: 94 Regular contributor ⭐
    Options
    That's perfect, thanks!

    :laugh:
  • mark130273
    mark130273 Registered Posts: 4,234 Beyond epic contributor 🧙‍♂️
    Options
    but are you adjusting them for index/rpi increase ?
  • Paul24
    Paul24 Registered Posts: 578 Epic contributor 🐘
    Options
    Mark - she is talking about a revenue comparison, dont complicate things :-)
Privacy Policy