N RENTA INTERES AMORTIZACION

0
1 2,850.00 431.16 2,418.84
2 2,831.25 412.41 2,418.84
3 2,812.51 393.67 2,418.84
4 2,793.76 374.92 2,418.84
5 2,775.01 356.17 2,418.84
6 2,756.27 337.43 2,418.84
7 2,737.52 318.68 2,418.84
8 2,718.78 299.94 2,418.84
9 2,700.03 281.19 2,418.84
10 2,681.28 262.44 2,418.84
11 2,662.54 243.70 2,418.84
12 2,643.79 224.95 2,418.84
13 2,625.05 206.21 2,418.84
14 2,606.30 187.46 2,418.84
15 2,587.55 168.71 2,418.84
16 2,568.81 149.97 2,418.84
17 2,550.06 131.22 2,418.84
18 2,531.32 112.48 2,418.84
19 2,512.57 93.73 2,418.84
20 2,493.82 74.98 2,418.84
21 2,475.08 56.24 2,418.84
22 2,456.33 37.49 2,418.84
23 2,437.59 18.75 2,418.84

N. RENTA INTERES AMORTIZACION

0
1 5695.32 1820 3875.32
2 5695.32 1719.24168 3976.07832
3 5695.32 1615.86364368 4079.45635632
4 5695.32 1509.797778416 4185.5222215843
5 5695.32 1400.974200654 4294.3457993455
6 5695.32 1289.321209872 4405.9987901285
7 5695.32 1174.765241328 4520.5547586718
8 5695.32 1057.230817603 4638.0891823973
9 5695.32 936.6404988604 4758.6795011396
10 5695.32 812.9148318307 4882.4051681693
11 5695.32 685.9722974583 5009.3477025417
12 5695.32 555.7292571923 5139.5907428077
13 5695.32 422.0998978792 5273.2201021208
14 5695.32 284.9961752241 5410.3238247759
15 5695.32 144.3277557799 5550.9922442201
TOTAL 85429.8 15285.54753 69999.924714222
 AMORTIZACION
A 2418.84
SALDO INSOLUTO
55,633.35
53,214.51 n= 8
50,795.67 jm= 17.40%
48,376.83 c= 165000
45,957.99 r= 21303.56
43,539.15 N RENTA INTERES
41,120.31 0
38,701.47 1 21,303.56 1,196.25
36,282.63 2 21,303.56 1,050.47
33,863.79 3 21,303.56 903.64
31,444.95 4 21,303.56 755.74
29,026.11 5 21,303.56 606.77
26,607.27 6 21,303.56 456.71
24,188.43 7 21,303.56 305.57
21,769.59 8 21,303.56 153.34
19,350.75 TOTAL 170428.48 5428.49070884
16,931.91
14,513.07
12,094.23
9,675.39
7,256.55 Nª RENTA INTERES
4,837.71 0
2,418.87 1 10,500.00 1,934.32
0.03 2 10,500.00 1,817.26
3 10,500.00 1,698.59
4 10,500.00 1,578.31
SALDO INSOLUTO 5695.32 5 10,500.00 1,456.38
70000 15.60% 6 10,500.00 1,332.78
66124.68 7 10,500.00 1,207.49
62148.60168 8 10,500.00 1,080.50
58069.14532368 9 10,500.00 951.76
53883.6231020957 10 10,500.00 821.27
49589.2773027502 11 10,500.00 689.00
45183.2785126217 12 10,500.00 554.91
40662.7237539498 13 10,500.00 419.00
36024.6345715525 14 10,500.00 281.22
31265.9550704129 15 10,500.00 141.57
26383.5499022436 TOTAL 10,500.00 - 0.00
21374.202199702
16234.6114568942
10961.3913547735
5551.06752999758
0.08
SALDO INSOLUTO INTERESS
55663.35 18.60%

AMORTIZACION SALDO INSOLUTO

165000
20,107.31 144,892.69
20,253.09 124,639.60
20,399.92 104,239.68
20,547.82 83,691.86
20,696.79 62,995.06
20,846.85 42,148.22
20,997.99 21,150.23
21,150.22 0.01
164999.989291162

saldo insoluto del pago numero 2

AMORTIZACION SALDO INSOLUTO 16.40%

141535.65 r=10500
8,565.68 132,969.97
8,682.74 124,287.23
8,801.41 115,485.82
8,921.69 106,564.13
9,043.62 97,520.50
9,167.22 88,353.28
9,292.51 79,060.78
9,419.50 69,641.27
9,548.24 60,093.04
9,678.73 50,414.31
9,811.00 40,603.30
9,945.09 30,658.22
10,081.00 20,577.21
10,218.78 10,358.43
10,358.43 - 0.00
10,500.00

aciende a 50,414.31
 RENTA INTERES AMORTIZACION
0
1 750,000.00 213,831.05 536,168.95
2 750,000.00 210,068.93 539,931.07
3 750,000.00 206,280.42 543,719.58
4 750,000.00 202,465.32 547,534.68
5 750,000.00 198,623.45 551,376.55
6 750,000.00 194,754.62 555,245.38
7 750,000.00 190,858.65 559,141.35
8 750,000.00 186,935.34 563,064.66
9 750,000.00 182,984.51 567,015.49
10 750,000.00 179,005.95 570,994.05
11 750,000.00 174,999.47 575,000.53
12 750,000.00 170,964.89 579,035.11
13 750,000.00 166,901.99 583,098.01
14 750,000.00 162,810.58 587,189.42
15 750,000.00 158,690.47 591,309.53
16 750,000.00 154,541.45 595,458.55
17 750,000.00 150,363.32 599,636.68
18 750,000.00 146,155.87 603,844.13
19 750,000.00 141,918.89 608,081.11
20 750,000.00 137,652.19 612,347.81
21 750,000.00 133,355.55 616,644.45
22 750,000.00 129,028.76 620,971.24
23 750,000.00 124,671.61 625,328.39
24 750,000.00 120,283.89 629,716.11
25 750,000.00 115,865.38 634,134.62
26 750,000.00 111,415.87 638,584.13
27 750,000.00 106,935.14 643,064.86
28 750,000.00 102,422.97 647,577.03
29 750,000.00 97,879.14 652,120.86
30 750,000.00 93,303.42 656,696.58
31 750,000.00 88,695.60 661,304.40
32 750,000.00 84,055.45 665,944.55
33 750,000.00 79,382.74 670,617.26
34 750,000.00 74,677.24 675,322.76
35 750,000.00 69,938.72 680,061.28
36 750,000.00 65,166.96 684,833.04
37 750,000.00 60,361.72 689,638.28
38 750,000.00 55,522.75 694,477.25
39 750,000.00 50,649.84 699,350.16
40 750,000.00 45,742.73 704,257.27
41 750,000.00 40,801.19 709,198.81
42 750,000.00 35,824.98 714,175.02
43 750,000.00 30,813.85 719,186.15
44 750,000.00 25,767.56 724,232.44
45 750,000.00 20,685.87 729,314.13
46 750,000.00 15,568.51 734,431.49
47 750,000.00 10,415.25 739,584.75
48 750,000.00 5,225.83 744,774.17
SALDO INSOLUTO 750000 Nª renta interes
30,474,734.10 8.42% 0
29,938,565.15 R=30474734,1 1 27200 2,077.96
29,398,634.08 2 27200 1,743.00
28,854,914.50 3 27200 1,403.57
28,307,379.82 4 27200 1,059.62
27,756,003.26 5 27200 711.08
27,200,757.89 6 27200 357.89
26,641,616.54 Nº RENTA INTERES
26,078,551.88 0
25,511,536.39 1 15,750.00 4,940.72
24,940,542.33 2 15,750.00 4,735.34
24,365,541.81 3 15,750.00 4,526.06
23,786,506.69 4 15,750.00 4,312.81
23,203,408.68 5 15,750.00 4,095.50
22,616,219.26 6 15,750.00 3,874.07
22,024,909.74 7 15,750.00 3,648.42
21,429,451.19 8 15,750.00 3,418.49
20,829,814.50 9 15,750.00 3,184.19
20,225,970.37 10 15,750.00 2,945.44
19,617,889.26 11 15,750.00 2,702.16
19,005,541.45 12 15,750.00 2,454.25
18,388,897.00 13 15,750.00 2,201.63
17,767,925.76 14 15,750.00 1,944.21
17,142,597.37 15 15,750.00 1,681.90
16,512,881.26 16 15,750.00 1,414.61
15,878,746.64 17 15,750.00 1,142.23
15,240,162.52 18 15,750.00 864.69
14,597,097.66 19 15,750.00 581.86
13,949,520.63 20 15,750.00 293.67
13,297,399.76 Nº RENTA INTERES
12,640,703.18 0
11,979,398.78 1 10,750.00 3,716.55
11,313,454.23 2 10,750.00 3,591.12
10,642,836.97 3 10,750.00 3,463.45
9,967,514.21 4 10,750.00 3,333.51
9,287,452.93 5 10,750.00 3,201.25
8,602,619.90 6 10,750.00 3,066.63
7,912,981.61 7 10,750.00 2,929.61
7,218,504.37 8 10,750.00 2,790.15
6,519,154.21 9 10,750.00 2,648.20
5,814,896.94 10 10,750.00 2,503.71
5,105,698.13 11 10,750.00 2,356.65
4,391,523.11 12 10,750.00 2,206.97
3,672,336.97 13 10,750.00 2,054.62
2,948,104.53 14 10,750.00 1,899.56
 2,218,790.40 15 10,750.00 1,741.72
1,484,358.91 16 10,750.00 1,581.07
744,774.16 17 10,750.00 1,417.56
- 0.01 18 10,750.00 1,251.13
19 10,750.00 1,081.74
20 10,750.00 909.32
21 10,750.00 733.83
22 10,750.00 555.21
23 10,750.00 373.40
24 10,750.00 188.35
amortizacion saldo insoluto
155,846.88
25,122.04 130,724.84 16%
25,457.00 105,267.84
25,796.43 79,471.41
26,140.38 53,331.02
26,488.92 26,842.11
26,842.11 0.00
AMORTIZACION SALDO INSOLUTO
260,037.75 11.40%
10,809.28 249,228.47
11,014.66 238,213.81
11,223.94 226,989.87
11,437.19 215,552.68
11,654.50 203,898.18
11,875.93 192,022.24
12,101.58 179,920.67
12,331.51 167,589.16
12,565.81 155,023.35
12,804.56 142,218.80
13,047.84 129,170.95
13,295.75 115,875.20
13,548.37 102,326.83
13,805.79 88,521.04
14,068.10 74,452.94
14,335.39 60,117.55
14,607.77 45,509.78
14,885.31 30,624.46
15,168.14 15,456.33
15,456.33 0.00
AMORTIZACION SALDO INSOLUTO
208,404.68 21.40%
7,033.45 201,371.23
7,158.88 194,212.35
7,286.55 186,925.81
7,416.49 179,509.32
7,548.75 171,960.57
7,683.37 164,277.20
7,820.39 156,456.81
7,959.85 148,496.95
8,101.80 140,395.15
8,246.29 132,148.86
8,393.35 123,755.52
8,543.03 115,212.49
8,695.38 106,517.11
8,850.44 97,666.67
 9,008.28 88,658.39
9,168.93 79,489.47
9,332.44 70,157.03
9,498.87 60,658.16
9,668.26 50,989.90
9,840.68 41,149.22
10,016.17 31,133.05
10,194.79 20,938.25
10,376.60 10,561.65
10,561.65 0.00
9 datos Nº R D.A
C= 232,846.00 0
N 9.00 1 9,862.00 9,862.00
C= 144,088.00 2 35,000.00 19,724.00
R= 9,862.00 3 35,000.00 54,724.00
4 35,000.00 89,724.00
5 35,000.00 124,724.00
6 35,000.00 159,724.00
7 35,000.00 194,724.00
8 35,000.00 229,724.00
10 DATOS 9 35,000.00 264,724.00
C= 180,000.00 0
N= 5 1 189,720.00 8,000.00
CN= 189,580.32 2 191,532.88 8,000.00
R= 8,000.00 3 193,443.66 8,000.00
I= 5.40% 4 195,457.61 8,000.00
5 197,580.32 8,000.00

11 DATOS Nº VI R
C= 1,345,000.00 -
N= 10 1 1,459,325.00 130,000.00
CN= 1,112,459.32 2 1,442,317.63 130,000.00
R= 130,000.00 3 1,423,864.62 130,000.00
I= 8.50% 4 1,403,843.12 130,000.00
5 1,382,119.78 130,000.00
6 1,358,549.96 130,000.00
7 1,332,976.71 130,000.00
8 1,305,229.73 130,000.00
9 1,275,124.26 130,000.00
10 1,242,459.82 130,000.00
V.C 12 DATOS Nº R
232,846.00 CN= 129250 0
222,984.00 C= 165000 1 7,150.00
213,122.00 N= 5 2 7,150.00
203,260.00 R= 7150 3 7,150.00
193,398.00 4 7,150.00
183,536.00 5 7,150.00
173,674.00
163,812.00
153,950.00
144,088.00 VL
180,000.00
8,000.00 181,720.00
16,000.00 183,532.88 probelma 19
24,000.00 185,443.66
32,000.00 187,457.61 C
40,000.00 189,580.32 14300 Cn
d
D.A V.L n
1,345,000.00
130,000.00 1,329,325.00 Nro
260,000.00 1,312,317.63 0
390,000.00 1,293,864.62 1
520,000.00 1,273,843.12 2
650,000.00 1,252,119.78 3
780,000.00 1,228,549.96 4
910,000.00 1,202,976.71 5
1,040,000.00 1,175,229.73
1,170,000.00 1,145,124.26
1,300,000.00 1,112,459.82 problema 29

Nro
0
1
2
3
4
5
6
D.A V.C
165,000.00
7,150.00 157,850.00
7,150.00 150,700.00
7,150.00 143,550.00
7,150.00 136,400.00
7,150.00 129,250.00

85000
50000
9%
5
R
[Link] I [Link] D.A V.L.
0 85000.0
5848.24 0 5848.2 5848.2 79151.8
5848.24 526.3 6374.6 12222.8 72777.2
5848.24 1100.1 6948.3 19171.1 65828.9
5848.24 1725.4 7573.6 26744.8 58255.2
5848.24 2407.0 8255.3 35000.0 50000.0

11.4%

[Link] I [Link] D.A V.L.

0 120000.0
9758.32 0 9758.3 9758.3 110241.7
9758.32 1112 10870.8 20629.1 99370.9
9758.32 2352 12110.0 32739.1 87260.9
9758.32 3732 13490.6 46229.7 73770.3
9758.32 5270 15028.5 61258.2 58741.8
9758.32 6983 16741.8 78000.0 42000.0
 AMORTIZACION
Interes 7.20%
n 4

n R C I M
1 1,500,000.00 1,500,000.00 27,000.00 1,527,000.00
2 1,500,000.00 3,027,000.00 54,486.00 3,081,486.00
3 1,500,000.00 4,581,486.00 82,466.75 4,663,952.75
4 1,500,000.00 6,163,952.75 110,951.15 6,274,903.90
5 1,500,000.00 7,774,903.90 139,948.27 7,914,852.17
6 1,500,000.00 9,414,852.17 169,467.34 9,584,319.51
7 1,500,000.00 11,084,319.51 199,517.75 11,283,837.26
8 1,500,000.00 12,783,837.26 230,109.07 13,013,946.33
9 1,500,000.00 14,513,946.33 261,251.03 14,775,197.36
10 1,500,000.00 16,275,197.36 292,953.55 16,568,150.91

1 1,500,000.00 1,500,000.00 27,000.00 1,527,000.00

2 1,500,000.00 3,027,000.00 54,486.00 3,081,486.00
3 1,500,000.00 4,581,486.00 82,466.75 4,663,952.75
4 1,500,000.00 6,163,952.75 110,951.15 6,274,903.90
5 1,500,000.00 7,774,903.90 139,948.27 7,914,852.17
6 1,500,000.00 9,414,852.17 169,467.34 9,584,319.51
7 1,500,000.00 11,084,319.51 199,517.75 11,283,837.26
8 1,500,000.00 12,783,837.26 230,109.07 13,013,946.33
9 1,500,000.00 14,513,946.33 261,251.03 14,775,197.36
10 1,500,000.00 16,275,197.36 292,953.55 16,568,150.91
1,500,000.00

R C I M
1 1,500,000.00
2
3
4
5
6
7
8
9
10