peoria corp. statement of cash flows - indirect method

Project Description:

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 the company maintain a minimum cash balance of $50,000.
required
1. prepare a statement of cash flows for 2014 using the indirect method in the operating activities 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 recommendations for improving the company’s cash flow in future years.
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $0 to $10
Completed
Total Proposals: 3
1 Current viewersl
23 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.8
    546 Jobs 386 Reviews
    $35 in 1 Day
  • 4.8
    405 Jobs 247 Reviews
    $60 in 1 Day
  • 4.9
    73 Jobs 54 Reviews
    $60 in 3 Days