Note that you may have to resize the columns to fit the words. Use Merge and Center for the headings.

3. Use the following information to prepare adjusting journal entries. Put your numbers directly in the worksheet, the debits in the debit column, and the credits in the credit column. It might help if you write out the journal entries by hand first.

a. Supplies of $1,500 have been used during the year.

b. The depreciation on the equipment was calculated as $5,000 for the year.

c. Interest on the note is $250 for the year. d. All the deferred revenue was earned by the end of the year.

Check figure - total adjustments should be $8,750.

4. Fill in the adjusted trial balance numbers using ONLY references or formulas. For example, the adjusted cash reference would be "=B6" if you set up your worksheet like the sample above. Any accounts that have been adjusted need their new balances, so add/subtract the effect of the adjustment to get the new balance.

Check figure - total adjusted trial balance should be $98,750.

5. Fill in the rest of the worksheet - the income statement and balance sheet columns - again using only references or formulas. See the sample worksheet at the end of this document to help with the treatment of net income.

Check figure - net income should be $25,250.

Before handing in your file, be sure to check your formatting. Put the Trial Balance worksheet first, on the left, and the Worksheet second or on the right.

Format all your numbers as noted in part 1, using $ and underlines where appropriate.

Go to the Worksheet and click CTRL and at the same time. That will show

H25