Video Excel Online Structured Activity: Statement of cash flows You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company fof the y flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior but paid $700,000 in dividends to common shareholders. Throughout the year, the firm pushed $54 depredation expense for the year is $460,000; however, the purchase price for t the firm was to issue long-term debt of $1 million at a 7% interest rate. The data has been What was the firm's end-of-year cash balance? Recreate the firm's cash flow statement to anive t nearest dollar, if necessary $ Check My Work Hapet Prob Statement of cash flows A Cash at the Beginning of Year Change in Net Operating Working Capital Except Cash 234 B 0 $100,000.00 $0.00 $5,000,000.00 D 55720 Net Income 6 Common Dividends $700,000.00 Machinery Equipment Purchases Depreciation Expense 9 Long-Term Debt 10 Interest Rate on Long-Term Debt $5,400,000.00 $460,000.00 $1,000,000.00 7.00% 11 12 Statement of Cash Flows 13 Operating Activities Formulas 14 Net income #N/A 15 Depreciation expense #N/A 16 17 Change in net operating working capital except cash Net cash provided by (used in) operations $0.00 #N/A 18 19 Long-Term Investing Activities 20 21 22 23 Additions to property, plant and equipment Net cash used in investing activities III. Financing Activities #N/A #N/A 24 Increase in long-term debt 25 Payment of common dividends 26 Net cash provided by financing activities 27 28 IV Summary 29 Net increase (decrease) in cash 30 Cash at beginning of year 31 Cash at end of year #N/A #N/A #N/A #N/A $100,000.00 #N/A 32 33