ATC 1-6 Spreadsheet Assignment Using Excel

The following transactions pertain to 2014, the first year of operations of the Barlett Company. All inventory was started and completed during 2014. Assume that all transactions are cash transactions.

Acquired $2.000 cash by issuing common stock.Paid $400 for materials used to produce inventory.Paid $600 t production workers.Pair $200 rental fee for production equipment.Paid $160 to administration employees.Paid $80 rental fee for administrative office equipment.Produced 300 units of inventory of which 200 units were sold at a price of $7.00 each.

Required:

Construct a spreadsheet that includes the income statement and balance sheet.