how can I prepare a

102 Case Study Pick a recent annual report of a public company. To find a list of companies, just google the question. For the company you choose complete following using Excel. Balance SheetPrepare a horizontal analysis for the last 2 years showing the $ amount increase or decrease along with a % change. Review the content in Chapter 14 for format, and Please use excel for your work. Income StatementPrepare a vertical analysis, using Excel for the three most recent years presented. Net sales should be the 100%. Please type one paragraph explaining the changes between years. Assignment is worth 10 points: Horizontal Analysis 4 points Vertical Analysis 4 points Paragraph 2 points