X] Excel template File View Help Tell me what you want to do S 10 AA = = = 25 Home Insert Data Review X Cut Arial LCopy Paste 3 Format Painter BI U D Currency A - $ - % Clipboard Font Alignment Undo 325 fo 1 Statement of cash flows Cash at the Beginning of Year Change in Net Operating Working Capital Except Cash 5 Net Income Common Dividends 7 Machinery Equipment Purchases 8 Depreciation Expense 9 Long-Term Debt 10 Interest Rate on Long-Term Debt 11 12 Statement of Cash Flows 13 . Operating Activities Net income 15 Depreciation expense 16 Change in net operating working capital except cash Net cash provided by (used in) operations $100,000.00 $0.00 $5,000,000.00 $800,000.00 $5,400,000.00 $450,000.00 $1,000,000.00 6.00% Formulas #N/A #N/A $0.00 NA 18 19 II. Long-Term Investing Activities Additions to property, plant and equipment Net cash used in investing activities 22 23 24 III. Financing Activities Increase in long-term debt Payment of common dividends Net cash provided by financing activities ANA #N/A ANA 28 IV. Summary Net increase (decrease) in cash Cash at beginning of year Cash at end of year $100,000.00 Video Excel One Structured Activity Statement of show o u You have just been hired as a francal analyst for Barton Industries fortunate company h a s where the cash ostaterent for the year ustended the firm 100.000 thbank at the end of the years work i during the year but do 300 individends to common hard Thu the year, the purchased m Learned that anual depreciation Expense for the year is 450.000:hover the purchase price for the machinery the wytracing done by them was long-term debt of S o nata terestre The data has been conected records an d y s th e e diant e r to s t the What the firm's end of each baland the newesto necessary