Directions Using the Chart of Accounts and Unadjusted Trial Balance below, prepare the following using the MS Excel files provided to you in the folder for Part 2 of the Comprehensive Project.

a) Perform the end of year adjusting entries. Use letters in place of the date

b) Complete the end of year worksheet

c) Prepare and Adjusted Trial Balance as of December 31, 2022

the Accounts Receivable and Accounts Payable Accounts must be shown in consolidated format on the Unadjusted Trial Balance and Adjusted Trial Balance.