251726145-03A-DeMOSTRACION-Flujo-de-Caja-Operacional-Anual-Subvencionado-Demo.xls
8
Supuestos para la Elaboración del Flujo de Caja 07/17/2022 Planilla Diseñada por Ariel Gringaus - Colegium.com Alumnos Matricula Promedio Colegiatura Promedio Subvención Promedio Mensual Mes de Cobro Matricula es de Inicio Cobro Colegiatur Meses ColegiaturaAsistencia Promedio Prekinder 0 0 0 0 11 3 10 90% Kinder 75 15,000 10,000 19,765 11 3 10 90% 1º Básico 74 15,000 10,000 19,810 11 3 10 90% 2º Básico 78 15,000 10,000 19,810 11 3 10 90% 3º Básico 76 15,000 10,000 19,810 11 3 10 90% 4º Básico 77 15,000 10,000 19,810 11 3 10 90% 5º Básico 74 15,000 10,000 19,810 11 3 10 90% 6º Básico 65 15,000 10,000 19,810 11 3 10 90% 7º Básico 85 15,000 10,000 21,502 11 3 10 90% 8º Básico 74 15,000 10,000 21,502 11 3 10 90% I Medio 77 15,000 12,000 24,010 11 3 10 90% II Medio 80 15,000 12,000 24,010 11 3 10 90% IIII Medi 72 15,000 12,000 24,010 11 3 10 90% IV Medio 80 15,000 12,000 24,010 11 3 10 90% Total 987
-
Upload
gheghel-gutierrez-huaman -
Category
Documents
-
view
3 -
download
0
Transcript of 251726145-03A-DeMOSTRACION-Flujo-de-Caja-Operacional-Anual-Subvencionado-Demo.xls
Flujo de Caja Operacional Anual
SupuestosAlumnosMatricula PromedioColegiatura PromedioSubvencin Promedio MensualMes de Cobro MatriculaMes de Inicio Cobro ColegiaturaMeses ColegiaturaAsistencia PromedioPrekinder00001131090%Kinder7515,00010,00019,7651131090%1 Bsico7415,00010,00019,8101131090%2 Bsico7815,00010,00019,8101131090%3 Bsico7615,00010,00019,8101131090%4 Bsico7715,00010,00019,8101131090%5 Bsico7415,00010,00019,8101131090%6 Bsico6515,00010,00019,8101131090%7 Bsico8515,00010,00021,5021131090%8 Bsico7415,00010,00021,5021131090%I Medio7715,00012,00024,0101131090%II Medio8015,00012,00024,0101131090%IIII Medio7215,00012,00024,0101131090%IV Medio8015,00012,00024,0101131090%Total987
&CSupuestos para la Elaboracin del Flujo de Caja&R&D&CPlanilla Diseada por Ariel Gringaus - Colegium.com
Ingresos SubvencionesENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBRETOTALPrekinder0000000000000Kinder1,334,1381,334,1381,334,1381,334,1381,334,1381,334,1381,334,1381,334,1381,334,1381,334,1381,334,1381,334,13816,009,6501 Bsico1,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,34615,832,1522 Bsico1,390,6621,390,6621,390,6621,390,6621,390,6621,390,6621,390,6621,390,6621,390,6621,390,6621,390,6621,390,66216,687,9443 Bsico1,355,0041,355,0041,355,0041,355,0041,355,0041,355,0041,355,0041,355,0041,355,0041,355,0041,355,0041,355,00416,260,0484 Bsico1,372,8331,372,8331,372,8331,372,8331,372,8331,372,8331,372,8331,372,8331,372,8331,372,8331,372,8331,372,83316,473,9965 Bsico1,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,3461,319,34615,832,1526 Bsico1,158,8851,158,8851,158,8851,158,8851,158,8851,158,8851,158,8851,158,8851,158,8851,158,8851,158,8851,158,88513,906,6207 Bsico1,644,9031,644,9031,644,9031,644,9031,644,9031,644,9031,644,9031,644,9031,644,9031,644,9031,644,9031,644,90319,738,8368 Bsico1,432,0331,432,0331,432,0331,432,0331,432,0331,432,0331,432,0331,432,0331,432,0331,432,0331,432,0331,432,03317,184,398I Medio1,663,8931,663,8931,663,8931,663,8931,663,8931,663,8931,663,8931,663,8931,663,8931,663,8931,663,8931,663,89319,966,716II Medio1,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,72020,744,640IIII Medio1,555,8481,555,8481,555,8481,555,8481,555,8481,555,8481,555,8481,555,8481,555,8481,555,8481,555,8481,555,84818,670,176IV Medio1,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,7201,728,72020,744,640Total19,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,331228,051,968
&CIngresos por Concepto de Subvenciones&R&D&CPlanilla Diseada por Ariel Gringaus - Colegium.com
Ingresos ColegiaturaENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBRETOTALPrekinder0000000000000Kinder00750,000750,000750,000750,000750,000750,000750,000750,000750,000750,0007,500,0001 Bsico00740,000740,000740,000740,000740,000740,000740,000740,000740,000740,0007,400,0002 Bsico00780,000780,000780,000780,000780,000780,000780,000780,000780,000780,0007,800,0003 Bsico00760,000760,000760,000760,000760,000760,000760,000760,000760,000760,0007,600,0004 Bsico00770,000770,000770,000770,000770,000770,000770,000770,000770,000770,0007,700,0005 Bsico00740,000740,000740,000740,000740,000740,000740,000740,000740,000740,0007,400,0006 Bsico00650,000650,000650,000650,000650,000650,000650,000650,000650,000650,0006,500,0007 Bsico00850,000850,000850,000850,000850,000850,000850,000850,000850,000850,0008,500,0008 Bsico00740,000740,000740,000740,000740,000740,000740,000740,000740,000740,0007,400,000I Medio00924,000924,000924,000924,000924,000924,000924,000924,000924,000924,0009,240,000II Medio00960,000960,000960,000960,000960,000960,000960,000960,000960,000960,0009,600,000IIII Medio00864,000864,000864,000864,000864,000864,000864,000864,000864,000864,0008,640,000IV Medio00960,000960,000960,000960,000960,000960,000960,000960,000960,000960,0009,600,000Total0010,488,00010,488,00010,488,00010,488,00010,488,00010,488,00010,488,00010,488,00010,488,00010,488,000104,880,000
&CIngresos por Concepto de Colegiaturas&R&D&CPlanilla Diseada por Ariel Gringaus - Colegium.com
Ingresos MatriculaENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBRETOTALPrekinder0000000000000Kinder00000000001,125,00001,125,0001 Bsico00000000001,110,00001,110,0002 Bsico00000000001,170,00001,170,0003 Bsico00000000001,140,00001,140,0004 Bsico00000000001,155,00001,155,0005 Bsico00000000001,110,00001,110,0006 Bsico0000000000975,0000975,0007 Bsico00000000001,275,00001,275,0008 Bsico00000000001,110,00001,110,000I Medio00000000001,155,00001,155,000II Medio00000000001,200,00001,200,000IIII Medio00000000001,080,00001,080,000IV Medio00000000001,200,00001,200,000Total000000000014,805,000014,805,000
&CIngresos por Concepto de Matrculas&R&D&CPlanilla Diseada por Ariel Gringaus - Colegium.com
Ingresos TotalesENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBRETOTALPrekinder0000000000000Kinder1,334,1381,334,1382,084,1382,084,1382,084,1382,084,1382,084,1382,084,1382,084,1382,084,1383,209,1382,084,13824,634,6501 Bsico1,319,3461,319,3462,059,3462,059,3462,059,3462,059,3462,059,3462,059,3462,059,3462,059,3463,169,3462,059,34624,342,1522 Bsico1,390,6621,390,6622,170,6622,170,6622,170,6622,170,6622,170,6622,170,6622,170,6622,170,6623,340,6622,170,66225,657,9443 Bsico1,355,0041,355,0042,115,0042,115,0042,115,0042,115,0042,115,0042,115,0042,115,0042,115,0043,255,0042,115,00425,000,0484 Bsico1,372,8331,372,8332,142,8332,142,8332,142,8332,142,8332,142,8332,142,8332,142,8332,142,8333,297,8332,142,83325,328,9965 Bsico1,319,3461,319,3462,059,3462,059,3462,059,3462,059,3462,059,3462,059,3462,059,3462,059,3463,169,3462,059,34624,342,1526 Bsico1,158,8851,158,8851,808,8851,808,8851,808,8851,808,8851,808,8851,808,8851,808,8851,808,8852,783,8851,808,88521,381,6207 Bsico1,644,9031,644,9032,494,9032,494,9032,494,9032,494,9032,494,9032,494,9032,494,9032,494,9033,769,9032,494,90329,513,8368 Bsico1,432,0331,432,0332,172,0332,172,0332,172,0332,172,0332,172,0332,172,0332,172,0332,172,0333,282,0332,172,03325,694,398I Medio1,663,8931,663,8932,587,8932,587,8932,587,8932,587,8932,587,8932,587,8932,587,8932,587,8933,742,8932,587,89330,361,716II Medio1,728,7201,728,7202,688,7202,688,7202,688,7202,688,7202,688,7202,688,7202,688,7202,688,7203,888,7202,688,72031,544,640IIII Medio1,555,8481,555,8482,419,8482,419,8482,419,8482,419,8482,419,8482,419,8482,419,8482,419,8483,499,8482,419,84828,390,176IV Medio1,728,7201,728,7202,688,7202,688,7202,688,7202,688,7202,688,7202,688,7202,688,7202,688,7203,888,7202,688,72031,544,640Total19,004,33119,004,33129,492,33129,492,33129,492,33129,492,33129,492,33129,492,33129,492,33129,492,33144,297,33129,492,331347,736,968
&CIngresos Totales del Colegio&R&D&CPlanilla Diseada por Ariel Gringaus - Colegium.com
Flujo de CajaENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBRETOTAL1Ingresos Totales24,884,33119,004,33129,492,33129,492,33129,492,33129,492,33129,492,33129,492,33129,492,33129,492,33144,297,33129,492,331353,616,9681.1Ingresos Colegiaturas0010,488,00010,488,00010,488,00010,488,00010,488,00010,488,00010,488,00010,488,00010,488,00010,488,000104,880,0001.2Ingresos Subvenviones19,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,33119,004,331228,051,9681.3Ingresos Matriculas000000000014,805,000014,805,0001.4Ingresos Otros5,880,000000000000005,880,0002Costos RR.HH.26,845,00026,845,00026,845,00026,845,00026,845,00026,845,00026,845,00026,845,00026,845,00026,845,00026,845,00026,845,000322,140,0002.1Remuneraciones21,000,00021,000,00021,000,00021,000,00021,000,00021,000,00021,000,00021,000,00021,000,00021,000,00021,000,00021,000,000252,000,0002.2Sala Cuna320,000320,000320,000320,000320,000320,000320,000320,000320,000320,000320,000320,0003,840,0002.3Iva - Impuestos100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,0001,200,0002.4Imposiciones3,700,0003,700,0003,700,0003,700,0003,700,0003,700,0003,700,0003,700,0003,700,0003,700,0003,700,0003,700,00044,400,0002.5Capacitacin Personal200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,0002,400,0002.6Convenios250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,0003,000,0002.7Honorarios650,000650,000650,000650,000650,000650,000650,000650,000650,000650,000650,000650,0007,800,0002.8Finiquitos00000000000002.9Bonos Especiales500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,000500,0006,000,0002.10Otros125,000125,000125,000125,000125,000125,000125,000125,000125,000125,000125,000125,0001,500,0003Activos Fijos150,000150,000150,000150,000150,000150,000150,000150,000150,000150,000150,000150,0001,800,0003.1Inversiones00000000000003.2Arriendos150,000150,000150,000150,000150,000150,000150,000150,000150,000150,000150,000150,0001,800,0003.3Otros00000000000004Servicios710,000710,000710,000710,000710,000710,000710,000710,000710,000710,000710,000710,0008,520,0004.1Luz300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,0003,600,0004.2Agua185,000185,000185,000185,000185,000185,000185,000185,000185,000185,000185,000185,0002,220,0004.3Telfonos200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,0002,400,0004.4Gas20,00020,00020,00020,00020,00020,00020,00020,00020,00020,00020,00020,000240,0004.5Otros5,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,00060,0005Insumos290,000290,000290,000290,000290,000290,000290,000290,000290,000290,000290,000290,0003,480,0005.1Aseo140,000140,000140,000140,000140,000140,000140,000140,000140,000140,000140,000140,0001,680,0005.2Oficina50,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,000600,0005.3Computacin50,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,000600,0005.4Otros50,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,00050,000600,0006Mantencin230,000230,000230,000230,000230,000230,000230,000230,000230,000230,000230,000230,0002,760,0006.1Edificio100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,0001,200,0006.2Equipos100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,0001,200,0006.3Vidrios15,00015,00015,00015,00015,00015,00015,00015,00015,00015,00015,00015,000180,0006.4Otros15,00015,00015,00015,00015,00015,00015,00015,00015,00015,00015,00015,000180,0007Egresos Totales28,225,00028,225,00028,225,00028,225,00028,225,00028,225,00028,225,00028,225,00028,225,00028,225,00028,225,00028,225,000338,700,0008Flujo de Caja (1-7)-3,340,669-9,220,6691,267,3311,267,3311,267,3311,267,3311,267,3311,267,3311,267,3311,267,33116,072,3311,267,33114,916,9689Ingreso Promedio Por Alumno25,21219,25529,88129,88129,88129,88129,88129,88129,88129,88144,88129,881358,27510Costo Promedio Por Alumno28,59728,59728,59728,59728,59728,59728,59728,59728,59728,59728,59728,597343,16111Utilidad Promedio por Alumno-3,385-9,3421,2841,2841,2841,2841,2841,2841,2841,28416,2841,28415,113
&CFlujo de Caja Anual&R&D&CPlanilla Diseada por Ariel Gringaus - Colegium.com
Calculos (No Usar)123456789101112Matricula_PK000000000010Matricula_K000000000010Matricula_1000000000010Matricula_2000000000010Matricula_3000000000010Matricula_4000000000010Matricula_5000000000010Matricula_6000000000010Matricula_7000000000010Matricula_8000000000010Matricula_9000000000010Matricula_10000000000010Matricula_11000000000010Matricula_12000000000010Colegiatura_PK001111111111Colegiatura_K001111111111Colegiatura_1001111111111Colegiatura_2001111111111Colegiatura_3001111111111Colegiatura_4001111111111Colegiatura_5001111111111Colegiatura_6001111111111Colegiatura_7001111111111Colegiatura_8001111111111Colegiatura_9001111111111Colegiatura_10001111111111Colegiatura_11001111111111Colegiatura_12001111111111Subvencion_PK0.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_K0.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_10.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_20.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_30.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_40.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_50.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_60.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_70.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_80.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_90.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_100.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_110.900.900.900.900.900.900.900.900.900.900.900.90Subvencion_120.900.900.900.900.900.900.900.900.900.900.900.90
