Excel Online Structured Activity: Statement of cash flows You have jat hired asa finan analyst for Barrington Industries. Unfortunately, company headquarters (where al of the frm's records are kept has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash million of machinery that was needed for a new project. You have just spoken to the firms accountants and learned that annual depreciation expense for the year is $450,000; however, the long-term debt of $1 maon at a 7% trest rate. The data has been collected in the Microsoft Enel Olne nie below. Open the spreadsheet and perform ne mored anarss to answer the urcae priefor the machinery epeertsns to prope,lbprecation nal you have deminedhthe only tinanong doneby the question below Open spreadsheet What was the firm's end-of-year cash balance? Recreate the firm's cash flow statement to arrive at your answer. Write out your answer completely. For example, 5 miltion should be entered as ,000,000 Round your answer to the nearest dollar, if necessary 14 2 3 Cash at the Beginning of Year 4 Change in Net Operating Working Capital Except Cash 5 Net Income 6 Common Dividends 7 Machinery Equipment Purchases 8 Depreciation Expense 9 Long-Term Debt 10 Interest Rate on Long-Term Debt $100,000.00 $0.00 5,000,000.00 $750,000.00 $5,400,000.00 $450,000.00 $1,000,000.00 12 Statement of Cash Flows 13 . Operating Activities 14Net income Formulas #N/A #N/A 15 Depreciation expense $0.00 16 17 18 19 20 21 Change in net operating working capital except cash Net cash provided by (used in) operations #N/A Il. Long-Term Investing Activities Additions to property, plant and equipment Net cash used in investing activities #N/A 23 Ill. Financing Activities 24 25 #N/A #N/A #N/A Increase in long-term debt Payment of common dividends 26 Net cash provided by financing activities 27 28 IV. Summary 29 Net increase (decrease) in cash Cash at beginning of year 30 31 $100,000.00 Cash at end of year #N/A Sheet1