Listed below are account balances and other data for The Book Wermz at the close of November 30, 2004. Revenue and expense account balances are for the month of November. All amounts are dollars except shares of common stock. The Book Wermz operates as a corporation.

Accounts payable ...............$ 6,131.77

Accounts receivable ............... 375.00

Accumulated depreciation ........... 13,891.82

Cash ..................... 12,307.99

Contributed capital .............. 100,000.00

Cost of goods sold .............. 30,937.32

Depreciation expense ............. 817.20

Dividends paid ................ 1,500.00

Equipment ................. 57,650.00

Income tax expense ............... 897.45

Interest expense ............... 932.03

Inventory ................... 235,255.06

Notes payable, current portion .......... 1,122.77

Notes payable, long-term ............ 120,084.57

Rent expense ................ 1,738.15

Sales .................... 43,312.25

Service revenues ................. 1,566.23

Shares of common stock .............. 1,000

Supplies ................... 2,130.12

Supplies expense ................ 2,411.53

Wages expense ................ 4,697.35

Wages payable ................ 1,150.68

Required

Use the account balances to produce an income statement, a statement of stockholders' equity, and a balance sheet for The Book Wermz in a spreadsheet. The financial statements should follow the examples illustrated in Chapter F4. The balance sheet should contain columns for November and October. October 31 balances should be obtained from data provided in the Chapter F3 spreadsheet problem.