assignment 3 BUS 210 - Professor Early ASSIGNMENT 3 (Stocks & Bonds) Using MS Excel complete the problems: Problems 1. Given the following information from the WS) on EMEC, calculate A. Dividend Yield B. Earnings per Share C EMEC's management is forecasting a 20% in EPS next year, what should the company's stock price be? Stock EMEC 52 Week High Low Dividend Yield 64 320.88 P/E 20 Sales (100) High 1,815 47 Low 46 Close Net Change 46.5 0.5 2a. On January 20, 2016, an investor purchased 300 shares of Lojack stock for $9.00/sh and paid a 1x broker commission. A year letter, she sold the stock for $12.00. The company paid a $0.10 dividend. What was the investor's return on investment (ROI)? 2b. The same investor wondered what would her return would have been if she used margin. At the time, the margin call was 40%. Calculate her ROI had she used margin. 3. A $1,000.00 bond with a 7.5% coupon rate is purchased and will mature in 12 years. A. If current interest rates are 8%, what should be the price of the bond? B. If after six years interest rates are still 8%, what should be the price of the bond? C Change the current interest rate in (A) and (B) to 6% and recalculate your answers. 4. (Extra Credit). Tracking a Stock. Review the following pages (221 to 227 in the FNB 100- Cornet text). Using Yahoo Finance (http://finance.yahoo.com), work through the illustration on the Microsoft (msft) historical return. After doing this, do the same for International Business Machine (IBM). Print out and hand in your results