ACCT504_W3_Case_Study.xlsx - CASE STUDY THE COMPLETE...

CASE STUDY - THE COMPLETE ACCOUNTING CYCLE
Name: ___________________________________
This Case Study is worth 100 points, or 10% of your final course grade.
This Case Study relates to TCOs E and F, and Chapters 2 and 3.
MAKE SURE TO COMPLETE ALL REQUIREMENTS WHICH ARE LISTED BELOW.
There are 10 sheets in the Workbook, including this one.
All of the information that you need for the project is located in this Workbook.
Requirements Sheet in Workbook
Requirement 1—Prepare the Journal Entries in the General Journal Journal Entries
Requirement 2—Post Journal Entries to the General Ledger General Ledger
Requirement 3—Prepare a Trial Balance Trial Balance
Requirement 4—Prepare the Adjusting Entries Adjusting Entries
Requirement 5—Post Adjusting Entries to the General Ledger General Ledger
Requirement 6—Prepare an Adjusted Trial Balance Adjusted Trial Balance
Requirement 7—Prepare the Financial Statements Financial Statements
Requirement 8—Prepare the Closing Entries Closing Entries
Requirement 9—Post Closing Entries to the General Ledger General Ledger
Requirement 10—Prepare the Post Closing Trial Balance Post-Closing Trial Balance
Hint for success: Review the Week 2 Lesson prior to starting this project.
There are also hints contained within certain cells on some of the Worksh
You can hover over the red pointer at the top right-hand corner of the cel
Hints are provided for the following balances:
1) The debits for the journal entries are on the Journal Entries tab.
2) The credits for the journal entries are on the Journal Entries tab.
3) The cash balance is on the General Ledger tab.
4) The debits for the trial balance are on the Trial Balance tab.
5) The credits for the trial balance are on the Trial Balance tab.
6) The debits for the adjusted trial balance are on the Adjusted Trial Balance tab.
7) The credits for the adjusted trial balance are on the Adjusted Trial Balance tab.
8) Net income for the income statement is on the Financial Statements tab.
9) Retained earnings as of July 31 are on the Financial Statements tab.
10) Total assets for the balance sheet are on the Financial Statements tab.
11) Total liabilities and shareholders' equity for the balance sheet are on the Financial Statements tab.
12) The debits for the post-closing trial balance are on the Post-Closing Trial Balance tab.
13) The credits for the post-closing trial balance are on the Post-Closing Trial Balance tab.

.
heet tabs.
ll to read the hint.