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

Get HelpNow





    FIN 615 Financial Analysis and Modeling

    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.
    DateEPS ActualClosing 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.