This spreadsheet supports STUDENT analysis of the case, "The Body Shop International Plc 2001" (Case 8)
Please note:
1) This is a working model. Assumptions / Inputs presented can be changed to vary the results.
2) This spreadsheet incorporates circular logical reference. To resolve this circularity, please instruct Excel to "iterate" several times in calculating the results. This is accomplished by clicking on Tools/Options/Calculation, and then checking the iteration box.
3) As long as default spreadsheet calculation is set as "automatic" impact of changing assumptions will be computed in real time. Alternatively the F9 function key may need to be invoked to recalculate results. To set the numerical calculation settings to automatic, please click on Tools/Options/Calculations menu, and check the automatic calculation option.