Report of Thornton Plc. The Excel model using for forecasting shareholder value are considered as a helpful application in financial analysis now. The prediction shareholder value was replied on Alfred Rappaports seven value drivers which are known as

Authors Avatar


000588128    
              Dung Nguyen 

Report of Thornton Plc

1. Introduction

The Excel model using for forecasting shareholder value are considered as a helpful application in financial analysis now. The prediction shareholder value was replied on Alfred Rappaport’s seven value drivers which are known as the crucially factors to affect the firm value. This report practiced the Excel model of Thortons Plc, which is engaged in manufacturing, selling and others activities, brings out the fundamental factors for retailing, commercial trading and manufacturing operations. This report also analyzed how the changing of value drivers influent to the operations of the firm.

2. Methodology

In simple terms, the Excel model will work out the value of Thorntons Plc today, based on prediction of how much free cash flow it is going to make in the future. The forecasting of free cash flows will be practice during the future five years (from March 2011 to March 2015). The all ratios and numbers predicted are given basing on the historical figures. And the assumption will be given that the ratios are constant.

Join now!

3. The forecast period and interpretation data

The value drivers are considered as the crucial factors affecting to the shareholder value including of sales growth, operating profit margin, tax rate, incremental fixed capital investment, incremental working capital investment, require rate of return, debt, market capitalization and number of prediction years. Beacause Thorntons Plc has fundamental operation in retail and manufacture, so the sales growth and profit margin are known as crucial factors impact on shareholder value. The forecasting ratios will base on the historical figures during the five years from June 2006 to June 2010 and interim results ...

This is a preview of the whole essay