The following accounts, balances, and other financial information are drawn from the records of Vong Company for the year 2013:
The Cash account revealed the following cash flows:
Received cash from advances from customers .........$ 2,600
Purchased office equipment .................$ 3,500
Received cash from issuing stock ..............$ 3,000
Collected cash from accounts receivable ..........$ 3,800
Purchased land ...................... $ 8,000
Received cash from borrowing funds ...........$ 6,000
Paid cash for rent ......... ............$ 1,200
Sold land .......................$ 10,000
Paid cash for dividends .................. $ 1,500
Paid cash for operating expenses .............$ 1,000
Purchased certificate of deposit ...............$ 10,000
Required:
Build an Excel spreadsheet to construct a multi step income statement, statement of changes in stockholders equity, balance sheet, and statement of cash flows for the year 2013.