calculo cuotas 2

Upload: boydy

Post on 06-Mar-2016

20 views

Category:

Documents


0 download

DESCRIPTION

ejemplo de calculo de cuotas de prestamo

TRANSCRIPT

  • RASPICHASHdeuda total 2054.5Monto 4,411.67 26.68%

    1 229.37 33.89 263.262 229.37 33.89 263.263 229.37 33.89 263.264 229.37 33.89 263.265 229.37 33.89 263.266 229.37 33.89 263.267 229.37 33.89 263.268 229.37 33.89 263.269 229.37 33.89 263.26

    10 229.37 33.89 263.2611 229.37 33.89 263.2612 229.37 33.89 263.2613 229.37 33.89 263.2614 229.37 33.89 263.2615 229.37 33.89 263.2616 229.37 33.89 263.2617 229.37 33.89 263.2618 229.37 33.89 263.2619 229.37 33.89 263.2620 229.37 33.89 263.2621 229.37 33.89 263.26

    4816.77 711.69 5528.46

  • RASPICHASH

    1.13% 4,411.67 1177.03 5,588.70

    237.2323282 123456789

    10111213

    229.37 33.89 263.26 14229.37 33.89 263.26 15229.37 33.89 263.26 16229.37 33.89 263.26 17229.37 33.89 263.26 18229.37 33.89 263.26 19229.37 33.89 263.26 20229.37 33.89 263.26 21

    221834.96 2106.08 232,818.78 244653.74 25

    2627282930313233343536

  • 26.18% 0.65%

    252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47252.47

  • Monto Prestamo : 5000.00 S/.Tasa Anual : 39.29%Nmero de Cotas : 12

    Tasa Mensual : 2.8000%

    N Saldo Captal Amortizacin Inters5,000.00

    1 4,643.67 356.33 140.002 4,277.36 366.31 130.023 3,900.79 376.57 119.774 3,513.68 387.11 109.225 3,115.73 397.95 98.386 2,706.64 409.09 87.247 2,286.09 420.55 75.798 1,853.77 432.32 64.019 1,409.35 444.43 51.91

    10 952.48 456.87 39.4611 482.81 469.66 26.6712 0.00 482.81 13.52

    5,000.00 955.99

  • Cuota Seg. Desgrav. Monto a Pagar

    496.33 3.25 499.58496.33 3.02 499.35496.33 2.78 499.11496.33 2.54 498.87496.33 2.28 498.62496.33 2.03 498.36496.33 1.76 498.09496.33 1.49 497.82496.33 1.20 497.54496.33 0.92 497.25496.33 0.62 496.95496.33 0.31 496.65

    5,955.99 22.19 5,978.18

  • Monto Prestamo : 6480.00 S/.Tasa Anual : 26.18%Nmero de Cotas : 36

    Tasa Mensual : 1.9567%

    N Saldo Captal Amortizacin Inters6,480.00

    1 6,354.33 125.67 126.802 6,226.20 128.13 124.343 6,095.57 130.64 121.834 5,962.37 133.19 119.275 5,826.58 135.80 116.676 5,688.12 138.46 114.017 5,546.96 141.16 111.308 5,403.03 143.93 108.549 5,256.29 146.74 105.72

    10 5,106.67 149.61 102.8511 4,954.13 152.54 99.9212 4,798.60 155.53 96.9413 4,640.03 158.57 93.9014 4,478.36 161.67 90.7915 4,313.52 164.84 87.6316 4,145.46 168.06 84.4017 3,974.11 171.35 81.1218 3,799.41 174.70 77.7619 3,621.29 178.12 74.3420 3,439.68 181.61 70.8621 3,254.52 185.16 67.3122 3,065.74 188.78 63.6823 2,873.26 192.48 59.9924 2,677.02 196.24 56.2225 2,476.93 200.08 52.3826 2,272.94 204.00 48.4727 2,064.94 207.99 44.4828 1,852.88 212.06 40.4129 1,636.68 216.21 36.2630 1,416.24 220.44 32.0331 1,191.48 224.75 27.7132 962.33 229.15 23.3133 728.69 233.64 18.8334 490.49 238.21 14.2635 247.62 242.87 9.6036 0.00 247.62 4.85

    6,480.00 2,608.75

  • Este monto es pagado anticipadamente

  • Cuota Seg. Desgrav. Monto a Pagar

    252.47 4.21 252.47252.47 4.13 252.47252.47 4.05 252.47252.47 3.96 252.47252.47 3.88 252.47252.47 3.79 252.47252.47 3.70 252.47252.47 3.61 252.47252.47 3.51 252.47252.47 3.42 252.47252.47 3.32 252.47252.47 3.22 252.47252.47 3.12 252.47252.47 3.02 252.47252.47 2.91 252.47252.47 2.80 252.47252.47 2.69 252.47252.47 2.58 252.47252.47 2.47 252.47252.47 2.35 252.47252.47 2.24 252.47252.47 2.12 252.47252.47 1.99 252.47252.47 1.87 252.47252.47 1.74 252.47252.47 1.61 252.47252.47 1.48 252.47252.47 1.34 252.47252.47 1.20 252.47252.47 1.06 252.47252.47 0.92 252.47252.47 0.77 252.47252.47 0.63 252.47252.47 0.47 252.47252.47 0.32 252.47252.47 0.16 252.47

    9,088.75 86.66 9,088.75

  • Este monto es pagado anticipadamente

  • Monto Prestamo : 25000.00 S/.Tasa Anual : 20.00%Nmero de Cotas : 48

    Tasa Mensual : 1.5309%

    N Saldo Captal Amortizacin Inters25,000.00

    1 24,643.50 356.50 382.742 24,281.55 361.96 377.283 23,914.05 367.50 371.744 23,540.92 373.12 366.115 23,162.09 378.84 360.406 22,777.45 384.64 354.607 22,386.93 390.52 348.718 21,990.42 396.50 342.739 21,587.85 402.57 336.66

    10 21,179.11 408.74 330.5011 20,764.12 414.99 324.2412 20,342.77 421.35 317.8913 19,914.97 427.80 311.4414 19,480.63 434.35 304.8915 19,039.63 441.00 298.2416 18,591.88 447.75 291.4917 18,137.28 454.60 284.6318 17,675.71 461.56 277.6719 17,207.08 468.63 270.6120 16,731.28 475.80 263.4321 16,248.19 483.09 256.1522 15,757.71 490.48 248.7523 15,259.72 497.99 241.2424 14,754.10 505.62 233.6225 14,240.74 513.36 225.8826 13,719.52 521.22 218.0227 13,190.33 529.20 210.0428 12,653.03 537.30 201.9429 12,107.50 545.52 193.7130 11,553.63 553.88 185.3631 10,991.27 562.36 176.8832 10,420.31 570.96 168.2733 9,840.60 579.71 159.5334 9,252.02 588.58 150.65

  • 35 8,654.43 597.59 141.6436 8,047.69 606.74 132.4937 7,431.66 616.03 123.2138 6,806.20 625.46 113.7739 6,171.16 635.04 104.2040 5,526.41 644.76 94.4841 4,871.78 654.63 84.6142 4,207.13 664.65 74.5843 3,532.30 674.83 64.4144 2,847.14 685.16 54.0845 2,151.50 695.65 43.5946 1,445.20 706.30 32.9447 728.09 717.11 22.1348 0.00 728.09 11.15

    25,000.00 10,483.29

    Este monto es pagado anticipadamente

  • Cuota Seg. Desgrav. Monto a Pagar

    739.24 16.25 739.24739.24 16.02 739.24739.24 15.78 739.24739.24 15.54 739.24739.24 15.30 739.24739.24 15.06 739.24739.24 14.81 739.24739.24 14.55 739.24739.24 14.29 739.24739.24 14.03 739.24739.24 13.77 739.24739.24 13.50 739.24739.24 13.22 739.24739.24 12.94 739.24739.24 12.66 739.24739.24 12.38 739.24739.24 12.08 739.24739.24 11.79 739.24739.24 11.49 739.24739.24 11.18 739.24739.24 10.88 739.24739.24 10.56 739.24739.24 10.24 739.24739.24 9.92 739.24739.24 9.59 739.24739.24 9.26 739.24739.24 8.92 739.24739.24 8.57 739.24739.24 8.22 739.24739.24 7.87 739.24739.24 7.51 739.24739.24 7.14 739.24739.24 6.77 739.24739.24 6.40 739.24

  • 739.24 6.01 739.24739.24 5.63 739.24739.24 5.23 739.24739.24 4.83 739.24739.24 4.42 739.24739.24 4.01 739.24739.24 3.59 739.24739.24 3.17 739.24739.24 2.73 739.24739.24 2.30 739.24739.24 1.85 739.24739.24 1.40 739.24739.24 0.94 739.24739.24 0.47 739.24

    35,483.29 445.09 35,483.29

    Este monto es pagado anticipadamente

  • Monto Prestamo : 5000.00 S/.Tasa Anual : 36.08% 26.68%Nmero de Cotas : 36 20

    Tasa Mensual : 2.6005%

    N Saldo Captal Amortizacin Inters Cuota Seg. Desgrav. Monto a Pagar N Cuota5,000.00 5000.00

    1 4,914.45 85.55 130.03 215.57 3.25 215.57 1 4750.00 250.002 4,826.68 87.77 127.80 215.57 3.19 215.57 2 4500.00 250.003 4,736.62 90.06 125.52 215.57 3.14 215.57 3 4250.00 250.004 4,644.22 92.40 123.18 215.57 3.08 215.57 4 4000.00 250.005 4,549.42 94.80 120.77 215.57 3.02 215.57 5 3750.00 250.006 4,452.16 97.27 118.31 215.57 2.96 215.57 6 3500.00 250.007 4,352.36 99.80 115.78 215.57 2.89 215.57 7 3250.00 250.008 4,249.97 102.39 113.18 215.57 2.83 215.57 8 3000.00 250.009 4,144.92 105.05 110.52 215.57 2.76 215.57 9 2750.00 250.0010 4,037.13 107.79 107.79 215.57 2.69 215.57 10 2500.00 250.0011 3,926.54 110.59 104.99 215.57 2.62 215.57 11 2250.00 250.0012 3,813.08 113.46 102.11 215.57 2.55 215.57 12 2000.00 250.0013 3,696.66 116.41 99.16 215.57 2.48 215.57 13 1750.00 250.0014 3,577.22 119.44 96.13 215.57 2.40 215.57 14 1500.00 250.0015 3,454.67 122.55 93.03 215.57 2.33 215.57 15 1250.00 250.0016 3,328.94 125.74 89.84 215.57 2.25 215.57 16 1000.00 250.0017 3,199.93 129.01 86.57 215.57 2.16 215.57 17 750.00 250.0018 3,067.57 132.36 83.21 215.57 2.08 215.57 18 500.00 250.0019 2,931.77 135.80 79.77 215.57 1.99 215.57 19 250.00 250.0020 2,792.44 139.33 76.24 215.57 1.91 215.57 20 0.00 250.0021 2,649.48 142.96 72.62 215.57 1.82 215.5722 2,502.81 146.67 68.90 215.57 1.72 215.5723 2,352.32 150.49 65.09 215.57 1.63 215.5724 2,197.91 154.40 61.17 215.57 1.53 215.5725 2,039.50 158.42 57.16 215.57 1.43 215.5726 1,876.96 162.54 53.04 215.57 1.33 215.5727 1,710.20 166.76 48.81 215.57 1.22 215.5728 1,539.10 171.10 44.47 215.57 1.11 215.5729 1,363.55 175.55 40.02 215.57 1.00 215.5730 1,183.43 180.12 35.46 215.57 0.89 215.5731 998.63 184.80 30.78 215.57 0.77 215.5732 809.03 189.60 25.97 215.57 0.65 215.5733 614.49 194.54 21.04 215.57 0.53 215.5734 414.90 199.59 15.98 215.57 0.40 215.5735 210.11 204.79 10.79 215.57 0.27 215.5736 0.00 210.11 5.46 215.57 0.14 215.57

    5,000.00 2,760.68 7,760.68 69.00 7,760.68

    Este monto es pagado anticipadamente

  • Externo 2,818.78 5000Raspicash 1,834.96

    Total 4,653.74

    Hoja1EjemploP.ExternoP.RaspicashP.RefinanciarDeuda Total