Byron Manufacturing

Spreadsheet to Prepare the Statement of Cash Flows

For the Year Ended December 31, 20Y8BeginningIncrease/DecreaseEndingBalance Sheet AccountsBalanceDebitCreditBalanceCash(m)Accounts receivable9,000(h)1,50010,500Inventory18,550(i)19,950Building494,000494,000Equipment272,800(b)279,000Accumulated depreciation120,850(c)147,400Accounts payable36,18019,130(j)55,310Salaries payable11,740(k)9,360Income taxes payable9,960(l)8,8901,070Bonds payable397,000(e)(d)355,000Common stock150,00035,000(f)185,000Retained earnings77,900(g)(a)55,660Increase/Decrease in CashStatement of Cash FlowsDebitCreditCash flow from operating activities Net income(a) Adjustments to reconcile net income

to net cash flow from operating activities Depreciation expense(c) Increase in accounts receivable1,500(h) Increase in inventory(i) Increase in accounts payable(j)19,130 Decrease in salaries payable(k) Decrease in income taxes payable8,890(l)Cash flows from investing activities Purchase equipment(b)Cash flows from financing activities Issued bonds payable(d) Retired bonds payable(e) Issued common stock(f)35,000 Paid dividend(g)Net increase (decrease) in cash(m)274,400274,400