Question: Download the 'Applying Excel' worksheet below and save it to your computer. View the tutorial video, and then complete the worksheet. Enter formulas in cells
Download the 'Applying Excel' worksheet below and save it to your computer. View the tutorial video, and then complete the worksheet. Enter formulas in cells that contain question marks (only use formulas). After entering formulas in all of the cells that contain question marks, verify that the amounts match the example below. (a) Calculate operating cash flows Sell inventory to customers $ 86,000 Earn interest on investments 2,000 Purchase inventory (38,000 ) Pay salaries (39,000 ) Net operating cash flows $ 11,000 (a) Calculate investing cash flows Sell land $ 98,000 Sell patent 61,000 Purchase equipment (180,000 ) Net investing cash flows $ (21,000 ) (c) Calculate financing cash flows Issue common stock $ 75,000 Issue notes payable 53,000 Purchase treasury stock (40,000 ) Repay notes payable (30,000 ) Pay dividends (15,000 ) Net financing cash flows $ 43,000 (d) Calculate ending cash Beginning cash $ 53,000 Net operating cash flows 11,000 Net investing cash flows (21,000 ) Net financing cash flows 43,000 Ending cash $ 86,000 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. Save your completed Applying Excel form to your computer and then upload it here by clicking Browse. Next click Save. You will use this worksheet to answer questions in Part 2.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
