Excel Online Structured Activity: Statement of cash flows You have just been hired as a financal analyst for darrington Industries. Unfortunately, company headquarters (where all of the firm's records are kepe) has been destroyed by fire. So, your first job will be to recreate the firm's cash fiow 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, ft earned 55 mitlion in net income during the year but paid $700,000 in dividends to commen shareholders. Throughout the year, the firm purchased $5.4 million of machinery that was needed for a new project, You have just spoken to the firm's accountants and learned that annual depreciatian expense for the year is $440,000; however, the purchage price for the machinery represents addieions to property, plant, and equipment before depreciation. Finally, you have determined that the coly financing done by the firm was to issue long-term debt of $1 million at a 5% interest rate. The data has been collected in the Microsaft Excel Onlin the spresdsheet and perform the required analysis to answer the questian below. 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 anawer compietely. For exampie, 5 million thould be entered as 5,000,000. Round your answer to the nearest doliar, if necessary