Share
4,214 Posts.
lightbulb Created with Sketch. 1226
clock Created with Sketch.
10/01/22
03:04
Share
I repasted the spreadsheet to see if all the crap about Colgroups always appears. I saw in the preview that it did not go away. Any clues how to prevent that? I'll post it anyhow, because the new one included revenue growth percentages in the last few columns.
Column 1
Column 2
Column 3
Column 4
Column 5
Column 6
Column 7
Column 8
Column 9
Column 10
1
{colgroup}
2
{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}{col=86x@}{/col}
3
{/colgroup}
4
$ Xchange
1.38
5
Sizing factor
6.5
6
7
ACV for ANZ
Each 6 mths
Population
Per 1m folk
ACV for NA
Each 6 mths
Per 1m NA equivalent
Per 1m NA equivalent
NA:ANZ relativity
8
$A million
$US million
$US million
$A million
9
-Jun15
24.900
10
-Dec15
29.700
19.28%
1.0
11
-Jun16
34.400
15.82%
1.5
50.00%
12
-Dec16
37.000
7.56%
24.19
1.530
3.1
106.67%
0.020
0.027
1.78%
13
-Jun17
40.000
8.11%
24.358
1.642
5.3
70.97%
0.033
0.046
2.81%
14
-Dec17
43.300
8.25%
24.526
1.765
8.5
60.38%
0.053
0.074
4.17%
15
-Jun18
48.800
12.70%
24.696
1.976
12.9
51.76%
0.080
0.111
5.61%
16
-Dec18
53.300
9.22%
24.868
2.143
17.6
36.43%
0.109
0.150
7.01%
17
-Jun19
57.900
8.63%
25.040
2.312
22.7
28.98%
0.139
0.192
8.32%
18
-Dec19
61.000
5.35%
25.213
2.419
24.9
9.69%
0.152
0.210
8.67%
19
-Jun20
64.500
5.74%
25.388
2.541
28.8
15.66%
0.175
0.241
9.48%
20
-Dec20
66.600
3.26%
25.564
2.605
35.1
21.88%
0.211
0.292
11.19%
21
-Jun21
69.000
3.60%
25.741
2.681
44.5
26.78%
0.266
0.367
13.69%
22
23
ACV for ANZ
Each 6 mths
Population
Per 1m folk
ACV for NA
Each 6 mths
Per 1m NA equivalent
Per 1m NA equivalent
NA:ANZ relativity
24
$A million
$US million
$US million
$A million
25
-Dec21
71.070
3.00%
25.920
2.742
56.515
27.00%
0.335
0.463
16.88%
26
-Jun22
73.202
3.00%
26.099
2.805
70.926
25.50%
0.418
0.577
20.57%
27
-Dec22
75.398
3.00%
26.280
2.869
88.008
24.08%
0.515
0.711
24.78%
28
-Jun23
77.660
3.00%
26.462
2.935
108.025
22.75%
0.628
0.867
29.53%
29
-Dec23
79.990
3.00%
26.646
3.002
131.231
21.48%
0.758
1.046
34.83%
30
-Jun24
82.390
3.00%
26.830
3.071
157.856
20.29%
0.905
1.249
40.68%
31
-Dec24
84.861
3.00%
27.016
3.141
188.103
19.16%
1.071
1.478
47.06%
32
-Jun25
87.407
3.00%
27.203
3.213
222.143
18.10%
1.256
1.734
53.96%
33
34
Total ACV
Est Revenue
35
$A million
$A million
36
130.41
122.724
37
-Dec21
149.061
139.735
13.86%
38
-Jun22
171.080
160.071
14.55%
39
-Dec22
196.849
183.965
14.93%
40
-Jun23
226.735
211.792
15.13%
41
-Dec23
261.089
243.912
15.17%
42
-Jun24
300.231
280.660
15.07%
43
-Dec24
344.443
322.337
14.85%
44
-Jun25
393.965
369.204
14.54%