Image transcription text A B = )] E L G H I J Using the data in
Fantastic news! We've Found the answer you've been seeking!
Question:
please tell me the formulas I need to put in the blue cells. Follow the requirements at the bottom.
Transcribed Image Text:
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. 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.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Derby Chips is an international producer of corn chips. At the end of 2006, Mary Hahn, president of Derby, appointed a task force to focus on the packaging and product use segments of its products...
-
11. Assume that the total cost function (TC) is given by the following equation: TC = 100+ 2.5y + 0.05 y2, where y is output. a. What is the total fixed cost (TFC)? b. What is the average total cost...
-
Puget World, Inc., manufactures two models of television sets, the N 800 XL model and the N 500 model. Data regarding the two products follow: Additional information about the company follows: a....
-
Solve each equation using the quadratic formula. -4x 2 = -12x + 11
-
Tyler Companys ASC 932-235 disclosures included the following information: REQUIRED: Using the information for Tyler Company in problems 13, 14, and 15 and in this problem: a. Compute the value of...
-
The Davidson Corporation's balance sheet and income statement are provided here. a. Construct the statement of stockholders' equity for December 31, 2008.b. How much money has been reinvested in the...
-
Corporate taxation in South Africa is too high and has negative implications for economic growth and our competitiveness with our main trading partners." Do you agree with this statement? Why (not)?...
-
MoonBucks is a coffee shop that sells fancy coffee products in Toronto. Sales in Year 2 are $500,000. The percentage change from Year1 sales is an increase of 46% . What are the Year 1 sales?
-
Choose a small organization in your city, such as a restaurant or school, and draw a chart showing its structure. Do you think the number of levels in its hierarchy and the span of control at each...
-
Izmir Industrial Electric (IZIEC) is a (fictional) Turkish medium-sized manufacturer of electronic data processing and office equipment including fibre optic data centre products, rack cabinets and...
-
In Figure 1.8, food retail is positioned as a local business, with a very low globalization score. However, in the press, companies like Tesco, Walmart or Carrefour are described as global retailers....
-
What is the difference among an individual franchise agreement, an area franchise agreement, and a master franchise agreement? If you wanted to open a large number of Fresh Healthy Vending franchises...
-
Identify a franchise location near where you live and ask to talk to the owner. Show the owner one of the two You Be the VC features at the end of this chapter and ask the person whether he or she...
-
The local Driver's License Office has asked you to write a program that grades the written portion of the driver's license exam.The exam has 20 multiple choice questions. Here are the correct...
-
A 2500-lbm car moving at 15 mi/h is accelerated at a constant rate of 15 ft/s 2 up to a speed of 50 mi/h. Calculate force and total time required?
-
You are considering purchasing a warehouse. The cost to purchase the warehouse is $500,000. Renting the equivalent space costs $20,000 per year. If the annual interest rate is 6%, at what rate must...
-
A 30-year bond with a face value of $1000 has a coupon rate of 5.5%, with semiannual payments. a. What is the coupon payment for this bond? b. Draw the cash flows for the bond on a timeline.
-
Describe what prepayment risk in a GNMA is.
-
When adopting resource-leveling heuristics, which of the following are relevant decision rules? a. The activities with the least slack time should have resources allocated to them first b. The...
-
Project resource constraints can involve any of the following examples? a. Poorly trained workers b. Lack of available materials for construction c. Environmental or physical constraints of the...
-
When are the resource requirements estimated? a. After the activities have been defined but before the schedule has been developed b. After the schedule has been developed but before the activities...
Study smarter with the SolutionInn App