FIN 615 Exxon

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 : help@assingmentstore.com or chat with us live.

Submit Assignment

Fill in the form below or give us a call and we'll contact you. We endeavour to answer all enquiries within 24-48 hours on business days.
[contact-form-7 id="7458"]