Please make a spreadsheet

Question 3 of 6 > 0.33/1 Show Attempt History Current Attempt in Progress Kimberly Young started her own consulting firm, Crane Consulting, on May 1, 2020. The following transactions occurred during the month of May. May 1 Trixie invested $6,600 cash in the business. 2 Paid $850 for office rent for the month. 3 Purchased $600 of supplies on account. 5 Paid $120 to advertise in the County News. 9 Received $3,800 cash for services performed. Withdrew $1,200 cash for personal use. Performed $5,000 of services on account. Paid $2,100 for employee salaries. Made a partial payment of $400 for the supplies purchased on account on May 3. Received a cash payment of $4,100 for services performed on account on May 15. Borrowed $5,500 from the bank on a note payable. Purchased equipment for $4,000 on account Paid $300 for utilities 12 15 17 20 23 26 29 30 Assets Liabilities Owners Equity Accounts Supplies Equipment Notes Accounts owners owners Revenues Expenses Date Cash Receivable payable payable capital drawings 1-May 6,600 6,600 2-May-850 -850 3-May 600 600 5-May-120 -120 9-May 3,000 3,000 12-May-1,200 -1,200 15-May 5,000 5,000 17-May -2,100 -2,100 20-May -400 -400 23-May 4,100 -4,100 26-May 3,500 3,500 29-May 4,000 4,000 30-May-300 -300 12,230 900 600 4000 3500 4200 6,600 - 1200 8000 -3370 Income Statement For the Month ended 31st May 2020 Revenue Service Revenue 8800 Expenses Rent Expenses 850) Advertisement exp 120 Salaries Exp. 2100 utility exp 300 Total Expenses 3370 Net profit 5430 Prepare a balance sheet at May 31, 2020. (List Assets in order of liquidity.) CRANE CONSULTING Balance Sheet Assets $ $ Liabilities and Owner's Equity $