Hoja1REGION: RIOBAMBA ROL DE PAGOS INTEGRALMES: DICIEMBRE 2014

TRABAJADORCARGO#. DIAS PAGADOSHORAS SUPLEMETNTARIASHORAS EXTRAORDINARIAS INGRESOS12345678910111213SALARIO UNIFICADOHORAS SUPLEM.HORAS EXTRASCOMISION VENTAINGRESOS APORTE IESSFONDO DE RESERVASUBSIDIO FAMILIARBONIFICACION AL SERVICIO (7%)DECIMO TERCER SUELDODECIMO CUARTO SUELDOVACACIONESTOTALTOTAL A PAGAR LA HORAJOSE RODRIGUESG30-16$ 1,000.00-$ 133.33-$ 121.50$ 83.33$ 10.00$ 70.00$ 95.28$ 28.33$ 47.64$ 1,589.42$ 6.62TATYANA FIALLOSS.C30-16$ 500.00-$ 66.67-$ 60.75$ 41.67$ 10.00$ 35.00$ 48.06$ 28.33$ 24.03$ 814.50$ 3.39DIEGO ALVAREZJ.P30-16$ 620.00-$ 82.67-$ 75.33$ 51.67$ 10.00$ 43.40$ 59.39$ 28.33$ 29.69$ 1,000.48$ 4.17LUIS ULLOAO30-16$ 360.00-$ 48.00-$ 43.74$ 30.00$ 30.00$ 25.20$ 36.50$ 28.33$ 18.25$ 620.02$ 2.58JORGE MORENOO30-16$ 385.00-$ 51.33-$ 46.78$ 32.08$ 30.00-$ 25.91$ 18.89$ 19.43$ 609.42$ 2.54$ 2,865.00$ 382.00$ 348.10$ 238.75$ 90.00$ 173.60$ 265.13$ 132.22$ 139.04$ 4,633.84

Hoja2GASTOS FINANCIEROSTABLA DE AMORTIZACION A 3 AOS PERIODOCUOTAINTERES (MES)MONTOSALDOINTERES ANUAL10.0--$ 18,490.0015.96%2$ 513.61$ 245.92$ 759.53$ 17,976.3915.96%3$ 513.61$ 239.09$ 752.70$ 17,462.7815.96%4$ 513.61$ 232.25$ 745.87$ 16,949.1715.96%5$ 513.61$ 225.42$ 739.04$ 16,435.5615.96%6$ 513.61$ 218.59$ 732.20$ 15,921.9415.96%7$ 513.61$ 211.76$ 725.37$ 15,408.3315.96%8$ 513.61$ 204.93$ 718.54$ 14,894.7215.96%9$ 513.61$ 198.10$ 711.71$ 14,381.1115.96%10$ 513.61$ 191.27$ 704.88$ 13,867.5015.96%11$ 513.61$ 184.44$ 698.05$ 13,353.8915.96%12$ 513.61$ 177.61$ 691.22$ 12,840.2815.96%13$ 513.61$ 170.78$ 684.39$ 12,326.6715.96%14$ 513.61$ 163.94$ 677.56$ 11,813.0615.96%15$ 513.61$ 157.11$ 670.72$ 11,299.4415.96%16$ 513.61$ 150.28$ 663.89$ 10,785.8315.96%17$ 513.61$ 143.45$ 657.06$ 10,272.2215.96%18$ 513.61$ 136.62$ 650.23$ 9,758.6115.96%19$ 513.61$ 129.79$ 643.40$ 9,245.0015.96%20$ 513.61$ 122.96$ 636.57$ 8,731.3915.96%21$ 513.61$ 116.13$ 629.74$ 8,217.7815.96%22$ 513.61$ 109.30$ 622.91$ 7,704.1715.96%23$ 513.61$ 102.47$ 616.08$ 7,190.5615.96%24$ 513.61$ 95.63$ 609.25$ 6,676.9415.96%25$ 513.61$ 88.80$ 602.41$ 6,163.3315.96%26$ 513.61$ 81.97$ 595.58$ 5,649.7215.96%27$ 513.61$ 75.14$ 588.75$ 5,136.1115.96%28$ 513.61$ 68.31$ 581.92$ 4,622.5015.96%29$ 513.61$ 61.48$ 575.09$ 4,108.8915.96%30$ 513.61$ 54.65$ 568.26$ 3,595.2815.96%31$ 513.61$ 47.82$ 561.43$ 3,081.6715.96%32$ 513.61$ 40.99$ 554.60$ 2,568.0615.96%33$ 513.61$ 34.16$ 547.77$ 2,054.4415.96%34$ 513.61$ 27.32$ 540.94$ 1,540.8315.96%35$ 513.61$ 20.49$ 534.10$ 1,027.2215.96%36$ 513.61$ 13.66$ 527.27$ 513.6115.96%37$ 513.61$ 6.83$ 520.44$ 0.0015.96%