Capitaland to CLIM, CICT and Cash

	K	L	M	N	O
1	Update manually
2	Otherwise, the cell will likely be hardcoded or formula linked
3
4
5	Capitaland Share Price	$3.750		Discount	11.72%
6	CICT Share Price	$2.100
7
8	CLIM NAV	$2.823
9	Cash	$0.951
10	CICT (0.155 Share)	$0.326
11	FY2020 Dividend	$0.090
12
13	Total	$4.190
14
15
16
17
18	Number of Capitaland Shares	1000
19
20	CICT Odd Lot	155
21
22	Number of Capitaland Shares	CICT Shares	Odd Lot?
23	1000	155	55
24	1100	170.5	70.5
25	1200	186	86
26	1300	201.5	1.5
27	1400	217	17
28	1500	232.5	32.5
29	1600	248	48
30	1700	263.5	63.5
31	1800	279	79
32	1900	294.5	94.5
33	2000	310	10
34	2100	325.5	25.5
35	2200	341	41
36	2300	356.5	56.5
37	2400	372	72
38	2500	387.5	87.5
39	2600	403	3
40	2700	418.5	18.5
41	2800	434	34
42	2900	449.5	49.5
43	3000	465	65
44	3100	480.5	80.5
45	3200	496	96
46	3300	511.5	11.5
47	3400	527	27
48	3500	542.5	42.5
49	3600	558	58
50	3700	573.5	73.5
51	3800	589	89
52	3900	604.5	4.5
53	4000	620	20
54	4100	635.5	35.5
55	4200	651	51
56	4300	666.5	66.5
57	4400	682	82
58	4500	697.5	97.5
59	4600	713	13
60	4700	728.5	28.5
61	4800	744	44
62	4900	759.5	59.5
63	5000	775	75
64	5100	790.5	90.5
65	5200	806	6
66	5300	821.5	21.5
67	5400	837	37
68	5500	852.5	52.5
69	5600	868	68
70	5700	883.5	83.5
71	5800	899	99
72	5900	914.5	14.5
73	6000	930	30
74	6100	945.5	45.5
75	6200	961	61
76	6300	976.5	76.5
77	6400	992	92
78	6500	1007.5	7.5
79	6600	1023	23
80	6700	1038.5	38.5
81	6800	1054	54
82	6900	1069.5	69.5
83	7000	1085	85
84	7100	1100.5	0.5
85	7200	1116	16
86	7300	1131.5	31.5
87	7400	1147	47
88	7500	1162.5	62.5
89	7600	1178	78
90	7700	1193.5	93.5
91	7800	1209	9
92	7900	1224.5	24.5
93	8000	1240	40
94	8100	1255.5	55.5
95	8200	1271	71
96	8300	1286.5	86.5
97	8400	1302	2
98	8500	1317.5	17.5
99	8600	1333	33
100	8700	1348.5	48.5