Please answer the following questions in Excel form (with Excel formula please THANK YOU) I WILL UPVOTE :) Questions: The following additional information is available for this year. a. The company declared and paid a cash dividend. b. Equipment was sold during the year for $57,600. The equipment originally cost $124,000 and had accumulated depreciation of $57,000. c. Long-term investments that cost $64,000 were sold during the year for $92,500. d. The company did not retire any bonds payable or repurchase any of its common stock. Required: 1. Using the indirect method, compute the net cash provided by/used in operating activities for this year. 2. Prepare a statement of cash flows for this year. 3. Compute free cash flow for this year.

Mary Walker, president of Rusco Company, considers $37,000 to be the minimum cash balance for operating purposes. As can be seen from the following statements, only $32,000 in cash was available at the end of this year. Since the company reported a large net income for the year, and also issued both bonds and common stock, the sharp decline in cash is puzzling to Ms. Walker. Rusco Company Income Statement For This Year Ended July 31