planilha de rentabilidade dicasdodi blogspot

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

cálculo de rentabilidade
	Calcule quanto renderá seu investimento - oferecimento: http://dicasdodi.blogspot.com
	
	
		investimento inicial	R$ 250,000.00	Insira o valor inicial que você possuí para investir
		depósitos mensais	R$ 4,000.00	Insira quanto você irá depositar mensalmente no seu investimento				Visite regularmente o blog Dicas do Di e obtenha dicas sobre Educação Financeira.
		rendimento mensal	0.60%	Digite a taxa de juros mensal do seu investimento
	
	anos	meses	montante total	montante sem juros	juros totais			Guia de uso da planilha: Insira os dados de investimento inicial, depósitos mensais, e rendimento mensal nos campos correspondentes.
		1	R$254,000.00	R$254,000.00	R$0.00
		2	R$259,548.00	R$258,000.00	R$1,548.00
		3	R$265,129.29	R$262,000.00	R$3,129.29
		4	R$270,744.06	R$266,000.00	R$4,744.06
		5	R$276,392.53	R$270,000.00	R$6,392.53			Caso você tenha apenas o rendimento anual do investimento, o divida por 12 (investimento/12) e o insira o resultado no rendimento mensal
		6	R$282,074.88	R$274,000.00	R$8,074.88
		7	R$287,791.33	R$278,000.00	R$9,791.33
		8	R$293,542.08	R$282,000.00	R$11,542.08
		9	R$299,327.33	R$286,000.00	R$13,327.33
		10	R$305,147.30	R$290,000.00	R$15,147.30
		11	R$311,002.18	R$294,000.00	R$17,002.18			Você pode acompanhar na planilha, o montante sem juros, ou seja quanto você teria se apenas fosse juntando o dinheiro.
	1 ano	12	R$316,892.19	R$298,000.00	R$18,892.19
		13	R$322,817.55	R$302,000.00	R$20,817.55
		14	R$328,778.45	R$306,000.00	R$22,778.45
		15	R$334,775.12	R$310,000.00	R$24,775.12
		16	R$340,807.77	R$314,000.00	R$26,807.77
		17	R$346,876.62	R$318,000.00	R$28,876.62			Na coluna de juros totais observe o valor do seu rendimento mês a mês, quanto você está ganhando apenas por não utilizar esse dinheiro.
		18	R$352,981.88	R$322,000.00	R$30,981.88
		19	R$359,123.77	R$326,000.00	R$33,123.77
		20	R$365,302.51	R$330,000.00	R$35,302.51
		21	R$371,518.33	R$334,000.00	R$37,518.33
		22	R$377,771.44	R$338,000.00	R$39,771.44
		23	R$384,062.07	R$342,000.00	R$42,062.07
	2 anos	24	R$390,390.44	R$346,000.00	R$44,390.44
		25	R$396,756.78	R$350,000.00	R$46,756.78
		26	R$403,161.32	R$354,000.00	R$49,161.32
		27	R$409,604.29	R$358,000.00	R$51,604.29
		28	R$416,085.92	R$362,000.00	R$54,085.92
		29	R$422,606.43	R$366,000.00	R$56,606.43
		30	R$429,166.07	R$370,000.00	R$59,166.07
		31	R$435,765.07	R$374,000.00	R$61,765.07
		32	R$442,403.66	R$378,000.00	R$64,403.66
		33	R$449,082.08	R$382,000.00	R$67,082.08
		34	R$455,800.57	R$386,000.00	R$69,800.57
		35	R$462,559.38	R$390,000.00	R$72,559.38
	3 anos	36	R$469,358.73	R$394,000.00	R$75,358.73
		37	R$476,198.88	R$398,000.00	R$78,198.88
		38	R$483,080.08	R$402,000.00	R$81,080.08
		39	R$490,002.56	R$406,000.00	R$84,002.56
		40	R$496,966.57	R$410,000.00	R$86,966.57
		41	R$503,972.37	R$414,000.00	R$89,972.37
		42	R$511,020.21	R$418,000.00	R$93,020.21
		43	R$518,110.33	R$422,000.00	R$96,110.33
		44	R$525,242.99	R$426,000.00	R$99,242.99
		45	R$532,418.45	R$430,000.00	R$102,418.45
		46	R$539,636.96	R$434,000.00	R$105,636.96
		47	R$546,898.78	R$438,000.00	R$108,898.78
	4 anos	48	R$554,204.17	R$442,000.00	R$112,204.17
		49	R$561,553.40	R$446,000.00	R$115,553.40
		50	R$568,946.72	R$450,000.00	R$118,946.72
		51	R$576,384.40	R$454,000.00	R$122,384.40
		52	R$583,866.71	R$458,000.00	R$125,866.71
		53	R$591,393.91	R$462,000.00	R$129,393.91
		54	R$598,966.27	R$466,000.00	R$132,966.27
		55	R$606,584.07	R$470,000.00	R$136,584.07
		56	R$614,247.57	R$474,000.00	R$140,247.57
		57	R$621,957.06	R$478,000.00	R$143,957.06
		58	R$629,712.80	R$482,000.00	R$147,712.80
		59	R$637,515.08	R$486,000.00	R$151,515.08
	5 anos	60	R$645,364.17	R$490,000.00	R$155,364.17
		61	R$653,260.35	R$494,000.00	R$159,260.35
		62	R$661,203.91	R$498,000.00	R$163,203.91
		63	R$669,195.14	R$502,000.00	R$167,195.14
		64	R$677,234.31	R$506,000.00	R$171,234.31
		65	R$685,321.71	R$510,000.00	R$175,321.71
		66	R$693,457.64	R$514,000.00	R$179,457.64
		67	R$701,642.39	R$518,000.00	R$183,642.39
		68	R$709,876.24	R$522,000.00	R$187,876.24
		69	R$718,159.50	R$526,000.00	R$192,159.50
		70	R$726,492.46	R$530,000.00	R$196,492.46
		71	R$734,875.41	R$534,000.00	R$200,875.41
	6 anos	72	R$743,308.67	R$538,000.00	R$205,308.67
		73	R$751,792.52	R$542,000.00	R$209,792.52
		74	R$760,327.27	R$546,000.00	R$214,327.27
		75	R$768,913.24	R$550,000.00	R$218,913.24
		76	R$777,550.72	R$554,000.00	R$223,550.72
		77	R$786,240.02	R$558,000.00	R$228,240.02
		78	R$794,981.46	R$562,000.00	R$232,981.46
		79	R$803,775.35	R$566,000.00	R$237,775.35
		80	R$812,622.00	R$570,000.00	R$242,622.00
		81	R$821,521.73	R$574,000.00	R$247,521.73
		82	R$830,474.86	R$578,000.00	R$252,474.86
		83	R$839,481.71	R$582,000.00	R$257,481.71
	7 anos	84	R$848,542.60	R$586,000.00	R$262,542.60
		85	R$857,657.86	R$590,000.00	R$267,657.86
		86	R$866,827.81	R$594,000.00	R$272,827.81
		87	R$876,052.77	R$598,000.00	R$278,052.77
		88	R$885,333.09	R$602,000.00	R$283,333.09
		89	R$894,669.09	R$606,000.00	R$288,669.09
		90	R$904,061.10	R$610,000.00	R$294,061.10
		91	R$913,509.47	R$614,000.00	R$299,509.47
		92	R$923,014.53	R$618,000.00	R$305,014.53
		93	R$932,576.61	R$622,000.00	R$310,576.61
		94	R$942,196.07	R$626,000.00	R$316,196.07
		95	R$951,873.25	R$630,000.00	R$321,873.25
	8 anos	96	R$961,608.49	R$634,000.00	R$327,608.49
		97	R$971,402.14	R$638,000.00	R$333,402.14
		98	R$981,254.55	R$642,000.00	R$339,254.55
		99	R$991,166.08	R$646,000.00	R$345,166.08
		100	R$1,001,137.08	R$650,000.00	R$351,137.08
		101	R$1,011,167.90	R$654,000.00	R$357,167.90
		102	R$1,021,258.91	R$658,000.00	R$363,258.91
		103	R$1,031,410.46	R$662,000.00	R$369,410.46
		104	R$1,041,622.92	R$666,000.00	R$375,622.92
		105	R$1,051,896.66	R$670,000.00	R$381,896.66
		106	R$1,062,232.04	R$674,000.00	R$388,232.04
		107	R$1,072,629.43	R$678,000.00	R$394,629.43
	9 anos	108	R$1,083,089.21	R$682,000.00	R$401,089.21
		109	R$1,093,611.74	R$686,000.00	R$407,611.74
		110	R$1,104,197.41	R$690,000.00	R$414,197.41
		111	R$1,114,846.60	R$694,000.00	R$420,846.60
		112	R$1,125,559.68	R$698,000.00	R$427,559.68
		113	R$1,136,337.04	R$702,000.00	R$434,337.04
		114	R$1,147,179.06	R$706,000.00	R$441,179.06
		115	R$1,158,086.13	R$710,000.00	R$448,086.13
		116	R$1,169,058.65	R$714,000.00	R$455,058.65
		117	R$1,180,097.00	R$718,000.00	R$462,097.00
		118	R$1,191,201.58	R$722,000.00	R$469,201.58
		119	R$1,202,372.79	R$726,000.00	R$476,372.79
	10 anos	120	R$1,213,611.03	R$730,000.00	R$483,611.03
		121	R$1,224,916.70	R$734,000.00	R$490,916.70
		122	R$1,236,290.20	R$738,000.00	R$498,290.20
		123	R$1,247,731.94	R$742,000.00	R$505,731.94
		124	R$1,259,242.33	R$746,000.00	R$513,242.33
		125	R$1,270,821.78	R$750,000.00	R$520,821.78
		126	R$1,282,470.71	R$754,000.00	R$528,470.71
		127	R$1,294,189.54	R$758,000.00	R$536,189.54
		128	R$1,305,978.68	R$762,000.00	R$543,978.68
		129	R$1,317,838.55	R$766,000.00	R$551,838.55
		130	R$1,329,769.58	R$770,000.00	R$559,769.58
		131	R$1,341,772.20	R$774,000.00	R$567,772.20
	11 anos	132	R$1,353,846.83	R$778,000.00	R$575,846.83
		133	R$1,365,993.91	R$782,000.00	R$583,993.91
		134	R$1,378,213.87	R$786,000.00	R$592,213.87
		135	R$1,390,507.16	R$790,000.00	R$600,507.16
		136	R$1,402,874.20	R$794,000.00	R$608,874.20
		137	R$1,415,315.45	R$798,000.00	R$617,315.45
		138	R$1,427,831.34	R$802,000.00	R$625,831.34
		139	R$1,440,422.33	R$806,000.00	R$634,422.33
		140	R$1,453,088.86	R$810,000.00	R$643,088.86
		141	R$1,465,831.39	R$814,000.00	R$651,831.39
		142	R$1,478,650.38	R$818,000.00	R$660,650.38
		143	R$1,491,546.28	R$822,000.00	R$669,546.28
	12 anos	144	R$1,504,519.56	R$826,000.00	R$678,519.56
		145	R$1,517,570.68	R$830,000.00	R$687,570.68
		146	R$1,530,700.10	R$834,000.00	R$696,700.10
		147	R$1,543,908.30	R$838,000.00	R$705,908.30
		148	R$1,557,195.75	R$842,000.00	R$715,195.75
		149	R$1,570,562.93	R$846,000.00	R$724,562.93
		150	R$1,584,010.31	R$850,000.00	R$734,010.31
		151	R$1,597,538.37	R$854,000.00	R$743,538.37
		152	R$1,611,147.60
R$858,000.00	R$753,147.60
		153	R$1,624,838.48	R$862,000.00	R$762,838.48
		154	R$1,638,611.51	R$866,000.00	R$772,611.51
		155	R$1,652,467.18	R$870,000.00	R$782,467.18
	13 anos	156	R$1,666,405.99	R$874,000.00	R$792,405.99
		157	R$1,680,428.42	R$878,000.00	R$802,428.42
		158	R$1,694,534.99	R$882,000.00	R$812,534.99
		159	R$1,708,726.20	R$886,000.00	R$822,726.20
		160	R$1,723,002.56	R$890,000.00	R$833,002.56
		161	R$1,737,364.58	R$894,000.00	R$843,364.58
		162	R$1,751,812.76	R$898,000.00	R$853,812.76
		163	R$1,766,347.64	R$902,000.00	R$864,347.64
		164	R$1,780,969.73	R$906,000.00	R$874,969.73
		165	R$1,795,679.54	R$910,000.00	R$885,679.54
		166	R$1,810,477.62	R$914,000.00	R$896,477.62
		167	R$1,825,364.49	R$918,000.00	R$907,364.49
	14 anos	168	R$1,840,340.67	R$922,000.00	R$918,340.67
		169	R$1,855,406.72	R$926,000.00	R$929,406.72
		170	R$1,870,563.16	R$930,000.00	R$940,563.16
		171	R$1,885,810.54	R$934,000.00	R$951,810.54
		172	R$1,901,149.40	R$938,000.00	R$963,149.40
		173	R$1,916,580.30	R$942,000.00	R$974,580.30
		174	R$1,932,103.78	R$946,000.00	R$986,103.78
		175	R$1,947,720.40	R$950,000.00	R$997,720.40
		176	R$1,963,430.72	R$954,000.00	R$1,009,430.72
		177	R$1,979,235.31	R$958,000.00	R$1,021,235.31
		178	R$1,995,134.72	R$962,000.00	R$1,033,134.72
		179	R$2,011,129.53	R$966,000.00	R$1,045,129.53
	15 anos	180	R$2,027,220.30	R$970,000.00	R$1,057,220.30
		181	R$2,043,407.63	R$974,000.00	R$1,069,407.63
		182	R$2,059,692.07	R$978,000.00	R$1,081,692.07
		183	R$2,076,074.22	R$982,000.00	R$1,094,074.22
		184	R$2,092,554.67	R$986,000.00	R$1,106,554.67
		185	R$2,109,134.00	R$990,000.00	R$1,119,134.00
		186	R$2,125,812.80	R$994,000.00	R$1,131,812.80
		187	R$2,142,591.68	R$998,000.00	R$1,144,591.68
		188	R$2,159,471.23	R$1,002,000.00	R$1,157,471.23
		189	R$2,176,452.06	R$1,006,000.00	R$1,170,452.06
		190	R$2,193,534.77	R$1,010,000.00	R$1,183,534.77
		191	R$2,210,719.98	R$1,014,000.00	R$1,196,719.98
	16 anos	192	R$2,228,008.30	R$1,018,000.00	R$1,210,008.30
		193	R$2,245,400.35	R$1,022,000.00	R$1,223,400.35
		194	R$2,262,896.75	R$1,026,000.00	R$1,236,896.75
		195	R$2,280,498.13	R$1,030,000.00	R$1,250,498.13
		196	R$2,298,205.12	R$1,034,000.00	R$1,264,205.12
		197	R$2,316,018.35	R$1,038,000.00	R$1,278,018.35
		198	R$2,333,938.46	R$1,042,000.00	R$1,291,938.46
		199	R$2,351,966.09	R$1,046,000.00	R$1,305,966.09
		200	R$2,370,101.89	R$1,050,000.00	R$1,320,101.89
		201	R$2,388,346.50	R$1,054,000.00	R$1,334,346.50
		202	R$2,406,700.58	R$1,058,000.00	R$1,348,700.58
		203	R$2,425,164.78	R$1,062,000.00	R$1,363,164.78
	17 anos	204	R$2,443,739.77	R$1,066,000.00	R$1,377,739.77
		205	R$2,462,426.21	R$1,070,000.00	R$1,392,426.21
		206	R$2,481,224.76	R$1,074,000.00	R$1,407,224.76
		207	R$2,500,136.11	R$1,078,000.00	R$1,422,136.11
		208	R$2,519,160.93	R$1,082,000.00	R$1,437,160.93
		209	R$2,538,299.90	R$1,086,000.00	R$1,452,299.90
		210	R$2,557,553.70	R$1,090,000.00	R$1,467,553.70
		211	R$2,576,923.02	R$1,094,000.00	R$1,482,923.02
		212	R$2,596,408.56	R$1,098,000.00	R$1,498,408.56
		213	R$2,616,011.01	R$1,102,000.00	R$1,514,011.01
		214	R$2,635,731.07	R$1,106,000.00	R$1,529,731.07
		215	R$2,655,569.46	R$1,110,000.00	R$1,545,569.46
	18 anos	216	R$2,675,526.88	R$1,114,000.00	R$1,561,526.88
		217	R$2,695,604.04	R$1,118,000.00	R$1,577,604.04
		218	R$2,715,801.66	R$1,122,000.00	R$1,593,801.66
		219	R$2,736,120.47	R$1,126,000.00	R$1,610,120.47
		220	R$2,756,561.19	R$1,130,000.00	R$1,626,561.19
		221	R$2,777,124.56	R$1,134,000.00	R$1,643,124.56
		222	R$2,797,811.31	R$1,138,000.00	R$1,659,811.31
		223	R$2,818,622.18	R$1,142,000.00	R$1,676,622.18
		224	R$2,839,557.91	R$1,146,000.00	R$1,693,557.91
		225	R$2,860,619.26	R$1,150,000.00	R$1,710,619.26
		226	R$2,881,806.97	R$1,154,000.00	R$1,727,806.97
		227	R$2,903,121.81	R$1,158,000.00	R$1,745,121.81
	19 anos	228	R$2,924,564.55	R$1,162,000.00	R$1,762,564.55
		229	R$2,946,135.93	R$1,166,000.00	R$1,780,135.93
		230	R$2,967,836.75	R$1,170,000.00	R$1,797,836.75
		231	R$2,989,667.77	R$1,174,000.00	R$1,815,667.77
		232	R$3,011,629.78	R$1,178,000.00	R$1,833,629.78
		233	R$3,033,723.55	R$1,182,000.00	R$1,851,723.55
		234	R$3,055,949.90	R$1,186,000.00	R$1,869,949.90
		235	R$3,078,309.59	R$1,190,000.00	R$1,888,309.59
		236	R$3,100,803.45	R$1,194,000.00	R$1,906,803.45
		237	R$3,123,432.27	R$1,198,000.00	R$1,925,432.27
		238	R$3,146,196.87	R$1,202,000.00	R$1,944,196.87
		239	R$3,169,098.05	R$1,206,000.00	R$1,963,098.05
	20 anos	240	R$3,192,136.64	R$1,210,000.00	R$1,982,136.64