Assignmentstore is an one stop solution for all your assignment needs with 100% unique solutions from high qualified Instructors.

## 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.
• 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.