PROJECT: SPREADSHEET APPLICATIONS FOR BOOKKEEPING The Bernards had quite a successful year in their newly opened Pennsylvania store. Matt and Julie Bernard have engaged their bookkeeper, Barb Burke, to prepare the shops Trial Balance, Net Income Statement, and Balance Sheet, which will be forwarded to their CPA. The Pennsylvania shop will use the same Chart of Accounts set-up in Practice Set 1. Youll notice one or two accounts have been added for this final project. The shop has been open for eight months. The grand opening was on November 1st of last year. The stores fiscal year will be July 1stJune 30th. Barb Burke calculated the shops unadjusted trial balance sheet in May after the store had officially closed for the season. There are five separate worksheets for you to complete in this project. The worksheets are in an Excel format. The cells highlighted in light yellow are input cells. If you dont have Excel, youll need to manually calculate the worksheets. Be sure to read the all the instructions for this project and review the worksheets before you begin your work. Worksheet Overview 1. Use the Adjusted Trial Balance WorksheetProject, Part 1 (tab 1). The unadjusted balances have been inserted for your convenience. Enter the adjusting entries. (Specific information relating to these entries can be found below.) Calculate the Adjusted Trial Balance. This should be similar to a simplified version shown on page 178 in your textbook. Input from the Adjusted Trial Balance, the Balance Sheet, and the Income Statement. This should be similar to that shown on page 184 in your textbook. 2. Use Project, Part 2Aggregation of Income Account Worksheet (tab 2). Aggregate the Income Statement Accounts. This should be similar to that shown on pages 211 and 212 in your textbook, although the format is slightly different. If youll be completing the project without spreadsheet software, you can access PDF copies of the required worksheets in