Risk and return on equity of JD Sports Fashion Plc and Next Plc Freshly armed with your new MBA, you have recently joined an executive recruitment firm that specialises in advising and placing senior managers in the apparel retail industry. One of your clients is currently considering an offer of a senior post at JD Sports Fashion Plc when a similar post comes up at Next Plc. Both posts carry similar salaries and share option packages. Your client has some time to respond to JD Sports Fashion Plc so is interested to learn more about both companies. She has commissioned you to write a report on comparing the two companies in terms of equity risk and return. Using monthly prices between Feb 2018 and Feb 2023, you compute the historical return and volatility of the two stocks. In order to round up your analysis, you also estimate the two stock’s betas based on their correlation with the FTSE 100 index. Required Using the stock return analysis and a background check on the two companies, write a report that summarizes your thoughts concerning which company is a better investment opportunity when considering the risk-return trade-off. Consider the following issues:a) Pay attention to differences between volatility and betas when considering the risk-return trade-off. Describe what type of risk they measure.b) Provide interpretation for the estimated betas given the two firms operate in the same industry. Why would betas of two firms in the same industry differ?c) Compute the rate of return you require for investing in these two stocks. It may be convenient to assume that the expected risk-free rate is 1.3% and the expected market risk premium is 5.8%. Which stock has higher required rate of return and why? How isthe required rate of return related to the average return computed based on the historical monthly returns? How does this relate to your decision to invest in the two stocks?d) Discuss your decision to invest in one of the stocks in the context of portfolio diversification.e) Are historical data suitable for judging future performance for these two stocks? Notes on the data, your analysis and your submission. • Use adjusted monthly closing prices from Yahoo Finance (or similar) that consider dividends and stock splits. The tickers are JD.L for JD Sports Fashion Plc and NXT.L for Next Plc.• The ticker for the FTSE 100 index is ‘^FTSE’. The data is posted on my.wbs under individual assignment.• Please do not forget to calculate monthly returns from the downloaded prices before running further analysis.• You can use functions built into Microsoft Excel (like ‘average’, ‘stdev.s’, and ‘covariance.s’). Before using them, make sure that you understand what these functions do. It is perfectly fine not to rely on these or other functions but to base your analysis on your own calculations in Excel instead.• Your clear and concise report should consider the overall assignment word limit.• Your reports should be submitted in one pdf document. Any spreadsheet work, e.g. tables, diagrams, calculations etc should be copied and pasted into the report or appendices.