Ejercicios de Amortizacion de Deuda Con Gradiente Expo 1

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 34

PRESTAMO S/.

1,000,000
N 1 año 12
INTERES 31.2% nominal anual TEM

TABLA DE AMORTIZACION (amortizacion fija o metodo Alemán)


N CUOTA INTERES ABONO
0
1 S/. 109,333.33 S/. 26,000.00 S/. 83,333.33
2 S/. 107,166.67 S/. 23,833.33 S/. 83,333.33
3 S/. 105,000.00 S/. 21,666.67 S/. 83,333.33
4 S/. 102,833.33 S/. 19,500.00 S/. 83,333.33
5 S/. 100,666.67 S/. 17,333.33 S/. 83,333.33
6 S/. 98,500.00 S/. 15,166.67 S/. 83,333.33
7 S/. 96,333.33 S/. 13,000.00 S/. 83,333.33
8 S/. 94,166.67 S/. 10,833.33 S/. 83,333.33
9 S/. 92,000.00 S/. 8,666.67 S/. 83,333.33
10 S/. 89,833.33 S/. 6,500.00 S/. 83,333.33
11 S/. 87,666.67 S/. 4,333.33 S/. 83,333.33
12 S/. 85,500.00 S/. 2,166.67 S/. 83,333.33

PRESTAMO S/. 1,000,000


N 1 año 12
INTERES 31.2% nominal anual TEM
GRADIENTE S/. 10,000
PRIMERA CUOTA S/. 46,132

N CUOTA INTERES ABONO


0
1 S/. 46,132.22 S/. 26,000.00 S/. 20,132.22
2 S/. 56,132.22 S/. 25,476.56 S/. 30,655.66
3 S/. 66,132.22 S/. 24,679.52 S/. 41,452.71
4 S/. 76,132.22 S/. 23,601.74 S/. 52,530.48
5 S/. 86,132.22 S/. 22,235.95 S/. 63,896.27
6 S/. 96,132.22 S/. 20,574.65 S/. 75,557.57
7 S/. 106,132.22 S/. 18,610.15 S/. 87,522.07
8 S/. 116,132.22 S/. 16,334.58 S/. 99,797.64
9 S/. 126,132.22 S/. 13,739.84 S/. 112,392.38
10 S/. 136,132.22 S/. 10,817.64 S/. 125,314.58
11 S/. 146,132.22 S/. 7,559.46 S/. 138,572.76
12 S/. 156,132.22 S/. 3,956.57 S/. 152,175.65
meses
2.6% efec. Mensual

odo Alemán) TABLA DE AMORTIZACION (cuota fija o metodo Frances)


SALDO N CUOTA INTERES ABONO
S/. 1,000,000 0
S/. 916,666.67 1 S/.98,078 S/.26,000.00 S/.72,078.34
S/. 833,333.33 2 S/.98,078 S/.24,125.96 S/.73,952.38
S/. 750,000.00 3 S/.98,078 S/.22,203.20 S/.75,875.14
S/. 666,666.67 4 S/.98,078 S/.20,230.45 S/.77,847.89
S/. 583,333.33 5 S/.98,078 S/.18,206.40 S/.79,871.94
S/. 500,000.00 6 S/.98,078 S/.16,129.73 S/.81,948.61
S/. 416,666.67 7 S/.98,078 S/.13,999.07 S/.84,079.27
S/. 333,333.33 8 S/.98,078 S/.11,813.01 S/.86,265.33
S/. 250,000.00 9 S/.98,078 S/.9,570.11 S/.88,508.23
S/. 166,666.67 10 S/.98,078 S/.7,268.89 S/.90,809.45
S/. 83,333.33 11 S/.98,078 S/.4,907.85 S/.93,170.49
S/. - 12 S/.98,078 S/.2,485.42 S/.95,592.92

PRESTAMO S/. 1,000,000


meses N 1 año
2.6% efec. Mensual INTERES 31.2% nominal anual
GRADIENTE S/. -10,000
PRIMERA CUOTA S/. 150,024

SALDO N CUOTA INTERES


S/. 1,000,000 0
S/. 979,867.78 1 S/. 150,024.46 S/. 26,000.00
S/. 949,212.12 2 S/. 140,024.46 S/. 22,775.36
S/. 907,759.41 3 S/. 130,024.46 S/. 19,726.89
S/. 855,228.94 4 S/. 120,024.46 S/. 16,859.15
S/. 791,332.67 5 S/. 110,024.46 S/. 14,176.85
S/. 715,775.09 6 S/. 100,024.46 S/. 11,684.81
S/. 628,253.03 7 S/. 90,024.46 S/. 9,387.98
S/. 528,455.38 8 S/. 80,024.46 S/. 7,291.44
S/. 416,063.00 9 S/. 70,024.46 S/. 5,400.38
S/. 290,748.42 10 S/. 60,024.46 S/. 3,720.15
S/. 152,175.65 11 S/. 50,024.46 S/. 2,256.24
S/. - 12 S/. 40,024.46 S/. 1,014.27
todo Frances)
SALDO
S/.1,000,000
S/.927,921.66
S/.853,969.28
S/.778,094.14
S/.700,246.25
S/.620,374.31
S/.538,425.70
S/.454,346.43
S/.368,081.10
S/.279,572.86
S/.188,763.42
S/.95,592.92
S/.0.00

12 meses
TEM 2.6% efec. Mensual

ABONO SALDO
S/. 1,000,000
S/. 124,024.46 S/. 875,975.54
S/. 117,249.10 S/. 758,726.44
S/. 110,297.57 S/. 648,428.87
S/. 103,165.31 S/. 545,263.56
S/. 95,847.61 S/. 449,415.95
S/. 88,339.65 S/. 361,076.31
S/. 80,636.48 S/. 280,439.83
S/. 72,733.02 S/. 207,706.81
S/. 64,624.08 S/. 143,082.73
S/. 56,304.31 S/. 86,778.42
S/. 47,768.22 S/. 39,010.20
S/. 39,010.20 S/. -
PRESTAMO S/. 6,000,000
N 24
INTERES 1.30% efec. Mensual
GRADIENTE 2% mensual
PRIMERA CUOTA S/. 487,537

CUOTA CRECIENTE GEOMETRICA


N CUOTA INTERES ABONO
0
1 S/. 487,537.19 S/. 78,000.00 S/. 409,537.19
2 S/. 497,287.93 S/. 72,676.02 S/. 424,611.91
3 S/. 507,233.69 S/. 67,156.06 S/. 440,077.63
4 S/. 517,378.36 S/. 61,435.05 S/. 455,943.31
5 S/. 527,725.93 S/. 55,507.79 S/. 472,218.14
6 S/. 538,280.45 S/. 49,368.95 S/. 488,911.50
7 S/. 549,046.06 S/. 43,013.10 S/. 506,032.95
8 S/. 560,026.98 S/. 36,434.68 S/. 523,592.30
9 S/. 571,227.52 S/. 29,627.98 S/. 541,599.54
10 S/. 582,652.07 S/. 22,587.18 S/. 560,064.89
11 S/. 594,305.11 S/. 15,306.34 S/. 578,998.77
12 S/. 606,191.21 S/. 7,779.35 S/. 598,411.86
GRADIENTE -2% mensual
PRIMERA CUOTA S/. 603,745

CUOTA DECRECIENTE GEOMETRICA


SALDO N CUOTA INTERES
S/. 6,000,000 0
S/. 5,590,462.81 1 S/. 603,744.81 S/. 78,000.00
S/. 5,165,850.90 2 S/. 591,669.92 S/. 71,165.32
S/. 4,725,773.27 3 S/. 579,836.52 S/. 64,398.76
S/. 4,269,829.96 4 S/. 568,239.79 S/. 57,698.07
S/. 3,797,611.82 5 S/. 556,874.99 S/. 51,061.02
S/. 3,308,700.32 6 S/. 545,737.49 S/. 44,485.44
S/. 2,802,667.37 7 S/. 534,822.74 S/. 37,969.17
S/. 2,279,075.06 8 S/. 524,126.29 S/. 31,510.07
S/. 1,737,475.52 9 S/. 513,643.76 S/. 25,106.06
S/. 1,177,410.63 10 S/. 503,370.89 S/. 18,755.07
S/. 598,411.86 11 S/. 493,303.47 S/. 12,455.06
S/. - 12 S/. 483,437.40 S/. 6,204.03
ECIENTE GEOMETRICA
ABONO SALDO
S/. 6,000,000
S/. 525,744.81 S/. 5,474,255.19
S/. 520,504.60 S/. 4,953,750.59
S/. 515,437.76 S/. 4,438,312.83
S/. 510,541.72 S/. 3,927,771.11
S/. 505,813.97 S/. 3,421,957.14
S/. 501,252.05 S/. 2,920,705.09
S/. 496,853.58 S/. 2,423,851.51
S/. 492,616.22 S/. 1,931,235.29
S/. 488,537.70 S/. 1,442,697.59
S/. 484,615.82 S/. 958,081.77
S/. 480,848.41 S/. 477,233.37
S/. 477,233.37 S/. 0.00
PRESTAMO S/. 250,000
N 24
INTERES 2%
GRADIENTE S/. 12,000
PRIMERA CUOTA S/. -113,438

N CUOTA INTERES ABONO


0
1 S/. -113,438.43 S/. 5,000.00 S/. -118,438.43
2 S/. -101,438.43 S/. 7,368.77 S/. -108,807.19
3 S/. -89,438.43 S/. 9,544.91 S/. -98,983.34
4 S/. -77,438.43 S/. 11,524.58 S/. -88,963.00
5 S/. -65,438.43 S/. 13,303.84 S/. -78,742.26
6 S/. -53,438.43 S/. 14,878.68 S/. -68,317.11
7 S/. -41,438.43 S/. 16,245.03 S/. -57,683.45
8 S/. -29,438.43 S/. 17,398.70 S/. -46,837.12
9 S/. -17,438.43 S/. 18,335.44 S/. -35,773.86
10 S/. -5,438.43 S/. 19,050.92 S/. -24,489.34
11 S/. 6,561.57 S/. 19,540.70 S/. -12,979.13
12 S/. 18,561.57 S/. 19,800.28 S/. -1,238.71
13 S/. 30,561.57 S/. 19,825.06 S/. 10,736.52
14 S/. 42,561.57 S/. 19,610.33 S/. 22,951.25
15 S/. 54,561.57 S/. 19,151.30 S/. 35,410.27
16 S/. 66,561.57 S/. 18,443.10 S/. 48,118.48
17 S/. 78,561.57 S/. 17,480.73 S/. 61,080.85
18 S/. 90,561.57 S/. 16,259.11 S/. 74,302.46
19 S/. 102,561.57 S/. 14,773.06 S/. 87,788.51
20 S/. 114,561.57 S/. 13,017.29 S/. 101,544.28
21 S/. 126,561.57 S/. 10,986.41 S/. 115,575.17
22 S/. 138,561.57 S/. 8,674.90 S/. 129,886.67
23 S/. 150,561.57 S/. 6,077.17 S/. 144,484.40
24 S/. 162,561.57 S/. 3,187.48 S/. 159,374.09
SALDO
S/. 250,000
S/. 368,438.43
S/. 477,245.62
S/. 576,228.96
S/. 665,191.96
S/. 743,934.23
S/. 812,251.34
S/. 869,934.79
S/. 916,771.91
S/. 952,545.77
S/. 977,035.11
S/. 990,014.24
S/. 991,252.95
S/. 980,516.43
S/. 957,565.19
S/. 922,154.92
S/. 874,036.44
S/. 812,955.59
S/. 738,653.13
S/. 650,864.62
S/. 549,320.34
S/. 433,745.17
S/. 303,858.50
S/. 159,374.09
S/. -
PRESTAMO S/. 150,000
N 36
INTERES 1.5%
GRADIENTE 3%
PRIMERA CUOTA S/. 3,234

N CUOTA INTERES ABONO


0
1 S/. 3,233.91 S/. 2,250.00 S/. 983.91
2 S/. 3,330.92 S/. 2,235.24 S/. 1,095.68
3 S/. 3,430.85 S/. 2,218.81 S/. 1,212.05
4 S/. 3,533.78 S/. 2,200.63 S/. 1,333.15
5 S/. 3,639.79 S/. 2,180.63 S/. 1,459.16
6 S/. 3,748.98 S/. 2,158.74 S/. 1,590.24
7 S/. 3,861.45 S/. 2,134.89 S/. 1,726.57
8 S/. 3,977.30 S/. 2,108.99 S/. 1,868.31
9 S/. 4,096.62 S/. 2,080.96 S/. 2,015.65
10 S/. 4,219.51 S/. 2,050.73 S/. 2,168.79
11 S/. 4,346.10 S/. 2,018.20 S/. 2,327.90
12 S/. 4,476.48 S/. 1,983.28 S/. 2,493.20
13 S/. 4,610.78 S/. 1,945.88 S/. 2,664.90
14 S/. 4,749.10 S/. 1,905.91 S/. 2,843.19
15 S/. 4,891.57 S/. 1,863.26 S/. 3,028.31
16 S/. 5,038.32 S/. 1,817.83 S/. 3,220.49
17 S/. 5,189.47 S/. 1,769.53 S/. 3,419.94
18 S/. 5,345.16 S/. 1,718.23 S/. 3,626.93
19 S/. 5,505.51 S/. 1,663.82 S/. 3,841.69
20 S/. 5,670.68 S/. 1,606.20 S/. 4,064.48
21 S/. 5,840.80 S/. 1,545.23 S/. 4,295.56
22 S/. 6,016.02 S/. 1,480.80 S/. 4,535.22
23 S/. 6,196.50 S/. 1,412.77 S/. 4,783.73
24 S/. 6,382.39 S/. 1,341.01 S/. 5,041.38
25 S/. 6,573.87 S/. 1,265.39 S/. 5,308.47
26 S/. 6,771.08 S/. 1,185.77 S/. 5,585.32
27 S/. 6,974.22 S/. 1,101.99 S/. 5,872.23
28 S/. 7,183.44 S/. 1,013.90 S/. 6,169.54
29 S/. 7,398.94 S/. 921.36 S/. 6,477.58
30 S/. 7,620.91 S/. 824.20 S/. 6,796.72
31 S/. 7,849.54 S/. 722.25 S/. 7,127.29
32 S/. 8,085.03 S/. 615.34 S/. 7,469.69
33 S/. 8,327.58 S/. 503.29 S/. 7,824.29
34 S/. 8,577.40 S/. 385.93 S/. 8,191.48
35 S/. 8,834.73 S/. 263.05 S/. 8,571.67
36 S/. 9,099.77 S/. 134.48 S/. 8,965.29
SALDO
S/. 150,000
S/. 149,016.09
S/. 147,920.41
S/. 146,708.37
S/. 145,375.21
S/. 143,916.05
S/. 142,325.81
S/. 140,599.24
S/. 138,730.93
S/. 136,715.28
S/. 134,546.49
S/. 132,218.59
S/. 129,725.39
S/. 127,060.49
S/. 124,217.30
S/. 121,188.98
S/. 117,968.49
S/. 114,548.55
S/. 110,921.62
S/. 107,079.94
S/. 103,015.46
S/. 98,719.90
S/. 94,184.68
S/. 89,400.95
S/. 84,359.57
S/. 79,051.10
S/. 73,465.78
S/. 67,593.55
S/. 61,424.01
S/. 54,946.43
S/. 48,149.71
S/. 41,022.42
S/. 33,552.73
S/. 25,728.44
S/. 17,536.96
S/. 8,965.29
S/. 0.00
PRESTAMO S/. 80,000.00
N 5 años 60
INTERES 2.5% efec. Mensual
PRIMERA CUOTA

N CUOTA INTERES ABONO


0
1 S/. 3,333.33 S/. 2,000.00 S/. 1,333.33
2 S/. 3,300.00 S/. 1,966.67 S/. 1,333.33
3 S/. 3,266.67 S/. 1,933.33 S/. 1,333.33
4 S/. 3,233.33 S/. 1,900.00 S/. 1,333.33
5 S/. 3,200.00 S/. 1,866.67 S/. 1,333.33
6 S/. 3,166.67 S/. 1,833.33 S/. 1,333.33
7 S/. 3,133.33 S/. 1,800.00 S/. 1,333.33
8 S/. 3,100.00 S/. 1,766.67 S/. 1,333.33
9 S/. 3,066.67 S/. 1,733.33 S/. 1,333.33
10 S/. 3,033.33 S/. 1,700.00 S/. 1,333.33
11 S/. 3,000.00 S/. 1,666.67 S/. 1,333.33
12 S/. 2,966.67 S/. 1,633.33 S/. 1,333.33
13 S/. 2,933.33 S/. 1,600.00 S/. 1,333.33
14 S/. 2,900.00 S/. 1,566.67 S/. 1,333.33
15 S/. 2,866.67 S/. 1,533.33 S/. 1,333.33
16 S/. 2,833.33 S/. 1,500.00 S/. 1,333.33
17 S/. 2,800.00 S/. 1,466.67 S/. 1,333.33
18 S/. 2,766.67 S/. 1,433.33 S/. 1,333.33
19 S/. 2,733.33 S/. 1,400.00 S/. 1,333.33
20 S/. 2,700.00 S/. 1,366.67 S/. 1,333.33
21 S/. 2,666.67 S/. 1,333.33 S/. 1,333.33
22 S/. 2,633.33 S/. 1,300.00 S/. 1,333.33
23 S/. 2,600.00 S/. 1,266.67 S/. 1,333.33
24 S/. 2,566.67 S/. 1,233.33 S/. 1,333.33
25 S/. 2,533.33 S/. 1,200.00 S/. 1,333.33
26 S/. 2,500.00 S/. 1,166.67 S/. 1,333.33
27 S/. 2,466.67 S/. 1,133.33 S/. 1,333.33
28 S/. 2,433.33 S/. 1,100.00 S/. 1,333.33
29 S/. 2,400.00 S/. 1,066.67 S/. 1,333.33
30 S/. 2,366.67 S/. 1,033.33 S/. 1,333.33
31 S/. 2,333.33 S/. 1,000.00 S/. 1,333.33
32 S/. 2,300.00 S/. 966.67 S/. 1,333.33
33 S/. 2,266.67 S/. 933.33 S/. 1,333.33
34 S/. 2,233.33 S/. 900.00 S/. 1,333.33
35 S/. 2,200.00 S/. 866.67 S/. 1,333.33
36 S/. 2,166.67 S/. 833.33 S/. 1,333.33
37 S/. 2,133.33 S/. 800.00 S/. 1,333.33
38 S/. 2,100.00 S/. 766.67 S/. 1,333.33
39 S/. 2,066.67 S/. 733.33 S/. 1,333.33
40 S/. 2,033.33 S/. 700.00 S/. 1,333.33
41 S/. 2,000.00 S/. 666.67 S/. 1,333.33
42 S/. 1,966.67 S/. 633.33 S/. 1,333.33
43 S/. 1,933.33 S/. 600.00 S/. 1,333.33
44 S/. 1,900.00 S/. 566.67 S/. 1,333.33
45 S/. 1,866.67 S/. 533.33 S/. 1,333.33
46 S/. 1,833.33 S/. 500.00 S/. 1,333.33
47 S/. 1,800.00 S/. 466.67 S/. 1,333.33
48 S/. 1,766.67 S/. 433.33 S/. 1,333.33
49 S/. 1,733.33 S/. 400.00 S/. 1,333.33
50 S/. 1,700.00 S/. 366.67 S/. 1,333.33
51 S/. 1,666.67 S/. 333.33 S/. 1,333.33
52 S/. 1,633.33 S/. 300.00 S/. 1,333.33
53 S/. 1,600.00 S/. 266.67 S/. 1,333.33
54 S/. 1,566.67 S/. 233.33 S/. 1,333.33
55 S/. 1,533.33 S/. 200.00 S/. 1,333.33
56 S/. 1,500.00 S/. 166.67 S/. 1,333.33
57 S/. 1,466.67 S/. 133.33 S/. 1,333.33
58 S/. 1,433.33 S/. 100.00 S/. 1,333.33
59 S/. 1,400.00 S/. 66.67 S/. 1,333.33
60 S/. 1,366.67 S/. 33.33 S/. 1,333.33
meses

SALDO
S/. 80,000
S/. 78,666.67
S/. 77,333.33
S/. 76,000.00
S/. 74,666.67
S/. 73,333.33
S/. 72,000.00
S/. 70,666.67
S/. 69,333.33
S/. 68,000.00
S/. 66,666.67
S/. 65,333.33
S/. 64,000.00
S/. 62,666.67
S/. 61,333.33
S/. 60,000.00
S/. 58,666.67
S/. 57,333.33
S/. 56,000.00
S/. 54,666.67
S/. 53,333.33
S/. 52,000.00
S/. 50,666.67
S/. 49,333.33
S/. 48,000.00
S/. 46,666.67
S/. 45,333.33
S/. 44,000.00
S/. 42,666.67
S/. 41,333.33
S/. 40,000.00
S/. 38,666.67
S/. 37,333.33
S/. 36,000.00
S/. 34,666.67
S/. 33,333.33
S/. 32,000.00
S/. 30,666.67
S/. 29,333.33
S/. 28,000.00
S/. 26,666.67
S/. 25,333.33
S/. 24,000.00
S/. 22,666.67
S/. 21,333.33
S/. 20,000.00
S/. 18,666.67
S/. 17,333.33
S/. 16,000.00
S/. 14,666.67
S/. 13,333.33
S/. 12,000.00
S/. 10,666.67
S/. 9,333.33
S/. 8,000.00
S/. 6,666.67
S/. 5,333.33
S/. 4,000.00
S/. 2,666.67
S/. 1,333.33
S/. -
PRESTAMO S/. 50,000.00
n 3 años 6
i 1.50% trimestral 3.02%
G S/. 5,000.00

N DEUDA SALDO Interes AMORTIZACION


0 S/. 50,000.00 S/. 50,000.00
1 S/. 54,340.48 S/. 1,511.25 S/. -4,340.48
2 S/. 53,812.14 S/. 1,642.44 S/. 528.33
3 S/. 48,267.84 S/. 1,626.47 S/. 5,544.30
4 S/. 37,555.97 S/. 1,458.90 S/. 10,711.88
5 S/. 21,520.32 S/. 1,135.13 S/. 16,035.64
6 S/. - S/. 650.45 S/. 21,520.32
semestres
semestral

CUOTA

-2829.22677982
S/. 2,170.77
S/. 7,170.77
S/. 12,170.77
S/. 17,170.77
S/. 22,170.77
DEUDA 10000
i 2%
n 6
G -400

N DEUDA SALDO Interes AMORTIZACION CUOTA


0 10000
1 7437.83936 200 2562.1606431277 2762.16064
2 5224.4355 148.756787 2213.4038559903 2362.16064
3 3366.76357 104.48871 1857.6719331101 1962.16064
4 1871.9382 67.3352714 1494.8253717723 1562.16064
5 747.216317 37.4387639 1124.7218792077 1162.16064
6 - 14.9443263 747.2163167919 762.160643
P 70000
n 10 trimestres
i 1.50% mensual 4.57% trimestral

N Deuda Saldo Interes Amortizacion Cuota


0 70000 70000
1 66012.8 3197.5 3987.2 7184.6
2 61484.3 3015.4 4528.5 7543.9
3 56371.8 2808.5 5112.6 7921.1
4 50629.6 2575.0 5742.2 8317.1
5 44209.3 2312.7 6420.3 8733.0
6 37059.1 2019.4 7150.2 9169.6
7 29123.7 1692.8 7935.3 9628.1 17563.4
8 20344.6 1330.3 8779.2 10109.5
9 10658.9 929.3 9685.7 10615.0
10 0.0 486.9 10658.9 11145.7
P 75000000
n ?
i 3% mensual
G 13500

N Deuda Saldo Interes Amortizacion Cuota


0 75000000 75000000
1 69207708.1 2250000 5792291.95 8042291.95
2 63228147.3 2076231.24 5979560.7085 8055791.95
3 57055699.8 1896844.42 6172447.529755 8069291.95
4 50684578.9 1711670.99 6371120.95564765 8082791.95
5 44108824.3 1520537.37 6575754.58431708 8096291.95
6 37322297 1323264.73 6786527.22184659 8109791.95
7 30318674 1119668.91 7003623.03850199 8123291.95
8 23091442.3 909560.22 7227231.72965705 8136791.95
9 15633893.6 692743.268 7457548.68154676 8150291.95
10 7939118.46 469016.808 7694775.14199316 8163791.95
11 0 238173.554 7939118.39625296 8177291.95
P 5000000
n 12
i 2%
G 32824.8554

N Deuda Saldo Interes Amortizacion Cuota


0 5000000 5000000
1 4800000 100000 200000 300000
2 4563175.14 96000 236824.855365 332824.855
3 4288788.94 91263.5029 274386.207836 365649.711
4 3976090.15 85775.7787 312698.787358 398474.566
5 3624312.53 79521.803 351777.618469 431299.421
6 3232674.5 72486.2506 391638.026203 464124.277
7 2800378.86 64653.4901 432295.642092 496949.132
8 2326612.45 56007.5773 473766.410298 529773.988
9 1810545.86 46532.249 516066.593869 562598.843
10 1251333.08 36210.9172 559212.78111 595423.698
11 648111.185 25026.6615 603221.892097 628248.554
12 0 12962.2237 648111.185304 661073.409
P 120000
n 5 AÑOS
i 25%

N Deuda Saldo Interes Amortizacion Cuota


0 120000 120000
1 105495.602425 30495.6024251308 14504.39757487 45000
2 87305.2020014 26809.5995763038 18190.4004237 45000
3 64492.0747504 22186.8727490124 22813.12725099 45000
4 35881.4470101 16389.3722596788 28610.62774032 45000
5 0.00 9118.5528538267 35881.44714617 45000
P 2500
n
i 1.8%
RETIROS 390

N Saldo Interes RETIRO


0 2500
1 2545 45
2 2590.81 45.81
3 2637.44458 46.63458
4 2684.91858 47.4740024
5 2733.24712 48.3285345
6 2782.44557 49.1984481
7 2832.52959 50.0840202
8 2883.51512 50.9855325
9 2935.41839 51.9032721
10 2598.25592 52.837531 390
11 2255.02453 46.7686066 390
12 1905.61497 40.5904415 390
13 1549.91604 34.3010694 390
14 1187.81453 27.8984887 390
15 819.195189 21.3806615 390
16 443.940702 14.7455134 390
17 61.9316346 7.99093264 390
18 -327.9536 1.11476942 391
i 2.50% TEM
i 34% TEA
i 12% anual
ANUALIDAD 69974.41320172

MONTO
N ACUMULADO interés RETIROS
0 69974.41320172
1 78371.34278593 8396.92958
2 31775.90392024 9404.56113 56000
3 35589.01239067 3813.10847 0
4 39859.69387755 4270.68149 0
5 44642.85714286 4783.16327 0
6 50000 5357.14286 0
7 0 6000 56000
P 4000
n 24
i 3.85%

N Deuda Saldo Interes Amortizacion Cuota


0 4000 4000
1 S/. 3,895.67 154 S/. 104.33 S/. 258.33
2 S/. 3,787.32 149.983146 S/. 108.35 S/. 258.33
3 S/. 3,674.79 145.811643 S/. 112.52 S/. 258.33
4 S/. 3,557.94 141.479537 S/. 116.85 S/. 258.33
5 S/. 3,436.59 136.980645 S/. 121.35 S/. 258.33
6 S/. 3,310.56 132.308545 S/. 126.03 S/. 258.33
7 S/. 3,179.68 127.45657 S/. 130.88 S/. 258.33
8 S/. 3,043.77 122.417794 S/. 135.92 S/. 258.33
9 S/. 2,902.62 117.185025 S/. 141.15 S/. 258.33
10 S/. 2,756.03 111.750794 S/. 146.58 S/. 258.33
11 S/. 2,603.81 106.107346 S/. 152.23 S/. 258.33
12 S/. 2,445.72 100.246624 S/. 158.09 S/. 258.33
13 S/. 2,281.55 94.160265 S/. 164.17 S/. 258.33
14 S/. 2,111.05 87.839581 S/. 170.49 S/. 258.33
15 S/. 1,933.99 81.2755507 S/. 177.06 S/. 258.33
16 S/. 1,750.12 74.4588052 S/. 183.88 S/. 258.33
17 S/. 1,559.17 67.379615 S/. 190.95 S/. 258.33
18 S/. 1,360.86 60.027876 S/. 198.31 S/. 258.33
19 S/. 1,154.92 52.3930951 S/. 205.94 S/. 258.33
20 S/. 941.05 44.464375 S/. 213.87 S/. 258.33
21 S/. 718.95 36.2303993 S/. 222.10 S/. 258.33
22 S/. 488.29 27.6794155 S/. 230.65 S/. 258.33
23 S/. 248.76 18.7992188 S/. 239.53 S/. 258.33
24 S/. 0.00 9.57713451 S/. 248.76 S/. 258.33

También podría gustarte