I need the excel formulas and the answers. Thanks!

Problem 10-6 Using the data in the table below, calculate the return for investing in Boeing stock (BA) fro 2, 2009, and also from January 2, 2011, to January 3, 2012, assuming all dividends are reinv Date 02/Jan/08 06/Feb/08 07/May/08 06/Aug/08 05/Nov/08 02/Jan/09 Date 06/Feb/08 07/May/08 06/Aug/08 05/Nov/08 02/Jan/09 Historical Stock and Dividend Data for Boeing Price Dividend Date $86.62 02/Jan/11 79.91 $0.40 09/Feb/11 84.55 0.40 11/May/11 65.40 0.40 10/Aug/11 49.55 0.40 08/Nov/11 45.25 03/Jan/12 Holding Period Return 1+ Holding Period Return Date 09/Feb/11 11/May/11 10/Aug/11 08/Nov/11 03/Jan/12 Return 2008 Return 2011 Requirements 1. In cell C16, by using cell references, calculate the holding period return for 06-Feb-08 (1 pt 2. To calculate the holding period return for 07-May-08, 06-Aug-08, etc., copy cell C16 and p pt.) and cells F16:F20 (1 pt.). 3. In cell D16, add 1 to the holding period return for 06-Feb-08 (1 pt.). Copy cell D16 and pas and cells G16:G20 (1 pt.). 4. Calculate the return for investing in the stock from January 2, 2008, to January 2, 2009 by u In cell C23, by using the function PRODUCT and cell references, calculate the return for in January 2, 2008, to January 2, 2009 (1 pt.). 5. Calculate the return for investing in the stock from January 2, 2011, to January 3, 2012. In c PRODUCT and cell references, calculate the return for investing in the stock from January pt.). ng in Boeing stock (BA) from January 2, 2008, to January ming all dividends are reinvested in the stock immediately. Data for Boeing Price $66.40 72.63 79.08 57.41 66.65 74.22 Holding Period Return Dividend $0.42 0.42 0.42 0.42 1+ Holding Period Return d return for 06-Feb-08 (1 pt.). 8, etc., copy cell C16 and paste it onto cells C17:C20 (1 pt.). Copy cell D16 and paste it onto cells D17:D20 (1 pt.) 08, to January 2, 2009 by using the function PRODUCT. s, calculate the return for investing in the stock from 11, to January 3, 2012. In cell C24, by using the function g in the stock from January 2, 2011, to January 3, 2012 (1