Amortizacion.xlsx

79 323446289 376125 28209375 100 48308 327817185

This preview shows page 3 - 10 out of 18 pages.

526.79 -3234.46289 3761.25 -282093.75 100 483.08 -3278.17185 3761.25 -285855.00 101 439.37 -3321.88081 3761.25 -289616.25 102 395.66 -3365.58976 3761.25 -293377.50 103 351.95 -3409.29872 3761.25 -297138.75 104 308.24 -3453.00768 3761.25 -300900.00 105 264.53 -3496.71664 3761.25 -304661.25 106 220.82 -3540.42559 3761.25 -308422.50 107 177.12 -3584.13455 3761.25 -312183.75 108 133.41 -3627.84351 3761.25 -315945.00 109 89.70 -3671.55247 3761.25 -319706.25
Image of page 3

Subscribe to view the full document.

110 45.99 -3715.26143 3761.25 -323467.50 111 2.28 -3758.97038 3761.25 -327228.75 112 -41.43 -3802.67934 3761.25 -330990.00 113 -85.14 -3846.3883 3761.25 -334751.25 114 -128.85 -3890.09726 3761.25 -338512.50 115 -172.56 -3933.80622 3761.25 -342273.75 116 -216.27 -3977.51517 3761.25 -346035.00 117 -259.97 -4021.22413 3761.25 -349796.25 118 -303.68 -4064.93309 3761.25 -353557.50 119 -347.39 -4108.64205 3761.25 -357318.75 120 -391.10 -4152.35101 3761.25 -361080.00
Image of page 4
2.- 71345 0 20 11.24% 0.009366667 12 3567.25 Anticipada Pago Intereses Amort Saldo Ins $ 3,567.25 0 3567.25 $ 67,777.75 $ 4,202.10 $ 634.85 3567.25 $ 64,210.50 $ 4,168.69 $ 601.44 3567.25 $ 60,643.25 $ 4,135.28 $ 568.03 3567.25 $ 57,076.00 $ 4,101.86 $ 534.61 3567.25 $ 53,508.75 $ 4,068.45 $ 501.20 3567.25 $ 49,941.50 $ 4,035.04 $ 467.79 3567.25 $ 46,374.25 $ 4,001.62 $ 434.37 3567.25 $ 42,807.00 $ 3,968.21 $ 400.96 3567.25 $ 39,239.75 $ 3,934.80 $ 367.55 3567.25 $ 35,672.50 $ 3,901.38 $ 334.13 3567.25 $ 32,105.25 $ 3,867.97 $ 300.72 3567.25 $ 28,538.00 $ 3,834.56 $ 267.31 3567.25 $ 24,970.75 $ 3,801.14 $ 233.89 3567.25 $ 21,403.50 $ 3,767.73 $ 200.48 3567.25 $ 17,836.25 $ 3,734.32 $ 167.07 3567.25 $ 14,269.00 $ 3,700.90 $ 133.65 3567.25 $ 10,701.75 $ 3,667.49 $ 100.24 3567.25 $ 7,134.50 $ 3,634.08 $ 66.83 3567.25 $ 3,567.25 $ 3,600.66 $ 33.41 3567.25 $ - $ 3,567.25 $ - 3567.25 -$ 3,567.25
Image of page 5

Subscribe to view the full document.

6.- SC= $ 117,285.00 n= 10 años #pagos= 18 quincenales i= 6.95% 0.002895833 R= 24 Amortizacion 6515.83 F= #pago/total F A=F1*sc Sc Period0 Factor Pago Intereses Amort Saldo Ins 0 $ 117,285.00 1 0.01 $ 1,025.52 $ 339.64 $ 685.88 $ 116,599.12 2 0.01 $ 1,709.41 $ 337.65 $ 1,371.75 $ 115,227.37 3 0.02 $ 2,391.31 $ 333.68 $ 2,057.63 $ 113,169.74 4 0.02 $ 3,071.23 $ 327.72 $ 2,743.51 $ 110,426.23 5 0.03 $ 3,749.16 $ 319.78 $ 3,429.39 $ 106,996.84 6 0.04 $ 4,425.11 $ 309.85 $ 4,115.26 $ 102,881.58 7 0.04 $ 5,099.07 $ 297.93 $ 4,801.14 $ 98,080.44 8 0.05 $ 5,771.04 $ 284.02 $ 5,487.02 $ 92,593.42 9 0.05 $ 6,441.03 $ 268.14 $ 6,172.89 $ 86,420.53 10 0.06 $ 7,109.03 $ 250.26 $ 6,858.77 $ 79,561.75 11 0.06 $ 7,775.05 $ 230.40 $ 7,544.65 $ 72,017.11 12 0.07 $ 8,439.08 $ 208.55 $ 8,230.53 $ 63,786.58 13 0.08 $ 9,101.12 $ 184.72 $ 8,916.40 $ 54,870.18 14 0.08 $ 9,761.18 $ 158.89 $ 9,602.28 $ 45,267.89 15 0.09 $ 10,419.25 $ 131.09 $ 10,288.16 $ 34,979.74 16 0.09 $ 11,075.33 $ 101.30 $ 10,974.04 $ 24,005.70 17 0.10 $ 11,729.43 $ 69.52 $ 11,659.91 $ 12,345.79 18 0.11 $ 12,381.54 $ 35.75 $ 12,345.79 $ - 171
Image of page 6
342
Image of page 7

Subscribe to view the full document.

7.- SC= $ 234,650.00 n= 5 años #pagos= 30 Bimestra 6 i= 5.82% 0.00485 R= 12 0.9724% Bimestral Amortizacion 7821.67 5.8341% anual Period0 Factor Pago Intereses Amort Saldo Ins 0 $ 234,650.00 1 0.0022 $ 2,786.25 $ 2,281.62 $ 504.62 $ 234,145.38 2 0.0043 $ 3,285.97 $ 2,276.72 $ 1,009.25 $ 233,136.13 3 0.0065 $ 3,780.78 $ 2,266.90 $ 1,513.87 $ 231,622.26 4 0.0086 $ 4,270.68 $ 2,252.18 $ 2,018.49 $ 229,603.76 5 0.0108 $ 4,755.68 $ 2,232.56 $ 2,523.12 $ 227,080.65 6 0.0129 $ 5,235.77 $ 2,208.02 $ 3,027.74 $ 224,052.90 7 0.0151 $ 5,710.95 $ 2,178.58 $ 3,532.37 $ 220,520.54 8 0.0172 $ 6,181.23 $ 2,144.24 $ 4,036.99 $ 216,483.55 9 0.0194 $ 6,646.60 $ 2,104.98 $ 4,541.61 $ 211,941.94 10 0.0215 $ 7,107.06 $ 2,060.82 $ 5,046.24 $ 206,895.70 11 0.0237 $ 7,562.62 $ 2,011.75 $ 5,550.86 $ 201,344.84 12 0.0258 $ 8,013.26 $ 1,957.78 $ 6,055.48 $ 195,289.35 13 0.0280 $ 8,459.01 $ 1,898.90 $ 6,560.11 $ 188,729.25 14 0.0301 $ 8,899.84 $ 1,835.11 $ 7,064.73 $ 181,664.52 15 0.0323 $ 9,335.77 $ 1,766.42 $ 7,569.35 $ 174,095.16 16 0.0344 $ 9,766.80 $ 1,692.82 $ 8,073.98 $ 166,021.18 17 0.0366 $ 10,192.91 $ 1,614.31 $ 8,578.60 $ 157,442.58 18 0.0387 $ 10,614.12 $ 1,530.90 $ 9,083.23 $ 148,359.35 19 0.0409 $ 11,030.42 $ 1,442.58 $ 9,587.85 $ 138,771.51 20 0.0430 $ 11,441.82 $ 1,349.35 $ 10,092.47 $ 128,679.03 21 0.0452 $ 11,848.31 $ 1,251.21 $ 10,597.10 $ 118,081.94 22 0.0473 $ 12,249.89 $ 1,148.17 $ 11,101.72 $ 106,980.22 23 0.0495 $ 12,646.57 $ 1,040.22 $ 11,606.34 $ 95,373.87 24 0.0516 $ 13,038.34 $ 927.37 $ 12,110.97 $ 83,262.90 25 0.0538 $ 13,425.20 $ 809.61 $ 12,615.59 $ 70,647.31 26 0.0559 $ 13,807.16 $ 686.94 $ 13,120.22 $ 57,527.10 27 0.0581 $ 14,184.20 $ 559.37 $ 13,624.84 $ 43,902.26 28 0.0602 $ 14,556.35 $ 426.88 $ 14,129.46 $ 29,772.80 29 0.0624 $ 14,923.58 $ 289.50 $ 14,634.09 $ 15,138.71 30 0.0645 $ 15,285.91 $ 147.20 $ 15,138.71 $ - 465
Image of page 8
8.- SC= $ 117,285.00 n= 5 años #pagos= 18 quincenales 3 i= 6.95% 0.02316667 R= 3 2.3167% Bimestral Amortizacion 6515.83 6.9500% anual Period0 Factor Pago Intereses Amort Saldo Ins 0 $ 117,285.00 1 0.0083333333 9128.6825 $ 8,151.31 $
Image of page 9

Subscribe to view the full document.

Image of page 10
  • Fall '19
  • Total F, $8,299.55

{[ 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