Millie and Milo Wermz are the owners of The Book Wermz. The business is operated as a corporation. The Wermz invested $100,000 in the company when they started it in 1996. This investment represents the company’s stockholders’ equity. The company’s account balances on September 30, 2004—the end of the fiscal year—were: Cash $4,238.72, Inventory of Books $235,892.35, Supplies $2,343.28, Equipment $43,297.00, Notes Payable $123,452.88, Investment by Owners $100,000, and Retained Earnings $62,318.47.Summary transactions for The Book Wermz for October 2004 included:

Cash sales ............$38,246.50

Cost of goods sold ........ 27,318.93

Required

Use a spreadsheet to keep track of account balances for The Book Wermz. Enter the titles of accounts in row 1. Use column A for dates. Enter account balances for September 30, 2004 in row 2. A partial spreadsheet is illustrated below as an example: