Question: Create a document in MS Excel with different tabs for: A. Prepare definition entries. B. Make entries in the general ledger. C. Prepare the adjusted

Create a document in MS Excel with different tabs for: A. Prepare definition entries. B. Make entries in the general 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 (inputs) worth $3,000. At the end of January, the month of the prepaid insurance account, paid for the full year, was exhausted. Equipment depreciation is $1,800. There is a salary debt as of January 31, 2020 of $900. The account balances before adjustments are as follows: Account balance Cash (cash) 200,550 Prepaid insurance (prepaid insurance) 25,000 Materials (supplies) 6,000 team (team) 35,000 Accounts receivable (accounts receivable) 122,850 Notes payable (notes payable) 42,800 Accounts payable (accounts payable) 50,000 Carmelo Ruiz, capital 169,100 Carmelo Ruiz, withdrawal (raffle) 20,000 Income (fee earned) 840,500 Utility expense 24,500 Salary expenses 620,000 Advertising expenses (advertising expenses) 3,500 Rental expenses 45,000 Note: The following links should be consulted before submitting the work.

Exercise #1- Part A Properly prepare adjustment entries by demonstrating a thorough understanding of the required procedure. 12 points This criterion depends on a learning competency

Exercise #1- Part B Correctly make the accounting entries that demonstrate a thorough understanding of the required procedure. 12 points This criterion depends on a learning competency

Exercise #1- Part C Correctly prepare the adjusted trial balance by demonstrating a thorough understanding of the required procedure. 34 points

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!