Preparing a columnar work sheet for a statement of cash flows from changes in balance sheet accounts. The comparative balance sheets of The Coca-Cola Company show the following information for the current year (amounts in millions):LO1.

a. Prepare a columnar work sheet for the statement of cash flows for the current year.

b. Comment on the most important reasons for the change in cash during the year.

Transcribed Image Text:

Change Amount Direction Cash $ 453 Increase Accounts Receivable. 282 Increase Inventories 2 Decrease Prepayments 38 Increase Property, Plant, and Equipment (at cost) 1,291 Increase Accumulated Depreciation 210 Increase Accounts Payable. 347 Increase Short-term Borrowing Other Current Liabilities Bonds Payable. Common Stock Retained Earnings *Cash was $1.078 million at the beginning of the year and $1,531 million at the end of the year. "The firm sold for $70 million during the year equipment costing $150 million and with accumu- lated depreciation of $80 million. "The firm retired during the year bonds with a face value and book value of $150 million, at no gain or loss. "The firm declared and paid dividends totaling $1,006 million during the year. 411 Increase 248 Increase 195 Increase 1,104 Decrease 1.755 Increase