| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Mautic 12 Month Cash Flow Forecast | |||||||||||||
2 | Green = Planned renewals. Orange = new acquisitions | JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | |
3 | CASH INCOMES | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | TOTAL |
4 | Members (Individual) | $200.00 | $300.00 | $200.00 | $500.00 | $1,000.00 | $500.00 | $1,000.00 | $250.00 | $300.00 | $610.00 | $760.00 | $5,620.00 | |
5 | Members (Community) | $1,200.00 | $1,200.00 | $2,400.00 | $2,400.00 | $2,400.00 | $2,400.00 | $2,400.00 | $2,400.00 | $1,200.00 | $3,600.00 | $1,200.00 | $22,800.00 | |
6 | Members (Bronze) | $5,000.00 | $5,000.00 | $5,000.00 | $5,000.00 | $20,000.00 | ||||||||
7 | Members (Silver) | $10,000.00 | $10,000.00 | $10,000.00 | $30,000.00 | |||||||||
8 | Members (Gold) | $15,000.00 | $15,000.00 | $30,000.00 | ||||||||||
9 | Members (Platinum) | $0.00 | ||||||||||||
10 | Members (Diamond) | $30,000.00 | $30,000.00 | |||||||||||
11 | Monthly sponsors | $915.00 | $815.00 | $815.00 | $815.00 | $815.00 | $815.00 | $815.00 | $815.00 | $815.00 | $815.00 | $815.00 | $815.00 | $9,880.00 |
12 | One-time sponsors | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $600.00 |
13 | Event sponsors | $5,000.00 | $5,000.00 | $5,000.00 | $10,000.00 | $5,000.00 | $5,000.00 | $35,000.00 | ||||||
14 | Event tickets | $5,000.00 | $12,500.00 | $17,500.00 | ||||||||||
15 | Trials | $96.00 | $336.00 | $576.00 | $912.00 | $1,392.00 | $1,872.00 | $2,592.00 | $3,312.00 | $4,272.00 | $5,232.00 | $20,592.00 | ||
16 | Misc | $2,200.00 | $2,200.00 | |||||||||||
17 | Refunds | $0.00 | ||||||||||||
18 | Total Incomes | $30,965.00 | $2,265.00 | $7,461.00 | $18,801.00 | $14,341.00 | $25,177.00 | $20,157.00 | $11,137.00 | $16,107.00 | $10,677.00 | $31,547.00 | $35,557.00 | $224,192.00 |
19 | ||||||||||||||
20 | CASH OUTGOINGS | |||||||||||||
21 | Employment Project Lead | $8,685.28 | $8,685.28 | $8,685.28 | $8,685.28 | $8,685.28 | $8,685.28 | $8,685.28 | $8,685.28 | $8,685.28 | $8,685.28 | $8,685.28 | $8,685.28 | $104,223.36 |
22 | Consultants | $0.00 | ||||||||||||
23 | Payment Processor fees | |||||||||||||
24 | Open Collective host fees | $3,096.50 | $226.50 | $746.10 | $1,880.10 | $1,434.10 | $2,517.70 | $2,015.70 | $1,113.70 | $1,610.70 | $1,067.70 | $3,154.70 | $3,555.70 | $22,419.20 |
25 | Infrastructure | $6,543.97 | $333.97 | $333.97 | $333.97 | $1,077.97 | $333.97 | $333.97 | $333.97 | $333.97 | $333.97 | $333.97 | $333.97 | $10,961.64 |
31 | Supporting dependencies | $22,419.20 | $22,419.20 | |||||||||||
32 | Bounties | $246.00 | $246.00 | $246.00 | $246.00 | $246.00 | $246.00 | $246.00 | $246.00 | $246.00 | $246.00 | $246.00 | $246.00 | $2,952.00 |
33 | Legal | $417.00 | $417.00 | $417.00 | $417.00 | $417.00 | $417.00 | $417.00 | $417.00 | $417.00 | $417.00 | $417.00 | $417.00 | $5,004.00 |
34 | Travel & Expenditure | $604.00 | $604.00 | $604.00 | $604.00 | $604.00 | $604.00 | $604.00 | $604.00 | $604.00 | $604.00 | $604.00 | $604.00 | $7,248.00 |
35 | Administration | $0.00 | ||||||||||||
36 | Marketing | $206.00 | $206.00 | $206.00 | $206.00 | $206.00 | $206.00 | $206.00 | $206.00 | $206.00 | $206.00 | $206.00 | $206.00 | $2,472.00 |
37 | Contributor swag | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $480.00 |
38 | Events | $250.00 | $250.00 | $500.00 | ||||||||||
39 | Refund | $0.00 | ||||||||||||
40 | Total Outgoings | $19,838.75 | $10,758.75 | $11,528.35 | $12,412.35 | $12,710.35 | $13,049.95 | $12,547.95 | $11,895.95 | $12,142.95 | $11,599.95 | $36,106.15 | $14,087.95 | $178,679.40 |
41 | ||||||||||||||
42 | NET CASH FLOW | $11,126.25 | -$8,493.75 | -$4,067.35 | $6,388.65 | $1,630.65 | $12,127.05 | $7,609.05 | -$758.95 | $3,964.05 | -$922.95 | -$4,559.15 | $21,469.05 | $45,512.60 |
43 | ||||||||||||||
44 | Opening balance | $67,714.82 | $78,841.07 | $70,347.32 | $66,279.97 | $72,668.62 | $74,299.27 | $86,426.32 | $94,035.37 | $93,276.42 | $97,240.47 | $96,317.52 | $91,758.37 | |
45 | Closing balance | $78,841.07 | $70,347.32 | $66,279.97 | $72,668.62 | $74,299.27 | $86,426.32 | $94,035.37 | $93,276.42 | $97,240.47 | $96,317.52 | $91,758.37 | $113,227.42 | |
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 | ||||||||||||||
101 | ||||||||||||||
102 | ||||||||||||||
103 | ||||||||||||||
104 | ||||||||||||||
105 | ||||||||||||||