Calculating total cash flow in excel

Calculating total cash flows - Excel ? - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in X Calibri - 11 %6 JA A A Pasto BIU Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard . Font AI v B D E F G H 1 J Jetson Spacecraft Corp. shows the following information on its income statement: sales = $235,000; costs = $141,000; other expenses = $7,900; depreciation expense = $17,300; interest expense = $12,900; taxes = $19,565; dividends = $12,300. In addition, you're told that the firm issued $6,100 in new equity during the year and redeemed $4,500 in outstanding long-term debt. a. What is the operating cash flow? b. What is the cash flow to creditors? c. What is the cash flow to stockholders? d. If net fixed assets increased by $25,000 during the year, what was the addition to NWC? 4 5 6 7 8 9 10 Sales Costs Other expenses Depreciation expense Interest expense Taxes Dividends $ 235,000 141,000 7,900 17,300 12,900 19,565 12,300 11 12 13 14 New equity Net nourAnAm dat 6,100 IAKOS Calculating total cash flows - Excel - FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in X Calibri - 11 AA M Paste BIU- FH- > %6 Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 fo E F G H 29 30 B Taxes Net income D 19,565 36,335 $ 31 32 33 34 35 Dividends Addition to retained earnings a. Operating cash flow 36 37 38 39 b. Cash flow to creditors C. Cash flow to stockholders 40 41 d. Cash flow from assets 42 43 Net capital spending 44 45 Change in NWC 46 47 48 49