Excel Online Structured Activity: Statement of cash flows You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been deste 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 it working capital accounts except cash remained constant during the year. It earned $5 million in net income during the year but paid $800,000 in dividends to common shareholders. Throughout the year, the firm purchased $5.4 million of machinery that was needed for a new project. You have just spoloon to the firm's accountants and learned that annual depreciation expense for the year is $460,000; however, the purchase price for the machinery represents addition to property, plants and equipmen before depreciation. Finally, you have determined that the only financing done by the firm was to issue long-term debt of $1 million at 74 interest rate. The data har been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer 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 new write out your ans completely for example, in should be entered as 5.000.000. Round your answer to the nearest dollar if necessary Check My Wor Reset