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 multistep income statement, statement of changes in stockholders’ equity, balance sheet, and statement of cash flows for the year2013.

Transcribed Image Text:

Net sales revenue Unearned revenue Accounts receivable Cost of goods sold Inventory Accounts payable Notes payable Interest expense Interest payable Supplies Supplies expense Office equipment Depreciation expense Accumulated depreciation Transportation-out expense Miscellaneous operating expense $18,800 Beginning common stock S9,000 8,000 10,000 100 100 1,500 8,500 3,000 7,200 1,050 50 1,400 400 1,100 100 2,600 Land 6,000 Certificate of deposit 6,000 Interest revenue 5,000 Interest receivable 5,800 Dividends 6,000 Beginning retained earnings 550 Cash from stock issued 550 Cash 50 750 Gain on sale of land 3,500 Salaries expense 1,000 Rent expense 4,500 Loss on sale of property Salaries payable Prepaid rent 500 500