• Author / Uploaded
• Lucio Mendoza

Citation preview

No

Fecha Amortizacion Interes Capital 0 12/21/2018 1 1/21/2019 2888.61 963.33 2 2/21/2019 2,888.61 941.51 3 3/21/2019 2,888.61 919.45 4 4/21/2019 2,888.61 897.13 5 5/21/2019 2,888.6124 874.56 6 6/21/2019 2,888.6124 851.73 7 7/21/2019 2,888.6124 828.64845421 8 8/21/2019 2,888.6124 805.30219616 9 9/21/2019 2,888.6124 781.69134719 10 10/21/2019 2,888.6124 757.8129086 11 11/21/2019 2,888.6124 733.6638477 12 12/21/2019 2,888.6124 709.24109745 13 1/21/2020 2,888.6124 684.54155603 14 2/21/2020 2,888.6124 659.56208647 15 3/21/2020 2,888.6124 634.29951626 16 4/21/2020 2,888.6124 608.75063692 17 5/21/2020 2,888.6124 582.91220361 18 6/21/2020 2,888.6124 556.78093473 19 7/21/2020 2,888.6124 530.35351146 20 8/21/2020 2,888.6124 503.6265774 21 9/21/2019 2,888.6124 476.59673808 22 10/21/2020 2,888.6124 449.26056059 23 11/21/2020 2,888.6124 421.61457309 24 12/21/2020 2,888.6124 393.65526439 25 1/21/2021 2,888.6124 365.37908353 26 2/21/2021 2,888.6124 336.78243928 27 3/21/2021 2,888.6124 307.86169974 28 4/21/2021 2,888.6124 278.61319181 29 5/21/2021 2,888.6124 249.03320079 30 6/21/2021 2,888.6124 219.11796987 31 7/21/2021 2,888.6124 188.86369968 32 8/21/2021 2,888.6124 158.26654775 33 9/21/2021 2,888.6124 127.3226281 34 10/21/2021 2,888.6124 96.028010692 35 11/21/2021 2,888.6124 64.378720956 36 12/21/2021 2,888.6124 32.370739269 Totales 103990.0464 18990.04644

Saldo a Capital Interes porcentual 85000 0.0113333333 1,925.28 83,074.72 0.0113333333 1,947.10 81,127.62 0.0113333333 1,969.17 79,158.46 0.0113333333 1,991.48 77,166.97 0.0113333333 2,014.05 75,152.92 0.0113333333 2,036.88 73,116.04 0.0113333333 2,059.96 71,056.08 0.0113333333 2,083.31 68,972.77 0.0113333333 2,106.92 66,865.84 0.0113333333 2,130.80 64,735.05 0.0113333333 2,154.95 62,580.10 0.0113333333 2,179.37 60,400.73 0.0113333333 2,204.07 58,196.65 0.0113333333 2,229.05 55,967.60 0.0113333333 2,254.31 53,713.29 0.0113333333 2,279.86 51,433.43 0.0113333333 2,305.70 49,127.73 0.0113333333 2,331.83 46,795.90 0.0113333333 2,358.26 44,437.64 0.0113333333 2,384.99 42,052.65 0.0113333333 2,412.02 39,640.64 0.0113333333 2,439.35 37,201.29 0.0113333333 2,467.00 34,734.29 0.0113333333 2,494.96 32,239.33 0.0113333333 2,523.23 29,716.10 0.0113333333 2,551.83 27,164.27 0.0113333333 2,580.75 24,583.52 0.0113333333 2,610.00 21,973.52 0.0113333333 2,639.58 19,333.94 0.0113333333 2,669.49 16,664.44 0.0113333333 2,699.75 13,964.70 0.0113333333 2,730.35 11,234.35 0.0113333333 2,761.29 8,473.06 0.0113333333 2,792.58 5,680.48 0.0113333333 2,824.23 2,856.24 0.0113333333 2,856.24 0 0.0113333333 85,000

No Fecha Amortizacion Interes Capital Saldo a CapitalInteres porcentual 0 12/21/2018 80000 0.0113333333 1 1/21/2019 2718.6940 906.6666664 1,812.03 78,187.97 0.0113333333 2 2/21/2019 2718.6940 886.13035663 1,832.56 76,355.41 0.0113333333 3 3/21/2019 2718.6940 865.36130201 1,853.33 74,502.08 0.0113333333 4 4/21/2019 2718.6940 844.35686477 1,874.34 72,627.74 0.0113333333 5 5/21/2019 2718.6940 823.11437724 1,895.58 70,732.16 0.0113333333 6 6/21/2019 2718.6940 801.63114152 1,917.06 68,815.10 0.0113333333 7 7/21/2019 2718.6940 779.90442913 1,938.79 66,876.31 0.0113333333 8 8/21/2019 2718.6940 757.93148067 1,960.76 64,915.54 0.0113333333 9 9/21/2019 2718.6940 735.70950546 1,982.98 62,932.56 0.0113333333 10 10/21/2019 2718.6940 713.23568119 2,005.46 60,927.10 0.0113333333 11 11/21/2019 2718.6940 690.50715359 2,028.19 58,898.91 0.0113333333 12 12/21/2019 2718.6940 667.521036 2,051.17 56,847.74 0.0113333333 13 1/21/2020 2718.6940 644.27440908 2,074.42 54,773.32 0.0113333333 14 2/21/2020 2718.6940 620.76432039 2,097.93 52,675.39 0.0113333333 15 3/21/2020 2718.6940 596.98778403 2,121.71 50,553.69 0.0113333333 16 4/21/2020 2718.6940 572.94178026 2,145.75 48,407.93 0.0113333333 17 5/21/2020 2718.6940 548.62325511 2,170.07 46,237.86 0.0113333333 18 6/21/2020 2718.6940 524.02912001 2,194.66 44,043.20 0.0113333333 19 7/21/2020 2718.6940 499.15625137 2,219.54 41,823.66 0.0113333333 20 8/21/2020 2718.6940 474.00149023 2,244.69 39,578.97 0.0113333333 21 9/21/2019 2718.6940 448.56164179 2,270.13 37,308.84 0.0113333333 22 10/21/2020 2718.6940 422.83347507 2,295.86 35,012.98 0.0113333333 23 11/21/2020 2718.6940 396.81372247 2,321.88 32,691.10 0.0113333333 24 12/21/2020 2718.6940 370.49907933 2,348.19 30,342.90 0.0113333333 25 1/21/2021 2718.6940 343.88620357 2,374.81 27,968.09 0.0113333333 26 2/21/2021 2718.6940 316.97171522 2,401.72 25,566.37 0.0113333333 27 3/21/2021 2718.6940 289.752196 2,428.94 23,137.43 0.0113333333 28 4/21/2021 2718.6940 262.22418889 2,456.47 20,680.96 0.0113333333 29 5/21/2021 2718.6940 234.38419771 2,484.31 18,196.65 0.0113333333 30 6/21/2021 2718.6940 206.22868662 2,512.47 15,684.18 0.0113333333 31 7/21/2021 2718.6940 177.75407975 2,540.94 13,143.24 0.0113333333 32 8/21/2021 2718.6940 148.95676066 2,569.74 10,573.51 0.0113333333 33 9/21/2021 2718.6940 119.83307196 2,598.86 7,974.65 0.0113333333 34 10/21/2021 2718.6940 90.37931478 2,628.31 5,346.33 0.0113333333 35 11/21/2021 2718.6940 60.591748356 2,658.10 2,688.23 0.0113333333 36 12/21/2021 2718.6940 30.466589513 2,688.23 0 0.0113333333 Totales 97872.9840 17872.985077 80,000

ALMACENES LA ESTRELLA LTDA TARJETA VALORADA DE INVENTARIOS Articulo Codigo Ubicacion U. de Medida FECHA

DESCRIPCION Inicial Compra Venta Compra Venta

Compra

REF CD CDE-0 CD CDECDI CDI CDI CDE-

ENTRADAS SALIDAS SALDOS COSTO U CANT VAL CANT VAL CANT 1400 0 0 0 0 80 1800 100 180000 0 0 180 1800 0 0 80 144000 100 2000 75 150000 0 0 175 2000 0 0 75 150000 100 1800 0 0 20 36000 80 1400 0 0 5 7000 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 75 0 75 0 75 0 75 75 75 75

VAL 112000 292000 148000 298000 148000 112000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000 105000

Muestra planilla de sueldos

DESCUENTOS Nro Nomina Cargo Total Ganado A.F.P. 12,71% RC-IVA 13% Total Descuentos 1 4400 559 33 592 2 3300 419 419 3 2200 280 280 4 1100 139.81 139.81 5 0 0 11000 1398 33 1431 APORTES PATRONALES BENEFICIOS SOCIALES Nro Nomina Total Ganado C.N.S 10% A.F.P. 6,71 % Total Aport. Aguinaldos 8,33% 1 4400 440 295.24 735.24 366.52 2 3300 330 221.43 551.43 274.89 3 2200 220 147.62 367.62 183.26 4 1100 110 73.81 183.81 91.63 5 0 0 0 0 11000 1100 738.1 1838 916.3 PLANILLA IMPOSITIVA Nro Total Ganado Total Cotiz. 12,71% Tot. Gan.Neto 2 Sal. Min. N. Mont. Impo RC-IVA 13% 4400 559.24 3840.76 1320 2520.76 327.70 3300 419.43 2880.57 1320 1560.57 202.87 2200 279.62 1920.38 1320 600.38 78.05 1100 139.81 960.19 1320 0 0 0 0 0 11000 1398 9601.9 4681.71 608.62

Liquido Pagable 3808 2881 1920 960 0 9569 BENEFICIOS SOCIALES Indemniz 8,33% Total Ben. Soc. Total C. Social 366.52 733 1468 274.89 550 1101 183.26 367 734 91.63 183.26 367.07 0 0 0 916.3 1833 3671

13% de 2 S.M.N Mont. para Desc FORM. 110 Cred. Fisc Deb. Fisc 171.6 156 124 33 171.6 31 72 40 171.6 33 33 0 20 20 0 0 0 0 0 514.8 187.3729 247 33

Facturas 110 950 550 250 150

Muestra planilla de sueldos enero DESCUENTOS Nro Nomina Cargo Total Ganado A.F.P. 12,71% RC-IVA 13% Total DescuentLiquido Pagable 1 4800 610 31 641 4159 2 4400 559 38 597 3803 3 4000 508 31 540 3460 4 3600 458 458 3142 5 3200 407 407 2793 20000 2542 100 2642 17358 APORTES PATRONALES BENEFICIOS SOCIALES Nro Nomina Total GanaC.N.S 10% A.F.P. 6,71 % Total Aport. Aguinaldos 8, Indemniz 8,33% 1 4800 480 322.08 802.08 399.84 399.84 2 4400 440 295.24 735.24 366.52 366.52 3 4000 400 268.4 668.4 333.2 333.2 4 3600 360 241.56 601.56 299.88 299.88 5 3200 320 214.72 534.72 266.56 266.56 20000 2000 1342 3342 1666.0 1666.0 PLANILLA IMPOSITIVA Nro Total GanaTotal CotizTot. Gan.Neto 2 Sal. Min. N. Mont. Impo RC-IVA 13% 13% de 2 S.M.N 4800 610.08 4189.92 1500 2689.92 349.69 195 4400 559.24 3840.76 1500 2340.76 304.30 195 4000 508.4 3491.6 1500 1991.6 258.91 195 3600 457.56 3142.44 1500 1642.44 213.5172 195 3200 406.72 2793.28 1500 1293.28 168.1264 195 20000 2542 17458 9958 1294.54 975

Total Ben. Soc. Total C. Social 800 1602 733 1468 666 1335 599.76 1201.32 533.12 1067.84 3332 6674

Mont. para Desc FORM. 110 Cred. Fisc Deb. Fisc 155 124 31 109 72 38 64 33 31 19 20 1.0 16 16.3 346.4136 263 69

Facturas 110 950 550 250 150 125

Muestra planilla de sueldos febrero DESCUENTOS Nro Nomina Cargo Total Ganado A.F.P. 12,71% RC-IVA 13% Total Descuentos Liquido Pagable 1 4900 623 62 685 4215 2 4500 572 69 641 3859 3 4000 508 38 546 3454 4 3600 457.56 457.56 3142.44 5 3200 406.72 406.72 2793.28 20200 2567 169 2736 17464 APORTES PATRONALES BENEFICIOS SOCIALES Nro Nomina Total Ganado C.N.S 10% A.F.P. 6,71 % Total Aport. Aguinaldos 8,33%Indemniz 8,33% 1 4900 490 328.79 818.79 408.17 408.17 2 4500 450 301.95 751.95 374.85 374.85 3 4000 400 268.4 668.4 333.2 333.2 4 3600 360 241.56 601.56 299.88 299.88 5 3200 320 214.72 534.72 266.56 266.56 20200 2020 1355.42 3375.42 1683 1683 PLANILLA IMPOSITIVA Nro Total Ganado Total Cotiz. 12 Tot. Gan.Neto 2 Sal. Min. N. Mont. Impo RC-IVA 13% 13% de 2 S.M.N 4900 622.79 4277.21 1500 2777.21 361.04 195 4500 571.95 3928.05 1500 2428.05 315.65 195 4000 508.4 3491.6 1500 1991.6 258.91 195 3600 457.56 3142.44 1500 1642.44 213.5172 195 3200 406.72 2793.28 1500 1293.28 168.1264 195 20200 2567.42 17632.58 10132.58 1317.24 975

Total Ben. Soc. Total C. Social 816 1635 750 1502 666 1335 599.76 1201.32 533.12 1067.84 3365 6741

Mont. para DesFORM. 110 Cred. Fisc Deb. Fisc 166 104 62 121 52 69 64 26 38 19 24.7 6.1828 17.55 17.55 369 224 169

Facturas 110 800 400 200 190 135

Muestra planilla de sueldos marzo DESCUENTOS Nro Nomina Cargo Total Ganado A.F.P. 12,71% RC-IVA 13% Total DescuentLiquido Pagable 1 5000 636 41 676 4324 2 4600 585 47 632 3968 3 4200 534 48 581 3619 4 3800 482.98 13 495.5926 3304.4074 5 3400 432.14 432.14 2967.86 21000 2669 149 2818 18182 APORTES PATRONALES BENEFICIOS SOCIALES Nro Nomina Total Ganado C.N.S 10% A.F.P. 6,71 % Total Aport. Aguinaldos 8, Indemniz 8,33% 1 5000 500 335.5 835.5 416.5 416.5 2 4600 460 308.66 768.66 383.18 383.18 3 4200 420 281.82 701.82 349.86 349.86 4 3800 380 254.98 634.98 316.54 316.54 5 3400 340 228.14 568.14 283.22 283.22 21000 2100 1409.1 3509.1 1749 1749 PLANILLA IMPOSITIVA Nro Total Ganado Total Cotiz. 1 Tot. Gan.Neto 2 Sal. Min. N. Mont. Impo RC-IVA 13% 13% de 2 S.M.N 5000 635.5 4364.5 1500 2864.5 372.39 195 4600 584.66 4015.34 1500 2515.34 326.99 195 4200 533.82 3666.18 1500 2166.18 281.60 195 3800 482.98 3317.02 1500 1817.02 236.21 195 3400 432.14 2967.86 1500 1467.86 190.82 195 21000 2669.1 18330.9 10830.9 1408.02 975

Total Ben. Soc. Total C. Social 833 1669 766 1535 700 1402 633.08 1268.06 566.44 1134.58 3499 7008

Mont. para DescFORM. 110 Cred. Fisc Deb. Fisc 177 137 41 132 85 47 87 39 48 41 29 13 18 18 437.1952 307 149

Facturas 110 1050 650 300 220 140

Muestra planilla de sueldos Abril DESCUENTOS Nro Nomina Cargo Total Ganado A.F.P. 12,71% RC-IVA 13% Total DescuentLiquido Pagable 1 5100 648 91 739 4361 2 4700 597 78 676 4024 3 4300 547 72 618 3682 4 3900 495.69 29 524.8503 3375.1497 5 3500 444.85 444.85 3055.15 21500 2733 271 3003 18497 APORTES PATRONALES BENEFICIOS SOCIALES Nro Nomina Total Ganado C.N.S 10% A.F.P. 6,71 % Total Aport. Aguinaldos 8, Indemniz 8,33% 1 5100 510 342.21 852.21 424.83 424.83 2 4700 470 315.37 785.37 391.51 391.51 3 4300 430 288.53 718.53 358.19 358.19 4 3900 390 261.69 651.69 324.87 324.87 5 3500 350 234.85 584.85 291.55 291.55 21500 2150 1442.65 3592.65 1791 1791 PLANILLA IMPOSITIVA Nro Total Ganado Total Cotiz. 12 Tot. Gan.Neto 2 Sal. Min. N. Mont. Impo RC-IVA 13% 13% de 2 S.M.N 5100 648.21 4451.79 1500 2951.79 383.73 195 4700 597.37 4102.63 1500 2602.63 338.34 195 4300 546.53 3753.47 1500 2253.47 292.95 195 3900 495.69 3404.31 1500 1904.31 247.5603 195 3500 444.85 3055.15 1500 1555.15 202.1695 195 21500 2732.65 18767.35 11267.35 1464.76 975

Total Ben. Soc.

Total C. Social 850 1702 783 1568 716 1435 649.74 1301.43 583.1 1167.95 3582 7175

Mont. para Desc FORM. 110 Cred. Fisc Deb. Fisc 189 97.5 91 143 65 78 98 26 72 53 23.4 29 7 19.5 12 489.7555 231 271

Facturas 110 750 500 200 180 150

5854096 3144775 5854099 3144777 sumas saldos tot activo

Credito Fiscal 6240 34536 26897 1170 169 60

34536

34536

Debito Fiscal 34536

34536

3134 34320 1638

39092 4556

SUMAS Y SALDOS