So I did some simple forecasting and predictive analysis on CIG costs.
Expenses Percentage Increase over Prior Year--------------------------------------------------------------Year------------------Series---------------Expenses
0.8923070824 | 16 | 1 | 45,016 | 1.085502932 | 17 | 2 | 48,865 | 1.149432109 | 18 | 3 | 56,167 | 1.25395695 | 19 | 4 | 70,431 | 1.382519463 | 20 | 5 | 97,372 | 1.497407341 | 21 | 6 | 145,806 | 1.612295219 | 22 | 7 | 235,082 |
| |
|
2019's expenses were 70,431 thousand. The model predicted 2019's expenses as 1.299539068 percent over prior year, or 72,991 thousand. This is +2.56 million off, but it's only a 0.045582118 difference, so within the margin of error.
IF CIG's expenses follow the model from past trends, they're looking at a ballpark of 97,372 thousands in 2020 expenses. Note that 2020 is looking to bring in about 78.6 million.
My bias would put 2020 closer to ~$86 million, due to a small increase in headcount and expenses in DevOps to set up "work at home" networks throughout the year, plus bandwidth usage and compensation.
IF CIG's expenses follow the model from past trends, and if 2020 is within the margin of error on the model, they're looking at a ballpark of 145,806 thousands in 2021 expenses.
Under the kindest of circumstances, meaning CIG manages expenses better than the model predicts, and backer put in
MORE money than the prior year, CIG is looking at depleting their Calder Warchest sometime in 2023. Considering CIG is looking to wholesale increase their headcount by 15% at least from the announced Montreal office, plus expansion of the Derby office, expenses aren't going to decrease meaningfully.
This is looking like Expand or Die territory.
Something has to happen in 2022 or early 2023.
Note: This model is only based on the reported total costs. I might do a line for line expenses model for a more "accurate" guess.