Question

le Data Review View Help Tell me what you want to do 14 Home Insert X Cut Le Copy Format Painter Clipboard General Arial 10 - A A BIUD #CA Paste 2. $ . % 19 Conditional Format Formatting as Table Tables Font Alignment Number сар GH Statement of cash flows Cash at the Beginning of Year Change in Net Operating Working Capital Except Cash Not Income Common Dividends Machinery Equipment Purchases Depreciation Expense Long-Term Debt Interest Rate on Long-Term Debt $100,000.00 $0.00 $5,000,000.00 $700,000.00 $5,400,000.00 $460,000.00 $1,000,000.00 5.00% Statement of Cash Flows 1. Operating Activities Net income Depreciation expense Change in net operating working capital except cash Net cash provided by (used in) operations Formulas ΗΝΙΑ UNIA $0.00 #N/A II. Long-Term Investing Activities Additions to property, plant and equipment Net cash used in investing activities #N/A UNA

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

2156 1 Le X V x 3 ENG e 1901 2020 B FX A B 100000 C D E F G H I J K L M 3 cash at the beginning of the year 4 changes in net operating working capital except cash 5 Net income 6 common dividends 7 machinery equipment purchases 8 depreciation expenses 9 long term debt 10 interest rate on long term debt 5000000 700000 5400000 460000 1000000 5.00% 12 statement of cash flows 13 1.Operating activities 14 net income 15 depreciation expenses 16 changes in net operating working capital except cash 17 net cash provided by (used in) operations 5000000 460000 formulas (=B5] (=B8] (=B4] (=SUM(B14:B16)] 5460000 -5400000 -5400000 (=-B7] (=SUM(B20)] 19 II. Long term investing activities 20 Additions to PP&E 21 net cash used in investing activities 22 23 III. Financing activities 24 Increase in long term debt 25 Payment of common dividends 26 net cash used by financing activities 27 28 IV. Summary 29 Net increase(decrease) in cash 30 cash at the beginning of the year 31 cash at the end of year ... Sheels Sheet6 SMOLIRA Sheel 1000000 -700000 300000 (=B9] (=-36] [ESUM(B24:B25)] 360000 (=B17+B21+B26] 100000 (=B3] 460000 (=SUM(B29:B30)] balance sheel increase decrease RHODES sumproduct CONGRESS +