Reference no: EM131011304

Peoria Corp. just completed another successful year, as indicated by the following income statement:

.........................................................For the Year Ended December 31, 2014

Sales revenue ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,$ 1,250,000

Cost of goods sold .....................................................700,000

..........................................................................______________

.....Gross profit ...................................................$.... 550,000

Operating expenses ...................................................150,000

..........................................................................______________

.....Income before interest and taxes ....................$..... 400,000

Interest expense ..........................................................25,000

.........................................................................._______________

.....Income before taxes...................................... $..... 375,000

Income tax expense............................................. 150,000

..........................................................................________________

Net income ........................................................$..... 225,000
..........................................................................==============

Presented here are comparative balance sheets:
....................................................................................................December 31
..........................................................................................2014 ......................................2013
Cash.................................................................... $ ........52,000................................$.... 90,000

Accounts receivable .......................................................180,000.....................................130,000

Inventory .......................................................................230,000.....................................200,000

Prepayments....................................................................15,000.......................................25,000

...................................................................................____________...........................____________

.....Total current assets .........................................$........477,000...............................$.....445,000

.................................................................................._____________.........................._____________

Land.....................................................................$.........750,000..............................$.....600,000

Plant and equipment.........................................................700,000.....................................500,000

Accumulated depreciation................................................(250,000).................................. (200,000)

..................................................................................._____________.........................._____________

.....Total long-term assets.......................................$.......1,200,000.............................$.....900,000

..................................................................................______________.........................______________

..........Total assets.................................................$.......1,677,000.............................$...1,345,000

...............................................................................=============..........................=============

Accounts payable...................................................$..........130,000............................ $......148,000

Other accrued liabilities.........................................................68,000......................................63,000

Income taxes payable......................................................... 90,000.....................................110,000

......................................................................................___________..............................__________

.....Total current liabilities........................................ $.......... 288,000 ...........................$ ......321,000

......................................................................................____________............................___________

Long-term bank loan payable................................... $.......... 350,000............................$.......300,000

......................................................................................___________.............................____________

Common stock....................................................... $.......... 550,000........................... $........400,000

Retained earnings.................................................................489,000......................................324,000

......................................................................................___________............................_____________

.....Total stockholders' equity ...................................$.........1,039,000 ..........................$........ 724,000

......................................................................................____________..........................._____________

..........Total liabilities and stockholders' equity........... $.........1,677,000......................... $........1,345,000

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.

c. 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 te company maintain a minimum cash balance of $10,000.

Questions:

1. Prepare a statement of cash flows for 2014 using the direct method in the Operating Activities section.

2. Prepare another statement of cash flows for 2014 using the indirect method in the Operating Activities section.

3. 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 recommendations for improving the company's cash flow in future years.

4. 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.