The main goal is to demonstarte your excel skills (put in formulas for calculation) and address these items:

2. Excel Ratio File spreadsheet:

Using the SEC Financial Statements Ratios and Calculations, prepare a ratio analysis of your SEC corporations current and prior years financial statements. In addition to presenting the year to year profit and loss and balance sheet variances, calculate inventory turnover, operating margin, working capital and operating margin. Explain the value of understanding why inventory balances, inventory turnover, cost of goods sold, operating margin, and working capital are important metrics for Cost Accounting.

Just a little more guidance on exactly how to tackle these formulas and charts in excel