Question

Using the account titles listed below, create these financial statements for EXAMPLE COMPANY for the year ended December 31, XXXX:

income statement,

statement of retained earnings,

and balance sheet.

Please prepare your answers in a spreadsheet that you create, using proper spreadsheet techniques. You don't need to add numbers.

Account Title

Account Payable

Account Receivable

Accumulated Depreciation - Building

Accumulated Depreciation - Office

Equipment

Accumulated Depreciation - Store

Fixtures

Administration Salaries Expense

Advertising expense

Allowance for Doubtful Accounts

Beginning Retained Earnings

Building

Cash

Common Stock

Cost of Good Sold

Credit Card Revenues

Depreciation Expense - Building

Depreciation Expense - Office

Equipment

Depreciation Expense - Store Equpment

Dividends on Common Shares

Employer Taxes payable

Freight expense

Gains on Sales of Equipment

Insurance expense

Interest Expense

Interest Payable

Inventory

Land

Mortgage Payable

Notes Payable

Notes Receivable

Office equipment

Office supplies

Office Supplies Expense

Paid in Excess of Par

Patents

Petty Cash

Prepaid Insurance

Rent expense

Rent revenue

Salaries Payable

Sales

Sales Commissions

Sales discounts

Sales returns

Sales Tax payable

Store fixtures

Supplies

Supplies Expense

Unearned revenue

Unfunded Pension Due

Utilities Expense