Image transcription text

A B = )] E L G H I J 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 all dividends are reinvested in the stock immediately. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. Historical Stock and Dividend Data for Boeing Date Price Dividend Date Price Dividend 1/2/08 86.62 1/3/11 6640 2/6/08 79.91 0.40 2/9/11 72.63 0.42 5/7/08 84.55 0.40 5/11/11 79.08 0.42 8/6/08 65.40 040 8/10/11 5741 0.42 11/5/08 49.55 040 11/8/11 66.65 042 1/2/09 4525 1/3/12 7422 Holding Period 1+ Holding Holding Period 1+ Holding Date Return Period Return Date Return Period Return 2/6/08 2/9/11 5/7/08 5/11/11 8/6/08 8/10/11 11/5/08 11/8/11 1/2/09 1/3/12 Return 2008 Return 2011 Requirements 1. Start Excel — completed. 2. In cell C16, by using cell references, calculate the holding period return for 2/6/2008 (1 pt.). " 3. To calculate the holding period return for other dates, copy cell C16 and paste it onto cells C17:C20 (1 pt.) and cells F16:F20 (1 pt.). " 4. In cell D16, add 1 to the holding period return for 2/6/2008 (1 pt.). Copy cell D16 and paste it onto cells D17:D20 (1 pt.) and cells G16:G20 (1 pt.). " 5. In cell C23, by using cell references and the function PRODUCT, calculate the return for investing in the stock from January 2,2008, to January 2, 2009 (1 pt.). Note: Remember to subtract 1 from the product to find the holding period return. " 6. In cell C24,by using cell references and the function PRODUCT, calculate the return for investing in the stock from January 3,2011, to January 3,2012 (1 pt.). . Note: Remember to subtract 1 from the product to find the holding period return. 7. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 

please tell me the formulas I need to put in the blue cells. Follow the requirements at the bottom.

B C E F G H 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 all dividends are reinvested in the stock immediately. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. 23 45678222221 222222222222222 Historical Stock and Dividend Data for Boeing Date Price Dividend Date Price Dividend 1/2/08 86.62 1/3/11 66.40 9 2/6/08 79.91 0.40 2/9/11 72.63 0.42 10 5/7/08 84.55 0.40 5/11/11 79.08 0.42 11 8/6/08 65.40 0.40 8/10/11 57.41 0.42 11/5/08 49.55 0.40 11/8/11 66.65 0.42 13 1/2/09 45.25 1/3/12 74.22 Holding Period 1+ Holding Date Return Period Return Date Holding Period Return 1+ Holding Period Return 2/6/08 2/9/11 17 5/7/08 5/11/11 19 20 21 8/6/08 11/5/08 1/2/09 8/10/11 11/8/11 1/3/12 Return 2008 Return 2011 25 26 27 Requirements 28 1. Start Excel completed. 30 31 32 33 34 35 36 2. In cell C16, by using cell references, calculate the holding period return for 2/6/2008 (1 pt.). 3. To calculate the holding period return for other dates, copy cell C16 and paste it onto cells C17:C20 (1 pt.) and cells F16:F20 (1 pt.). 4. In cell D16, add 1 to the holding period return for 2/6/2008 (1 pt.). Copy cell D16 and paste it onto cells D17:D20 (1 pt.) and cells G16:G20 (1 pt.). 5. In cell C23, by using cell references and the function PRODUCT, calculate the return for investing in the stock from January 2,2008, to January 2, 2009 (1 pt.). Note: Remember to subtract 1 from the product to find the holding period return. 6. In cell C24, by using cell references and the function PRODUCT, calculate the return for investing in the stock from January 3,2011, to January 3, 2012 (1 pt.). Note: Remember to subtract 1 from the product to find the holding period return. 7. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.