Perform the required operation in the excel.

Management Tools Assignment # 1 and #2
Use this Excel Workbook for Units 02 & 03 Assignments
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 Instru
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
Additional Notes:
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.”Be sure that you use proper formatting when
he assessment values.
he Unit readings, Assignment Instructions and this Workbook.