tace Online Dructured Activity Statement of each to You have just been red as a financial analyst for Barrington Intres nortunately, comany headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first will be to recreate them'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 remained constant during the year. I earned 35 milionin net income during the year but paid $700.000 dividend to common olders Thot the war the form purchased 154 million of machinery that was needed for a new have an so the free and learned that preciation expense for the year 140,000, however, the puchow price for the machinery representation to property, plant, out before depreciation. Faly you have determined that the only financing done by the firm was to me Jong-term det of 81 million to interest rate. The datas been collected in the Microsoft Excel Online fie below. Open the spreadsheet and perform the required analysis to answer the question below Open spreadsheet What was the firm's end of year.com www.ce Recreate the tree's cash flow statement te vor answer Write out your answer completely. For example, 5 milion should be entered as 5,000,000. Round your answer to the nearest dobar, necessary E C E-Portal | Cumberland University Ch 03: Assignment - Financial Statements, Excel template - Saved Search (Option File Home Insert Formulas Data Review View Help Edit Arial v 10 V B V B26 B D $100,000.00 $0.00 $5,000,000.00 $700,000.00 $5,400,000.00 $440,000.00 $1,000,000.00 5.00% Formulas #N/A #N/A A 1 Statement of cash flows 2 3 Cash at the Beginning of Year 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 11 12 Statement of Cash Flows 13 1. Operating Activities 14 Net income 15 Depreciation expense 16 Change in net operating working capital except cash 17 Net cash provided by (used in) operations 18 19 M. Long-Term Investing Activities 20 Additions to property, plant and equipment 21 Net cash used in investing activities 22 23 NI. Financing Activities 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 32 33 34 35 $0.00 $0.00 -815+B14 #N/A #N/A #NIA #NA WNA #N/A $100,000.00 #N/A Sheet1 +