Look into the problems given and solve the problems given. The question is complete with all data given. Make it ASAP for submission.

Chapter 8 Homework Exercises Directions: Complete questions 1-5 in Excel and paste the answers into a word processing program. The data for questions 1-5 are located in the appendix to chapter 8. Question six should be printed out in power point. Make sure that you check to ensure that your charts and figures correspond with the actual data. All of your Excel responses should be pasted into a MS Word document and sub- mitted to your instructor along with the Excel file. Background Information: Governor Rebecca Davis is preparing her state of the state address and wants to focus on poverty and infant mortality issues. As a result, she has contacted you, state vital statistics director, to provide data on poverty and infant mortality in the state's 50 counties. More specifically, she wants you to determine if there is a link between poverty and income and be- tween health care spending and infant mortality in the different regions of the state. Using the county level data in the Excel spreadsheet, complete the follow- ing tasks. 1A. Create a three dimensional pie chart showing the percentage (round to whole number) of the counties that represent each region (Central, East, North, South, and West) in the data. Label the chart Regions A. See Exhibit 8.5. B. Using the county data in the Excel spreadsheet, create a bar graph showing the number of counties that represent each region in the state. Label the chart Regions B. See Exhibit 8.7. C. Which one of these techniques best describes/visually represent the data?2A. Using the template on the worksheet for question 2, create a table with the average infant mortality rate and poverty rate by region for the 50 counties in the State of Alexander. Label the table Alexander Statistics. B. Create pie charts that answer this question: What percentage of HCS and PCI dollars go to each region of the state? Using the same data, create two column graphs showing the percentage distribution of HCS and PCI for each region of the state. Label each of the charts (HCS Pie Chart, HCS Column Chart, PCI Pie Chart, and PCI Column Chart). Which one of the charts best describes the data? Explain. C. Create a pie chart and a bar chart using the average poverty rate variable by region data. Label the charts Poverty Pie Chart and Poverty Bar Chart respec- tively. Which one of the charts best describes the data?Financial Reporting Problem: Apple Inc. BYP18-1 Your parents are considering investing in Apple Inc. common stock. They ask you, as an accounting expert, to make an analysis of the company for them. Apple's financial statements are presented in Appendix A. Instructions for accessing and using the company's complete annual report, including the notes to the financial statements, are also provided in Appendix A. Instructions (Follow the approach in the chapter for rounding numbers.) (a) Make a 3-year trend analysis, using 2011 as the base year, of (1) net sales and (2) net income. Comment on the significance of the trend results. (b) Compute for 2013 and 2012 the (1) profit margin, (2) asset turnover, (3) return on assets, and (4) return on common stockholders' equity. How would you evaluate Apple's profitability? Total assets at September 24, 2011, were $116,371 and total stockholders' equity at September 24, 2011, was $76,615. (c) Compute for 2013 and 2012 the (1) debt to assets ratio and (2) times interest earned. How would you evaluate Apple's long-term solvency? (d) What information outside the annual report may also be useful to your parents in making a deci- sion about Apple?A-2 Appendix A Specimen Financial Statements: Apple Inc. CONSOLIDATED STATEMENTS OF OPERATIONS (In millions, except number of shares which are reflected in thousands and per share amounts) Veirs reded September 19, 212 Net sales 170,910 156.508 108,249 Cost of sales 106.606 87.846 64,431 Gross margin 64,304 68, 662 43.818 Operating expenses Research and development 4,475 3.381 2,429 Selling, general and administrative 10.830 10,040 7.599 Total operating expenses 15,305 13.421 10,028 Operating income 48.999 55.241 33.790 Other income/(expense), net 1,156 521 415 Income before provision for income taxes 50.155 35.763 34.205 Provision for income taxes 13,1 18 14.030 8,283 Net income S 37,037 41,733 25,922 Earnings per share: Basic 40.03 44.64 28.05 Diluted 39.75 4.15 27.68 Shares used in computing earnings per share: Basic 925.331 934,818 924.258 Diluted 931,662 945.355 936.645 Cash dividends declared per common share S 1 1.40 2.65 0.00 See accompanying Notes to Consolidated Financial Statements. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (In millions) Years ruled