Uncategorized

Assignment

Given Data
May
1 Cash invested in company  $60,000
1 Cash paid for may rent  $3,200
3 office equipment purchased on credit  $1,680
5 Cash paid for May cleaning services $800
8 Cash collected for services provided  $4,600
12 provided services on credit  $3,000
15 Cash paid for assistants salary (1st half of May)  $850
20 Cash received for servives provided May 12  $3,000
22 Provided services on credit  $2,800
25 Cash recevied for services provided May 22  $2,800
26 Cash Paid for office equipment Purchased May 3  $1,680
27 Purchased May Advertising payment due June 1  $60
28 Cash paid for assistant salary (2nd half of May)  $850
30 Cash paid for May telephone bill  $200
30 Cash paid for May Utilities  $480
31 Cash paid for dividends  $1,200

Check figures
(2) Ending Balances $61,140
Cash $6,440
Expense

(3) Net income  3960
Total Assets  $62,820

I need this in a spread sheet form that says
Asset = Libilities + Equity

The sub heading would be
Cash, Account Receivable, office equipment, Accounts payable, Common Stock, dividends, Revenue, and Expenses.