Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Behavioral Finance

Authors: Edwin Burton, Sunit N. Shah

1st Edition

111830019X, 978-1118300190

More Books

Students also viewed these Finance questions

Question

What is meant by a green or sustainable strategy?

Answered: 1 week ago