Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help filling in this table. 1 Kate Wilson started her own consulting firm, Wilson Consulting, on May 1, 2017. The following transactions occurred
I need help filling in this table.
1 Kate Wilson started her own consulting firm, Wilson Consulting, on May 1, 2017. The following transactions occurred during the month of May. I May .1 Kate invested $7,000 cash in the business. 2 Paid $900 for office rent for the month.[ 3 Purchased $600 of supplies on account. | 5 Paid $125 to advertise in the County News. I 9 Received $4,000 cash for services performed. || 12 Withdrew $1,000 cash for personal use. 15 Performed $5,400 of services on account. 17 Paid $2,500 for employee salaries. I 20 Paid for the supplies purchased on account on May 3.] 23 Received a cash payment of $4,000 for services performed on account on May 15. 26 Borrowed $5,000 from the bank on a note payable. I 29 Purchased equipment for $4,200 on account. | 30 Paid $275 for utilities. I 1.- En la tabla con el formato Excel que se incluye, registre las cantidades de acuerdo a los efectos de las transacciones en la ecuacin de contabilidad. (Total Assets must be $20,800 = Liabilities + Capital). I AutoSave OFF O ES5= Tabla Problema Mdulo 1 Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) v 11 AP = ab Wrap Text General [O Paste B I U A E + 60 Merge & Center $ % .00 Conditional Format Formatting as Table X22 fx A B D E F G H H 1 J K L M N OP Q R S T U 1 2 OWNER'S EQUITY 3 ASSET Account Rec + Supplies LIABILITIES Note Account Payable + Payable + 4 Date Cash + + Equipment Capital Drawing + Revenue Expenses Info 5 1 6 2 3 7 8 5 9 9 10 12 11 15 12 17 13 20 14 23 15 26 16 29 17 30 18 Bal. 0 19 20 21 Total Asset 22 0 0 0 0 0 = 0 0 0 0 0 0 Total Asset 0 = Total Liabilites + Owner's Equity 0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started