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 (notes payable) 43,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

PD: Updated the Notes Payable figure from 42,300 to $ 43,400 Notes payable 43,800.