Flujo de efectivo Anual

Anlisis Anual 2014Anlisis Anual De Flujo de Efectivo[Nombre del Negocio]EneroFebreroMarzoAbrilMayoJunioJulioAgostoSeptiembreOctubreNoviembreDiciembreTotalFlujo Inicial de Efectivo2,833,469.002,843,360.342,705,746.262,702,889.932,568,657.142,358,886.102,224,767.092,084,272.55Entradas0.0Ingresos por Venta de Alimentos0.00.00.00.0441,459.38234,281.25412,978.13270,571.88124,031.25242,090.63261,843.75669,309.382,656,565.63Ingresos por Venta de Bebidas0.00.00.00.0386,922.63205,338.75361,959.88237,146.13108,708.75212,183.38229,496.25586,624.632,328,380.38Ingresos por Video Juegos0.00.00.00.042,250.0037,770.0040,680.0027,850.0045,890.0041,385.0029,600.0064,735.00330,160.00Ingresos por Renta de Salones0.00.00.00.021,600.009,000.0028,800.007,200.0010,800.0010,800.009,000.0043,200.00140,400.00Ingresos por Banquetes0.00.00.00.027,200.006,800.0013,600.000.013,600.006,800.006,800.0054,400.00129,200.00Intereses Bancarios Ganados0.00.00.00.01,416.731,421.681,352.871,351.441,284.331,179.441,112.381,042.1410,161.02Otros:0.00.00.00.01,500.00900.00900.00900.001,500.001,200.001,200.005,400.0013,500.00Total de Entradas0.00.00.00.0922,348.73495,511.68860,270.87545,019.44305,814.33515,638.44539,052.381,424,711.145,608,367.02SalidasProveedores0.00.00.00.0494,984.57258,760.37456,958.29294,804.00142,133.64267,269.14288,791.33866,114.853,069,816.20Honorarios por Entretenimiento0.00.00.00.063,100.0033,500.0038,000.0033,500.0042,000.0034,500.0033,500.0072,600.00350,700.00Gasolinas y peajes0.00.00.00.05,400.003,200.003,200.003,200.003,900.003,200.003,000.008,900.0034,000.00Cargos Financieros0.00.00.00.0270.00270.00270.00270.00270.00270.00270.00270.002,160.00ISR0.00.00.00.041,505.6922,298.0338,712.1924,525.8813,761.6423,203.7324,257.3664,112.00252,376.52Cursos y Seminarios0.00.00.00.00.00.05,000.000.00.00.05,000.000.010,000.00Beneficios a empleados0.00.00.00.01,147.63673.471,122.34682.97516.19715.20684.341,795.617,337.75Tenencias Vehiculares0.00.00.00.00.00.00.00.00.00.00.00.00.0Rentas0.00.00.00.072,000.0072,000.0072,000.0072,000.0072,000.0072,000.0072,000.0072,000.00576,000.00Telfonos0.00.00.00.0999.00999.00999.00999.00999.00999.00999.00999.007,992.00Articulos de Aseo y Limpieza0.00.00.00.01,350.00620.00350.001,200.00450.001,320.00690.00860.006,840.00Seguros0.00.00.00.05,800.005,800.005,800.005,800.005,800.005,800.005,800.005,800.0046,400.00Seguridad Privada0.00.00.00.014,400.0014,400.0014,400.0014,400.0014,400.0014,400.0014,400.0014,400.00115,200.00Mobiliario y Equipo0.00.00.00.018,000.004,000.000.06,000.000.00.013,000.000.041,000.00Gastos Varios0.00.00.00.01,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.008,000.00Sistemas y Equipo de Computo0.00.00.00.07,500.00620.00500.00500.00500.00500.00750.00500.0011,370.00Intereses sobre Prestamos0.00.00.00.00.025,772.7325,478.7025,181.0824,879.8324,574.9224,266.3023,953.91174,107.47Papeleria y Equipo de Oficina0.00.00.00.0580.00320.00495.00550.00190.00260.00740.00580.003,715.00Nmina0.00.00.00.090,830.0087,900.0090,830.0090,830.0087,900.0090,830.0087,900.0090,830.00717,850.00Impuestos sobre Nmina0.00.00.00.031,790.5030,765.0031,790.5031,790.5030,765.0031,790.5030,765.0031,790.50251,247.50Publicidad0.00.00.00.037,200.0036,000.0037,200.0037,200.0036,000.0037,200.0036,000.0037,200.00294,000.00Mantenimiento0.00.00.00.04,500.000.04,500.000.00.04,500.000.00.013,500.00TV Satelital0.00.00.00.0450.00450.00450.00450.00450.00450.00450.00450.003,600.00Mantenimiento de Equipo de Transporte0.00.00.00.01,650.001,650.001,650.001,650.001,650.001,650.001,650.001,650.0013,200.00Subtotal0.00.00.00.0894,457.40600,998.59830,706.01646,533.42479,565.31616,432.49645,913.331,295,805.876,010,412.43Otras Salidas de EfectivoDeuda Principal32,127.1632,421.1932,718.8133,020.0633,324.9733,633.5933,945.98231,191.76Utilidades a socios / Dueo625,000.00625,000.00Otros0.00.00.00.018,000.000.00.00.03,000.000.00.018,000.0039,000.00Subtotal0.00.00.00.018,000.0032,127.1632,421.1932,718.8136,020.0633,324.9733,633.59676,945.98895,191.76Total Salidas0.00.00.00.0912,457.40633,125.75863,127.20679,252.23515,585.37649,757.46679,546.921,972,751.850.06,905,604.19Balance de Flujo de Efectivo Final0.00.00.00.02,843,360.342,705,746.262,702,889.932,568,657.142,358,886.102,224,767.092,084,272.551,536,231.84

Analisis Anual 2015Anlisis Anual De Flujo de Efectivo[Nombre del Negocio]EneroFebreroMarzoAbrilMayoJunioJulioAgostoSeptiembreOctubreNoviembreDiciembreTotalFlujo Inicial de Efectivo1,536,231.841,126,233.13806,288.09646,664.10532,136.99585,927.44477,078.30534,195.24435,790.22241,088.81142,625.3934,999.96EntradasIngresos por Venta de Alimentos159,694.42173,088.14207,602.73262,723.05495,052.60262,723.05463,113.72303,419.35139,088.70271,480.48293,631.63750,563.593,782,181.450.025,918.200.017,278.8034,557.608,639.4017,278.800.017,278.808,639.408,639.4069,115.20Ingresos por Venta de Bebidas139,966.19151,705.29181,956.03230,266.93433,895.08230,266.93405,901.86265,935.72121,906.04237,942.49257,357.15657,840.913,314,940.61149,483.94162,021.30194,329.09245,925.13463,400.00245,925.13433,503.23284,019.40130,195.71254,122.63274,857.48702,574.14Ingresos por Video Juegos40,215.0039,249.0043,454.2542,052.5044,362.5039,658.5042,714.0029,242.5048,184.5043,454.2531,080.0067,971.75511,638.75Ingresos por Renta de Salones6,237.0010,395.008,316.0012,474.0024,948.0010,395.0033,264.008,316.0012,474.0012,474.0010,395.0049,896.00199,584.000.027,214.110.018,142.7436,285.489,071.3718,142.740.018,142.749,071.379,071.3772,570.96Ingresos por Banquetes0.023,562.000.015,708.0031,416.007,854.0015,708.000.015,708.007,854.007,854.0062,832.00188,496.00156,958.14170,122.36204,045.55258,221.38486,570.00258,221.38455,178.39298,220.37136,705.49266,828.76288,600.36737,702.85Intereses Bancarios Ganados0.0563.12403.14323.33266.07292.96238.54267.10217.90120.5471.3117.502,781.51Otros:0.0600.001,500.001,200.001,500.00900.00900.00900.001,500.001,200.001,200.005,400.0016,800.00Total de Entradas346,112.61399,162.55443,232.16564,747.811,031,440.25552,090.44961,840.12608,080.67339,079.14574,525.76601,589.091,594,521.748,016,422.33SalidasProveedores374,349.36323,294.05218,994.38284,732.99537,404.75280,936.13496,119.61320,068.70154,314.50290,174.10313,540.75940,340.894,534,270.21393,066.83339,458.75229,944.09298,969.63564,274.99294,982.94520,925.59336,072.14162,030.22304,682.81329,217.79987,357.94Honorarios por Entretenimiento36,750.0065,100.0036,225.0040,215.0066,255.0035,175.0039,900.0035,175.0044,100.0036,225.0035,175.0076,230.00546,525.0038,587.5068,355.0038,036.2542,225.7569,567.7536,933.7541,895.0036,933.7546,305.0038,036.2536,933.7580,041.50Gasolinas y peajes3,780.004,410.003,780.004,725.005,670.003,360.003,360.003,360.004,095.003,360.003,150.009,345.0052,395.003,969.004,630.503,969.004,961.255,953.503,528.003,528.003,528.004,299.753,528.003,307.509,812.25Cargos Financieros283.50283.50283.50283.50283.50283.50283.50283.50283.50283.50283.50283.503,402.00297.68297.68297.68297.68297.68297.68297.68297.68297.68297.68297.68297.68ISR15,575.0717,962.3119,945.4525,413.6546,414.8124,844.0743,282.8127,363.6315,258.5625,853.6627,071.5171,753.48360,739.0040,516.8871,772.7539,938.0644,337.0473,046.1438,780.4443,989.7538,780.4448,620.2539,938.0638,780.4484,043.58Cursos y Seminarios5,000.000.00.05,000.000.00.05,000.000.00.00.05,000.000.020,000.004,167.454,862.034,167.455,209.316,251.183,704.403,704.403,704.404,514.743,704.403,472.8810,302.86Beneficios a empleados531.92573.01648.41765.621,275.50743.261,248.91757.15564.29789.06758.361,997.7410,653.24312.56312.56312.56312.56312.56312.56312.56312.56312.56312.56312.56312.56Tenencias Vehiculares0.00.00.02,480.000.00.00.00.00.00.00.00.02,480.0042,542.7275,361.3941,934.9746,553.8976,698.4440,719.4646,189.2440,719.4651,051.2641,934.9740,719.4688,245.75Rentas72,000.0072,000.0072,000.0072,000.0072,000.0072,000.0072,000.0072,000.0072,000.0072,000.0072,000.0072,000.00864,000.004,375.825,105.134,375.825,469.786,563.733,889.623,889.623,889.624,740.473,889.623,646.5210,818.01Telfonos999.00999.00999.00999.00999.00999.00999.00999.00999.00999.00999.00999.0011,988.00328.19328.19328.19328.19328.19328.19328.19328.19328.19328.19328.19328.19Articulos de Aseo y Limpieza399.00756.00630.001,029.001,417.50651.00367.501,260.00472.501,386.00724.50903.009,996.00418.95793.80661.501,080.451,488.38683.55385.881,323.00496.131,455.30760.73948.15Seguros5,400.005,400.005,400.005,400.005,400.005,400.005,400.005,400.005,400.005,400.005,400.005,400.0064,800.005,670.005,670.005,670.005,670.005,670.005,670.005,670.005,670.005,670.005,670.005,670.005,670.00Seguridad Privada15,120.0015,120.0015,120.0015,120.0015,120.0015,120.0015,120.0015,120.0015,120.0015,120.0015,120.0015,120.00181,440.0015,876.0015,876.0015,876.0015,876.0015,876.0015,876.0015,876.0015,876.0015,876.0015,876.0015,876.0015,876.00Mobiliario y Equipo4,000.000.07,000.000.00.04,000.000.03,000.000.00.012,000.000.030,000.004,200.000.07,350.000.00.04,200.000.03,150.000.00.012,600.000.0Gastos Varios1,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.0012,000.001,050.001,050.001,050.001,050.001,050.001,050.001,050.001,050.001,050.001,050.001,050.001,050.00Sistemas y Equipo de Computo580.00750.00580.00500.00180.00620.00500.00500.00500.00500.00750.00500.006,460.00609.00787.50609.00525.00189.00651.00525.00525.00525.00525.00787.50525.00Intereses sobre Prestamos23,637.7223,317.6822,993.7422,665.8522,333.9821,998.0521,658.0421,313.8920,965.5420,612.9520,256.0719,894.84261,648.3524,819.6124,483.5624,143.4323,799.1423,450.6823,097.9522,740.9422,379.5822,013.8221,643.6021,268.8720,889.58Papeleria y Equipo de Oficina713.46289.52620.40134.42599.72330.88511.83568.70196.46268.84765.16599.725,599.11737.72299.36641.49138.99620.11342.13529.23588.04203.14277.98791.18620.11Nmina95,371.5086,142.0095,371.5092,295.0095,371.5092,295.0095,371.5095,371.5092,295.0095,371.5092,295.0095,371.501,122,922.50100,140.0890,449.10100,140.0896,909.75100,140.0896,909.75100,140.08100,140.0896,909.75100,140.0896,909.75100,140.08Impuestos sobre Nmina33,380.0330,149.7033,380.0332,303.2533,380.0332,303.2533,380.0333,380.0332,303.2533,380.0332,303.2533,380.03393,022.8835,049.0331,657.1935,049.0333,918.4135,049.0333,918.4135,049.0335,049.0333,918.4135,049.0333,918.4135,049.03Publicidad28,000.0032,000.0028,000.0032,000.0032,000.0028,000.0028,000.0028,000.0032,000.0028,000.0028,000.0032,000.00356,000.0029,400.0033,600.0029,400.0033,600.0033,600.0029,400.0029,400.0029,400.0033,600.0029,400.0029,400.0033,600.00Mantenimiento1,800.001,800.001,800.001,800.001,800.001,800.001,800.001,800.001,800.001,800.001,800.001,800.0021,600.001,890.001,890.001,890.001,890.001,890.001,890.001,890.001,890.001,890.001,890.001,890.001,890.00TV Satelital472.50472.50472.50472.50472.50472.50472.50472.50472.50472.50472.50472.505,670.00496.13496.13496.13496.13496.13496.13496.13496.13496.13496.13496.13496.13Mantenimiento de Equipo de Transporte1,706.101,706.101,706.101,706.101,706.101,706.101,706.101,706.101,706.101,706.101,706.101,706.1020,473.201,764.111,764.111,764.111,764.111,764.111,764.111,764.111,764.111,764.111,764.111,764.111,764.11Subtotal720,849.15683,525.37566,950.00643,040.88941,083.89624,037.74867,481.32668,899.70495,846.19634,702.24670,570.701,381,097.308,898,084.49Otras Salidas de EfectivoDeuda Principal34,262.1734,582.2134,906.1535,234.0435,565.9135,901.8436,241.8536,586.0036,934.3537,286.9437,643.8238,005.05433,150.33Utilidades a socios / Dueo625,000.00625,000.00Otros1,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.0012,000.00Subtotal35,262.1735,582.2135,906.1536,234.0436,565.9136,901.8437,241.8537,586.0037,934.3538,286.9438,643.82664,005.051,070,150.33Total Salidas756,111.32719,107.58602,856.15679,274.92977,649.80660,939.58904,723.17706,485.70533,780.54672,989.18709,214.522,045,102.350.09,968,234.82Balance de Flujo de Efectivo Final1,126,233.13806,288.09646,664.10532,136.99585,927.44477,078.30534,195.24435,790.22241,088.81142,625.3934,999.96(415,580.65)