After examining and analyzing the information provided, create a document in MS Excel to complete the following exercise:

A. Make the trial balance. B. Prepare the income statement. C. Prepare the statement of owner equity. D. Prepare the balance sheet.

At Camino Real, Inc. the account balances are as follows:

Account Balance Cash 425,000

Prepaid insurance 14,000

Materials (supplies) 15,000

Equipment 27,000

Accounts receivable (accounts receivable) 123,000

Notes payable 53,600

Accounts payable 26,500

Carmelo Ruiz, capital 228,100

Carmelo Ruiz, retirement (drawing) 20,000

Fee earned 896,300

Utilities expense 9,000

Salary expense 536,000

Advertising expense 3,500

Rent expense 32,000