Your memo should be between around 400 words and should be typed up using Word. It should be double-spaced, 1-inch margin, and with 12-point Times New Roman font • Your recommendation on which firms would be the best candidates for future investment, and • Your reasoning behind the recommendation, and • A brief response to each of the items in the following list:

1. The fund manager wants to first find out when and by how much stock prices for the selected firms fluctuate drastically. i. In your memo, include only the days on which top-most positive and top-most negative % change fluctuations occur. See Part-A for instructions to complete this.

2. The fund manager plans to discuss these results with colleagues. This requires a visual summary of the stock pricing data and NASDAQ Composite index. Create a pivot-chart that will help the fund manager in her discussion. In your memo include a copy of pivot chart and a couple of sentences about your observations from this chart. See Part-B for instructions to complete this.

3. The fund manager wants to know how the ROI of your IT portfolio compares with that of NASDAQ, which is the market index for IT firms. She wants to know whether it was better than that of NASDAQ (i.e. whether you beat the market). ii. In your memo, include a couple of sentences explaining this comparison with NASDAQ. See Part-C for instructions to complete portfolio analysis.

The post CIS Project: Business Memo appeared first on PapersSpot.