Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following partially completed spreadsheet has been prepared for Perrin Company's 2016 statement of cash flows: Balances Change Worksheet Entries Account Titles 12/31/15 12/31/16 Increase

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

Balances Change Worksheet Entries
Account Titles 12/31/15 12/31/16 Increase (Decrease) Debit Credit
Debits
Cash 800 1,540
Noncash Accounts:
Accounts Receivable 1,500 2,180
Inventory 3,100 6,055
Investments in Stock 2,800
Land 6,000 9,200
Buildings 20,000 20,000
Office Equipment 4,000 6,100
Delivery Equipment 3,000 5,900
Treasury Stock 2,000
Totals 38,400 55,775 ?
Credits
Accumulated Depreciation 7,000 8,500
Accounts Payable 3,300 3,695
Wages Payable 600 500
Bonds Payable 5,000
Premium on Bonds Payable 240
Common Stock, $10 par 6,000 8,200
Additional Paid-in Capital 9,000 13,640
Retained Earnings ? ? 3,500
Totals 38,400 55,775 ?

Additional relevant information:

Beginning retained earnings $12,500
Plus: Net income 8,000
$20,500
Less: Stock dividends $ 840
Cash dividends 3,660 (4,500)
Ending retained earnings $16,000

Accumulated depreciation is a contra account for all the depreciable assets. Depreciation on these assets totaled $2,200 for the year.

On January 1, 2016, 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, 2021. Straight-line amortization is used for bond discount or premium. Bond interest expense was $440.

Land was purchased for $3,200 during the year.

Two hundred shares of common stock were issued for delivery equipment valued at $2,900 and office equipment valued at $3,100.

Twenty shares of stock were issued as a stock dividend. The market price per share was $42.

Office equipment with a cost of $1,000 and a book value of $300 was sold for $50.

Fifty shares of its own common stock were reacquired by the company as treasury stock. The company purchased the shares for $40 per share.

One hundred shares of Doe Company stock were purchased for $28 per share at year-end.

Required:

Complete the spreadsheet. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments.

PERRIN COMPANY Cash Flows Worksheet For Year Ended December 31, 2016
Balances Worksheet Entries
Account Titles 12/31/2015 12/31/2016 Change Debit Credit
Debits
Cash 800 1,540
Noncash Accounts:
Accounts Receivable 1,500 2,180
Inventory 3,100 6,055
Investments in Stock 2,800
Land 6,000 9,200
Buildings 20,000 20,000
Office Equipment 4,000 6,100
Delivery Equipment 3,000 5,900
Treasury Stock 2,000
Totals 38,400 55,775
Credits
Accumulated Depreciation 7,000 8,500
Accounts Payable 3,300 3,695
Wages Payable 600 500
Bonds Payable 5,000
Premium on Bonds Payable 240
Common stock, $10 par 6,000 8,200
Additional Paid-in Capital 9,000 13,640
Retained Earnings 3,500
Totals 38,400 55,775

Worksheet Entries
Debit Credit
Cash Flows from Operating Activities:
Cash Flows from Investing Activities:
Cash Flows from Financing Activities:
Investing and Financing Activities Not Affecting Cash:
Totals

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions