Hello I need assistance with the completion of the spreadsheet attached

Recording and Posting Adjusting Entries and Preparing an Adjusted Trial Balance:

Use the empty area on the bottom of the spreadsheet to show work and calculations.

You must enable macros in order fo Please visit the Microsoft Office Support sit Contact the World Campus Helpdesk s in order for this assignment to function. e Support site for documentation and instructions. us Helpdesk if you continue to have trouble. . Assignment number three The unadjusted trial balance on December 31 for Holmes and Watkins, Attorneys at Law is shown to entries is shown below: 1. Office supplies on hand totaled 2. Prepaid insurance expired totaled 3. The office equipment was purchased January 1 of the current year for the amount shown on the u useful life is 5 years, the residual valaue is $0, and we are calculating the depreciation for the entire 4. The building was purchased January 1 of the current year for the amount shown on the unadjusted life is 25 years, the residual valaue is $0, and we are calculating the depreciation for the entire year ( 5. Salaries owed to employees at year end: 6. income taxes owed at year end: 7. Unearned revenue that has been earned totaled: 8. Work performed but not yet billed (no cash has been received) totalled: Required: 1. Record each adjusting entry in the general journal (journal) using the account titles shown in the unadjuste 2. Post the adjusting entries to the ledger accounts (T-accounts). 3. Prepare an adjusted trial balance for Holmes and Watkins as of December 31 SCROLL RIGHT FOR GENERAL JOURNAL, LEDGER ACCOUNTS, AND ADJUSTED TRIAL BALA ignment number three kins, Attorneys at Law is shown to the right. The data developed for the adjusting ear for the amount shown on the unadjusted trial balance, the expected ing the depreciation for the entire year (12 months) e amount shown on the unadjusted trial balance, , the expected useful e depreciation for the entire year (12 months) Amount 1,026.00 1,095.00 Student Calc Student Calc 2,220.00 13,060.00 1,625.00 1,720.00 account titles shown in the unadjusted trial balance. mber 31 COUNTS, AND ADJUSTED TRIAL BALANCE (*N Holmes and Watkins, Attorneys at Law Unadjusted Trial Balance As of December 31, 20xx Accounts Cash Accounts receivable Office supplies Prepaid insurance Office equipment Accumulated depreciation, Office Equipment Building Accumulated depreciation, Building Accounts payable Salaries payable Income taxes payable Notes payable Unearned fees Common stock Dividends Fees earned Salaries expense Advertising expense Office supplies expense Insurance expense Income taxes expense Depreciation expense, Office Equipment Depreciation expense, Building Total Debit 13,511.00 9,680.00 Credit 2,304.00 1,215.00 7,183.00 308,575.00 11,912.00 113,674.00 3,036.00 156,653.00 1,271.00 80,849.00 15,543.00 6,842.00 366,124.00 366,124.00 Use the area below to show your work and calc (*Note: Your instructor may use this area to help review and resolve any inc General Journal (journal) Date Dec 31 AJE1 Accounts Dec 31 AJE2 Dec 31 AJE3 Dec 31 AJE4 Dec 31 AJE5 Dec 31 AJE6 Dec 31 AJE7 Dec 31 AJE8 our work and calculations. review and resolve any incorrect answers) Debit Credit Ledger accounts (T-accounts) Date Bal - Dec 31 Cash Debit $13,511.00 Credit Bal Date Bal - Dec 31 Accounts receivable Debit $9,680.00 Credit Office supplies Debit $2,304.00 Credit Prepaid insurance Debit $1,215.00 Credit Office equipment Debit $7,183.00 Credit Bal Date Bal - Dec 31 Bal Date Bal - Dec 31 Bal Date Bal - Dec 31 Bal Accumulated depreciation, Office Equipment Date Debit Credit Bal - Dec 31 $0.00 Bal Date Bal - Dec 31 Building Debit $308,575.00 Credit Bal Accumulated depreciation, Building Date Debit Credit Bal - Dec 31 $0.00 Bal ounts (T-accounts) Date Bal - Dec 31 Accounts payable Debit Holmes and Watkin Adjusted Tr As of Decem Credit $11,912.00 Accounts Bal Date Bal - Dec 31 Salaries payable Debit Credit $0.00 Bal Date Bal - Dec 31 Income taxes payable Debit Credit $0.00 Bal Date Bal - Dec 31 Notes payable Debit Credit $113,674.00 Bal Date Bal - Dec 31 Unearned fees Debit Credit $3,036.00 Bal Date Bal - Dec 31 Common stock Debit Credit $156,653.00 Total Bal Date Bal - Dec 31 Dividends Debit $1,271.00 Credit Bal Date Bal - Dec 31 Fees earned Debit Credit $80,849.00 Bal Date Bal - Dec 31 Salaries expense Debit $15,543.00 Credit Advertising expense Debit $6,842.00 Credit Bal Date Bal - Dec 31 Bal Date Bal - Dec 31 Office supplies expense Debit Credit $0.00 Bal Insurance expense Date Bal - Dec 31 Debit $0.00 Credit Bal Income taxes expense Date Debit Bal - Dec 31 $0.00 Credit Bal Depreciation expense, Office Equipment Date Debit Credit Bal - Dec 31 $0.00 Bal Depreciation expense, Building Date Debit Credit Bal - Dec 31 $0.00 Bal l Holmes and Watkins, Attorneys at Law Adjusted Trial Balance As of December 31, 20xx Accounts Debit Credit You must enable macros in order fo Please visit the Microsoft Office Support sit Contact the World Campus Helpdesk s in order for this assignment to function. e Support site for documentation and instructions. us Helpdesk if you continue to have trouble. s. Assignment number three The unadjusted trial balance on December 31 for Holmes and Watkins, Attorneys at Law is shown to entries is shown below: 1. Office supplies on hand totaled 2. Prepaid insurance expired totaled 3. The office equipment was purchased January 1 of the current year for the amount shown on the u useful life is 5 years, the residual valaue is $0, and we are calculating the depreciation for the entire y 4. The building was purchased January 1 of the current year for the amount shown on the unadjusted life is 25 years, the residual valaue is $0, and we are calculating the depreciation for the entire year ( 5. Salaries owed to employees at year end: 6. income taxes owed at year end: 7. Unearned revenue that has been earned totaled: 8. Work performed but not yet billed (no cash has been received) totalled: Required: 1. Record each adjusting entry in the general journal (journal) using the account titles shown in the unadjuste 2. Post the adjusting entries to the ledger accounts (T-accounts). 3. Prepare an adjusted trial balance for Holmes and Watkins as of December 31 SCROLL RIGHT FOR GENERAL JOURNAL, LEDGER ACCOUNTS, AND ADJUSTED TRIAL BALAN ignment number three tkins, Attorneys at Law is shown to the right. The data developed for the adjusting Amount 1,026.00 1,095.00 ear for the amount shown on the unadjusted trial balance, the expected Student Calc ting the depreciation for the entire year (12 months) e amount shown on the unadjusted trial balance, , the expected useful he depreciation for the entire year (12 months) Student Calc 2,220.00 13,060.00 1,625.00 1,720.00 account titles shown in the unadjusted trial balance. mber 31 COUNTS, AND ADJUSTED TRIAL BALANCE U (*N Holmes and Watkins, Attorneys at Law Unadjusted Trial Balance As of December 31, 20xx Accounts Cash Accounts receivable Office supplies Prepaid insurance Office equipment Accumulated depreciation, Office Equipment Building Accumulated depreciation, Building Accounts payable Salaries payable Income taxes payable Notes payable Unearned fees Common stock Dividends Fees earned Salaries expense Advertising expense Office supplies expense Insurance expense Income taxes expense Depreciation expense, Office Equipment Depreciation expense, Building Total Debit 13,511.00 9,680.00 Credit 2,304.00 1,215.00 7,183.00 308,575.00 11,912.00 113,674.00 3,036.00 156,653.00 1,271.00 80,849.00 15,543.00 6,842.00 366,124.00 366,124.00 Use the area below to show your work and calcu (*Note: Your instructor may use this area to help review and resolve any inc General Journal (journal) Date Dec 31 AJE1 Dec 31 AJE2 Dec 31 AJE3 Dec 31 AJE4 Dec 31 AJE5 Accounts Office Supplies Expense Office Supplies Insurance Expense Prepaid Insurance Expense Depreciation Expense,Office Equipmet Accumulated Depreciation,Office Equipmet Depreciation Expense,Building Accumulated Depreciation,Building Salaries Expense Debit 1278.00 1278.00 120.00 120.00 1436.60 1436.60 12343.00 12343.00 2220.00 Salaries Payable Dec 31 AJE6 Income Tax expense 2220.00 13060.00 Income Taxes Payable Dec 31 AJE7 Unearned Fees 13060.00 1625.00 Fees Earened Dec 31 AJE8 Credit Account Receivable 1625.00 1720.00 Fees Earened our work and calculations. review and resolve any incorrect answers) 1720.00 Ledger accounts (T-accounts) Date Bal - Dec 31 Cash Debit $13,511.00 Bal $13,511.00 Date Bal - Dec 31 31-Dec Bal Date Bal - Dec 31 31-Dec Bal Date Bal - Dec 31 31-Dec Bal Date Bal - Dec 31 Bal Accounts receivable Debit $9,680.00 $1,720.00 Credit Credit $11,400.00 Office supplies Debit $2,304.00 Credit $1,278.00 $1,026.00 Prepaid insurance Debit $1,215.00 Credit $120.00 $1,095.00 Office equipment Debit $7,183.00 Credit $7,183.00 Accumulated depreciation, Office Equipment Date Debit Credit Bal - Dec 31 $0.00 31-Dec $1,436.60 Bal $1,436.60 Date Bal - Dec 31 Building Debit $308,575.00 Bal $308,575.00 Credit Accumulated depreciation, Building Date Debit Credit Bal - Dec 31 $0.00 31-Dec $12,343.00 Bal $12,343.00 ounts (T-accounts) Date Bal - Dec 31 Accounts payable Debit Holmes and Watkins Adjusted Tri As of Decemb Credit $11,912.00 Accounts Cash Accounts receivable Bal Date Bal - Dec 31 31-Dec $11,912.00 Salaries payable Debit Bal Date Bal - Dec 31 31-Dec $2,220.00 Income taxes payable Debit Bal Date Bal - Dec 31 Notes payable Debit Credit $113,674.00 $113,674.00 Unearned fees Debit Credit $3,036.00 $1,625.00 Bal Date Bal - Dec 31 Credit $0.00 $13,060.00 $13,060.00 Bal Date Bal - Dec 31 31-Dec Credit $0.00 $2,220.00 $1,411.00 Common stock Debit Credit $156,653.00 Office supplies Prepaid insurance Office equipment Accumulated depreciation, Office Equipme Building Accumulated depreciation, Building Accounts payable Salaries payable Income taxes payable Notes payable Unearned fees Common stock Dividends Fees earned Salaries expense Advertising expense Office supplies expense Insurance expense Income taxes expense Depreciation expense, Office Equipment Depreciation expense, Building Total Bal Date Bal - Dec 31 Bal Date Bal - Dec 31 31-Dec 31-Dec Bal Date Bal - Dec 31 31-Dec Bal Date Bal - Dec 31 Bal Date Bal - Dec 31 31-Dec Bal $156,653.00 Dividends Debit $1,271.00 Credit $1,271.00 Fees earned Debit Salaries expense Debit $15,543.00 $2,220.00 Credit $80,849.00 $1,625.00 $1,720.00 $84,194.00 Credit $17,763.00 Advertising expense Debit $6,842.00 Credit $6,842.00 Office supplies expense Debit Credit $0.00 $1,278.00 $1,278.00 Insurance expense Date Bal - Dec 31 31-Dec Bal Debit $0.00 $120.00 $120.00 Income taxes expense Date Debit Bal - Dec 31 $0.00 31-Dec $13,060.00 Bal Credit Credit $13,060.00 Depreciation expense, Office Equipment Date Debit Credit Bal - Dec 31 $0.00 31-Dec $1,436.60 Bal $1,436.60 Depreciation expense, Building Date Debit Credit Bal - Dec 31 $0.00 31-Dec $12,343.00 Bal $12,343.00 Holmes and Watkins, Attorneys at Law Adjusted Trial Balance As of December 31, 20xx Accounts h ounts receivable ce supplies aid insurance ce equipment umulated depreciation, Office Equipment ding umulated depreciation, Building ounts payable ries payable me taxes payable es payable arned fees mon stock dends earned ries expense ertising expense ce supplies expense rance expense me taxes expense reciation expense, Office Equipment reciation expense, Building l Debit 13511.00 11400.00 Credit 1026.00 1095.00 7183.00 1436.60 308575.00 12343.00 11912.00 2220.00 13060.00 113674.00 1411.00 156653.00 1271.00 84194.00 17763.00 6842.00 1278.00 120.00 13060.00 1436.60 12343.00 396903.60 396903.60