2 Replies Latest reply: Jul 3, 2012 2:14 PM by amv34189 RSS

    What's the expression for delta?

      Hello,

       

      I have data similar to this chart. I want to find the delta and i'm not sure how to form the expression in the table. So:

       

      Inventory2011 - Inventory 2010 / Revenue2011 - Revenue2010

       

      How can the change over year for EACH company? I already have the expression of Inventory to Revenue along with some other simple ratios. Just not sure how the expression should look.

       

      Thanks!

       

       

      Company
      Year
      Revenue
      Inventory
      Company A2011$8$2
      Company A2010$10$1
      Company A2009$12$3
      Company A2008$6$2
      Company A2007$13$2
      Company B2011$10$5
      Company B2010$11$3
      Company B2009$9$2
      Company B2008$7$6
      Company B2007$15$2