Creation of financial statements I

After examining and analyzing the information provided, create a document in MS Excel to complete the following exercise: A. Performs the trial balance. B. Prepares the income statement. C. Prepares the owner's statement of owner equity. D . Prepares the balance sheet.

At Camino Real, Inc. the balance of accounts is as follows:

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