Body Shop International
By: brock1313 • Essay • 744 Words • April 20, 2015 • 1,222 Views
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:
- 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.
- 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 |