Cedar River Corporation started operations on July 1, 2018. On July 31, a trial balance was prepared, adjusting entries were journalized and posted, and an adjusted trial balance was completed. A worksheet is to be used to help prepare the financial statements and the post-closing trial balance.

Requirements
1. Use Excel to complete the Income Statement and Balance Sheet columns of the worksheet. Carry numbers from the adjusted trial balance columns of the worksheet to the income statement and balance sheet columns using Excel formulas.

a. Use formulas to total the columns.
b. Use a formula to determine the amount of the net income or net loss.
c. Format the cells requiring dollar signs.
d. Boldface the totals.

2. Prepare the income statement, the statement of retained earnings, and a classified balance sheet.

a. Use the Increase Indent button on the Home tab to indent items.
b. Use formulas to sum items.
c. Format the cells requiring dollar signs.
d. Format the cells requiring double underlines.

3. Journalize the closing entries. The account titles are available when you click on the down arrow. Indent the account to be credited.
4. Post the closing entries to the T-accounts. Use cell references from the closing entries.
5. Complete the post-closing trial balance using formulas referencing the T-accounts. The account titles are available when you click the down-arrow.

a. Format the cells requiring dollar signs.
b. Boldface the totals.
c. Format the cells requiring double underlines.