Body Shop - Exhibits-1 - ModelFacts Please note: 1) This is...

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

View Full Document Right Arrow Icon
Model Facts Page 1 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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Model Facts Page 2
Background image of page 2
Input Data Exhibit 1 The Body Shop Plc 2001: SALES  422,733  Format for Developing a Spreadsheet Model COGS/SALES  0.38      OPERATING EXPENSES/SALES  0.50    INTEREST RATE  0.06    TAX RATE  0.30    DIVIDENDS (Thousand pounds)  10,900    CURR. ASSETS/SALES  0.32    CURR. LIABS./SALES  0.28    FIXED ASSETS  110,600    STARTING EQUITY  121,600  INCOME STATEMENT 2002 SALES COGS OPERATING EXPENSES INTEREST EXPENSE (INCOME) PROFIT BEFORE TAX TAX PROFIT AFTER TAX DIVIDENDS EARNINGS RETAINED BALANCE SHEET 2002 CURRENT ASSETS FIXED ASSETS TOTAL ASSETS CURRENT LIABILITIES DEBT EQUITY A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
Background image of page 3

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

View Full DocumentRight Arrow Icon
Input Data Exhibit 2 The Body Shop Plc 2001: SALES  422,733  Spreadsheet Formulas to Forecast 2002 Financials: COGS/SALES  0.38  OPERATING EXPENSES/SALES  0.50  INTEREST RATE  0.06  TAX RATE  0.30  DIVIDENDS (Thousand pounds)  10,900  CURR. ASSETS/SALES  0.32  CURR. LIABS./SALES  0.28  FIXED ASSETS  110,600  STARTING EQUITY  121,600  INCOME STATEMENT 2002 SALES +B3 COGS +B4*B16 OPERATING EXPENSES +B5*B16 INTEREST EXPENSE (INCOME) +B6*B33 PROFIT BEFORE TAX +B16-B17-B18-B19 TAX +B7*B20 PROFIT AFTER TAX +B20-B21 DIVIDENDS +B8 EARNINGS RETAINED +B22-B23 BALANCE SHEET 2002 CURRENT ASSETS +B9*B16 FIXED ASSETS +B11 TOTAL ASSETS +B28+B29 CURRENT LIABILITIES +B10*B16 DEBT +B30-B32-B34 EQUITY +B12+B24 +B32+B33+B34 A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
Background image of page 4
Input Data Exhibit 3 The Body Shop Plc 2001: SALES  422,733  Basic Forecasting Results for 2002 COGS/SALES  0.38  OPERATING EXPENSES/SALES  0.50  INTEREST RATE  0.06  TAX RATE  0.30  DIVIDENDS (Thousand pounds)
Background image of page 5

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

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

This note was uploaded on 05/09/2011 for the course BUSI 408 taught by Professor Zeighamkhokher during the Spring '11 term at University of North Carolina School of the Arts.

Page1 / 10

Body Shop - Exhibits-1 - ModelFacts Please note: 1) This is...

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

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