Prepare the adjusted trial balance on December 31, 20X6. Attach your response in an excel or word file.

Questions 4 through 10 are based on the following December 31, 20X6 year-end account balances for XYZ Co. after adjusting entries had been prepared but before the books were closed for the year.

Cash...250,000

Accounts receivable...680,000

Marketable securities...60,000

Prepaid insurance.35,000

Prepaid rent..30,000

Office equipment.....620,000

Accumulated depreciation: equipment...200,000

Land750,000

Accounts payable306,000

Dividends payable 50,000

Interest payable... 8,750

Income tax payable...30,000

Unearned client service revenue..180,000

Notes payable (long-term)...350,000

Common stock.750,000

Retained earnings.....315,200

Dividends.......75,000

Client service revenue...1,200,000

Travel expense....28,000

Office supplies expense..20,000

Advertising expense45,000

Salary expense...400,000

Utility expense.....40,000

Depreciation expense: equipment25,000

Interest expense....17,500

Insurance expense.....52,000

Rent expense..175,000

Income tax expense..87,450