Check your worksheet setup and formulas by changing both the 'Issue common stock' and the beginning cash balance to $50,000. You should now have Net financing cash flows of $18,000 and an ending Cash balance of $58,000. If you do not have these results, check your spreadsheet and formulas and try again.

*Enter ALL excel values as formulas, ex. (C10+C11) in cell F10

AutoSave Off H D - Spiceland 5e_applyingexcel_ch11-2 - Protected View Alina Sarker AS - 0 X File Home Insert Draw Page Layout Formulas Data Review View Help Search Share L14 : x v for C D E F J K L M N O P Q R Given Information:* (a) Calculate operating cash flows Inflows: Issue common stock Sell inventory to customers Issue notes payable Sell land Earn interest on investments Sell patent $75,000 86,000 53,000 98,000 2,000 61,000 Net operating cash flows (b) Calculate investing cash flows Outflows: Purchase equipment Purchase inventory Purchase treasury stock Repay notes payable Pay salaries Pay dividends Net investing cash flows $180,000 38,000 40,000 30,000 39,000 15,000 (c) Calculate financing cash flows Beginning cash $53,000 Net financing cash flows (d) Calculate ending cash Ending cash Student Workbook @ - - + 87% Type here to search o e @ 99. a * $ @ w x ^.. 1 % 278/2020 Required information (a) Calculate operating cash flows Part 1 of 2 Sell inventory to customers Earn interest on investments Purchase inventory Pay salaries Net operating cash flows $ 86,000 2,000 (38,000) (39,000) $ 11,000 16.66 points eBook (a) Calculate investing cash flows Print References Sell land Sell patent Purchase equipment Net investing cash flows $ 98,000 61,000 (180,000) $ (21,000) Required information (c) Calculate financing cash flows Part 1 of 2 Issue common stock Issue notes payable Purchase treasury stock Repay notes payable Pay dividends Net financing cash flows $ 75,000 53,000 (40,000) (30,000) (15,000) $ 43,000 16.66 points eBook Print (d) Calculate ending cash References Beginning cash Net operating cash flows Net investing cash flows Net financing cash flows Ending cash $ 53,000 11,000 (21,000) 43,000 $ 86,000