Using the data in the table below, calculate the return for investing in Boeing stock (BA) from January 2, 2008, to January 2, 2009, and also from January 3, 2011, to January 3, 2012, assuming al dividends are reinvested in the stock immediately. Historical Stock and Dividend Data for Boeing Price Price Dividend Date Dividend Date 1/2/2008S 2/6/2008S 79.91 S0.40 2/9/2011$72.63 S0.42 5/7/2008 84.55 S0.40 5/11/2011 79.08 S0.42 8/6/2008 65.40 0.40 8/10/201157.41 S0.42 11/5/2008 49.55 $0.40 11/8/2011 66.65S0.42 1/2/2009 s 86.62 1/3/201166.40 1/3/2012 74.22 13 Holding 1+ Holding Holding1+ Holding Date Period Return Period Return 2/6/2008 5/7/2008 DatePeriod Return Period Retunn 2/9/2011 5/11/2011 11-8 File HomeInsertPage Layout Formulas DataReview View Add-ins Help Tell me what you want Cut a Copy Format Panter | B 1 u . |. | aA-| Merge & Center . I $ .963-08 Formatti Font A1 1/2/200945.25 1/3/201274.22 13 Holding 1+ Holding Period Returm Period Retum Holding 1+ Holding Period Retum Period Return 15 Date 2/6/2008 5/7/2008 8/6/2008 11/5/2008 1/2/2009 Date 2/9/2011 5/11/2011 8/10/2011 11/8/2011 1/3/2012 16 18 20 21 Return 2008 Return 2011 25 26 Requirements In cell range D16:D20. by using cell references, calculate the holding period returm for each of the periods from 2008-02-06 to 2009-01-02 (5 pt.). In cell range E16:E20. by using cell references. calculate the sum of 1 and the holding period shm for each of tha narinde from p0ns--sto 2000-01-02 /5 nt) 1 23 Return 2011 26 Requirements 1 In cell range D16:D20, by using cell references, calculate the holding period retum for each 2 In cell range E16:E20, by using cell references, calculate the sum of 1 and the holding period 3 In cell range G16:G20, by using cell references, calculate the holding period return for each 4 In cell range H16:H20. by using cell references, calculate the sum of 1 and the holding 5 In cell D22. by using cell references. calculate the holding period return for the period from 6 In cell D23, by using cell references. calculate the holding period returm for the period from of the periods from 2008-02-06 to 2009-01-02 (5 pt.). retum for each of the periods from 2008-02-06 to 2009-01-02 (5 pt.) of the periods from 2011-02-09 to 2012-01-03 (5 pt.). period return for each of the periods from 2011-02-09 to 2012-01-03 (5 pt.). 2008-02-06 to 2009-01-02 (1 pt.). 2011-02-09 to 2012-01-03 (1 pt.). 27 28 31 11-8