Body Shop - Introduction Page 1 "The Body Shop...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Introduction Page 1 "The Body Shop International Plc: 2001" (Case 8) Please note: Copyright 2001 by the Trustees of the University of Virginia Darden School Foundation. Revised March 7, 2006. 1) This is a working model. Assumptions / Inputs presented can be changed to vary the results. 2) This model intentionally incorporates circular logic. To resolve this circularity, please instruct Excel to iterate 20-30 times in recalculating the model. This is achieved by clicking on Tools/Options/Calculation, and on the iteration button. 3) As long as default spreadsheet calculation is "automatic" the impact of changing assumptions will be computed in real time. If calculation is set as "manual" you should press the F9 function key to recalculate results. To set numerical calculation settings to automatic look under tools, options, calculations menu. Exhibit TN1 The Body Shop Plc 2001: Hypothetical Three-Year Forecast Worksheet, Drawing on Case Exhibit 8 Fiscal Year Ended February 28 Assumptions Forecast 1999 1999 2000 2000 2001 2001 (GBP) (% sales) (GBP) (% sales) (GBP) (% sales) 20022004 2002 2003 2004 Income Statement Turnover 303.7 100.0 330.1 100.0 374.1 100.0 Cost of sales 127.7 42.0 130.9 39.7 149.0 39.8 Gross profit 176.0 58.0 199.2 60.3 225.1 60.2 Operating expenses excluding exceptional costs 151.4 49.9 166.2 50.3 195.7 52.3 exceptional costs 4.5 1.5 0.0 0.0 11.2 3.0 Restructuring costs 16.6 5.5 2.7 0.8 1.0 1....
View Full Document

This note was uploaded on 11/22/2011 for the course BUS 306 taught by Professor Anhnamsung during the Spring '11 term at Solano Community College.

Page1 / 4

Body Shop - Introduction Page 1 "The Body Shop...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online