Our first discussion homework spreadsheet will be using the following information you will find in your textbook. Our goal is to create a WORKING spreadsheet that can be used to display this information in a meaningful manner! You will find this problem in your textbook, it is a PRACTICE problem so the solution is already available in your textbook, what I am grading is your DELIVERY of this information!l! Please read the following problem and create a spreadsheet and attach your results to this thread AND then please read and review the submissions from the other students. What did you think worked well, what types of formatting made the spreadsheet work, and what needs help? EXCEL Homework Assignment 1, Chapter 2, Practice Problem (2-31) Practice Problem Journalize transactions, post, and propare a trial balance. (LO 1, 2, 3,4) Bob Sample and other student investors opened Campus Laundromat Inc. on September 1, 2022. During the first month of operations, the following transactions occurred. Sept.1 Stockholders invested $20,000 cash in the business in exchange for common stock. 2 The company paid $1,000 cash for store rent for September. Purchased washers and dryers for $25,000, paying $10,000 in cash and signing a $15,000, 3 6-month, 12% note payable. 4 Paid $1,200 for a one-year accident insurance policy. 10 Received a $200 bill from the Daily News for advertising the opening of the laundromat. 20 Declared and paid a $700 cash dividend to stockholders. The company determined that cash receipts for laundry services for the month were 30$6,200. The chart of accounts for the company is the same as that for Pioneer Advertising Inc. (Illustration 2.19), plus No. 610 Advertising Expense. Instructions 1. Journalize the September transactions. (Use J/ for the journal page number.) 2. Open ledger accounts and post the September transactions. 3. Prepare a trial balance at September 30, 2022. counts differ for each company. The number of accounts depends on the amount of detail management desires. For example, the management of one company may y peparate expense accounts for each type of utility, such as gas, clectricity, and water. Similarly, a small company like Softbyte inc. will have fewer accounts than a co. rities in 20 to 30 accounts, while Dell may require thousands of accounts to keep track of its worldwide activities. art of accounts. This chart lists the accounts and the account numbers that identify their location in the ledger. The numbering system that identifies the accounts t he statement accounts. lapters, we will be explaining the accounting for Pioneer Advertising Inc. (a service company). Accounts 101-199 indicate asset accounts; 200-299 indicate liabilities: nes; 601-799, expenses; 800-899, other revenues; and 900-999, other expenses. Illustration \&.19 shows Pioneer's chart of accounts. Accounts listed in red are use Chart of accounts for Pioneer Advertising Ine. re are gaps in the numbering system of the chart of accounts for Pioneer. Companies leave gaps to permit the insertion of new accounts as needed during the life of the busine Across the Organization al Group
