Determine a Fortune 500 company of your choosing (Apple, Amazon, Walmart etc.). Find the Income Statement and the Balance Sheet for one year (no earlier than 2014). Calculate the Inventory Turnover for that particular year.
One sheet in Excel file (spreadsheet) must be dedicated to the Income Statement of the company. The source of the Income Statement should be included at the bottom of the page.
The second sheet in the same Excel file must be dedicated to the Balance Sheet of the company for the same year. The source of the balance sheet should be included at the bottom of the page.
The third sheet in the same Excel file must be dedicated to the Inventory Turnover calculations.