1 Trabajo #2 Ejercicio Practico- Valor 100 puntos 2 Ejercicio Practico: Para ser preparado en una hoja de trabajo (worksheet) en el programa de computadora Excell. 3 Instrucciones: 4 Con los balances de Trial Balance presentados en la tabla provista el estudiante debera: 5 1. Analizar las transaccion o eventos dados para determinar que cuentas afectara para hacer la entrada de ajuste 6 2. Completar la columna de Adjustments con la entrada de ajuste que corresponda realizar. Trial Balance Adjusted. 7 3. Presentara Trial balance adjustments en la columnas de la hoja de trabajo dada. 8 4.Preparar los estados financieros (Income Statement y Balance Sheet) en la hoja de trabajo dada. 9 5. Utilizar el Programa Excell- preparar hoja de trabajo con columnas y lineas segun provista. 10 6.Las entradas de ajustes con las letras (a,b,c,d,e,f). 11 Preparar los ajustes para las transacciones siguientes: 12 1- Supplies- the supplies account has a debit balance of $2,000. The cost of the supplies on hand at the end of the period is $760.00. 13 2-Prepaid Insurance - the prepaid insurance account has a debit balance of $2,400,which represents the prepayment of insurance of 24 months 14 beginning December 1. The insurance expense for December is $100 15 3-Unearned Rent- the unearned rent account has a credit balance $360.00, which represents the receipt of three months rent, beginning with December. 16 Thus the rent income for December is $120 17 4- Wages- Wages accrued but not paid at the end of December total $250. 18 5- Accrued Fees- fees accrued at the end of December but not recorded total $500. 19 6-Depreciation- Depreciation of the office equipment is $50.00 for December. The Adjustment is entered by writing in the account Title column. 20 And Accumulated Depreciation in the account title column in the adjustment is entered in column.22 J. Torres 23 Work sheet 24 For the two months ended December 31,2024 25 26 Account Title Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance sheet 27 Dr. Cr. Dr. Cr. Or. Cr. Dr. Cr. Or. Cr. 28 Cash 2,065.00 29 Account Receivable 2.220.00 30 Supplies 2,000.00 31 Prepaid Insurance 2.400 00 32 Land 10.000 00 33 Office Equipment 1,800.00 34 Account Payable 900 35 Unearned Rent 360 36 J. Torres, capital 15,000 37 J. Torres, Drawing 4.000.00 38 Fees Earned 39 Wages Expense 4,275.00 16,340.00 40 Rent Expense 1,600.00 41 Utilities Expense 985.00 42 Supplies Expense 800.00 43 Miscellaneous Expense 455.00 44 32,600.00 32,600.00 45 Insurance Expense 46 Rent Income 47 Wages Payable 48 Depreciation Expense 49 Accumulated Depreciation 50 51 HINT: Sheet1 + Listo 1 Accesibilidad: es necesario investigar