05 Problem 12-3 Statement of Cash Flows-Direct Method Peoria Corp. just completed another successful year, as indicated by the following income statement: Sales revenue Cost of goods sold Gross profit Operating expenses Income before interest and taxes Interest expense Income before taxes Income tax expense Net income For the Year Ended December 31, 2017 $1,250,000 700,000 $ 550,000 150,000 $ 400,000 25.000 $ 375,000 150,000 $ 225,000 Presented here are comparative balance sheets: December 31 2017 2016 Cash Accounts receivable Inventory Prepayments Total current assets Land Plant and equipment Accumulated depreciation Total long-term assets Total assets Accounts payable Other accrued liabilities Income taxes payable Total current liabilities Long-term bank loan payable Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ 52,000 180,000 230,000 75,000 $ 477,000 $ 750,000 700,000 (250,000 $1,200,000 $1,677,000 $ 90,000 130,000 200,000 25,000 $ 445,000 S 600,000 500,000 (200,000) $ 900,000 $1,345,000 $ 148,000 63,000 110,000 S 321,000 $ 300,000 $ 400.000 324,000 $ 724,000 S1,345,000 $ 130,000 68,000 90,000 $ 288,000 $ 350,000 $ 550,000 489,000 $1,039,000 $1,677,000 c. Other information is as follows: a. Dividends of $60,000 were declared and paid during the year. b. Operating expenses include $50,000 of depreciation. Land and plant and equipment were acquired for cash, and additional stock was issued for cash. Cash also was received from additional bank loans The president has asked you some questions about the year's results. She is very impressed with the profit margin of 18% (net income divided by sales revenue). She is bothered, however, by the decline in the company's cash balance during the year. One of the conditions of the existing bank loan is that the company maintain a minimum cash balance of $50,000. Required 1. Prepare a statement of cash flows for 2017 using the direct method in the Operating Activ- ities section 2 On the basis of your statement in part (1), draft a brief memo to the president to explain why cash decreased during such a profitable year. Include in your explanation any recom- mendations for improving the company's cash flow in future years. 05 Problem 12-3 Statement of Cash Flows-Direct Method Peoria Corp. just completed another successful year, as indicated by the following income statement: Sales revenue Cost of goods sold Gross profit Operating expenses Income before interest and taxes Interest expense Income before taxes Income tax expense Net income For the Year Ended December 31, 2017 $1,250,000 700,000 $ 550,000 150,000 $ 400,000 25.000 $ 375,000 150,000 $ 225,000 Presented here are comparative balance sheets: December 31 2017 2016 Cash Accounts receivable Inventory Prepayments Total current assets Land Plant and equipment Accumulated depreciation Total long-term assets Total assets Accounts payable Other accrued liabilities Income taxes payable Total current liabilities Long-term bank loan payable Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ 52,000 180,000 230,000 75,000 $ 477,000 $ 750,000 700,000 (250,000 $1,200,000 $1,677,000 $ 90,000 130,000 200,000 25,000 $ 445,000 S 600,000 500,000 (200,000) $ 900,000 $1,345,000 $ 148,000 63,000 110,000 S 321,000 $ 300,000 $ 400.000 324,000 $ 724,000 S1,345,000 $ 130,000 68,000 90,000 $ 288,000 $ 350,000 $ 550,000 489,000 $1,039,000 $1,677,000 c. Other information is as follows: a. Dividends of $60,000 were declared and paid during the year. b. Operating expenses include $50,000 of depreciation. Land and plant and equipment were acquired for cash, and additional stock was issued for cash. Cash also was received from additional bank loans The president has asked you some questions about the year's results. She is very impressed with the profit margin of 18% (net income divided by sales revenue). She is bothered, however, by the decline in the company's cash balance during the year. One of the conditions of the existing bank loan is that the company maintain a minimum cash balance of $50,000. Required 1. Prepare a statement of cash flows for 2017 using the direct method in the Operating Activ- ities section 2 On the basis of your statement in part (1), draft a brief memo to the president to explain why cash decreased during such a profitable year. Include in your explanation any recom- mendations for improving the company's cash flow in future years