journal and ledger paper are provided on subsequent pages. An Excel template for requirement #3 is provided for you. Students are to create from scratch an Excel spreadsheet for the preparation of financial statements as directed in requirement #4.) Work through the case as directed so that you experience the sequence of the accounting cycle. 1. Prepare a journal entry for each transaction. 2. Post to general ledger accounts. An Excel version of a working trial balance is posted in DocSharing. Complete the Unadjusted Trial Balance on the Excel spreadsheet. The debit and credit columns should total $138,000. 3. Complete a month-end working trial balance on an Excel spreadsheet as of August 31, 2025. (See Excel template provided.) The working trial balance enables the accountant to problem-solve for the adjustments and complete the financial statements before formally recording adjusting entries into the accounting records. You will formally record the adjusting entries in requirement 6. Solve for Bells adjusting entries using the following information, then complete your spreadsheet through the adjusted trial balance columns. a. The company anticipates that of the $25,000 in Accounts Receivable from customers, $2,500 will not be collected. b. The note payable requires the entire $30,000 in principal plus interest at 10% to be paid on July 31, 2026. The date of the loan is August 1, 2025. c. The equipment that was purchased on August 1, 2025 is being depreciated using the straight-line method over 3 years and is expected to have a $2,000 residual value. (Recall only one month is depreciated.) d. The note receivable is dated August 16, 2025. The note requires the entire $20,000 in principal plus interest at 12% to be repaid in four months. (Note that the loan was outstanding for one-half month in August.) e. The prepaid rent of $6,000 represents rent for the months of August and September. f. Total debits and credits for the Adjusted Trial Balance columns should be $141,350. 4. Using Sheet 2 &/or 3 (from your Excel spreadsheet in #3), prepare the companys financial statements for August 2025 on an Excel Spreadsheet. You are responsible for creating and formatting. 5. Go back to your working trial balance and problem-solve for your closing entries. Complete the working trial balance through the post-closing trial balance. Total debits and credits for the Post-Closing Trial Balance columns should be $103,100. 6. Formally record both the adjusting and closing entries in the general journal. Post to the general ledger accounts. Double check that your general ledger account balances agree with your post-closing trial balance