ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
 Get Started
3
Setup and timescale
4
5
 What is the name of your company? Company
6
7
What is the first date you want to forecast?
Jan-23
First month in the model; if this model is entirely a forecast of the future, input the first month you want to forecast from.
8
What is the fiscal year end of the first year modeled?
Dec-23
Define the month that is the fiscal year end of the first year in the model. This allows you to set the fiscal years in the model, and thus the # of months in the first year forecasted in the model. The default setting uses a formula to return the year end (in December) from the first month in the forecast. Feel free to overwrite this to set a different fiscal year end, just overwrite the formula with a date.
9
10
 Aggregation Options
only used for the aggregation options column (sum, average, initial, final)
11
 initial
returns the value from the beginning of a period
12
 final
returns the value from the end of a period
13
 sum
returns the total during the period
14
 average
returns the simple average during the period; averages are not weighted-averages, and for % growths, do not represent the average growth over the time period.
15
16
17
18
19
20
21
22
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