11:47 PM Tue Nov 9 1.0 $5%0. X Week 2 Homework Excel template - Saved Search (Option+Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments 2 v 2 Arial 10 B AV a2 General 8 D E E27v or ... F30 f f A B D E F G H I ) K L M N 0 Statement of cash flows Cash at the Beginning of Year Change in Net Operating Working Capital Except Cash Net Income Common Dividends Machinery Equipment Purchases Depreciation Expense Long-Term Debt 10 Interest Rate on Long-Term Debt $100,000.00 $0.00 $5,000,000.00 $600.000.00 $5,400,000.00 $460,000.00 $1.000.000.00 7.00% Formulas #N/A #NIA $0.00 #N/A 1 23456789uuuBnggan 12 Statement of Cash Flows 13 I. Operating Activities 14 Net incomo 15 Depreciation expense 16 Change in net operating working capital except cash 17 Net cash provided by (used in) operations 18 19 W. Long Term Investing Activities 20 Additions to property, plant and equipment 21 Net cash used in investing activities 22 23 W. Financing Activities 24 Increase in long-term debt 25 Payment of common dividends 26 Net cash provided by financing activities #NIA #N/A #N/A #N/A #N/A #N/A $100.000.00 #N/A 28 IV. Summary Net increase (decrease) in cash Cash at boginning of year 31 Cash at end of year 32 33 34 35 36 37