Project Description:

In this problem, you will determine some financial ratios for Procter & Gamble and Johnson & Johnson based on their financial statements for the most recent years.

 

Steps to Perform:

Step Instructions Points Possible
1 Start Excel. Download and open the workbook named:
Brooks_Chapter_14_2_Start.
0
2 In cell D74, by using cell references, calculate the net profit margin percentage for Procter & Gamble in year 2017. Use the relevant cells from the Given Data section. 1
3 In cell D75, by using cell references, calculate the inventory turnover for Procter & Gamble in year 2017. Use the relevant cells from the Given Data section. 1
4 In cell D76, by using cell references, calculate the current ratio for Procter & Gamble in year 2017. Use the relevant cells from the Given Data section. 1
5 In cell D77, by using cell references, calculate the return on assets percentage for Procter & Gamble in year 2017. Use the relevant cells from the Given Data section. 1
6 In cell D78, by using cell references, calculate the return on equity percentage for Procter & Gamble in year 2017. Use the relevant cells from the Given Data section. 1
7 In cell D79, by using cell references, calculate the debt to equity ratio for Procter & Gamble in year 2017. Use the relevant cells from the Given Data section. 1
8 In cell ranges F74:F79, H74:F79, K74:K79, M74:M79, O74:O79, by using cell references, calculate the gross margin, inventory turnover, current ratio, return on assets, return on equity, and debt to equity ratios for Procter & Gamble in year 2016 and 2015, and for Johnson & Johnson in the three years. Copy the contents from cells D74:D79 and paste the contents to cell ranges F74:F79, H74:H79, K74:K79, M74:M79, and O74:O79. 1
9 In cell D80, by using cell references, calculate the earnings per share for Procter & Gamble in year 2017. Use the relevant cells from the Given Data section. 1
10 In cells F80 and H80, by using absolute and relative cell references, calculate the earnings per share ratios for Procter & Gamble in years 2016 and 2015, respectively. Use the relevant cells from the Given Data section. Copy the content from cell D80 and paste it to cells F80 and H80. 1
11 In cell K80, by using cell references, calculate the earnings per share for Johnson & Johnson in year 2017. Use the relevant cells from the Given Data section. 1
12 In cells M80 and O80, by using absolute and relative cell references, calculate the earnings per share ratios for Johnson & Johnson in years 2016 and 2015, respectively. Use the relevant cells from the Given Data section. Copy the content from cell K80 and paste it to cells M80 and O80. 1
13 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0
Total Points 11

Click on Buy Solution and make payment. All prices shown above are in USD. Payment supported in all currencies. Price shown above includes the solution of all questions mentioned on this page. Please note that our prices are fixed (do not bargain).

After making payment, solution is available instantly.Solution is available either in Word or Excel format unless otherwise specified.


If your question is slightly different from the above question, please contact us at info@myassignmentguru.com with your version of question.