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 Week 2, Day 7 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

Field of study: 
No answers yet