After examining and analyzing the information provided in the two (2) tables below, use an MS Excel sheet to perform the following exercise. Use a different tab on the worksheet to display each requested part.

Carmen Ramos started a business called Perfect Cleaning. The following transactions occurred in January 2020:

Date Transaction

January 1 Invested $ 10,000 in cash to start the business.

January 3 Bought a business equipment for $ 12,000 of which $ 3,000 was in cash and the remainder in credit

January 3 Purchased cleaning supplies for a total of $ 1,500.

January 4 she Paid a prepayment insurance policy for $ 2,000 effective January 1.

January 5 she Performed a customer service (fee earned) in the amount of $ 2,100.

January 10 she paid a subscription to the equipment purchased for $ 500

January 15, she paid employee wages of $ 1,800.

January 16 she did a cleaning job on a building on credit for $ 3,000.

January 18, she did cleaning work in an office and collected it in cash for $ 2,500.

January 20 The customer who had the job performed on January 16 paid $ 1,200.

January 21 she Paid $ 80 for gas for the business vehicle.

January 22nd she did office cleaning work for $ 1,000 cash.

January 25 she Paid $ 20 for gas for the business vehicle.

January 28, she paid $ 500 for advertising expense.

January 29 she made a withdrawal for personal use in the amount of $ 500.

January 30, she paid employee wages of $ 1,800.

The following list of accounts (chart of accounts) is used for the accounting books of the Perfect Cleaning company:

Account number Account name

111 Cash

112 Accounts receivable

128 Cleaning supplies

130 Prepaid insurance

157 Equipment

158 Accumulated depreciation equipment

201 Accounts payable

212 Wages payable (salaries payable)

301 Carmen Ramos, capital

305 Carmen Ramos, retirement (drawing)

350 Income summary

400 Fee earned

632 Gas & oil expense

633 Cleaning supplies expense

710 Depreciation expense

712 Insurance expense

720 Salaries expense

730 Advertising expense

Journalize the transactions for the month of January in the general journal.

Make (post) the entries in the ledger.

Prepare the trial balance without adjustments as of January 31, 2020.

Make the following adjustments:

The depreciation of the equipment for one month is $ 205.

One month of prepaid insurance expired.

The inventory balance of cleaning supplies at the end of the month is $ 200.

Salary accrued, but not paid to an employee (unpaid employee salary) is $ 600.

Prepare the following reports in their corresponding spreadsheet:

Income statement

Statement of owner equity

Balance sheet