V.

CREDITO TASA A TASA PER AÑOS NPER NCAP PAGO

TABLA DE AMORTIZACION
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
1 $140,000.00 $2,100.00 $4,112.50 $2,012.50 $137,987.50
2 $137,987.50 $2,069.81 $4,112.50 $2,042.69 $135,944.81
3 $135,944.81 $2,039.17 $4,112.50 $2,073.33 $133,871.48
4 $133,871.48 $2,008.07 $4,112.50 $2,104.43 $131,767.06
5 $131,767.06 $1,976.51 $4,112.50 $2,135.99 $129,631.06
6 $129,631.06 $1,944.47 $4,112.50 $2,168.03 $127,463.03
7 $127,463.03 $1,911.95 $4,112.50 $2,200.55 $125,262.47
8 $125,262.47 $1,878.94 $4,112.50 $2,233.56 $123,028.91
9 $123,028.91 $1,845.43 $4,112.50 $2,267.07 $120,761.85
10 $120,761.85 $1,811.43 $4,112.50 $2,301.07 $118,460.77
11 $118,460.77 $1,776.91 $4,112.50 $2,335.59 $116,125.18
12 $116,125.18 $1,741.88 $4,112.50 $2,370.62 $113,754.56
13 $113,754.56 $1,706.32 $4,112.50 $2,406.18 $111,348.38
14 $111,348.38 $1,670.23 $4,112.50 $2,442.27 $108,906.11
15 $108,906.11 $1,633.59 $4,112.50 $2,478.91 $106,427.20
16 $106,427.20 $1,596.41 $4,112.50 $2,516.09 $103,911.11
17 $103,911.11 $1,558.67 $4,112.50 $2,553.83 $101,357.27
18 $101,357.27 $1,520.36 $4,112.50 $2,592.14 $98,765.13
19 $98,765.13 $1,481.48 $4,112.50 $2,631.02 $96,134.11
20 $96,134.11 $1,442.01 $4,112.50 $2,670.49 $93,463.62
21 $93,463.62 $1,401.95 $4,112.50 $2,710.55 $90,753.08
22 $90,753.08 $1,361.30 $4,112.50 $2,751.20 $88,001.87
23 $88,001.87 $1,320.03 $4,112.50 $2,792.47 $85,209.40
24 $85,209.40 $1,278.14 $4,112.50 $2,834.36 $82,375.04
25 $82,375.04 $1,235.63 $4,112.50 $2,876.87 $79,498.17
26 $79,498.17 $1,192.47 $4,112.50 $2,920.03 $76,578.14
27 $76,578.14 $1,148.67 $4,112.50 $2,963.83 $73,614.31
28 $73,614.31 $1,104.21 $4,112.50 $3,008.29 $70,606.03
29 $70,606.03 $1,059.09 $4,112.50 $3,053.41 $67,552.62
30 $67,552.62 $1,013.29 $4,112.50 $3,099.21 $64,453.41
31 $64,453.41 $966.80 $4,112.50 $3,145.70 $61,307.71
32 $61,307.71 $919.62 $4,112.50 $3,192.88 $58,114.82
33 $58,114.82 $871.72 $4,112.50 $3,240.78 $54,874.05
34 $54,874.05 $823.11 $4,112.50 $3,289.39 $51,584.66
35 $51,584.66 $773.77 $4,112.50 $3,338.73 $48,245.93
36 $48,245.93 $723.69 $4,112.50 $3,388.81 $44,857.11
37 $44,857.11 $672.86 $4,112.50 $3,439.64 $41,417.47
38 $41,417.47 $621.26 $4,112.50 $3,491.24 $37,926.23
39 $37,926.23 $568.89 $4,112.50 $3,543.61 $34,382.63
40 $34,382.63 $515.74 $4,112.50 $3,596.76 $30,785.87
41 $30,785.87 $461.79 $4,112.50 $3,650.71 $27,135.15
42 $27,135.15 $407.03 $4,112.50 $3,705.47 $23,429.68
43 $23,429.68 $351.45 $4,112.50 $3,761.05 $19,668.63
44 $19,668.63 $295.03 $4,112.50 $3,817.47 $15,851.16
45 $15,851.16 $237.77 $4,112.50 $3,874.73 $11,976.42
46 $11,976.42 $179.65 $4,112.50 $3,932.85 $8,043.57
47 $8,043.57 $120.65 $4,112.50 $3,991.85 $4,051.72
48 $4,051.72 $60.78 $4,112.50 $4,051.72 $-0.00
V. CREDITO TASA A TASA PER AÑOS NPER NCAP PAGOS
80000 0.16 0.04 5 20 4 $5,886.54
$45,245.61 0.16 0.04 3 12 4 $4,821.02

TABLA DE AMORTIZACION
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
1 $80,000.00 $3,200.00 $5,886.54 $2,686.54 $77,313.46
2 $77,313.46 $3,092.54 $5,886.54 $2,794.00 $74,519.46
3 $74,519.46 $2,980.78 $5,886.54 $2,905.76 $71,613.70
4 $71,613.70 $2,864.55 $5,886.54 $3,021.99 $68,591.70
5 $68,591.70 $2,743.67 $5,886.54 $3,142.87 $65,448.83
6 $65,448.83 $2,617.95 $5,886.54 $3,268.59 $62,180.25
7 $62,180.25 $2,487.21 $5,886.54 $3,399.33 $58,780.92
8 $58,780.92 $2,351.24 $5,886.54 $3,535.30 $45,245.61 ABONO 10000
9 $45,245.61 $1,809.82 $4,821.02 $3,011.19 $42,234.42
10 $42,234.42 $1,689.38 $4,821.02 $3,131.64 $39,102.78
11 $39,102.78 $1,564.11 $4,821.02 $3,256.91 $35,845.87
12 $35,845.87 $1,433.83 $4,821.02 $3,387.18 $32,458.69
13 $32,458.69 $1,298.35 $4,821.02 $3,522.67 $28,936.02
14 $28,936.02 $1,157.44 $4,821.02 $3,663.58 $25,272.44
15 $25,272.44 $1,010.90 $4,821.02 $3,810.12 $21,462.32
16 $21,462.32 $858.49 $4,821.02 $3,962.53 $17,499.79
17 $17,499.79 $699.99 $4,821.02 $4,121.03 $13,378.76
18 $13,378.76 $535.15 $4,821.02 $4,285.87 $9,092.90
19 $9,092.90 $363.72 $4,821.02 $4,457.30 $4,635.59
20 $4,635.59 $185.42 $4,821.02 $4,635.59 $-0.00
 VA AÑOS TASA ANUAL TASA PER N PERIODOS NCAP PAGO
60000 3 0.15 0.0125 36 12 $2,079.92
$23,044.08 1 0.18 0.015 12 12 $2,112.68

TABLA AMORTIZACION
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
1 60000 750 $2,079.92 $1,329.92 $58,670.08
2 $58,670.08 $733.38 $2,079.92 $1,346.54 $57,323.54
3 $57,323.54 $716.54 $2,079.92 $1,363.38 $55,960.16
4 $55,960.16 $699.50 $2,079.92 $1,380.42 $54,579.74
5 $54,579.74 $682.25 $2,079.92 $1,397.67 $53,182.07
6 $53,182.07 $664.78 $2,079.92 $1,415.14 $51,766.93
7 $51,766.93 $647.09 $2,079.92 $1,432.83 $50,334.09
8 $50,334.09 $629.18 $2,079.92 $1,450.74 $48,883.35
9 $48,883.35 $611.04 $2,079.92 $1,468.88 $47,414.47
10 $47,414.47 $592.68 $2,079.92 $1,487.24 $45,927.23
11 $45,927.23 $574.09 $2,079.92 $1,505.83 $44,421.40
12 $44,421.40 $555.27 $2,079.92 $1,524.65 $42,896.75
13 $42,896.75 $536.21 $2,079.92 $1,543.71 $41,353.04
14 $41,353.04 $516.91 $2,079.92 $1,563.01 $39,790.03
15 $39,790.03 $497.38 $2,079.92 $1,582.54 $38,207.49
16 $38,207.49 $477.59 $2,079.92 $1,602.33 $36,605.16
17 $36,605.16 $457.56 $2,079.92 $1,622.36 $34,982.81
18 $34,982.81 $437.29 $2,079.92 $1,642.63 $33,340.17
19 $33,340.17 $416.75 $2,079.92 $1,663.17 $31,677.01
20 $31,677.01 $395.96 $2,079.92 $1,683.96 $29,993.05
21 $29,993.05 $374.91 $2,079.92 $1,705.01 $28,288.04
22 $28,288.04 $353.60 $2,079.92 $1,726.32 $26,561.72
23 $26,561.72 $332.02 $2,079.92 $1,747.90 $24,813.83
24 $24,813.83 $310.17 $2,079.92 $1,769.75 $23,044.08
25 $23,044.08 $345.66 $2,112.68 $1,767.02 $21,277.06
26 $21,277.06 $319.16 $2,112.68 $1,793.53 $19,483.53
27 $19,483.53 $292.25 $2,112.68 $1,820.43 $17,663.11
28 $17,663.11 $264.95 $2,112.68 $1,847.73 $15,815.37
29 $15,815.37 $237.23 $2,112.68 $1,875.45 $13,939.92
30 $13,939.92 $209.10 $2,112.68 $1,903.58 $12,036.34
31 $12,036.34 $180.55 $2,112.68 $1,932.14 $10,104.20
32 $10,104.20 $151.56 $2,112.68 $1,961.12 $8,143.09
33 $8,143.09 $122.15 $2,112.68 $1,990.53 $6,152.55
34 $6,152.55 $92.29 $2,112.68 $2,020.39 $4,132.16
35 $4,132.16 $61.98 $2,112.68 $2,050.70 $2,081.46
36 $2,081.46 $31.22 $2,112.68 $2,081.46 $0.00
VA TASA A TASA PER AÑOS NPER NCAP ir i
300000 0.18 0.045 5 20 4 0.03 0.15

TABLA AMORTIZACION
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
$1.00 $300,000.00 $13,500.00 $17,960.51 $4,460.51 $295,539.49
$2.00 $295,539.49 $13,299.28 $17,960.51 $4,661.24 $290,878.25
$3.00 $290,878.25 $13,089.52 $17,960.51 $4,870.99 $286,007.26
$4.00 $286,007.26 $12,870.33 $17,960.51 $5,090.19 $280,917.07
$5.00 $280,917.07 $12,641.27 $20,654.59 $8,013.32 $272,903.75
$6.00 $272,903.75 $12,280.67 $20,654.59 $8,373.92 $264,529.82
$7.00 $264,529.82 $11,903.84 $20,654.59 $8,750.75 $255,779.08
$8.00 $255,779.08 $11,510.06 $20,654.59 $9,144.53 $246,634.54
$9.00 $246,634.54 $11,098.55 $23,752.78 $12,654.22 $233,980.32
$10.00 $233,980.32 $10,529.11 $23,752.78 $13,223.67 $220,756.65
$11.00 $220,756.65 $9,934.05 $23,752.78 $13,818.73 $206,937.92
$12.00 $206,937.92 $9,312.21 $23,752.78 $14,440.57 $192,497.35
$13.00 $192,497.35 $8,662.38 $27,315.70 $18,653.32 $173,844.04
$14.00 $173,844.04 $7,822.98 $27,315.70 $19,492.71 $154,351.32
$15.00 $154,351.32 $6,945.81 $27,315.70 $20,369.89 $133,981.43
$16.00 $133,981.43 $6,029.16 $27,315.70 $21,286.53 $112,694.90
$17.00 $112,694.90 $5,071.27 $31,413.05 $26,341.78 $86,353.12
$18.00 $86,353.12 $3,885.89 $31,413.05 $27,527.16 $58,825.96
$19.00 $58,825.96 $2,647.17 $31,413.05 $28,765.88 $30,060.08
$20.00 $30,060.08 $1,352.70 $31,413.05 $30,060.35 $0.00
 (1+ir)^n (1+i)^-n (1+ir) (1+i) (1+ir)-(1+i) (1+ir)^n * (1+i)^-n -1 PAGO
1.80611123 0.41464286 1.03 1.045 0.015 0.251108872748219 17960.5137
año 2 20654.5908
año 3 23752.7794
1.15 año 4 27315.6963
año 5 31413.0508
 VA AÑOS TASA A d d/i NCAP
250000 8 0.15 5000 33333.3333333333 1

TABLA DE AMORTIZACION
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
1 250,000.00 37,500.00 41,805.88 4,305.88 245,694.12
2 245,694.12 36,854.12 46,805.88 9,951.76 235,742.36
3 235,742.36 35,361.35 51,805.88 16,444.53 219,297.83
4 219,297.83 32,894.67 56,805.88 23,911.21 195,386.63
5 195,386.63 29,307.99 61,805.88 32,497.89 162,888.74
6 162,888.74 24,433.31 66,805.88 42,372.57 120,516.17
7 120,516.17 18,077.43 71,805.88 53,728.45 66,787.72
8 66,787.72 10,018.16 76,805.88 66,787.72 0.00
va PAGO1 (1+i)^-n
$4.49 $41,805.88 0.32690177
 VA AÑOS TASA A TASA ANUAL NCAP NPER PAGO DIFERENCIA
180000 6 0.14 0.14 1 6 56897.4573 -5000

TABLA DE AMORTIZACIÓN
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
1 $180,000.00 $25,200.00 $56,897.46 $31,697.46 $148,302.54
2 $148,302.54 $20,762.36 $51,897.46 $31,135.10 $117,167.44
3 $117,167.44 $16,403.44 $46,897.46 $30,494.02 $86,673.43
4 $86,673.43 $12,134.28 $41,897.46 $29,763.18 $56,910.25
5 $56,910.25 $7,967.43 $36,897.46 $28,930.02 $27,980.23
6 $27,980.23 $3,917.23 $31,897.46 $27,980.23 $0.00
TOTAL $86,384.74 $266,384.74 $180,000.00
 (1+i)^-n 1- (1+i)^-n / i
0.45558655 3.8886675165
 TASA
VA TASA A TASA PER AÑOS NCAP NPER CRECIENTE
300000 0.12 0.03 4 4 16 0.06

TABLA DE AMORTIZACIÓN
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
1 $ 300,000.00 $ 9,000.00 $ 15,435.72 $ 6,435.72 $ 293,564.28
2 $ 293,564.28 $ 8,806.93 $ 16,361.86 $ 7,554.93 $ 286,009.35
3 $ 286,009.35 $ 8,580.28 $ 17,343.57 $ 8,763.29 $ 277,246.05
4 $ 277,246.05 $ 8,317.38 $ 18,384.19 $ 10,066.81 $ 267,179.24
5 $ 267,179.24 $ 8,015.38 $ 19,487.24 $ 11,471.86 $ 255,707.38
6 $ 255,707.38 $ 7,671.22 $ 20,656.48 $ 12,985.25 $ 242,722.13
7 $ 242,722.13 $ 7,281.66 $ 21,895.86 $ 14,614.20 $ 228,107.93
8 $ 228,107.93 $ 6,843.24 $ 23,209.62 $ 16,366.38 $ 211,741.55
9 $ 211,741.55 $ 6,352.25 $ 24,602.19 $ 18,249.95 $ 193,491.60
10 $ 193,491.60 $ 5,804.75 $ 26,078.32 $ 20,273.58 $ 173,218.03
11 $ 173,218.03 $ 5,196.54 $ 27,643.02 $ 22,446.48 $ 150,771.54
12 $ 150,771.54 $ 4,523.15 $ 29,301.60 $ 24,778.46 $ 125,993.08
13 $ 125,993.08 $ 3,779.79 $ 31,059.70 $ 27,279.91 $ 98,713.18
14 $ 98,713.18 $ 2,961.40 $ 32,923.28 $ 29,961.89 $ 68,751.29
15 $ 68,751.29 $ 2,062.54 $ 34,898.68 $ 32,836.14 $ 35,915.15
16 $ 35,915.15 $ 1,077.45 $ 36,992.60 $ 35,915.15 $ 0.00
 PAGO (1+ir)^n (1+i)^-n (1+ir)^n * (1+i)^-n -1 (1+i) (1+ir) (1+ir) - (1+i)
15435.7199 2.54035168 0.62316694 0.583063183888232 1.03 1.06 0.03
V. CREDITO AÑOS NCAP NPER ir TASA TASA PER PAGO
600000 3 2 6 0.1 0.16 0.08 159161.469

TABLA DE AMORTIZACION
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
1 $600,000.00 $48,000.00 $159,161.47 $111,161.47 $488,838.53
2 $488,838.53 $39,107.08 $144,692.24 $105,585.16 $383,253.37
3 $383,253.37 $30,660.27 $131,538.40 $100,878.13 $282,375.23
4 $282,375.23 $22,590.02 $119,580.37 $96,990.35 $185,384.88
5 $185,384.88 $14,830.79 $108,709.43 $93,878.63 $91,506.25
6 $91,506.25 $7,320.50 $98,826.75 $91,506.25 $0.00
 (1+i)^-n (1+ir)^n ((1+i)^-n/(1+ir)^n)-1 1/(1+ir) (1+i) 1/(1+ir)-(1+i)
0.63016963 1.771561 -0.644285674112772 0.90909091 1.08 -0.1709090909
 TABLA DE AMORTIZACIÓN
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
1 $1,000,000 $37,500 $37,500.00 $0.00 $1,000,000.00
2 $1,000,000.00 $37,500 $37,500.00 $0.00 $1,000,000.00
3 $1,000,000.00 $37,500 $37,500.00 $0.00 $1,000,000.00
4 $1,000,000.00 $37,500 $37,500.00 $0.00 $1,000,000.00
5 $1,000,000.00 $37,500 $37,500.00 $0.00 $1,000,000.00
6 $1,000,000.00 $37,500 $37,500.00 $0.00 $1,000,000.00
7 $1,000,000.00 $37,500 $37,500.00 $0.00 $1,000,000.00
8 $1,000,000.00 $37,500 $37,500.00 $0.00 $1,000,000.00

TABLA DE AMORTIZACIÓN
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
1 $1,000,000 $37,500 $84,244.83 $46,744.83 $953,255.17
2 $953,255.17 $35,747 $84,244.83 $48,497.76 $904,757.42
3 $904,757.42 $33,928 $84,244.83 $50,316.42 $854,440.99
4 $854,440.99 $32,042 $84,244.83 $52,203.29 $802,237.70
5 $802,237.70 $30,084 $84,244.83 $54,160.91 $748,076.79
6 $748,076.79 $28,053 $84,244.83 $56,191.95 $691,884.84
7 $691,884.84 $25,946 $84,244.83 $58,299.15 $633,585.70
8 $633,585.70 $23,759 $84,244.83 $60,485.36 $573,100.33
9 $573,100.33 $21,491 $84,244.83 $62,753.56 $510,346.77
10 $510,346.77 $19,138 $84,244.83 $65,106.82 $445,239.94
11 $445,239.94 $16,696 $84,244.83 $67,548.33 $377,691.62
12 $377,691.62 $14,163 $84,244.83 $70,081.39 $307,610.22
13 $307,610.22 $11,535 $84,244.83 $72,709.44 $234,900.78
14 $234,900.78 $8,809 $84,244.83 $75,436.05 $159,464.73
15 $159,464.73 $5,980 $84,244.83 $78,264.90 $81,199.83
16 $81,199.83 $3,045 $84,244.83 $81,199.83 $0.00
 TABLA DE AMORTIZACIÓN
PERIODO S. INICIAL INTERES PAGO AMORTIZACION K S. FINAL
1 $596.26 $26.83 $ 53,076.24 $ 26,244.57 $ 570,014.73
2 $ 570,014.73 $25.65 $ 53,076.24 $ 27,425.58 $ 542,589.15
3 $ 542,589.15 $24.42 $ 53,076.24 $ 28,659.73 $ 513,929.42
4 $ 513,929.42 $23.13 $ 53,076.24 $ 29,949.42 $ 483,980.00
5 $ 483,980.00 $21.78 $ 53,076.24 $ 31,297.14 $ 452,682.86
6 $ 452,682.86 $20.37 $ 53,076.24 $ 32,705.51 $ 419,977.34
7 $ 419,977.34 $18.90 $ 53,076.24 $ 34,177.26 $ 385,800.08
8 $ 385,800.08 $17.36 $ 53,076.24 $ 35,715.24 $ 350,084.84
9 $ 350,084.84 $15.75 $ 53,076.24 $ 37,322.42 $ 312,762.42
10 $ 312,762.42 $14.07 $ 53,076.24 $ 39,001.93 $ 273,760.49
11 $ 273,760.49 $12.32 $ 53,076.24 $ 40,757.02 $ 233,003.47
12 $ 233,003.47 $10.49 $ 53,076.24 $ 42,591.09 $ 190,412.38
13 $ 190,412.38 $8.57 $ 53,076.24 $ 44,507.68 $ 145,904.70
14 $ 145,904.70 $6.57 $ 53,076.24 $ 46,510.53 $ 99,394.17
15 $ 99,394.17 $4.47 $ 53,076.24 $ 48,603.50 $ 50,790.66
16 $ 50,790.66 $2.29 $ 53,076.24 $ 50,790.66 $ 0.00