Complete using an Excel spreadsheet

Principles of Accounting 1 Chapter 2 Homework Cynthia Jackson, an accountant, organized Jackson and Associates on August 1, 2021. During the month. Jackson and Associates completed the following transactions: a. Issued capital stock to Cynthia Jackson in exchange for $55,000. b. Paid office salaries, $8,000. c. Billed customers for fees earned for providing accounting services, $17,500. d. Purchase office supplies (supplies inventory) on account, $4.000. e. Paid advertising expenses using cash $1,000. f. Paid rent expense for the month. $2.500. g. Paid creditors on account. $3.500. h. Received cash from customers on account, $12,000. i. Determined that the cost of supplies (supplies inventory) on hand was $2,500; therefore, the cost of supplies used was $1,500. j. Paid dividends, $3,000. Instructions 1. Journalize the entries for transactions (a) through (1). 2. Prepare T accounts using all accounts utilized to make the journal entries. Post the journal entries to these T accounts. Determine the account balances, after all posting is complete. 3. Prepare an unadjusted trial balance as of August 31, 202X. 4. Determine net income and net effect on retained earnings for August