Tabla De Amortizacion Ubaldo.xlsx

PRESTAMO TEIMPO TASA CUOTA no° cuota

70,000,000 42 4.20% -$3,575,103.35 valor cuota

1 2 3 4 5 6

3,575,103 3,575,103 3,575,103 3,575,103 3,575,103 3,575,103

PAPELERIA COMISION COSTO CREDITO abono k. 635,103 661,778 689,572 718,534 748,713 780,159

interes

saldo 70,000,000 69,364,897 68,703,119 68,013,547 67,295,012 66,546,299 65,766,141

2,940,000 2,913,326 2,885,531 2,856,569 2,826,391 2,794,945

valor taza periodo cuota no° cuota 0 1 2 3 4 5 6

2 AÑO PRESTAMO 72,342,755 TIEMPO 42 TASA 0.042 CUOTA - 3,694,754.637

PAPELERIA COMISION COSTO CREDITP no° cuota

valor cuota 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637

abono k. 656,358.942 683,926.018 712,650.911 742,582.249 773,770.703 806,269.073 840,132.374 875,417.934 912,185.487 950,497.277 990,418.163 1,032,015.726 1,075,360.386 1,120,525.522 1,167,587.594 1,216,626.273 1,267,724.577

interes 3,038,396 3,010,829 2,982,104 2,952,172 2,920,984 2,888,486 2,854,622 2,819,337 2,782,569 2,744,257 2,704,336 2,662,739 2,619,394 2,574,229 2,527,167 2,478,128 2,427,030

saldo 72,342,755 71,686,395.704 71,002,469.687 70,289,818.776 69,547,236.527 68,773,465.824 67,967,196.751 67,127,064.377 66,251,646.444 65,339,460.957 64,388,963.680 63,398,545.517 62,366,529.792 61,291,169.405 60,170,643.883 59,003,056.289 57,786,430.016 56,518,705.439

PRESTAMO TIEMPO TASA CUOTA no° cuota 0 1 2 3 4 5 6 7 8 9 10 11 12

18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637 3,694,754.637

1,320,969.009 1,376,449.707 1,434,260.595 1,494,499.540 1,557,268.521 1,622,673.799 1,690,826.098 1,761,840.794 1,835,838.108 1,912,943.308 1,993,286.927 2,077,004.978 2,164,239.187 2,255,137.233 2,349,852.997 2,448,546.823 2,551,385.789 2,658,543.992 2,770,202.840 2,886,551.359 3,007,786.516 3,134,113.550 3,265,746.319 3,402,907.664 3,545,829.786

2,373,786 55,197,736.430 2,318,305 53,821,286.723 2,260,494 52,387,026.128 2,200,255 50,892,526.588 2,137,486 49,335,258.067 2,072,081 47,712,584.268 2,003,929 46,021,758.170 1,932,914 44,259,917.376 1,858,917 42,424,079.269 1,781,811 40,511,135.960 1,701,468 38,517,849.033 1,617,750 36,440,844.055 1,530,515 34,276,604.868 1,439,617 32,021,467.636 1,344,902 29,671,614.639 1,246,208 27,223,067.816 1,143,369 24,671,682.027 1,036,211 22,013,138.035 924,552 19,242,935.195 808,203 16,356,383.836 686,968 13,348,597.320 560,641 10,214,483.770 429,008 6,948,737.451 291,847 3,545,829.786 148,925 0.000 82,836,940

13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

910,000 2,940,000 3,850,000 66,150,000 66,150,000 5% 42 -$3,575,103.35 valor cuota $3,575,103.35 $3,575,103.35 $3,575,103.35 $3,575,103.35 $3,575,103.35 $3,575,103.35

abono $544,878.24 $569,838.23 $595,941.61 $623,240.73 $651,790.39 $681,647.86

interes 3,030,225 3,005,265 2,979,162 2,951,863 2,923,313 2,893,455

saldo 66,150,000 65,605,121.76 65,035,283.53 64,439,341.93 63,816,101.19 63,164,310.81 62,482,662.95

2 año 940,456 3,038,396 3,978,851.506 68,363,903.141 68,363,903.14 42 5% -$3,694,754.64 valoe cuota $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64

abono k $563,114.18 $588,909.53 $615,886.53 $644,099.30 $673,604.46 $704,461.20 $736,731.43 $770,479.91 $805,774.36 $842,685.58 $881,287.66 $921,658.03

interes 3,131,640.46 3,105,845.10 3,078,868.10 3,050,655.33 3,021,150.18 2,990,293.44 2,958,023.21 2,924,274.73 2,888,980.28 2,852,069.05 2,813,466.98 2,773,096.61

saldo 68,363,903.14 67,800,788.96 67,211,879.43 66,595,992.89 65,951,893.59 65,278,289.13 64,573,827.93 63,837,096.51 63,066,616.59 62,260,842.24 61,418,156.65 60,536,869.00 59,615,210.97

DIFETENCIA TASA PACTADA Y TASA R T. PACTADA AÑO 1 17,216,761 AÑO 2 82,836,940 100,053,701 VALOR PRESTADO 70,000,000 70,000,000

$3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64 $3,694,754.64

$963,877.70 $1,008,031.39 $1,054,207.68 $1,102,499.24 $1,153,002.96 $1,205,820.17 $1,261,056.85 $1,318,823.84 $1,379,237.04 $1,442,417.67 $1,508,492.50 $1,577,594.12 $1,649,861.17 $1,725,438.65 $1,804,478.22 $1,887,138.47 $1,973,585.25 $2,063,992.01 $2,158,540.17 $2,257,419.42 $2,360,828.17 $2,468,973.91 $2,582,073.64 $2,700,354.28 $2,824,053.17 $2,953,418.50 $3,088,709.85 $3,230,198.68 $3,378,168.89 $3,532,917.37

2,730,876.94 58,651,333.27 2,686,723.25 57,643,301.89 2,640,546.96 56,589,094.20 2,592,255.40 55,486,594.96 2,541,751.68 54,333,592.01 2,488,934.47 53,127,771.84 2,433,697.79 51,866,714.99 2,375,930.80 50,547,891.15 2,315,517.60 49,168,654.11 2,252,336.97 47,726,236.44 2,186,262.14 46,217,743.94 2,117,160.52 44,640,149.83 2,044,893.47 42,990,288.66 1,969,315.99 41,264,850.01 1,890,276.42 39,460,371.79 1,807,616.17 37,573,233.32 1,721,169.39 35,599,648.07 1,630,762.63 33,535,656.06 1,536,214.47 31,377,115.90 1,437,335.22 29,119,696.48 1,333,926.46 26,758,868.30 1,225,780.72 24,289,894.39 1,112,681.00 21,707,820.75 994,400.36 19,007,466.47 870,701.47 16,183,413.30 741,336.14 13,229,994.80 606,044.78 10,141,284.95 464,555.95 6,911,086.26 316,585.75 3,532,917.37 161,837.26 0.00 86,815,791.63

CIA TASA PACTADA Y TASA REAL T. REAL 17,783,283 86,815,792 104,599,075 4,545,374 TOTAL PAGADO 100,053,701 30,053,701 104,599,075 34,599,075