The following partially completed spreadsheet has been prepared for Perrin Company’s 2019 statement of cash flows:

Additional 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, 2019, 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, 2024. 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 spreadsheet.

Transcribed Image Text:

Change Increase (Decrease) Balances Worksheet Entries Credit 3 12/31/18 12/31/19 Debit Account Titles Debits 4 5 Cash 6 Noncash Accounts: 7 Accounts Receivable 8 Inventory 9 Investments in Stock 10 Land 11 Buildings 12 Office Equipment 13 Delivery Equipment 14 Treasury Stock Totals 800 1,540 1,500 3,100 2,180 6,055 2,800 9,200 20,000 6,100 5,900 2,000 55,775 6,000 20,000 4,000 3,000 38,400 15 16 Credits 18 Accumulated Depreciation 19 Accounts Payable 20 Wages Payable 21 Bonds Payable 22 Premium on Bonds Payable 23 Common Stock, $10 par 24 Additional Paid-in Capital 25 Retained Earnings Totals 17 8,500 3,695 500 7,000 3,300 600 5,000 240 6,000 9,000 ? 8,200 13,640 3,500 55,775 26 38,400 27 Beginning retained earnings Plus: Net income $12,500 8,000 $20,500 Less: Stock dividends Cash dividends Ending retained earnings $ 840 (4,500) $16,000 3,660