Please complete the following tasks. Use two ocmpanies Pfizer (PFE) and Eli Lilly (LLY). Please collate ALL your work in a Excel Workbook, and show your work. DO not simply enter numbers you calculated.

1. Download the last ANNUAL financial statements (as of 12/31/2019) for both companies: Balance Sheet, Income Statement, and Statement of Cash Flows, It would be better if you got this information from Sec.GOV, but you can alsoi get them form finance.yahoo.com. Make sure you pay attention to units

2. Find out the closing price at the end of 2019 for both companies

3. Find out the number of shares outstanding for both companies

4. Find out expected earnings per share for both companies, using the Analysis Tab in Finance.Yahoo.com

5. Find out expected growth rate for the next 5 years for both companies using the Analysis Tab in Finance.Yahoo.com

6. Calculate P/E ratio for both companies. Interpret your result. What do these numbers mean, and based on this number alone, what would be your recommedation to a client who is trying to decide whether to buy PFE or LLY. Make sure you justify your recommendation using the numbers you found and logic.

7. Calculate growth adjusted P/E ratios for both companies. What do these numbers mean, and based on this number alone, what would be your recommedation to a client who is trying to decide whether to buy PFE or LLY. Make sure you justify your recommendation using the numbers you found and logic.

8. Compare your findings of P/E and Growth Adjusted P/E. If they are different, why are they different.

9.Calculate Enterprise Value/Earnings ratio and Growth Adjusted Enterprise Value/Earnings Ratio for both companies. What do these numbers mean, and based on this number alone, what would be your recommedation to a client who is trying to decide whether to buy PFE or LLY. Make sure you justify your recommendation using the numbers you found and logic.

10. Make a general recommendation based on all of your findings, and justify your reommendation.