Make 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 the month 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.

The 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 122,850

Notes payable 42,800

Accounts payable 50,000

Carmelo Ruiz, capital 169,100

Carmelo Ruiz, retirement (drawing) 20,000

Income (fee earned) 840,500

Utilities expense 24,500

Salary expense 620,000

Advertising expense 3,500

Rent expense 45,000