DCA - Damn i need to learn excel

	A	B	C	D	G	H	I	J	L
1	Scenario A – Lump Sum				Scenario B – Dollar Cost Averaging
2
3	Month	Amount	Bitcoin Price	Bitcoin	Month	Amount	Bitcoin Price	Bitcoin
4	1	RM120,000.00	400	300.00	1	RM100.00	400	0.25
5	2	RM0.00	410	0.00	2	RM100.00	410	0.24
6	3	RM0.00	385	0.00	3	RM100.00	385	0.26
7	4	RM0.00	375	0.00	4	RM100.00	375	0.27
8	5	RM0.00	340	0.00	5	RM100.00	340	0.29
9	6	RM0.00	350	0.00	6	RM100.00	350	0.29
10	7	RM0.00	300	0.00	7	RM100.00	300	0.33
11	8	RM0.00	320	0.00	8	RM100.00	320	0.31
12	9	RM0.00	380	0.00	9	RM100.00	380	0.26
13	10	RM0.00	410	0.00	10	RM100.00	410	0.24
14	11	RM0.00	430	0.00	11	RM100.00	430	0.23
15	12	RM0.00	450	0.00	12	RM100.00	450	0.22	Value Cost Average
16
17	Total	RM120,000.00		300.00	Total	RM1,200.00		3.21
18
19
20
21
22	Total bitcoin worth			RM135,000.00	Total bitcoin worth			RM1,443.52
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
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