M2Assignment 3:
|
Assignment 3: Excel Problems
At the end of each module, you will apply the module’s concepts by completing comprehensive assignments from the textbook.
Complete problems P3-43 (p. 185) and P4-38 (p. 252) in your text book.
Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes.
By Wednesday, December 17, 2014 deliver your assignment to the M2: Assignment 3 Dropbox.
Create the file with the following name: LastnameFirstInitial_M2A3.Excel.xls.
|
Assignment 3 Grading Criteria
|
Maximum Points
|
|
P3-43:
|
|
|
Open addition T accounts
|
3
|
|
Journalize transactions December 21-30
|
4
|
|
Post to T-accounts
|
2
|
|
Prepare trial balance
|
5
|
|
Adjusting entries made in adjustments column
|
3
|
|
Journalize and post adjusting entries and denoted adjusting amounts
|
4
|
|
Prepare income statement and retained earnings
|
5
|
|
P4-38:
|
|
|
Complete accounting worksheet at 12/31
|
6
|
|
Journalize and post closing entries at 12/31
|
6
|
|
Prepare classified balance sheet
|
7
|
|
Accuracy and timeliness
|
5
|
|
Total:
|
50
|
|
