CashFlow With Solutions

Acct 592 – Spring 2005 The Statement of Cash Flows Purpose of a statement of cash flows: To provide information about t

Views 127 Downloads 8 File size 814KB

Report DMCA / Copyright

DOWNLOAD FILE

Recommend stories

Citation preview

Acct 592 – Spring 2005

The Statement of Cash Flows Purpose of a statement of cash flows: To provide information about the cash inflows and outflows of an entity during a period. To summarize the operating, investing, and financing activities of the business.

The cash flow statement helps users to assess a company’s liquidity, financial flexibility, operating capabilities, and risk. The statement of cash flows is useful because it provides answers to the following important questions: Where did cash come from? What was cash used for? What was the change in the cash balance?

Specifically, the information in a statement of cash flows, if used with information in the other financial statements, helps external users to assess: 1.

A company’s ability to generate positive future net cash flows,

2.

A company’s ability to meet its obligations and pay dividends,

3.

A company’s need for external financing,

4.

The reasons for differences between a company’s net income and associated cash receipts and payments, and

5.

Both the cash and noncash aspects of a company’s financing and investing transactions.

180694588.doc created by T. Gordon 10/16/2013

Page 1

Acct 592 – Spring 2005

What can we learn from SCF that is not already available in the other financial statements?

It provides answers to important questions like: Where did cash come from? What was cash used for? What was the change in the cash balance? Couldn’t we just look the balance sheet? The change in cash could be determined, but the statement of cash flows provides detailed information about a company’s cash receipts and cash payments during the period. Many things you want to know about a company is summarized in this one statement Operating, financing and investing cash flows

Net income does not always tell the whole story about operating performance. A statement of cash flows is an excellent forecasting tool.

Review of terms Cash and cash equivalents It is a short-term, highly liquid investment. It must be readily convertible to cash and it must be so near to maturity that there is insignificant risks of changes in value due to changes in interest rate.

180694588.doc created by T. Gordon 10/16/2013

Page 2

Acct 592 – Spring 2005

Noncash revenues and expenses Net income includes items that were neither cash inflow nor cash outflows: Depreciation expense Accretion expense on asset retirement obligation Amortization of intangibles Impairment loss on goodwill and intangibles Earnings of affiliated companies accounted for using the equity method Impairment losses on other noncurrent assets Compensation expense related to stock options Net income also includes gains and losses from investing and financing activities Gain ≠ cash received (unless carrying value was zero) Even when there is a loss, cash might have been received Net income must be adjusted for these items to get the cash provided by operations – part of the reconciling schedule or “indirect method” For other items, there are revenues/expenses as well as cash flows but the amounts are different: Bond interest expense ≠ bond interest paid (if bonds were sold at premium or discount) Sales were not all collected in cash (bad debts, other changes in Accounts Receivable) Purchases were not necessarily paid for during period (change in Accounts Payable) Income tax expense ≠ income taxes paid due to deferred tax assets/liabilities as well as income taxes refunds receivable or unpaid taxes owed

180694588.doc created by T. Gordon 10/16/2013

Page 3

Acct 592 – Spring 2005 Company, Inc. Statement of Cash Flows For the year ended December 31, 199X Cash Flows from Operating Activities Cash received from customers Cash received as interest income * Cash received as dividend income Cash paid for cost of goods sold * Cash paid for selling expenses Cash paid for general & administrative expenses Cash paid for interest (including interest on capital leases) Cash paid for income taxes Cash that would have been paid for taxes except for “excess tax deduction” related to stock based compensation Net cash provided by (or used by) operating activities Cash Flows from Investing Activities Cash received from sale of property, plant, & equipment Cash received from sale of investments Cash received from repayment of note receivables Cash paid to acquire property, plant, and equipment Cash paid to acquire investments Cash paid out as a loan Net cash provided by (or used by) investing activities Cash Flows from Financing Activities Cash received as proceeds from issuance of debt Cash received as proceeds from issuance of stock Cash received as proceeds from reissuance of treasury stock Cash paid to repay debt (principal payment) Cash paid on principal related to capital leases Cash paid to reacquire stock (purchase treasury stock) Cash paid as dividends Cash retained due to “excess tax deduction” related to stock options Net cash provided by (or used by) financing activities Net increase (decrease) in cash Beginning cash and cash equivalents balance =Ending cash and cash equivalents balance Schedule of Noncash Investing and Financing Activities Assets for Liabilities &/or Equity Liabilities &/or Equity for Assets Liabilities for Equity and Equity for Liabilities Capital lease (acquisition of asset and obligation for lessee) A reconciliation of net income to cash provided by operations *Brackets indicate items that are normally combined

180694588.doc created by T. Gordon 10/16/2013

Page 4

Acct 592 – Spring 2005

Operating Activities (Usually associated with working capital accounts like Accounts receivable, inventory, salaries payable, etc.) Inflows: From sale of goods and services From receiving dividends investments From receiving interest from investments or loans From sale of trading securities From reduced income taxes due to “excess tax deduction” related to stock options

Outflows: To suppliers for inventory and other materials To employees for services To other entities for services (insurance, etc.) To government for taxes To lenders for interest To purchase trading securities Interest expense is an operating item! Investment earnings (dividends & interest) is an operating item! Buying and selling trading securities are operating activities! These things may not make sense to you – so “memorize.”

180694588.doc created by T. Gordon 10/16/2013

Page 5

Acct 592 – Spring 2005

Investing Activities (Usually associated with long-term assets) Inflows:

From sale of property, plant and equipment From sale of debt or equity investments of other entities* From collections of principal on loans to other entities Outflows:

To purchase property, plant and equipment To purchase debt or equity securities of other entities To make loans to other entities

*except investments classified as trading securities which are included in operating activities

180694588.doc created by T. Gordon 10/16/2013

Page 6

Acct 592 – Spring 2005

Financing Activities (Usually associated with long-term liability and equity items) Inflows:

From issuance of debt (bonds and notes) From issuance of equity securities Common stock Preferred stock Re-issuance of treasury stock Outflows:

To stockholders as dividends To repay or retire long-term debt, including capital leases for lessee (interest on leases is classified as operating) To reacquire capital stock (treasury stock)

An “anomaly” on SCF Dividends are paid to stockholders and interest is paid to bondholders. Dividends paid are shown as outflows under financing activities However, FASB defined interest expense to be an operating activity Interest & dividend revenue are defined to be operating activities, too.

180694588.doc created by T. Gordon 10/16/2013

Page 7

Acct 592 – Spring 2005

Direct versus Indirect Presentations FASB Statement No. 95 allows two ways to calculate and report a company’s net cash flow from operating activities on its statement of cash flows.

The Direct Method Under the direct method, operating cash outflows are deducted from operating cash inflows to determine the net cash flow from operating activities. If you choose the direct method, a reconciliation of cash provided by operations to net income is a required disclosure. This is the same schedule that appears in a statement prepared using the indirect method The required information items on a direct method statement of cash flow (per FASB) Operating Inflows Cash collected from customers (including lessees, tenants, licensees, and the like) Interest and dividends received Other operating cash receipts, if any Operating outflows Cash paid to employees and other suppliers of goods or services (including insurance, advertising and the like) Interest paid Income taxes paid Other operating cash payments, if any

The Indirect Method Under the indirect method, net income is adjusted for noncash items related to operations to compute the net cash flow from operating activities. If you choose to use the indirect method, you must also disclose interest paid and income taxes paid during the year.

180694588.doc created by T. Gordon 10/16/2013

Page 8

Acct 592 – Spring 2005

Other disclosures Under both methods (direct & indirect), you must disclose noncash financing and investing activities This can be on face of the statement or in the notes to the financial statements. Examples: Trade common stock for land Convertible bonds converted to common stock

Noncash Items Some financing and investing activities do not affect an entity’s cash flow. Examples: Trade common stock for land Issue bonds in exchange for a building Convertible bonds converted to common stock

Significant transactions should be disclosed separately. The disclosure of significant noncash financing and investing activities are required under both methods (direct & indirect) The disclosure can be on face of the statement or in the notes to the financial statements. Theoretical Considerations The direct method has the advantage of reporting operating cash inflows separately from operating cash outflows, which may be useful in estimating future cash flows. The direct method is more meaningful to most financial statement users and the “tie in” to net income is also provided in a separate schedule which is the same as the indirect method presentation. Under the indirect method, adjustments are made to net income to arrive at cash flow from operating activities. Thus, cash from operating activities is “tied” to net income. An advantage of the indirect method is that income flows are converted from an accrual basis to a cash flow basis. In this manner, the indirect method shows the “quality of earnings” by providing information about intervals of leads and lags between income flows and operating cash flows.

180694588.doc created by T. Gordon 10/16/2013

Page 9

Acct 592 – Spring 2005 Example 1 - Statement of Cash Flow – DIRECT METHOD Year ending 12/31/06 Ref 15,000 X

Palouse Pottery Cash

Year ending 12/31/07 42,000

Target 27,000

40,000 (3,000) 25,000 3,000

37,500 (4,500) 43,000 6,000

(2,500) (1,500) 18,000 3,000

215,000 (80,000) 215,000 (23,000) (2,000) (2,000) (1,500) 0 (25,000) (100,000) (61,500) (215,000) 1997 Rev/(Exp) 93,000 (4,000) 20,000 (35,000) (37,000)

236,000 (82,000) 278,000 (31,000) (9,000) (1,500) (5,500) (8,000) (15,000) (145,000) (63,000) (278,000) 1997 Rec/(Disb)

21,000 (2,000)

Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Expenses Plant, property & equipment Accumulated Depreciation Accounts Payable Salaries Payable Interest payable Income Taxes Payable Dividends Payable Long term liabilities Common stock, $1 par Retained Earnings

Closing entry for Sales Gain/(loss) on sale of PP&E Realized gain/(loss) - land Cost of goods sold Salaries & other operating expenses Bad debt expense Depreciation & amortization Interest expense Income taxes expense Net income (accrual basis) Statement of Cash Flows Operating Activities

Debit Ref 27,000

Credit

(8,000) (7,000) 500 (4,000) (8,000) 10,000 (45,000) (1,500) 0

(2,000) (11,000) (2,500) (7,000) 14,500 (INFLOWS)

(OUTFLOWS)

Investing Activities

Financing Activities

Noncash Financing/Investing CHANGE IN CASH

X

27,000

Totals

Additional information: a. Wrote off $500 accounts receivable as uncollectible b. Sold operational assets for $4,000 cash that had cost $17,000 and had a book value of $8,000 c. Declared a cash dividend of $13,000 180694588.doc created by T. Gordon 10/16/2013

d. e. f. g.

Sold land for $30,000 that had been acquired for $10,000 Paid a $10,000 long-term note installment Purchase plant, property & equipment for $48,000 cash. Issued common stock for $45,000 cash.

Page 10

Acct 592 – Spring 2005 Example 1 - Statement of Cash Flow – INDIRECT METHOD Year ending 12/31/06 Ref 15,000 X

Palouse Pottery Cash

Year ending 12/31/07 42,000

Target 27,000

40,000 (3,000) 25,000 3,000

37,500 (4,500) 43,000 6,000

(2,500) (1,500) 18,000 3,000

215,000 (80,000) 215,000 (23,000) (2,000) (2,000) (1,500) 0 (25,000) (100,000) (61,500) (215,000)

236,000 (82,000) 278,000 (31,000) (9,000) (1,500) (5,500) (8,000) (15,000) (145,000) (63,000) (278,000)

21,000 (2,000)

Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Expenses Plant, property & equipment Accumulated Depreciation Accounts Payable Salaries Payable Interest payable Income Taxes Payable Dividends Payable Long term liabilities Common stock, $1 par Retained Earnings Statement of Cash Flows Operating Activities

Debit Ref 27,000

(INFLOWS)

Credit

(8,000) (7,000) 500 (4,000) (8,000) 10,000 (45,000) (1,500) 0

(OUTFLOWS)

Investing Activities

Financing Activities

Noncash Financing/Investing CHANGE IN CASH

X

27,000

Totals

Additional information: a. Wrote off $500 accounts receivable as uncollectible b. Sold operational assets for $4,000 cash that had cost $17,000 and had a book value of $8,000 180694588.doc created by T. Gordon 10/16/2013

d. Sold land for $30,000 that had been acquired for $10,000 e. Paid a $10,000 long-term note installment f. Purchase plant, property & equipment for $48,000 cash.

Page 11

Acct 592 – Spring 2005 c. Declared a cash dividend of $13,000

Moscow Moving & Storage Cash

Year ending 12/31/06 Ref 15,000

Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Expenses Plant, property & equipment Accumulated Depreciation Accounts Payable Salaries Payable Interest payable Long term liabilities Common stock, $1 par Retained Earnings

g. Issued common stock for $45,000 cash. Example 2 - Statement of Cash Flow Year ending 12/31/07 5,000

Target (10,000)

30,000 (1,500) 10,000 4,500

28,500 (2,000) 17,000 500

(1,500) (500) 7,000 (4,000)

220,100 (20,000) 258,100 (10,000) (3,000) 0 (30,000)

289,100 (16,000) 322,100 (13,000) (1,000) (1,000) (10,000)

69,000 4,000

Debit

Ref

Credit

(100,000) (115,100) (258,100) 1997 Rev/(Exp) 80,000 (2,000) (35,000) (26,000)

Closing entry for Sales Gain/(loss) on sale of PP&E Cost of goods sold Salaries & other operating expenses Bad debt expense Depreciation & amortization Interest expense Income taxes expense Net income (accrual basis) Statement of Cash Flows Operating Activities

(3,000) 2,000 (1,000) 20,000

(181,000) (81,000) (116,100) (1,000) (322,100) 0 1997 Receipt/(Disb)

(1,000) (5,000) (2,000) (3,000) 6,000 (INFLOWS)

(OUTFLOWS)

Investing Activities

Financing Activities

Noncash Financing/Investing

CHANGE IN CASH Totals Additional Information

a. Wrote off $500 accounts receivable as uncollectible b. Sold operational assets for $4,000 cash (cost $15,000, acc'd depreciation $9,000) c. Declared and paid a cash dividend, $5,000

180694588.doc created by T. Gordon 10/16/2013

d. Issued common stock for $36,000 cash e. Paid a $20,000 long-term note installment f. Purchased operational assets, $39,000 cash g. Acquired land in exchange for 1,000 shares of common stock worth $45 each

Page 12

Acct 592 – Spring 2005

Reconciliation of Net Income to Cash Provided by Operations or – “the Indirect Method” Example 2 Moscow Moving & Storage Statement of Cash Flow Worksheet Reconciliation Schedule (Indirect method) Net income

Ref

Cash provided by operations

180694588.doc created by T. Gordon 10/16/2013

Page 13

Acct 592 – Spring 2005 Example 3 Avery Slings & Arrows, Inc. Avery Slings & Arrows Income Statement For year ending

12/31/04

Sales Earnings of affiliates (equity method) Realized loss on sale of equipment Realized gain on sale of investments Interest and dividend revenue Total revenues Cost of goods sold Salaries and wages Other operating expenses Bad debt expense Depreciation expense Amortization of intangibles Accretion expense Interest expense Income tax expense Net income

6,600,000 150,000 (65,000) 53,000 15,000 6,753,000 3,490,000 632,000 421,000 45,000 757,000 5,000 25,000 935,000 177,000

6,487,000 266,000

Prepare a statement of cash flows (direct method) including the required reconciling schedule and any other required disclosures for Avery Slings & Arrows, Inc. Information from the balance sheet and income statement have been entered into a worksheet for your convenience. In addition to completing the worksheet, you MUST prepare a formal statement with headings, subtotals, etc. for full credit. ADDITIONAL INFORMATION a. During the year, ASA paid $2,767,000 in cash for land, building, and equipment. b. On August 5, 2004, ASA issued 25,000 shares of common stock for $42 per share. c. ASA purchased $273,000 in marketable securities during the year. d. Equipment costing $500,000 was sold during the year for $59,000. The book value was $124,000. e. During the year, AAS declared cash dividends in the amount of $203,000. f. On April 1, 2004, the holders of $1,500,000 in convertible bonds elected to convert their bonds to common stock. The conversion ratio was 25 shares of common stock for each share $1,000 face value bond. g. The noncurrent investment represents 30% of the outstanding securities of the investee. This investment is accounted for on the equity method. During 2004, ASA received $29,000 in dividends from the investment. h. On May 1, 2004, ASA acquired equipment under a capital lease. At the inception of the lease, the present value of the minimum lease payments was $648,000. i. ASA acquired a patent on a new process for $500,000 on October 15, 2004. j. During 2004, ASA sold marketable securities which it had acquired for $222,000 for $275,000. k. In February, ASA issued 150,000 shares of common stock in a 50% stock dividend. l. ASA issued $3,000,000 in bonds at face value on August 1, 2004. m. ASA sold 500 shares of treasury stock which it had acquired for $20 per share for $46 per share on January 18, 2004. n. In October, ASA acquired 1,000 shares of treasury stock at $38 per share. o. Bad debts in the amount of $33,000 were written off during the year.

180694588.doc created by T. Gordon 10/16/2013

Page 14

Acct 592 – Spring 2005

Avery Slings & Arrows Balance Sheet Current Assets Cash Securities Available for Sale (at market) Accounts Receivable (net) Merchandise Inventory Prepaid Expenses Noncurrent Assets Investments in affiliated companies (equity method) Land, building & equipment Less Accumulated Depreciation Intangible Assets Total assets Current Liabilities Accounts Payable Salaries Payable Interest payable Income Taxes Payable Dividends Payable Noncurrent Liabilities Bonds Payable Premium/Discount on Bonds Payable Convertible Bonds Payable Lease obligation Asset retirement obligation Deferred Income Taxes Other long term liabilities Stockholder's Equity Common stock, $10 par Additional paid in capital - common Other paid in capital Unrealized (gain)/loss AFS invest Treasury stock (at cost) Retained Earnings Total liabilities and equity

180694588.doc created by T. Gordon 10/16/2013

12/31/04

12/31/03

2,261,000 258,000 1,947,000 602,000 4,000 5,072,000

2,850,000 100,000 1,900,000 900,000 50,000 5,800,000

2,121,000 20,715,000 (2,181,000) 568,000 26,295,000

2,000,000 17,800,000 (1,800,000) 73,000 23,873,000

347,000 18,000 156,000 45,000 128,000 694,000

650,000 21,000 55,000 32,000 60,000 818,000

7,000,000 642,000 1,500,000 2,108,000 275,000 122,000 590,000 12,237,000

4,000,000 656,000 3,000,000 1,825,000 250,000 75,000 2,590,000 12,396,000

5,125,000 3,525,000 13,000 27,000 (38,000) 4,712,000 13,364,000

3,000,000 1,600,000 0 (80,000) (10,000) 6,149,000 10,659,000

26,295,000

23,873,000

Page 15

Acct 592 – Spring 2005 Avery Slings & Arrows Cash

Year ending 12/31/03 Ref Debit 2,850,000 x

Ref Credit

Year ending 12/30/04 Target 589,000 2,261,000 (589,000)

Securities Available for Sale

180,000

231,000

51,000

Allowance to adjust to market

(80,000)

27,000

107,000

1,900,000

1,947,000

47,000

900,000

602,000

(298,000)

50,000

4,000

(46,000)

2,000,000

2,121,000

121,000

17,800,000

20,715,000

2,915,000

(1,800,000)

(2,181,000)

(381,000)

73,000

568,000

495,000

23,873,000

26,295,000

Accounts Payable

(650,000)

(347,000)

303,000

Salaries Payable

(21,000)

(18,000)

3,000

Interest payable

(55,000)

(156,000)

(101,000)

Income Taxes Payable

(32,000)

(45,000)

(13,000)

Dividends Payable

(60,000)

(128,000)

(68,000)

Accounts receivable (net) Merchandise Inventory Prepaid Expenses Investments in affiliated companies (equity method) Land, building & equipment

Accumulated Depreciation Intangible Assets Total assets

Bonds Payable

(4,000,000)

(Premium)/Discount on Bonds Payable

(656,000)

(7,000,000) (3,000,000) (642,000)

14,000

Convertible Bonds Payable

(3,000,000)

(1,500,000) 1,500,000

Lease obligation

(1,825,000)

(2,108,000)

(283,000)

(250,000)

(275,000)

(25,000)

(75,000)

(122,000)

(47,000)

Asset retirement obligation Deferred Income Taxes Other long term liabilities

(2,590,000)

180694588.doc created by T. Gordon 10/16/2013

(590,000) 2,000,000

Page 16

Acct 592 – Spring 2005

Avery Slings & Arrows

Year ending 12/31/03 Ref Debit

Ref Credit

Year ending 12/30/04 Target

Common stock, $10 par

(3,000,000)

(5,125,000) (2,125,000)

Additional paid in capital – common

(1,600,000)

(3,525,000) (1,925,000)

Unrealized (gain)/loss AFS invest

80,000

(27,000)

(107,000)

Treasury stock (at cost)

10,000

38,000

28,000

0

(13,000)

(13,000)

(6,149,000)

(4,712,000)

1,437,000

(23,873,000)

(26,295,000)

2004 Revenue/ Re (Expense) f 6,600,000 150,000 (65,000) 0 0

2004 Operating Cash Inflows/ (Outflows)

Other paid in capital Retained Earnings

Closing entry for

Sales Earnings of affiliated companies Gain/(loss) on sale of equipment Gain/(loss) sale of patent Realized gain/(loss) sale of land Realized gain/(loss) on investments Interest and dividend revenue Cost of goods sold

Ref

53,000 15,000 (3,490,000)

Salaries and wages Other operating expenses Bad debt expense Depreciation expense Amortization of intangibles Accretion expense

(632,000) (421,000) (45,000) (757,000) (5,000) (25,000)

Interest expense

(935,000)

Income taxes expense

(177,000)

Net income (accrual basis)

180694588.doc created by T. Gordon 10/16/2013

266,000

Page 17

Acct 592 – Spring 2005

Avery Slings & Arrows Cash provided by operations: Reconciling schedule: Net income

INFLOWS

OUTFLOWS

266,000

Cash provided by operations

Investing Activities

180694588.doc created by T. Gordon 10/16/2013

0

Page 18

Acct 592 – Spring 2005

Avery Slings & Arrows

INFLOWS

OUTFLOWS

Financing Activities

0

Noncash Financing/Investing

CHANGE IN CASH

589,000 x

Totals

180694588.doc created by T. Gordon 10/16/2013

0

Page 19

Acct 592 – Spring 2005

Avery Slings & Arrows Statement of Cash Flows For year ended December 31, 2004 Inflows Cash provided by operations Cash collected from customers Interest & dividends received Cash paid for merchandise Cash paid to employees Other operating disbursements Interest paid Income taxes paid

(3,495,000) (635,000) (375,000) (848,000) (117,000) (5,470,000)

1,082,000

59,000 (2,767,000) (500,000) 275,000 334,000

Cash provided by financing activities Dividends paid Sold treasury stock Purchased treasury stock Payments on long term debt Payments on capital leases Common stock issued Proceeds from issuing nonconvertible bonds

Net

6,508,000 44,000

6,552,000 Cash provided by investing activities Proceeds from sale of equipment Cash outlay to acquire equipment Cash outlay to acquire patent Proceeds from sale of securities Cash outlay to buy securities

Outflows

(273,000) (3,540,000)

(3,206,000)

(135,000) 23,000 (38,000) (2,000,000) (365,000) 1,050,000 3,000,000 4,073,000

(2,538,000)

1,535,000

Change in cash Beginning balance - Cash

(589,000) 2,850,000

Ending balance - Cash

2,261,000

180694588.doc created by T. Gordon 10/16/2013

Page 20

Acct 592 – Spring 2005 Avery Slings & Arrows Statement of Cash Flows For year ended December 31, 2004 Non-cash financing and investing activities Capital lease Preferred bonds converted to common stock

648,000 1,500,000

Schedule to reconcile net income to cash provided by operations Net Income Depreciation Amortization & impairment of intangibles Accretion expense Amortization of bond premium Realized loss on sale of equipment Realized gain on sale of investments Equity method investments – earnings in excess of dividends Increase in deferred income taxes

266,000 757,000 5,000 25,000 (14,000) 65,000 (53,000) (121,000) 47,000

Change in working capital accounts: Net accounts receivable Merchandise Inventory Prepaid Expenses Accounts Payable Salaries Payable Interest Payable Income Taxes Payable

(47,000) 298,000 46,000 (303,000) (3,000) 101,000 13,000

Cash provided by operations:

1,082,000

180694588.doc created by T. Gordon 10/16/2013

Page 21

Acct 592 – Spring 2005 Acct. 301 - Statement of Cash Flows - Homework 4 Wenatchee Whirlpool World Balance Sheet Current Assets Cash Securities Available for Sale (at market) Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Operating Expenses Noncurrent Assets Investments (equity method) Plant, property & equipment Accumulated Depreciation Intangible Assets TOTAL ASSETS Current Liabilities Accounts Payable Salaries Payable Income Taxes Payable Dividends Payable Current portion long term debt Noncurrent Liabilities Bonds Payable Discount on Bonds Deferred Income Taxes Other long term liabilities Stockholder's Equity Convertible preferred, $100 par Common stock, $10 par Additional paid in capital Unrealized (gain)/loss investments Retained Earnings Total liabilities and equity

180694588.doc created by T. Gordon 10/16/2013

12/31/96

12/31/95

2,837,600 390,000 1,752,000 (120,500) 1,145,000 84,000 6,088,100

2,000,000 150,000 1,900,000 (110,000) 875,000 62,000 4,877,000

3,097,000 16,420,000 (829,000) 71,500 24,847,600

3,000,000 10,800,000 (600,000) 128,000 18,205,000

880,000 20,000 13,400 35,000 29,000 977,400 10,000,000 (247,000) 180,000 562,000 10,495,000 500,000 3,100,000 3,950,000 27,000 5,798,200 13,375,200 24,847,600

750,000 15,000 27,000 60,000 21,000 873,000 5,000,000 (270,000) 88,000 3,000,000 7,818,000 2,000,000 1,500,000 1,200,000 78,000 4,736,000 9,514,000 18,205,000

Page 22

Acct 592 – Spring 2005

Wenatchee Whirlpool World Income Statement For year ending 12/31/96 Sales Earnings of affiliated company (equity method) Gain/(loss) on sale of PP&E Realized gain/(loss) on investments Realized gain on sale of patent Interest and dividend revenue Total revenues Cost of goods sold Salaries and wages Other operating expenses Bad debt expense Depreciation & amortization expense Interest expense Income taxes expense

6,200,000 115,000 (40,000) 108,000 950,000 13,000 7,346,000 3,600,000 590,000 345,000 38,500 250,500 669,400 740,400

Net income

6,233,800 1,112,200

Additional information: a.

On February 25, WWW sold an internally developed patent for $1,000,000. The patent was carried on the books at unamortized legal fees amounting to $50,000 at date of sale.

b.

On March 31, WWW issued $5,000,000 in bonds at face value. The semi-annual bonds have a coupon rate of 10% per annum.

c.

During the year, WWW disposed of various items of equipment with a total book value of $65,000 and original cost of $80,000. The amount received was $25,000 in cash.

d.

During the third quarter, shareholders holding 15,000 shares of the preferred stock converted them into common stock. The conversion ratio was 6 shares of common for each share of preferred.

e.

On July 20, WWW sold 50,000 shares of its common stock for $41 per share.

f.

By the end of the year, WWW had written off as uncollectible a total of $28,000 in accounts receivable.

g.

An existing factory with equipment was acquired during the year. The acquisition cost was allocated as follows: $772,000 to land, $3,450,000 to building and 678,000 to equipment.

h.

WWW acquired a parcel of land adjoining the new factory by giving the owner 20,000 shares of its common stock. At the date of the transaction, the market value of the stock was $40 per share.

i.

During the year WWW purchased $875,000 in marketable securities and sold securities which had cost $584,000. The market value of the portfolio at the end of the year was $390,000.

j.

WWW owns 30% of a company which manufactures parts that WWW uses in its production process. WWW received $18,000 in dividends from this partially owned company during 1996.

k.

Dividends declared during the year totaled $50,000.

180694588.doc created by T. Gordon 10/16/2013

Page 23

Acct 592 – Spring 2005 Homework 4 - Acct 315 Worksheet Wenatchee Whirlpool World

Year ending 12/31/95 Ref

Debit

Cash

2,000,000

837,600

Securities Available for Sale (at market) Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Operating Expenses Investments in affiliated companies (equity method) Plant, property & equipment Accumulated Depreciation Intangible Assets

Accounts Payable

Ref

Credit

Year ending 12/31/96

Target

2,837,600

837,600

390,000

240,000

150,000 1,900,000

1,752,000 (148,000)

(110,000)

(120,500)

(10,500)

875,000

1,145,000

270,000

62,000

84,000

22,000

3,000,000

3,097,000

97,000

10,800,000

16,420,000 5,620,000

(600,000)

(829,000) (229,000)

128,000 18,205,00 0 (750,000)

71,500

(56,500)

24,847,60 0 (880,000) (130,000)

Salaries Payable

(15,000)

(20,000)

(5,000)

Income Taxes Payable

(27,000)

(13,400)

13,600

Dividends Payable

(60,000)

(35,000)

25,000

Current portion long term debt

(21,000)

(29,000)

(8,000)

Bonds Payable

(5,000,000)

(10,000,000 (5,000,00 ) 0)

Premium/Discount on Bonds Payable

270,000

247,000

(23,000)

Deferred Income Taxes

(88,000)

(180,000)

(92,000)

Other long term liabilities

180694588.doc created by T. Gordon 10/16/2013

(3,000,000)

(562,000) 2,438,000

Page 24

Acct 592 – Spring 2005 Wenatchee Whirlpool World 12/31/95 ref

Debit

ref

Credit

12/31/96

Target

Convertible preferred, $100 par

(2,000,000)

Common stock, $10 par

(1,500,000)

(3,100,000) (1,600,000 )

Additional paid in capital

(1,200,000)

(3,950,000) (2,750,000 )

Unrealized (gain)/loss investments

(78,000)

Retained Earnings

(4,736,000) 0 (18,205,00 0)

Closing entry for

Sales

115,000

Gain/(loss) on sale of PP&E

(40,000)

Realized gain/(loss) on investments Realized gain on sale of patent

108,000

Cost of goods sold

(345,000)

Amortization of intangible assets

(38,500) (244,000) (6,500)

Interest expense

(669,400)

Income taxes expense

(740,400)

180694588.doc created by T. Gordon 10/16/2013

Receipt/ (Disb)

(3,600,000)

Other operating expenses

Depreciation expense

1996

13,000

(590,000)

Bad debt expense

(24,847,60 0)

950,000

Salaries and wages

51,000

(5,798,200) (1,062,200 )

6,200,000

Earnings of affiliated companies (equity method)

Interest and dividend revenue

(27,000)

1996 Rev/(Exp)

Net income (accrual basis)

(500,000) 1,500,000

1,112,200

Page 25

Acct 592 – Spring 2005 Wenatchee Whirlpool World Statement of Cash Flows

INFLOWS

OUTFLOWS

Operating Activities

Investing Activities

Financing Activities

Noncash Financing/Investing

CHANGE IN CASH

837,600

Totals

180694588.doc created by T. Gordon 10/16/2013

Page 26

(Subtotals)

Acct 592 – Spring 2005

Statement of Cash Flow – Easy Practice Problems 5 & 6 5.

Ulliman Company Prepare a statement of cash flow – direct method including the reconciliation schedule. Most information is provided on the attached workpaper. Additional information: a. Dividends declared and paid totaled $700. b. On January 1, 1999 the 10% convertible bonds that had originally been issued at face value were converted into 500 shares of common stock. The book value method was used to account for the conversion. c. Long-term nonmarketable investments that cost $1,600 were sold for $2,300. d. The long-term note payable was paid by issuing 250 shares of common stock at the beginning of the year. e. Equipment with a cost of $2,000 and a book value of $300 was sold for $100. f. Equipment was purchased at a cost of $16,200. g. The 12% bonds payable were issued on September 1, 1999 at 97. They mature on September 1, 2009. The company uses the straight-line method to amortize the discount. h. Taxable income was less than pretax accounting income, resulting in a $396 increase in deferred taxes payable. i. Short-term marketable securities were purchased at a cost of $1,300. The portfolio was increased by $300 to a $3,800 fair value at year end by adjusting the related allowance account.

6.

Driskoll Company Prepare a statement of cash flow – direct method including the reconciliation schedule. Most information is provided on the attached workpaper. Additional information: a. Dividends were declared in the amount of $2,100. b. Bonds payable with a face value, book value, and market value of $14,000 were retired on June 30, 1999. c. Bonds payable with a face value of $8,000 were issued at 90.25 on July 31, 1999, They mature on July 31, 2004. The company uses the straight-line method to amortize the bond discount. d. Equipment with a cost of $4,000 and a book value of $1,400 was exchanged for an acre of land valued at $2,700. No cash was exchanged. The transaction was properly considered to be a dissimilar asset exchange. e. Long-term investments in bonds being held to maturity with a cost of $1,000 were sold for $800. f. Sixty-five shares of common stock were exchanged for a patent. The common stock was selling for $20 per share at the time of the exchange. g. A tornado completely destroyed a small building that had an original cost of $8,000 and a book value of $4,800. Settlement with the insurance company resulted in after-tax proceeds of $2,200 and an extraordinary loss (net of income taxes) of $2,600.

180694588.doc created by T. Gordon 10/16/2013

Page 27

Acct 592 – Spring 2005 5.

Homework Assignment – Ulliman Company

Uliman Company Cash Accounts receivable (net) Marketable securities (at cost) Allowance for change in value Merchandise Inventory Prepaid Expenses Investments (long-term) Land Buildings and equipment Accumulated depreciation

Accounts Payable Income Taxes Payable Wages payable Interest payable 12% bonds payable Premium/Discount on Bonds Payable Notes payable (long term) 10% Convertible bonds Deferred Income Taxes Convertible preferred, $100 par Common stock, $10 par Additional paid in capital Unrealized (gain)/loss investments Retained Earnings Closing entry for Sales Other revenue Gain/(loss) on sale of PP&E Realized gain/(loss) on investments Interest and dividend revenue Cost of goods sold Salaries & other operating expenses Other operating expense Depreciation & amortization Interest expense Income taxes expense Net income (accrual basis)

Year ending 01/01/99 Ref 1,400 2,800 1,700 500 8,100 1,300 7,000 15,000 32,000 (16,000) 0 53,800 (3,800) (2,400) (1,100) 0 0 0 (3,500) (9,000) (800) 0 (14,000) (8,700) (500) (10,000) (53,800) 1999 Rev/ (Exp) 39,930 0 (200) 700

180694588.doc created by T. Gordon 10/16/2013

Debit

Worksheet Ref Credit

Year ending 12/31/99 Target 1,000 2,400 (110) 2,690 1,300 3,000 300 800 (190) 7,910 410 1,710 (1,600) 5,400 0 15,000 14,200 46,200 (400) (16,400) 0 0 68,710 (350) (4,150) (104) (2,504) 450 (650) (400) (400) (10,000) (10,000) 290 290 0 0 (1,196) 0 (21,500) (13,700) (800)

3,500 9,000 (396) 0 (7,500) (5,000) (300)

(14,100) (4,100) (68,710) 1999 Receipt/(Disb)

820 (19,890) (11,000) (1,000) (2,100) (410) (2,050) 4,800 (53,800)

Page 28

Acct 592 – Spring 2005 5.

Ulliman Company, continued

Statement of Cash Flows Operating Activities

INFLOWS

OUTFLOWS

Subtotals

Reconciliation Schedule:

Investing Activities

Financing Activities

Noncash Financing/Investing

CHANGE IN CASH Totals

180694588.doc created by T. Gordon 10/16/2013

Page 29

Acct 592 – Spring 2005 6.

Homework Problem – Driskoll Company

Driskoll Company Cash Accounts receivable (net) Inventories Prepaid Expenses Investments (long-term) Land Buildings Acc'd depreciation - Bldg Equipment Acc'd depreciation - Equip Patents

Year ending 12/31/99 Ref 2,700 5,900 15,300 1,400 8,300 16,300 68,700 (35,000) 29,600 (14,200) 8,700 107,700

Accounts Payable Interest payable Wages payable Bonds payable Discount on bonds Common stock, $10 par Additional paid in capital Unrealized (gain)/loss investments Retained Earnings

(8,900) (630) (2,500) (23,000) 0 (22,000) (15,320) 0

(35,350) (107,700) ok Closing entry for 1999 Rev/(Exp) Sales 49,550 Gain/(loss) on exchange of assets 1,300 Realized gain/(loss) on (200) investments Interest and dividend revenue 790 Cost of goods sold (23,800) Salaries & other operating (16,510) expenses Other operating expense (1,100) Depreciation - buildings (2,700) Depreciation - equipment (3,100) Patent amortization (815) Interest expense (1,715) Income taxes expense (500) Extraordinary loss (net of taxes) (2,600) Net income (accrual basis) (1,400)

180694588.doc created by T. Gordon 10/16/2013

Debit

Worksheet Ref Credit

Year ending 12/31/99 Target 3,520 820 6,215 315 15,530 230 1,000 (400) 7,300 (1,000) 19,000 2,700 60,700 (8,000) (34,500) 500 25,600 (4,000) (14,700) (500) 9,185 485 98,850 (9,195) (300) (2,600) (17,000) 715 (22,650) (15,970) 0

(295) 330 (100) 6,000 715 (650) (650) 0

(31,850) 3,500 (98,850) ok 1999 Receipt/(Disb)

Page 30

Acct 592 – Spring 2005 6.

Driskoll Company, continued

Statement of Cash Flows Operating Activities

INFLOWS

OUTFLOWS

Subtotals

Reconciliation Schedule:

Investing Activities

Financing Activities

Noncash Financing/Investing

CHANGE IN CASH Totals

180694588.doc created by T. Gordon 10/16/2013

Page 31

Acct 592 – Spring 2005 7. Statement of Cash Flow Problem from final exam, Spring 1998 Albion Altimeters Inc. Balance Sheet Current Assets Cash Securities Available for Sale (at market) Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Operating Expenses

Noncurrent Assets Plant, property & equipment Accumulated Depreciation TOTAL ASSETS Current Liabilities Accounts Payable Salaries Payable Income Taxes Payable Dividends Payable Noncurrent Liabilities Bonds Payable Premium/Discount on Bonds Payable Deferred Income Taxes

Stockholder's Equity Common stock, $10 par Additional paid in capital Acc'd other comprehensive income* Retained Earnings Total liabilities and equity

12/31/97

12/31/96

310,200 1,112,000

400,000 500,000

781,000 (33,200) 829,000 38,800 3,037,800

900,000 (27,000) 850,000 25,000 2,648,000

3,562,000 (355,000) 6,244,800

1,880,000 (350,000) 4,178,000

Albion Altimeters Inc. Income Statement For year ending Sales Gain/(loss) on sale of PP&E Interest and dividend revenue Total revenues Cost of goods sold Salaries and wages Other operating expenses Bad debt expense Depreciation & amortization expense Interest expense Income taxes expense Net income

413,000 7,200 23,500 0 443,700

350,000 8,500 27,000 25,000 410,500

1,000,000 118,000 103,700 1,221,700

1,000,000 124,000 88,000 1,212,000

1,510,000 1,972,000 13,000 1,084,400 4,579,400 6,244,800

1,000,000 700,000 (14,000) 869,500 2,555,500 4,178,000

3,600,000 (30,000) 15,000 3,585,000 2,100,000 650,000 230,000 17,200 30,000 87,700 180,200

3,295,100 289,900

Required: Use the additional information (below) and the worksheet provided to prepare the statement of cash flow using the direct method. For full credit, use the pages provided to prepare the formal statement in addition to the worksheet. Additional information: a. AA declared dividends of $75,000 on June 30, 1997. b. On Sept. 3, AA sold equipment with a book value of $65,000 for $35,000 in cash. The original cost of the item was $90,000. c. AA purchased for cash plant, property & equipment for $1,740,000. d. On May 15, AA issued 50,000 shares of common stock at $35 each. e. AA wrote off $11,000 of bad debts during 1997. f. AA purchased for cash $585,000 in marketable securities on Apr. 1. g. On Oct. 10, AA issued 1,000 shares of stock in exchange for a parcel of land. At that date, the market price of the stock was $32.

* Other comprehensive income is composed of the holding gains/losses related to available for sale securities.

180694588.doc created by T. Gordon 10/16/2013

12/31/97

Page 32

Acct 592 – Spring 2005 7. Statement of Cash Flow Problem Worksheet Albion Altimeters Inc.

Year ending 12/31/96 Ref

Cash Securities Available for Sale (at market)

400,000 500,000

Accounts Receivable

Debit

Ref

Year ending 12/31/97

Credit

310,200 1,112,000

(89,800) 612,000

900,000

781,000

(119,000)

Allowance for doubtful accounts

(27,000)

(33,200)

(6,200)

Merchandise Inventory

850,000

829,000

(21,000)

Prepaid Operating Expenses

25,000

38,800

13,800

Plant, property & equipment

1,880,000

3,562,000

1,682,000

(350,000)

(355,000)

(5,000)

4,178,000 (350,000)

6,244,800 (413,000)

(63,000)

(8,500)

(7,200)

1,300

Income Taxes Payable

(27,000)

(23,500)

3,500

Dividends Payable

(25,000)

0

25,000

(1,000,000)

(1,000,000)

0

(124,000)

(118,000)

6,000

(88,000)

(103,700)

(15,700)

(1,000,000)

(1,510,000)

(510,000)

(700,000)

(1,972,000)

(1,272,000)

14,000

(13,000)

(27,000)

(869,500)

(1,084,400)

(214,900)

(4,178,000)

(6,244,800)

(2,066,800)

Accumulated Depreciation

Accounts Payable Salaries Payable

Bonds Payable Premium/Discount on Bonds Payable Deferred Income Taxes Common stock, $10 par Additional paid in capital Acc'd other comprehensive income Retained Earnings 0

Closing entry for 1997 Sales

Rev/(Exp) (30,000)

Interest and dividend revenue

15,000

Cost of goods sold

(2,100,000)

Salaries and wages

(650,000)

Other operating expenses

(230,000)

Bad debt expense

(17,200)

Depreciation expense

(30,000)

Interest expense

(87,700)

Net income (accrual basis)

180694588.doc created by T. Gordon 10/16/2013

Ref

Debit

Ref

Credit

Receipt/(Disb)

3,600,000

Gain/(loss) on sale of PP&E

Income taxes expense

89,800

Target

(180,200) 289,900

Page 33

Acct 592 – Spring 2005 7. Albion Altimeters Statement of Cash Flows

INFLOWS

OUTFLOWS

(Subtotals)

Operating Activities

Investing Activities

Financing Activities

Noncash Financing/Investing

CHANGE IN CASH

89,800

Totals

180694588.doc created by T. Gordon 10/16/2013

Page 34

Acct 592 – Spring 2005 Albion Altimeters Statement of Cash Flow For year ended 12-31-97 Cash provided by operations

Cash provided by investing activities

Cash provided by financing activities

180694588.doc created by T. Gordon 10/16/2013

Page 35

Acct 592 – Spring 2005

Albion Altimeters Statement of Cash Flow For year ended 12-31-97 Reconciling schedule

Notes:

180694588.doc created by T. Gordon 10/16/2013

Page 36

Acct 592 – Spring 2005

Acct 315 - Statement of Cash Flow Homework Problem # 8 Instructions: Prepare the statement of cash flow for Endicott Engines Inc. (attached) using the direct method. Show all your work on clearly labeled and well-organized worksheet (provided) or equivalent printout. Label your work and answers clearly. You must submit a worksheet if you want me to be able to follow your thought process (in case your answer is wrong). If the problem doesn’t “balance”, you may “plug” something (clearly labeled as a plug) and still obtain most of the available points. If you are using spreadsheet software, please explain your computations since I cannot tell what formulas you incorporated into the cells from looking at the printout. The Excel worksheet is available on the course web page: http://www.academic.uidaho.edu/Acct301. NOTE: For full credit, you must prepare the statement of cash flow in good form (direct method) with all necessary disclosures including a reconciling schedule and disclosures about noncash financing and investing activities. Endicott Engines Inc. Income Statement For year ending 12/31/02 Sales Earnings of affiliated companies (equity method) Gain/(loss) on sale of PP&E Realized gain/(loss) on investments Realized gain on sale of patent Interest and dividend revenue Total revenues Cost of goods sold Salaries and wages Other operating expenses Bad debt expense Depreciation & amortization expense Income taxes expense Net income

180694588.doc created by T. Gordon 10/16/2013

6,500,000 125,000 (30,000) 192,000 450,000 15,000 7,252,000 3,800,000 610,000 354,000 47,200 261,000 692,100 572,700

6,337,000 915,000

Page 37

Acct 592 – Spring 2005 Endicott Engines Inc. Additional information: a. b. c. d. e. f. g. h. i. j. k. l.

On February 19, EEI sold an internally developed patent for $500,000. On April 3, EEI issued $6,000,000 in bonds at face value. The semi-annual bonds have a coupon rate of 10% per annum. During the year, EEI disposed of various items of equipment with a total book value of $60,000 and original cost of $80,000. The amount received was $30,000 in cash. During the third quarter, shareholders holding 10,000 shares of the preferred stock converted them into common stock. The conversion ratio was 8 shares of common for each share of preferred. On July 20, EEI sold 25,000 shares of its common stock for $43 per share. By the end of the year, EEI had written off as uncollectible a total of $35,000 in accounts receivable. An existing factory with equipment was acquired during the year. The acquisition cost was allocated as follows: $750,000 to land, $4,000,000 to building and 600,000 to equipment. EEI acquired a parcel of land adjoining the new factory by giving the owner 10,000 shares of its common stock. At the date of the transaction, the market value of the stock was $45 per share. New equipment for the factory was obtained under a capital lease. The present value of the minimum lease payments was $722,000. During the year EEI purchased $900,000 in marketable securities and sold securities which had cost $600,000. The market value of the portfolio at the end of the year was $536,000. EEI owns 40% of a company that manufactures parts that EEI uses in its production process. EEI received $20,000 in dividends from this partially owned company during 2002. Dividends declared during the year totaled $100,000.

180694588.doc created by T. Gordon 10/16/2013

Page 38

Acct 592 – Spring 2005

Endicott Engines Inc. Balance Sheet Current Assets Cash Securities Available for Sale Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Operating Expenses Noncurrent Assets Investments (partially owned companies) Plant, property & equipment Accumulated Depreciation Intangible Assets TOTAL ASSETS Current Liabilities Accounts Payable Salaries Payable Income Taxes Payable Dividends Payable

12/31/02

12/31/01

1,308,200 536,000 2,145,000 (122,200) 1,165,000 63,000 5,095,000

1,500,000 300,000 2,000,000 (110,000) 975,000 50,000 4,715,000

2,605,000 17,142,000 (934,000) 93,000 24,001,000

2,500,000 10,700,000 (700,000) 150,000 17,365,000

1,050,000 43,000 24,000 85,000 1,202,000

800,000 18,000 35,000 60,000 913,000

11,000,000 (277,000) 142,000 749,000 570,000 12,184,000

5,000,000 (300,000) 90,000 323,000 3,000,000 8,113,000

1,000,000 2,150,000 2,575,000 27,000 4,863,000 10,615,000 24,001,000

2,000,000 1,000,000 1,200,000 91,000 4,048,000 8,339,000 17,365,000

Noncurrent Liabilities Bonds Payable Discount on Bonds Deferred Income Taxes Lease obligations Other long term liabilities Stockholder's Equity Convertible preferred, $100 par Common stock, $10 par Additional paid in capital Unrealized (gain)/loss investments Retained Earnings Total liabilities and equity

180694588.doc created by T. Gordon 10/16/2013

Page 39

Acct 592 – Spring 2005 Worksheet

Endicott Engines Inc. Year ending

Endicott Engines Inc. Cash Securities Available for Sale

12/31/01 Ref 1,500,000 300,000

Accounts Receivable

12/31/02 1,308,200 536,000

Target (191,800) 236,000

2,000,000

2,145,000

145,000

(110,000)

(122,200)

(12,200)

975,000

1,165,000

190,000

Prepaid Operating Expenses

50,000

63,000

13,000

Investments (equity method)

2,500,000

2,605,000

105,000

Plant, property & equipment

10,700,000

17,142,000

6,442,000

(700,000)

(934,000)

(234,000)

Intangible Assets

150,000

93,000

(57,000)

Accounts Payable

17,365,000 (800,000)

24,001,000 (1,050,000)

(250,000)

Salaries Payable

(18,000)

(43,000)

(25,000)

Income Taxes Payable

(35,000)

(24,000)

11,000

Dividends Payable

(60,000)

(85,000)

(25,000)

(5,000,000)

(11,000,000)

(6,000,000)

Premium/Discount on Bonds Payable

300,000

277,000

(23,000)

Deferred Income Taxes

(90,000)

(142,000)

(52,000)

(323,000)

(749,000)

(426,000)

Allowance for doubtful accounts Merchandise Inventory

Accumulated Depreciation

Bonds Payable

Lease obligations

180694588.doc Created by T. Gordon 10/16/2013

Debit

Year ending Ref

Credit 191,800

Page 40

Acct 592 – Spring 2005 Endicott Engines Inc. Other long term liabilities

12/31/01 Ref (3,000,000)

Convertible preferred, $100 par

(2,000,000)

(1,000,000)

Common stock, $10 par

(1,000,000)

(2,150,000) (1,150,000)

Additional paid in capital

(1,200,000)

(2,575,000) (1,375,000)

Unrealized (gain)/loss investments Retained Earnings 0 Closing entry for 2002: Sales

(815,000)

(17,365,000)

(24,001,000)

Rev/(Exp) 6,500,000

192,000

Realized gain on sale of patent

450,000

Interest and dividend revenue

15,000

Cost of goods sold

(3,800,000)

Salaries and wages

(610,000)

Other operating expenses

(354,000)

Receipt/(Disb)

(47,200) (254,000) (7,000)

Interest expense

(692,100)

Income taxes expense

(572,700) 915,000

Endicott Engines Inc. INFLOWS

OUTFLOW S

Operating Activities 180694588.doc Created by T. Gordon 10/16/2013

1,000,000

(4,863,000)

Realized gain/(loss) on investments

Statement of Cash Flows

Target 2,430,000

(4,048,000)

(30,000)

Net income (accrual basis)

12/31/02 (570,000)

64,000

Gain/(loss) on sale of PP&E

Amortization of intangible assets

Credit

(27,000)

125,000

Depreciation expense

Ref

(91,000)

Earnings of affiliated company (equity method)

Bad debt expense

Debit

Page 41

Acct 592 – Spring 2005

Investing Activities

180694588.doc Created by T. Gordon 10/16/2013

Page 42

Acct 592 – Spring 2005 Endicott Engines Inc. Financing Activities

Noncash Financing/Investing

CHANGE IN CASH Totals

180694588.doc Created by T. Gordon 10/16/2013

191,800

Page 43

Acct 592 – Spring 2005 Statement of Cash Flow Examples - Solutions Example 1 - completed worksheet Palouse Pottery

Year ending 12/31/96

Cash

15,000

Ref x

Debit

Credit

27,000

Accounts Receivable

40,000

Allowance for doubtful accounts

(3,000)

a

500

Merchandise Inventory

25,000

k

18,000

3,000

L

3,000

Prepaid Expenses

Ref

42,000

27,000

2,000 500

37,500

(2,500)

j

2,000

(4,500)

(1,500)

43,000

18,000

Plant, property & equipment

215,000

f

48,000

Accumulated Depreciation

(80,000)

b

9,000

m

6,000

3,000

10,000 17,000

236,000

21,000

11,000

(82,000)

(2,000)

215,000

(2,000)

Income Taxes Payable

(1,500)

Dividends Payable Long term liabilities Common stock, $1 par Retained Earnings

278,000

(23,000) (2,000)

Interest payable

0 (25,000)

p h

5,000

e

10,000

c

13,000

(215,000) Closing entry for

n o

8,000 7,000

q

4,000

c

13,000

500

(100,000) (61,500)

(31,000) (9,000) (5,500) (8,000) (15,000)

2,000

Gain/(loss) on sale of PP&E

(4,000)

b

4,000

Realized gain/(loss) - land

20,000

45,000

(145,000)

(45,000)

x

14,500

(63,000)

(1,500)

(278,000)

0 d

20,000

0

(35,000)

n

8,000

k

18,000

(45,000)

Salaries & other operating expenses Bad debt expense

(37,000)

o

7,000

L

3,000

(33,000)

Depreciation & amortization

(11,000)

j m

2,000

(2,500) (7,000)

q

4,000

Net income (accrual basis)

14,500

X

14,500

Statement of Cash Flows

0

11,000

Income taxes expense

0 p

500

X

11,000

11,000

Sold operational asset

b

4,000

Sold land

d

30,000

(3,000) (3,000)

(INFLOWS) X

11,000 Operating Cash

(OUTFLOW S) 11,000

Investing Activities

(14,000)

Purchased Plant, Property & Equipment

f

48,000

e

10,000

h

5,000

Financing Activities

30,000

Paid long-term debt Issued common stock

0

95,000

Cost of goods sold

Operating Activities

(8,000) 10,000

1997 Receipt/(Disb) i

Interest expense

500 (4,000)

g x

93,000

(2,000)

(8,000) (7,000)

(1,500)

1997 Rev/(Exp)

Sales

Target

i a

d b

Accounts Payable Salaries Payable

Year ending 12/31/97

g

45,000

Paid cash dividend Noncash Financing/Investing CHANGE IN CASH Totals

180694588.doc Created by T. Gordon 10/16/2013

X 276,500

27,000

27,000

276,500

Page 44

Acct 592 – Spring 2005

Solutions for Example Problems Example 1 for Acct 301 Solution: Palouse Pottery Statement of Cash Flows For year ended

31-Dec-97

Cash provided by operations Cash collected from customers Interest & dividends received Cash paid for merchandise Cash paid to employees Other operating disbursements Interest paid Income taxes paid

Inflows 95,000 0

Subtotals

95,000

Cash provided by investing activities Purchase plant, property & equipment Sale of plant, property & equipment Sale of land Subtotals

4,000 30,000 34,000

Cash provided by financing activities Dividends paid Long-term debt retired Common stock issued Subtotals

45,000 45,000

Outflows

(45,000) (20,000) (13,000) (3,000) (3,000) (84,000)

11,000

(48,000) (48,000)

(14,000)

(5,000) (10,000) (15,000)

Change in cash Beginning balance - Cash Ending balance - Cash

Schedule to reconcile net income to cash Net Income Depreciation & amortization Realized gains/losses PP&E Realized gain/loss - land sale Change in working capital accounts: Net accounts receivable Merchandise Inventory Prepaid Expenses Accounts Payable Salaries Payable Income Taxes Payable Interest Payable Cash provided by operations:

Net

30,000 27,000 15,000 42,000

provided by operations 14,500 11,000 4,000 (20,000) 4,000 (18,000) (3,000) 8,000 7,000 4,000 (500) 11,000

Non-cash financing and investing activities None

180694588.doc Created by T. Gordon 10/16/2013

Page 45

Acct 592 – Spring 2005 Example 1 for Acct 301 – INDIRECT METHOD SOLUTION Statement of Cash Flow Worksheet

Palouse Pottery Cash Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Expenses Plant, property & equipment Accumulated Depreciation Accounts Payable Salaries Payable Interest payable Income Taxes Payable Dividends Payable Long term liabilities Common stock, $1 par Retained Earnings

Statement of Cash Flows Operating Activities Net income Add back loss on sale of equipment Minus gain on sale of land depreciation

Year ending 12/31/96 Ref 15,000 x 40,000 (3,000) 25,000 3,000 215,000 f (80,000) b 215,000 (23,000) (2,000) (2,000) (1,500) 0 c (25,000) e (100,000) (61,500) c (215,000)

Financing Activities Dividends paid Payment on LT debt Issued common stock Noncash Financing/Investing

18,000 3,000 48,000 b,d 9,000

27,000 11,000 8,000 7,000

500 5,000 c 10,000 g 13,000 h

4,000 13,000 45,000 14,500

(31,000) (9,000) (1,500) (5,500) (8,000) (15,000) (145,000) (63,000) (278,000)

(OUTFLOW S) 11,000

h b

14,500 4,000 d

20,000

11,000

4,000 18,000 3,000 8,000 7,000 500 4,000

b d

g

4,000 30,000 f

48,000

c e

5,000 10,000

X

27,000

45,000

CHANGE IN CASH Totals 265,000

180694588.doc Created by T. Gordon 10/16/2013

Credit 2,500 1,500

(INFLOWS)

Change in working capital accounts: A/R (net) Inventory Prepaid expenses A/P Salaries payable Interest payable Income taxes payable Investing Activities Sold equipment Sold land Purchase PP&E

Debit Ref 27,000

Year ending 12/31/97 42,000 37,500 (4,500) 43,000 6,000 236,000 (82,000) 278,000

265,000

Page 46

Target 27,000 (2,500) (1,500) 18,000 3,000 21,000 (2,000) (8,000) (7,000) 500 (4,000) (8,000) 10,000 (45,000) (1,500) 0

Acct 592 – Spring 2005 Example 2 for Acct 301 - S97 Statement of Cash Flow Worksheet Moscow Moving & Storage

Year ending 12/31/96 Ref

Cash

15,000

Accounts Receivable Allowance for doubtful accounts

30,000 (1,500)

Merchandise Inventory Prepaid Expenses

10,000 4,500

k

7,000

39,000 9,000

(10,000) (3,000)

n

2,000

0 (30,000)

e

20,000

Interest payable Long term liabilities

Bad debt expense Depreciation & amortization Interest expense Income taxes expense Net income (accrual basis)

500

45,000

Accounts Payable Salaries Payable

Sales Gain/(loss) on sale of PP&E Cost of goods sold Salaries & other operating expenses

a

f b

220,100 (20,000) 258,100

Closing entry for

Ref

g Plant, property & equipment Accumulated Depreciation

Common stock, $1 par Retained Earnings

Debit

(100,000) (115,100) (258,100)

c

5,000

Year ending 12/31/97

Credit

x j a h

10,000 1,000 500 1,000

L

4,000

b i

(10,000)

28,500 (2,000)

(1,500) (500)

17,000 500

7,000 (4,000)

15,000 5,000

289,100 (16,000) 322,100

69,000 4,000

m

3,000

(13,000) (1,000)

(3,000) 2,000

o

1,000

(1,000) (10,000)

(1,000) 20,000

g

45,000

d x

36,000 6,000

(181,000) (116,100) (322,100)

(81,000) (1,000) 0

1997

1997

Rev/(Exp)

Receipt/(Disb)

80,000 (2,000) (35,000) (26,000)

j b m L

1,000 2,000 3,000 4,000

(1,000) (5,000) (2,000) (3,000) 6,000

h i o

1,000 5,000 1,000

x

Statement of Cash Flows Operating Activities

6,000

k n

x

(INFLOWS)

x

14,000

b

4,000

Target

5,000

7,000 2,000

14,000

81,000 0 (39,000) (24,000) 0 0 (1,000) (3,000) 14,000 Operating Cash

(OUTFLOWS)

14,000

Investing Activities Sold operational assets Purchased operational assets

(35,000) f

39,000

c

5,000

e

20,000 45,000

Financing Activities Paid cash dividend Issued common stock

11,000 d

36,000

Paid long term debt Noncash Financing/Investing Acquired land in exchange for stock

g

45,000

g

CHANGE IN CASH Totals

x

10,000 259,500

x

0 Additional Information a. Wrote off $500 accounts receivable as uncollectible b. Sold operational assets for $4,000 cash (cost $15,000, acc'd depreciation $9,000) c. Declared and paid a cash dividend, $5,000 180694588.doc Created by T. Gordon 10/16/2013

d. e. f. g.

(10,000) 259,500 0

0 0 Issued common stock for $36,000 cash Paid a $20,000 long-term note installment Purchased operational assets, $39,000 cash Acquired land in exchange for 1000 shares worth $45 each Page 47

Acct 592 – Spring 2005 Example 2 for Acct 301 - Solution: Moscow Moving & Storage Statement of Cash Flows For year ended

31-Dec-97 Inflows

Cash provided by operations Cash collected from customers Interest & dividends received Cash paid for merchandise Cash paid to employees Other operating disbursements Interest paid Income taxes paid

Outflows

81,000 0

Subtotals Cash provided by investing activities Purchase plant, property & equipment Sale of plant, property & equipment Sale of land

81,000

(39,000) (14,000) (10,000) (1,000) (3,000) (67,000)

14,000

(39,000) 4,000 Subtotals

Cash provided by financing activities Dividends paid Long-term debt retired Common stock issued

4,000

(39,000)

(35,000)

(5,000) (20,000) Subtotals

36,000 36,000

(25,000)

Change in cash Beginning balance – Cash Ending balance – Cash

11,000 (10,000) 15,000 5,000

Schedule to reconcile net income to cash provided by operations Net Income 6,000 Depreciation & amortization 5,000 Realized gains/losses PP&E 2,000 Change in working capital accounts: Net accounts receivable 2,000 Merchandise Inventory (7,000) Prepaid Expenses 4,000 Accounts Payable 3,000 Salaries Payable (2,000) Interest Payable 1,000 Cash provided by operations: 14,000 Non-cash financing and investing activities Acquired land in exchange for common stock

180694588.doc Created by T. Gordon 10/16/2013

Net

Page 48

Acct 592 – Spring 2005 Example 3 – workpaper solution Avery Slings & Arrows

Year ending 12/31/03 2,850,000 180,000 (80,000) 2,000,000 (100,000) 900,000 50,000 2,000,000

0 Cash Securities Available for Sale Allowance to adjust to market Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Expenses Investments in affiliated companies (equity method) Land, building & equipment 17,800,000

Ref x c r s o

Debit

Ref

g

273,000 J 107,000 92,000 o 33,000 o s s 150,000 g

a

2,767,000 d

Accumulated Depreciation Intangible Assets

g (1,800,000) d 73,000 I

648,000 376,000 p 500,000 p

Total assets

23,873,000

Accounts Payable Salaries Payable Interest payable Income Taxes Payable Dividends Payable Bonds Payable Premium/Discount on Bonds Payable Convertible Bonds Payable Lease obligation Asset retirement obligation Deferred Income Taxes Other long term liabilities Convertible preferred, $100 par Common stock, $10 par

(650,000) (21,000) (55,000) (32,000) (60,000) (4,000,000) (656,000)

Additional paid in capital common

(1,600,000)

Retained Earnings

t t

303,000 3,000

e

t t 135,000 e L 14,000

u

(3,000,000) f (1,825,000) v (250,000) (75,000) (2,590,000) y 0 (3,000,000)

80,000 10,000 n 0 k (6,149,000) e (23,873,000 )

180694588.doc Created by T. Gordon 10/16/2013

33,000 45,000 298,000 46,000 29,000

500,000 20,715,000

757,000 (2,181,000) 5,000 568,000

Target (589,000) 51,000 107,000 59,000 (12,000) (298,000) (46,000) 121,000 2,915,000

(381,000) 495,000

26,295,000

1,500,000 365,000 g q w 2,000,000

101,000 13,000 203,000 3,000,000

(347,000) 303,000 (18,000) 3,000 (156,000) (101,000) (45,000) (13,000) (128,000) (68,000) (7,000,000) (3,000,000) (642,000) 14,000

b f k

(1,500,000) 1,500,000 648,000 (2,108,000) (283,000) 25,000 (275,000) (25,000) 47,000 (122,000) (47,000) (590,000) 2,000,000 0 0 250,000 (5,125,000) (2,125,000) 375,000 1,500,000

b

800,000 (3,525,000) (1,925,000)

f Unrealized (gain)/loss AFS invest Treasury stock (at cost) Other paid in capital

Credit 589,000 222,000

Year ending 12/30/04 2,261,000 231,000 27,000 2,059,000 (112,000) 602,000 4,000 2,121,000

r 38,000 m m 1,500,000 203,000 X

1,125,000 107,000 10,000 13,000

(27,000) 38,000 (13,000)

266,000 (4,712,000) (26,295,000 )

Page 49

(107,000) 28,000 (13,000) 1,437,000

Acct 592 – Spring 2005 Avery Slings & Arrows Closing entry for

Sales Earnings of affiliates (equity method) Gain/(loss) on sale of PP&E Realized gain/(loss) on investments Interest and dividend revenue Cost of goods sold Salaries and wages Other operating expenses Bad debt expense Depreciation expense Amortization of intangibles Accretion expense Interest expense

2004 Rev/(Exp)

Ref

Debits

6,600,000 150,000

s g

(65,000) d 53,000 15,000 (3,490,000) (632,000) (421,000) (45,000) (757,000) (5,000) (25,000) (935,000)

Income taxes expense Net income (accrual basis)

g s

J

s o p p q t w (177,000) t

29,000 298,000 t t 46,000 45,000 757,000 5,000 25,000 101,000 u 47,000 13,000

266,000 X

266,000 X

Cash provided by operations:

X

Cash provided by operations off by

Credits

92,000 150,000

2004 Receipt/ (Disb) 6,508,000 0

53,000

0 0

65,000

INFLOWS

Reconciling schedule: Net income Depreciation Amortization & impairment of intangibles Accretion expense Bond premiums/discounts Realized gains/losses PP&E Realized gain/loss investments Equity method investments Deferred income taxes Change in working capital: Net accounts receivable Merchandise Inventory Prepaid Expenses Accounts Payable Salaries Payable Interest payable Income Taxes Payable

Ref

1,082,000

44,000 303,000 (3,495,000) 3,000 (635,000) (375,000) 0 0 0 0 14,000 (848,000) (117,000) 1,082,000

1,082,000

OUTFLOW S 1,082,000

266,000 757,000 5,000 25,000 (14,000) 65,000 (53,000) (121,000) 47,000 (47,000) 298,000 46,000 (303,000) (3,000) 101,000 13,000

1,082,000 0

180694588.doc Created by T. Gordon 10/16/2013

Page 50

Acct 592 – Spring 2005

Avery Slings & Arrows Investing Activities Purchased PP&E Purchased marketable securities Sold equipment Purchased patent Sold investments

Financing Activities Issued common stock Paid dividends Issued bonds Sold treasury stock Purchased treasury stock Payments on capital leases Payments on long-term debt Noncash Financing/Investing Bonds converted into stock Capital lease Stock dividend CHANGE IN CASH Totals

Ref

Inflows

Outflows

a c

2,767,000 273,000

(3,206,000)

d

59,000 I

J

500,000

275,000

1,535,000 b

1,050,000

L m

3,000,000 23,000

f h K

e

135,000

n v y

38,000 365,000 2,000,000

1,500,000 f 648,000

1,500,000 648,000

589,000 x 20,930,000

20,930,000

ok

180694588.doc Created by T. Gordon 10/16/2013

Ref

0

(589,000) Change in Cash 0 half 0 double 0 divide by 9

Page 51

Acct 592 – Spring 2005

Solution Example 4- Acct 315 Worksheet

Year ending

Wenatchee Whirlpool World

Year ending

12/31/95 Ref

Cash

2,000,000

Securities Available for Sale (at market)

150,000

Accounts Receivable

X I

Debit

875,000

(110,000)

f

28,000

875,000

p

270,000

Prepaid Operating Expenses

62,000

p

22,000

Investments (equity method)

3,000,000

l

115,000

h

800,000

Plant, property & equipment

10,800,000

g

(600,000)

c

Merchandise Inventory

Accumulated Depreciation Intangible Assets

Credit

12/31/96

837,600

1,900,000

Allowance for doubtful accounts

Ref

2,837,600

837,600

o I

51,000 584,000

390,000

240,000

p f

120,000 28,000

1,752,000

(148,000)

m

38,500

(120,500)

(10,500)

1,145,000

270,000

84,000

22,000

j

18,000

3,097,000

97,000

4,900,000

c

80,000

16,420,000

5,620,000

15,000

n

244,000

(829,000)

(229,000)

n a

6,500 50,000

71,500

(56,500)

128,000 18,205,000

Accounts Payable

Target

24,847,600

(750,000)

p

130,000

(880,000)

(130,000)

Salaries Payable

(15,000)

p

5,000

(20,000)

(5,000)

Income Taxes Payable

(27,000)

q

13,600

(13,400)

13,600

Dividends Payable

(60,000)

k

75,000

(35,000)

25,000

Current portion long term debt

k

50,000

(21,000)

s

8,000

(29,000)

(8,000)

(5,000,000)

b

5,000,000

(10,000,000)

(5,000,000)

Premium/Discount on Bonds Payable

270,000

r

23,000

247,000

(23,000)

Deferred Income Taxes

(88,000)

q

92,000

(180,000)

(92,000)

(562,000)

2,438,000

Bonds Payable

Other long term liabilities

(3,000,000) 12/31/95

Convertible preferred, $100 par

(2,000,000)

Common stock, $10 par

ref d

2,430,000 8,000 Debit

(1,200,000)

Unrealized (gain)/loss investments Retained Earnings 0

ref

Credit

12/31/96

1,500,000

(1,500,000)

Additional paid in capital

180694588.doc Created by T. Gordon 10/16/2013

s s

(78,000)

o

51,000

(4,736,000)

k

50,000

Target

(500,000)

1,500,000

(3,100,000)

(1,600,000)

(2,750,000)

h e

200,000 500,000

d

900,000

h e

600,000 1,550,000

d

600,000

(3,950,000) (27,000)

51,000

X

1,112,200

(5,798,200)

(1,062,200)

(18,205,000)

(24,847,600)

Page 52

Acct 592 – Spring 2005 Wenatchee Whirlpool World Closing entry for

1996

1996

Rev/(Exp) Sales

6,200,000

Receipt/(Disb) p

120,000

6,320,000

Earnings of affiliated company (equity method) Gain/(loss) on sale of PP&E

115,000

Realized gain/(loss) on investments

108,000

I

108,000

0

Realized gain on sale of patent

950,000

a

950,000

0

Interest and dividend revenue

13,000

j

18,000

Cost of goods sold

(3,600,000)

p

130,000

Salaries and wages

(590,000)

p

5,000

Other operating expenses

(345,000) (38,500)

m

38,500

0

(244,000)

n

244,000

0

(6,500)

n

6,500

0

Interest expense

(669,400)

r

23,000

Income taxes expense

(740,400)

q

92,000

q

1,112,200

X

1,112,200

X

Bad debt expense Depreciation expense Amortization of intangible assets

Net income (accrual basis)

(40,000)

l c

INFLOWS

Operating Activities

X

0

40,000

0

31,000 p

270,000

(3,740,000) (585,000)

p

Statement of Cash Flows

115,000

22,000

(367,000)

(646,400) 13,600

(662,000)

350,600 OUTFLOWS

350,600 (Subtotals)

350,600

Reconciling schedule: Net Income Depreciation & amortization

1,112,200 250,500

Bond premiums/discounts

23,000

Realized gains/losses PP&E

40,000

Realized gain/loss investments

(108,000)

Gain on sale of patent

(950,000)

Undistributed Earnings of Investees Deferred income taxes

(97,000) 92,000

Change in working capital accounts: Net accounts receivable

158,500

Merchandise Inventory

(270,000)

Prepaid Operating Expenses

(22,000)

Accounts Payable

130,000

Salaries Payable

5,000

Income Taxes Payable

(13,600)

Cash provided by operations:

350,600

180694588.doc Created by T. Gordon 10/16/2013

Page 53

Acct 592 – Spring 2005

Investing Activities Sale of patent

a

1,000,000

Sale of equipment

c

25,000

Purchase factory

g

4,900,000

I

875,000

Dividends paid

k

75,000

Long-term debt repaid

s

2,430,000

Purchase investment securities Sold investment securities

I

692,000

Issued bonds

b

5,000,000

Issued common stock

e

2,050,000

Financing Activities

Noncash Financing/Investing Preferred converted to common stock

d

1,500,000

d

1,500,000

Swap common stock for land

h

800,000

h

800,000

X

837,600

CHANGE IN CASH Totals

180694588.doc Created by T. Gordon 10/16/2013

25,237,000

25,237,000

Page 54

Acct 592 – Spring 2005 Solution

Working through the additional items of information: a.

On February 25, WWW sold an internally developed patent for $1,000,000. The patent was carried on the books at unamortized legal fees amounting to $50,000 at date of sale.

Cash [Investing - inflow] Intangible Assets Realized gain on sale of patent b.

80,000

1,500,000 900,000 600,000

2,050,000 500,000 1,550,000

By the end of the year, WWW had written off as uncollectible a total of $28,000 in accounts receivable.

Allowance for doubtful accounts Accounts receivable g.

25,000 15,000 40,000

On July 20, WWW sold 50,000 shares of its common stock for $41 per share. The proceeds would be $2,050,000 (41 * 50,000) and the par value portion would be $500,000 with the rest as additional paid in capital.

Cash [Financing - inflow] Common stock, $10 par Additional paid in capital f.

5,000,000

During the third quarter, shareholders holding 15,000 shares of the preferred stock converted them into common stock. The conversion ratio was 6 shares of common for each share of preferred. Therefore 90,000 shares of common stock would be issues (6 * 15,000) with a par value of $900,000 ($10 par each). The book value of the preferred was 1,500,000. Therefore, additional paid in capital to balance the journal entry would be 600,000.

Convertible Preferred Stock, $100 par Common stock, $10 par Additional paid-in capital e.

5,000,000

During the year, WWW disposed of various items of equipment with a total book value of $65,000 and original cost of $80,000. The amount received was $25,000 in cash. Accumulated depreciation would be $15,000 (80,000 - 65,000)

Cash [Investing - inflow] Accumulated depreciation Loss on sale of plant, property & equipment Plant, property and equipment d.

50,000 950,000

On March 31, WWW issued $5,000,000 in bonds at face value. The semi-annual bonds have a coupon rate of 10% per annum.

Cash [Financing - inflow] Bonds payable c.

1,000,000

28,000 28,000

An existing factory with equipment was acquired during the year. The acquisition cost was allocated as follows: $772,000 to land, $3,450,000 to building and 678,000 to equipment. This totals to $4,900,000.

Plant, property and equipment Cash [Investing outflow]

180694588.doc Created by T. Gordon 10/16/2013

4,900,000 4,900,000

Page 55

Acct 592 – Spring 2005 h.

WWW acquired a parcel of land adjoining the new factory by giving the owner 20,000 shares of its common stock. At the date of the transaction, the market value of the stock was $40 per share. The value of the land is $800,000 (20,000 * 40).

Plant, property and equipment Common stock, $10 par Additional paid in capital i.

875,000 875,000 692,000 584,000 108,000

WWW owns 30% of a company which manufactures parts that WWW uses in its production process. WWW received $18,000 in dividends from this partially owned company during 1996. Dividends received from equity-method investments reduce the investment account and do NOT appear on the income statement.

Cash [Operating - dividends received] Investments (partially-owned companies) k.

200,000 600,000

During the year WWW purchased $875,000 in marketable securities and sold securities which had cost $584,000. The market value of the portfolio at the end of the year was $390,000. From the income statement, the gain on sale was 108,000. Therefore, the cash received from the sale of securities was 584+108 = $692,000

Investments - Securities available for sale Cash [Investing outflow] Cash [Investing inflow] Investments - Securities available for sale Gain on sale of investments j.

800,000

18,000 18,000

Dividends declared during the year totaled $50,000. Dividends declared reduce retained earnings and increase dividends payable. The balancing number in dividends payable (if this account exists) will be the dividends paid. If there is no dividends payable account, then the dividends declared = the dividends paid.

Retained earnings Dividends payable Dividends payable Cash [Financing - outflow]

50,000 50,000 75,000 75,000

Starting through the income statement, looking for noncash items: l.

No deposit was made for share of earnings of partially owned companies. Therefore, this account needs to be zeroed out by re-constructing the entry that recorded the share of earnings.

Investments in partially owned company Earnings of partially-owned company

115,000 115,000

m. No check was written for bad debt expense. Therefore, this account needs to be zeroed out by re-constructing the entry that recorded bad debt expense for the year (the credit is always to allowance for doubtful accounts. Bad debt expense Allowance for doubtful accounts

180694588.doc Created by T. Gordon 10/16/2013

38,500 38,500

Page 56

Acct 592 – Spring 2005 n.

No checks are written to record depreciation expense and amortization of intangibles. Therefore, these accounts need to be zeroed out by reconstructing the entry that recorded the expenses.

Depreciation expense Amortization of intangible assets Accumulated depreciation Intangible assets

244,000 6,500 244,000 6,500

Starting through the balance sheet to investigate accounts not yet balanced: o.

Securities available for sale (at market) doesn’t balance by $51,000. However, this amount appears in the owners’ equity section as the change in Unrealized (gain)/loss on investments. Therefore, this amount must have been the adjusting entry for the “allowance for change in value” account.

Unrealized gain/loss on investments Investments in AFS securities (allowance) p.

120,000 120,000 270,000 270,000 22,000 22,000 130,000 130,000 5,000 5,000

Income tax expense is affected by two accounts on the balance sheet - income taxes payable and deferred income taxes.

Income taxes payable Income tax expense Deferred income taxes Income tax expense r.

51,000

The remaining difference in accounts receivable ($120,000) is the adjustment to sales to get from accrual basis to cash basis. The difference in Merchandise Inventory is an adjustment to cost of goods sold. The difference in prepaid operating expenses is an adjustment to other operating expenses. The change in accounts payable would mostly be related to cost of goods sold. The change in salaries payable affects salaries and wages expense.

Sales Accounts receivable Merchandise inventory Cost of goods sold Prepaid operating expenses Other operating expenses Accounts payable Cost of goods sold Salaries payable Salaries and wages q.

51,000

13,600 13,600 92,000 92,000

Amortization of premiums and discounts on bonds payable impacts interest expense.

180694588.doc Created by T. Gordon 10/16/2013

Page 57

Acct 592 – Spring 2005 Interest expense Discount on bonds payable s.

23,000 23,000

Long-term debt is presented in two numbers on balance sheet - current and noncurrent. These accounts need to be combined to find out how much was borrowed or repaid during the year. Take the change in one account to the other. The remaining “amount to balance” will be the cash inflow or outflow.

Other long-term debt Current portion of long-term debt

8,000 8,000

After this entry, the number necessary to balance other long-term debt is $2,430,000 which must be the amount of long-term debt repaid during the year. Other long-term debt Cash [Financing - outflow]

180694588.doc Created by T. Gordon 10/16/2013

2,430,000 2,430,000

Page 58

Acct 592 – Spring 2005 Example 4 - Acct 301 Solution Wenatchee Whirlpool World Statement of Cash Flows For year ended 12/31/96 Inflows Cash provided by operations Cash collected from customers Interest & dividends received Cash paid for merchandise

Outflows

6,320,000 31,000

(3,740,000 ) Cash paid to employees (585,000) Other operating disbursements (367,000) Interest paid (646,400) Income taxes paid (662,000) Subtotals 6,351,000 (6,000,400 ) Cash provided by investing activities Purchase plant, property & equipment

Net

350,600

(4,900,000 )

Sale of plant, property & equipment 25,000 Sale of patent 1,000,000 Marketable securities purchased (875,000) Marketable securities sold 692,000 Subtotals 1,717,000 (5,775,000 (4,058,000 ) ) Cash provided by financing activities Dividends paid Long-term debt retired Bonds issued Common stock issued

(75,000) (2,430,000 )

5,000,000 2,050,000 Subtotals 7,050,000 (2,505,000 4,545,000 )

Change in cash Beginning balance - Cash Ending balance - Cash

837,600 2,000,000 2,837,600

Non-cash financing and investing activities Preferred stock converted to common 1,500,000

180694588.doc Created by T. Gordon 10/16/2013

Page 59

Acct 592 – Spring 2005 Land obtained by issue of common stock 800,000

180694588.doc Created by T. Gordon 10/16/2013

Page 60

Acct 592 – Spring 2005

Example 3 - Acct 301 Wenatchee Whirlpool World For year ended

Solution 12/31/96

Schedule to reconcile net income to cash provided by operations Net Income 1,112,200 Depreciation & amortization 250,500 Bond premiums/discounts 23,000 Realized gains/losses PP&E 40,000 Realized gain/loss investments (108,000) Gain on sale of patent (950,000) Undistributed Earnings of Affiliates (97,000) * Deferred income taxes 92,000 Change in working capital accounts: Net accounts receivable 158,500 ** Merchandise Inventory (270,000) Prepaid Operating Expenses (22,000) Accounts Payable 130,000 Salaries Payable 5,000 Income Taxes Payable (13,600) Cash provided by operations: 350,600 The following notes are explanations and not part of a formal statement of cash flow * Earnings of affiliates (equity method) Dividends received (equity method affiliates)

(115,000) 18,000 (97,000)

** This is the easiest way to handle bad debts: just enter change in NET A/R: Change in Accounts 148,000 Receivable Change in Allowance for Doubtful 10,500 Accounts 158,500 This is the more difficult alternate: Adjustment to sales (to get cash collected from 120,000 customers) Bad debt expense 38,500 158,500

180694588.doc Created by T. Gordon 10/16/2013

Page 61

Acct 592 – Spring 2005 What does not work is to include bad debt expense + change in Accounts Receivable and change in Allowance!

180694588.doc Created by T. Gordon 10/16/2013

Page 62

Acct 592 – Spring 2005

1. Homework Assignment Ulliman Company

Solution

Year ending 0 01/01/99 Ref Cash 1,400 x Accounts receivable (net) 2,800 Marketable securities (at cost) 1,700 j Allowance for change in value 500 j Merchandise Inventory 8,100 Prepaid Expenses 1,300 N Investments (long-term) 7,000 Land 15,000 Buildings and equipment 32,000 g Accumulated depreciation (16,000) f Total assets 53,800 Accounts Payable Income Taxes Payable Wages payable Interest payable 12% bonds payable Premium/Discount on Bonds Payable Notes payable (long term) 10% Convertible bonds Deferred Income Taxes Convertible preferred, $100 par Common stock, $10 par Additional paid in capital Unrealized (gain)/loss investments Retained Earnings Total liab & equity Closing entry for Sales Other revenue Gain/(loss) on sale of PP&E Realized gain/(loss) on investments Interest and dividend revenue Cost of goods sold Salaries & other operating expenses Other operating expense Depreciation & amortization Interest expense Income taxes expense Net income (accrual basis)

(3,800) (2,400) (1,100) 0 0 0 (3,500) (9,000) (800) 0 (14,000) (8,700) (500) (10,000) (53,800)

q

h e c

b

Worksheet Year ending Ref Credit 12/31/99 Target 1,000 1,000 2,400 (110) L 110 2,690 1,300 1,300 3,000 300 300 800 (190) M 190 7,910 410 410 1,710 (1,600) d 1,600 5,400 0 15,000 14,200 16,200 f 2,000 46,200 (400) 1,700 k 2,100 (16,400) 68,710

Debit

O p

350 104

r h 300 s 3,500 9,000 i

400 10,000 10

(4,150) (2,504) (650) (400) (10,000) 290 0 0 (1,196) 0 (21,500) (13,700) (800) (14,100) (68,710)

450

c&e c&e j 700 XX

396 7,500 5,000 300 4,800

ok

ok

1999 Rev/(Exp) 39,930 0 (200) 700 820 (19,890) (11,000) (1,000) (2,100) (410) (2,050) 4,800

1999 Receipt/(Disb) 40,040 0 0 0 820 (19,350) (11,450) (1,410) 0 0 (1,550) 7,100

180694588.doc Created by T. Gordon 10/16/2013

L

110

f

200

m&o

k r&s i&p XX

d

700

q N

450 410

2,100 410 500 4,800 xx

7,100

540

(350) (104) 450 (400) (10,000) 290 3,500 9,000 (396) 0 (7,500) (5,000) (300) (4,100)

Page 63

Acct 592 – Spring 2005 Ulliman Company Statement of Cash Flows Operating Activities Reconciliation Schedule: Net Income Loss on sale of equipment Gain on sale of investments Depreciation expense Bond discount amortization Deferred income taxes Change in WC accounts: Accounts receivable (net) Merchandise Inventory Prepaid Expenses Accounts Payable Income Taxes Payable Wages payable Interest payable

Investing Activities Investments sold sold equipment Purchased equipment Purchase mkt securities

xx

4,800 200 (700) 2,100 10 396

7,100

110 190 (410) 350 104 (450) 400 7,100

(15,100) d f

h

Noncash Financing/Investing LT debt retired by issue of common stock conversion of bonds to stock

e c

180694588.doc Created by T. Gordon 10/16/2013

OUTFLOWS Subtotals

f d k s i

Financing Activities Dividends paid Issued bonds at a discount

CHANGE IN CASH Totals

INFLOWS 7,100

2,300 100 g j

16,200 1,300

b

700

x

1,000 62,720

9,000 9,700

62,720

1,000

Page 64

Acct 592 – Spring 2005

Ulliman Company Statement of Cash Flows For year ended December 31, 1999 Cash flows from operating activities Collections from customers Payments to suppliers Payments to employees Other operating payments Income taxes paid Dividends collected Cash provided by operations

40,040 (19,350) (11,450) (1,410) (1,550) 820 7,100

Cash flows from investing activities Purchase of marketable securities Proceeds from sale of long-term investments Disbursements to acquire equipment Proceeds from sale of equipment Cash used by investing activities

(1,300) 2,300 (16,200) 100 (15,100)

Cash flows from financing activities Proceeds from issuance of bonds Payment of dividends Cash provided by financing activities

9,700 (700) 9,000

Net increase in cash Beginning balance in cash Cash balance at 12-31-97

1,000 1,400 2,400

Noncash investing and financing activities LT debt retired by issue of common stock conversion of bonds to stock

3,500 9,000

Reconcilation of net income to cash provided by operations Net income 4,800 Loss on sale of equipment 200 Gain on sale of investments (700) Depreciation expense 2,100 Bond discount amortization 10 Deferred income taxes 396 Change in WC accounts: Accounts receivable (net) 110 Merchandise Inventory 190 Prepaid Expenses (410) Accounts Payable 350 Income Taxes Payable 104 Wages payable (450) Interest payable 400 7,100

180694588.doc Created by T. Gordon 10/16/2013

Page 65

Acct 592 – Spring 2005

2. Homework Assignment Driskoll Company Cash Accounts receivable (net) Inventories Prepaid Expenses Investments (long-term) Land Buildings Acc'd depreciation - Bldg Equipment Acc'd depreciation - Equip Patents

Accounts Payable Interest payable Wages payable Bonds payable Discount on bonds Common stock, $10 par Additional paid in capital Unrealized (gain)/loss investments Retained Earnings

Closing entry for Sales Gain/(loss) on exchange of assets Realized gain/(loss) on investments Interest and dividend revenue Cost of goods sold Salaries & other operating expenses Other operating expense Depreciation - buildings Depreciation - equipment Patent amortization Interest expense Income taxes expense Extraordinary loss (net of taxes) Net income (accrual basis)

Solution Year ending 12/31/99 Ref 2,700 x 5,900 i 15,300 j 1,400 8,300 16,300 d 68,700 (35,000) c 29,600 (14,200) d 8,700 f 107,700 (8,900) (630) (2,500) (23,000) 0 (22,000) (15,320) 0 (35,350) (107,700) ok 1999 Rev/(Exp) 49,550 1,300 (200) 790 (23,800) (16,510) (1,100) (2,700) (3,100) (815) (1,715) (500) (2,600) (1,400)

180694588.doc Created by T. Gordon 10/16/2013

m a b

p

Debit

Worksheet Year ending Ref Credit 12/31/99 Target 820 820 3,520 315 315 6,215 230 230 15,530 (400) k 400 1,000 (1,000) e 1,000 7,300 2,700 2,700 19,000 (8,000) c 8,000 60,700 500 3,200 g 2,700 (34,500) (4,000) d 4,000 25,600 (500) 2,600 g 3,100 (14,700) 485 1,300 h 815 9,185 98,850 L

295

n 14,000 b 780 o f f

100 8,000 65 650 650

(9,195) (300) (2,600) (17,000) 715 (22,650) (15,970) 0 (31,850) (98,850)

330

2,100 xx

(1,400) ok

i d

315 1,300

L n k g g h o

295 j 100 400 2,700 3,100 815 65 m

230

c xx

2,600 (1,400) xx

e

200

330

6,700

1999 Receipt/(Disb) 49,235 0 0 790 (23,735) (16,410) (700) 0 0 0 (1,980) (500) 0 6,700

Page 66

(295) 330 (100) 6,000 715 (650) (650) 0 3,500

Acct 592 – Spring 2005 Driskoll Company Statement of Cash Flows Operating Activities Reconciliation Schedule: Net income Depreciation amortization Extraordinary loss (net of taxes) Gain/(loss) on exchange of assets Realized gain/(loss) on investments Amort of Bond Discount change in WC accounts: Accounts receivable (net) Inventories Prepaid Expenses Accounts Payable Interest payable Wages payable

Investing Activities Proceeds from insurance company Sale of long-term investment

Financing Activities Retired bonds payable Proceeds of bond issue dividends paid

Noncash Financing/Investing Exchanged equipment for land Exchanged stock for patent

CHANGE IN CASH Totals

180694588.doc Created by T. Gordon 10/16/2013

xx

INFLOWS 6,700

OUTFLOWS Subtotals

6,700

(1,400) 5,800 g 815 h 2,600 (1,300) 200 65 o

(315) (230) 400 295 (330) 100 6,700

i j k L m n

3,000 c e

2,200 800

(8,880) b

a

14,000

p

2,100

x

820 54,170

7,220

d f

54,170

820

Page 67

Acct 592 – Spring 2005

Driskoll Company Statement of Cash Flows For year ended December 31, 1998 Cash flows from operating activities Collections from customers Payments to suppliers Payments to employees Other operating payments Income taxes paid Interest paid Dividends collected Cash provided by operations

49,235 (23,735) (16,410) (700) (500) (1,980) 790 6,700

Cash flows from investing activities Proceeds from insurance company Proceeds from sale of long-term investments Cash provided by investing activities

2,200 800 3,000

Cash flows from financing activities Proceeds from issuance of bonds Retire bonds payable Payment of dividends Cash used by financing activities

7,220 (14,000) (2,100) (8,880)

Net increase in cash Beginning balance in cash Cash balance at 12-31-97

820 2,700 3,520

Noncash investing and financing activities Exchanged stock for patent Exchanged equipment for land Reconcilation of net income to cash provided by operations Net income Depreciation amortization Extraordinary loss (net of taxes) Gain/(loss) on exchange of assets Realized gain/(loss) on investments Amort of Bond Discount Change in working capital accounts: Accounts receivable (net) Inventories Prepaid Expenses Accounts Payable Interest payable Wages payable

180694588.doc Created by T. Gordon 10/16/2013

(1,400) 5,800 815 2,600 (1,300) 200 65 (315) (230) 400 295 (330) 100 6,700

Page 68

Acct 592 – Spring 2005

Albion Altimeters Inc. Statement of Cash Flows For year ended Cash provided by operations Cash collected from customers Interest & dividends received Cash paid for merchandise Cash paid to employees Other operating disbursements Interest paid Income taxes paid Subtotals

12/31/97 Inflows

Net

3,708,000 15,000

3,723,000

Cash provided by investing activities Purchase plant, property & equipment Sale of plant, property & equipment Marketable securities purchased Marketable securities sold Subtotals Cash provided by financing activities Dividends paid Common stock issued

Outflows

(2,016,000) (651,300) (243,800) (93,700) (168,000) (3,172,800)

550,200

(1,740,000) 35,000 (585,000) 35,000

(2,325,000)

(2,290,000)

(100,000) Subtotals

1,750,000 1,750,000

Change in cash Beginning balance - Cash Ending balance - Cash

Land obtained by issue of common stock

180694588.doc Created by T. Gordon 10/16/2013

(100,000)

1,650,000 (89,800) 400,000 310,200

32,000

Page 69

Acct 592 – Spring 2005

Albion Altimeters Inc. For year ended

12/31/97

Schedule to reconcile net income to cash provided by operations Net Income 289,900 Depreciation & amortization 30,000 Bond premiums/discounts (6,000) Realized gains/losses PP&E 30,000 Deferred income taxes 15,700 Change in working capital accounts: Net accounts receivable 125,200 ** Merchandise Inventory 21,000 Prepaid Operating Expenses (13,800) Accounts Payable 63,000 Salaries Payable (1,300) Income Taxes Payable (3,500) Cash provided by operations: 550,200

**

Change in Accounts Receivable Change in Allowance for Doubtful Accounts

This is the more difficult alternate: Adjustment to sales (to get cash collected from customers) Bad debt expense

180694588.doc Created by T. Gordon 10/16/2013

119,000 6,200 125,200 108,000 17,200 125,200

Page 70

Acct 592 – Spring 2005

Worksheet Albion Altimeters Inc. Cash Securities Available for Sale (at market) Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Operating Expenses Plant, property & equipment Accumulated Depreciation Accounts Payable Salaries Payable Income Taxes Payable Dividends Payable Bonds Payable Premium/Discount on Bonds Payable Deferred Income Taxes

Year ending 12/31/96 Ref 400,000 r, 500,000 f 900,000 (27,000) e 850,000 25,000 m g, 1,880,000 c (350,000) b 4,178,000 (350,000) (8,500) n (27,000) o (25,000) A (1,000,000) (124,000) (88,000)

Common stock, $10 par

(1,000,000)

Additional paid in capital Acc'd other comprehensive income Retained Earnings 0

(700,000) 14,000 (869,500) (4,178,000)

180694588.doc Created by T. Gordon 10/16/2013

p

a

Debit

Ref

Credit 89,800

J e i k

11,000 108,000 17,200 21,000

27,000 585,000

11,000

1,112,000

13,800 32,000 1,740,000 b 25,000 h l 1,300 3,500 100,000

a

781,000 (33,200) 829,000 38,800

90,000 30,000

3,562,000 (355,000) 6,244,800 63,000 (413,000) (7,200) (23,500) 75,000 0 (1,000,000)

6,000

75,000

Year ending 12/31/97 310,200

(118,000) (103,700)

q 15,700 G 10,000 d 500,000 (1,510,000) G 22,000 d 1,250,000 (1,972,000) r 27,000 (13,000) x 289,900 (1,084,400) (6,244,800)

Page 71

Acct 592 – Spring 2005 Albion Altimeters 1997 Closing entry for 1997 Sales Gain/(loss) on sale of PP&E Interest and dividend revenue Cost of goods sold Salaries and wages Other operating expenses Bad debt expense Depreciation expense Interest expense Income taxes expense Net income (accrual basis) Statement of Cash Flows Operating Activities Net income Add depreciation expense Add loss on sale of equipment Amortization of discount on B/P Deferred Income Taxes Change in working capital accounts: Accounts Receivable Allowance for doubtful accounts Merchandise Inventory Prepaid Operating Expenses Accounts Payable Salaries Payable Income Taxes Payable Investing Activities Proceeds from sale of equipment Purchase building & equipment Purchase marketable securities Financing Activities Dividends paid Proceeds from issuance of common stock Noncash Financing/Investing Exchange common stock for land valued at $32,000 CHANGE IN CASH Totals

180694588.doc Created by T. Gordon 10/16/2013

Rev/(Exp) Ref 3,600,000 j (30,000) b 15,000 k (2,100,000) l (650,000) (230,000) (17,200) I (30,000) H (87,700) (180,200) Q 289,900 X

289,900 30,000 30,000 (6,000) 15,700

X X H B P Q

Debit Ref 108,000 30,000

Credit

21,000 63,000 n m

1,300 13,800

p o X

6,000 3,500 550,200 OUTFLO WS

17,200 30,000 15,700 289,900 INFLOW S 550,200

1997 Receipt/ (Disb) 3,708,000 0 15,000 (2,016,000) (651,300) (243,800) 0 0 (93,700) (168,000) 550,200 (Subtotals ) 550,200

119,000 6,200 21,000 (13,800) 63,000 (1,300) (3,500) 550,200 (2,290,000) b

35,000 c f

1,740,000 585,000 1,650,000

A d

100,000

1,750,000

89,800 5,619,400 0

5,619,400

Page 72

(89,800)

Acct 592 – Spring 2005

180694588.doc Created by T. Gordon 10/16/2013

Page 73

Acct 592 – Spring 2005

Check figures for cash provided by operations: Endicott Engines Camperdown Company

180694588.doc Created by T. Gordon 10/16/2013

$ 462,000 $2,647,000

Page 74

Acct 592 – Spring 2005 Final Exam Question – Spring 2002 Required: Use the financial statements, the additional information (next page) and the worksheet provided to prepare the statement of cash flow using the direct method. For full credit, use the pages provided to prepare the formal statement in addition to the worksheet.

Camperdown Company Balance Sheet Current Assets Cash Securities Available for Sale (at cost) Allowance to adjust to market value Net accounts receivable Merchandise Inventory

Noncurrent Assets Plant, property & equipment Accumulated Depreciation Investment in Edible Oils Inc. Intangible Assets TOTAL ASSETS

180694588.doc Created by T. Gordon 10/16/2013

12/31/02

12/31/01

183,000 727,000 13,000 917,000 480,000 2,320,000

100,000 367,000 (14,000) 1,238,000 540,000 2,231,000

17,208,000 (2,527,000) 2,023,000 480,000 19,504,000

14,500,000 (1,500,000) 2,000,000 500,000 17,731,000

Balance Sheet Current Liabilities Accounts Payable Salaries Payable Income Taxes Payable Dividends Payable Noncurrent Liabilities Bonds Payable Discount on Bonds Payable Deferred Income Taxes Obligation under capital leases

Stockholder's Equity Convertible preferred stock Common stock, $10 par Additional paid in capital Acc'd other comprehensive income Treasury stock (at cost) Retained Earnings Total liabilities and equity

Page 75

12/31/02

12/31/01

930,000 2,000 9,000 27,000 968,000

750,000 5,000 20,000 18,000 793,000

7,000,000 (605,000) 64,000 403,000 6,862,000

7,000,000 (640,000) 39,000 380,000 6,779,000

4,500,000 2,000,000 2,106,000

5,000,000 1,600,000 1,400,000

13,000 (26,000) 3,081,000 11,674,000 19,504,000

(14,000) (52,000) 2,225,000 10,159,000 17,731,000

Acct 592 – Spring 2005

Camperdown Company Income Statement For year ending 12/31/02 Sales Investment income Gain/(loss) on sale of PP&E Realized gain/(loss) on investments Total revenues Cost of goods sold Salaries and wages Other operating expenses Bad debt expense Depreciation & amortization expense Interest expense Income taxes expense

10,000,000 50,000 (45,000) 10,000 10,015,000 6,000,000 600,000 250,000 21,000 1,077,000 565,000 551,000

Net income

180694588.doc Created by T. Gordon 10/16/2013

9,064,000 951,000

Additional information: a. During the year, Camperdown Corporation paid quarterly dividends in the total amount of $86,000. b. The preferred stock is convertible into 6 shares of common stock at the discretion of the stockholder. During the year, 5,000 shares of preferred stock were converted into common stock. c. Camperdown Corporation received $27,000 in dividends from Edible Oils Inc (equity method investment). The securities held in the available for sale portfolio paid no cash dividends during the year. d. During the year, Camperdown Corporation sold a piece of equipment for $25,000. The historical cost of the asset was $100,000 and the book value was $70,000 at the date of sale. e. On April 30, Camperdown Corporation issued 10,000 shares of common stock for $60 per share. f. Camperdown Corporation acquired a new processing plant for a total cost of $2,450,000. $2,000,000 was attributed to the building and the remainder was attributed to the cost of the land. g. Camperdown Corporation wrote off $5,000 in bad debts during the year. h. Camperdown Corporation sold marketable securities that had cost $90,000 for $100,000. i. Camperdown Corporation entered into a new capital lease arrangement to obtain manufacturing equipment needed for the new facility. The present value of the minimum lease payments was $358,000 at the inception of the lease. j. Half of the 1,000 shares of treasury stock were sold for $64 per share. Camperdown Corporation uses the cost method. The treasury stock on hand at the beginning of the year was carried at $52 per share.

Page 76

Acct 592 – Spring 2005 Statement of Cash Flow Problem Worksheet Camperdown Company Cash

Year ending 12/31/01 Ref 100,000

Debit Ref 83,000

Credit

Year ending 12/31/02 183,000

Target 83,000

Securities Available for Sale (at cost)

367,000

727,000

360,000

Allowance to adjust to market value

(14,000)

13,000

27,000

Net accounts receivable

1,238,000

917,000

(321,000)

Merchandise Inventory

540,000

480,000

(60,000)

Plant, property & equipment

14,500,000

17,208,000

2,708,000

Accumulated Depreciation

(1,500,000)

(2,527,000) (1,027,000)

Investment in Edible Oils Inc.

2,000,000

2,023,000

23,000

500,000

480,000

(20,000)

17,731,000

19,504,000

(750,000)

(930,000)

(180,000)

(5,000)

(2,000)

3,000

Income Taxes Payable

(20,000)

(9,000)

11,000

Dividends Payable

(18,000)

(27,000)

(9,000)

(7,000,000)

(7,000,000)

0

Premium/Discount on Bonds Payable

640,000

605,000

(35,000)

Deferred Income Taxes

(39,000)

(64,000)

(25,000)

(380,000)

(403,000)

(23,000)

Intangible Assets Total assets Accounts Payable Salaries Payable

Bonds Payable

Obligation under capital leases

180694588.doc Created by T. Gordon 10/16/2013

Page 77

Acct 592 – Spring 2005

Statement of Cash Flow Problem Worksheet Camperdown Company

Year ending 12/31/01 Ref

Debit

Ref

Credit

Year ending 12/31/02

Target

Convertible preferred, $100 par

(5,000,000)

(4,500,000)

500,000

Common stock, $10 par

(1,600,000)

(2,000,000)

(400,000)

Additional paid in capital

(1,400,000)

(2,106,000)

(706,000)

Acc'd other comprehensive income

14,000

(13,000)

(27,000)

Treasury stock (at cost)

52,000

26,000

(26,000)

Retained Earnings Total Liab & owners equity Closing entry for

(2,225,000) (17,731,000) 2002 Rev/(Exp)

Sales Earnings of investees (equity method) Gain/(loss) on sale of PP&E Realized gain/(loss) on investments

Credit

10,000

(600,000)

Other operating expenses

(250,000) (21,000) (1,077,000)

Interest expense

(565,000)

Income taxes expense

(551,000)

180694588.doc Created by T. Gordon 10/16/2013

Ref

(45,000)

Salaries and wages

Net income (accrual basis)

Debit

50,000

(6,000,000)

Depreciation & amortization expense

Ref

2002 Inflow/ (Outflow)

10,000,000

Cost of goods sold

Bad debt expense

(3,081,000) (856,000) (19,504,000) (1,773,000)

951,000

Page 78

Acct 592 – Spring 2005 Camperdown Company Statement of Cash Flows Operating Activities Net income

INFLOWS

OUTFLOWS

(Subtotals)

951,000

Investing Activities

Financing Activities

180694588.doc Created by T. Gordon 10/16/2013

Page 79

Acct 592 – Spring 2005 Camperdown Company INFLOWS

OUTFLOWS

(Subtotals)

Noncash Financing/Investing

CHANGE IN CASH Totals

180694588.doc Created by T. Gordon 10/16/2013

83,000

Page 80

Acct 592 – Spring 2005 Camperdown Corporation Statement of Cash Flow For year ended 12-31-02 Cash provided by operations

Cash provided by investing activities

Cash provided by financing activities

180694588.doc Created by T. Gordon 10/16/2013

Page 81

Acct 592 – Spring 2005 Camperdown Corporation Statement of Cash Flow For year ended 12-31-02 Reconciling schedule

Notes

180694588.doc Created by T. Gordon 10/16/2013

Page 82