Crea un documento en MS Excel con diferentes pestaas para:

A. Preparar las entradas de ajustes.

B. Realizar las entradas en el ledger.

C. Preparar el balance de comprobacin ajustado (adjusted trial balance).

Utiliza la siguiente informacin para completar el ejercicio:

• Al finalizar el mes de enero, Carnes del Pas tena materiales (supplies) por la cantidad de $2,000.
• Al finalizar el mes de enero, se consumi el mes de la cuenta de seguro prepagada (prepaid insurance), pagada por el ao completo.
• La depreciacin del equipo (equipment) es de $1,500.
• Hay una deuda de salario al 31 de enero de 2020 de $600.
• Los balances de las cuentas antes de los ajustes son los siguientes:

Cuenta Balance

Efectivo (cash) 200,550

Seguro prepagado (prepaid insurance) 25,000

Materiales (supplies) 6,000

Equipo (equipment) 35,000

Cuentas por cobrar (accounts receivable) 122,850

Notas por pagar (notes payable) 42,800

Cuentas por pagar (accounts payable) 50,000

Carmelo Ruiz, capital 169,100

Carmelo Ruiz, retiro (drawing) 20,000

Ingresos (fee earned) 839,500

Gasto de utilidades (utilities expense) 24,500

Gastos de salario (salary expense) 620,000

Gastos de publicidad (advertising expense) 3,500

Gastos de alquiler (rent expense) 45,000

Create a document in MS Excel with different tabs to:

A. Prepare the settings inputs.

B. Make the entries in the ledger.

C. Prepare the adjusted trial balance.

Use the following information to complete the exercise:

At the end of January, Carnes del Pas had materials (supplies) in the amount of $ 2,000.

At the end of January, the month of the prepaid insurance account, paid for the full year, was used up.

Equipment depreciation is $ 1,500.

There is a salary debt as of January 31, 2020 of $ 600.

The account balances before adjustments are as follows:

Account Balance

Cash 200,550

Prepaid insurance 25,000

Materials (supplies) 6,000

Equipment 35,000

Accounts receivable (accounts receivable) 122,850

Notes payable 42,800

Accounts payable 50,000

Carmelo Ruiz, capital 169,100

Carmelo Ruiz, retirement (drawing) 20,000

Income (fee earned) 839,500

Utilities expense 24,500

Salary expense 620,000

Advertising expense 3,500

Rent expense 45,000