CLASE No 6 EXCEL B

Vista previa del material en texto

Estados Financieros
	Estados Financiero - Flujo de Efectivo 2022 (Metodo Indirecto)
	Flujo efectivo Metodo Indirecto	PRESUPUESTO 2022
		Enero	Febrero	Marzo	Abril	Mayo	Junio	Julio	Agosto	Septiembre	Octubre	Noviembre	Diciembre	2022
	Flujo efectivo de Operación
	Ganancia neta del Ejercicio	3,902,874.00	8,648,261.00	- 977,656.00	- 1,843,626.00	- 1,949,220.00	2,258,894.00	- 857,330.00	- 2,589,996.00	- 2,031,597.00	- 3,441,318.00	1,882,168.00	770,983.00	3,772,437.00
	Partidas que no han generado movimiento de fondos
	Depreciacion Activos Fijos	1,035,845.00	979,601.00	977,563.00	978,481.00	982,869.00	984,325.00	985,138.00	946,512.00	900,892.00	893,734.00	888,662.00	885,912.00	11,439,534.00
	Previcion para Indiminizaciones	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	2,102,928.00
	Amortizacion para mantenimiento	42,757.00	0	0	0	0	0	0	0	0	0	0	0	42,757.00
	Ajuste para Reexpresion	0	0	0	0	0	0	0	0	0	0	0	0	0
		5,156,720.00	9,803,106.00	175,151.00	-689,901.00	-791,107.00	3,418,463.00	303,052.00	-1,468,240.00	-955,461.00	-2,372,340.00	2,946,074.00	1,832,139.00	17,357,656.00
	Cambios en activos y pasivos operativos
	Total Flujo de efectivo act. Operativas	-5,791,219.00	4,253,872.00	-179,596,511.00	-30,128,061.00	141,414,737.00	-355,632,346.00	180,917,726.00	-25,909,814.00	140,425,362.00	52,105,702.00	-19,934,658.00	-3,801,181.00	- 101,676,391.00
	Flujo de efectivo de inversion
	Activos fijos	0.00	-8,700.00 	-534,180.00 	-63,510.00 	-218,370.00 	-81,780.00 	-34,800.00 	-33,060.00 	-10,875.00 	-20,880.00 	-27,405.00 	-177,045.00 	-1,210,605.00 
	Proyectos y obras	-22,786,056.00	-32,459,822.00	-36,775,659.00	-51,519,277.00	-54,225,814.00	-59,632,011.00	-65,742,807.00	-64,568,906.00	-57,914,955.00	-56,205,353.00	-54,493,842.00	-43,760,997.00	-600,085,499.00
	Total Flujo de efectivo de Inversion	-22,786,056.00 	-32,468,522.00 	-37,309,839.00 	-51,582,787.00 	-54,444,184.00 	-59,713,791.00 	-65,777,607.00 	-64,601,966.00 	-57,925,830.00 	-56,226,233.00 	-54,521,247.00 	-43,938,042.00 	-601,296,104.00 
	Flujo de efectivo financimiento
	Distribucion de dividendos	0.00	0.00	-19,437,242.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	-19,437,242.00
	Deuda a largo plazo
	Aporte de Capital	96,449,141.00	0.00	339,753,448.00	0.00	0.00	350,000,000.00	0.00	0.00	0.00	0.00	0.00	0.00	786,202,589.00
	Total Flujo de efectivo financiamiento	96,449,141.00	0.00	320,316,206.00	0.00	0.00	350,000,000.00	0.00	0.00	0.00	0.00	0.00	0.00	766,765,347.00
	Incremento neto de efectivo	67,871,866.00	-28,214,650.00	103,409,855.00	-81,710,848.00	86,970,553.00	-65,346,137.00	115,140,119.00	-90,511,781.00	82,499,532.00	-4,120,531.00	-74,455,905.00	-47,739,223.00	63,792,850.00
	Efectivo al inicio del ejercicio	56,216,836.00	124,088,702.00	95,874,052.00	199,283,907.00	117,573,059.00	204,543,612.00	139,197,475.00	254,337,593.00	163,825,813.00	246,325,345.00	242,204,814.00	167,748,909.00	2,011,220,117.00
	Efectivo al cierre del ejercicio	124,088,702.00	95,874,052.00	199,283,907.00	117,573,059.00	204,543,612.00	139,197,475.00	254,337,594.00	163,825,812.00	246,325,345.00	242,204,814.00	167,748,909.00	120,009,686.00
MODIFICACION 1
	Flujo efectivo Metodo Indirecto	PRESUPUESTO 2022
		Enero	Febrero	Marzo	Abril	Mayo	Junio	Julio	Agosto	Septiembre	Octubre	Noviembre	Diciembre	2022
	Flujo efectivo de Operación
	Ganancia neta del Ejercicio	3,902,874.00	8,648,261.00	- 977,656.00	- 1,843,626.00	- 1,949,220.00	2,258,894.00	- 857,330.00	- 2,589,996.00	- 2,031,597.00	- 3,441,318.00	1,882,168.00	770,983.00	3,772,437.00
	Partidas que no han generado movimiento de fondos
	Depreciacion Activos Fijos	1,035,845.00	979,601.00	977,563.00	978,481.00	982,869.00	984,325.00	985,138.00	946,512.00	900,892.00	893,734.00	888,662.00	885,912.00	11,439,534.00
	Previcion para Indiminizaciones	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	2,102,928.00
	Amortizacion para mantenimiento	42,757.00	0	0	0	0	0	0	0	0	0	0	0	42,757.00
	Ajuste para Reexpresion	0	0	0	0	0	0	0	0	0	0	0	0	0
		5,156,720.00	9,803,106.00	175,151.00	-689,901.00	-791,107.00	3,418,463.00	303,052.00	-1,468,240.00	-955,461.00	-2,372,340.00	2,946,074.00	1,832,139.00	17,357,656.00
	Cambios en activos y pasivos operativos
	Total Flujo de efectivo act. Operativas	-5,791,219.00	4,253,872.00	-179,596,511.00	-30,128,061.00	141,414,737.00	-355,632,346.00	180,917,726.00	-25,909,814.00	140,425,362.00	52,105,702.00	-19,934,658.00	-3,801,181.00	- 101,676,391.00
	Flujo de efectivo de inversion
	Activos fijos	0.00	-8,700.00 	-534,180.00 	-63,510.00 	-218,370.00 	-81,780.00 	-34,800.00 	-33,060.00 	-10,875.00 	-20,880.00 	-27,405.00 	-177,045.00 	-1,210,605.00 
	Proyectos y obras	-22,786,056.00	-32,459,822.00	-36,775,659.00	-51,519,277.00	-54,225,814.00	-59,632,011.00	-65,742,807.00	-64,568,906.00	-57,914,955.00	-56,205,353.00	-54,493,842.00	-43,760,997.00	-600,085,499.00
	Total Flujo de efectivo de Inversion	-22,786,056.00 	-32,468,522.00 	-37,309,839.00 	-51,582,787.00 	-54,444,184.00 	-59,713,791.00 	-65,777,607.00 	-64,601,966.00 	-57,925,830.00 	-56,226,233.00 	-54,521,247.00 	-43,938,042.00 	-601,296,104.00 
	Flujo de efectivo financimiento
	Distribucion de dividendos	0.00	0.00	-19,437,242.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	-19,437,242.00
	Deuda a largo plazo
	Aporte de Capital	96,449,141.00	0.00	339,753,448.00	0.00	0.00	350,000,000.00	0.00	0.00	0.00	0.00	0.00	0.00	786,202,589.00
	Total Flujo de efectivo financiamiento	96,449,141.00	0.00	320,316,206.00	0.00	0.00	350,000,000.00	0.00	0.00	0.00	0.00	0.00	0.00	766,765,347.00
	Incremento neto de efectivo	67,871,866.00	-28,214,650.00	103,409,855.00	-81,710,848.00	86,970,553.00	-65,346,137.00	115,140,119.00	-90,511,781.00	82,499,532.00	-4,120,531.00	-74,455,905.00	-47,739,223.00	63,792,850.00
	Efectivo al inicio del ejercicio	56,216,836.00	124,088,702.00	95,874,052.00	199,283,907.00	117,573,059.00	204,543,612.00	139,197,475.00	254,337,593.00	163,825,813.00	246,325,345.00	242,204,814.00	167,748,909.00	2,011,220,117.00
	Efectivo al cierre del ejercicio	124,088,702.00	95,874,052.00	199,283,907.00	117,573,059.00	204,543,612.00	139,197,475.00	254,337,594.00	163,825,812.00	246,325,345.00	242,204,814.00	167,748,909.00	120,009,686.00
MODIFICACION 2
		Enero	Febrero	Marzo	Abril	Mayo	Junio	Julio	Agosto	Septiembre	Octubre	Noviembre	Diciembre	2022
	Flujo efectivo de Operación
	Ganancia neta del Ejercicio	3,902,874.00	8,648,261.00	- 977,656.00	- 1,843,626.00	- 1,949,220.00	2,258,894.00	- 857,330.00	- 2,589,996.00	- 2,031,597.00	- 3,441,318.00	1,882,168.00	770,983.00	3,772,437.00
	Partidas que no han generado movimiento de fondos
	Depreciacion Activos Fijos	1,035,845.00	979,601.00	977,563.00	978,481.00	982,869.00	984,325.00	985,138.00	946,512.00	900,892.00	893,734.00	888,662.00	885,912.00	11,439,534.00
	Previcion para Indiminizaciones	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	2,102,928.00
	Amortizacion para mantenimiento	42,757.00	0	0	0	0	0	0	0	0	0	0	0	42,757.00
	Ajuste para Reexpresion	0	0	0	0	0	0	0	0	0	0	0	0	0
		5,156,720.00	9,803,106.00	175,151.00	-689,901.00	-791,107.00	3,418,463.00	303,052.00	-1,468,240.00	-955,461.00	-2,372,340.00	2,946,074.00	1,832,139.00	17,357,656.00
	Cambios en activos y pasivos operativos
	Total Flujo de efectivo act. Operativas	-5,791,219.00	4,253,872.00	-179,596,511.00	-30,128,061.00	141,414,737.00	-355,632,346.00	180,917,726.00	-25,909,814.00	140,425,362.00	52,105,702.00	-19,934,658.00	-3,801,181.00	- 101,676,391.00
	Flujo de efectivo de inversion
	Activos fijos	0.00	-8,700.00 	-534,180.00 	-63,510.00 	-218,370.00 	-81,780.00 	-34,800.00 	-33,060.00 	-10,875.00 	-20,880.00 	-27,405.00 	-177,045.00 	-1,210,605.00 
	Proyectos y obras	-22,786,056.00	-32,459,822.00	-36,775,659.00	-51,519,277.00	-54,225,814.00	-59,632,011.00	-65,742,807.00	-64,568,906.00-57,914,955.00	-56,205,353.00	-54,493,842.00	-43,760,997.00	-600,085,499.00
	Total Flujo de efectivo de Inversion	-22,786,056.00 	-32,468,522.00 	-37,309,839.00 	-51,582,787.00 	-54,444,184.00 	-59,713,791.00 	-65,777,607.00 	-64,601,966.00 	-57,925,830.00 	-56,226,233.00 	-54,521,247.00 	-43,938,042.00 	-601,296,104.00 
	Flujo de efectivo financimiento
	Distribucion de dividendos	0.00	0.00	-19,437,242.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	-19,437,242.00
	Deuda a largo plazo
	Aporte de Capital	96,449,141.00	0.00	339,753,448.00	0.00	0.00	350,000,000.00	0.00	0.00	0.00	0.00	0.00	0.00	786,202,589.00
	Total Flujo de efectivo financiamiento	96,449,141.00	0.00	320,316,206.00	0.00	0.00	350,000,000.00	0.00	0.00	0.00	0.00	0.00	0.00	766,765,347.00
	Incremento neto de efectivo	67,871,866.00	-28,214,650.00	103,409,855.00	-81,710,848.00	86,970,553.00	-65,346,137.00	115,140,119.00	-90,511,781.00	82,499,532.00	-4,120,531.00	-74,455,905.00	-47,739,223.00	63,792,850.00
	Efectivo al inicio del ejercicio	56,216,836.00	124,088,702.00	95,874,052.00	199,283,907.00	117,573,059.00	204,543,612.00	139,197,475.00	254,337,593.00	163,825,813.00	246,325,345.00	242,204,814.00	167,748,909.00	2,011,220,117.00
	Efectivo al cierre del ejercicio	124,088,702.00	95,874,052.00	199,283,907.00	117,573,059.00	204,543,612.00	139,197,475.00	254,337,594.00	163,825,812.00	246,325,345.00	242,204,814.00	167,748,909.00	120,009,686.00
MODIFICACION 3
		Enero	Febrero	Marzo	Abril	Mayo	Junio	Julio	Agosto	Septiembre	Octubre	Noviembre	Diciembre	2022
	Flujo efectivo de Operación
	Ganancia neta del Ejercicio	3,902,874.00	8,648,261.00	-977,656.00 	-1,843,626.00 	-1,949,220.00 	2,258,894.00	-857,330.00 	-2,589,996.00 	-2,031,597.00 	-3,441,318.00 	1,882,168.00	770,983.00	3,772,437.00
	Partidas que no han generado movimiento de fondos
	Depreciacion Activos Fijos	1,035,845.00	979,601.00	977,563.00	978,481.00	982,869.00	984,325.00	985,138.00	946,512.00	900,892.00	893,734.00	888,662.00	885,912.00	11,439,534.00
	Previcion para Indiminizaciones	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	2,102,928.00
	Amortizacion para mantenimiento	42,757.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	42,757.00
	Ajuste para Reexpresion	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
		5,156,720.00	9,803,106.00	175,151.00	-689,901.00	-791,107.00	3,418,463.00	303,052.00	-1,468,240.00	-955,461.00	-2,372,340.00	2,946,074.00	1,832,139.00	17,357,656.00
	Cambios en activos y pasivos operativos
	Total Flujo de efectivo act. Operativas	-5,791,219.00 	4,253,872.00	-179,596,511.00 	-30,128,061.00 	141,414,737.00	-355,632,346.00 	180,917,726.00	-25,909,814.00 	140,425,362.00	52,105,702.00	-19,934,658.00 	-3,801,181.00 	- 101,676,391.00
	Flujo de efectivo de inversion
	Activos fijos	0.00	-8,700.00 	-534,180.00 	-63,510.00 	-218,370.00 	-81,780.00 	-34,800.00 	-33,060.00 	-10,875.00 	-20,880.00 	-27,405.00 	-177,045.00 	-1,210,605.00 
	Proyectos y obras	-22,786,056.00	-32,459,822.00	-36,775,659.00	-51,519,277.00	-54,225,814.00	-59,632,011.00	-65,742,807.00	-64,568,906.00	-57,914,955.00	-56,205,353.00	-54,493,842.00	-43,760,997.00	-600,085,499.00
	Total Flujo de efectivo de Inversion	-22,786,056.00 	-32,468,522.00 	-37,309,839.00 	-51,582,787.00 	-54,444,184.00 	-59,713,791.00 	-65,777,607.00 	-64,601,966.00 	-57,925,830.00 	-56,226,233.00 	-54,521,247.00 	-43,938,042.00 	-601,296,104.00 
	Flujo de efectivo financimiento
	Distribucion de dividendos	0.00	0.00	-19,437,242.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	-19,437,242.00
	Deuda a largo plazo
	Aporte de Capital	96,449,141.00	0.00	339,753,448.00	0.00	0.00	350,000,000.00	0.00	0.00	0.00	0.00	0.00	0.00	786,202,589.00
	Total Flujo de efectivo financiamiento	96,449,141.00	0.00	320,316,206.00	0.00	0.00	350,000,000.00	0.00	0.00	0.00	0.00	0.00	0.00	766,765,347.00
	Incremento neto de efectivo	67,871,866.00	-28,214,650.00	103,409,855.00	-81,710,848.00	86,970,553.00	-65,346,137.00	115,140,119.00	-90,511,781.00	82,499,532.00	-4,120,531.00	-74,455,905.00	-47,739,223.00	63,792,850.00
	Efectivo al inicio del ejercicio	56,216,836.00	124,088,702.00	95,874,052.00	199,283,907.00	117,573,059.00	204,543,612.00	139,197,475.00	254,337,593.00	163,825,813.00	246,325,345.00	242,204,814.00	167,748,909.00	2,011,220,117.00
	Efectivo al cierre del ejercicio	124,088,702.00	95,874,052.00	199,283,907.00	117,573,059.00	204,543,612.00	139,197,475.00	254,337,594.00	163,825,812.00	246,325,345.00	242,204,814.00	167,748,909.00	120,009,686.00
Hoja1
		Flujo efectivo Metodo Indirecto	PRESUPUESTO 2022
			Enero	Febrero	Marzo	Abril	Mayo	Junio	Julio	Agosto	Septiembre	Octubre	Noviembre	Diciembre	2022
		Flujo efectivo de Operación
		Ganancia neta del Ejercicio	3,902,874.00	8,648,261.00	- 977,656.00	- 1,843,626.00	- 1,949,220.00	2,258,894.00	- 857,330.00	- 2,589,996.00	- 2,031,597.00	- 3,441,318.00	1,882,168.00	770,983.00	3,772,437.00
		Partidas que no han generado movimiento de fondos
		Depreciacion Activos Fijos	1,035,845.00	979,601.00	977,563.00	978,481.00	982,869.00	984,325.00	985,138.00	946,512.00	900,892.00	893,734.00	888,662.00	885,912.00	11,439,534.00
		Previcion para Indiminizaciones	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	175,244.00	2,102,928.00
		Amortizacion para mantenimiento	42,757.00	0	0	0	0	0	0	0	0	0	0	0	42,757.00
		Ajuste para Reexpresion	0	0	0	0	0	0	0	0	0	0	0	0	0