Excel Ratio File spreadsheet:

Using the SEC Financial Statements Ratios and Calculations, preparea ratio analysis of Dell Technologies SEC corporation's 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. Label the work in Excel to assist those who read it.

Using the SEC 10-K financial statements, createa three year comparative income statement with summary line items focusing on revenue through net income with key line items included but items of lower value appropriately grouped as All other Expenses. Revenue, Cost of Goods Sold, SG&A, and Income Tax Expense should be separate line items. Include a vertical analysis column for each of the three years presented.

Formulas must be embedded into the cells

Reference:

Dell Technologies SEC-10k:https://www.sec.gov/ix?doc=/Archives/edgar/data/1571996/000157199620000017/delltechnologiesfy2010k.htm#s55A78ADE61D55E0588033D6C8EEE0216