Case study

Case study 1- Tim Long, newly launched IT Hardware and Communications analyst, recently launched on the sector. His top pick is Motorola Solutions, Inc. and he is looking for ideas on how to convince MSI to do a Non-Deal Roadshow with him. Using the attached initiation report (casestudy 1 MSI.pdf) and the 13F holding data (Case study1 MSI.xlsx) for MSI and its comparable companies (MSI, Keysight, Corning) please put together a short ppt. presentation that Tim can send to MSI. The ppt should include:

Slide 1- Executive Summary /Current Investment thesis (includes icone,shapes, charts,graphics)

Slide 2-Shareholder analysis by region (indepth analysis)

Case study 2- Please build a regional account database, by sector. Refer to file Case study (Regional Acct DB).xls

a. Use the account raw data, broken down and identified by tab, to populate the cells in the summary tab.

b. Populate the relevant columns in the summary tab, as well as color code (green – link data from other tab; black - formula; blue input).

c. Please otherwise format in the manner of the example row – using consistent font, decimals and any other non-letter or number text.

d. Please double-check and cross-check all work