Compounding - Google Drive


1			Explication
2	Weeks per year	52.14285714	365/7
3	Initial cake	4000	investissement initial
4	gain cake after exactly 24h 00 min 00 s	26.67000	Ce que j'ai farme
5	Yearly gain after 365 period no compouding	9734.5500	26.67*365
6	Weekly gain after 7 days no compounding	186.6900	cakes B4 X 7
7	Check 52.14 weeks to year	9734.5500	pareil que B4
8	Yearly APR no reinvest	243.36%
9	Weekly APR no reinvest	4.67%
10
11	# week	Cake initial	Gain no compound	Cake balance with gain week before no compound	Gain compound	Cake balance with gain week before no compound
12	0	4000
13	1		186.690	4,186.690	186.690	4,186.690
14	2		186.690	4,373.380	195.403	4,382.093
15	3		186.690	4,560.070	204.523	4,586.617
16	4		186.690	4,746.760	214.069	4,800.685
17	5		186.690	4,933.450	224.060	5,024.745
18	6		186.690	5,120.140	234.517	5,259.263
19	7		186.690	5,306.830	245.463	5,504.726
20	8		186.690	5,493.520	256.919	5,761.645
21	9		186.690	5,680.210	268.910	6,030.555
22	10		186.690	5,866.900	281.461	6,312.017
23	11		186.690	6,053.590	294.598	6,606.614
24	12		186.690	6,240.280	308.347	6,914.961
25	13		186.690	6,426.970	322.739	7,237.700
26	14		186.690	6,613.660	337.802	7,575.501
27	15		186.690	6,800.350	353.568	7,929.069
28	16		186.690	6,987.040	370.069	8,299.138
29	17		186.690	7,173.730	387.342	8,686.480
30	18		186.690	7,360.420	405.420	9,091.900
31	19		186.690	7,547.110	424.342	9,516.241
32	20		186.690	7,733.800	444.147	9,960.388
33	21		186.690	7,920.490	464.876	10,425.264
34	22		186.690	8,107.180	486.573	10,911.838
35	23		186.690	8,293.870	509.283	11,421.120
36	24		186.690	8,480.560	533.052	11,954.173
37	25		186.690	8,667.250	557.931	12,512.104
38	26		186.690	8,853.940	583.971	13,096.075
39	27		186.690	9,040.630	611.227	13,707.301
40	28		186.690	9,227.320	639.754	14,347.055
41	29		186.690	9,414.010	669.613	15,016.668
42	30		186.690	9,600.700	700.865	15,717.534
43	31		186.690	9,787.390	733.577	16,451.110
44	32		186.690	9,974.080	767.814	17,218.925
45	33		186.690	10,160.770	803.650	18,022.575
46	34		186.690	10,347.460	841.159	18,863.734
47	35		186.690	10,534.150	880.418	19,744.151
48	36		186.690	10,720.840	921.509	20,665.660
49	37		186.690	10,907.530	964.518	21,630.178
50	38		186.690	11,094.220	1,009.535	22,639.713
51	39		186.690	11,280.910	1,056.652	23,696.365
52	40		186.690	11,467.600	1,105.969	24,802.333
53	41		186.690	11,654.290	1,157.587	25,959.920
54	42		186.690	11,840.980	1,211.614	27,171.535
55	43		186.690	12,027.670	1,268.163	28,439.698
56	44		186.690	12,214.360	1,327.352	29,767.050
57	45		186.690	12,401.050	1,389.303	31,156.353
58	46		186.690	12,587.740	1,454.145	32,610.498
59	47		186.690	12,774.430	1,522.013	34,132.511
60	48		186.690	12,961.120	1,593.050	35,725.561
61	49		186.690	13,147.810	1,667.401	37,392.962
62	50		186.690	13,334.500	1,745.223	39,138.185
63	51		186.690	13,521.190	1,826.677	40,964.862
64	52		186.690	13,707.880	1,911.933	42,876.794
65
66	SUM		9,707.880	13,707.880	38,876.794	42,876.794
67
68			Initial Check	4,000.000		4,000.000
69				OK		OK
70
71
72			APR calcul pas de reinvestissement	242.70%		971.92%	APY calcul AVEC reinvestissement
73
74
75			Difference entre le 9707 obtenu en C66 et le 9734 en B5 viens du fait que j'ai fais calcul sur 52 semaines et non 52.14 semaines.