Instructions: You can use Excel to development the answer. 1. Journalize each transaction in a Journal (see the model on page 63-64), referring to the following chart of accounts and prepare a General Ledger using this accounts titles and numbers: Cash 11 Aceounts Receivable #13 Supplies #15 Prepaid Rent #16 Prepaid Insurance #17 Office Equipment W18 Accumulated Depreciation #19 Accounts Payable #21 Salaries Payable #23 Pepita Prez, Capital #31 Pepita Prez, Withdrawals 832 Fees Revenue #41 Salary Expense #51 Rent Expense #53 Supplies Expense #54 Depreciation Expense #55 Insurance Expense #56 Utilities Expense #57 Miscellaneous Expense #59 Income Summary #81 2. Post the journal entries to a ledger accounts (see the model in Exhibit 2.12 on page 52), you may be used this format for each one of the ledger accounts. 3. Prepare an unadjusted trial balance at September 30, 2021. (See the model on page 4. At the end of September, the following adjustments data were got it. Analyze and use these data to complete #5 y #6 instructions. a. Insurance expired during September is $250. b. Supplies used for September are $2,000. c. Depreciation of office equipment for September, $500. d Accrued salary on September is $720. c. Rent expired during September is $2,000. 65) 5. Journalize and post to the ledger accounts the adjusting entries. 6. Prepare an adjusted trial balance as September 30, 2021 7. Prepare at September 30, 2021 an income statement, an owner's equity statement, and a statement of financial position (balance sheet) use model on page 65. 8. Journalize and post to the ledger accounts from the closing entries. 9. Prepare a post-closing trial balance at September 30, 2021. Instructions: You can use Excel to development the answer. 1. Journalize each transaction in a Journal (see the model on page 63-64), referring to the following chart of accounts and prepare a General Ledger using this accounts titles and numbers: Cash 11 Aceounts Receivable #13 Supplies #15 Prepaid Rent #16 Prepaid Insurance #17 Office Equipment W18 Accumulated Depreciation #19 Accounts Payable #21 Salaries Payable #23 Pepita Prez, Capital #31 Pepita Prez, Withdrawals 832 Fees Revenue #41 Salary Expense #51 Rent Expense #53 Supplies Expense #54 Depreciation Expense #55 Insurance Expense #56 Utilities Expense #57 Miscellaneous Expense #59 Income Summary #81 2. Post the journal entries to a ledger accounts (see the model in Exhibit 2.12 on page 52), you may be used this format for each one of the ledger accounts. 3. Prepare an unadjusted trial balance at September 30, 2021. (See the model on page 4. At the end of September, the following adjustments data were got it. Analyze and use these data to complete #5 y #6 instructions. a. Insurance expired during September is $250. b. Supplies used for September are $2,000. c. Depreciation of office equipment for September, $500. d Accrued salary on September is $720. c. Rent expired during September is $2,000. 65) 5. Journalize and post to the ledger accounts the adjusting entries. 6. Prepare an adjusted trial balance as September 30, 2021 7. Prepare at September 30, 2021 an income statement, an owner's equity statement, and a statement of financial position (balance sheet) use model on page 65. 8. Journalize and post to the ledger accounts from the closing entries. 9. Prepare a post-closing trial balance at September 30, 2021