M2 Assignment 3: Excel Problems

Thman2c

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, March 4, 2015 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