Umbrella Corporation provides consulting for virology and pharmaceutical research. Umbrella Corporation prepared the following end-of-period spreadsheet at December 31, 2002, the end of the fiscal year:

Instructions

1. Prepare an income statement for the year ended December 31.
2. Prepare a retained earnings statement for the year ended December 31.
3. Prepare a balance sheet as of December 31.
4. Based upon the end-of-period spreadsheet, journalize the closing entries.
5. Prepare a post-closing trial balance

Umbrella Corporation End-of-Period Spreadsheet For the Year Ended December 31, 2002 Unadjusted Trial Balance Adjustments Account Title Dr. Cr. Dr. Cr. Cash 11,800 Accounts Receivable 37,500 11,300 Supplies 2,840 2,000 Prepaid Insurance 4,200 4,000 Land 98,000 Building 450,000 Accumulated Depreciation - Building 230,000 11,000 Equipment 107,000 Accumulated Depreciation - Equipment 87,300 6,550 Accounts Payable 21,690 Wages Payable 5,900 Common Stock 75,000 Retained Earnings 145,000 Dividends 10,000 Fees Earned 363,700 11,300 Wages Expense 160,000 5,900 Advertising Expense 18,000 Insurance Expense 4,000 Utilities Expense 11,000 Supplies Expense 2,000 Depreciation Expense - Building 11,000 Repairs Expense 8,050 Depreciation Expense - Equipment 6,550 Miscellaneous Expense 4,300 922,690 922,690 40,750 40,750 Adjusted Trial Balance Dr. Cr. 11,800 48,800 840 200 98,000 450,000 241,000 107,000 93,850 21,690 5,900 75,000 145,000 10,000 375,000 165,900 18,000 4,000 11,000 2,000 11,000 8,050 6,550 4,300 957,440 957,440