ACC504
Case Study 1 The complete accounting cycle.
The entire Case Study is due Sunday at midnight mountain time at the end
of Week 3.
This Case Study is worth 100 points or 10% of your final course grade.
Hint for success: Review the Week 2 Lecture prior
to starting this project.
There are also hints contained within certain cells on some of the worksheet tabs.
You can hover over the red pointer at the top right-hand corner of the cell to read the hint.
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 March 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.
TUTORIAL
PREVIEW
File name: ACCT504-Case-Study1.xls File type: XLS PRICE: $40
CASE STUDY 1 -THE COMPLETE ACCOUNTING CYCLE
This Case Study relates to TCOs D and E and Chapters 3 and 4.
MAKE SURE TO COMPLETE ALL REQUIREMENTS WHICH ARE LISTED BELOW.
There are 10 sheets in the Workbook including this one.
All of the Information 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 TB
|
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 TB
|
There are also hints contained within certain cells on some of the worksheet tabs.
You can hover over the red pointer at the top right-hand corner of the cell to read the hint.
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 March 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.
The
statement of cash flows is a required financial statement, but is not
required for this project.
|
|||||||||
Flower Landscaping Corporation
|
Flower Landscaping Corporation
|
Flower Landscaping Corporation
|
|||||||
Income Statement
|
Statement of Retained Earnings
|
Balance Sheet
|
|||||||
For the Month Ending March 31
|
For the Month Ending March 31
|
March 31
|
|||||||
Revenues:
|
Retained
Earnings, March 1
|
$ -
|
Assets:
|
||||||
Landscaping
Revenue
|
$10,200
|
Add:
Net Income
|
1,855
|
Cash
|
$69,250
|
||||
Subtotal
|
1,855
|
Prepaid
Insurance
|
3,025
|
||||||
Expenses:
|
Less:
Dividends
|
1,000
|
Supplies
|
475
|
|||||
Rent
Expense
|
4,500
|
Retained
Earnings, March 31
|
$855
|
Equipment
|
9,000
|
||||
Salaries
Expense
|
2,200
|
Less:
Accum. Depr.
|
150
|
8,850
|