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
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
Get step-by-step solutions from verified subject matter experts
