please kindly solve this question for me. thank you

2:564 11 3G Assignment Read the case notes below and 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 this issue. 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 organisations 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.). JP 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 maximisation, 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 organisation or individual then it should be a n-eu-central-1-prod-fleet01-xythos.content blackboardcdn.com 2:56 1 al 3G of a single organisation or individual then it should be possible to force managers to pursue value maximisation. 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 1 The data for to this assignment can be found in MN7024 Financial Modelling Assignment 2021-22.xls. All data is annual. The file contains information on a large sample of medium and large sized firms. In total there are 500 observations. 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 a n-eu-central-1-prod-fleet01-xythos.content blackboardcdn.com 2:56 al 3G FURTHER GUIDELINES In structuring your analysis and your report you may wish to consider the following framework. This does not mean that you simply respond to (a) to (e) 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. You need to decide upon the exact data to use and appropriate graph(s). (b) Descriptive analysis and discussion of the variables shown in the data set (c) Bivariate (two variable) analysis and discussion which considers the effects of ownership structure on company performance + (d) Multivariate (three or more variable) analysis and associated discussion which makes use of the data given in MN7024 Financial Modelling Assignment 2021-22.xlsx (e) Any other issues, problems or additional complications which you feel should be conveyed to the Directors of JP Drew with respect to your analysis. 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, Important points to note: In your report 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. 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- a n-eu-central-1-prod-fleet01-xythos.content blackboardcdn.com . } 14 P ID we P ME 1 BI 11 1 IR VE WE WE WIE 1 4 11 1601 VE WE NE KT HT 4 1 106 3 LIT FE 10 1 10m RE EE *** IT 1 23 LT a WE F 11F GE WE IR 23 T WE UE Me 21 21 WT we WE CH! . 1 IT BLE 4 e 1 B . TE IS MIT T P w LE * F E ot W F E . NE 4 ME 10 I F 1 1 1 2. * E ET TA E 20 ME E * 20 TE INT we E 3 200 1 ITE TE OT TE SIE > www RE PE ITE TH WY 1 WE . 11 w 1 + + 2 w IT NE 1 TS MIT UT w 15 WT MIT WE 1 1 3 IT: W M 1 CE 115 TE RE CTE IT E . HE RE . wa . 115 co 14 99 9 M * M. w TE IH 20 3 1 . TER 1 DICE 1 E VE F 16 RE O DEE - 1 . me BE T. TE 1 . W SIE E TH H. 1 1 M 41 R 1 WE 361 100 4 4 4 E WE ME BE WIE GUT 10 4 4 12 1 1 WE OT * TE 1 1 TE WE O OR ME E WE 1 w MOR WE . WE 1 1 ** FR IN M W 2 OF 100 om 2 18 ET 1 4 29 1 IT VET VE www CE 1 HE WE PIPE HE 21 F BE 1 9 100 2. LE LP HE 31 BO wit ER 4 ME CE SI BE H! IH + NE . 3 AR + HT NE SE > IN . RE ! . . 1 . . 114 . TRI . NL E B w at . DE 200 . 1 . HE ER IE . LP . ce . IN 1 FR the west 1 TR NATH ht IN 2. W ON T! . . ! 2 . ! . 1 ME . . . IN w . . > HE B. ME 1 HI TO IN ww M. 1 WER 10 --- + 1 >>> 1 IR W! NI M ME RE NE RE . tot MERR ! I . 140 E WWW IN M w E 1 LE + 1 HT 18 HE ** 1 09 3 11 . NI 1 . M ! . 10 Bari BE ! ener Wow! WI . 2 . . M . . ** HE ANT NIT MES . + + + 4 WT 1 02 102 15 LR 1 211 + . TH 1 1 it FI DY! 18! 2 . ER . . . HE . IN TH . DE . IE NEW HET E TW HEL + # T 21 W M . 19 BE 1 * 1 te BE COM 1. + E TN 2018 1 . MI HE ** . + C. ht *** HI W wort . . E ar RE NE . . M - + . . . . 1 . . 1 IN 1 ENE RET NY 03 1 GER HE + at 1 AM . RE 11 16 PEL + . 3 33 34 MEN TE HINI # . . 000 24 1 ! ! HI . RE ! - . . . ME MIN U . HE 2 . BUT 46 . . STE VO . HO > w WE . 3. Om WOW TH # 1 w w 3 ME 12 . IN 1 IN 18 ME TH 11 EW RI IDE 200 . HI OM 08 440 1 21 . > ** . NE NI HR WIN! . > P! . THE TW 1 W! 1 1 1 1 1 FIL 2:564 11 3G Assignment Read the case notes below and 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 this issue. 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 organisations 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.). JP 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 maximisation, 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 organisation or individual then it should be a n-eu-central-1-prod-fleet01-xythos.content blackboardcdn.com 2:56 1 al 3G of a single organisation or individual then it should be possible to force managers to pursue value maximisation. 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 1 The data for to this assignment can be found in MN7024 Financial Modelling Assignment 2021-22.xls. All data is annual. The file contains information on a large sample of medium and large sized firms. In total there are 500 observations. 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 a n-eu-central-1-prod-fleet01-xythos.content blackboardcdn.com 2:56 al 3G FURTHER GUIDELINES In structuring your analysis and your report you may wish to consider the following framework. This does not mean that you simply respond to (a) to (e) 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. You need to decide upon the exact data to use and appropriate graph(s). (b) Descriptive analysis and discussion of the variables shown in the data set (c) Bivariate (two variable) analysis and discussion which considers the effects of ownership structure on company performance + (d) Multivariate (three or more variable) analysis and associated discussion which makes use of the data given in MN7024 Financial Modelling Assignment 2021-22.xlsx (e) Any other issues, problems or additional complications which you feel should be conveyed to the Directors of JP Drew with respect to your analysis. 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, Important points to note: In your report 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. 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- a n-eu-central-1-prod-fleet01-xythos.content blackboardcdn.com . } 14 P ID we P ME 1 BI 11 1 IR VE WE WE WIE 1 4 11 1601 VE WE NE KT HT 4 1 106 3 LIT FE 10 1 10m RE EE *** IT 1 23 LT a WE F 11F GE WE IR 23 T WE UE Me 21 21 WT we WE CH! . 1 IT BLE 4 e 1 B . TE IS MIT T P w LE * F E ot W F E . NE 4 ME 10 I F 1 1 1 2. * E ET TA E 20 ME E * 20 TE INT we E 3 200 1 ITE TE OT TE SIE > www RE PE ITE TH WY 1 WE . 11 w 1 + + 2 w IT NE 1 TS MIT UT w 15 WT MIT WE 1 1 3 IT: W M 1 CE 115 TE RE CTE IT E . HE RE . wa . 115 co 14 99 9 M * M. w TE IH 20 3 1 . TER 1 DICE 1 E VE F 16 RE O DEE - 1 . me BE T. TE 1 . W SIE E TH H. 1 1 M 41 R 1 WE 361 100 4 4 4 E WE ME BE WIE GUT 10 4 4 12 1 1 WE OT * TE 1 1 TE WE O OR ME E WE 1 w MOR WE . WE 1 1 ** FR IN M W 2 OF 100 om 2 18 ET 1 4 29 1 IT VET VE www CE 1 HE WE PIPE HE 21 F BE 1 9 100 2. LE LP HE 31 BO wit ER 4 ME CE SI BE H! IH + NE . 3 AR + HT NE SE > IN . RE ! . . 1 . . 114 . TRI . NL E B w at . DE 200 . 1 . HE ER IE . LP . ce . IN 1 FR the west 1 TR NATH ht IN 2. W ON T! . . ! 2 . ! . 1 ME . . . IN w . . > HE B. ME 1 HI TO IN ww M. 1 WER 10 --- + 1 >>> 1 IR W! NI M ME RE NE RE . tot MERR ! I . 140 E WWW IN M w E 1 LE + 1 HT 18 HE ** 1 09 3 11 . NI 1 . M ! . 10 Bari BE ! ener Wow! WI . 2 . . M . . ** HE ANT NIT MES . + + + 4 WT 1 02 102 15 LR 1 211 + . TH 1 1 it FI DY! 18! 2 . ER . . . HE . IN TH . DE . IE NEW HET E TW HEL + # T 21 W M . 19 BE 1 * 1 te BE COM 1. + E TN 2018 1 . MI HE ** . + C. ht *** HI W wort . . E ar RE NE . . M - + . . . . 1 . . 1 IN 1 ENE RET NY 03 1 GER HE + at 1 AM . RE 11 16 PEL + . 3 33 34 MEN TE HINI # . . 000 24 1 ! ! HI . RE ! - . . . ME MIN U . HE 2 . BUT 46 . . STE VO . HO > w WE . 3. Om WOW TH # 1 w w 3 ME 12 . IN 1 IN 18 ME TH 11 EW RI IDE 200 . HI OM 08 440 1 21 . > ** . NE NI HR WIN! . > P! . THE TW 1 W! 1 1 1 1 1 FIL