can you please help me do this, my professor just threw it at us and I'm really struggling. please Help!

LayoutTables ChartsSmartArt Formulas Data Review abe Wap Text General : Fil Liberation Sans Normal 2 Clear BI U nsert Delete Format Themes Aa" Aa- burn opened a law office, Randy Coburn, Attomey at Law, on July 1, 2015. On Jly 31, the balance sheet ash $4.000. Accounts Recevable S 1.500. Supplies $400. Equipment S 5.000. Accounts Payable S4.200 . Stock $6,000, and Retained Earnings $700. During August, the folowing transactions occurred. lected $1.400 of accounts receivable due from clents d $2,700 cash on accounts payable due. cognized revenue of $7,900 of which $3,000 is collected in cash and the balance is due in September. rchased additional equipment for $1,000, paying $400 in cash and the balance on account. d salaries $3,000, rent for August $900, and advertising expenses $250. clared and paid a $450 cash dividend ceived $2,000 from Standard Federal Bank; the money was borrowed on a 4-month note payable urred utility expenses for month on account $180 pare a tabular analysis of the August transactions beginning with July 31 balances. The column counts Payable+ Common StockRetained Earnings+Revenue Expenses-Dividends pare an income statement for August, a retained eamings statement for August and a balance et at August 31 nter a number in cells requesting a value; enter either a number or a formula in cels with a "7 RANDY COBURN, ATTORNEY AT LAW Notes Accounts Receivable PayableStock EaningsRevenues ExpensesDividends Value Value P1-28+ Ready mal Vien Sum-0