Makes a document in MS Excel with different tabs to:

A. Prepare the settings entries.

B. Making the entries in the ledger.

C. Prepare the adjusted trial balance.

Use the following information to complete the exercise:

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

2.At the end of January, the month of prepaid insurance, paid for the full year, was consumed.

3.Equipment depreciation is $1,500.

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

5.The balance sheets of the accounts before adjustments are as follows:

account Balance

Cash 200,550

Seguro prepagado(prepaid insurance) 25,000

Materials (supplies) 6,000

Equipment 35,000

Accounts receivable 122,850

Unpaid notes 42,800

Accounts payable 50,000

Carmelo Ruiz, capital 169,100

Carmelo Ruiz, retirement (drawing) 20,000

Ingresos(fee earned 839,500

Utilities expense 24,500

Salary expense 620,000

Advertising expense 3,500

Rent expense 45,000