Logo Studenta

EXCEL_TAREA_INDIVIDUAL

¡Estudia con miles de materiales!

Vista previa del material en texto

Hoja1
			1	2	3	4	5		EJERCICIO	1	2	3	4	5
		ACTIVO TOTAL	VALOR	VALOR	VALOR	VALOR	VALOR		ACTIVOS CORRIENTES
		EDIFICIO	$89,300.00	$120,555.00	$111,625.00	$62,510.00	$102.695.00		BANCO	$65,000.00	$87,750.00	$81,250.00	$45,500.00	$74,750.00
		CUENTAS POR COBRAR	$96,300.00	$130,005.00	$120,375.00	$67,410.00	$110,745.00		INVENTARIOS	$62,100.00	$83,835.00	$77,625.00	$43,470.00	$71,415.00
		CUENTAS POR PAGAR	$25,000.00	$33,750.00	$31,250.00	$17,500.00	$28,750.00		CLIENTES	$63,200.00	$85,320.00	$79,000.00	$44,240.00	$72,680.00
		CLIENTES	$63,200.00	$85,320.00	$79,000.00	$44,240.00	$72,680.00		CAJA	$21,500.00	$29,025.00	$26,875.00	$15,050.00	$24,725.00
		PROVEEDORES	$17,500.00	$23,625.00	$21,875.00	$12,250.00	$20,125.00		CUENTAS POR COBRAR	$96,300.00	$130,005.00	$120,375.00	$67,410.00	$110,745.00
		OBLIGACIONES BANCARIAS	$65,300.00	$88,155.00	$81,625.00	$45,710.00	$75,095.00
		INVENTARIOS	$62,100.00	$83,835.00	$77,625.00	$43,470.00	$71,415.00		TOTAL DE LOS ACTIVOS	$308,100.00	$415,935.00	$385,125.00	$215,670.00	$354,315.00
		BANCO	$65,000.00	$87,750.00	$81,250.00	$45,500.00	$74,750.00
		INVERSIONES	$25,100.00	$33,885.00	$31,375.00	$17,570.00	$28,865.00
		CAJA	$21,500.00	$29,025.00	$26,875.00	$15,050.00	$24,725.00		EJERCICIO	1	2	3	4	5
		HIPOTECA POR PAGAR	$65,400.00	$88,290.00	$81,750.00	$45,780.00	$75,210.00		PASIVOS CORRIENTES
		IMPUESTOS POR PAGAR	$15,900.00	$21,465.00	$19,875.00	$11,130.00	$18,285.00
									PROVEEDORES	$17,500.00	$23,625.00	$21,875.00	$12,250.00	$20,125.00
									CUENTAS POR PAGAR	$25,000.00	$33,750.00	$31,250.00	$17,500.00	$28,750.00
									OBLIGACIONES BANCARIAS	$65,300.00	$88,155.00	$81,625.00	$45,710.00	$75,095.00
									HIPOTECA POR PAGAR	$65,400.00	$88,290.00	$81,750.00	$45,780.00	$75,210.00
									IMPUESTOS POR PAGAR	$15,900.00	$21,465.00	$19,875.00	$11,130.00	$18,285.00
									TOTAL DE LOS PASIVOS	$189,100.00	$255,285.00	$236,375.00	$132,370.00	$217,465.00
									FORMULA
							1	RATIO
								PRUEBA ACIDA
								LIQUIDEZ LIQUIDA

Otros materiales