solution

the company name is AMD (AMD) https://ir.amd.com

The objective will be to create, as your interim report, a set of fully formatted appendices that contain your financial statement data and accurate vertical, horizontal, and ratio analyses.

Requirements:

? Enter balance sheet, income statement, and cash flow statement for a minimum of 4 years (maximum 5 years) into the Excel template provided.

?Consolidate information so all statement data fit on one page

e.g. The 4 or 5-year comparative income statement is on one page

The 4 or 5-year comparative balance sheet is on one page

The 4 or 5-year comparative cash flow statement is on one page

?The statements must be properly formatted including relevant headers and subtotals. Your goal is to make the financial statements “user friendly”.

?Present subtotals for key figures (eg. Gross Margin, Total Current Assets, etc.)

?Use the spreadsheet to calculate all totals

?Using Excel, and linking all calculations, prepare vertical and horizontal analyses. For the horizontal analysis, set your base year to 100%.

?Using Excel, and linking all calculations, prepare a ratio analysis (note the Excel template lists all required ratios). Note the requirement to calculate ROA using the DuPont method.

Use the spreadsheet to calculate all totals and ratios, it is not a word processor. Your grade is based on the accuracy of the spreadsheet formulae.

?Delete all instructions and sample information from your submission.

?You are not required to interpret the ratios at this time. Your ratio calculations will be examined for accuracy. You will have an opportunity be required to correct and resubmit any errors. You will then be able to interpret accurate data for the final report.