ABCDEFGHIKLMNOPQRSTUVWXYZ
1
*Clique em ARQUIVO > BAIXAR > MICROSOFT EXCEL (.xlsx)
2
3
* PREENCHER APENAS AS CÉLULAS AMARELAS
4
Financiamento Prazo (meses)
Taxa Anual (C.E.T.)
Taxa MensalPrestação Máxima Renda Mínima
5
 R$ 100.000,00 3608%0,6434% R$ 715,00 R$ 2.400,00
6
7
ParcSaldo Inicial Juros Saldo Atualizado Amortização Prestação Saldo Devedor
8
1 100.000,00 643,40 100.643,40 70,99 714,40 99.929,01
9
2 99.929,01 642,95 100.571,95 71,45 714,40 99.857,55
10
3 99.857,55 642,49 100.500,04 71,91 714,40 99.785,64
11
4 99.785,64 642,02 100.427,67 72,37 714,40 99.713,27
12
5 99.713,27 641,56 100.354,83 72,84 714,40 99.640,43
13
6 99.640,43 641,09 100.281,52 73,31 714,40 99.567,12
14
7 99.567,12 640,62 100.207,74 73,78 714,40 99.493,34
15
8 99.493,34 640,14 100.133,48 74,25 714,40 99.419,08
16
9 99.419,08 639,67 100.058,75 74,73 714,40 99.344,35
17
10 99.344,35 639,18 99.983,54 75,21 714,40 99.269,14
18
11 99.269,14 638,70 99.907,84 75,70 714,40 99.193,44
19
12 99.193,44 638,21 99.831,65 76,18 714,40 99.117,26
20
13 99.117,26 637,72 99.754,98 76,67 714,40 99.040,58
21
14 99.040,58 637,23 99.677,81 77,17 714,40 98.963,41
22
15 98.963,41 636,73 99.600,15 77,66 714,40 98.885,75
23
16 98.885,75 636,23 99.521,98 78,16 714,40 98.807,59
24
17 98.807,59 635,73 99.443,32 78,67 714,40 98.728,92
25
18 98.728,92 635,22 99.364,14 79,17 714,40 98.649,75
26
19 98.649,75 634,72 99.284,46 79,68 714,40 98.570,06
27
20 98.570,06 634,20 99.204,27 80,20 714,40 98.489,87
28
21 98.489,87 633,69 99.123,55 80,71 714,40 98.409,16
29
22 98.409,16 633,17 99.042,32 81,23 714,40 98.327,93
30
23 98.327,93 632,64 98.960,57 81,75 714,40 98.246,17
31
24 98.246,17 632,12 98.878,29 82,28 714,40 98.163,89
32
25 98.163,89 631,59 98.795,48 82,81 714,40 98.081,09
33
26 98.081,09 631,06 98.712,14 83,34 714,40 97.997,74
34
27 97.997,74 630,52 98.628,26 83,88 714,40 97.913,87
35
28 97.913,87 629,98 98.543,85 84,42 714,40 97.829,45
36
29 97.829,45 629,44 98.458,89 84,96 714,40 97.744,49
37
30 97.744,49 628,89 98.373,38 85,51 714,40 97.658,98
38
31 97.658,98 628,34 98.287,32 86,06 714,40 97.572,92
39
32 97.572,92 627,79 98.200,71 86,61 714,40 97.486,31
40
33 97.486,31 627,23 98.113,54 87,17 714,40 97.399,15
41
34 97.399,15 626,67 98.025,81 87,73 714,40 97.311,42
42
35 97.311,42 626,10 97.937,52 88,29 714,40 97.223,12
43
36 97.223,12 625,54 97.848,66 88,86 714,40 97.134,26
44
37 97.134,26 624,96 97.759,23 89,43 714,40 97.044,83
45
38 97.044,83 624,39 97.669,22 90,01 714,40 96.954,82
46
39 96.954,82 623,81 97.578,63 90,59 714,40 96.864,23
47
40 96.864,23 623,23 97.487,46 91,17 714,40 96.773,06
48
41 96.773,06 622,64 97.395,70 91,76 714,40 96.681,30
49
42 96.681,30 622,05 97.303,36 92,35 714,40 96.588,96
50
43 96.588,96 621,46 97.210,41 92,94 714,40 96.496,02
51
44 96.496,02 620,86 97.116,87 93,54 714,40 96.402,48
52
45 96.402,48 620,26 97.022,73 94,14 714,40 96.308,33
53
46 96.308,33 619,65 96.927,98 94,75 714,40 96.213,59
54
47 96.213,59 619,04 96.832,63 95,36 714,40 96.118,23
55
48 96.118,23 618,43 96.736,66 95,97 714,40 96.022,26
56
49 96.022,26 617,81 96.640,07 96,59 714,40 95.925,67
57
50 95.925,67 617,19 96.542,86 97,21 714,40 95.828,46
58
51 95.828,46 616,56 96.445,03 97,83 714,40 95.730,63
59
52 95.730,63 615,93 96.346,56 98,46 714,40 95.632,16
60
53 95.632,16 615,30 96.247,46 99,10 714,40 95.533,07
61
54 95.533,07 614,66 96.147,73 99,74 714,40 95.433,33
62
55 95.433,33 614,02 96.047,35 100,38 714,40 95.332,95
63
56 95.332,95 613,38 95.946,33 101,02 714,40 95.231,93
64
57 95.231,93 612,73 95.844,66 101,67 714,40 95.130,26
65
58 95.130,26 612,07 95.742,33 102,33 714,40 95.027,93
66
59 95.027,93 611,41 95.639,34 102,99 714,40 94.924,95
67
60 94.924,95 610,75 95.535,70 103,65 714,40 94.821,30
68
61 94.821,30 610,08 95.431,38 104,31 714,40 94.716,98
69
62 94.716,98 609,41 95.326,39 104,99 714,40 94.612,00
70
63 94.612,00 608,74 95.220,73 105,66 714,40 94.506,33
71
64 94.506,33 608,06 95.114,39 106,34 714,40 94.399,99
72
65 94.399,99 607,37 95.007,37 107,03 714,40 94.292,97
73
66 94.292,97 606,68 94.899,65 107,71 714,40 94.185,25
74
67 94.185,25 605,99 94.791,24 108,41 714,40 94.076,85
75
68 94.076,85 605,29 94.682,14 109,10 714,40 93.967,74
76
69 93.967,74 604,59 94.572,33 109,81 714,40 93.857,93
77
70 93.857,93 603,88 94.461,82 110,51 714,40 93.747,42
78
71 93.747,42 603,17 94.350,60 111,22 714,40 93.636,20
79
72 93.636,20 602,46 94.238,66 111,94 714,40 93.524,26
80
73 93.524,26 601,74 94.126,00 112,66 714,40 93.411,60
81
74 93.411,60 601,01 94.012,61 113,38 714,40 93.298,21
82
75 93.298,21 600,28 93.898,50 114,11 714,40 93.184,10
83
76 93.184,10 599,55 93.783,65 114,85 714,40 93.069,25
84
77 93.069,25 598,81 93.668,06 115,59 714,40 92.953,66
85
78 92.953,66 598,07 93.551,73 116,33 714,40 92.837,33
86
79 92.837,33 597,32 93.434,65 117,08 714,40 92.720,25
87
80 92.720,25 596,56 93.316,82 117,83 714,40 92.602,42
88
81 92.602,42 595,81 93.198,22 118,59 714,40 92.483,83
89
82 92.483,83 595,04 93.078,87 119,35 714,40 92.364,47
90
83 92.364,47 594,28 92.958,75 120,12 714,40 92.244,35
91
84 92.244,35 593,50 92.837,85 120,90 714,40 92.123,45
92
85 92.123,45 592,73 92.716,18 121,67 714,40 92.001,78
93
86 92.001,78 591,94 92.593,72 122,46 714,40 91.879,33
94
87 91.879,33 591,15 92.470,48 123,24 714,40 91.756,08
95
88 91.756,08 590,36 92.346,44 124,04 714,40 91.632,05
96
89 91.632,05 589,56 92.221,61 124,83 714,40 91.507,21
97
90 91.507,21 588,76 92.095,97 125,64 714,40 91.381,57
98
91 91.381,57 587,95 91.969,53 126,45 714,40 91.255,13
99
92 91.255,13 587,14 91.842,27 127,26 714,40 91.127,87
100
93 91.127,87 586,32 91.714,19 128,08 714,40 90.999,79