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
Get step-by-step solutions from verified subject matter experts
