Assignment 3: Excel Problems

Requirements

1. Complete the accounting work sheet at December 31.

2. Journalize and post the closing entries at December 31. Denote each closing amount as Clo and an account balance as Bal.

3. Prepare a classified balance sheet at December 31.

Requirements

1. Prepare an accounting work sheet.

2. Prepare an income statement, statement of owner’s equity, and balance sheet using the report format.

3. Prepare closing entries for the month.

4. Prepare a postclosing trail balance.