Complete a Balance Sheet for December 31, 2020, Use the balances obtained after the transactions have been verified on the transaction analysis sheet.

Be sure to create formulas for each column and row. The first column (Cash) and the first row (Zero Proof for opening balances)

Use formulas to calculate the Total Assets, Total Liabilities, and Total Liabilities and Owner's Equity figures. Use Borders to add underlining to the appropriate values.

0 L M N O C Analyse each of the following action and record in the transaction analysis sheet below 1. Services receives $1000 cash from the intent of the amount owed 2. Staples 2000 canhin para manter the dead to the 2. The only the new computere 51200 with the money 4 Scire purchased for cash fronte SA Service receives a comision 54 700 foreign countingtone An eve from the concerne la tiked to the company with a compensation A new company accounting wits resetup Kit Accounting Service for this service, the company receive 15.000 Accounting Services de comertom oplevalundt 53 000 cents Account Services of 1000 and the remainder of the best bedre 40 10. Kath' Accounting Servicesses and stars for S15 COCA 11 12 15 Keith's Accounting Services 16 Owner's Emily A 16 19 Opening Dances KK Staple 2.3.70000 1000 19.000 100.00 5.000.00 1.300.00 13.400.00 21.000.000.000,00 10,000.00 21 22 ORE 23 24 25 28 27 na 28 20 30 Estances 31 Transaction Analysis sheet Balance sheet 8 E C D F G H M K L Keith's Accounting Services BALANCE SHEET December 31, 2020 Liabilities Assets Total liabilties Owner's Equity Total Assets Total liabilities and Owner's Equity Transaction Analysis sheet Balance sheet 1 Analyze each of the following transactions and record in the transaction analysis sheet below! 2 1. Keith's Accounting Services receives $1000 cash from Judy's Gift Shop in partial payment of the amount owed by them. 2. Staples is paid $2 000 cash in partial payment of the debt owed to them by Keith's 3. The owner buys themself a new computer valued at $1200) with their own money 4. Supplies costing $950 are purchased for cash from the Staples. 5. Keith's Accounting Services receives a commission of S4 700 for selling new accounting software. 6 6. A old computer is sold for $3 000 cash 7. An employee from the company is asked to leave the company with no compensation 8. A new company accounting systems are set up Keith's Accounting Services is set up up. For this service, the company receives $15000 cash. 9 9. Keith's Accounting Services purchases a new computer from Apple valued at $3000. Keith's Accounting Services gives a cash down payment of S1000 and the remainder of the balance is to be paid 10 10. Keith's Accounting Services sells one of its cars for $15 000 cash. 11 12 13 Keith's Accounting Services 15 Assets Owner's Liabilities 16 Equity Accounts Receivable Office Accounts Payable 17 Krby Cash Supplies Cars Equipment Capital Zero Proof Judy's G Alexia Pet Ozzie Apple 18 Staples Shop Store Food Computer 19 Opening Balances 15,000.00 3.100.00 5,000.00 1,300.00 13,400.00 21,000.00 60,000.00 30,600.00 23,700.00 $4,500.00 o 20 Transaction 1 21 Transaction 2 22 Transaction 3 23 Transaction 4 24 Transaction 5 25 Transaction 6 26 Transaction 7 27 Transaction 28 Transaction 29 Transaction 10 30 Ending Balances 15,000.00 31 32 33 34 Transaction Analysis sheet Balance sheet +