The first Screent\grab is the instructions for these spreadsheets

M P R S T U V X B D E F H H 1 L N 1 Chapter 2 Using Excel 3 P3-45 Using Excel to journalize and post adjusting entries, and to create the Adjustments and Adjusted Trial Balance colurnns of the worksheet Cedar River Corporation started operations on July 1, 2018. The transactions that occurred during the month were journalized and posted, and a trial balance was prepared at the end of the 5 month. The month-end adjusting entries are to be journalized and posted to T-accounts. A worksheet is to be used to help prepare the adjusted trial balance. 6 7 Requirements B 1. Use Excel to journalize the adjusting entries. Use the blue shaded areas for inputs. To record the account name in the journal, click in the Account and Explanation column. A drop down arrow will appear to the right. Click the arrow and select an account from the chart of accounts. Use the explanation to help you with the entry. a. Date Account and Explanation DR CR Sie cami 10 11 Indent the account name of the account to be credited using the indent button on the Home tab. Click the increase Indent button twice. 12 a. 13 14 15 16 17 19 2. Once the adjustments have been journalized, post the amounts to the correct side of the T-account. (Note that the balance at the end of the month has been posted as a single entry.l Accounts with a zero balance have the cell with the zero locked. Enter adjusting entry into another cell. The T-account totals will be calculated automatically. b. Total debits should equal total credits. The debit credit balance checks for the trial balance and the adjusted trial balance appear to the right in red. 3. Use a formula to fill in the Adjustment debit and credit columns on the worksheet by referencing the T account adjustment(s). 4. Use a formula to add or subtract the adjustments to the trial balance amounts to create the adjusted trial balance columns. 5. Use a formula to total the Adjustments and Adjusted Trial Balance columns 6. On the Worksheet Format the cells requiring dollar signs. Forn he cells requiring a single underline and cells requiring double underlines Bold face the totals. 0 a. 22 24 Excel Skills: 1. Enter numbers or text into cells. 2. Use Excel's data validation to select account names in journal entries 27 3. Create formulas to add trial balance amounts to adjustment amounts to derive the adjusted trial balance. 28 4. Select the number format (dollar signs). 09 5. Select the border single underline, double underline). 90 6. Select the boldface font Instructions Adjusting Entries | T-Accounts Worksheet 1 Requirements 2 Journalize the adjusting entries. Use the blue shaded areas for inputs 3. To record the account name in the journal, click in the Account and Explanation column. A drop down arrow will appear to the right 4 click the arrow and select an account from the chart of accounts. Use the explanation to help you with the entry. 5. Indent the account name of the account to be credited using the indent button on the Home tab. Click the increase indent button twice. 5 7 Account and Explanation DR Date Jul 31 CR 8 9 10 11 12 To record rent expense. Krour months of rent was prepaid carlier in the month.) Calculation: $16,000 $4,000 13 24 31 14 To record office supplies used A physical count revealed $625 of office supplies on hand at the end of the month) Calculation: $950 - $625 = $325 15 16 17 15 19 31 To record depreciation on furniture (The furniture has a residual value of $4,000, and estimated Mes Testeminin directiva Colnulation 18.00 54/51/12=5370 20 21 22 23 24 31 25 25 To record depreciation on the building. (The building has a residual value of $24,000, and estimated useful life of 20 years. Use straight line depreciation. Calculation: ($120.000 - 50.000)/201/12 - $400 27 28 31 29 To record serwce revenue comed that was collected in advance (Cedar River has eamed $21,000 of the revenue that had been collected in advance! 30 31 32 31 33 TO Yue solos en (Cedar River pays $5,000 every Friday for a five-day work week Monday through Friday, July 31 is a Tuesday. Accrue two days of salaries) Calculation: $5,000 2/5 = $2,400 34 35 36 37 31 36 39 To ore interest expense. One month's interest on the Note Payabi 250 40 41 31 42 To ocorre service revenue. evenue of $700 has been earned. The client will pay next 43 44 45 47 48 49 90 1 Requirements Once the adjustments have been journalized, post the amounts to the correct side of the T-account. (Note that the balance at the end of the month has been posted as a single entry.) a. The T-account totals will be calculated automatically. b. Total debits should equal total credits. The debit-credit balance checks for the trial balance and the adjusted trial balance appear to the right in red. ASSETS LIABILITIES STOCKHOLDERS' EQUITY 2 3 4 5 6 7 8 9 10 Bal. 11 12 13 14 Debit-Credit Check DR CR 603,500 603,500 Trial Balance 0 0 0 Adj. Trial Balance Cash 355,750 Building 120,000 Accounts Payable 200 Bal. Common Stock 422,000 Bal. Rent Expense 0 Ball Bal 120.000 200 422.000 0 355.750 15 Accounts Receivable 8,000 Accumulated Dep- Building O Bal. Utilities Payable 300 Bal. Retained Earnings O Bal. Salaries Expense 24,000 Bal 8.000 300 24.000 16 Bal. 17 18 19 20 21 22 Bal. 23 24 25 Office Supplies 950 Furniture 22.000 Salaries Payable O Bal. Dividends 1,500 Supplies Expense 0 Bal. Bal Bal 950 22.000 0 1.500 0 Accumulated Dep Furniture Prepaid Rent 16,000 Interest Payable O O Bal. Service Revenue 39,000 Bal. Utilities Expense 300 O Bal. 26 27 Bal. 28 29 Bal 16.000 O 300 30 39.000 Land 55,000 Unearned Revenue 22,000 Bal. Dep Expense - Building 0 Bal 31 32 Bal. 33 34 55.000 22.000 35 Notes Payable 120,000 Bal Dep Expense Furniture 0 Bal. 120,000 Interest Expense 36 37 38 39 40 41 42 43 44 45 46 47 Bal Use a formula to add or subtract the adjustments to the trial balance amounts to create the adjusted trial balance columns 1 Uses formula o lulell the Ndjuslintents and Aljusted Trial Belarke cours On the Worksheet: Format the cells requiring dollar signs. 7 Corinst the cells requiring single underline and cells requiring double underlines 2 Radiace the total CEDAR RIVER CORPORATION Worksheet July 31, 2018 10 11 2 13 14 Balance Sheet Trin Balance Debit Credit Adjustments Debit Credit Adjusted Trial Balance Debit Credit Income Statement Debit Credit 15 Account Title Debit Credit S 10 Cash 7 ccounts Receivable A pitiraturies a 19 Prepaid Rent 20 Land 8,008 950 16,000 55,000 120,000 22.000 $ 200 300 2 Accumulated Depreciation Building 3 Furniture 2 4 cuiruled Depreciatimi Turniture s Accounts payahla 0 Utilities Payable 7 Salaties Payable & Interest Payable 9 Unearned Revenue O NotePayable Cock 22.000 120,000 422.000 1.500 39,000 Fetained Farnings 3 Dividends 14 Service Revenue Es Rent Expense o Salaries Expense .7 Supplies Cxpense 24,000 300 8 9 Depreciation Expense Building 10 Depreciation Expense - Furniture 1 linterest Expense 12 Total $ 605,500 609.500 0 14 35 Instructions Adjusting Entries | T-Accounts Worksheet M P R S T U V X B D E F H H 1 L N 1 Chapter 2 Using Excel 3 P3-45 Using Excel to journalize and post adjusting entries, and to create the Adjustments and Adjusted Trial Balance colurnns of the worksheet Cedar River Corporation started operations on July 1, 2018. The transactions that occurred during the month were journalized and posted, and a trial balance was prepared at the end of the 5 month. The month-end adjusting entries are to be journalized and posted to T-accounts. A worksheet is to be used to help prepare the adjusted trial balance. 6 7 Requirements B 1. Use Excel to journalize the adjusting entries. Use the blue shaded areas for inputs. To record the account name in the journal, click in the Account and Explanation column. A drop down arrow will appear to the right. Click the arrow and select an account from the chart of accounts. Use the explanation to help you with the entry. a. Date Account and Explanation DR CR Sie cami 10 11 Indent the account name of the account to be credited using the indent button on the Home tab. Click the increase Indent button twice. 12 a. 13 14 15 16 17 19 2. Once the adjustments have been journalized, post the amounts to the correct side of the T-account. (Note that the balance at the end of the month has been posted as a single entry.l Accounts with a zero balance have the cell with the zero locked. Enter adjusting entry into another cell. The T-account totals will be calculated automatically. b. Total debits should equal total credits. The debit credit balance checks for the trial balance and the adjusted trial balance appear to the right in red. 3. Use a formula to fill in the Adjustment debit and credit columns on the worksheet by referencing the T account adjustment(s). 4. Use a formula to add or subtract the adjustments to the trial balance amounts to create the adjusted trial balance columns. 5. Use a formula to total the Adjustments and Adjusted Trial Balance columns 6. On the Worksheet Format the cells requiring dollar signs. Forn he cells requiring a single underline and cells requiring double underlines Bold face the totals. 0 a. 22 24 Excel Skills: 1. Enter numbers or text into cells. 2. Use Excel's data validation to select account names in journal entries 27 3. Create formulas to add trial balance amounts to adjustment amounts to derive the adjusted trial balance. 28 4. Select the number format (dollar signs). 09 5. Select the border single underline, double underline). 90 6. Select the boldface font Instructions Adjusting Entries | T-Accounts Worksheet 1 Requirements 2 Journalize the adjusting entries. Use the blue shaded areas for inputs 3. To record the account name in the journal, click in the Account and Explanation column. A drop down arrow will appear to the right 4 click the arrow and select an account from the chart of accounts. Use the explanation to help you with the entry. 5. Indent the account name of the account to be credited using the indent button on the Home tab. Click the increase indent button twice. 5 7 Account and Explanation DR Date Jul 31 CR 8 9 10 11 12 To record rent expense. Krour months of rent was prepaid carlier in the month.) Calculation: $16,000 $4,000 13 24 31 14 To record office supplies used A physical count revealed $625 of office supplies on hand at the end of the month) Calculation: $950 - $625 = $325 15 16 17 15 19 31 To record depreciation on furniture (The furniture has a residual value of $4,000, and estimated Mes Testeminin directiva Colnulation 18.00 54/51/12=5370 20 21 22 23 24 31 25 25 To record depreciation on the building. (The building has a residual value of $24,000, and estimated useful life of 20 years. Use straight line depreciation. Calculation: ($120.000 - 50.000)/201/12 - $400 27 28 31 29 To record serwce revenue comed that was collected in advance (Cedar River has eamed $21,000 of the revenue that had been collected in advance! 30 31 32 31 33 TO Yue solos en (Cedar River pays $5,000 every Friday for a five-day work week Monday through Friday, July 31 is a Tuesday. Accrue two days of salaries) Calculation: $5,000 2/5 = $2,400 34 35 36 37 31 36 39 To ore interest expense. One month's interest on the Note Payabi 250 40 41 31 42 To ocorre service revenue. evenue of $700 has been earned. The client will pay next 43 44 45 47 48 49 90 1 Requirements Once the adjustments have been journalized, post the amounts to the correct side of the T-account. (Note that the balance at the end of the month has been posted as a single entry.) a. The T-account totals will be calculated automatically. b. Total debits should equal total credits. The debit-credit balance checks for the trial balance and the adjusted trial balance appear to the right in red. ASSETS LIABILITIES STOCKHOLDERS' EQUITY 2 3 4 5 6 7 8 9 10 Bal. 11 12 13 14 Debit-Credit Check DR CR 603,500 603,500 Trial Balance 0 0 0 Adj. Trial Balance Cash 355,750 Building 120,000 Accounts Payable 200 Bal. Common Stock 422,000 Bal. Rent Expense 0 Ball Bal 120.000 200 422.000 0 355.750 15 Accounts Receivable 8,000 Accumulated Dep- Building O Bal. Utilities Payable 300 Bal. Retained Earnings O Bal. Salaries Expense 24,000 Bal 8.000 300 24.000 16 Bal. 17 18 19 20 21 22 Bal. 23 24 25 Office Supplies 950 Furniture 22.000 Salaries Payable O Bal. Dividends 1,500 Supplies Expense 0 Bal. Bal Bal 950 22.000 0 1.500 0 Accumulated Dep Furniture Prepaid Rent 16,000 Interest Payable O O Bal. Service Revenue 39,000 Bal. Utilities Expense 300 O Bal. 26 27 Bal. 28 29 Bal 16.000 O 300 30 39.000 Land 55,000 Unearned Revenue 22,000 Bal. Dep Expense - Building 0 Bal 31 32 Bal. 33 34 55.000 22.000 35 Notes Payable 120,000 Bal Dep Expense Furniture 0 Bal. 120,000 Interest Expense 36 37 38 39 40 41 42 43 44 45 46 47 Bal Use a formula to add or subtract the adjustments to the trial balance amounts to create the adjusted trial balance columns 1 Uses formula o lulell the Ndjuslintents and Aljusted Trial Belarke cours On the Worksheet: Format the cells requiring dollar signs. 7 Corinst the cells requiring single underline and cells requiring double underlines 2 Radiace the total CEDAR RIVER CORPORATION Worksheet July 31, 2018 10 11 2 13 14 Balance Sheet Trin Balance Debit Credit Adjustments Debit Credit Adjusted Trial Balance Debit Credit Income Statement Debit Credit 15 Account Title Debit Credit S 10 Cash 7 ccounts Receivable A pitiraturies a 19 Prepaid Rent 20 Land 8,008 950 16,000 55,000 120,000 22.000 $ 200 300 2 Accumulated Depreciation Building 3 Furniture 2 4 cuiruled Depreciatimi Turniture s Accounts payahla 0 Utilities Payable 7 Salaties Payable & Interest Payable 9 Unearned Revenue O NotePayable Cock 22.000 120,000 422.000 1.500 39,000 Fetained Farnings 3 Dividends 14 Service Revenue Es Rent Expense o Salaries Expense .7 Supplies Cxpense 24,000 300 8 9 Depreciation Expense Building 10 Depreciation Expense - Furniture 1 linterest Expense 12 Total $ 605,500 609.500 0 14 35 Instructions Adjusting Entries | T-Accounts Worksheet