Excel 2008 : Formulas Not Calculating or Displaying Wrong Values

Thanks, here is the work book. A few notes:

1. Working in '08 but saving as .xls because the person who will use this has an older version

2. List variables are hidden in column M

3. I have input a couple of sample transactions and manually updated the cells to show the correct values for them, to help show how the data should propagate