ContratoGurman
Ação
#
00.547593-7
NILTON GURMAN
CES
1,00
74,5000 SEGURO DO IMÓVEL(DF)
SEGURO PESSOAL(MI)
emissão
9/9/1991
TAC
IOF
ACRESCM
24741,95
financiado
ULTMVcto
PRIMVcto
CR$
62.945.988,00
64.230.600,00
9/9/2001
9/10/1991
0,000% ACRESCM devido a TP
0,00 CES*prestação #1
0% TCA
encargo parcial
ACRESCM parcial
SEGURO
encargo total cobrado
ACRESCM total cobrado
MAIS correção pela TR
Página 1
COMPROMETIM
25,5000
prestação#1
QTDE
999.480,38
87%
999.480,38
0,00
999.480,38
87%
73.285,66
1.072.766,04
100%
prestação#2
120
535.255,00
contra
BANCO ITAU S/A
N.º Contrato
100%
RENDA
TOTAL
73.285,66
999.480,38
anual %
nominal
TAXAS
mensal %
nominal
14,057
0,14057
0,0117140
10,000
0,1000
0,00833333
14,999 (((1+J10)^(12))-1)*100
1,1714
0,8333333
1,1714
MULTA
10%
MORA % de acordo com o Banco Central
FUNDHAB SOBRE O SALDO DEVEDOR
7483605
aoDia
0,0003905
0,0002778
1,00
total
1.284.612,00
VARIAÇÃO DO ICPoup Livre NA DATA BASE
0,759370219
ATUALIZAÇÃO DO SALDO DEVEDOR:
Cálculo pela Fórmula da Tabela Price, Taxa mensal, calculada
linha
2
3
4
5 fator TP
capital
PAGTO
Coluna E
(1+tx/100)^(F10)
(tx/100)*E2
E2(-)1
E3/E4
64.230.600,00
fator*capital
4,045117779
0,04738451
3,045117779
0,015560813
999.480,38
999.480,38
Cálculo pela Fórmula da Tabela Price, Taxa nominal anual de 10%ªa, legal
linha
2
3
4
5 fator TP
capital
PAGTO
Coluna E
(1+tx/100)^(F10)
(tx/100)*E2
E2(-)1
E3/E4
64.230.600,00
fator*capital
88.026,76
10.563.211,14
2,707041491
0,022558679
1,707041491
0,013215074
seguro
848.812,11
848.812,11
0,07332376
62.238,10
Cálculo pela Fórmula de Juros Simples, Linear, Taxa Price
120
Juros totais
45.143.834,90
376.198,62
juro
mensal
376.198,62
70%
911.453,62
prestação
911.453,62
Principal mais
Juros totais
109.374.434,90
0,01171400
Juros totais
45.143.834,90
911.453,62
amortização
Principal
64.230.600,00
70%
109.374.434,90
seguro
535.255,00
911.453,62
0,07332376
66.831,21
Cálculo pela Fórmula de Juros Simples, Linear, Taxa price
120
Juros totais
32.115.300,00
juro
mensal
267.627,50
50%
802.882,50
prestação
802.882,50
Principal mais
Juros totais
96.345.900,00
0,00833333
Juros totais
32.115.300,00
50%
amortização
Principal
64.230.600,00
535.255,00
802.882,50
0,07332376
58.870,36
ÍNDICES DE POUPANÇA
Taxas utilizadas
Contratada
lei4380
Taxa efetiva
0,000333333
total%
2%
ResumoLinear
# 100 último pgto efetuado
9/1/2000
9/1/2000
Saldo Devedor Saldo Devedor(-)
Saldo Devedor Saldo Devedor(-)
#
Vcto.
(-)Amortização Amortização(+)
(-)Amortização
Amortização(+)
Encargo(-)Pagto
Encargo(-)Pagto
BANCaudit
BANCauditLinear
0
9/9/1991
64.230.600,00
64.230.600,00
64.230.600,00
64.230.600,00
64
9/1/1997
120.300,75
97.737,86
164.090,27
164.151,05
80
9/5/1998
143.722,44
143.857,17
96.812,90
65.050,80
100
9/1/2000
88.497,11
89.136,09
65.050,80
9.904,54
10INPC
INPC10linear
0
9/9/1991
64.230.600,00
64.230.600,00
64.230.600,00
64.230.600,00
64
9/1/1997
134.074,90
58.073,56
106.148,59
36.750,17
77
9/2/1998
114.359,07
8.891,09
87.630,49
(1.346,13)
80
9/5/1998
109.432,71
81.431,03
(15.555,19)
(4.509,35)
100
9/1/2000
64.257,39
(115.985,03)
44.158,91
(96.709,48)
Página 2
BANCauditLinear
Ação
#
CES
SEGURO PESSOAL(MI)
0,745
#
0
1
2
3
4
5
6
7
8
9
10
11
12
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Vcto.
9/9/1991
9/10/1991
9/11/1991
9/12/1991
9/1/1992
9/2/1992
9/3/1992
9/4/1992
9/5/1992
9/6/1992
9/7/1992
9/8/1992
9/9/1992
9/10/1992
9/11/1992
9/12/1992
9/1/1993
9/2/1993
9/3/1993
9/4/1993
9/5/1993
9/6/1993
9/7/1993
9/8/1993
9/9/1993
9/10/1993
9/11/1993
9/12/1993
9/1/1994
9/2/1994
9/3/1994
9/4/1994
9/5/1994
9/6/1994
9/7/1994
9/8/1994
9/9/1994
9/10/1994
9/11/1994
9/12/1994
9/1/1995
9/2/1995
9/3/1995
9/4/1995
9/5/1995
9/6/1995
9/7/1995
9/8/1995
9/9/1995
9/10/1995
9/11/1995
9/12/1995
9/1/1996
9/2/1996
9/3/1996
9/4/1996
9/5/1996
9/6/1996
9/7/1996
9/8/1996
9/9/1996
Pagamento
999.521,91
1.349.047,98
1.565.414,71
2.009.893,85
2.560.624,85
3.220.992,06
3.952.659,72
5.008.715,52
6.026.125,87
7.285.327,04
8.799.431,96
10.812.534,23
13.376.708,88
16.978.013,70
20.772.848,20
25.959.170,65
32.175.815,90
41.701.016,71
51.664.270,77
65.213.674,77
83.271.701,64
108.126.766,70
139.881.318,03
180.485,48
241.301,88
332.452,81
445.835,87
608.227,41
834.022,37
1.215.426,51
1.663.829,28
2.382.943,48
3.423.809,09
5.089.421,69
2.515,34
2.623,24
2.672,77
2.738,03
2.809,45
2.898,64
2.960,15
3.031,11
3.079,89
3.172,03
3.269,23
3.378,96
3.470,09
3.574,67
3.654,75
3.720,62
3.778,42
3.835,37
3.878,69
3.929,66
3.960,41
3.986,56
4.013,50
4.035,79
4.061,28
4.084,04
4.106,02
NILTON GURMAN
1,000000
74,500000
49789,25
Fator saldev
TR
1,000000
1,177781
1,238919
1,283509
1,273912
1,258415
1,227156
1,279459
1,191351
1,209129
1,210113
1,229044
1,237585
1,269036
1,223752
1,250604
1,239575
1,295331
1,240057
1,262561
1,277215
1,298800
1,294000
0,001291
1,337300
1,378100
1,341400
1,364600
1,371600
1,457700
1,369300
1,432600
1,437200
1,486900
0,000495
1,040905
1,019407
1,024724
1,026401
1,032063
1,021539
1,024294
1,016418
1,030250
1,030981
1,033906
1,027311
1,030485
1,022753
1,018374
1,015889
1,015432
1,011657
1,013508
1,008193
1,006976
1,007134
1,005932
1,006706
1,005994
1,005779
COMPROMETIM
SEGURO DO IMÓVEL(DF)
saldo devedor
F.Prestação
64.230.600,00
75.359.218,24
92.999.154,74
118.890.902,69
150.845.006,19
189.048.276,11
231.026.631,76
294.385.073,83
349.209.769,55
420.398.122,98
506.475.056,00
619.677.191,59
763.395.345,36
964.266.580,91
1.174.439.267,91
1.461.706.025,00
1.803.045.252,43
2.323.913.449,88
2.867.230.980,03
3.601.463.246,66
4.575.820.332,51
5.911.509.479,94
7.608.168.430,26
9.765.143,60
12.985.922,47
17.794.114,15
23.730.890,40
32.192.466,89
43.890.550,97
63.588.976,57
86.531.715,71
123.181.698,99
175.897.301,96
259.827.624,99
127.854,86
132.179,67
133.811,99
136.153,30
138.743,56
142.143,46
144.121,32
146.499,50
147.749,83
151.015,50
154.438,52
158.351,56
161.311,15
164.805,48
167.082,64
168.635,33
169.755,34
170.772,95
171.123,95
171.754,17
171.446,41
170.897,28
170.336,28
169.534,99
168.826,66
167.960,57
167.020,21
1,177084
1,239653
1,283937
1,274010
1,257893
1,227156
1,267176
1,203128
1,208957
1,210055
1,229044
1,237421
1,269505
1,223791
1,249954
1,239764
1,296339
1,239215
1,262561
1,277215
1,298800
1,294000
0,001291
1,337300
1,378100
1,341400
1,364600
1,371600
1,457700
1,369300
1,432600
1,437200
1,486900
0,000494
1,043203
1,019810
1,024724
1,026401
1,032063
1,021539
1,024294
1,016418
1,030250
1,030981
1,033908
1,027311
1,030485
1,022753
1,018374
1,015889
1,015432
1,011657
1,013508
1,008193
1,006976
1,007134
1,005932
1,006706
1,005994
1,005779
F. seguro
1,459175
1,283937
1,274010
1,257893
1,227156
1,267176
1,203128
1,208957
1,177475
1,225026
1,233314
1,265230
1,219602
1,245610
1,235398
1,291702
1,234702
1,257903
1,272430
1,293858
1,289000
0,001286
1,331969
1,372520
1,335883
1,358898
1,365777
1,451413
1,363299
1,426220
1,430696
1,480061
0,000492
1,038216
1,014259
1,020313
1,020455
1,026945
1,016218
1,018866
1,010964
1,024624
1,025220
0,975400
1,076578
1,024480
1,016648
1,012233
1,009659
1,009048
1,005184
1,006923
1,001523
1,009399
0,991100
0,998941
0,999493
0,998708
0,998291
contra
BANCO ITAU S/A
100%
RENDA
25,5000
0,001040489
seguro
78.665,94
66.831,21
172.526,74
106.936,63
137.299,88
174.921,41
220.032,41
270.014,08
342.155,35
411.656,67
497.675,20
585.999,92
717.864,87
885.353,03
1.120.175,00
1.366.167,92
1.701.713,01
2.102.293,19
2.715.536,36
3.352.878,74
4.217.595,34
5.366.594,06
6.943.612,98
8.950.317,12
11.505,94
15.325,55
21.034,63
28.099,80
38.184,77
52.151,89
75.693,92
103.193,45
147.176,59
210.564,92
311.648,94
153,34
159,20
161,47
164,75
168,12
172,65
175,45
178,76
180,72
185,17
189,84
185,17
199,35
204,23
207,63
210,17
212,20
214,12
215,23
216,72
217,05
219,09
217,14
216,91
216,80
216,52
216,15
Prestação
911.453,62
1.072.857,48
1.329.970,99
1.707.598,96
2.175.498,16
2.736.543,90
3.358.166,27
4.255.387,70
5.119.776,09
6.189.589,15
7.489.743,29
9.205.224,06
11.390.737,56
14.460.598,28
17.696.750,03
22.120.123,49
27.423.732,78
35.550.454,33
44.054.656,26
55.621.690,86
71.040.857,90
92.267.866,24
119.394.618,91
154.090,70
206.065,49
283.978,85
380.929,23
519.816,02
712.979,65
1.039.310,44
1.423.127,79
2.038.772,87
2.930.124,37
4.356.801,93
2.153,89
2.246,94
2.291,45
2.348,11
2.410,10
2.487,37
2.540,95
2.602,68
2.645,41
2.725,43
2.809,87
2.905,15
2.984,49
3.075,47
3.145,45
3.203,24
3.254,14
3.304,36
3.342,88
3.388,03
3.415,79
3.439,62
3.464,16
3.484,71
3.508,08
3.529,10
3.549,50
N.º Contrato
106936,63 TOTAL
3648904803,56
JurosN
Amortizações
0,011714
535.255,00
629.777,89
781.031,27
1.003.029,89
1.277.939,15
1.607.042,19
1.972.091,47
2.481.961,82
3.007.003,40
3.634.974,41
4.398.370,79
5.405.791,23
6.688.616,48
8.493.437,36
10.394.424,92
12.987.806,49
16.103.540,94
20.887.058,91
25.871.210,13
32.663.980,93
41.718.926,41
54.184.541,62
70.114.796,85
90.490,16
121.012,49
166.767,31
223.701,67
305.263,29
418.699,13
610.337,73
835.735,45
1.197.274,61
1.720.723,07
2.558.543,13
1.263,10
1.319,71
1.346,23
1.379,51
1.415,93
1.461,33
1.492,81
1.529,07
1.554,18
1.601,19
1.650,80
1.706,78
1.753,39
1.806,84
1.847,95
1.881,91
1.911,81
1.941,31
1.963,94
1.990,47
2.006,78
2.020,78
2.035,20
2.047,27
2.061,00
2.073,35
2.085,33
(376.198,62)
(443.079,59)
(548.939,72)
(704.569,08)
(897.559,00)
(1.129.501,71)
(1.386.074,80)
(1.773.425,88)
(2.112.772,70)
(2.554.614,74)
(3.091.372,50)
(3.799.432,83)
(4.702.121,08)
(5.967.160,92)
(7.302.325,11)
(9.132.317,00)
(11.320.191,84)
(14.663.395,42)
(18.183.446,13)
(22.957.709,93)
(29.321.931,49)
(38.083.324,62)
(49.279.822,06)
(63.600,54)
(85.053,00)
(117.211,54)
(157.227,56)
(214.552,73)
(294.280,52)
(428.972,71)
(587.392,34)
(841.498,26)
(1.209.401,30)
(1.798.258,80)
(890,79)
(927,23)
(945,22)
(968,59)
(994,17)
(1.026,04)
(1.048,14)
(1.073,61)
(1.091,23)
(1.124,24)
(1.159,07)
(1.198,37)
(1.231,10)
(1.268,63)
(1.297,50)
(1.321,34)
(1.342,33)
(1.363,05)
(1.378,93)
(1.397,56)
(1.409,01)
(1.418,84)
(1.428,96)
(1.437,44)
(1.447,08)
(1.455,75)
(1.464,16)
Página 3
7483605
9/10/1991
9/9/2001
73.285,66
Juros P
0,011714
Encargo
(376.198,62)
978.284,83
(443.079,59)
1.245.384,22
(548.939,72)
1.436.907,62
(704.569,08)
1.844.898,84
(897.559,00)
2.350.419,57
(1.129.501,71)
2.956.576,31
(1.386.074,80)
3.628.180,35
(1.773.425,88)
4.597.543,05
(2.112.772,70)
5.531.432,76
(2.554.614,74)
6.687.264,35
(3.091.372,50)
8.075.743,21
(3.799.432,83)
9.923.088,93
(4.702.121,08) 12.276.090,59
(5.967.160,92) 15.580.773,28
(7.302.325,11) 19.062.917,95
(9.132.317,00) 23.821.836,50
(11.320.191,84) 29.526.025,97
(14.663.395,42) 38.265.990,69
(18.183.446,13) 47.407.535,00
(22.957.709,93) 59.839.286,20
(29.321.931,49) 76.407.451,96
(38.083.324,62) 99.211.479,22
(49.279.822,06) 128.344.936,03
(63.600,54)
165.596,64
(85.053,00)
221.391,04
(117.211,54)
305.013,48
(157.227,56)
409.029,03
(214.552,73)
558.000,79
(294.280,52)
765.131,54
(428.972,71)
1.115.004,36
(587.392,34)
1.526.321,24
(841.498,26)
2.185.949,46
(1.209.401,30)
3.140.689,29
(1.798.258,80)
4.668.450,87
(890,79)
2.307,23
(927,23)
2.406,14
(945,22)
2.452,92
(968,59)
2.512,86
(994,17)
2.578,22
(1.026,04)
2.660,02
(1.048,14)
2.716,40
(1.073,61)
2.781,44
(1.091,23)
2.826,13
(1.124,24)
2.910,60
(1.159,07)
2.999,71
(1.198,37)
3.090,32
(1.231,10)
3.183,84
(1.268,63)
3.279,70
(1.297,50)
3.353,08
(1.321,34)
3.413,41
(1.342,33)
3.466,34
(1.363,05)
3.518,48
(1.378,93)
3.558,11
(1.397,56)
3.604,75
(1.409,01)
3.632,84
(1.418,84)
3.658,71
(1.428,96)
3.681,30
(1.437,44)
3.701,62
(1.447,08)
3.724,88
(1.455,75)
3.745,62
(1.464,16)
3.765,65
Saldo Devedor
64.230.600,00
75.649.580,30
92.943.458,59
118.291.304,93
149.414.941,03
186.417.825,22
226.791.661,26
287.647.421,94
339.732.156,09
407.144.147,15
488.291.695,55
594.726.187,44
729.334.082,54
917.063.111,67
1.111.863.956,08
1.377.502.201,54
1.691.417.931,24
2.170.086.664,51
2.665.130.015,32
3.332.225.236,34
4.214.249.128,82
5.419.282.226,90
6.942.436.404,76
8.869.418,27
11.740.060,56
16.012.210,15
21.255.077,03
28.699.414,82
38.945.418,24
56.160.398,43
76.064.698,12
107.773.011,92
153.170.649,67
225.190.895,86
110.283,97
113.480,38
114.337,37
115.784,73
117.425,63
119.729,31
120.815,36
122.221,37
122.673,82
124.783,51
126.998,63
129.597,87
131.383,93
133.582,33
134.773,77
135.368,20
135.607,25
135.758,63
135.377,22
135.215,43
134.316,47
133.232,68
132.147,97
130.884,60
129.701,32
128.405,40
127.062,12
Saldo Devedor(-)
(-)Amortização
64.230.600,00
75.019.802,41
92.162.427,32
117.288.275,04
148.137.001,88
184.810.783,03
224.819.569,79
285.165.460,13
336.725.152,69
403.509.172,74
483.893.324,76
589.320.396,21
722.645.466,06
908.569.674,31
1.101.469.531,16
1.364.514.395,05
1.675.314.390,30
2.149.199.605,60
2.639.258.805,19
3.299.561.255,40
4.172.530.202,42
5.365.097.685,28
6.872.321.607,91
8.778.928,11
11.619.048,08
15.845.442,84
21.031.375,36
28.394.151,53
38.526.719,10
55.550.060,71
75.228.962,67
106.575.737,31
151.449.926,60
222.632.352,73
109.020,88
112.160,66
112.991,14
114.405,22
116.009,70
118.267,98
119.322,55
120.692,29
121.119,64
123.182,32
125.347,83
127.891,10
129.630,54
131.775,48
132.925,82
133.486,29
133.695,44
133.817,32
133.413,28
133.224,96
132.309,69
131.211,90
130.112,77
128.837,33
127.640,32
126.332,04
124.976,78
Saldo Devedor PD
64.230.600,00
75.649.580,30
92.815.027,58
117.961.522,57
148.784.638,21
185.360.117,21
225.169.209,16
285.156.402,96
336.274.627,39
402.365.401,16
481.785.149,46
585.839.910,70
717.235.795,58
900.313.225,74
1.089.656.373,91
1.347.590.864,85
1.651.691.200,09
2.115.195.043,07
2.592.801.647,85
3.235.531.871,81
4.083.886.663,56
5.241.052.169,53
6.700.270.328,52
8.541.989,87
11.282.279,72
15.353.903,24
20.335.217,02
27.393.947,23
37.085.948,06
53.349.426,60
72.078.126,34
101.864.855,17
144.396.326,98
211.723.384,62
103.404,12
106.102,48
106.594,98
107.625,64
108.820,01
110.609,13
111.254,98
112.179,06
112.212,87
113.744,68
115.348,28
117.273,85
118.426,80
119.935,22
120.514,47
120.539,69
120.231,04
119.828,24
118.940,55
118.231,81
116.866,14
115.330,76
113.788,15
112.081,70
110.435,91
108.686,09
106.888,48
Saldo Devedor(-)
Amortização(+)
Encargo(-)Pagto
64.230.600,00
74.916.138,65
91.905.489,23
116.793.497,68
147.296.493,78
183.488.659,28
222.872.638,33
282.263.268,67
332.772.930,89
398.132.364,05
476.663.089,93
579.544.674,17
709.446.560,80
890.422.547,96
1.077.552.018,75
1.332.465.724,21
1.632.937.869,22
2.090.872.958,14
2.562.673.701,95
3.197.493.502,32
4.035.303.487,47
5.177.952.340,43
6.618.619.149,67
8.436.610,87
11.141.356,39
15.159.696,60
20.074.708,51
27.038.457,32
36.598.358,10
52.638.666,72
71.104.882,85
100.470.586,54
142.392.484,11
208.743.870,67
101.932,91
104.565,67
105.028,90
106.020,95
107.172,85
108.909,18
109.518,42
110.400,31
110.404,93
111.882,06
113.427,96
115.278,43
116.387,16
117.833,41
118.364,85
118.350,57
118.007,15
117.570,04
116.656,02
115.916,43
114.531,79
112.982,13
111.420,75
109.700,26
108.038,50
106.274,32
104.462,77
BANCauditLinear
#
Vcto.
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
9/10/1996
9/11/1996
9/12/1996
9/1/1997
9/2/1997
9/3/1997
9/4/1997
9/5/1997
9/6/1997
9/7/1997
9/8/1997
9/9/1997
9/10/1997
9/11/1997
9/12/1997
9/1/1998
9/2/1998
9/3/1998
9/4/1998
9/5/1998
9/6/1998
9/7/1998
9/8/1998
9/9/1998
9/10/1998
9/11/1998
9/12/1998
9/1/1999
9/2/1999
9/3/1999
9/4/1999
9/5/1999
9/6/1999
9/7/1999
9/8/1999
9/9/1999
9/10/1999
9/11/1999
9/12/1999
9/1/2000
9/2/2000
9/3/2000
9/4/2000
9/5/2000
9/6/2000
9/7/2000
9/8/2000
9/9/2000
9/10/2000
9/11/2000
9/12/2000
9/1/2001
9/2/2001
9/3/2001
9/4/2001
9/5/2001
9/6/2001
9/7/2001
9/8/2001
9/9/2001
Pagamento
4.117,46
4.150,56
4.180,33
4.220,44
4.253,35
4.279,69
4.305,85
4.329,10
4.354,24
4.381,43
4.408,56
4.434,23
4.459,10
4.457,24
4.527,46
4.575,79
4.630,54
4.647,76
4.682,67
4.695,98
4.718,84
4.738,14
4.757,56
4.772,77
4.821,74
4.852,20
4.881,88
4.909,36
4.938,76
4.972,49
5.017,40
5.041,52
5.062,39
5.082,61
5.093,28
5.105,37
5.115,90
5.120,35
5.127,92
5.139,35
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
Fator saldev
TR
1,006462
1,008408
1,007546
1,008647
1,008189
1,006585
1,006512
1,005801
1,006215
1,006658
1,006611
1,006245
1,006037
1,006218
1,016202
1,011122
1,012420
1,004174
1,007974
1,003312
1,005340
1,004569
1,004584
1,003686
1,010762
1,006820
1,006627
1,006145
1,006512
1,007361
1,009565
1,005349
1,004687
1,003322
1,002679
1,002970
1,002664
1,001477
1,002094
1,002853
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
saldo devedor
166.153,61
165.565,41
164.791,13
164.151,05
163.388,95
162.319,84
161.192,58
159.904,97
158.636,09
157.387,86
156.081,51
154.667,08
153.169,09
151.645,99
151.557,02
150.638,29
149.841,53
147.758,14
146.174,70
143.857,17
141.777,03
139.531,39
137.231,76
134.754,65
133.155,00
130.957,70
128.664,24
126.238,31
123.786,36
121.362,13
119.117,15
116.291,95
113.319,61
110.121,65
106.793,16
103.436,02
99.986,91
96.363,58
92.744,97
89.136,09
85.620,54
82.063,80
78.465,40
74.824,84
71.141,65
67.415,30
63.645,31
59.831,15
55.972,32
52.068,28
48.118,51
44.122,48
40.079,63
35.989,42
31.851,31
27.664,72
23.429,09
19.143,84
14.808,39
10.422,16
F.Prestação
F. seguro
1,006462
1,008408
1,007546
1,008647
1,008189
1,006585
1,006512
1,005801
1,006215
1,006658
1,006611
1,006245
1,006037
1,006218
1,016202
1,011122
1,012420
1,004174
1,007974
1,003312
1,005340
1,004569
1,004584
1,003686
1,010762
1,006820
1,006627
1,006145
1,006512
1,007361
1,009565
1,005349
1,004687
1,003322
1,002679
1,002970
1,002664
1,001477
1,002094
1,002853
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
0,936664
1,000938
0,999901
1,028229
1,000288
0,998609
0,998318
0,997497
0,997732
0,997969
0,997722
0,997232
0,996834
0,861680
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
seguro
78.665,94
202,46
202,65
202,63
208,35
208,41
208,12
207,77
207,25
206,78
206,36
205,89
205,32
204,67
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
176,36
Prestação
3.572,43
3.602,47
3.629,66
3.661,04
3.691,02
3.715,33
3.739,52
3.761,21
3.784,59
3.809,79
3.834,97
3.858,92
3.882,22
3.906,36
3.969,65
4.013,80
4.063,65
4.080,61
4.113,15
4.126,78
4.148,81
4.167,77
4.186,87
4.202,31
4.247,53
4.276,50
4.304,84
4.331,29
4.359,50
4.391,59
4.433,59
4.457,31
4.478,20
4.493,08
4.505,12
4.518,50
4.530,53
4.537,22
4.546,73
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
4.559,70
Página 4
Amortizações
JurosN
0,011714
Juros P
0,011714
2.098,81
2.116,45
2.132,43
2.150,86
2.168,48
2.182,76
2.196,97
2.209,72
2.223,45
2.238,25
2.253,05
2.267,12
2.280,81
2.294,99
2.332,17
2.358,11
2.387,40
2.397,36
2.416,48
2.424,48
2.437,43
2.448,57
2.459,79
2.468,86
2.495,43
2.512,45
2.529,10
2.544,64
2.561,21
2.580,06
2.604,74
2.618,67
2.630,95
2.639,69
2.646,76
2.654,62
2.661,69
2.665,62
2.671,20
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
2.678,83
(1.473,63)
(1.486,02)
(1.497,23)
(1.510,18)
(1.522,54)
(1.532,57)
(1.542,55)
(1.551,50)
(1.561,14)
(1.571,53)
(1.581,92)
(1.591,80)
(1.601,41)
(1.611,37)
(1.637,48)
(1.655,69)
(1.676,25)
(1.683,25)
(1.696,67)
(1.702,29)
(1.711,38)
(1.719,20)
(1.727,08)
(1.733,45)
(1.752,10)
(1.764,05)
(1.775,74)
(1.786,66)
(1.798,29)
(1.811,53)
(1.828,85)
(1.838,64)
(1.847,25)
(1.853,39)
(1.858,36)
(1.863,88)
(1.868,84)
(1.871,60)
(1.875,52)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.473,63)
(1.486,02)
(1.497,23)
(1.510,18)
(1.522,54)
(1.532,57)
(1.542,55)
(1.551,50)
(1.561,14)
(1.571,53)
(1.581,92)
(1.591,80)
(1.601,41)
(1.611,37)
(1.637,48)
(1.655,69)
(1.676,25)
(1.683,25)
(1.696,67)
(1.702,29)
(1.711,38)
(1.719,20)
(1.727,08)
(1.733,45)
(1.752,10)
(1.764,05)
(1.775,74)
(1.786,66)
(1.798,29)
(1.811,53)
(1.828,85)
(1.838,64)
(1.847,25)
(1.853,39)
(1.858,36)
(1.863,88)
(1.868,84)
(1.871,60)
(1.875,52)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
(1.880,87)
Encargo
3.774,89
3.805,12
3.832,29
3.869,39
3.899,43
3.923,45
3.947,29
3.968,46
3.991,37
4.016,15
4.040,86
4.064,24
4.086,89
4.082,72
4.146,01
4.190,16
4.240,01
4.256,97
4.289,51
4.303,14
4.325,17
4.344,13
4.363,23
4.378,67
4.423,89
4.452,86
4.481,20
4.507,65
4.535,86
4.567,95
4.609,95
4.633,67
4.654,56
4.669,44
4.681,48
4.694,86
4.706,89
4.713,58
4.723,09
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
4.736,06
Saldo Devedor
125.784,38
124.725,52
123.534,28
122.451,61
121.285,89
119.901,80
118.485,63
116.963,25
115.466,73
113.997,25
112.497,84
110.933,27
109.322,16
107.706,94
107.119,83
105.953,11
104.881,65
102.922,06
101.326,28
99.237,39
97.329,88
95.326,02
93.303,20
91.178,26
89.664,09
87.763,15
85.815,66
83.798,36
81.782,84
79.804,79
77.963,38
75.761,73
73.485,88
71.090,31
68.634,01
66.183,23
63.697,85
61.126,31
58.583,10
56.071,41
53.392,59
50.713,76
48.034,94
45.356,11
42.677,29
39.998,46
37.319,64
34.640,81
31.961,99
29.283,16
26.604,33
23.925,51
21.246,68
18.567,86
15.889,03
13.210,21
10.531,38
7.852,56
5.173,73
2.494,91
Saldo Devedor(-)
(-)Amortização
123.685,58
122.609,07
121.401,85
120.300,75
119.117,41
117.719,05
116.288,66
114.753,53
113.243,28
111.759,00
110.244,79
108.666,14
107.041,35
105.411,95
104.787,66
103.595,00
102.494,25
100.524,69
98.909,80
96.812,90
94.892,45
92.877,45
90.843,41
88.709,40
87.168,66
85.250,70
83.286,56
81.253,72
79.221,64
77.224,72
75.358,64
73.143,06
70.854,93
68.450,63
65.987,25
63.528,61
61.036,16
58.460,69
55.911,90
53.392,59
50.713,76
48.034,94
45.356,11
42.677,29
39.998,46
37.319,64
34.640,81
31.961,99
29.283,16
26.604,33
23.925,51
21.246,68
18.567,86
15.889,03
13.210,21
10.531,38
7.852,56
5.173,73
2.494,91
(183,92)
Saldo Devedor PD
105.137,81
103.559,91
101.860,90
100.239,78
98.538,24
96.648,11
94.721,94
92.701,07
90.690,88
88.691,16
86.656,75
84.560,81
82.418,28
80.261,24
78.848,87
76.982,03
75.160,32
72.684,52
70.453,73
67.868,13
65.398,17
62.852,94
60.285,45
57.643,02
55.369,60
52.834,22
50.253,26
47.614,29
44.958,82
42.303,84
39.695,32
36.879,35
34.011,50
31.075,62
28.097,83
25.113,63
22.107,24
19.064,65
16.025,75
12.986,66
9.904,54
7.225,72
4.546,89
1.868,06
(810,76)
(3.489,59)
(6.168,41)
(8.847,24)
(11.526,06)
(14.204,89)
(16.883,71)
(19.562,54)
(22.241,36)
(24.920,19)
(27.599,02)
(30.277,84)
(32.956,67)
(35.635,49)
(38.314,32)
(40.993,14)
Saldo Devedor(-)
Amortização(+)
Encargo(-)Pagto
102.696,44
101.098,02
99.380,43
97.737,86
96.015,84
94.109,11
92.166,41
90.130,72
88.104,56
86.087,63
84.036,01
81.923,70
79.765,26
77.591,73
76.135,25
74.238,29
72.382,40
69.896,37
67.644,09
65.050,80
62.567,07
60.010,36
57.431,33
54.780,06
52.476,33
49.922,43
47.323,49
44.667,95
41.994,71
39.319,23
36.683,14
33.852,83
30.972,72
28.022,76
25.039,27
22.048,50
19.036,54
15.992,27
12.949,71
9.904,54
7.225,72
4.546,89
1.868,06
(810,76)
(3.489,59)
(6.168,41)
(8.847,24)
(11.526,06)
(14.204,89)
(16.883,71)
(19.562,54)
(22.241,36)
(24.920,19)
(27.599,02)
(30.277,84)
(32.956,67)
(35.635,49)
(38.314,32)
(40.993,14)
(43.671,97)
INPC10linear
Ação
#
CES
SEGURO PESSOAL(MI)
NILTON GURMAN
1,00
74,5000
COMPROMETIM
SEGURO DO IMÓVEL(DF)
contra
BANCO ITAU S/A
100%
RENDA
25,5000
Página 5
N.º Contrato
TOTAL
0,00833333
#
0
1
2
3
4
5
6
7
8
9
10
11
12
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
Vcto.
9/9/1991
9/10/1991
9/11/1991
9/12/1991
9/1/1992
9/2/1992
9/3/1992
9/4/1992
9/5/1992
9/6/1992
9/7/1992
9/8/1992
9/9/1992
9/10/1992
9/11/1992
9/12/1992
9/1/1993
9/2/1993
9/3/1993
9/4/1993
9/5/1993
9/6/1993
9/7/1993
9/8/1993
9/9/1993
9/10/1993
9/11/1993
9/12/1993
9/1/1994
9/2/1994
9/3/1994
9/4/1994
9/5/1994
9/6/1994
9/7/1994
9/8/1994
9/9/1994
9/10/1994
9/11/1994
9/12/1994
9/1/1995
9/2/1995
9/3/1995
9/4/1995
9/5/1995
9/6/1995
9/7/1995
9/8/1995
9/9/1995
9/10/1995
9/11/1995
9/12/1995
9/1/1996
9/2/1996
9/3/1996
9/4/1996
9/5/1996
9/6/1996
9/7/1996
9/8/1996
Pagamento
1.349.047,98
1.565.414,71
2.009.893,85
2.560.624,85
3.220.992,06
3.952.659,72
5.008.715,52
6.026.125,87
7.285.327,04
8.799.431,96
10.812.534,23
13.376.708,88
16.978.013,70
20.772.848,20
25.959.170,65
32.175.815,90
41.701.016,71
51.664.270,77
65.213.674,77
83.271.701,64
108.126.766,70
139.881.318,03
180.485,48
241.301,88
332.452,81
445.835,87
608.227,41
834.022,37
1.215.426,51
1.663.829,28
2.382.943,48
3.423.809,09
5.089.421,69
2.515,34
2.623,24
2.672,77
2.738,03
2.809,45
2.898,64
2.960,15
3.031,11
3.079,89
3.172,03
3.269,23
3.378,96
3.470,09
3.574,67
3.654,75
3.720,62
3.778,42
3.835,37
3.878,69
3.929,66
3.960,41
3.986,56
4.013,50
4.035,79
4.061,28
4.084,04
Fator saldev
INPC
1,156200
1,210800
1,264800
1,241500
1,259200
1,244800
1,216200
1,208400
1,245000
1,208500
1,220800
1,223800
1,239800
1,260700
1,228900
1,255800
1,287700
1,247900
1,275800
1,283700
1,267800
1,303700
0,001310
1,333400
1,356300
1,341200
1,360000
1,377300
1,413200
1,405700
1,430800
1,428600
1,427300
0,000539
1,077500
1,018500
1,014000
1,028200
1,029600
1,017000
1,014400
1,010100
1,016200
1,024900
1,021000
1,021800
1,024600
1,010200
1,011700
1,014000
1,015100
1,016500
1,014600
1,007100
1,002900
1,009300
1,012800
1,013300
1,012000
saldo devedor F.Prestação
64.230.600,00
73.705.760,31
88.507.113,18
110.977.060,86
136.506.060,73
170.276.595,22
209.990.884,18
252.785.308,79
302.315.873,10
372.634.244,59
445.752.523,68
538.473.596,48
651.810.015,72
798.770.164,08
995.725.886,43
1.209.252.419,94
1.500.746.971,56
1.909.096.514,31
2.353.243.649,45
2.965.461.469,21
3.759.525.194,97
4.703.496.462,83
6.050.356.378,97
7.821.383,90
10.286.951,03
13.752.904,26
18.175.843,51
24.347.586,48
33.021.251,53
45.899.891,34
63.478.222,24
89.316.795,85
125.406.628,69
175.645.414,35
93.069,66
98.622,89
98.741,41
98.352,47
99.294,33
100.325,44
100.062,01
99.461,25
98.368,31
97.771,61
97.924,44
97.583,82
97.232,12
97.043,61
95.362,44
93.730,38
92.226,67
90.736,08
89.296,04
87.599,19
85.170,27
82.318,51
79.937,37
77.773,69
75.577,69
73.211,89
1,156200
1,210800
1,264800
1,241500
1,259200
1,244800
1,216200
1,208400
1,245000
1,208500
1,220800
1,223800
1,239800
1,260700
1,228900
1,255800
1,287700
1,247900
1,275800
1,283700
1,267800
1,303700
0,001310
1,333400
1,356300
1,341200
1,360000
1,377300
1,413200
1,405700
1,430800
1,428600
1,427300
0,000539
1,077500
1,018500
1,014000
1,028200
1,029600
1,017000
1,014400
1,010100
1,016200
1,024900
1,021000
1,021800
1,024600
1,010200
1,011700
1,014000
1,015100
1,016500
1,014600
1,007100
1,002900
1,009300
1,012800
1,013300
1,012000
F. seguro
1,459175
1,283937
1,274010
1,257893
1,227156
1,267176
1,203128
1,208957
1,177475
1,225026
1,233314
1,265230
1,219602
1,245610
1,235398
1,291702
1,234702
1,257903
1,272430
1,293858
1,289000
0,001286
1,331969
1,372520
1,335883
1,358898
1,365777
1,451413
1,363299
1,426220
1,430696
1,480061
0,000492
1,038216
1,014259
1,020313
1,020455
1,026945
1,016218
1,018866
1,010964
1,024624
1,025220
0,975400
1,076578
1,024480
1,016648
1,012233
1,009659
1,009048
1,005184
1,006923
1,001523
1,009399
0,991100
0,998941
0,999493
0,998708
seguro
68.065,91
58.870,36
172.526,74
85.902,19
110.292,98
140.514,35
176.752,01
216.902,29
274.853,36
330.683,77
399.782,44
470.733,68
576.660,78
711.204,01
899.836,47
1.097.442,56
1.366.985,90
1.688.771,93
2.181.390,11
2.693.367,18
3.387.993,95
4.310.984,51
5.577.803,67
7.189.788,92
9.242,72
12.311,01
16.897,12
22.572,57
30.673,82
41.893,61
60.804,92
82.895,29
118.226,94
169.146,78
250.347,56
123,18
127,89
129,71
132,34
135,05
138,69
140,94
143,60
145,17
148,75
152,50
148,75
160,14
164,06
166,79
168,83
170,46
172,00
172,89
174,09
174,36
175,99
174,43
174,24
174,16
173,93
Prestação
802.882,50
928.292,75
1.123.976,86
1.421.605,93
1.764.923,76
2.222.392,00
2.766.433,56
3.364.536,50
4.065.705,90
5.061.803,85
6.117.189,95
7.467.865,50
9.139.173,79
11.330.747,67
14.284.673,59
17.554.435,37
22.044.859,94
28.387.166,14
35.424.344,63
45.194.378,87
58.016.024,16
73.552.715,43
95.890.675,11
125.626,37
167.510,21
227.194,09
304.712,72
414.409,30
570.765,92
806.606,40
1.133.846,62
1.622.307,74
2.317.628,84
3.307.951,65
1.782,99
1.921,17
1.956,71
1.984,10
2.040,05
2.100,44
2.136,15
2.166,91
2.188,79
2.224,25
2.279,64
2.327,51
2.378,25
2.436,75
2.461,61
2.490,41
2.525,27
2.563,41
2.605,70
2.643,75
2.662,52
2.670,24
2.695,07
2.729,57
2.765,87
2.799,06
Amortizações
535.255,00
618.861,83
749.317,90
947.737,29
1.176.615,84
1.481.594,67
1.844.289,04
2.243.024,33
2.710.470,60
3.374.535,90
4.078.126,64
4.978.577,00
6.092.782,53
7.553.831,78
9.523.115,72
11.702.956,91
14.696.573,29
18.924.777,43
23.616.229,75
30.129.585,92
38.677.349,44
49.035.143,62
63.927.116,74
83.750,92
111.673,47
151.462,73
203.141,81
276.272,86
380.510,62
537.737,60
755.897,75
1.081.538,50
1.545.085,89
2.205.301,10
1.188,66
1.280,78
1.304,47
1.322,74
1.360,04
1.400,29
1.424,10
1.444,61
1.459,20
1.482,83
1.519,76
1.551,67
1.585,50
1.624,50
1.641,07
1.660,27
1.683,52
1.708,94
1.737,14
1.762,50
1.775,01
1.780,16
1.796,71
1.819,71
1.843,91
1.866,04
7483605
62.235,51
0,00833333
Saldo Devedor
Encargo
JurosN
(267.627,50)
(309.430,92)
(374.658,95)
(473.868,64)
(588.307,92)
(740.797,33)
(922.144,52)
(1.121.512,17)
(1.355.235,30)
(1.687.267,95)
(2.039.063,32)
(2.489.288,50)
(3.046.391,26)
(3.776.915,89)
(4.761.557,86)
(5.851.478,46)
(7.348.286,65)
(9.462.388,71)
(11.808.114,88)
(15.064.792,96)
(19.338.674,72)
(24.517.571,81)
(31.963.558,37)
(41.875,46)
(55.836,74)
(75.731,36)
(101.570,91)
(138.136,43)
(190.255,31)
(268.868,80)
(377.948,87)
(540.769,25)
(772.542,95)
(1.102.650,55)
(594,33)
(640,39)
(652,24)
(661,37)
(680,02)
(700,15)
(712,05)
(722,30)
(729,60)
(741,42)
(759,88)
(775,84)
(792,75)
(812,25)
(820,54)
(830,14)
(841,76)
(854,47)
(868,57)
(881,25)
(887,51)
(890,08)
(898,36)
(909,86)
(921,96)
(933,02)
Juros P
(267.627,50)
861.752,86
(309.430,92)
1.100.819,49
(374.658,95)
1.209.879,04
(473.868,64)
1.531.898,91
(588.307,92)
1.905.438,11
(740.797,33)
2.399.144,01
(922.144,52)
2.983.335,85
(1.121.512,17)
3.639.389,86
(1.355.235,30)
4.396.389,67
(1.687.267,95)
5.461.586,29
(2.039.063,32)
6.587.923,63
(2.489.288,50)
8.044.526,28
(3.046.391,26)
9.850.377,80
(3.776.915,89) 12.230.584,14
(4.761.557,86) 15.382.116,15
(5.851.478,46) 18.921.421,27
(7.348.286,65) 23.733.631,86
(9.462.388,71) 30.568.556,25
(11.808.114,88) 38.117.711,81
(15.064.792,96) 48.582.372,82
(19.338.674,72) 62.327.008,67
(24.517.571,81) 79.130.519,10
(31.963.558,37) 103.080.464,02
(41.875,46)
134.869,09
(55.836,74)
179.821,22
(75.731,36)
244.091,21
(101.570,91)
327.285,28
(138.136,43)
445.083,12
(190.255,31)
612.659,53
(268.868,80)
867.411,32
(377.948,87)
1.216.741,91
(540.769,25)
1.740.534,68
(772.542,95)
2.486.775,62
(1.102.650,55)
3.558.299,21
(594,33)
1.906,16
(640,39)
2.049,05
(652,24)
2.086,42
(661,37)
2.116,45
(680,02)
2.175,11
(700,15)
2.239,13
(712,05)
2.277,09
(722,30)
2.310,51
(729,60)
2.333,97
(741,42)
2.373,00
(759,88)
2.432,13
(775,84)
2.476,26
(792,75)
2.538,39
(812,25)
2.600,81
(820,54)
2.628,40
(830,14)
2.659,24
(841,76)
2.695,73
(854,47)
2.735,41
(868,57)
2.778,60
(881,25)
2.817,84
(887,51)
2.836,87
(890,08)
2.846,23
(898,36)
2.869,50
(909,86)
2.903,81
(921,96)
2.940,03
(933,02)
2.972,99
64.230.600,00
74.263.419,72
89.168.830,69
111.832.999,77
137.664.053,38
171.864.981,35
212.093.239,74
255.704.773,84
306.283.178,10
377.948.020,84
452.672.056,55
547.643.469,64
664.113.295,61
815.813.832,12
1.018.973.382,43
1.240.513.432,76
1.543.140.195,56
1.968.176.852,40
2.432.471.664,36
3.073.217.763,48
3.906.412.293,53
4.903.514.362,12
6.328.784.557,16
8.207.589,73
10.832.326,68
14.540.421,95
19.298.472,10
25.969.649,19
35.387.487,22
49.471.859,34
68.786.694,93
97.338.464,60
137.512.644,64
194.066.496,60
103.413,18
110.146,93
110.880,17
111.109,76
112.883,02
114.824,06
115.351,97
115.568,44
115.276,48
115.661,13
117.021,33
117.927,11
118.912,42
120.213,16
119.798,26
119.539,63
119.529,67
119.625,63
119.862,32
119.849,81
118.925,73
117.490,46
116.786,41
116.461,56
116.166,59
115.694,54
Saldo Devedor(-)
(-)Amortização
64.230.600,00
73.644.557,89
88.419.512,79
110.885.262,49
136.487.437,54
170.383.386,68
210.248.950,70
253.461.749,51
303.572.707,50
374.573.484,94
448.593.929,91
542.664.892,64
658.020.513,08
808.260.000,34
1.009.450.266,71
1.228.810.475,84
1.528.443.622,27
1.949.252.074,97
2.408.855.434,61
3.043.088.177,56
3.867.734.944,09
4.854.479.218,50
6.264.857.440,42
8.123.838,82
10.720.653,21
14.388.959,22
19.095.330,29
25.693.376,33
35.006.976,61
48.934.121,74
68.030.797,18
96.256.926,11
135.967.558,74
191.861.195,50
102.224,53
108.866,15
109.575,70
109.787,03
111.522,98
113.423,77
113.927,88
114.123,83
113.817,29
114.178,29
115.501,57
116.375,43
117.326,92
118.588,66
118.157,19
117.879,36
117.846,15
117.916,69
118.125,18
118.087,31
117.150,72
115.710,30
114.989,69
114.641,85
114.322,67
113.828,50
Saldo Devedor
64.230.600,00
74.263.419,72
88.868.275,63
111.003.176,22
136.040.396,72
168.995.461,74
207.498.225,29
248.937.425,57
296.450.821,33
363.677.715,09
433.222.401,35
521.199.521,21
628.363.703,40
767.119.542,43
951.599.406,97
1.151.092.883,70
1.422.007.864,39
1.801.323.749,16
2.210.363.479,42
2.772.569.441,20
3.499.120.439,92
4.360.596.068,36
5.583.179.569,59
7.182.559,84
9.404.726,93
12.520.782,19
16.471.220,68
21.963.358,46
29.644.924,36
41.043.639,54
56.449.941,41
79.047.345,06
110.464.206,05
154.122.832,33
81.058,27
85.403,13
85.093,80
84.367,82
84.747,84
85.202,96
84.556,59
83.636,70
82.294,36
81.386,68
81.074,53
80.370,74
79.614,94
78.994,35
77.175,22
75.379,54
73.675,10
71.979,62
70.312,04
68.459,94
66.051,28
63.335,87
60.977,25
58.779,40
56.570,22
54.248,32
Saldo Devedor(-)
Amortização(+)
Encargo(-)Pagto
64.230.600,00
73.396.329,40
87.763.422,06
109.577.443,99
134.208.594,14
166.692.019,03
204.684.612,38
245.325.075,58
292.110.614,53
358.479.438,44
426.932.766,39
513.452.936,27
618.744.589,79
754.818.281,09
936.685.559,20
1.132.352.177,41
1.398.869.107,06
1.771.266.511,27
2.173.200.690,70
2.725.808.553,33
3.439.498.397,51
4.282.564.677,14
5.482.451.598,84
7.053.192,54
9.231.572,80
12.280.957,86
16.149.528,28
21.523.941,31
29.043.050,91
40.157.886,75
55.246.956,29
77.323.397,77
107.982.086,69
150.386.408,75
79.260,44
83.548,16
83.202,98
82.423,50
82.753,46
83.143,16
82.449,43
81.471,49
80.089,24
79.104,82
78.717,67
77.916,37
77.097,74
76.395,99
74.507,80
72.657,89
70.908,90
69.170,72
67.474,81
65.585,62
63.152,73
60.415,39
58.036,54
55.827,71
53.605,06
51.271,23
INPC10linear
Página 6
0,00833333
#
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
Vcto.
9/9/1996
9/10/1996
9/11/1996
9/12/1996
9/1/1997
9/2/1997
9/3/1997
9/4/1997
9/5/1997
9/6/1997
9/7/1997
9/8/1997
9/9/1997
9/10/1997
9/11/1997
9/12/1997
9/1/1998
9/2/1998
9/3/1998
9/4/1998
9/5/1998
9/6/1998
9/7/1998
9/8/1998
9/9/1998
9/10/1998
9/11/1998
9/12/1998
9/1/1999
9/2/1999
9/3/1999
9/4/1999
9/5/1999
9/6/1999
9/7/1999
9/8/1999
9/9/1999
9/10/1999
9/11/1999
9/12/1999
9/1/2000
9/2/2000
9/3/2000
9/4/2000
9/5/2000
9/6/2000
9/7/2000
9/8/2000
9/9/2000
9/10/2000
9/11/2000
9/12/2000
9/1/2001
9/2/2001
9/3/2001
9/4/2001
9/5/2001
9/6/2001
9/7/2001
9/8/2001
9/9/2001
Pagamento
4.106,02
4.117,46
4.150,56
4.180,33
4.220,44
4.253,35
4.279,69
4.305,85
4.329,10
4.354,24
4.381,43
4.408,56
4.434,23
4.459,10
4.457,24
4.527,46
4.575,79
4.630,54
4.647,76
4.682,67
4.695,98
4.718,84
4.738,14
4.757,56
4.772,77
4.821,74
4.852,20
4.881,88
4.909,36
4.938,76
4.972,49
5.017,40
5.041,52
5.062,39
5.082,61
5.093,28
5.105,37
5.115,90
5.120,35
5.127,92
5.139,35
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
Fator saldev
INPC
1,005000
1,000200
1,003800
1,003400
1,003300
1,008100
1,004500
1,006800
1,006000
1,001100
1,003500
1,001800
0,999700
1,001000
1,002900
1,005700
1,008500
1,005400
1,004900
1,004500
1,007200
1,001500
0,997200
0,995100
0,996900
1,001100
0,998200
1,004200
1,006500
1,012900
1,012800
1,004700
1,000500
1,000700
1,007400
1,005500
1,003900
1,009600
1,009400
1,007400
1,006100
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
saldo devedor
70.258,71
66.903,54
63.729,65
60.461,66
57.113,62
53.970,11
50.552,24
47.181,18
43.697,19
39.921,67
36.179,58
32.303,57
28.293,70
24.263,32
20.220,90
16.119,83
11.958,21
7.634,10
3.229,35
-1.270,09
-5.844,21
-10.478,92
-15.133,13
-19.800,35
-24.534,56
-29.446,30
-34.348,77
-39.520,69
-44.876,74
-50.631,54
-56.537,78
-62.152,60
-67.601,72
-73.133,50
-79.229,59
-85.280,84
-91.290,58
-97.909,25
(104.631,86)
(111.270,77)
(117.880,12)
(122.174,37)
(126.504,41)
(130.870,53)
(135.273,04)
(139.712,23)
(144.188,42)
(148.701,91)
(153.253,01)
(157.842,03)
(162.469,30)
(167.135,13)
(171.839,84)
(176.583,76)
(181.367,21)
(186.190,52)
(191.054,03)
(195.958,06)
(200.902,97)
(205.889,08)
(210.916,74)
F.Prestação
F. seguro
1,005000
1,000200
1,003800
1,003400
1,003300
1,008100
1,004500
1,006800
1,006000
1,001100
1,003500
1,001800
0,999700
1,001000
1,002900
1,005700
1,008500
1,005400
1,004900
1,004500
1,007200
1,001500
0,997200
0,995100
0,996900
1,001100
0,998200
1,004200
1,006500
1,012900
1,012800
1,004700
1,000500
1,000700
1,007400
1,005500
1,003900
1,009600
1,009400
1,007400
1,006100
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
1,0000000
0,998291
0,936664
1,000938
0,999901
1,028229
1,000288
0,998609
0,998318
0,997497
0,997732
0,997969
0,997722
0,997232
0,996834
0,861680
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
1,000000
seguro
68.065,91
173,63
162,64
162,79
162,77
167,37
167,42
167,18
166,90
166,48
166,11
165,77
165,39
164,93
164,41
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
141,67
Prestação
2.813,06
2.813,62
2.824,31
2.833,91
2.843,27
2.866,30
2.879,19
2.898,77
2.916,17
2.919,37
2.929,59
2.934,86
2.933,98
2.936,92
2.945,44
2.962,22
2.987,40
3.003,54
3.018,25
3.031,83
3.053,66
3.058,24
3.049,68
3.034,74
3.025,33
3.028,66
3.023,21
3.035,90
3.055,64
3.095,05
3.134,67
3.149,40
3.150,98
3.153,18
3.176,52
3.193,99
3.206,45
3.237,23
3.267,66
3.291,84
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
3.311,92
0,00833333
Amortizações
1.875,37
1.875,75
1.882,87
1.889,28
1.895,51
1.910,86
1.919,46
1.932,52
1.944,11
1.946,25
1.953,06
1.956,58
1.955,99
1.957,95
1.963,62
1.974,82
1.991,60
2.002,36
2.012,17
2.021,22
2.035,78
2.038,83
2.033,12
2.023,16
2.016,89
2.019,11
2.015,47
2.023,94
2.037,09
2.063,37
2.089,78
2.099,60
2.100,65
2.102,12
2.117,68
2.129,33
2.137,63
2.158,15
2.178,44
2.194,56
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
2.207,95
Saldo Devedor
Encargo
JurosN
(937,69)
(937,87)
(941,44)
(944,64)
(947,76)
(955,43)
(959,73)
(966,26)
(972,06)
(973,12)
(976,53)
(978,29)
(977,99)
(978,97)
(981,81)
(987,41)
(995,80)
(1.001,18)
(1.006,08)
(1.010,61)
(1.017,89)
(1.019,41)
(1.016,56)
(1.011,58)
(1.008,44)
(1.009,55)
(1.007,74)
(1.011,97)
(1.018,55)
(1.031,68)
(1.044,89)
(1.049,80)
(1.050,33)
(1.051,06)
(1.058,84)
(1.064,66)
(1.068,82)
(1.079,08)
(1.089,22)
(1.097,28)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
Juros P
(937,69)
(937,87)
(941,44)
(944,64)
(947,76)
(955,43)
(959,73)
(966,26)
(972,06)
(973,12)
(976,53)
(978,29)
(977,99)
(978,97)
(981,81)
(987,41)
(995,80)
(1.001,18)
(1.006,08)
(1.010,61)
(1.017,89)
(1.019,41)
(1.016,56)
(1.011,58)
(1.008,44)
(1.009,55)
(1.007,74)
(1.011,97)
(1.018,55)
(1.031,68)
(1.044,89)
(1.049,80)
(1.050,33)
(1.051,06)
(1.058,84)
(1.064,66)
(1.068,82)
(1.079,08)
(1.089,22)
(1.097,28)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
(1.103,97)
2.986,69
2.976,26
2.987,10
2.996,69
3.010,63
3.033,71
3.046,38
3.065,67
3.082,65
3.085,48
3.095,36
3.100,26
3.098,92
3.101,33
3.087,11
3.103,89
3.129,07
3.145,20
3.159,92
3.173,50
3.195,33
3.199,91
3.191,35
3.176,41
3.167,00
3.170,33
3.164,88
3.177,57
3.197,31
3.236,72
3.276,34
3.291,07
3.292,65
3.294,85
3.318,19
3.335,66
3.348,12
3.378,90
3.409,33
3.433,51
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
3.453,59
114.397,64
112.544,78
111.089,57
109.578,00
108.044,10
107.008,39
105.570,47
104.355,83
103.037,86
101.204,95
99.606,10
97.828,82
95.843,48
93.981,38
92.290,30
90.841,54
89.622,09
88.103,69
86.523,23
84.891,37
83.466,81
81.553,18
79.291,71
76.880,02
74.624,81
72.687,79
70.541,48
68.813,82
67.224,02
66.027,84
64.783,21
62.988,09
60.918,93
58.859,45
57.177,33
55.362,48
53.440,76
51.795,64
50.104,08
48.280,30
46.366,86
44.158,91
41.950,97
39.743,02
37.535,08
35.327,13
33.119,19
30.911,24
28.703,29
26.495,35
24.287,40
22.079,46
19.871,51
17.663,57
15.455,62
13.247,67
11.039,73
8.831,78
6.623,84
4.415,89
2.207,95
Saldo Devedor(-)
(-)Amortização
112.522,27
110.669,03
109.206,70
107.688,73
106.148,59
105.097,53
103.651,00
102.423,32
101.093,75
99.258,70
97.653,04
95.872,24
93.887,49
92.023,43
90.326,68
88.866,72
87.630,49
86.101,34
84.511,07
82.870,14
81.431,03
79.514,35
77.258,59
74.856,86
72.607,92
70.668,68
68.526,01
66.789,88
65.186,92
63.964,47
62.693,43
60.888,49
58.818,28
56.757,33
55.059,65
53.233,15
51.303,13
49.637,49
47.925,65
46.085,74
44.158,91
41.950,97
39.743,02
37.535,08
35.327,13
33.119,19
30.911,24
28.703,29
26.495,35
24.287,40
22.079,46
19.871,51
17.663,57
15.455,62
13.247,67
11.039,73
8.831,78
6.623,84
4.415,89
2.207,95
(0,00)
Saldo Devedor
51.527,58
48.542,59
45.698,64
42.797,32
39.855,49
37.047,85
34.069,98
31.127,44
28.122,47
24.959,34
21.820,43
18.614,75
15.345,27
12.066,02
8.775,68
5.472,94
2.092,19
(1.353,40)
(4.864,81)
(8.402,46)
(12.018,76)
(15.578,52)
(19.082,69)
(22.551,56)
(26.074,78)
(29.730,11)
(33.340,50)
(37.198,88)
(41.193,15)
(45.522,05)
(49.918,33)
(53.956,67)
(57.811,49)
(61.704,18)
(66.059,08)
(70.325,86)
(74.502,24)
(79.149,73)
(83.825,51)
(88.364,06)
(92.815,78)
(96.709,48)
(98.917,43)
(101.125,37)
(103.333,32)
(105.541,27)
(107.749,21)
(109.957,16)
(112.165,10)
(114.373,05)
(116.580,99)
(118.788,94)
(120.996,89)
(123.204,83)
(125.412,78)
(127.620,72)
(129.828,67)
(132.036,61)
(134.244,56)
(136.452,51)
(138.660,45)
Saldo Devedor(-)
Amortização(+)
Encargo(-)Pagto
48.532,88
45.525,64
42.652,30
39.724,40
36.750,17
33.917,35
30.917,20
27.954,75
24.931,91
21.744,33
18.581,30
15.349,87
12.053,96
8.750,30
5.441,92
2.074,56
(1.346,13)
(4.841,09)
(8.364,82)
(11.932,85)
(15.555,19)
(19.136,27)
(22.662,60)
(26.155,87)
(29.697,44)
(33.400,62)
(37.043,30)
(40.927,12)
(44.942,29)
(49.287,45)
(53.704,26)
(57.782,60)
(61.661,02)
(65.573,84)
(69.941,18)
(74.212,81)
(78.397,12)
(83.044,89)
(87.714,97)
(92.253,03)
(96.709,48)
(98.917,43)
(101.125,37)
(103.333,32)
(105.541,27)
(107.749,21)
(109.957,16)
(112.165,10)
(114.373,05)
(116.580,99)
(118.788,94)
(120.996,89)
(123.204,83)
(125.412,78)
(127.620,72)
(129.828,67)
(132.036,61)
(134.244,56)
(136.452,51)
(138.660,45)
(140.868,40)
Download

Veja a planilha de cálculos sobre o questionamento do laudo pericial