Please answer the attached question.

1)

Prepare a spreadsheet to support Casavant Company's statement of cash flows.

Worksheet entries are optional tools that do not have to be submitted but may be helpful.

2)

Prepare the formal statement of cash flows for Casavant.

Chapter 21 Statement of Cash Flows Homework Problem (15 points) Account Balances 12/31/2015 12/31/2016 Account titles: Debits Cash Accounts receivable Inventory Investment in stock Land Building Office equipment Delivery equipment Treasury stock Totals 800 1,500 3,100 6,000 20,000 4,000 3,000 38,400 1,540 2,180 6,055 2,800 9,200 20,000 6,100 5,900 2,000 55,775 7,000 3,300 600 6,000 9,000 ? 38,400 8,500 3,695 500 5,000 240 8,200 13,640 ? 55,775 Credits Accumulated depreciation Accounts payable Wages payable Bonds payable Premium on bonds payable Common stock, $10 par Additional paid-in capital Retained earnings Totals Additional relevant information: Beginning retained earnings Add: net income a. Less: stock dividends cash dividends Ending retained earnings 12,500 8,000 20,500 840 3,660 $ (4,500) 16,000 Accumulated depreciation is a contra account for ALL the depreciable assets. Depreciation on these assets totale year. On January 1, 2016, the company issued 10% bonds with a face value of $5,000 at 106. Interest was paid semi-annually 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 for the year. Land was purchased for $3,200 during the year. Two hunded shares of common stock were issued for delivery equipment valued at $2,900 and office equipeme Twenty shares of stock were issued as a stock dividend. The market price per share was $42. Office equipment withcommon a cost of stock $1,000 andreacquired a book value was sold for $50. stock. The company purchase Fifty shares of its own were by of the$300 company as treasury $40 per share. One hundred shares of Doe Company stock were purchased for $28 per share at year-end. b. c. d. e. f. g. h. i. 1) Required: Prepare a spreadsheet to support Casavant Company's statement of cash flows. Worksheet entries are optional tools that do not have to be submitted but may be helpful. 2) Prepare the formal statement of cash flows for Casavant. on on these assets totaled $2,200 for the nterest 021. was 00 and office equipement valued at $3,100. The company purchased the shares for