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 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 remained constant during the year. It earned $5 million in net income during the year but paid $750,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 spoken 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 additions to property, plant, and equipment before depreciation. Finally, you have determined that the only financing done by the firm was to issue long-term debt of $1 million at a 6% interest rate. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. x 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 million should be entered as 5,000,000. Round your answer to the nearest dollar, if necessary. \begin{tabular}{|c|c|c|c|c|c|} \hline & A & B & C & D & E \\ \hline 1 & Statement of cash flows & & & & \\ \hline 2 & & & & & \\ \hline 3 & Cash at the Beginning of Year & $100,000.00 & & & \\ \hline 4 & Change in Net Operating Working Capital Except Cash & $0.00 & & & \\ \hline 5 & Net Income & $5,000,000.00 & & & \\ \hline 6 & Common Dividends & $750,000.00 & & & \\ \hline 7 & Machinery Equipment Purchases & $5,400,000.00 & & & \\ \hline 8 & Depreciation Expense & $460,000.00 & & & \\ \hline 9 & Long-Term Debt & $1,000,000.00 & & & \\ \hline 10 & Interest Rate on Long-Term Debt & 6.00% & & & \\ \hline 11 & & & & & \\ \hline 12 & Statement of Cash Flows & & & & \\ \hline 13 & 1. Operating Activities & & & Formulas & \\ \hline 14 & Net income & & & \#N/A & \\ \hline 15 & Depreciation expense & & & #N/A & \\ \hline 16 & Change in net operating working capital except cash & $0.00 & & & \\ \hline 17 & Net cash provided by (used in) operations & & & \#N/A & \\ \hline 18 & & & & & \\ \hline 19 & II. Long-Term Investing Activities & & & & \\ \hline 20 & Additions to property, plant and equipment & & & #N/A & \\ \hline 21 & Net cash used in investing activities & & & #N/A & \\ \hline 22 & & & & & \\ \hline 23 & III. Financing Activities & & & & \\ \hline 24 & Increase in long-term debt & & & #N/A & \\ \hline 25 & Payment of common dividends & & & #N/A & \\ \hline 26 & Net cash provided by financing activities & & & #N/A & \\ \hline 27 & & & & & \\ \hline 28 & IV. Summary & & & & \\ \hline 29 & Net increase (decrease) in cash & & & #N/A & \\ \hline 30 & Cash at beginning of year & $100,000.00 & & & \\ \hline 31 & Cash at end of year & & & #N/A & \\ \hline 32 & & & & & \\ \hline 33 & & & & & \\ \hline 34 & & & & & \\ \hline 35 & & & & & \\ \hline 36 & & & & & \\ \hline \end{tabular}