Refer to all of the facts in Problem 12-3A.

Required
1. Using the format in the chapter€™s appendix, prepare a statement of cash flows work sheet.
2. Prepare a statement of cash flows for 2014 using the indirect method in the Operating Activities section.
3. On the basis of your statement in part (2), draft a brief memo to the president to explain why cash decreased during such a profitable year. Include in your explanation any recommendations for improving the company€™s cash flow in future years.

Data From Problem 12.3A

Wabash Corp. just completed another successful year, as indicated by the following income statement:
                                                                                    For the Year Ended
                                                                                    December 31, 2014
Sales revenue ..............................................................$2,460,000
Cost of goods sold .........................................................1,400,000
Gross profit ..................................................................$1,060,000
Operating expenses .........................................................460,000
Income before interest and taxes ...............................$ 600,000
Interest expense ...............................................................100,000
Income before taxes .....................................................$ 500,000
Income tax expense .........................................................150,000
Net income .....................................................................$ 350,000
Presented here are comparative balance sheets:

Other information is as follows:
a. Dividends of $350,000 were declared and paid during the year.
b. Operating expenses include $25,000 of depreciation.
c. Land was sold for its book value, and new plant and equipment were acquired for cash.
d. Part of the bank loan was repaid, and additional common stock was issued for cash.
The president has asked you some questions about the year€™s results. She is very impressed with the profit margin of 14% (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 $100,000.

Transcribed Image Text:

December 31 2014 2013 $ 140,000 $ 210,000 Cash Accounts receivable 60,000 145,000 Inventory 180,000 200,000 Prepayments 15,000 25,000 $ 415,000 $ 600,000 $ 560,000 $ 700,000 Total current assets Land Plant and equipment Accumulated depreciation 850,000 600,000 (225,000) (200,000) $1,100,000 Total long-term assets $1,225,000 Total assets $1,640,000 $1,660,000 $ 120,000 $ 140,000 Accounts payable Other accrued liabilities 55,000 50,000 Income taxes payable 80,000 $ 270,000 $ 200,000 $ 450,000 720,000 $1,170,000 115,000 $ 290,000 $ 250,000 $ 400,000 Total current liabilities Long-term bank loan payable Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 720,000 $1,120,000 $1,640,000 $1,660,000