Please show me all the steps

Question CE7-17

Question CONTINUING EXAMPLES For Kellogg (K), we will address the method by which forecasts can be formed while recognizing that one set of "right" answers does not exist. At the end of this section, we provide a set of forecasts that will be used in valuation tasks in subsequent chapters. CE7.17 Given the analysis of Kellogg (K) performed in Chapter 6, form reasonable parsimonious forecasts for K of sales growth, PM. and ATO. Use those assumptions to form parsimonious forecasts of sales, NOPAT, and NOA for 2019-2022. forecasting. EXHIBIT 6.9 GIS and K's RNOA, PM, ATO, and RNFL Amounts in Millions GIS K RNOA 2,316.4 1,590 NOPAT 20,945.6 12,382 Average NOA. 11.06% 12.84% RNOA.. GIS K 2,316.4 1,590 15,740.4 13,547 14.72% 11.74% GIS K 15,740.4 13,547 20,945.6 12,382 0.751 1.094 GIS K (364.3) PM NOPAT. Sales. Operating PM. ATO Sales. Average NOA. Operating ATO. RNFL FEAT (FIAT). Average NFL RNFL ***** 15,745.1 (2.31)% 249 10,016.5 2.49% CONTINUING EXAMPLES CE6.22 While much of the analysis of Kellogg's (K) for the current year was shown in the text, we can per- form additional analysis of prior years to complete a time-series analysis. Complete the following for K: Compute RNOA for the years 2015-2018. b. Compute operating PM for the years 2015-2018. c. Compute NOPAT from sales and PM from sales for the years 2015-2018. d. Compute operating ATO for the years 2015-2018. e. Compute RNFL for the years 2015-2018. f. Prepare a common-size income statement for the years 2015-2018 to allow for analysis of the PM. 8. Prepare a common-size balance sheet for the years 2015-2018 to allow for analysis of the inverse of ATO. h. Verify the decomposition of ROE into its components for the years 2015-2018