DTAP Q Search this com Statement of cash flows Video 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 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 $700,000 in dividends 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 $440,000; however, the purchase price for the machinery represents additions to property, plan 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 5% 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 milli should be entered as 5,000,000. Round your answer to the nearest dollar, if necessary. Check My Work Reset Problem Back a Blank page O E Search or enter web address x Excel template File Tell me what you want to do Home Insert Data Review View X Cut Arial 10 LL Copy Paste Format Painter BI UD Help A A ES A . $ % Undo Clipboard Font Alignment Numbo B14 F 1 Statement of cash flows 3 Cash at the Beginning of Year Change in Net Operating Working Capital Except Cash 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 $700,000.00 $5,400,000.00 $440,000.00 $1,000,000.00 5.00% Formulas 12 13 14 15 16 UNA Statement of Cash Flows Operating Activities Net income Depreciation expense Change in net operating working capital except cash Net cash provided by (used in) operations #NA $0.00 #N/A 19 II Long-Term Investing Activities Additions to property, plant and equipment Net cash used in investing activities UNA HINA NNNN III Financing Activities Increase in long-term debt Payment of common dividends Net cash provided by financing activities #N/A HINA NA Sheet1 Saved to engage Type here to search template - a Blank page X + > 0 Search or enter web address x) Excel File Home Insert Data Review View Help X Cut - 10 - A Copy Paste Format Painter BI U D I Clipboard Font Tell me what you want to do Arial A 22 A - $ - % Undo Alignment Number B14 19 20 21 II. Long-Term Investing Activities Additions to property, plant and equipment Net cash used in investing activities WNA #N/A A #N/A III. Financing Activities Increase in long-term debt Payment of common dividends Net cash provided by financing activities #N/A #N/A #N/A IV. Summary Net increase (decrease) in cash Cash at beginning of year Cash at end of year $100,000.00 #N/A Sheet1 Saved to Cengage Type here to search