Prepare a cash flow statement for the Excel Spreadsheet

2017 2018 Change 6,422,640 7,892,640 7,350,000 51,450,000 Cash Marketable secutities Accounts Receivable Notes receivable (current) Inventory Prepaid Expenses Deferred tax Asset current Total Current assets 1,470,000 7,350,000 41,160,000 110,250 44,100,000 3,307,500 46,305,000 3,381,000 33,600 116,412,240 10,290,000 (110,250) 2,205,000 73,500 33,600 97,497,750 Land Building Machinery and Equipment Accrued Depreciation Total PPE 11,760,000 33,075,000 60,637,500 (22,932,000) 82,540,500 11,760,000 33,075,000 75,311,250 (29,209,950) 90,936,300 14,673,750 (6,277,950) Total Assets 180,038,250 207,348,540 27,310,290 Accounts Payable Accrued Expenses Accrued current tax obligation Current portion other LTD Debt Dividends payable Total Current Liabilities 66,150,000 14,883,750 3,528,000 2,940,000 3,307,500 330,750 8,085,000 69,457,500 15,214,500 11,613,000 2,940,000 84,000 99,309,000 84,000 87,501,750 Deferred tax Liabilities Mortgage Debt Total Non-Current Liabilities 1,470,000 32,340,000 33,810,000 588,000 28,875,000 29,463,000 (882,000) (3,465,000) 2,100,000 * Preferred Stock (210,000 shares @ $10) Common stock (10,500,000 shares $.01 par) APIC Retained Earnings Total Equity 105,000 10,342,500 48,279,000 58,726,500 2,100,000 105,000 10,417,500 65,954,040 78,576,540 75,000 17,675,040 Total Liabilities & Equity 180,038,250 207,348,540 Revenue COGS Gross Profit 441,000,000 264,600,000 176,400,000 463,050,000 277,830,000 185,220,000 143,135,000 SG&A Employee stock option expense Depreciation Equip Operating expenses 146,817,000 75,000 6,300,000 153,192,000 4,777,500 147,912,500 EBIT (Operating Profit) Interest EBT Taxes Net Income 28,487,500 2,100,000 26,387,500 10,555,000 15,832,500 32,028,000 2,469,600 29,558,400 11,823,360 17,735,040 Dividends of $60,000 were accrued with a corresponding reduction in Retained Earnings The company sold a partially depreciated truck with an original purchase price of $48,750 for a loss of 5.500 The company incurred an employee stock option expense of 75,000 Note: Not all cells and lines below are to be filled. Cash Flow 17,735,040 Net income Depreciation Employee stock Option non-cash expense Accounts Receivable Note Receivables Inventory Prepaid expenses Deferrend Tax Asset Accounts Payable Accrued expenses Accrued tax obligation Dividend Payable Gain on sale of truck Change in Deferred tax liability Net Cash from Operating Activities 17,735,040 Issuance of preferred stock Loss on FMV marketable securities Depreciation Sale of equipment Purchase of Equipment Net Cash from investing activities Note Receivable Dividend to retained earnings Issuance of preferred stock Mortgage payable Net Cash from financing activities Net Change in Cash & Cash equivalents Cash & Cash Equivalants Beginning of year Year Year End Cash & Cash equivalents