SimuladorJuros Compostos

HÁ 3 ABAS DIFERENTES COM PLANILHAS DIFERENTES EM CADA UMA
A PLANILHA SÓ FUNCIONA NO GOOGLE DRIVE (PLANILHAS GOOGLE).

PARA USAR A PLANILHA, BASTA CLICAR EM ARQUIVO E DEPOIS EM FA
IPCA Anual 0%
SELIC Anual 13.75%
CDI Anual 13.65%
Seu Investimento % CDI 100.00%
Juros Mensal 1.07%
Investimento Rendimento
R$ 1,000.00 R$ 10.72
R$ 5,000.00 R$ 53.60
R$ 10,000.00 R$ 107.20
R$ 25,000.00 R$ 268.00
R$ 50,000.00 R$ 535.99
R$ 100,000.00 R$ 1,071.98
R$ 1,000,000.00 R$ 10,719.83
* O imposto só entra na hora de resgatar os investimentos.

* Usei aliquita de 15% de IR
ANILHAS DIFERENTES EM CADA UMA DAS ABAS.
OOGLE DRIVE (PLANILHAS GOOGLE). NO EXCEL ELA PODE APRESENTAR ERRO DE FÓRM
A CLICAR EM ARQUIVO E DEPOIS EM FAZER UMA CÓPIA ou DOWNLOAD e SUBIR NO SEU D
Mês Acumulado
1 R$ 0.00
2 R$ 500.00
Rendimento menos Imposto* 3 R$ 1,005.36
R$ 9.11 4 R$ 1,516.14
R$ 45.56 5 R$ 2,032.39
R$ 91.12 6 R$ 2,554.18
R$ 227.80 7 R$ 3,081.56
R$ 455.59 8 R$ 3,614.59
R$ 911.19 9 R$ 4,153.34
R$ 9,111.86 10 R$ 4,697.86
11 R$ 5,248.22
12 R$ 5,804.48
gatar os investimentos. 13 R$ 6,366.71
14 R$ 6,934.96
15 R$ 7,509.30
16 R$ 8,089.80
17 R$ 8,676.52
18 R$ 9,269.53
19 R$ 9,868.89
20 R$ 10,474.69
21 R$ 11,086.97
22 R$ 11,705.83
23 R$ 12,331.31
24 R$ 12,963.50
25 R$ 13,602.47
26 R$ 14,248.28
27 R$ 14,901.02
28 R$ 15,560.76
29 R$ 16,227.57
30 R$ 16,901.52
31 R$ 17,582.70
32 R$ 18,271.19
33 R$ 18,967.05
34 R$ 19,670.38
35 R$ 20,381.24
36 R$ 21,099.72
37 R$ 21,825.91
38 R$ 22,559.88
39 R$ 23,301.72
40 R$ 24,051.51
41 R$ 24,809.33
42 R$ 25,575.29
43 R$ 26,349.45
44 R$ 27,131.91
45 R$ 27,922.76
46 R$ 28,722.09
47 R$ 29,529.98
48 R$ 30,346.54
49 R$ 31,171.85
50 R$ 32,006.01
51 R$ 32,849.10
52 R$ 33,701.24
53 R$ 34,562.51
54 R$ 35,433.02
55 R$ 36,312.85
56 R$ 37,202.12
57 R$ 38,100.92
58 R$ 39,009.36
59 R$ 39,927.53
60 R$ 40,855.55
61 R$ 41,793.51
62 R$ 42,741.53
63 R$ 43,699.71
64 R$ 44,668.17
65 R$ 45,647.00
66 R$ 46,636.33
67 R$ 47,636.26
68 R$ 48,646.92
69 R$ 49,668.40
70 R$ 50,700.84
71 R$ 51,744.34
72 R$ 52,799.03
73 R$ 53,865.03
74 R$ 54,942.46
75 R$ 56,031.43
76 R$ 57,132.08
77 R$ 58,244.52
78 R$ 59,368.89
79 R$ 60,505.32
80 R$ 61,653.93
81 R$ 62,814.84
82 R$ 63,988.21
83 R$ 65,174.15
84 R$ 66,372.81
85 R$ 67,584.31
86 R$ 68,808.81
87 R$ 70,046.42
88 R$ 71,297.31
89 R$ 72,561.61
90 R$ 73,839.45
91 R$ 75,131.00
92 R$ 76,436.39
93 R$ 77,755.78
94 R$ 79,089.31
95 R$ 80,437.13
96 R$ 81,799.40
97 R$ 83,176.28
98 R$ 84,567.91
99 R$ 85,974.47
100 R$ 87,396.10
101 R$ 88,832.97
102 R$ 90,285.24
103 R$ 91,753.09
104 R$ 93,236.66
105 R$ 94,736.15
106 R$ 96,251.70
107 R$ 97,783.50
108 R$ 99,331.72
109 R$ 100,896.54
110 R$ 102,478.14
111 R$ 104,076.69
112 R$ 105,692.37
113 R$ 107,325.37
114 R$ 108,975.88
115 R$ 110,644.09
116 R$ 112,330.17
117 R$ 114,034.33
118 R$ 115,756.76
119 R$ 117,497.66
120 R$ 119,257.21
121 R$ 121,035.63
122 R$ 122,833.11
123 R$ 124,649.86
124 R$ 126,486.08
125 R$ 128,341.99
126 R$ 130,217.80
127 R$ 132,113.71
128 R$ 134,029.95
129 R$ 135,966.73
130 R$ 137,924.27
131 R$ 139,902.79
132 R$ 141,902.52
133 R$ 143,923.70
134 R$ 145,966.53
135 R$ 148,031.27
136 R$ 150,118.14
137 R$ 152,227.38
138 R$ 154,359.23
139 R$ 156,513.94
140 R$ 158,691.74
141 R$ 160,892.89
142 R$ 163,117.63
143 R$ 165,366.23
144 R$ 167,638.92
145 R$ 169,935.99
146 R$ 172,257.67
147 R$ 174,604.24
148 R$ 176,975.97
149 R$ 179,373.12
150 R$ 181,795.97
151 R$ 184,244.80
152 R$ 186,719.87
153 R$ 189,221.47
154 R$ 191,749.90
155 R$ 194,305.42
156 R$ 196,888.34
157 R$ 199,498.95
158 R$ 202,137.55
159 R$ 204,804.43
160 R$ 207,499.90
161 R$ 210,224.26
162 R$ 212,977.83
163 R$ 215,760.92
164 R$ 218,573.84
165 R$ 221,416.91
166 R$ 224,290.46
167 R$ 227,194.82
168 R$ 230,130.31
169 R$ 233,097.27
170 R$ 236,096.03
171 R$ 239,126.94
172 R$ 242,190.34
173 R$ 245,286.58
174 R$ 248,416.01
175 R$ 251,578.99
176 R$ 254,775.87
177 R$ 258,007.02
178 R$ 261,272.81
179 R$ 264,573.62
180 R$ 267,909.80
181 R$ 271,281.75
182 R$ 274,689.84
183 R$ 278,134.47
184 R$ 281,616.02
185 R$ 285,134.90
186 R$ 288,691.50
187 R$ 292,286.22
188 R$ 295,919.48
189 R$ 299,591.69
190 R$ 303,303.26
191 R$ 307,054.62
192 R$ 310,846.19
193 R$ 314,678.41
194 R$ 318,551.71
195 R$ 322,466.53
196 R$ 326,423.32
197 R$ 330,422.52
198 R$ 334,464.59
199 R$ 338,550.00
200 R$ 342,679.19
201 R$ 346,852.66
202 R$ 351,070.86
203 R$ 355,334.28
204 R$ 359,643.40
205 R$ 363,998.72
206 R$ 368,400.72
207 R$ 372,849.92
208 R$ 377,346.80
209 R$ 381,891.90
210 R$ 386,485.71
211 R$ 391,128.78
212 R$ 395,821.61
213 R$ 400,564.75
214 R$ 405,358.74
215 R$ 410,204.11
216 R$ 415,101.43
217 R$ 420,051.25
218 R$ 425,054.13
219 R$ 430,110.64
220 R$ 435,221.35
221 R$ 440,386.85
222 R$ 445,607.72
223 R$ 450,884.56
224 R$ 456,217.97
225 R$ 461,608.54
226 R$ 467,056.91
227 R$ 472,563.68
228 R$ 478,129.48
229 R$ 483,754.95
230 R$ 489,440.72
231 R$ 495,187.44
232 R$ 500,995.77
233 R$ 506,866.36
234 R$ 512,799.88
235 R$ 518,797.01
236 R$ 524,858.42
237 R$ 530,984.82
238 R$ 537,176.88
239 R$ 543,435.33
240 R$ 549,760.86
241 R$ 556,154.21
242 R$ 562,616.08
243 R$ 569,147.23
244 R$ 575,748.40
245 R$ 582,420.32
246 R$ 589,163.77
247 R$ 595,979.50
248 R$ 602,868.30
249 R$ 609,830.95
250 R$ 616,868.23
251 R$ 623,980.96
252 R$ 631,169.93
253 R$ 638,435.96
254 R$ 645,779.89
255 R$ 653,202.54
256 R$ 660,704.76
257 R$ 668,287.40
258 R$ 675,951.33
259 R$ 683,697.41
260 R$ 691,526.53
261 R$ 699,439.58
262 R$ 707,437.45
263 R$ 715,521.06
264 R$ 723,691.33
265 R$ 731,949.17
266 R$ 740,295.55
267 R$ 748,731.39
268 R$ 757,257.66
269 R$ 765,875.34
270 R$ 774,585.39
271 R$ 783,388.81
272 R$ 792,286.61
273 R$ 801,279.79
274 R$ 810,369.37
275 R$ 819,556.39
276 R$ 828,841.90
277 R$ 838,226.94
278 R$ 847,712.59
279 R$ 857,299.93
280 R$ 866,990.04
281 R$ 876,784.02
282 R$ 886,683.00
283 R$ 896,688.09
284 R$ 906,800.44
285 R$ 917,021.18
286 R$ 927,351.49
287 R$ 937,792.54
288 R$ 948,345.52
289 R$ 959,011.62
290 R$ 969,792.07
291 R$ 980,688.07
292 R$ 991,700.88
293 R$ 1,002,831.75
294 R$ 1,014,081.93
295 R$ 1,025,452.72
296 R$ 1,036,945.40
297 R$ 1,048,561.28
298 R$ 1,060,301.68
299 R$ 1,072,167.93
300 R$ 1,084,161.39
301 R$ 1,096,283.42
302 R$ 1,108,535.39
303 R$ 1,120,918.70
304 R$ 1,133,434.76
305 R$ 1,146,084.99
306 R$ 1,158,870.82
307 R$ 1,171,793.72
308 R$ 1,184,855.15
309 R$ 1,198,056.60
310 R$ 1,211,399.56
311 R$ 1,224,885.56
312 R$ 1,238,516.12
313 R$ 1,252,292.81
314 R$ 1,266,217.17
315 R$ 1,280,290.81
316 R$ 1,294,515.31
317 R$ 1,308,892.29
318 R$ 1,323,423.40
319 R$ 1,338,110.27
320 R$ 1,352,954.59
321 R$ 1,367,958.03
322 R$ 1,383,122.31
323 R$ 1,398,449.14
324 R$ 1,413,940.28
325 R$ 1,429,597.48
326 R$ 1,445,422.52
327 R$ 1,461,417.21
328 R$ 1,477,583.35
329 R$ 1,493,922.80
330 R$ 1,510,437.39
331 R$ 1,527,129.03
332 R$ 1,543,999.59
333 R$ 1,561,051.01
334 R$ 1,578,285.21
335 R$ 1,595,704.16
336 R$ 1,613,309.83
337 R$ 1,631,104.24
338 R$ 1,649,089.40
339 R$ 1,667,267.36
340 R$ 1,685,640.19
341 R$ 1,704,209.96
342 R$ 1,722,978.80
343 R$ 1,741,948.84
344 R$ 1,761,122.24
345 R$ 1,780,501.17
346 R$ 1,800,087.84
347 R$ 1,819,884.48
348 R$ 1,839,893.33
349 R$ 1,860,116.68
350 R$ 1,880,556.81
351 R$ 1,901,216.06
352 R$ 1,922,096.78
353 R$ 1,943,201.33
354 R$ 1,964,532.12
355 R$ 1,986,091.57
356 R$ 2,007,882.13
357 R$ 2,029,906.29
358 R$ 2,052,166.54
359 R$ 2,074,665.42
360 R$ 2,097,405.48
SENTAR ERRO DE FÓRMULAS.
OAD e SUBIR NO SEU DRIVE.
Rendimento Mensal Aporte

R$ 0.00 R$ 500.00
R$ 5.36 R$ 500.00
R$ 10.78 R$ 500.00
R$ 16.25 R$ 500.00
R$ 21.79 R$ 500.00
R$ 27.38 R$ 500.00
R$ 33.03 R$ 500.00
R$ 38.75 R$ 500.00
R$ 44.52 R$ 500.00
R$ 50.36 R$ 500.00
R$ 56.26 R$ 500.00
R$ 62.22 R$ 500.00
R$ 68.25 R$ 500.00
R$ 74.34 R$ 500.00
R$ 80.50 R$ 500.00
R$ 86.72 R$ 500.00
R$ 93.01 R$ 500.00
R$ 99.37 R$ 500.00
R$ 105.79 R$ 500.00
R$ 112.29 R$ 500.00
R$ 118.85 R$ 500.00
R$ 125.48 R$ 500.00
R$ 132.19 R$ 500.00
R$ 138.97 R$ 500.00
R$ 145.82 R$ 500.00
R$ 152.74 R$ 500.00
R$ 159.74 R$ 500.00
R$ 166.81 R$ 500.00
R$ 173.96 R$ 500.00
R$ 181.18 R$ 500.00
R$ 188.48 R$ 500.00
R$ 195.86 R$ 500.00
R$ 203.32 R$ 500.00
R$ 210.86 R$ 500.00
R$ 218.48 R$ 500.00
R$ 226.19 R$ 500.00
R$ 233.97 R$ 500.00
R$ 241.84 R$ 500.00
R$ 249.79 R$ 500.00
R$ 257.83 R$ 500.00
R$ 265.95 R$ 500.00
R$ 274.16 R$ 500.00
R$ 282.46 R$ 500.00
R$ 290.85 R$ 500.00
R$ 299.33 R$ 500.00
R$ 307.90 R$ 500.00
R$ 316.56 R$ 500.00
R$ 325.31 R$ 500.00
R$ 334.16 R$ 500.00
R$ 343.10 R$ 500.00
R$ 352.14 R$ 500.00
R$ 361.27 R$ 500.00
R$ 370.50 R$ 500.00
R$ 379.84 R$ 500.00
R$ 389.27 R$ 500.00
R$ 398.80 R$ 500.00
R$ 408.44 R$ 500.00
R$ 418.17 R$ 500.00
R$ 428.02 R$ 500.00
R$ 437.96 R$ 500.00
R$ 448.02 R$ 500.00
R$ 458.18 R$ 500.00
R$ 468.45 R$ 500.00
R$ 478.84 R$ 500.00
R$ 489.33 R$ 500.00
R$ 499.93 R$ 500.00
R$ 510.65 R$ 500.00
R$ 521.49 R$ 500.00
R$ 532.44 R$ 500.00
R$ 543.50 R$ 500.00
R$ 554.69 R$ 500.00
R$ 566.00 R$ 500.00
R$ 577.42 R$ 500.00
R$ 588.97 R$ 500.00
R$ 600.65 R$ 500.00
R$ 612.45 R$ 500.00
R$ 624.37 R$ 500.00
R$ 636.42 R$ 500.00
R$ 648.61 R$ 500.00
R$ 660.92 R$ 500.00
R$ 673.36 R$ 500.00
R$ 685.94 R$ 500.00
R$ 698.66 R$ 500.00
R$ 711.51 R$ 500.00
R$ 724.49 R$ 500.00
R$ 737.62 R$ 500.00
R$ 750.89 R$ 500.00
R$ 764.30 R$ 500.00
R$ 777.85 R$ 500.00
R$ 791.55 R$ 500.00
R$ 805.39 R$ 500.00
R$ 819.39 R$ 500.00
R$ 833.53 R$ 500.00
R$ 847.82 R$ 500.00
R$ 862.27 R$ 500.00
R$ 876.88 R$ 500.00
R$ 891.64 R$ 500.00
R$ 906.55 R$ 500.00
R$ 921.63 R$ 500.00
R$ 936.87 R$ 500.00
R$ 952.27 R$ 500.00
R$ 967.84 R$ 500.00
R$ 983.58 R$ 500.00
R$ 999.48 R$ 500.00
R$ 1,015.56 R$ 500.00
R$ 1,031.80 R$ 500.00
R$ 1,048.22 R$ 500.00
R$ 1,064.82 R$ 500.00
R$ 1,081.59 R$ 500.00
R$ 1,098.55 R$ 500.00
R$ 1,115.68 R$ 500.00
R$ 1,133.00 R$ 500.00
R$ 1,150.51 R$ 500.00
R$ 1,168.20 R$ 500.00
R$ 1,186.09 R$ 500.00
R$ 1,204.16 R$ 500.00
R$ 1,222.43 R$ 500.00
R$ 1,240.89 R$ 500.00
R$ 1,259.55 R$ 500.00
R$ 1,278.42 R$ 500.00
R$ 1,297.48 R$ 500.00
R$ 1,316.75 R$ 500.00
R$ 1,336.23 R$ 500.00
R$ 1,355.91 R$ 500.00
R$ 1,375.80 R$ 500.00
R$ 1,395.91 R$ 500.00
R$ 1,416.24 R$ 500.00
R$ 1,436.78 R$ 500.00
R$ 1,457.54 R$ 500.00
R$ 1,478.52 R$ 500.00
R$ 1,499.73 R$ 500.00
R$ 1,521.17 R$ 500.00
R$ 1,542.84 R$ 500.00
R$ 1,564.74 R$ 500.00
R$ 1,586.87 R$ 500.00
R$ 1,609.24 R$ 500.00
R$ 1,631.85 R$ 500.00
R$ 1,654.70 R$ 500.00
R$ 1,677.80 R$ 500.00
R$ 1,701.15 R$ 500.00
R$ 1,724.74 R$ 500.00
R$ 1,748.59 R$ 500.00
R$ 1,772.70 R$ 500.00
R$ 1,797.06 R$ 500.00
R$ 1,821.68 R$ 500.00
R$ 1,846.57 R$ 500.00
R$ 1,871.73 R$ 500.00
R$ 1,897.15 R$ 500.00
R$ 1,922.85 R$ 500.00
R$ 1,948.82 R$ 500.00
R$ 1,975.07 R$ 500.00
R$ 2,001.61 R$ 500.00
R$ 2,028.42 R$ 500.00
R$ 2,055.53 R$ 500.00
R$ 2,082.92 R$ 500.00
R$ 2,110.61 R$ 500.00
R$ 2,138.59 R$ 500.00
R$ 2,166.88 R$ 500.00
R$ 2,195.47 R$ 500.00
R$ 2,224.36 R$ 500.00
R$ 2,253.57 R$ 500.00
R$ 2,283.09 R$ 500.00
R$ 2,312.92 R$ 500.00
R$ 2,343.07 R$ 500.00
R$ 2,373.55 R$ 500.00
R$ 2,404.36 R$ 500.00
R$ 2,435.49 R$ 500.00
R$ 2,466.96 R$ 500.00
R$ 2,498.76 R$ 500.00
R$ 2,530.91 R$ 500.00
R$ 2,563.40 R$ 500.00
R$ 2,596.24 R$ 500.00
R$ 2,629.43 R$ 500.00
R$ 2,662.98 R$ 500.00
R$ 2,696.88 R$ 500.00
R$ 2,731.15 R$ 500.00
R$ 2,765.79 R$ 500.00
R$ 2,800.80 R$ 500.00
R$ 2,836.18 R$ 500.00
R$ 2,871.95 R$ 500.00
R$ 2,908.09 R$ 500.00
R$ 2,944.63 R$ 500.00
R$ 2,981.55 R$ 500.00
R$ 3,018.88 R$ 500.00
R$ 3,056.60 R$ 500.00
R$ 3,094.72 R$ 500.00
R$ 3,133.26 R$ 500.00
R$ 3,172.21 R$ 500.00
R$ 3,211.57 R$ 500.00
R$ 3,251.36 R$ 500.00
R$ 3,291.57 R$ 500.00
R$ 3,332.22 R$ 500.00
R$ 3,373.30 R$ 500.00
R$ 3,414.82 R$ 500.00
R$ 3,456.79 R$ 500.00
R$ 3,499.20 R$ 500.00
R$ 3,542.07 R$ 500.00
R$ 3,585.40 R$ 500.00
R$ 3,629.20 R$ 500.00
R$ 3,673.46 R$ 500.00
R$ 3,718.20 R$ 500.00
R$ 3,763.42 R$ 500.00
R$ 3,809.12 R$ 500.00
R$ 3,855.32 R$ 500.00
R$ 3,902.00 R$ 500.00
R$ 3,949.19 R$ 500.00
R$ 3,996.89 R$ 500.00
R$ 4,045.09 R$ 500.00
R$ 4,093.82 R$ 500.00
R$ 4,143.06 R$ 500.00
R$ 4,192.83 R$ 500.00
R$ 4,243.14 R$ 500.00
R$ 4,293.99 R$ 500.00
R$ 4,345.38 R$ 500.00
R$ 4,397.32 R$ 500.00
R$ 4,449.82 R$ 500.00
R$ 4,502.88 R$ 500.00
R$ 4,556.51 R$ 500.00
R$ 4,610.71 R$ 500.00
R$ 4,665.50 R$ 500.00
R$ 4,720.87 R$ 500.00
R$ 4,776.84 R$ 500.00
R$ 4,833.41 R$ 500.00
R$ 4,890.58 R$ 500.00
R$ 4,948.37 R$ 500.00
R$ 5,006.77 R$ 500.00
R$ 5,065.80 R$ 500.00
R$ 5,125.47 R$ 500.00
R$ 5,185.77 R$ 500.00
R$ 5,246.72 R$ 500.00
R$ 5,308.33 R$ 500.00
R$ 5,370.59 R$ 500.00
R$ 5,433.52 R$ 500.00
R$ 5,497.13 R$ 500.00
R$ 5,561.42 R$ 500.00
R$ 5,626.39 R$ 500.00
R$ 5,692.07 R$ 500.00
R$ 5,758.45 R$ 500.00
R$ 5,825.53 R$ 500.00
R$ 5,893.34 R$ 500.00
R$ 5,961.88 R$ 500.00
R$ 6,031.15 R$ 500.00
R$ 6,101.16 R$ 500.00
R$ 6,171.93 R$ 500.00
R$ 6,243.45 R$ 500.00
R$ 6,315.74 R$ 500.00
R$ 6,388.80 R$ 500.00
R$ 6,462.65 R$ 500.00
R$ 6,537.28 R$ 500.00
R$ 6,612.72 R$ 500.00
R$ 6,688.97 R$ 500.00
R$ 6,766.03 R$ 500.00
R$ 6,843.93 R$ 500.00
R$ 6,922.65 R$ 500.00
R$ 7,002.22 R$ 500.00
R$ 7,082.64 R$ 500.00
R$ 7,163.93 R$ 500.00
R$ 7,246.08 R$ 500.00
R$ 7,329.12 R$ 500.00
R$ 7,413.05 R$ 500.00
R$ 7,497.87 R$ 500.00
R$ 7,583.61 R$ 500.00
R$ 7,670.26 R$ 500.00
R$ 7,757.85 R$ 500.00
R$ 7,846.37 R$ 500.00
R$ 7,935.84 R$ 500.00
R$ 8,026.27 R$ 500.00
R$ 8,117.67 R$ 500.00
R$ 8,210.05 R$ 500.00
R$ 8,303.42 R$ 500.00
R$ 8,397.80 R$ 500.00
R$ 8,493.18 R$ 500.00
R$ 8,589.58 R$ 500.00
R$ 8,687.02 R$ 500.00
R$ 8,785.51 R$ 500.00
R$ 8,885.04 R$ 500.00
R$ 8,985.65 R$ 500.00
R$ 9,087.34 R$ 500.00
R$ 9,190.11 R$ 500.00
R$ 9,293.99 R$ 500.00
R$ 9,398.98 R$ 500.00
R$ 9,505.09 R$ 500.00
R$ 9,612.34 R$ 500.00
R$ 9,720.75 R$ 500.00
R$ 9,830.31 R$ 500.00
R$ 9,941.05 R$ 500.00
R$ 10,052.98 R$ 500.00
R$ 10,166.10 R$ 500.00
R$ 10,280.44 R$ 500.00
R$ 10,396.01 R$ 500.00
R$ 10,512.81 R$ 500.00
R$ 10,630.87 R$ 500.00
R$ 10,750.19 R$ 500.00
R$ 10,870.79 R$ 500.00
R$ 10,992.68 R$ 500.00
R$ 11,115.88 R$ 500.00
R$ 11,240.40 R$ 500.00
R$ 11,366.25 R$ 500.00
R$ 11,493.46 R$ 500.00
R$ 11,622.03 R$ 500.00
R$ 11,751.97 R$ 500.00
R$ 11,883.31 R$ 500.00
R$ 12,016.06 R$ 500.00
R$ 12,150.23 R$ 500.00
R$ 12,285.84 R$ 500.00
R$ 12,422.90 R$ 500.00
R$ 12,561.43 R$ 500.00
R$ 12,701.45 R$ 500.00
R$ 12,842.96 R$ 500.00
R$ 12,986.00 R$ 500.00
R$ 13,130.57 R$ 500.00
R$ 13,276.68 R$ 500.00
R$ 13,424.37 R$ 500.00
R$ 13,573.63 R$ 500.00
R$ 13,724.50 R$ 500.00
R$ 13,876.98 R$ 500.00
R$ 14,031.10 R$ 500.00
R$ 14,186.87 R$ 500.00
R$ 14,344.32 R$ 500.00
R$ 14,503.44 R$ 500.00
R$ 14,664.28 R$ 500.00
R$ 14,826.84 R$ 500.00
R$ 14,991.14 R$ 500.00
R$ 15,157.20 R$ 500.00
R$ 15,325.04 R$ 500.00
R$ 15,494.68 R$ 500.00
R$ 15,666.14 R$ 500.00
R$ 15,839.44 R$ 500.00
R$ 16,014.60 R$ 500.00
R$ 16,191.63 R$ 500.00
R$ 16,370.56 R$ 500.00
R$ 16,551.41 R$ 500.00
R$ 16,734.20 R$ 500.00
R$ 16,918.95 R$ 500.00
R$ 17,105.68 R$ 500.00
R$ 17,294.41 R$ 500.00
R$ 17,485.16 R$ 500.00
R$ 17,677.96 R$ 500.00
R$ 17,872.82 R$ 500.00
R$ 18,069.78 R$ 500.00
R$ 18,268.84 R$ 500.00
R$ 18,470.04 R$ 500.00
R$ 18,673.40 R$ 500.00
R$ 18,878.93 R$ 500.00
R$ 19,086.67 R$ 500.00
R$ 19,296.64 R$ 500.00
R$ 19,508.85 R$ 500.00
R$ 19,723.34 R$ 500.00
R$ 19,940.14 R$ 500.00
R$ 20,159.25 R$ 500.00
R$ 20,380.71 R$ 500.00
R$ 20,604.55 R$ 500.00
R$ 20,830.79 R$ 500.00
R$ 21,059.45 R$ 500.00
R$ 21,290.56 R$ 500.00
R$ 21,524.16 R$ 500.00
R$ 21,760.25 R$ 500.00
R$ 21,998.88 R$ 500.00
R$ 22,240.06 R$ 500.00
R$ 22,483.83 R$ 500.00
HÁ 3 ABAS DIFERENTES COM PLANILHAS DIFERENTES EM CADA UMA DAS A
A PLANILHA SÓ FUNCIONA NO GOOGLE DRIVE (PLANILHAS GOOGLE). NO EX
PARA USAR A PLANILHA, BASTA CLICAR EM ARQUIVO E DEPOIS EM FAZER
FII: FIIS
DY Anual: 10.00%
DY Mensal: 0.80%
Valor Cota: R$ 90.00
Investimento Rendimento Quantas Cotas eu Compro?

R$ 1,000.00 R$ 7.97 0
R$ 2,000.00 R$ 15.95 0
R$ 5,000.00 R$ 39.87 0
R$ 25,000.00 R$ 199.35 2
R$ 92,000.00 R$ 733.62 8
Rendimento por mês
300000
250000
200000
Rendimento
150000 Rendimento
100000
50000
0
1 21 41 61 81 101121141161181201221241261281301321341
Mês
RENTES EM CADA UMA DAS ABAS.
(PLANILHAS GOOGLE). NO EXCEL ELA PODE APRESENTAR ERRO DE FÓRMUL
RQUIVO E DEPOIS EM FAZER UMA CÓPIA ou DOWNLOAD e SUBIR NO SEU DRIV
Número de Cotas Valor

Investimento Mensal 167 R$ 15,030.00
Mês Quantas Cotas eu Tenho? Valor das Cotas Rendimento

1 0 R$ 0.00 R$ 0.00
2 167 R$ 15,030.00 R$ 119.85
3 335 R$ 30,150.00 R$ 240.42
4 505 R$ 45,450.00 R$ 362.42
5 676 R$ 60,840.00 R$ 485.15
6 848 R$ 76,320.00 R$ 608.59
7 1022 R$ 91,980.00 R$ 733.46
8 1197 R$ 107,730.00 R$ 859.05
9 1373 R$ 123,570.00 R$ 985.36
10 1551 R$ 139,590.00 R$ 1,113.11
11 1731 R$ 155,790.00 R$ 1,242.29
12 1911 R$ 171,990.00 R$ 1,371.47
13 2094 R$ 188,460.00 R$ 1,502.81
14 2277 R$ 204,930.00 R$ 1,634.14
15 2463 R$ 221,670.00 R$ 1,767.63
16 2649 R$ 238,410.00 R$ 1,901.11
17 2837 R$ 255,330.00 R$ 2,036.04
18 3027 R$ 272,430.00 R$ 2,172.40
19 3218 R$ 289,620.00 R$ 2,309.47
20 3411 R$ 306,990.00 R$ 2,447.98
21 3605 R$ 324,450.00 R$ 2,587.21
22 3801 R$ 342,090.00 R$ 2,727.87
23 3998 R$ 359,820.00 R$ 2,869.26
24 4197 R$ 377,730.00 R$ 3,012.07
25 4397 R$ 395,730.00 R$ 3,155.61
26 4599 R$ 413,910.00 R$ 3,300.58
27 4803 R$ 432,270.00 R$ 3,446.98
28 5008 R$ 450,720.00 R$ 3,594.10
29 5215 R$ 469,350.00 R$ 3,742.66
30 5424 R$ 488,160.00 R$ 3,892.66
31 5634 R$ 507,060.00 R$ 4,043.37
32 5846 R$ 526,140.00 R$ 4,195.51
33 6060 R$ 545,400.00 R$ 4,349.10
34 6275 R$ 564,750.00 R$ 4,503.40
35 6492 R$ 584,280.00 R$ 4,659.13
36 6711 R$ 603,990.00 R$ 4,816.30
37 6931 R$ 623,790.00 R$ 4,974.19
38 7154 R$ 643,860.00 R$ 5,134.23
39 7378 R$ 664,020.00 R$ 5,294.99
40 7604 R$ 684,360.00 R$ 5,457.18
41 7831 R$ 704,790.00 R$ 5,620.09
42 8061 R$ 725,490.00 R$ 5,785.16
43 8292 R$ 746,280.00 R$ 5,950.94
44 8525 R$ 767,250.00 R$ 6,118.16
45 8760 R$ 788,400.00 R$ 6,286.81
46 8997 R$ 809,730.00 R$ 6,456.90
47 9236 R$ 831,240.00 R$ 6,628.42
48 9476 R$ 852,840.00 R$ 6,800.67
49 9719 R$ 874,710.00 R$ 6,975.06
50 9963 R$ 896,670.00 R$ 7,150.17
51 10210 R$ 918,900.00 R$ 7,327.44
52 10458 R$ 941,220.00 R$ 7,505.42
53 10709 R$ 963,810.00 R$ 7,685.56
54 10961 R$ 986,490.00 R$ 7,866.41
55 11215 R$ 1,009,350.00 R$ 8,048.70
56 11472 R$ 1,032,480.00 R$ 8,233.14
57 11730 R$ 1,055,700.00 R$ 8,418.30
58 11991 R$ 1,079,190.00 R$ 8,605.61
59 12253 R$ 1,102,770.00 R$ 8,793.64
60 12518 R$ 1,126,620.00 R$ 8,983.83
61 12785 R$ 1,150,650.00 R$ 9,175.44
62 13054 R$ 1,174,860.00 R$ 9,368.50
63 13325 R$ 1,199,250.00 R$ 9,562.99
64 13598 R$ 1,223,820.00 R$ 9,758.91
65 13874 R$ 1,248,660.00 R$ 9,956.99
66 14151 R$ 1,273,590.00 R$ 10,155.79
67 14431 R$ 1,298,790.00 R$ 10,356.73
68 14713 R$ 1,324,170.00 R$ 10,559.12
69 14998 R$ 1,349,820.00 R$ 10,763.65
70 15284 R$ 1,375,560.00 R$ 10,968.91
71 15573 R$ 1,401,570.00 R$ 11,176.32
72 15864 R$ 1,427,760.00 R$ 11,385.16
73 16158 R$ 1,454,220.00 R$ 11,596.15
74 16454 R$ 1,480,860.00 R$ 11,808.59
75 16752 R$ 1,507,680.00 R$ 12,022.45
76 17052 R$ 1,534,680.00 R$ 12,237.75
77 17355 R$ 1,561,950.00 R$ 12,455.21
78 17661 R$ 1,589,490.00 R$ 12,674.82
79 17969 R$ 1,617,210.00 R$ 12,895.86
80 18279 R$ 1,645,110.00 R$ 13,118.34
81 18592 R$ 1,673,280.00 R$ 13,342.97
82 18907 R$ 1,701,630.00 R$ 13,569.04
83 19225 R$ 1,730,250.00 R$ 13,797.26
84 19545 R$ 1,759,050.00 R$ 14,026.91
85 19868 R$ 1,788,120.00 R$ 14,258.72
86 20193 R$ 1,817,370.00 R$ 14,491.96
87 20521 R$ 1,846,890.00 R$ 14,727.36
88 20852 R$ 1,876,680.00 R$ 14,964.91
89 21185 R$ 1,906,650.00 R$ 15,203.89
90 21521 R$ 1,936,890.00 R$ 15,445.03
91 21860 R$ 1,967,400.00 R$ 15,688.32
92 22201 R$ 1,998,090.00 R$ 15,933.05
93 22545 R$ 2,029,050.00 R$ 16,179.93
94 22892 R$ 2,060,280.00 R$ 16,428.96
95 23241 R$ 2,091,690.00 R$ 16,679.43
96 23594 R$ 2,123,460.00 R$ 16,932.77
97 23949 R$ 2,155,410.00 R$ 17,187.54
98 24307 R$ 2,187,630.00 R$ 17,444.47
99 24668 R$ 2,220,120.00 R$ 17,703.55
100 25031 R$ 2,252,790.00 R$ 17,964.06
101 25398 R$ 2,285,820.00 R$ 18,227.45
102 25767 R$ 2,319,030.00 R$ 18,492.27
103 26140 R$ 2,352,600.00 R$ 18,759.96
104 26515 R$ 2,386,350.00 R$ 19,029.09
105 26894 R$ 2,420,460.00 R$ 19,301.09
106 27275 R$ 2,454,750.00 R$ 19,574.52
107 27660 R$ 2,489,400.00 R$ 19,850.83
108 28047 R$ 2,524,230.00 R$ 20,128.56
109 28438 R$ 2,559,420.00 R$ 20,409.17
110 28832 R$ 2,594,880.00 R$ 20,691.94
111 29229 R$ 2,630,610.00 R$ 20,976.85
112 29629 R$ 2,666,610.00 R$ 21,263.92
113 30032 R$ 2,702,880.00 R$ 21,553.14
114 30438 R$ 2,739,420.00 R$ 21,844.52
115 30848 R$ 2,776,320.00 R$ 22,138.77
116 31261 R$ 2,813,490.00 R$ 22,435.16
117 31677 R$ 2,850,930.00 R$ 22,733.72
118 32097 R$ 2,888,730.00 R$ 23,035.14
119 32520 R$ 2,926,800.00 R$ 23,338.71
120 32946 R$ 2,965,140.00 R$ 23,644.44
121 33376 R$ 3,003,840.00 R$ 23,953.04
122 33809 R$ 3,042,810.00 R$ 24,263.79
123 34246 R$ 3,082,140.00 R$ 24,577.42
124 34686 R$ 3,121,740.00 R$ 24,893.19
125 35129 R$ 3,161,610.00 R$ 25,211.12
126 35577 R$ 3,201,930.00 R$ 25,532.64
127 36027 R$ 3,242,430.00 R$ 25,855.59
128 36482 R$ 3,283,380.00 R$ 26,182.13
129 36939 R$ 3,324,510.00 R$ 26,510.11
130 37401 R$ 3,366,090.00 R$ 26,841.67
131 37866 R$ 3,407,940.00 R$ 27,175.39
132 38335 R$ 3,450,150.00 R$ 27,511.98
133 38808 R$ 3,492,720.00 R$ 27,851.44
134 39284 R$ 3,535,560.00 R$ 28,193.05
135 39765 R$ 3,578,850.00 R$ 28,538.25
136 40249 R$ 3,622,410.00 R$ 28,885.61
137 40737 R$ 3,666,330.00 R$ 29,235.83
138 41228 R$ 3,710,520.00 R$ 29,588.21
139 41724 R$ 3,755,160.00 R$ 29,944.17
140 42224 R$ 3,800,160.00 R$ 30,303.01
141 42728 R$ 3,845,520.00 R$ 30,664.72
142 43235 R$ 3,891,150.00 R$ 31,028.58
143 43747 R$ 3,937,230.00 R$ 31,396.02
144 44263 R$ 3,983,670.00 R$ 31,766.34
145 44783 R$ 4,030,470.00 R$ 32,139.53
146 45307 R$ 4,077,630.00 R$ 32,515.59
147 45835 R$ 4,125,150.00 R$ 32,894.53
148 46368 R$ 4,173,120.00 R$ 33,277.04
149 46905 R$ 4,221,450.00 R$ 33,662.44
150 47446 R$ 4,270,140.00 R$ 34,050.70
151 47991 R$ 4,319,190.00 R$ 34,441.83
152 48541 R$ 4,368,690.00 R$ 34,836.55
153 49095 R$ 4,418,550.00 R$ 35,234.14
154 49653 R$ 4,468,770.00 R$ 35,634.60
155 50216 R$ 4,519,440.00 R$ 36,038.65
156 50784 R$ 4,570,560.00 R$ 36,446.29
157 51356 R$ 4,622,040.00 R$ 36,856.80
158 51932 R$ 4,673,880.00 R$ 37,270.18
159 52513 R$ 4,726,170.00 R$ 37,687.14
160 53099 R$ 4,778,910.00 R$ 38,107.70
161 53689 R$ 4,832,010.00 R$ 38,531.13
162 54284 R$ 4,885,560.00 R$ 38,958.14
163 54884 R$ 4,939,560.00 R$ 39,388.75
164 55489 R$ 4,994,010.00 R$ 39,822.94
165 56098 R$ 5,048,820.00 R$ 40,260.00
166 56713 R$ 5,104,170.00 R$ 40,701.37
167 57332 R$ 5,159,880.00 R$ 41,145.61
168 57956 R$ 5,216,040.00 R$ 41,593.44
169 58585 R$ 5,272,650.00 R$ 42,044.85
170 59219 R$ 5,329,710.00 R$ 42,499.86
171 59859 R$ 5,387,310.00 R$ 42,959.17
172 60503 R$ 5,445,270.00 R$ 43,421.35
173 61153 R$ 5,503,770.00 R$ 43,887.83
174 61807 R$ 5,562,630.00 R$ 44,357.19
175 62467 R$ 5,622,030.00 R$ 44,830.86
176 63132 R$ 5,681,880.00 R$ 45,308.11
177 63803 R$ 5,742,270.00 R$ 45,789.67
178 64478 R$ 5,803,020.00 R$ 46,274.10
179 65159 R$ 5,864,310.00 R$ 46,762.83
180 65846 R$ 5,926,140.00 R$ 47,255.87
181 66538 R$ 5,988,420.00 R$ 47,752.50
182 67236 R$ 6,051,240.00 R$ 48,253.44
183 67939 R$ 6,114,510.00 R$ 48,757.96
184 68648 R$ 6,178,320.00 R$ 49,266.79
185 69362 R$ 6,242,580.00 R$ 49,779.21
186 70082 R$ 6,307,380.00 R$ 50,295.93
187 70808 R$ 6,372,720.00 R$ 50,816.96
188 71540 R$ 6,438,600.00 R$ 51,342.30
189 72277 R$ 6,504,930.00 R$ 51,871.23
190 73020 R$ 6,571,800.00 R$ 52,404.46
191 73770 R$ 6,639,300.00 R$ 52,942.71
192 74525 R$ 6,707,250.00 R$ 53,484.55
193 75286 R$ 6,775,740.00 R$ 54,030.70
194 76054 R$ 6,844,860.00 R$ 54,581.87
195 76827 R$ 6,914,430.00 R$ 55,136.64
196 77607 R$ 6,984,630.00 R$ 55,696.42
197 78393 R$ 7,055,370.00 R$ 56,260.51
198 79185 R$ 7,126,650.00 R$ 56,828.91
199 79983 R$ 7,198,470.00 R$ 57,401.61
200 80788 R$ 7,270,920.00 R$ 57,979.34
201 81599 R$ 7,343,910.00 R$ 58,561.37
202 82417 R$ 7,417,530.00 R$ 59,148.43
203 83241 R$ 7,491,690.00 R$ 59,739.79
204 84072 R$ 7,566,480.00 R$ 60,336.17
205 84909 R$ 7,641,810.00 R$ 60,936.87
206 85753 R$ 7,717,770.00 R$ 61,542.58
207 86604 R$ 7,794,360.00 R$ 62,153.32
208 87462 R$ 7,871,580.00 R$ 62,769.08
209 88326 R$ 7,949,340.00 R$ 63,389.15
210 89197 R$ 8,027,730.00 R$ 64,014.25
211 90076 R$ 8,106,840.00 R$ 64,645.08
212 90961 R$ 8,186,490.00 R$ 65,280.22
213 91853 R$ 8,266,770.00 R$ 65,920.38
214 92753 R$ 8,347,770.00 R$ 66,566.29
215 93659 R$ 8,429,310.00 R$ 67,216.50
216 94573 R$ 8,511,570.00 R$ 67,872.45
217 95494 R$ 8,594,460.00 R$ 68,533.43
218 96423 R$ 8,678,070.00 R$ 69,200.15
219 97359 R$ 8,762,310.00 R$ 69,871.89
220 98302 R$ 8,847,180.00 R$ 70,548.66
221 99253 R$ 8,932,770.00 R$ 71,231.16
222 100211 R$ 9,018,990.00 R$ 71,918.69
223 101177 R$ 9,105,930.00 R$ 72,611.96
224 102151 R$ 9,193,590.00 R$ 73,310.98
225 103133 R$ 9,281,970.00 R$ 74,015.73
226 104122 R$ 9,370,980.00 R$ 74,725.51
227 105120 R$ 9,460,800.00 R$ 75,441.75
228 106125 R$ 9,551,250.00 R$ 76,163.01
229 107138 R$ 9,642,420.00 R$ 76,890.01
230 108159 R$ 9,734,310.00 R$ 77,622.75
231 109189 R$ 9,827,010.00 R$ 78,361.96
232 110227 R$ 9,920,430.00 R$ 79,106.90
233 111272 R$ 10,014,480.00 R$ 79,856.87
234 112327 R$ 10,109,430.00 R$ 80,614.01
235 113389 R$ 10,205,010.00 R$ 81,376.18
236 114461 R$ 10,301,490.00 R$ 82,145.53
237 115540 R$ 10,398,600.00 R$ 82,919.90
238 116629 R$ 10,496,610.00 R$ 83,701.44
239 117726 R$ 10,595,340.00 R$ 84,488.73
240 118831 R$ 10,694,790.00 R$ 85,281.76
241 119946 R$ 10,795,140.00 R$ 86,081.96
242 121070 R$ 10,896,300.00 R$ 86,888.63
243 122202 R$ 10,998,180.00 R$ 87,701.03
244 123343 R$ 11,100,870.00 R$ 88,519.90
245 124494 R$ 11,204,460.00 R$ 89,345.94
246 125654 R$ 11,308,860.00 R$ 90,178.44
247 126823 R$ 11,414,070.00 R$ 91,017.40
248 128001 R$ 11,520,090.00 R$ 91,862.82
249 129189 R$ 11,627,010.00 R$ 92,715.41
250 130386 R$ 11,734,740.00 R$ 93,574.46
251 131593 R$ 11,843,370.00 R$ 94,440.70
252 132809 R$ 11,952,810.00 R$ 95,313.39
253 134035 R$ 12,063,150.00 R$ 96,193.25
254 135271 R$ 12,174,390.00 R$ 97,080.30
255 136516 R$ 12,286,440.00 R$ 97,973.80
256 137772 R$ 12,399,480.00 R$ 98,875.19
257 139038 R$ 12,513,420.00 R$ 99,783.77
258 140313 R$ 12,628,170.00 ###
259 141599 R$ 12,743,910.00 ###
260 142895 R$ 12,860,550.00 ###
261 144202 R$ 12,978,180.00 ###
262 145519 R$ 13,096,710.00 ###
263 146846 R$ 13,216,140.00 ###
264 148184 R$ 13,336,560.00 ###
265 149533 R$ 13,457,970.00 ###
266 150892 R$ 13,580,280.00 ###
267 152262 R$ 13,703,580.00 ###
268 153644 R$ 13,827,960.00 ###
269 155036 R$ 13,953,240.00 ###
270 156439 R$ 14,079,510.00 ###
271 157853 R$ 14,206,770.00 ###
272 159279 R$ 14,335,110.00 ###
273 160716 R$ 14,464,440.00 ###
274 162165 R$ 14,594,850.00 ###
275 163625 R$ 14,726,250.00 ###
276 165097 R$ 14,858,730.00 ###
277 166580 R$ 14,992,200.00 ###
278 168076 R$ 15,126,840.00 ###
279 169583 R$ 15,262,470.00 ###
280 171102 R$ 15,399,180.00 ###
281 172634 R$ 15,537,060.00 ###
282 174177 R$ 15,675,930.00 ###
283 175733 R$ 15,815,970.00 ###
284 177301 R$ 15,957,090.00 ###
285 178882 R$ 16,099,380.00 ###
286 180476 R$ 16,242,840.00 ###
287 182082 R$ 16,387,380.00 ###
288 183701 R$ 16,533,090.00 ###
289 185333 R$ 16,679,970.00 ###
290 186977 R$ 16,827,930.00 ###
291 188635 R$ 16,977,150.00 ###
292 190307 R$ 17,127,630.00 ###
293 191991 R$ 17,279,190.00 ###
294 193689 R$ 17,432,010.00 ###
295 195401 R$ 17,586,090.00 ###
296 197126 R$ 17,741,340.00 ###
297 198865 R$ 17,897,850.00 ###
298 200617 R$ 18,055,530.00 ###
299 202384 R$ 18,214,560.00 ###
300 204165 R$ 18,374,850.00 ###
301 205960 R$ 18,536,400.00 ###
302 207769 R$ 18,699,210.00 ###
303 209593 R$ 18,863,370.00 ###
304 211432 R$ 19,028,880.00 ###
305 213285 R$ 19,195,650.00 ###
306 215152 R$ 19,363,680.00 ###
307 217035 R$ 19,533,150.00 ###
308 218933 R$ 19,703,970.00 ###
309 220845 R$ 19,876,050.00 ###
310 222773 R$ 20,049,570.00 ###
311 224717 R$ 20,224,530.00 ###
312 226676 R$ 20,400,840.00 ###
313 228650 R$ 20,578,500.00 ###
314 230641 R$ 20,757,690.00 ###
315 232647 R$ 20,938,230.00 ###
316 234669 R$ 21,120,210.00 ###
317 236707 R$ 21,303,630.00 ###
318 238762 R$ 21,488,580.00 ###
319 240833 R$ 21,674,970.00 ###
320 242920 R$ 21,862,800.00 ###
321 245024 R$ 22,052,160.00 ###
322 247145 R$ 22,243,050.00 ###
323 249283 R$ 22,435,470.00 ###
324 251438 R$ 22,629,420.00 ###
325 253610 R$ 22,824,900.00 ###
326 255799 R$ 23,021,910.00 ###
327 258006 R$ 23,220,540.00 ###
328 260230 R$ 23,420,700.00 ###
329 262472 R$ 23,622,480.00 ###
330 264732 R$ 23,825,880.00 ###
331 267010 R$ 24,030,900.00 ###
332 269306 R$ 24,237,540.00 ###
333 271621 R$ 24,445,890.00 ###
334 273954 R$ 24,655,860.00 ###
335 276305 R$ 24,867,450.00 ###
336 278676 R$ 25,080,840.00 ###
337 281065 R$ 25,295,850.00 ###
338 283473 R$ 25,512,570.00 ###
339 285901 R$ 25,731,090.00 ###
340 288347 R$ 25,951,230.00 ###
341 290814 R$ 26,173,260.00 ###
342 293300 R$ 26,397,000.00 ###
343 295806 R$ 26,622,540.00 ###
344 298331 R$ 26,849,790.00 ###
345 300877 R$ 27,078,930.00 ###
346 303444 R$ 27,309,960.00 ###
347 306030 R$ 27,542,700.00 ###
348 308638 R$ 27,777,420.00 ###
Rendimento 349 311266 R$ 28,013,940.00 ###
350 313915 R$ 28,252,350.00 ###
351 316585 R$ 28,492,650.00 ###
352 319276 R$ 28,734,840.00 ###
353 321989 R$ 28,979,010.00 ###
354 324724 R$ 29,225,160.00 ###
355 327480 R$ 29,473,200.00 ###
1
356 330259 R$ 29,723,310.00 ###
357 333059 R$ 29,975,310.00 ###
358 335882 R$ 30,229,380.00 ###
359 338728 R$ 30,485,520.00 ###
360 341596 R$ 30,743,640.00 ###
Rendimento por m
300000
Quantas Cotas eu Compro? 250000

0
1 200000
Rendimento
3
150000
4
5
100000
7
8 50000
9
11 0
13 1 21 41 61 81 101121141161181201221241
13 Mês
16
16
19
19
21
23
24
26
27
29
30
32
33
35
37
38
40
42
43
45
47
48
50
52
53
56
57
59
60
63
64
66
68
70
72
73
76
77
80
81
84
85
87
90
91
94
95
98
100
102
104
106
109
110
113
115
118
119
122
124
127
129
131
133
136
139
141
143
146
148
151
153
156
158
161
164
166
169
172
174
177
180
182
186
188
191
194
196
200
202
206
208
212
214
218
220
224
227
230
233
236
239
243
246
249
253
256
259
263
266
270
273
276
281
283
288
290
295
298
302
306
309
314
317
321
324
329
333
337
340
345
349
353
357
361
366
370
374
378
383
387
391
396
401
405
409
414
419
423
428
433
438
442
448
452
457
462
467
473
477
483
487
493
498
504
508
514
520
525
531
536
542
547
553
559
565
570
576
583
588
594
601
606
613
619
625
631
638
644
651
657
664
670
677
684
691
697
704
712
718
725
733
739
747
754
762
769
776
784
791
799
807
815
822
831
838
846
854
863
871
878
888
895
905
912
922
930
938
948
957
965
974
984
993
1002
1011
1021
1030
1040
1049
1059
1069
1078
1089
1099
1108
1119
1129
1140
1150
1160
1171
1182
1192
1203
1215
1225
1236
1247
1259
1270
1282
1293
1305
1316
1329
1340
1352
1365
1376
1389
1401
1414
1427
1439
1452
1465
1477
1491
1505
1517
1531
1545
1558
1572
1585
1600
1614
1628
1642
1657
1672
1686
1700
1716
1731
1745
1761
1777
1792
1807
1824
1839
1855
1871
1888
1904
1920
1937
1954
1971
1988
2005
2022
2040
2057
2075
2093
2111
2129
2148
2166
2184
2204
2222
2241
2261
2279
2300
2319
2339
2358
2379
2400
2419
2441
2461
2482
2503
2524
2546
2568
2589
2612
2633
2656
2679
2701
2724
ndimento por mês
Rendimento
121141161181201221241261281301321341
Mês
HÁ 3 ABAS DIFERENTES COM PLANILHAS DIFERENTES EM CADA UMA DAS A
A PLANILHA SÓ FUNCIONA NO GOOGLE DRIVE (PLANILHAS GOOGLE). NO EX
PARA USAR A PLANILHA, BASTA CLICAR EM ARQUIVO E DEPOIS EM FAZER
Inflação Anual 5%
Rentabilidade Anual 13.75%
Rentabilidade Mensal 1.05%
Objetivo Renda MensalQuanto preciso terQuanto preciso ter considerando IR

R$ 100,000.00 R$ 9,523,809.52 R$ 11,204,481.79
R$ 500.00 R$ 47,619.05 R$ 56,022.41
R$ 1,300.00 R$ 123,809.52 R$ 145,658.26
R$ 2,000.00 R$ 190,476.19 R$ 224,089.64
CADA UMA DAS ABAS.
S GOOGLE). NO EXCEL ELA PODE APRESENTAR ERRO DE FÓRMULAS.
EPOIS EM FAZER UMA CÓPIA ou DOWNLOAD e SUBIR NO SEU DRIVE.
Objetivo Renda Mensal R$ 3,000.00

Prazo (anos) 20
Mês Quanto eu tenho Aporte Quanto rendeu

1 #NAME? #NAME? #NAME?
Quanto rendeu considerando IR
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?

SimuladorJuros Compostos

Enviado por

Direitos autorais:

Formatos disponíveis

SimuladorJuros Compostos

Enviado por

Dados do documento

Título original

Direitos autorais

Formatos disponíveis

Compartilhar este documento

Compartilhar ou incorporar documento

Opções de compartilhamento

Você considera este documento útil?

Este conteúdo é inapropriado?

Direitos autorais:

Formatos disponíveis

SimuladorJuros Compostos

Enviado por

Direitos autorais:

Formatos disponíveis

HÁ 3 ABAS DIFERENTES COM PLANILHAS DIFERENTES EM CADA UMA

A PLANILHA SÓ FUNCIONA NO GOOGLE DRIVE (PLANILHAS GOOGLE).

* O imposto só entra na hora de resgatar os investimentos.

Rendimento Mensal Aporte

Investimento Rendimento Quantas Cotas eu Compro?

Número de Cotas Valor

Mês Quantas Cotas eu Tenho? Valor das Cotas Rendimento

Quantas Cotas eu Compro? 250000

Objetivo Renda MensalQuanto preciso terQuanto preciso ter considerando IR

Objetivo Renda Mensal R$ 3,000.00

Mês Quanto eu tenho Aporte Quanto rendeu

Você também pode gostar