PART 6
- 26.Given the data below for Exxon:
- Would the EPS actual be a useful variable in predicting the closing price for Exxon? Support your answer with numerical support.
- Even if the EPS was not a useful predictor based on your analysis in part a, what increase in closing price could be expected for a $0.50 increase in the EPS.
| Date | EPS Actual | Closing Price |
| 12/31/2010 | $1.85 | $73.12 |
| 9/30/2010 | $1.44 | $61.79 |
| 6/30/2010 | $1.60 | $57.07 |
| 3/31/2010 | $1.33 | $66.98 |
| 12/31/2009 | $1.27 | $68.19 |
| 9/30/2009 | $0.98 | $68.61 |
| 6/30/2009 | $0.84 | $69.91 |
| 3/31/2009 | $0.92 | $68.10 |
| 12/31/2008 | $1.55 | $79.83 |
| 9/30/2008 | $2.59 | $77.66 |
| 6/30/2008 | $2.27 | $88.13 |
| 3/31/2008 | $2.03 | $84.58 |
| 12/31/2007 | $2.13 | $93.69 |
| 9/30/2007 | $1.70 | $92.56 |
| 6/30/2007 | $1.83 | $83.88 |
| 3/31/2007 | $1.62 | $75.45 |
| 12/31/2006 | $1.69 | $76.63 |
| 9/30/2006 | $1.77 | $67.10 |
| 6/30/2006 | $1.72 | $61.35 |
| 27. What should be the answer for cell B5? |
| 28. What should be the answer for cell B7? |
- 29.You are planning for an early retirement, so you decide to invest $5,000 per year, starting at age 23. You plan to retire when you can accumulate $1M. If the average rate of return on your investments is 10.5%, how old will you be when you accumulate the $1,000,000.
Using the sales-sheet.xlsx spreadsheet for questions 30-32 (save this spreadsheet as lastname_firstinitialmacro.xlsm (or xls if working with an earlier version of Excel).
30. Create two separate one-variable data tables that reflects the sensitivity of net proceeds based on changes in sales price for prodc (-.05, 0, .05, 10) and commissions for sales of $200 or more (-.10, 0, .10, .15).
- 31. Generate a pivot table which shows (by saleperson), the average quantity sold and the average sale (total). This should be only 1 pivot table. Be sure to format the output properly.
- 32.Create a macro which allows you to format cells A1 .. G1. The formatting should be:
wrapping text, boldfacing, italicizing, background color, centering of text, auto-column width. I should be able to click on cell A1, press ctrl-m, and the macro should run. Be sure to save this macro within “this workbook.”
To access towards the answers of the above questions email : [email protected] or chat with us live.
