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 |
Leave a reply