Preparacion flujo caja y estado resultado

EERR |Enero |Febrero |Marzo |Abril |Mayo |Junio |Julio |Agosto |Septiembre |Octubre |Noviembre |Diciembre |Total |Total % | |ventas netas |$ 20,916,799 |$ 21,361,110 |$ 21,561,904 |$ 21,361,110 |$ 21,361,110 |$ 21,993,399 |$ 21,361,110 |$ 22,877,749 |$ 21,361,110 |$ 21,361,110 |$ 21,361,110 |$ 23,322,060 |$ 260,199,681 |100.00% | |costo venta |$ 5,298,157 |$ 5,142,843 |$ 5,403,071 |$ 5,142,843 |$5,142,843 |$ 5,402,042 |$ 5,142,843 |$ 5,453,985 |$ 5,142,843 |$ 5,142,843 |$ 5,142,843 |$ 5,560,442 |$ 63,117,598 |24.26% | |mg bruto |$ 15,618,642 |$ 16,218,267 |$ 16,158,834 |$ 16,218,267 |$ 16,218,267 |$ 16,591,357 |$ 16,218,267 |$ 17,423,764 |$ 16,218,267 |$ 16,218,267 |$ 16,218,267 |$ 17,761,618 |$ 197,082,083 |75.74% | |mg bruto % |75% |76% |75% |76% |76% |75% |76% |76% |76% |76% |76% |76%|76% |  | |Gasto Administración |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 30,000,000 |11.53% | |Gasto Finanzas |$ 3,124,800 |$ 2,976,000 |$ 3,154,560 |$ 2,976,000 |$ 2,976,000 |$ 3,184,320 |$ 2,976,000 |$ 3,065,280 |$ 2,976,000 |$ 2,976,000 |$ 2,976,000 |$ 3,035,520 |$ 36,396,480|13.99% | |Gasto Ventas |$ 2,177,700 |$ 2,135,000 |$ 2,177,700 |$ 2,135,000 |$ 2,135,000 |$ 2,177,700 |$ 2,135,000 |$ 2,177,700 |$ 2,135,000 |$ 2,135,000 |$ 2,135,000 |$ 2,177,700 |$ 25,833,500 |9.93% | |Gasto MKT |$ 3,331,125 |$ 3,172,500 |$ 3,394,575 |$ 13,747,500 |$ 3,172,500 |$ 3,458,025 |$ 3,172,500 |$ 3,267,675 |$ 3,172,500 |$ 3,172,500 |$ 3,172,500 |$ 3,235,950 |$ 49,469,850 |19.01% | |gastoOperaciones |$ 1,841,100 |$ 1,805,000 |$ 1,859,150 |$ 1,805,000 |$ 1,805,000 |$ 1,678,650 |$ 1,805,000 |$ 1,660,600 |$ 1,805,000 |$ 1,805,000 |$ 1,805,000 |$ 1,642,550 |$ 21,317,050 |8.19% | |Total Gastos |$ 12,974,725 |$ 12,588,500 |$ 13,085,985 |$ 23,163,500 |$ 12,588,500 |$ 12,998,695 |$ 12,588,500 |$ 12,671,255 |$ 12,588,500 |$ 12,588,500 |$ 12,588,500 |$ 12,591,720 |$ 163,016,880 |62.65% ||margen neto Aimpto |$ 2,643,917 |$ 3,629,767 |$ 3,072,849 |-$ 6,945,233 |$ 3,629,767 |$ 3,592,662 |$ 3,629,767 |$ 4,752,509 |$ 3,629,767 |$ 3,629,767 |$ 3,629,767 |$ 5,169,898 |$ 34,065,203 |13.09% | |impuesto renta |$ 528,783 |$ 725,953 |$ 614,570 |-$ 1,389,047 |$ 725,953 |$ 718,532 |$ 725,953 |$ 950,502 |$ 725,953 |$ 725,953 |$ 725,953 |$ 1,033,980 |$ 6,813,041 |2.62% | |margen neto d imp |$2,115,134 |$ 2,903,814 |$ 2,458,279 |-$ 5,556,186 |$ 2,903,814 |$ 2,874,129 |$ 2,903,814 |$ 3,802,007 |$ 2,903,814 |$ 2,903,814 |$ 2,903,814 |$ 4,135,918 |$ 27,252,162 |10.47% | |margen neto d imp % |10.11% |13.59% |11.40% |-26.01% |13.59% |13.07% |13.59% |16.62% |13.59% |13.59% |13.59% |17.73% |10.47% |  | |EERR |Enero |Febrero |Marzo |Abril |Mayo |Junio |Julio |Agosto |Septiembre |Octubre|Noviembre |Diciembre |Total |Total % | |ventas netas |$ 20,916,799 |$ 21,361,110 |$ 21,561,904 |$ 21,361,110 |$ 21,361,110 |$ 21,993,399 |$ 21,361,110 |$ 22,877,749 |$ 21,361,110 |$ 21,361,110 |$ 21,361,110 |$ 23,322,060 |$ 260,199,681 |100.00% | |costo venta |$ 5,298,157 |$ 5,142,843 |$ 5,403,071 |$ 5,142,843 |$ 5,142,843 |$ 5,402,042 |$ 5,142,843 |$ 5,453,985 |$ 5,142,843 |$ 5,142,843 |$ 5,142,843 |$5,560,442 |$ 63,117,598 |24.26% | |mg bruto |$ 15,618,642 |$ 16,218,267 |$ 16,158,834 |$ 16,218,267 |$ 16,218,267 |$ 16,591,357 |$ 16,218,267 |$ 17,423,764 |$ 16,218,267 |$ 16,218,267 |$ 16,218,267 |$ 17,761,618 |$ 197,082,083 |75.74% | |mg bruto % |75% |76% |75% |76% |76% |75% |76% |76% |76% |76% |76% |76% |76% |  | |Gasto Administración |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 2,500,000 |$ 30,000,000 |11.53% | |Gasto Finanzas |$ 3,124,800 |$ 2,976,000 |$ 3,154,560 |$ 2,976,000 |$ 2,976,000 |$ 3,184,320 |$ 2,976,000 |$ 3,065,280 |$ 2,976,000 |$ 2,976,000 |$ 2,976,000 |$ 3,035,520 |$ 36,396,480 |13.99% | |Gasto Ventas |$ 2,177,700 |$ 2,135,000 |$ 2,177,700 |$ 2,135,000 |$ 2,135,000 |$...