PRESUPUESTO PROYECTO VIDEO JUEGO ARQUINAUT

INICIO MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 TOTAL PROYECTO INGRESOSSaldo que viene $ - #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?Recursos ajenos $ 182,000,000 $ - $ 182,000,000 Cuentas por cobrar $ - $ - $ - Otros $ - $ - $ - TOTAL INGRESOS $ 182,000,000 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? $ 182,000,000

EGRESOS $ - Nomina Equipo Scrum $ - $ 11,500,000 $ 11,500,000 $ 11,500,000 $ 11,500,000 $ 11,500,000 $ 11,500,000 $ 69,000,000 Prestaciones sociales $ - $ 2,510,833 $ 2,510,833 $ 2,510,833 $ 2,510,833 $ 2,510,833 $ 2,510,833 $ 15,065,000 Parafiscales y Aportes $ - $ 2,877,530 $ 2,877,530 $ 2,877,530 $ 2,877,530 $ 2,877,530 $ 2,877,530 $ 17,265,180 Arriendo $ - $ 800,000 $ 800,000 $ 800,000 $ 800,000 $ 800,000 $ 800,000 $ 4,800,000 Servicios públicos $ - $ 220,000 $ 220,000 $ 220,000 $ 220,000 $ 220,000 $ 220,000 $ 1,320,000 Imprevistos $ - $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 600,000 Intereses prestamo $ - $ 2,564,683 $ 2,556,397 $ 2,547,993 $ 2,539,471 $ 2,530,829 $ 2,522,065 $ 15,261,438 Abono a prestamos $ - $ 588,062 $ 596,349 $ 604,753 $ 613,274 $ 621,917 $ 630,680 $ 3,655,035 Muebles y enseres $ 2,000,000 $ - $ 2,000,000 Equipos de computo $ 4,104,000 $ - $ 2,859,471 $ 6,963,471 Adquisición Software #NAME? $ - #NAME?Arrendamiento Software $ 120,325 $ 120,325 $ 120,325 $ 120,325 $ 120,325 $ 120,325 $ 721,950

$ - $ - TOTAL EGRESOS #NAME? $ 21,281,434 $ 21,281,434 $ 21,281,434 $ 24,140,905 $ 21,281,434 $ 21,281,434 #NAME?

$ - SALDO EN CAJA #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

INDICE

NÓMINA MENSUAL

CARGO SUELDO PRESTACIONES SOCIALES PARAFISCALES Y APORTES

CESANTIAS PRIMA VACACIONES SENA ICBF CAJA SALUD PENSION ARP

70,500 0.08 0.08 0.04 0.12 0% 0% 4% 8.5% 12% 0.52%Programador Senior 2,500,000 1 2,500,000 - 2,500,000 208,333 208,333 104,167 25,000 - - 100,000 212,500 300,000 13,050 Animador Senior 2,500,000 1 2,500,000 - 2,500,000 208,333 208,333 104,167 25,000 - - 100,000 212,500 300,000 13,050 Diseñador Gráfico Senior 2,500,000 1 2,500,000 - 2,500,000 208,333 208,333 104,167 25,000 - - 100,000 212,500 300,000 13,050 Ingeniero de Audio 1,500,000 1 1,500,000 - 1,500,000 125,000 125,000 62,500 15,000 - - 60,000 127,500 180,000 7,830 Scrum Master 2,500,000 1 2,500,000 - 2,500,000 208,333 208,333 104,167 25,000 - - 100,000 212,500 300,000 13,050

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

TOTALES 11,500,000 0 11,500,000 958,333 958,333 479,167 115,000 2,510,833 0 0 460,000 977,500 1,380,000 60,030TOTAL PROYECTO 69,000,000 5,750,000 5,750,000 2,875,000 690,000 15,065,000 0 0 2,760,000 5,865,000 8,280,000 360,180

NUMERO FUNCIONARIOS

TOTAL SUELDOS

AUXILIO TRANSPORTE TOTAL

DEVENGADO INTERESES

CESANTIAS TOTAL

PRESTACIONES

INDICE

NÓMINA MENSUAL

PARAFISCALES Y APORTES

2,877,530|

TOTAL APORTES

GASTOS

MES TOTAL PROYECTOARRIENDO 800,000 4,800,000

ENERGIA 90,000 540,000ACUEDUCTO 50,000 300,000TELEFONO 80,000 480,000

0 0Total Servicios 220,000 1,320,000

IMPREVISTOS 100,000 600,000

INDICE

INVERSIONES

ACTIVOS VALOR CANTIDAD VALOR TOTAL

Equipos de computo Equipos de computo 3,835,000 1 3,835,000Impresora 269,000 1 269,000TOTAL EQUIPOS DE COMUNICACIONES 4,104,000

Muebles y enseres 500,000 4 2,000,000TOTAL MUEBLES Y ENSERES 2,000,000Office 365 pequeña empresa premium 24,065 5 120,325 arriendo mensualArrandamiento de software 120,325TOTAL INVERSION 6,224,325

EspecificacionesEquipo de computo : Intel Core i7 950 DD 1 TB, memoria DDR 3 4GB, tarjeta de video AT IHD 7750 1 GB

Impresora: Multifuncional Hewlett Packard DESKJET INK ADVANTAGE 4625 AIO; 4 en 1, Impresora, escáner, copiadora y fax

arriendo mensual

PRESTAMOS

MONTO 182,000,000PERIODOS 120 MESESTASA 1.41% MENSUAL 16.91% ANUALCUOTA 3,152,746

TABLA DE AMORTIZACION

N SALDO QUE VIENE CUOTA INTERES SALDO QUE PASA

0 0 0 0 0 182,000,0001 182,000,000 3,152,746 588,062 2,564,683 181,411,9382 181,411,938 3,152,746 596,349 2,556,397 180,815,5893 180,815,589 3,152,746 604,753 2,547,993 180,210,8364 180,210,836 3,152,746 613,274 2,539,471 179,597,5625 179,597,562 3,152,746 621,917 2,530,829 178,975,6456 178,975,645 3,152,746 630,680 2,522,065 178,344,9657 178,344,965 3,152,746 639,568 2,513,178 177,705,3978 177,705,397 3,152,746 648,580 2,504,165 177,056,8179 177,056,817 3,152,746 657,720 2,495,026 176,399,097

10 176,399,097 3,152,746 666,988 2,485,757 175,732,10911 175,732,109 3,152,746 676,387 2,476,358 175,055,72212 175,055,722 3,152,746 685,919 2,466,827 174,369,80313 174,369,803 3,152,746 695,584 2,457,161 173,674,21914 173,674,219 3,152,746 705,386 2,447,359 172,968,83215 172,968,832 3,152,746 715,326 2,437,419 172,253,50616 172,253,506 3,152,746 725,407 2,427,339 171,528,09917 171,528,099 3,152,746 735,629 2,417,117 170,792,47118 170,792,471 3,152,746 745,995 2,406,751 170,046,47619 170,046,476 3,152,746 756,507 2,396,238 169,289,96920 169,289,969 3,152,746 767,168 2,385,578 168,522,80121 168,522,801 3,152,746 777,978 2,374,767 167,744,82222 167,744,822 3,152,746 788,941 2,363,804 166,955,88123 166,955,881 3,152,746 800,059 2,352,687 166,155,82224 166,155,822 3,152,746 811,333 2,341,412 165,344,48925 165,344,489 3,152,746 822,766 2,329,979 164,521,72326 164,521,723 3,152,746 834,360 2,318,385 163,687,36327 163,687,363 3,152,746 846,118 2,306,628 162,841,24528 162,841,245 3,152,746 858,041 2,294,705 161,983,20429 161,983,204 3,152,746 870,132 2,282,613 161,113,07230 161,113,072 3,152,746 882,394 2,270,352 160,230,67831 160,230,678 3,152,746 894,828 2,257,917 159,335,85032 159,335,850 3,152,746 907,438 2,245,308 158,428,41233 158,428,412 3,152,746 920,225 2,232,520 157,508,18734 157,508,187 3,152,746 933,193 2,219,553 156,574,99435 156,574,994 3,152,746 946,343 2,206,403 155,628,65136 155,628,651 3,152,746 959,678 2,193,067 154,668,97337 154,668,973 3,152,746 973,202 2,179,544 153,695,77138 153,695,771 3,152,746 986,916 2,165,830 152,708,85539 152,708,855 3,152,746 1,000,823 2,151,922 151,708,03240 151,708,032 3,152,746 1,014,926 2,137,819 150,693,10541 150,693,105 3,152,746 1,029,229 2,123,517 149,663,877

INDICE

ABONO AL CREDITO

42 149,663,877 3,152,746 1,043,732 2,109,013 148,620,14543 148,620,145 3,152,746 1,058,440 2,094,306 147,561,70544 147,561,705 3,152,746 1,073,355 2,079,390 146,488,35045 146,488,350 3,152,746 1,088,481 2,064,265 145,399,86946 145,399,869 3,152,746 1,103,819 2,048,926 144,296,05047 144,296,050 3,152,746 1,119,374 2,033,372 143,176,67748 143,176,677 3,152,746 1,135,148 2,017,598 142,041,52949 142,041,529 3,152,746 1,151,144 2,001,602 140,890,38550 140,890,385 3,152,746 1,167,365 1,985,380 139,723,02051 139,723,020 3,152,746 1,183,815 1,968,930 138,539,20552 138,539,205 3,152,746 1,200,497 1,952,248 137,338,70853 137,338,708 3,152,746 1,217,414 1,935,331 136,121,29354 136,121,293 3,152,746 1,234,570 1,918,176 134,886,72455 134,886,724 3,152,746 1,251,967 1,900,779 133,634,75756 133,634,757 3,152,746 1,269,609 1,883,136 132,365,14857 132,365,148 3,152,746 1,287,500 1,865,246 131,077,64858 131,077,648 3,152,746 1,305,643 1,847,103 129,772,00559 129,772,005 3,152,746 1,324,042 1,828,704 128,447,96360 128,447,963 3,152,746 1,342,700 1,810,046 127,105,26461 127,105,264 3,152,746 1,361,621 1,791,125 125,743,64362 125,743,643 3,152,746 1,380,808 1,771,938 124,362,83563 124,362,835 3,152,746 1,400,266 1,752,480 122,962,56964 122,962,569 3,152,746 1,419,998 1,732,748 121,542,57165 121,542,571 3,152,746 1,440,008 1,712,737 120,102,56366 120,102,563 3,152,746 1,460,300 1,692,445 118,642,26367 118,642,263 3,152,746 1,480,878 1,671,867 117,161,38568 117,161,385 3,152,746 1,501,746 1,650,999 115,659,63869 115,659,638 3,152,746 1,522,908 1,629,837 114,136,73070 114,136,730 3,152,746 1,544,369 1,608,377 112,592,36171 112,592,361 3,152,746 1,566,131 1,586,614 111,026,23072 111,026,230 3,152,746 1,588,201 1,564,545 109,438,02973 109,438,029 3,152,746 1,610,581 1,542,164 107,827,44874 107,827,448 3,152,746 1,633,277 1,519,468 106,194,17175 106,194,171 3,152,746 1,656,293 1,496,453 104,537,87876 104,537,878 3,152,746 1,679,633 1,473,113 102,858,24577 102,858,245 3,152,746 1,703,301 1,449,444 101,154,94478 101,154,944 3,152,746 1,727,304 1,425,442 99,427,64079 99,427,640 3,152,746 1,751,644 1,401,101 97,675,99680 97,675,996 3,152,746 1,776,328 1,376,418 95,899,66881 95,899,668 3,152,746 1,801,359 1,351,386 94,098,30982 94,098,309 3,152,746 1,826,744 1,326,002 92,271,56583 92,271,565 3,152,746 1,852,485 1,300,260 90,419,08084 90,419,080 3,152,746 1,878,590 1,274,156 88,540,49085 88,540,490 3,152,746 1,905,062 1,247,683 86,635,42786 86,635,427 3,152,746 1,931,908 1,220,838 84,703,51987 84,703,519 3,152,746 1,959,132 1,193,614 82,744,38888 82,744,388 3,152,746 1,986,739 1,166,006 80,757,64889 80,757,648 3,152,746 2,014,736 1,138,010 78,742,91390 78,742,913 3,152,746 2,043,127 1,109,619 76,699,78691 76,699,786 3,152,746 2,071,918 1,080,828 74,627,86892 74,627,868 3,152,746 2,101,114 1,051,631 72,526,75493 72,526,754 3,152,746 2,130,723 1,022,023 70,396,03194 70,396,031 3,152,746 2,160,748 991,997 68,235,28395 68,235,283 3,152,746 2,191,197 961,549 66,044,08696 66,044,086 3,152,746 2,222,074 930,671 63,822,01297 63,822,012 3,152,746 2,253,387 899,359 61,568,625

98 61,568,625 3,152,746 2,285,141 867,605 59,283,48499 59,283,484 3,152,746 2,317,342 835,403 56,966,142

100 56,966,142 3,152,746 2,349,998 802,748 54,616,144101 54,616,144 3,152,746 2,383,113 769,632 52,233,031102 52,233,031 3,152,746 2,416,695 736,050 49,816,336103 49,816,336 3,152,746 2,450,750 701,995 47,365,586104 47,365,586 3,152,746 2,485,285 667,460 44,880,300105 44,880,300 3,152,746 2,520,307 632,438 42,359,993106 42,359,993 3,152,746 2,555,823 596,923 39,804,170107 39,804,170 3,152,746 2,591,838 560,907 37,212,332108 37,212,332 3,152,746 2,628,362 524,384 34,583,970109 34,583,970 3,152,746 2,665,400 487,346 31,918,571110 31,918,571 3,152,746 2,702,960 449,786 29,215,611111 29,215,611 3,152,746 2,741,049 411,697 26,474,562112 26,474,562 3,152,746 2,779,675 373,071 23,694,887113 23,694,887 3,152,746 2,818,845 333,900 20,876,042114 20,876,042 3,152,746 2,858,567 294,178 18,017,475115 18,017,475 3,152,746 2,898,849 253,896 15,118,626116 15,118,626 3,152,746 2,939,699 213,047 12,178,927117 12,178,927 3,152,746 2,981,124 171,621 9,197,803118 9,197,803 3,152,746 3,023,133 129,612 6,174,670119 6,174,670 3,152,746 3,065,734 87,011 3,108,935120 3,108,935 3,152,746 3,108,935 43,810 0

INDICE