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.

Express Your Reaction
Like
Love
Haha
Wow
Sad
Angry
You have reacted on"FIN 615 Financial Analysis and Modeling" A few seconds ago
0 Shares
Share via
Copy link
Powered by Social Snap