Financial Ratio Analysis

Need done ASAP! Purpose of Assignment Students should understand how to use the financial information and tools learned in the class on a public company, obtain public company SEC reports, and use that data to calculate a company's financial ratios and their comparison to industry or competitor standards. Assignment Steps Resources: Tutorial help on Excel® and Word functions can be found on the Microsoft®Office® website. There are also additional tutorials via the web that offer support for office products. Calculate and analyze the following ratios for PepsiCo Corporation for the last two years from the SEC Form 10-K: • Equity Multiplier • Return on Assets • Net Profit Margin • Return on Equity (Use three ratio DuPont method) • Compare and contrast your PepsiCo Corp. ratios to industry and competitor standard ratios obtained from Yahoo Finance, Morningstar, MotleyFool, Macroaxis or other Internet sources, and provide a detailed answer and analysis as to why your company's ratios are different than the industry/competitor standard. • Prepare your analysis in a minimum of 220 words in Microsoft® Word. The use of Microsoft®Word tables is encouraged