Question: After examining and analyzing the information provided in the two (2) tables then use a sheet in MS Excel to perform the following exercise. Use
After examining and analyzing the information provided in the two (2) tables then use a sheet in MS Excel to perform the following exercise. Use a different tab in the worksheet to display each requested part. Carmen Ramos started a business with the name Perfect Cleaning. The following transactions occurred in January 2020: Transaction Date January 1 Invested $10,000 in cash to start the business. January 3 Purchased a vehicle for the business for $12,000 of which $3,000 was in cash and the remaining in credit January 3 Purchased cleaning products for a total of $1,500. January 4 Paid for a $3,600 prepaid insurance policy effective January 1. January 5 Performed a fee earned for the amount of $2,100. January 10 Paid a subscription to the purchased vehicle for $500 January 15 Paid Employees a Salary for $1,800. January 16 He did a cleaning job in a building on credit for $3,000. January 18 He did cleaning work in offices and charged him in cash for $2,500. January 20 The customer who was given the job on January 16 paid $1,200. January 21 He paid for the business vehicle's gas in the amount of $80. January 22 He did office cleaning work for $1,000 in cash. January 25 Paid for the business vehicle's gas amounting to $20. January 28 Paid for advertising expenses $500. January 29 Made a personal withdrawal in the amount of $500. January 30 Paid Employees a Salary for $1,800. The following list of accounts (chart of accounts) is used for the accounting books of the company Perfect Cleaning: Account number Account name 111 Cash (cash) 112 Accounts receivable 128 Cleaning materials (cleaning supplies) 130 Prepaid insurance 157 Equipment (equipment) 158 Accumulated depreciation equipment 201 Accounts payable 212 Salaries payable 301 Carmen Ramos, capital 305 Carmen Ramos, retreat (drawing) 350 Income summary 400 Earned Fee (fee earned) 632 Gasoline and oil expenditure (gas & oil expense) 633 Cleaning supplies expense 710 Depreciation expense (depreciation expense) 712 Insurance expense 720 Wage expenses (salaries expense) Jornalizes January's transactions in the general journal. Makes (post) the entries in the ledger. Prepares the check balance without adjustment as of January 31, 2020. Make the following settings:to. The team's depreciation for one month is $205.B. A month of prepaid insurance expired.c. The balance of cleaning supplies inventory at the end of the month is $200.d. Accrued wage, but not paid to an employee (unpaid employee salary) is for $600. Prepare the following reports in your corresponding spreadsheet:to. Income statementB. Status of owner equityc. Status (balance sheet)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
