Please use the Adjusted Trial Balance for Rockford Corporation included as a separate

Excel file to complete this assignment. Note that the Excel file contains tabs for the individual

worksheets designated for each of the required statements or assignments. Please name the

workbook you submit as specified below.

In addition to the content, you will be assessed on your mastery of the following skills:

(1) correct data entry,

(2) correct and accessible formulas, (3) formatting of column headings

and labels,

(4) merger and centering of titles, and (5) overall spreadsheet formatting and

printing.

You are asked to prepare the following statements:

Balance Sheet at December 31, 2019

In addition to the above statements, you are to prepare the journal entries necessary to

close the books for Rockford Corporation on December 31, 2019

Note: The following relates to Common Stock

Authorized 1,000,000 shares

Issued 100,000 shares

Outstanding 65,000 shares