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, July 30, 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
|
0 comments