The following partially completed worksheet has been prepared for the 2007 statement of cash flows of the Perrin Company:

Other relevant information
(a)

(b) Accumulated depreciation is a contra account for all the depreciable assets. Depreciation on these assets totaled $2,200 for the year.
(c) On January 1, 2007 the company issued 10% bonds with a face value of $5,000 at 106. Interest was paid semiannually on June 30 and December 31. The bonds mature on January 1, 2009. Straight-line amortization is used for bond discount or premium. Bond interest expense was $440.
(d) Land was purchased for $3,200 during the year.
(e) Two hundred shares of common stock were issued for delivery equipment valued at $2,900 and office equipment valued at $3,100.
(f) Twenty shares of stock were issued as a stock dividend. The market price per share was $42.
(g) Office equipment with a cost of $1,000 and a book value of $300 was sold for $50.
(h) Fifty shares of its own common stock were reacquired by the company as treasury stock. The company purchased the shares for $40 per share.
(i) One hundred shares of Doe Company stock were purchased for $28 per share at year-end.
Required
Complete the worksheet(spreadsheet).

Balances Change Worksheet Entries Credit Account Titles 12/31/06 12/31/07 ncrease Debit Debits Cash Noncash Accounts Accounts receivable Inventor)y 1,500 3,100 Land Buildin Office equipment Delivery equipment Treasury stock 2,180 6,055 2,800 9,200 20,000 6,100 5,900 2,000 38,40055,775 6,000 20,000 4,000 3,000 Totals Credits 8,500 3,695 500 5,000 240 8,200 13,640 Accumulated depreciation Accounts payable 7,000 Bonds payable Premium on bonds payable Common stock, S10 Additional paid-in capital Retained ea 6,000 9,000 3,500 Totals Beginning retained earnings $12,500 8,000 $20,500 Plus: Net income Less: Stock dividends Ending retained earnings $ 840 3,660 Cash dividends (4,500) $16,000