Problem -

During 2015, the following events occurred:

1. Lander liquidated its available-for-sale investment portfolio at a loss of $6,500.
2. A tract of land was purchased for $31,000 cash.
3. An additional $20,000 in common stock was issued at par.
4. Dividends totalling $5,000 were declared and paid to stockholders.
5. Net income for 2015 was $29,000, including $7,000 in depreciation expense.
6. A second tract of land was purchased through the issuance of $25,000 in additional bonds.
7. At December 31, 2015, cash was $72,650, accounts receivable was $35,250, and accounts payable was $32,500.

In an Excel spreadsheet:

• Prepare a statement of cash flows for the year 2015 for Lander.
• Prepare the balance sheet as it would appear as of December 31, 2015.