Problem 2. Compute monthly stock returns for five stocks with monthly stock prices from Dec. 2013 to Dec. 2018. Generate descriptive statistics for five monthly stock returns and plot histograms. Problem 3. Analyze all the statistics and histogran Part 1 Collecting Data and Computing financial indicators Instruction: You have been retained by an analytic unit of the SHB Brooklyn investmemt, LLC to provide an investment analysis report to the CEO of the company. Seungho Baek. Your unit head asks you to evaluate a portfolio which consists of five stocks chosen by a junior fund manager as below I Amazon, Inc. (Ticker: AMZN) II. Microsoft Corporation (Ticker: MSFT) III. General Electronic, Co. (Ticker: GE) IV. Netflix, Ine. (Ticker: NFLX) V. Apple, Inc. (Ticker: AAPL) Thus, you are about to generate key variables, which are widely used in financial markets, so as to evaluate these companies using Bloomberg. The key values include 1) Market Capitalization, 2) Enterprise Value, 3) Revenue, 4) Gross Profit, 5) Net Income, 6) EPS, 8) Cash from Operations, 7) Capital Expenditure, and 8) Free Cash Flow 1 Read carefully the below instruction before you begin project 2. .Consolidate all excel spreadsheets from partl in a single Excel file. Make a cover page that includes names and ID numbers for your team on Sheetl in your EXCEL file .To submit this project electronically, use Blackboard. DO NOT send me it via email. .Only one person (a group leader) in your team needs to sabmit the project. After grading, all the team members will get the same score for the attempt .Submit your project in a single EXCEL file. ONLY one EXCEL FILE will be accepted. You have to write up with yur own words. Do not copy from others' work. You should show all your references for your project on the last sheet in your Excel. Also, you need to provide all the names (except your team members) you discussed on the last sheet as well. Note that this main goal of this project is to replicate "Key Stats" and "Profitability Ratios" on Bloomberg. If you just copy and paste the values from Bloomberg, you will 'get zero. You must show how to get the answes. All your answers that require computation must be computed using the collected data and Excel. Part 1 Collecting Data and Computing financial indicators Instruction: You have been retained by an analytic unit of the SHB Brooklyn investment, LLC to provide an investment analysis report to the CEO of the company, Seungho Back. Your unit head asks you to evaluate a portfolio which consists of five stocks chosen by a junior fund manager as below. I Amazon, Inc. (Tickor: AMZN) IL Microsoft Corporation (Ticker: MSFT) earch G Problem 2. Compute monthly stock returns for five stocks with monthly stock prices from Dec. 2013 to Dec. 2018. Generate descriptive statistics for five monthly stock returns and plot histograms. Problem 3. Analyze all the statistics and histogran Part 1 Collecting Data and Computing financial indicators Instruction: You have been retained by an analytic unit of the SHB Brooklyn investmemt, LLC to provide an investment analysis report to the CEO of the company. Seungho Baek. Your unit head asks you to evaluate a portfolio which consists of five stocks chosen by a junior fund manager as below I Amazon, Inc. (Ticker: AMZN) II. Microsoft Corporation (Ticker: MSFT) III. General Electronic, Co. (Ticker: GE) IV. Netflix, Ine. (Ticker: NFLX) V. Apple, Inc. (Ticker: AAPL) Thus, you are about to generate key variables, which are widely used in financial markets, so as to evaluate these companies using Bloomberg. The key values include 1) Market Capitalization, 2) Enterprise Value, 3) Revenue, 4) Gross Profit, 5) Net Income, 6) EPS, 8) Cash from Operations, 7) Capital Expenditure, and 8) Free Cash Flow 1 Read carefully the below instruction before you begin project 2. .Consolidate all excel spreadsheets from partl in a single Excel file. Make a cover page that includes names and ID numbers for your team on Sheetl in your EXCEL file .To submit this project electronically, use Blackboard. DO NOT send me it via email. .Only one person (a group leader) in your team needs to sabmit the project. After grading, all the team members will get the same score for the attempt .Submit your project in a single EXCEL file. ONLY one EXCEL FILE will be accepted. You have to write up with yur own words. Do not copy from others' work. You should show all your references for your project on the last sheet in your Excel. Also, you need to provide all the names (except your team members) you discussed on the last sheet as well. Note that this main goal of this project is to replicate "Key Stats" and "Profitability Ratios" on Bloomberg. If you just copy and paste the values from Bloomberg, you will 'get zero. You must show how to get the answes. All your answers that require computation must be computed using the collected data and Excel. Part 1 Collecting Data and Computing financial indicators Instruction: You have been retained by an analytic unit of the SHB Brooklyn investment, LLC to provide an investment analysis report to the CEO of the company, Seungho Back. Your unit head asks you to evaluate a portfolio which consists of five stocks chosen by a junior fund manager as below. I Amazon, Inc. (Tickor: AMZN) IL Microsoft Corporation (Ticker: MSFT) earch G