Flujo de Caja
7
EMPRESA MODELO FLUJO DE CAJA PROYECTADO PARA EL AÑO: 2005 CONCEPTO JUNIO JULIO AGOSTO SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE INGRESOS DE EFECTIVO: SALDO INICIAL EN CAJA 12,006,857 717,463 44,716,205 55,537,339 68,539,969 86,413,087 139,199,346 INGRESOS POR VENTAS 9,594,550 16,585,820 32,455,160 37,847,145 39,733,680 97,633,680 41,690,000 DEBITO FISCAL (IVA) 1,439,183 2,487,873 4,868,274 5,677,072 5,960,052 14,645,052 6,253,500 PRÉSTAMOS 0 50,000,000 0 0 0 0 0 OTROS INGRESOS EN EFECTIVO TOTAL INGRESOS 23,040,589 69,791,156 82,039,639 99,061,556 114,233,701 198,691,819 187,142,846 DESEMBOLSOS EN EFECTIVO: COMPRA DE MATERIA PRIMA 5,586,782 7,300,000 6,135,642 8,067,323 5,391,840 29,529,340 20,900,000 GASTO DE ADMINISTRACION 208,564 260,900 260,900 260,900 260,900 260,900 260,900 MANTENIMIENTO VEHICULO 132,000 3,000,000 150,000 150,000 150,000 150,000 150,000 GASTOS DE TRANSPORTE 60,000 60,000 60,000 60,000 60,000 60,000 60,000 ELECTRICIDAD Y AGUA 251,781 270,000 270,000 270,000 270,000 270,000 270,000 GASTO DE PRODUCCION 3,080,900 3,300,000 3,400,000 3,400,000 3,400,000 3,400,000 11,338,000 SUELDOS Y SALARIOS 2,748,200 2,950,000 3,000,000 3,000,000 3,000,000 3,000,000 12,500,000 CREDITO FISCAL (IVA) 907,069 1,174,635 999,981 1,289,733 888,411 4,509,036 3,214,635 OBLIGACIONES BANCARIAS 4,500,000 0 3,000,000 4,500,000 4,200,000 3,000,000 4,500,000 HIPORTECA POR PAGAR 2,568,276 2,590,458 2,612,863 2,635,492 2,648,347 2,676,430 2,704,744 INTERESES Y COMISIONES 1,747,440 2,855,720 2,744,621 2,500,801 2,479,475 2,500,751 2,385,602 PAGO DE IMPUESTO (IVA) 532,114 1,313,238 3,868,293 4,387,338 5,071,641 10,136,016 3,038,865 OTROS EGRESOS EN EFECTIVO TOTAL EGRESOS 22,323,126 25,074,952 26,502,300 30,521,587 27,820,614 59,492,473 61,322,746 SALDO FINAL EN CAJA 717,463 44,716,205 55,537,339 68,539,969 86,413,087 ### ###
-
Upload
yereysy-alvarez -
Category
Documents
-
view
7 -
download
0
description
Modelo de formato
Transcript of Flujo de Caja
2005EMPRESA MODELOFLUJO DE CAJA PROYECTADOPARA EL AO: 2005CONCEPTOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBREINGRESOS DE EFECTIVO:SALDO INICIAL EN CAJA12,006,857717,46344,716,20555,537,33968,539,96986,413,087139,199,346INGRESOS POR VENTAS9,594,55016,585,82032,455,16037,847,14539,733,68097,633,68041,690,000DEBITO FISCAL (IVA)1,439,1832,487,8734,868,2745,677,0725,960,05214,645,0526,253,500PRSTAMOS050,000,00000000OTROS INGRESOS EN EFECTIVOTOTAL INGRESOS23,040,58969,791,15682,039,63999,061,556114,233,701198,691,819187,142,846DESEMBOLSOS EN EFECTIVO:COMPRA DE MATERIA PRIMA5,586,7827,300,0006,135,6428,067,3235,391,84029,529,34020,900,000GASTO DE ADMINISTRACION208,564260,900260,900260,900260,900260,900260,900MANTENIMIENTO VEHICULO132,0003,000,000150,000150,000150,000150,000150,000GASTOS DE TRANSPORTE60,00060,00060,00060,00060,00060,00060,000ELECTRICIDAD Y AGUA251,781270,000270,000270,000270,000270,000270,000GASTO DE PRODUCCION3,080,9003,300,0003,400,0003,400,0003,400,0003,400,00011,338,000SUELDOS Y SALARIOS2,748,2002,950,0003,000,0003,000,0003,000,0003,000,00012,500,000CREDITO FISCAL (IVA)907,0691,174,635999,9811,289,733888,4114,509,0363,214,635OBLIGACIONES BANCARIAS4,500,00003,000,0004,500,0004,200,0003,000,0004,500,000HIPORTECA POR PAGAR2,568,2762,590,4582,612,8632,635,4922,648,3472,676,4302,704,744INTERESES Y COMISIONES1,747,4402,855,7202,744,6212,500,8012,479,4752,500,7512,385,602PAGO DE IMPUESTO (IVA)532,1141,313,2383,868,2934,387,3385,071,64110,136,0163,038,865OTROS EGRESOS EN EFECTIVOTOTAL EGRESOS22,323,12625,074,95226,502,30030,521,58727,820,61459,492,47361,322,746SALDO FINAL EN CAJA717,46344,716,20555,537,33968,539,96986,413,087139,199,346125,820,100
2006EMPRESA MODELOFLUJO DE CAJA PROYECTADOPARA EL AO: 2006CONCEPTOENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBREINGRESOS DE EFECTIVO:SALDO INICIAL EN CAJA125,820,100119,364,978114,217,382107,671,571101,525,99396,060,52892,187,91388,998,98496,222,247107,032,960119,114,377169,166,542INGRESOS POR VENTAS18,718,38018,718,38018,718,38018,718,38018,718,38018,718,38019,902,98438,946,19245,416,57447,680,416117,160,41650,028,000DEBITO FISCAL (IVA)2,620,5732,620,5732,620,5732,620,5732,620,5732,620,5732,786,4185,452,4676,358,3206,675,25816,402,4587,003,920PRSTAMOS000000000000OTROS INGRESOS EN EFECTIVOTOTAL INGRESOS147,159,053140,703,931135,556,335129,010,524122,864,946117,399,481114,877,315133,397,643147,997,141161,388,634252,677,251226,198,462DESEMBOLSOS EN EFECTIVO:COMPRA DE MATERIA PRIMA8,500,0008,500,0008,500,0008,500,0008,500,0008,500,0009,035,95517,681,57120,619,12521,646,90853,190,82822,712,712GASTO DE ADMINISTRACION300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000MANTENIMIENTO VEHICULO200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000200,000GASTOS DE TRANSPORTE80,00080,00080,00080,00080,00080,00080,00080,00080,00080,00080,00080,000ELECTRICIDAD Y AGUA320,000320,000320,000320,000320,000320,000320,000320,000320,000320,000320,000320,000GASTO DE PRODUCCION4,200,0004,200,0004,200,0004,200,0004,200,0004,200,0004,200,0004,200,0004,200,0004,200,0004,200,00015,000,000SUELDOS Y SALARIOS3,000,0003,000,0003,000,0003,000,0003,600,0003,600,0003,600,0003,600,0003,600,0003,600,0003,600,00014,400,000CREDITO FISCAL (IVA)1,290,8001,290,8001,290,8001,290,8001,290,8001,290,8001,365,8342,576,2202,987,4783,131,3677,547,5163,280,580OBLIGACIONES BANCARIAS4,200,0003,000,0004,500,0004,200,0003,000,0001,450,0001,450,0001,450,0001,450,0001,450,0001,450,0001,450,000HIPOTECA POR PAGAR2,728,2922,752,0742,776,0952,800,3562,824,8602,850,6082,877,6042,904,8502,932,3492,960,1022,988,1133,016,384INTERESES Y COMISIONES1,645,2101,513,9021,388,0961,263,6021,158,9851,090,3871,028,354986,508904,387841,989779,310716,349PAGO DE IMPUESTO (IVA)1,329,7731,329,7731,329,7731,329,7731,329,7731,329,7731,420,5842,876,2473,370,8433,543,8918,854,9423,723,340OTROS EGRESOS EN EFECTIVOTOTAL EGRESOS27,794,07526,486,54927,884,76427,484,53126,804,41825,211,56825,878,33137,175,39640,964,18142,274,25783,510,70965,199,365SALDO FINAL EN CAJA119,364,978114,217,382107,671,571101,525,99396,060,52892,187,91388,998,98496,222,247107,032,960119,114,377169,166,542160,999,097
2007EMPRESA MODELOFLUJO DE CAJA PROYECTADOPARA EL AO: 2007CONCEPTOENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBREINGRESOS DE EFECTIVO:SALDO INICIAL EN CAJA160,999,097157,643,128154,321,885152,505,434152,355,202151,337,758150,385,891150,245,191162,614,389179,255,769197,413,207261,126,730INGRESOS POR VENTAS22,462,05622,462,05622,462,05622,462,05622,462,05622,462,05623,883,58146,735,43054,499,88957,216,499140,592,49960,033,600DEBITO FISCAL (IVA)3,144,6883,144,6883,144,6883,144,6883,144,6883,144,6883,343,7016,542,9607,629,9848,010,31019,682,9508,404,704PRSTAMOS000000000000OTROS INGRESOS EN EFECTIVOTOTAL INGRESOS186,605,841183,249,872179,928,629178,112,178177,961,946176,944,502177,613,173203,523,582224,744,262244,482,578357,688,657329,565,034DESEMBOLSOS EN EFECTIVO:COMPRA DE MATERIA PRIMA10,200,00010,200,00010,200,00010,200,00010,200,00010,200,00010,843,14621,217,88524,742,95025,976,29063,828,99427,255,254GASTO DE ADMINISTRACION360,000360,000360,000360,000360,000360,000360,000360,000360,000360,000360,000360,000MANTENIMIENTO VEHICULO240,000240,000240,000240,000240,000240,000240,000240,000240,000240,000240,000240,000GASTOS DE TRANSPORTE100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000ELECTRICIDAD Y AGUA370,000370,000370,000370,000370,000370,000370,000370,000370,000370,000370,000370,000GASTO DE PRODUCCION5,000,0005,000,0005,000,0005,000,0005,000,0005,000,0005,000,0005,000,0005,000,0005,000,0005,000,00017,000,000SUELDOS Y SALARIOS4,400,0004,400,0004,400,0004,400,0005,300,0005,300,0005,300,0005,300,0005,300,0005,300,0005,300,00021,200,000CREDITO FISCAL (IVA)1,547,0001,547,0001,547,0001,547,0001,547,0001,547,0001,637,0403,089,5043,583,0133,755,6819,055,0593,934,736OBLIGACIONES BANCARIAS1,450,0001,450,0001,450,0001,450,0001,450,0001,450,0001,450,0001,450,0001,450,0001,450,0001,450,0001,450,000HIPORTECA POR PAGAR3,044,9233,073,7321,625,305000000000INTERESES Y COMISIONES653,102589,567533,202492,288459,500393,923361,135328,347295,559262,771229,983197,195PAGO DE IMPUESTO (IVA)1,597,6881,597,6881,597,6881,597,6881,597,6881,597,6881,706,6613,453,4564,046,9714,254,62910,627,8914,469,968OTROS EGRESOS EN EFECTIVOTOTAL EGRESOS28,962,71328,927,98727,423,19525,756,97626,624,18826,558,61127,367,98240,909,19245,488,49347,069,37096,561,92676,577,153SALDO FINAL EN CAJA157,643,128154,321,885152,505,434152,355,202151,337,758150,385,891150,245,191162,614,389179,255,769197,413,207261,126,730252,987,881
2008LA FORTALEZA, C.A.EMPRESA MODELOPARA EL AO: 2008CONCEPTOENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBREINGRESOS DE EFECTIVO:SALDO INICIAL EN CAJA252,987,881253,567,942254,200,791254,866,428255,564,853255,236,067255,234,784257,323,306274,384,360296,532,686320,460,938399,017,145INGRESOS POR VENTAS26,954,46726,954,46726,954,46726,954,46726,954,46726,954,46728,660,29756,082,51665,399,86768,659,799168,710,99972,040,320DEBITO FISCAL (IVA)3,773,6253,773,6253,773,6253,773,6253,773,6253,773,6254,012,4427,851,5529,155,9819,612,37223,619,54010,085,645PRSTAMOS000000000000OTROS INGRESOS EN EFECTIVOTOTAL INGRESOS283,715,973284,296,034284,928,884285,594,521286,292,946285,964,159287,907,522321,257,374348,940,208374,804,857512,791,477481,143,109DESEMBOLSOS EN EFECTIVO:COMPRA DE MATERIA PRIMA12,240,00012,240,00012,240,00012,240,00012,240,00012,240,00013,011,77525,461,46229,691,54031,171,54876,594,79232,706,305GASTO DE ADMINISTRACION450,000450,000450,000450,000450,000450,000450,000450,000450,000450,000450,000450,000MANTENIMIENTO VEHICULO250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000GASTOS DE TRANSPORTE120,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000100,000ELECTRICIDAD Y AGUA400,000400,000400,000400,000400,000400,000400,000400,000400,000400,000400,000400,000GASTO DE PRODUCCION6,000,0006,000,0006,000,0006,000,0006,000,0006,000,0006,000,0006,000,0006,000,0006,000,0006,000,00015,000,000SUELDOS Y SALARIOS5,300,0005,300,0005,300,0005,300,0006,360,0006,360,0006,360,0006,360,0006,360,0006,360,0006,360,00025,440,000CREDITO FISCAL (IVA)1,850,1001,850,1001,850,1001,850,1001,850,1001,850,1001,958,1493,701,1054,293,3164,500,51710,859,7714,715,383OBLIGACIONES BANCARIAS1,450,0001,450,0001,450,0001,450,0001,450,0001,150,000000000HIPORTECA POR PAGAR000000000000INTERESES Y COMISIONES164,406131,61898,83066,04233,2545,750000000PAGO DE IMPUESTO (IVA)1,923,5251,923,5251,923,5251,923,5251,923,5251,923,5252,054,2934,150,4484,862,6665,111,85512,759,7695,370,262OTROS EGRESOS EN EFECTIVOTOTAL EGRESOS30,148,03130,095,24330,062,45530,029,66731,056,87930,729,37530,584,21746,873,01552,407,52154,343,919113,774,33284,431,950SALDO FINAL EN CAJA253,567,942254,200,791254,866,428255,564,853255,236,067255,234,784257,323,306274,384,360296,532,686320,460,938399,017,145396,711,159
