Creacin de estados financieros I

Luego de examinar y analizar la informacin provista, crea un documento en MS Excel para completar el siguiente ejercicio:

A. Realiza el balance de comprobacin (trial balance).

B. Prepara el estado de ingresos y gastos (income statement).

C. Prepara el estado de capital del dueo (statement of owner equity).

D .Prepara el estado de situacin (balance sheet).

En Camino Real, Inc. los balances de las cuentas son los siguientes:

Cuenta Balance

Efectivo (cash) 425,000

Seguro prepagado (prepaid insurance) 14,000

Materiales (supplies) 15,000

Equipo (equipment) 27,000

Cuentas por cobrar (accounts receivable) 123,000

Notas por pagar (notes payable) 53,600

Cuentas por pagar (accounts payable) 26,500

Carmelo Ruiz, capital 228,100

Carmelo Ruiz, retiro (drawing) 20,000

Ingresos (fee earned) 896,300

Gasto de utilidades (utilities expense) 9,000

Gastos de salario (salary expense) 536,000

Gastos de publicidad (advertising expense) 3,500

Gastos de renta (rent expense) 32,000

------------

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