After examining and analyzing the information provided in the two (2) tables below, use a 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:

Transaction Date

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

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

January 3 Purchased cleaning supplies totaling $ 1,500.

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

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

January 10 she paid a credit to the vehicle purchased for $ 500

January 15 Paid salary to employees for $ 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 22, 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.

El siguiente listado de cuentas(chart of accounts)es el utilizado para los libros contables de la compaaLimpieza Perfecta:

Nmero de cuenta Nombre de cuenta

111 Efectivo(cash)

112 Cuentas por cobrar(accounts receivable)

128 Materiales de limpieza(cleaning supplies)

130 Seguro prepagado(prepaid insurance)

157 Equipo(equipment)

158 Depreciacin acumulada de equipo(accumulated depreciation equipment)

201 Cuentas por pagar(accounts payable)

212 Salarios por pagar(salaries payable)

301 Carmen Ramos, capital

305 Carmen Ramos, retiro(drawing)

350 Resumen de ingresos(Income summary)

400 Tarifa ganada(fee earned)

632 Gasto de gasolina y aceite(gas & oil expense)

633 Gasto de materiales de limpieza(cleaning supplies expense)

710 Gasto de depreciacin(depreciation expense)

712 Gasto de seguro(insurance expense)

720 Gasto de salarios(salaries 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:

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

b. One month of prepaid insurance expired.

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

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

Prepare the following reports in their corresponding spreadsheet:

to. Income statement

b. Statement of owner equity

c. Balance sheet