EssaysForStudent.com - Free Essays, Term Papers & Book Notes
Search

Body Shop International

By:   •  Essay  •  744 Words  •  April 20, 2015  •  1,222 Views

Page 1 of 3

Body Shop International

Joseph Brock Taylor

Professor Khan

Case Studies in Finance

February 5, 2015

THE BODY SHOP INTERNATIONAL PLC 2001:

AN INTRODUCTION TO FINANCIAL MODELING

Assignment Questions:

  1. Why would a company like the Body Shop want to forecast its financial statements? 

Anita Roddick, a founder of The Body Shop, stepped down as chief executive officer in 1998 after numerous unsuccessful attempts to reinvent the company. Patrick Gournay replaced Roddick as the company’s CEO. Despite the management change, in revenue year 2001, revenue grew 13%, but pretax profit decline by over 21%. Gournay said of the results, “This is below our expectations and we are disappointed with the outcome”. Gournay was convinced that a newly implemented strategy would produce improved results. The strategy consisted of three principle objectives: to enhance The Body Shop Brand through a focused product strategy and increased investment in stores, and to achieve operation efficiencies in the company’s supply chain by reducing product and inventory costs, and to reinforce the company’s stakeholder culture. To ensure that Gournay was able to successfully implement these new strategies, it was important that he forecasted the company’s financial statements. By doing so, it would help him to increase operational efficiencies and lower product and inventory costs.

  1. Let us vault past the exercise questions and go straight into the three-year forecasts: How did you prepare your forecast and what numbers did you get?

I prepared the financial forecast for the next three years for The Body Shop by using two different methods of financial forecasting. One method was called T-accounting forecasting, which starts with a base year of financial statements, such as last years. The second method of forecasting that I used, is called percentage-of-sales forecasting. This method starts with a forecast of sales and then estimates other financial statement accounts based on some presumed relationship between sales and that account. The most widely used approach of financial forecasting is a hybrid of the methods discussed above. T-accounts are used to estimate shareholders’ equity and fixed assets, where as percent-of-sales forecasting method is used to estimate income statements, current assets and current liabilities.

My forecasting for The Body Shop over the next three years (2002-2004) is listed below.

Income Statement

 

2002

2003

2004

Growth

13%

422.7

477.7

539.8

COGS

40%

169.1

191.1

215.9

Gross- Profit

253.6

286.6

323.9

Operating- Expenses

52%

219.8

248.4

280.7

Fixed

0%

0

0

0

Fixed

0%

0

0

0

Interest

6%

3.4

4.1

4.8

PBT

30.4

34.1

38.4

Tax

30%

9.1

10.2

11.5

NI

21.3

23.9

26.9

Dividends

10.90

10.90

10.90

Retained Earnings

 

10.40

12.99

15.98

Balance Sheet

 

2002

2003

2004

 

 

4.7

10

10

Accounts Rec

8%

33.8

38.2

43.2

Inventory

13.70%

57.9

65.4

74.0

CA

4.70%

19.9

22.5

25.4

FA

30.00%

126.8

143.3

161.9

OA

1.80%

7.6

8.6

9.7

TA

 

250.7

288.0

324.2

Accounts Payable

4%

16.9

19.1

21.6

Taxes

2%

8.5

9.6

10.8

Accruals

3.50%

14.8

16.7

18.9

Plug

0

16.9

28.6

CL

4%

16.9

19.1

21.6

LTL

fixed

61.2

61.2

61.2

OL

0.10%

0.4

0.5

0.5

Equity

 

132.0

144.9

160.9

TL&E

 

250.7

288.0

324.2

Trial Assets

246

278

314.2

Trial Liabilities

250.7

271.2

295.6

Trial Plug

-4.7

6.9

18.6

Minimum Cash

10

10

10

Plug

 

5.3

16.9

28.6

Download as (for upgraded members)  txt (5.8 Kb)   pdf (105.5 Kb)   docx (10.6 Kb)  
Continue for 2 more pages »