Build an excel spreadsheet to construct a multi step income


The following accounts, balances, and other financial information are drawn from the records of Vong Company for the year 2013:

320_264-B-A-M-B (1316).png

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.

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Build an excel spreadsheet to construct a multi step income
Reference No:- TGS01242277

Now Priced at $15 (50% Discount)

Recommended (95%)

Rated (4.7/5)