Instructions: Create an Excel File to answer the following questions listec Problem 3.31 Vanderheiden Hog Products Corp. provided the following financial information for the quarter ending June 30,2013 : What is this firm's cash flow from operating activities during this quarter? (If an amount reduces the cash flow then enter with negative sign preceding the number e.g. -45 or parentheses e.g. (45).) ProhleiJJ 5.52 Analysts following the Tom kovick Golf Company we re given the following balance sheetinform ation for the years ended June 30,2013, and June 30 , In addition, itwas reported that the company had a net income of $2,894,848 and that depreciation expenses were equal to $242,366 during 2013 . a. Construct a 2013 cash flow statement for this firm. b. Calculate the net cash provided by operating activities for the statement of cash flows. c. '.W hat is the net cash used in investing activities? d. Compute the netcash provided by financing activities. Problem 3.29 Eau Claire Paper llili, Inc., had, atthe beginning ofthe currentfiscalyear,.A pril 1, 2012. retained earnings of $322,525. During the year ended llarch 31,2013 .the com pany produced netincome after taxes of 7J3.175 and paid out 41 percent ofits netincome as dividends. Construct a statem ent of retained earnings and compute the year-end balance of retained earnings. (Round anslvefs ro 2cfec/ma/p/aces, e.g. 5.25./ Instructions: Create an Excel File to answer the following questions listec Problem 3.31 Vanderheiden Hog Products Corp. provided the following financial information for the quarter ending June 30,2013 : What is this firm's cash flow from operating activities during this quarter? (If an amount reduces the cash flow then enter with negative sign preceding the number e.g. -45 or parentheses e.g. (45).) ProhleiJJ 5.52 Analysts following the Tom kovick Golf Company we re given the following balance sheetinform ation for the years ended June 30,2013, and June 30 , In addition, itwas reported that the company had a net income of $2,894,848 and that depreciation expenses were equal to $242,366 during 2013 . a. Construct a 2013 cash flow statement for this firm. b. Calculate the net cash provided by operating activities for the statement of cash flows. c. '.W hat is the net cash used in investing activities? d. Compute the netcash provided by financing activities. Problem 3.29 Eau Claire Paper llili, Inc., had, atthe beginning ofthe currentfiscalyear,.A pril 1, 2012. retained earnings of $322,525. During the year ended llarch 31,2013 .the com pany produced netincome after taxes of 7J3.175 and paid out 41 percent ofits netincome as dividends. Construct a statem ent of retained earnings and compute the year-end balance of retained earnings. (Round anslvefs ro 2cfec/ma/p/aces, e.g. 5.25./