10:19 To Do Assignment Details 2023SP BUS 110 Introduction to Business FON03 Select five of the Dow Jones Industrials (randomly) from Table 16.5 on page 529. Look up their earnings/share, dividends/share, and stock prices for the past five (5) years. Present this information in an Excel spreadsheet. In other words: Pick five (5) companies from that table to research. Go to the financial website www.morningstar.com (or any other financial website) and in the search block (top left of page) enter the name of a company (or their Ticker Symbol) from the DOW Jones Average that you selected and hit enter. On this page, there is everything you need. For example, if you select the dividend tab you will see Dividend Per Share for the past five years (2017, 2018, 2019, 2020, and 2021). Continue to surf the page until you find all the requested information. Hint: when searching for financials stay in the quote mode and select keys ratios; also, click on the Full Key Ratios Data for more financials. Repeat this process for FIVE companies and organize the data in an EXCEL spreadsheet and submit it in a manner that a manager would present data to his/her boss for review. You will provide five-year (2017, 2018, 2019, 2020, and 2021) performance for ALL FIVE COMPANIES. Previous Submit Assignment 8 Next Dashboard Calendar To Do Notifications Inbox 10:20 To Do Assignment Details 2023SP BUS 110 Introduction to Business FON03 VITANILJ. Find the following information: 1) earnings/share 2) dividends/share paid 3) ending (12/31/xx) stock prices for the past five years (2017, 2018, 2019, 2020, and 2021) and post this information for each company in an EXCEL spreadsheet. Note: Year-end (12/31/xx) means the last trading day of the year. Answer the following questions about the above data at the end of the spreadsheet: 1. Which stocks would you have liked to have owned over this past period? Why? 2. Do you think the next five years will present a similar picture? Explain your answer in detail. I will NOT accept this assignment in any other format other than a SPREADSHEET. Part of the purpose of the assignment is to see if you can present data in this format. Grading Criteria Previous Submit Assignment 8 Next Dashboard Calendar To Do Notifications Inbox