Chapter 4, Problem P4.41CT

Using Excel to prepare financial statements, closing entries, and the post-closing trial balance
Download an Excel template for this problem online in MyAccountingLab or athttp:www.pearsonhighered.com/Horngren. Cedar River Company 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.
1. Use formulas to total the columns.
2. Use a formula to determine the amount of the net income or net loss.
3. Format the cells requiring dollar signs.
4. Boldface the totals.
2. Prepare the income statement, the statement of owner's equity, and a classified balance sheet.
1. Use the Increase Indent button on the Home tab to indent items.
2. Use formulas to sum items.
3. Format the cells requiring dollar signs.
4. 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 tiles are available when you click the down-arrow.
1. Format the cells requiring dollar signs.
2. Boldface the totals.
Format the cells requiring double underlines.