Question: please help resolve and show steps for answers on excel Using the data for Johnson & Johnson (NYSE:JNJ), presented below: Johnson & Johnson Selected Financial

please help resolve and show steps for answers on excel please help resolve and show steps for answers on excel Using the

Using the data for Johnson & Johnson (NYSE:JNJ), presented below: Johnson & Johnson Selected Financial Data For the Years 2014 to 2018 Fiscal Year 2018 2016 Sales $ EBIT Interest Expense Net Income Basic EPS Total Assets Accounts Payable Total Liabilities Retained Earnings Net Cash from Operating Activities Free Cash Flow 81,534 21,253 1,194 15,297 6.67 152.954 7.537 93,202 106,216 22, 201 18,531 2017 $ 76,481 19,565 1,017 1,300 1.34 157,303 7,310 97,143 101,793 21,056 17,777 $ 71,937 21,350 763 16,540 6.33 141,208 6,918 70,790 110,551 18,767 15,541 2015 2014 $ 70,200 $ 74,334 18,368 20,929 552 518 15,409 16,323 5.89 6.29 133,411 131,119 6,668 7,633 62,261 61,367 103,879 97,245 19,279 18,471 15,816 14.757 a) Calculate the ratio of each years data to the previous year for each of the above items for JNJ, and describe in percentage. For example, for the year 2018 the ratio for sales is $81 534/576,481=1 06607 (Analysis 4pts). b) From your calculations in part a, calculate each year's rate of growth. Using the example in part a the ratio is 1.06607. so the percentage growth in sales for 2018 is 1 06607-1 or 6.607% (Identify and Access Needed Information 4pts). c) Calculate the average growth rate (using the AVERAGE function) of each of the above items using the results you calculated in part b. These averages are arithmetic averages (Analysis 4 pts) d) Use the GEOMEAN function to estimate the compound anmal average growth rate (CAGR) for each of the above items using the results that you calculated in part a Be sure to subtract 1 from the result to arrive at a percent change. These are geometric averages (Use Information Effectively to Accomplish a Specific Purpose 4 pts). e) Interpretation: Please include your written description in the interpretation tab. If you do not complete this section with your words or leave the interpretation tab as a blank, you receive 0 point in this HW (Use Information Effectively to Accomplish a Specific Purpose 4 pts)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!