Hi, can you help me with part 2 of this assignment. The pdf file has the instructions. The tabs that need to be completed are the tabs that say adjusting entries due in unit 3, adjusted TB due in unit 3, financial statements unit 3, closing entries unit 3 and post closing TB unit 3.

Unit 3 [AC499: Bachelor's Capstone in Accounting] Unit 3 Assignment: Management Tools Applications Continue with the Assignment from Unit 2, using the same Excel Template and complete the following steps: 1. Prepare/Journalize the Adjusting entries A-F. a. b. c. d. e. f. Insurance expired during June is $150. Supplies on hand on June 30 are $1,020. Depreciation of office equipment for June is $500. Accrued receptionist salary on June 30 is $120. Rent expired during June is $1,500. Unearned fees on June 30 are $2,000. 2. Post the adjusting entries to the General Ledger. 3. Prepare an income statement, a statement of owner's equity, and a balance sheet. 4. Journalize and post the closing entries. (Income Summary is account #33 in the chart of accounts.) 5. Prepare a post-closing trial balance. Notes: 1) You will be required to make all corrections to the Excel Workbook as noted in the Unit 2 Assignment Feedback. Any errors from Unit 2 that are not corrected will result in additional deductions in Unit 3. 2) Review the transaction descriptions very carefully. The adjustment required depends on the wording of the transaction description. That is, does the transaction give provide the amount of the adjustment, or does the description give the amount of the ending balance required after the adjustment? Unit 3 [AC499: Bachelor's Capstone in Accounting] Review the Rubric below before starting the Assignment. AC 499 Unit 3 Rubric: Your score Possible Points 1-Prepare the Adjusting entries A-F. 0 5 2-Journalize and Post the adjusting entries. 0 5 a. an income statement, 0 5 b. a statement of owner's equity, 0 5 c. a balance sheet. 0 10 4-Journalize and post the closing entries. 0 5 5-Prepare a post-closing trial balance. 0 5 Preliminary Totals 0 40 0 40 Category 3-Prepare: Additional Items: Deductions for uncorrected errors from Unit 2 (Enter a negative amount -->) Late Penalty (If applicable) (Enter as a negative amount ->) Final Total Instructor Comments Management Tools Assignment # 1 and #2 Additional Notes: Use this Excel Workbook for Units 02 & 03 Assignments 1) All Journal Entries MUST include the "Explanation" line. 2) All Debit account entry lines MUST be fully left-justified. 3) All Credit account entry lines MUST be indented 4 or 5 spaces, UNIFORMLY. 4) You will be required to create at least ONE additional general Ledger Account to accommodate a few Journal Entries. You may create one "Miscellaneous Expense" account in the General Ledger to accommodate all of the otherwise unspecified entries, OR you may create 2 or 3 new G/L accounts. For example "Utilities." 4) Be sure that you use proper formatting when you create the Financial Statements. For example, all underlining and "$" signs must be properly formatted. 5) These templates are NOT fully "pre-formatted". You must re-format them for proper presentation in many places. Due Dates: Assignment #1-Due Unit 2 Assignment #2-Due Unit 3 The Unit 2 Assignment is worth 40 points The Unit 3 Assignment is worth 40 points BE SURE TO COMPLETE ALL REQUIREMENTS LISTED BELOW. There are 11 Sheets in the Workbook including this one. The Final 2 sheets are the Unit 2 and Unit 3 rubrics. They will help you understand the assessment values. All of the Information you need for successful completion the Project is located in the Unit readings, Assignment Instructions and this Workbook. Requirements Assignment #1 Due in Unit 02 Requirement 1 - Prepare the Journal Entries in the General Journal Requirement 2 - Post Journal Entries to the General Ledger Requirement 3 - Prepare an Unadjusted Trial Balance Sheet in Workbook Journal Entries General Ledger Unadjusted TB Assignment #2 - Due in Unit 03 Requirement 4 - Prepare the Adjusting Entries Requirement 5 - Post Adjusting Entries to the General Ledger Requirement 6 - Prepare an Adjusted Trial Balance Requirement 7 - Prepare the Financial Statements Requirement 8 - Prepare the Closing Entries Requirement 9 - Post Closing Entries to the General Ledger Requirement 10 - Prepare the Post Closing Trial Balance Adjusting Entries General Ledger Adjusted TB Financial Statements Closing Entries General Ledger Post Closing TB ) Late Penalty (If applicable) (Enter as a negative amount -->) Final Total Instructor Comments AC 499 Unit 3 Rubric: Your score Possible Points 1-Prepare the Adjusting entries A-F. 0 5 2-Journalize and Post the adjusting entries. 0 5 a. an income statement, 0 5 b. a statement of owner's equity, 0 5 c. a balance sheet. 0 10 4-Journalize and post the closing entries. 0 5 5-Prepare a post-closing trial balance. 0 5 0 40 0 40 Category 3-Prepare: Preliminary Totals Additional Items: Deductions for uncorrected errors from Unit 2 (Enter a negative amount -->) Late Penalty (If applicable) (Enter as a negative amount -->) Final Total Instructor Comments