Financial Modelling

Assignment Question

Read carefully the case notes below. Consider the information shown in the appendix.

Determine how this information can be used to shed light on the impact of ownership structure on company performance.

Then write a report for the Directors of JP Drew which addresses these issues.

Ownership Structure and Company Performance

You have recently been appointed as an analyst within PMC Inc. PMC is a UK consultancy company that undertakes independent research for client organizations.

Your first client is a large investment management firm (JP Drew) which provides advice and administrative services to both individuals and companies in relation to portfolio selection and specific asset purchase (stocks, bonds, etc.).

The Directors of JP Drew are interested in determining the impact which ownership structure has on company performance. In particular, the extent to which the separation of ownership and control provides opportunity for managers to undertake activities which negatively impact on performance and whether large shareholders can put pressure on managers to increase this performance.

You have been asked to undertake some quantitative analysis looking at this issue. While you are familiar with various different aspects of statistics and a number of statistical packages you have not undertaken a project of this nature before. Hence you start by conducting a literature search.

This search proves beneficial and you find that there are a number of existing studies which look at ownership structure and performance, although none specifically in a UK context.

In terms of theoretical work one of the overarching themes is that of the principal/agent problem. This suggests that the owners of a firm will want to pursue profit or value maximization, but that on many occasions share ownership is so dispersed that the ability of shareholders to push managers in this direction is extremely limited. In contrast managers will have other objectives such as ‘empire building’ or a quest for higher salaries, with pursuit of these alternative objectives being possible (at the expense of profit) because control cannot be exerted by shareholders. This implies that in situations where share ownership is not dispersed and instead resides to a large extent in the hands of a single organization or individual then it should be possible to force managers to pursue value maximization. However, there is also the suggestion that some of the owners of a company may have objectives other than maximum value.

In terms of empirical work there have been a number of studies which have attempted to look at the impact which ownership concentration (percentage shares of the largest owner) has on performance. Various measures of company performance have been used including accounting profit, market to book value and return on capital employed. In addition, some studies have looked at whether the identity of the largest owner (bank, institutional investor, etc.) has an effect on these performance measures. All such studies also contain ‘control variables’ which are likely to impact on company performance. The most frequently used of these is firm size. In addition, some studies have attempted to control for the industry in which the firms are located.

From the material you have identified you draw up a list of variables which can be used to identify the impact, if any, of ownership structure on performance. You then collect numerical data on each of these variables (details of the data can be found in Appendix I). You now need to consider how you will analyse this information. In addition you need to consider how you will explain the approach (es) you have adopted and the implication of your analysis given that the Directors of JP Drew are not experts in quantitative or statistical methods.

Appendix I

The data for to this assignment can be found in MN7542 Financial Modelling Assignment May – July 2016.xls. This information relates to a large sample of medium and large sized firms. In total there are 400 observations. The first 5 observations are shown below.

Variable definitions:

MBV: Market to book value.

Identity:                 Identity of the largest owner:

3 if bank,

4 if institutional investor,

5 if non-financial company,

6 if family or single person.

Con: Ownership concentration, percentage shares of the largest owner.

Size: Total assets of company, £ million.

ROCE: Return on capital employed, percent.

Industry:                 Sector in which company operates:

1 if manufacturing,

2 if services,

3 if primary.

 

MBV	Identity	Con	Size	ROCE	Industry
1.94	3	39.1	217307	43.4	2
2.22	3	36.3	190638	41.8	1
1.99	3	32.8	260402	32.4	1
2.10	3	32.3	291598	44.3	1
1.74	3	38.3	196831	36.7	3

 

Further Guidance

Students are reminded that whilst some questions may very evidently refer to a particular unit they are all designed to span issues across the entire module. A full answer to the question will require reflection on the issues that you have encountered throughout the module. It is important to bear in mind that the content of your answer will depend on the argument that you wish to put forward in answer to the question and not solely on the concepts that the question explicitly identifies.

Remember, the Directors of JP Drew are not experts in statistical analysis. Hence you will need to explain what you are doing and why, as well as the meaning of your results.

In structuring your report you may wish to consider the following framework. This does not mean that you simply respond to (a) to (d) below, but rather that you formulate headings and sub-headings for your report using the framework as a starting point.

(a) A graphical representation of the data and a discussion of any issues or patterns which arise from this exercise. It would be for you to decide upon the exact data to use and the appropriate graph(s).

(b) Univariate and bivariate analysis and discussion which considers the effects of ownership structure on company performance.

(c) Multivariate analysis and associated discussion which makes use of the data given in MN7542 Financial Modelling Assignment May – July 2016.xls.

(d) Any other issues, problems or additional complications which you feel should be conveyed to the Directors of JP Drew with respect to your analysis.

Important points to note:

 You are required to provide explanation and discussion.

 Do not produce graphs if you cannot provide related discussion.

 Do not produce tables if you cannot provide related discussion.

 Do not cut and paste Excel, SPSS, etc. tables into your report. Produce your own summary tables in the main body of your report. If you think appropriate you can provide an appendix with the Excel, SPSS, etc. information.

 

An example of ‘what you are doing, why, and the meaning of results’:

“The analysis consists of cross-tabulations and a logistic regression. The cross-tabulations, which make up the brunt of the report, allow one to see the interrelationship between two or more variables. For example, what percentage of whites and African-Americans play lottery games? Or, who spends more per month on lotteries, those younger than fifty or those older than fifty? The investigators use cross-tabulations to illustrate the relationship among demographic characteristics (e.g., age, education, income), attitudes toward lotteries, how frequently residents play lottery games, and how much they spend on them.” (Piliavin and Entner Wright, 1992: 2)

“As shown in column four, several demographic characteristics of the 1991 respondents significantly predict lottery play. These include gender, age, marital status, and education. First, men are more likely to play the lottery than women, with an estimated regression coefficient of .3242 (top of column four). Being positive, this coefficient indicates that male respondents (coded as 1) have higher probabilities of lottery play than female respondents (coded as 0).” (Piliavin and Entner Wright, 1992: 58)

References

Please ensure that you have read the advice on assignment writing and referencing.

A literature search/review is not a requirement because the main objective of this assignment is for you to think through the issues that can be addressed using the data provided. However, good use of secondary material in introduction or conclusion will be rewarded. If you use such material it should be referenced in your report and the full citation must be provided in a bibliography.

Word limit: 3,500 words

Please refer to the Assessment section of Blackboard for details on how to submit.

If you have any questions or need information regarding submission of your assignment, please contact the programme administration team.

Please CHAT WITH LIVE Assignment Advisor to Get Assignment help right away