act-5.xlsx - Ao 0 1 2 3 4 5 6 7 8 9 10 Ahorro Final Plazo...

This preview shows page 1 - 6 out of 6 pages.

Ahorro Final 10,000 Plazo 10 años Tasa 4% Anual Numero de pago 10 Vencido Anualidad Fijo -832.909443 Año Pago Saldo 0 1 832.9094 Saldo Final 2 832.9094 866.2258 1699.1353 3 832.9094 1767.1007 2600.0101 4 832.9094 2704.0105 3536.9200 5 832.9094 3678.3968 4511.3062 6 832.9094 4691.7585 5524.6679 7 832.9094 5745.6546 6578.5641 8 832.9094 6841.7066 7674.6161 9 832.9094 7981.6007 8814.5101 10 832.9094 9167.0906 10000.0000 Ahorro Final 120,000 Plazo 6 años Tasa 25% Anual Numero de pago 12 Anticipado Anualidad Fijo -19823.320682 Año Pago Saldo 0 120'000 Saldo Final 1 800.8745 #VALUE! #VALUE! 2 800.8745 #VALUE! #VALUE! 3 800.8745 #VALUE! #VALUE! 4 800.8745 #VALUE! #VALUE! 5 800.8745 #VALUE! #VALUE! 6 800.8745 #VALUE! #VALUE! 7 800.8745 #VALUE! #VALUE! 8 800.8745 #VALUE! #VALUE! 9 800.8745 #VALUE! #VALUE! 10 0.0000 #VALUE! #VALUE! 11 12
Image of page 1

Subscribe to view the full document.

credito 120000 plazo 6 años tasa 25% anual cap semestral numero de pago 12 tipo de pago vencido Anualidad fijo -$19,823.32 AÑO INTERES CAPITAL 0 $ 120,000.00 1 $ 115,176.68 $ 15,000.00 $ 4,823.32 2 $ 109,750.44 $ 14,397.08 $ 5,426.24 3 $ 103,645.93 $ 13,718.81 $ 6,104.52 4 $ 96,778.35 $ 12,955.74 $ 6,867.58 5 $ 89,052.32 $ 12,097.29 $ 7,726.03 6 $ 80,360.54 $ 11,131.54 $ 8,691.78 7 $ 70,582.29 $ 10,045.07 $ 9,778.25 8 $ 59,581.75 $ 8,822.79 $ 11,000.53 9 $ 47,206.15 $ 7,447.72 $ 12,375.60 10 $ 33,283.60 $ 5,900.77 $ 13,922.55 11 $ 17,620.73 $ 4,160.45 $ 15,662.87 12 $ 0.00 $ 2,202.59 $ 17,620.73
Image of page 2
PAGO $ 19,823.32 $ 19,823.32 $ 19,823.32 $ 19,823.32 $ 19,823.32 $ 19,823.32 $ 19,823.32 $ 19,823.32 $ 19,823.32 $ 19,823.32 $ 19,823.32 $ 19,823.32
Image of page 3

Subscribe to view the full document.

credito 82500 plazo 3 años taza 3% anual cap mensual # de pago 36 tipo de pago vencida anualidad fija -$2,399.1997945288 MES INTERES CAPITAL PAGO 0 82500 1 $ 80,307.05 $ 206.25 $ 2,192.95 $ 2,399.20 2 $ 78,108.62 $ 200.77 $ 2,198.43 $ 2,399.20 3 $ 75,904.69 $ 195.27 $ 2,203.93 $ 2,399.20 4 $ 73,695.25 $ 189.76 $ 2,209.44 $ 2,399.20 5 $ 71,480.29 $ 184.24 $ 2,214.96 $ 2,399.20 6 $ 69,259.79 $ 178.70 $ 2,220.50 $ 2,399.20 7 $ 67,033.74 $ 173.15 $ 2,226.05 $ 2,399.20 8 $ 64,802.13 $ 167.58 $ 2,231.62 $ 2,399.20 9 $ 62,564.93 $ 162.01 $ 2,237.19 $ 2,399.20 10 $ 60,322.14 $ 156.41 $ 2,242.79 $ 2,399.20 11 $ 58,073.75 $ 150.81 $ 2,248.39 $ 2,399.20 12 $ 55,819.73 $ 145.18 $ 2,254.02 $ 2,399.20 13 $ 53,560.08 $ 139.55 $ 2,259.65 $ 2,399.20 14 $ 51,294.78 $ 133.90 $ 2,265.30 $ 2,399.20 15 $ 49,023.82 $ 128.24 $ 2,270.96 $ 2,399.20 16 $ 46,747.18 $ 122.56 $ 2,276.64 $ 2,399.20 17 $ 44,464.85 $ 116.87 $ 2,282.33 $ 2,399.20 18 $ 42,176.81 $ 111.16 $ 2,288.04 $ 2,399.20 19 $ 39,883.05 $ 105.44 $ 2,293.76 $ 2,399.20 20 $ 37,583.56 $ 99.71 $ 2,299.49 $ 2,399.20 21 $ 35,278.32 $ 93.96 $ 2,305.24 $ 2,399.20 22 $ 32,967.32 $ 88.20 $ 2,311.00 $ 2,399.20 23 $ 30,650.53 $ 82.42 $ 2,316.78 $ 2,399.20 24 $ 28,327.96 $ 76.63 $ 2,322.57 $ 2,399.20 25 $ 25,999.58 $ 70.82 $ 2,328.38 $ 2,399.20 26 $ 23,665.38 $ 65.00 $ 2,334.20 $ 2,399.20 27 $ 21,325.34 $ 59.16 $ 2,340.04 $ 2,399.20 28 $ 18,979.46 $ 53.31 $ 2,345.89 $ 2,399.20 29 $ 16,627.71 $ 47.45 $ 2,351.75 $ 2,399.20 30 $ 14,270.08 $ 41.57 $ 2,357.63 $ 2,399.20 31 $ 11,906.55 $ 35.68 $ 2,363.52 $
Image of page 4
Image of page 5

Subscribe to view the full document.

Image of page 6
  • Spring '17
  • xxx
  • ANUAL CAP, anualidad fijo

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern