Complete the following exercise in excel

ind P1-40A Using the accounting equation for transaction analysis Learning objective 4 Previous Nest Matilda Crone owns and operates a public relations firm called Dance Fever. The following amounts summarize her business on August 31, 2014: Total Assets $27,900 Liabilities+ Assets ul Cash +AccountsOffice +Land Receivable Supplies Accounts+Crone,Crone, +Service RentAdvertising Payable Capital Withdrawals Revenue Expens Expense $8,000 $11,300 Bal. $2,300+$3,000S0 +$14,000 During September 2014, the business completed the following transactions: a. Matilda Crone contributed $13,000 cash in exchange for capital b. Performed service for a client and received cash of $900 c. Paid off the beginning balance of accounts payable. d. Purchased office supplies from OfficeMax on account, $600 e. Collected cash from a customer on account, $2,300 f. Matilda withdrew $1,600 g. Consulted for a new band and billed the client for services rendered, $5,500 h. Recorded the following business expenses for the month: Paid office rent: $1,200 Paid advertising: $600 Analyze the effects of the transactions on the accounting equation of Dance Fever using the format presented above