GOLD RETURNS.xlsx

	A	B	C	D	E	F	G	H	J	K	M
1	SGB: July 18-22, 2016	3119	3069								27
2	SGB Redemption: (26 MAY 2021)	4836.5
3	Nippon NAV 20/7/2016	13.63									30
4	Nippon NAV 26/05/2021	20.7
5	Gold price 20/7/2016	3199.8									31
6	Gold price 26/05/2021	5011
7	Investment amount	30,690									30
8
9
10
11			Physical (coin)	Physical (earing)	Physical (piece)	Digital	SGB	Nippon Gold Fund
12	Costs								SGB XIRR
13	Buy		-30690	-30690	-30690	-30690	-30690	-30690	20/7/2016	-30690
14	Making Charge		-2148.30	-8900.1	0	0	0	0	20/1/2017	383.63
15	GST		-985.15	-1187.70	-920.70	-920.70	0	0	20/7/2017	383.63
16	Total Cost	20/7/2016	-33823.45	-40777.80	-31610.70	-31610.70	-30690.00	-30690.00	20/1/2018	383.63
17									20/7/2018	383.63
18									20/1/2019	383.63
19									20/7/2019	383.63
20	Value on 26th MAY, 2021								20/1/2020	383.63
21	Value	26/05/2021	48061	48061	48061	48061	48365	46609.17	20/7/2020	383.63
22	Interest @2.5% p.a						3682.8		20/1/2021	383.63
23	Spread/ Exit load	26/05/2021	-1441.83	-1441.83		-1441.83			26/7/2021	48630
24									XIRR	11.59
25	Final Amount	26/05/2021	46619.17	46619.17	48061	46619.17	52047.8	46609.17
26	XIRR		6.84	2.80	9.02	8.34	11.6	8.99
27
28	Indexed Cost	20/7/2016	-34986.60	-34986.60	-34986.60	-34986.60	Tax-FREE	-34986.60
29	Sell		46619.17	46619.17	48061	46619.17	Tax-FREE	46609.17
30	Taxable capital gain		11632.57	11632.57	13074.40	11632.57	Tax-FREE	11622.57
31	Tax @20%		2326.51	2326.51	2614.88	2326.51	Tax-FREE	2324.51
32	Post tax profit		9306.06	9306.06	10459.52	9306.06		9298.06
33	Post tax XIRR		5.7	1.7	7.7	7.1	11.6	7.8
34
35	GOLD XIRR		9.7
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