Given the following year-end balances, prepare a multiple step income statement (on an excel sheet), statement of retained earnings (on an excel sheet), and a classified balance sheet on an excel sheet.

Accounts payable ..............................................................$2,550

Accounts receivable ..........................................................$3,550

Accumulated depreciation ................................................$6,250

Beginning retained income ...............................................$6,450

Cash ..................................................................................$2,300

Cost of goods sold .........................................................$52,300

Depreciation expense .......................................................$2,500

Dividends declared ..........................................................$8,800

Fixed assets ....................................................................$29,000

Income tax expense ........................................................$10,700

Interest expense ................................................................$1,150

Inventory ..........................................................................$6,250

Long-term note payable ..................................................$11,500

Paid-in capital ..................................................................$4,450

Prepaid rent .........................................................................$350

Rent expense ....................................................................$4,000

Sales .............................................................................$118,600

Wage expense ................................................................$31,900

Wages payable .................................................................$3,000