Need help creating the direct method operating expenses using the data above. I dont understand how to do that part and my numbers are not balancing. The answers are provided by the check figures at the bottom, but I have to create a statement laying out the different accounts

Using the financial statement provided (an Excel spreadsheet with the data is available on Blackboard), prepare a complete Statement of Cash Flows that shows both the direct method and the indirect method for summarizing cash flow from operating activities. Note to complete the assignment you will need to calculate items such as dividends paid (Retained Earnings & AOC 2019 - Net income2019 - Retained Earnings & AOC1201) and capital expenditures (Net PP&E 2018 - Book Value of PP&E Sold2019 Depreciation Expense2019 - Net PP&E2010). Please submit your work via the assignment submission feature in Blackboard. Balance Sheets Income Statement (millions) 2019 2018 (millions) Cash & equivalents $2,577.0 $1,556.0 Sales Accounts receivable, net 1.262.0 1,100.0 Less: Cost of goods sold Inventories 8,992.0 9,497.0 Gross profit Other current assets 371.0 366.0 Less: Selling, gen. & admin, expenses Total current assets 13.202.0 12.5190 Less: Depr.& amort, expenses Property, plant, & equipment gross 45,547.0 44,220.0 Operating profit (EBIT) Less: Accumulated depreciation 19.6640 18.6870 Less: Interest expense Property, plant, & equipment, net 25,883.0 25,533.0 Other income expense) Right-of-use leased assets 2.536.0 2.215.0 Gain/(loss) on sale of assets Other long-term investments 137.0 10.0 Earnings before tax Goodwill 633.0 633.0 Less: Income tax expense Other intangible assets 53.0 66.0 Net income Other noncurrent assets 635.0 564.0 Total assets $43.079.0 $41.540.0 2019 $78,112.0 54,864.0 23,248.0 16,163.0 2.357.0 4,728.0 467.0 (18.0) (410) 4,202.0 921.0 $3,281.0 Current portion of long-term debt $94.0 $1.002.0 Short-term debt (notes payable) 41.0 63.0 Current operating lease liabilities 261.0 2110 Accounts payable 9,920.0 9,761.0 Other accrued expenses 1.983.0 2.034.0 Deferred revenue 1,135.0 840.0 Other current liabilities 1.053.0 1.103.0 Total current liabilities 14.487.0 15,0140 Long-term debt 10,035.0 9.255.0 Long-term operating lease liabilities 2,275.0 2004.0 Deferred taxes 1,1220 972.0 Other long-term liabilities 3.0270 2.7480 Total liabilities 30,946.0 29,993.0 Common stock and add. paid-in capital 6,268.0 6,085.0 Retained earnings 11.6770 9.845.0 Accum. other comp. income (loss) (868,0) (805.0) Less: Treasury stock 4,944.0 3,578.0 Total equity 12.133.0 11.5470 Total liabilities and equity $43.079,0 $41.540.0 Footnotes During the year, the company received cash of $338.4 when it sold PP&E with a net book value of $379.4, which gave rise to the $41.0 loss that appears on the income statement. Total depreciation and amortization expenses of $2,357.0 is made up of depreciation expense of $2.344.0 and amortization expense of $13.0. Check figures: cash flow from operations = $6,728.0; cash flow from investments = $(3,183.0); and cash flow from financing = $(2,524.0). Using the financial statement provided (an Excel spreadsheet with the data is available on Blackboard), prepare a complete Statement of Cash Flows that shows both the direct method and the indirect method for summarizing cash flow from operating activities. Note to complete the assignment you will need to calculate items such as dividends paid (Retained Earnings & AOC 2019 - Net income2019 - Retained Earnings & AOC1201) and capital expenditures (Net PP&E 2018 - Book Value of PP&E Sold2019 Depreciation Expense2019 - Net PP&E2010). Please submit your work via the assignment submission feature in Blackboard. Balance Sheets Income Statement (millions) 2019 2018 (millions) Cash & equivalents $2,577.0 $1,556.0 Sales Accounts receivable, net 1.262.0 1,100.0 Less: Cost of goods sold Inventories 8,992.0 9,497.0 Gross profit Other current assets 371.0 366.0 Less: Selling, gen. & admin, expenses Total current assets 13.202.0 12.5190 Less: Depr.& amort, expenses Property, plant, & equipment gross 45,547.0 44,220.0 Operating profit (EBIT) Less: Accumulated depreciation 19.6640 18.6870 Less: Interest expense Property, plant, & equipment, net 25,883.0 25,533.0 Other income expense) Right-of-use leased assets 2.536.0 2.215.0 Gain/(loss) on sale of assets Other long-term investments 137.0 10.0 Earnings before tax Goodwill 633.0 633.0 Less: Income tax expense Other intangible assets 53.0 66.0 Net income Other noncurrent assets 635.0 564.0 Total assets $43.079.0 $41.540.0 2019 $78,112.0 54,864.0 23,248.0 16,163.0 2.357.0 4,728.0 467.0 (18.0) (410) 4,202.0 921.0 $3,281.0 Current portion of long-term debt $94.0 $1.002.0 Short-term debt (notes payable) 41.0 63.0 Current operating lease liabilities 261.0 2110 Accounts payable 9,920.0 9,761.0 Other accrued expenses 1.983.0 2.034.0 Deferred revenue 1,135.0 840.0 Other current liabilities 1.053.0 1.103.0 Total current liabilities 14.487.0 15,0140 Long-term debt 10,035.0 9.255.0 Long-term operating lease liabilities 2,275.0 2004.0 Deferred taxes 1,1220 972.0 Other long-term liabilities 3.0270 2.7480 Total liabilities 30,946.0 29,993.0 Common stock and add. paid-in capital 6,268.0 6,085.0 Retained earnings 11.6770 9.845.0 Accum. other comp. income (loss) (868,0) (805.0) Less: Treasury stock 4,944.0 3,578.0 Total equity 12.133.0 11.5470 Total liabilities and equity $43.079,0 $41.540.0 Footnotes During the year, the company received cash of $338.4 when it sold PP&E with a net book value of $379.4, which gave rise to the $41.0 loss that appears on the income statement. Total depreciation and amortization expenses of $2,357.0 is made up of depreciation expense of $2.344.0 and amortization expense of $13.0. Check figures: cash flow from operations = $6,728.0; cash flow from investments = $(3,183.0); and cash flow from financing = $(2,524.0)