Concordia University Irvine AMD Income Statement Excel Worksheet

I did a research on the company AMD by looking at the companies 10k’s and 10q’s, but I am stuck on ratio analysis part of the assignment and I need help getting it solved because I am really confused as to how to figure this out. I did all the analysis on the attached excel and I wanted you to fill out the ratio analysis part of the assignment.

Here is what my professor said and here are the examples below.

Hi Everyone – Here is a sample of the ratios to do for your project this week. You’ll complete these for the past 3 fiscal years, and also find 6 ratios that are specific to the company’s industry – those 6 ratios are additional to the ones shown below. Complete them in Excel, using formulas for all the ratios, and use the formatting of mine below as a model. (You can use the “Special Formatting” feature of cells to make it use “x” and “days” when it shows the data – the number appears in the cell and Excel adds those letters to the data itself via formatting – no hard-coding needed!)