Question

financial statement information and additional data for Stanislaus Co. is presented below. Prepare a statement of cash flows for the year ending December 31, 2014December 31 2013 2014Cash $42,000 $75,000Accounts receivable (net) 84,000 144,200Inventory 168,000 206,600Land 58,800 21,000Equipment 504,000 789,600TOTAL $856,800 $1,236,400Accumulated depreciation $84,000 $115,600Accounts payable 50,400 86,000Notes payable - short-term 67,200 29,400Notes payable - long-term 168,000 302,400Common stock 420,000 487,200Retained earnings 67,200 215,800TOTAL $856,800 $1,236,400Additional data for 2014:1. Net income was $240,000, see income statement below.2. Depreciation was $31,600.3. Land was sold at its original cost.4. Dividends were paid.5. Equipment was purchased for $184,000 cash.6. A long-term note for $101,000 was used to pay for an equipment purchase.7. Common stock was issued8. Company issued $33,400 long-term note payable. Income Statement For the year ended December 31, 2014Sales revenue…………….. $1,200,000Cost of goods sold……… .......480,000Gross profit .............................720,000Selling and administrative expenses….. 360,000Pre-tax operating income .......................340,000Income taxes ..........................................120,000Net income……………………………… $240,0001. Prepare the statement of cash flow using the indirect method2. Prepare the statement of cash flow using the direct method

Answer 1

Answer:

Statement of cash flow for the year ended December 31, 2014

Cash flow from Operating Activities

Cash Receipts from Customers                       $1,139,800

Cash Paid to Suppliers and Employees           ($811,600)

Cash Generated from operations                     $328,200

Income tax paid                                                 ($120,000)

Net Cash from Operating Activities                 $208,200

Cash flow from Investing Activities

Purchase of Equipment                                     ($101,000)

Proceeds from Sale of Land                               $37,800

Net Cash from Investing Activities                      $63,200

Cash flow from Financing Activities

Issue of Note Payables                                      $33,400

Repayment of Note Payables                           ($37,800)

Issue of Common Stock                                     $67,200

Dividends Paid                                                   ($91,400)

Net Cash from Financing Activities                  ($28,600)

Movement during the year                                $33,000

Beginning Cash and Cash Equivalents             $42,000

Ending Cash and Cash Equivalents                   $75,000

Explanation:

The Direct Method has been used to to prepare Cash flow Statement. See also calculation of the respective line items done below.

Cash Receipts from Customers calculation :

Total Trade Receivables T - Account

Debit :

Beginning Balance                              $84,000

Sales Revenue                                $1,200,000

Totals                                               $1,284,000

Credit :

Cash Receipts from Customers      $1,139,800

Ending Balance                                  $144,200

Totals                                               $1,284,000

Cash Paid to Suppliers and Employees calculation :

Cost of goods sold                                          $480,000

Add Selling and administrative expenses     $360,000

Adjustment for Non -Cash Items :

Depreciation                                                      ($31,600)

Adjustment for Working Capital Items :

Increase in Inventory                                         $38,800

Increase in Accounts Payables                        ($35,600)

Cash Paid to Suppliers and Employees           $811,600

Note payable T - Account

Debit :

Ending (29,400 + 302,400)                             $331,800

Cash (Balancing figure)                                     $37,800

Totals                                                               $369,600

Credit :

Beginning (67,200 + 168,000)                       $235,200

Equipment                                                        $101,000

Cash                                                                   $33,400

Totals                                                               $369,600

Equipment T - Account

Debit :

Beginning Balance                                        $504,000

Note Payable                                                   $101,000

Cash                                                                 $184,000

Totals                                                              $789,000

Credit :

Ending Balance                                              $789,600

Disposal                                                                      $0

Totals                                                              $789,000

Calculation of Dividends

Beginning Retained Earnings Balance          $67,200

Add Income for the year                              $240,000

Less Ending Retained Earnings Balance     $215,800

Dividends Paid                                                 $91,400