Dr Cr

Cash 11400

Accounts Receivable 5620

Supplies 1050

Prepaid Insurance 2400

Equipment 30000

Notes Payable 10000

Accounts Payable 12350

Capital 20000

Dividends 600

Service Revenue 13620

Salaries and Wages Expense 2200

Travel Expense 1300

Rent Expense 1200

Miscellaneous Expense 200

Total 55970 55970

Other data:

1. Supplies on hand total $280.

2. Depreciation is $800 per quarter.

3. Interest accrued on 6-month note payable, issued January 1, $300.

4. Insurance expires at the rate of $200 per month.

5. Services performed but unbilled at March 31 total $2,030.

3. Using the ten-column worksheet prepared above as your data, prepare the income statement, statement of changes in equity and classified balance sheet in Excel in a separate page. Use formulas to generate all of the figures in the financial statement reports. (10 marks)