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 A | 2011 | $8 | $2 |
| Company A | 2010 | $10 | $1 |
| Company A | 2009 | $12 | $3 |
| Company A | 2008 | $6 | $2 |
| Company A | 2007 | $13 | $2 |
| Company B | 2011 | $10 | $5 |
| Company B | 2010 | $11 | $3 |
| Company B | 2009 | $9 | $2 |
| Company B | 2008 | $7 | $6 |
| Company B | 2007 | $15 | $2 |
