Another Assignment

profileBatman007
Innovare-ProposedModelLayout.2021.07.31v1.xlsx
Home>Business & Finance homework help>Operations Management homework help>Another Assignment

Open Items

Sales Funnel Need to add input cells for starting marketing budgets in cells C6 and D6 DASHBOARD IDEAS
Sales Funnel Need to add efficiency rates when building out future years Marketing Metrics
Sales Funnel Need to include timing for each stage of funnel (prospect - 90 days, MQL - 60 days, SQL - 14 days, Opportunity 30 days) Cost per Visit
Sales Funnel What are assumptions regarding Early Renewals and Normal Renewals? Cost per SL
Sales Funnel/Sales Goals Consider connecting these two tabs Cost per MQL
Revenue Need Renewal Revenue - what are assumptions RE: churn by market and segment (currently 90% for all on Customer Count tab) Cost per opportunity (CAC?)
OpEx Address notes throughout Sales Metrics
Will CS Reps be contractor or employees? # SQL
Will R&D labor be contractor or employees? # Opportunities
Should track taxes, benefits and other fringe benefits for each employee type within that area of P&L ARR
Other Service income not factored in Pipeline Revenue
How to model discounts? Booked (New) Revenue
Do we need a 3-year or 5-year model? # Closed Deals
Expectations for full balance sheet and traditional cash flow statement # Renewals
Inputs Tab Add inputs tab when nearly complete for easy updating Renewal Rate
Renewal Revenue
Customer Info
# Total Closed Deals + Renewals
# Cumulative Active Customers
Operating
Sales Growth
Customer Support as % of Revenue
Gross Margin
Sales & Marketing as % of Revenue
Operating Expeses as % of Revenue
EBITDA
EBITDA Growth Rate

Inputs

Sales Funnel

7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 1/1/22 2/1/22 3/1/22 4/1/22 5/1/22 6/1/22 7/1/22 8/1/22 9/1/22 10/1/22 11/1/22 12/1/22 1/1/23 2/1/23 3/1/23 4/1/23 5/1/23 6/1/23 7/1/23 8/1/23 9/1/23 10/1/23 11/1/23 12/1/23 1/1/24 2/1/24 3/1/24 4/1/24 5/1/24 6/1/24 Total
TARGET
Marketing YoY Growth 20.0% 1.67% 1.67% 1.67% 1.67% 1.67% 1.67% 1.67% 1.67% 1.67% 1.67% 1.67% 1.67% 20%
Marketing Costs $2,388,621 $11,043 $198,727 $202,039 $205,406 $208,830 $212,310 $215,849 $219,446 $223,104 $226,822 $230,603 $234,446 $2,388,626
Cost per Visit $0.21 $0.21 $0.21 $0.21 $0.21 $0.21 $0.21 $0.21 $0.21 $0.21 $0.21 $0.21 $0.21 $0.21
Cost per SL $4.26 $4.26 $4.26 $4.26 $4.26 $4.26 $4.26 $4.26 $4.26 $4.26 $4.26 $4.26 $4.26 $4.26
Cost per prospect $14.19 $14.19 $14.19 $14.19 $14.19 $14.19 $14.19 $14.19 $14.19 $14.19 $14.19 $14.19 $14.19 $14.19
Cost per MQL $94.59 $94.38 $94.59 $94.59 $94.57 $94.58 $94.57 $94.59 $94.59 $94.58 $94.59 $94.59 $94.57 $94.58
Cost per opportunity $1,910.90 $1,840.50 $4,731.60 $2,590.25 $4,890.63 $4,972.14 $5,055.01 $1,713.09 $1,741.64 $1,770.67 $1,085.27 $1,103.36 $1,121.75 $1,900.26
Anonymous Visitor 51,887 933,753 949,316 965,138 981,223 997,577 1,014,203 1,031,107 1,048,292 1,065,763 1,083,526 1,101,585 11,223,370
Filter Noise 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%
Simple Lead 2,594 46,688 47,466 48,257 49,061 49,879 50,710 51,555 52,415 53,288 54,176 55,079 561,168
Qualifying Lead Rate 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0%
Prospect Goal 778 14,006 14,240 14,477 14,718 14,964 15,213 15,467 15,725 15,986 16,253 16,524 168,351
Prospect Conversion Rate 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0%
MQL Goal 117 2,101 2,136 2,172 2,208 2,245 2,282 2,320 2,359 2,398 2,438 2,479 25,255
MQL Conversion Rate 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0%
SQL Goal 18 315 320 326 331 337 342 348 354 360 366 372 3,789
SQL Conversion YR1 Ramp-Up 10.0% 10.0% 30.0% 50.0%
SQL Conversion Rate 33.0% 33.0% 13.3% 33.0% 33.0% 33.0% 33.0% 33.0% 33.0% 33.0% 33.0% 33.0% 33.0%
Opportunity Goal 6 42 78 42 42 42 126 126 126 209 209 209 1,257
Opportunity Close Rate 16.4% 16.4% 16.4% 16.4% 16.4% 16.4% 16.4% 16.4% 16.4% 16.4% 16.4% 16.4% 16.4%
Closed-Won 1 7 13 7 7 7 21 21 21 34 34 34 207
SDR efficiency YoY
Opportunities per SDR 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25
Sales Reps Needed 1 2 4 2 2 2 6 6 6 9 9 9 58

Contract Count

RENEWAL RATE 90% 90% 90% 90%
7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 1/1/22 2/1/22 3/1/22 4/1/22 5/1/22 6/1/22 7/1/22 8/1/22 9/1/22 10/1/22 11/1/22 12/1/22 1/1/23 2/1/23 3/1/23 4/1/23 5/1/23 6/1/23 7/1/23 8/1/23 9/1/23 10/1/23 11/1/23 12/1/23 1/1/24 2/1/24 3/1/24 4/1/24 5/1/24 6/1/24 7/1/24 8/1/24 9/1/24 10/1/24 11/1/24 12/1/24 1/1/25 2/1/25 3/1/25 4/1/25 5/1/25 6/1/25 7/1/25 8/1/25 9/1/25 10/1/25 11/1/25 12/1/25 1/1/26 2/1/26 3/1/26 4/1/26 5/1/26 6/1/26
7/1/21 1 1 0 0 0 0
8/1/21 7 7 6 5 4 3
9/1/21 13 13 11 9 8 7
10/1/21 7 7 6 5 4 3
11/1/21 7 7 6 5 4 3
12/1/21 7 7 6 5 4 3
1/1/22 21 21 18 16 14 12
2/1/22 21 21 18 16 14 12
3/1/22 21 21 18 16 14 12
4/1/22 34 34 30 27 24 21
5/1/22 34 34 30 27 24 21
6/1/22 34 34 30 27 24 21
7/1/22 35 35 31 27 24 21
8/1/22 36 36 32 28 25
9/1/22 37 37 33 29 26
10/1/22 38 38 34 30 27
11/1/22 39 39 35 31 27
12/1/22 40 40 36 32 28
1/1/23 41 41 36 32 28
2/1/23 42 42 37 33 29
3/1/23 43 43 38 34 30
4/1/23 44 44 39 35 31
5/1/23 45 45 40 36 32
6/1/23 46 46 41 36 32
7/1/23 47 47 42 37
8/1/23 48 48 43 38
9/1/23 49 49 44 39
10/1/23 50 50 45 40
11/1/23 51 51 45 40
12/1/23 52 52 46 41
1/1/24 53 53 47 42
2/1/24 54 54 48 43
3/1/24 55 55 49 44
4/1/24 56 56 50 45
5/1/24 57 57 51 45
6/1/24 58 58 52 46
7/1/24 59 59 53
8/1/24 60 60 54
9/1/24 61 61 54
10/1/24 62 62 55
11/1/24 63 63 56
12/1/24 64 64 57
1/1/25 65 65 58
2/1/25 66 66 59
3/1/25 67 67 60
4/1/25 68 68 61
5/1/25 69 69 62
6/1/25 70 70 63
7/1/25 71 71
8/1/25 72 72
9/1/25 73 73
10/1/25 74 74
11/1/25 75 75
12/1/25 76 76
1/1/26 77 77
2/1/26 78 78
3/1/26 79 79
4/1/26 80 80
5/1/26 81 81
6/1/26 82 82
New 1 7 13 7 7 7 21 21 21 34 34 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 3,015
Renewal 0 0 0 0 0 0 0 0 0 0 0 0 0 6 11 6 6 6 18 18 18 30 30 30 31 37 42 39 40 41 52 53 54 66 67 68 69 75 81 79 80 82 93 95 97 109 111 112 114 120 126 125 126 129 140 143 146 158 160 162 3,501
Total Adds 1 7 13 7 7 7 21 21 21 34 34 34 35 42 48 44 45 46 59 60 61 74 75 76 78 85 91 89 91 93 105 107 109 122 124 126 128 135 142 141 143 146 158 161 164 177 180 182 185 192 199 199 201 205 217 221 225 238 241 244 6,516
Cumulative 1 8 21 28 35 42 63 84 105 139 173 207 242 284 332 376 421 467 526 586 647 721 796 872 950 1,035 1,126 1,215 1,306 1,399 1,504 1,611 1,720 1,842 1,966 2,092 2,220 2,355 2,497 2,638 2,781 2,927 3,085 3,246 3,410 3,587 3,767 3,949 4,134 4,326 4,525 4,724 4,925 5,130 5,347 5,568 5,793 6,031 6,272 6,516
Churn (1) (1) (2) (1) (1) (1) (3) (3) (3) (4) (4) (4) (4) (5) (6) (5) (5) (5) (7) (7) (7) (8) (8) (8) (9) (10) (10) (10) (11) (11) (12) (12) (12) (13) (13) (14) (14) (15) (16) (16) (17) (17) (18) (18) (18) (19) (20) (20)
Cumulative (1) (2) (4) (5) (6) (7) (10) (13) (16) (20) (24) (28) (32) (37) (43) (48) (53) (58) (65) (72) (79) (87) (95) (103) (112) (122) (132) (142) (153) (164) (176) (188) (200) (213) (226) (240) (254) (269) (285) (301) (318) (335) (353) (371) (389) (408) (428) (448)
CS efficienccy YoY
Customers per CS Rep 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40
CS Reps Needed 1 1 1 1 1 2 2 3 3 4 5 6 7 8 9 10 11 12 14 15 17 19 20 22 24 26 29 31 33 35 38 41 43 47 50 53 56 59 63 66 70 74 78 82 86 90 95 99 104 109 114 119 124 129 134 140 145 151 157 163
Probably 2 customers per contract
check total 207 486 630 774 918 3,015
check total 0 179 590 1,083 1,649 3,501
6,516

Revenue

Jul-2021 Aug-2021 Sep-2021 Oct-2021 Nov-2021 Dec-2021 Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022 Total
New Revenue
School $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500
IL 0 35,000 70,000 35,000 35,000 35,000 122,500 122,500 122,500 192,500 192,500 192,500 1,155,000
NY 0 0 17,500 0 0 0 35,000 35,000 35,000 70,000 70,000 70,000 332,500
DC 0 0 0 0 0 0 17,500 17,500 17,500 35,000 35,000 35,000 157,500
MO 0 35,000 52,500 35,000 35,000 35,000 52,500 52,500 52,500 70,000 70,000 70,000 560,000
Total 0 70,000 140,000 70,000 70,000 70,000 227,500 227,500 227,500 367,500 367,500 367,500 2,205,000
Non-profit $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
IL 0 0 25,000 0 0 0 50,000 50,000 50,000 100,000 100,000 100,000 475,000
NY 0 0 0 0 0 0 0 0 0 0 0 0 0
DC 0 0 0 0 0 0 25,000 25,000 25,000 50,000 50,000 50,000 225,000
MO 0 25,000 50,000 25,000 25,000 25,000 50,000 50,000 50,000 50,000 50,000 50,000 450,000
Total 0 25,000 75,000 25,000 25,000 25,000 125,000 125,000 125,000 200,000 200,000 200,000 1,150,000
Small Network/District $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
IL 0 0 0 0 0 0 60,000 60,000 60,000 120,000 120,000 120,000 540,000
NY 0 0 0 0 0 0 0 0 0 0 0 0 0
DC 0 0 0 0 0 0 0 0 0 0 0 0 0
MO 60,000 120,000 120,000 120,000 120,000 120,000 120,000 120,000 120,000 180,000 180,000 180,000 1,560,000
Total 60,000 120,000 120,000 120,000 120,000 120,000 180,000 180,000 180,000 300,000 300,000 300,000 2,100,000
Total New Revenue 60,000 215,000 335,000 215,000 215,000 215,000 532,500 532,500 532,500 867,500 867,500 867,500 5,455,000
Renewal Revenue
School $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500
IL 0
NY 0
DC 0
MO 0
Total 0 0 0 0 0 0 0 0 0 0 0 0 0
Non-profit $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
IL 0
NY 0
DC 0
MO 0
Total 0 0 0 0 0 0 0 0 0 0 0 0 0
Small Network/District $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
IL 0
NY 0
DC 0
MO 0
Total 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Renewal Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0
New Revenue
School 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3%
IL 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0%
NY/NJ/CT 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0%
DC/VA/MD 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%
MO 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0%
Nonprofit 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1%
IL 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0%
NY/NJ/CT 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%
DC/VA/MD 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0%
MO 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%
Small Network/District 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6%
IL 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0%
NY/NJ/CT 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%
DC/VA/MD 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0%
MO 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0%
School - 0 4 8 4 4 4 13 13 13 21 21 21 126
IL - 0 2 4 2 2 2 7 7 7 11 11 11 66
NY/NJ/CT - 0 - 0 1 - 0 - 0 - 0 2 2 2 4 4 4 19
DC/VA/MD - 0 - 0 - 0 - 0 - 0 - 0 1 1 1 2 2 2 9
MO - 0 2 3 2 2 2 3 3 3 4 4 4 32
Nonprofit - 0 1 3 1 1 1 5 5 5 8 8 8 46
IL - 0 - 0 1 - 0 - 0 - 0 2 2 2 4 4 4 19
NY/NJ/CT - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
DC/VA/MD - 0 - 0 - 0 - 0 - 0 - 0 1 1 1 2 2 2 9
MO - 0 1 2 1 1 1 2 2 2 2 2 2 18
Small Network/District 1 2 2 2 2 2 3 3 3 5 5 5 35
IL - 0 - 0 - 0 - 0 - 0 - 0 1 1 1 2 2 2 9
NY/NJ/CT - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
DC/VA/MD - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
MO 1 2 2 2 2 2 2 2 2 3 3 3 26
Renewals by Market
School 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3% 63.3%
IL 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0%
NY/NJ/CT 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0%
DC/VA/MD 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%
MO 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0%
Nonprofit 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1% 24.1%
IL 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0%
NY/NJ/CT 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%
DC/VA/MD 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0%
MO 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%
Small Network/District 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6% 12.6%
IL 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0%
NY/NJ/CT 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%
DC/VA/MD 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0% 15.0%
MO 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0%
School - 0 4 8 4 4 4 13 13 13 21 21 21 126
IL - 0 2 4 2 2 2 7 7 7 11 11 11 66
NY/NJ/CT - 0 - 0 1 - 0 - 0 - 0 2 2 2 4 4 4 19
DC/VA/MD - 0 - 0 - 0 - 0 - 0 - 0 1 1 1 2 2 2 9
MO - 0 2 3 2 2 2 3 3 3 4 4 4 32
Nonprofit - 0 1 3 1 1 1 5 5 5 8 8 8 46
IL - 0 - 0 1 - 0 - 0 - 0 2 2 2 4 4 4 19
NY/NJ/CT - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
DC/VA/MD - 0 - 0 - 0 - 0 - 0 - 0 1 1 1 2 2 2 9
MO - 0 1 2 1 1 1 2 2 2 2 2 2 18
Small Network/District 1 2 2 2 2 2 3 3 3 5 5 5 35
IL - 0 - 0 - 0 - 0 - 0 - 0 1 1 1 2 2 2 9
NY/NJ/CT - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
DC/VA/MD - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
MO 1 2 2 2 2 2 2 2 2 3 3 3 26

Personnel

FTEs 7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 1/1/22 2/1/22 3/1/22 4/1/22 5/1/22 6/1/22 Total
Function Position Start Date
Customer Support CS Reps 1 1 1 1 1 2 2 3 3 4 5 6 30
Platform Support Engineer Full Stack Engineer? (should this be in G&A as leadership?) 1 1 1 1 1 1 1 1 1 1 1 1 12
Platform Support Engineer TBD 1 1 1 1 1 1 1 1 1 1 1 1 12
Platform Support Engineer TBD 1 1 1 1 1 1 1 1 1 1 1 1 12
Marketing Marketing Manager 1 1 1 1 1 1 1 1 1 1 1 1 12
Marketing TBD 1 1 1 1 1 1 1 1 1 1 1 1 12
Marketing TBD 1 1 1 1 1 1 1 1 1 1 1 1 12
Sales Sales Reps 1 2 4 2 2 2 6 6 6 9 9 9 58
R&D Engineer Designer 1 1 1 1 1 1 1 1 1 1 1 1 12
R&D Engineer Front End 1 1 1 1 1 1 1 1 1 1 1 1 12
R&D Engineer Back End 1 1 1 1 1 1 1 1 1 1 1 1 12
G&A CEO 1 1 1 1 1 1 1 1 1 1 1 1 12
G&A CGO 1 1 1 1 1 1 1 1 1 1 1 1 12
G&A President 1 1 1 1 1 1 1 1 1 1 1 1 12
G&A Chief of Staff 1 1 1 1 1 1 1 1 1 1 1 1 12
G&A Community Manager 1 1 1 1 1 1 1 1 1 1 1 1 12
Salaries & Wages
Function Position Start Date Base Salary Inflator Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Total
Customer Support CS Reps $70,000.00 3% $5,833.33 $5,833.33 $5,833.33 $5,833.33 $5,833.33 $11,666.67 $11,666.67 $17,500.00 $17,500.00 $23,333.33 $29,166.67 $35,000.00 $175,000.00
Platform Support Engineer Full Stack Engineer? (should this be in G&A as leadership?) $67,500.00 3% $5,625.00 $5,625.00 $5,625.00 $5,625.00 $5,625.00 $5,625.00 $5,625.00 $5,625.00 $5,625.00 $5,625.00 $5,625.00 $5,625.00 $67,500.00
Platform Support Engineer TBD 3% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Platform Support Engineer TBD 3% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Marketing Marketing Manager $85,000.00 3% $7,083.33 $7,083.33 $7,083.33 $7,083.33 $7,083.33 $7,083.33 $7,083.33 $7,083.33 $7,083.33 $7,083.33 $7,083.33 $7,083.33 $85,000.00
Marketing TBD 3% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Marketing TBD 3% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Sales Sales Reps $70,000.00 3% $5,833.33 $11,666.67 $23,333.33 $11,666.67 $11,666.67 $11,666.67 $35,000.00 $35,000.00 $35,000.00 $52,500.00 $52,500.00 $52,500.00 $338,333.33
R&D Engineer Designer 3% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
R&D Engineer Front End 3% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
R&D Engineer Back End 3% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
G&A CEO $120,000.00 3% $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $120,000.00
G&A CGO $110,000.00 3% $9,166.67 $9,166.67 $9,166.67 $9,166.67 $9,166.67 $9,166.67 $9,166.67 $9,166.67 $9,166.67 $9,166.67 $9,166.67 $9,166.67 $110,000.00
G&A President $100,000.00 3% $8,333.33 $8,333.33 $8,333.33 $8,333.33 $8,333.33 $8,333.33 $8,333.33 $8,333.33 $8,333.33 $8,333.33 $8,333.33 $8,333.33 $100,000.00
G&A Chief of Staff $80,000.00 3% $6,666.67 $6,666.67 $6,666.67 $6,666.67 $6,666.67 $6,666.67 $6,666.67 $6,666.67 $6,666.67 $6,666.67 $6,666.67 $6,666.67 $80,000.00
G&A Community Manager $70,000.00 3% $5,833.33 $5,833.33 $5,833.33 $5,833.33 $5,833.33 $5,833.33 $5,833.33 $5,833.33 $5,833.33 $5,833.33 $5,833.33 $5,833.33 $70,000.00
Employee Position Headcount
Admin 0 0 0 0 0 0 0 0
Executive 0 0 0 0 0 0 0 0
Sales 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
Total FTEs 0 0 0 0 0 0 0 0

OpEx

Fixed or Variable Driver Frequency/ Assumptions/ Multiplier YoY Growth/ Inflator Jul-2021 Aug-2021 Sep-2021 Oct-2021 Nov-2021 Dec-2021 Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022 Total
Cost of Goods Sold
Customer Support (After Sale) - MOVE TO Cost of Services
Labor
Contractors (or employees?) fixed 0
Employees variable from FTE tab n/a n/a
Team Building & Training per CS Rep $500 annually 0% 0
Total Labor 0 0 0 0 0 0 0 0 0 0 0 0 0
Events
Rewards
Travel, M&E
Software Subscriptions
Total Customer Support (After Sale) 0 0 0 0 0 0 0 0 0 0 0 0 0
Research & Development (COGS) (consider renaming Other Costs of Services)
Data Infrastructure Base variable per customer users
Nancy McCullough: Nancy McCullough: $280 in Q4 2021 Budget Planning		 monthly 3% 0
Data Infrastructure Incremental fixed $115
Nancy McCullough: Nancy McCullough: $304 in Q4 2021 Budget Planning		 monthly 3% 0
Labor
Contractors (or employees?) fixed 0
Employees variable from FTE tab n/a n/a
Total Labor 0 0 0 0 0 0 0 0 0 0 0 0 0
Software fixed $100 monthly 3% 0
Total Research & Development (COGS) 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Cost of Goods Sold 0 0 0 0 0 0 0 0 0 0 0 0 0
Expenses
Digital Sales & Marketing
Marketing Expenses (this needs to tie to marketing budget on Sales Funnel tab - other accounts needed as shown in Marketing Goal Projection model?)
Contractors (or employees?) deals? $1,500 monthly 3% conference & ads 0
Employees
Operating email campaign email campaign
Design/Content Creation $1,000 monthly webinar hosting 0
Facebook Spend (consider combining to one account "social media") sales funnel (plug?) from Sales Funnel Tab n/a n/a private events 0
LinkedIn Spend (consider combining to one account "social media") etc. 0
Software fixed $865 monthly 3% 0
Twitter Spend (consider combining to one account "social media") 0
Website $179 monthly 3% 0
Total Operating 0 0 0 0 0 0 0 0 0 0 0 0 0
Travel & Meals per FTE $2,000 annually 3% 0
Total Marketing Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Sales Expenses
Labor
Contractors (or employees?) MQLs from FTE tab n/a n/a 0
Employees
Team Building & Training per FTE $2,000 annually 3% 0
Total Labor 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Sales Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Digital Sales & Marketing 0 0 0 0 0 0 0 0 0 0 0 0 0
Direct Sales & Marketing (collapse w/ digital)
Marketing Expenses
Operating
Collateral (Banners, Pens, Swag) fixed monthly 3% 0
Event Sponsorship fixed monthly 3% 0
Market Research fixed monthly 3% 0
Partnerships/Dues/Subscriptions fixed monthly 3% 0
Software fixed $210 monthly 3% 0
Total Operating 0 0 0 0 0 0 0 0 0 0 0 0 0
Travel & Meals per FTE monthly 3% 0
Total Marketing Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Sales Expenses
Labor
Contractors SQLs from FTE tab n/a n/a 0
Team Building & Training per FTE $2,000 annually 3% 0
Total Labor 0 0 0 0 0 0 0 0 0 0 0 0 0
Operating
Software fixed $210 monthly 3% 0
Total Operating 0 0 0 0 0 0 0 0 0 0 0 0 0
Travel & Meals (no need for detail in model)
Air Travel
Hotel
Incidentals
Internet
Meals
Transportation (Land)
Travel Meals
Total Travel & Meals per FTE $2,000 monthly 3% 0
Total Sales Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Direct Sales & Marketing 0 0 0 0 0 0 0 0 0 0 0 0 0
General/Admin
Labor
Contractors fixed $1,000 monthly 3% 0
Recruiting per FTE add $500 monthly 0% 0
Team Building & Training fixed $300 monthly 0% 0
Total Labor 0 0 0 0 0 0 0 0 0 0 0 0 0
Operating
Bank & Processing Fees fixed $50 monthly n/a 0
Bank Charges (consider deleting)
Total Bank & Processing Fees (consider deleting)
Donations fixed $500 monthly n/a 0
Dues & Subscriptions fixed $100 monthly n/a 0
Equipment per FTE add $2,500 annually n/a 0
Gifts (Customer) - ADD TO CUSTOMER SUPPORT ALSO - add ASSOC RELATIONS fixed $100 monthly n/a 0
Insurance fixed $300 monthly n/a 0
Interest Paid (move to other expense, may go away with funding) fixed $0 monthly n/a 0
Legal & Professional Services
Accounting fixed $4,250 monthly n/a 0
Legal fixed $500 monthly n/a 0
Total Legal & Professional Services 0 0 0 0 0 0 0 0 0 0 0 0 0
Office Supplies per FTE $50 monthly n/a 0
Other Business Expenses fixed $50 monthly n/a 0
Rent & Lease fixed $500 monthly n/a 0
Shipping fixed $100 monthly n/a 0
Software fixed $1,100 monthly n/a 0
Taxes & Licenses (rename Licenses & Fees) fixed $50 monthly n/a 0
Total Operating 0 0 0 0 0 0 0 0 0 0 0 0 0
Travel & Meals (no need for detail in model, should this be grouped in "operating"?) fixed $300 monthly 3% 0
Meals & Entertainment
Total Travel & Meals
Total General/Admin 0 0 0 0 0 0 0 0 0 0 0 0 0
Payroll Expenses
Company Benefits & Contributions
Athletic Facilities per FTE $50 monthly n/a 0
Cell Service per FTE $50 monthly n/a 0
Medical Benefits per FTE $500 monthly 10% 0
Retirement Benefits per FTE 4% Salaries n/a 0
Total Company Benefits & Contributions 0 0 0 0 0 0 0 0 0 0 0 0 0
Company Contributions (duplicate)
Retirement
Total Company Contributions
Salary & Wages
C-level - Salaries (no need to report separately for c-corp) fixed from FTE tab n/a n/a 0
Marketing - Salaries (move to mktg) fixed from FTE tab n/a n/a 0
Operations - Salaries fixed from FTE tab n/a n/a 0
Sales - Salaries (move to sales) fixed from FTE tab n/a n/a 0
Total Salary & Wages 0 0 0 0 0 0 0 0 0 0 0 0 0
Taxes fixed 8% Salaries n/a 0
Wages (no longer being used?)
Total Payroll Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Research & Development
Operating
Research fixed $300 monthly 3% 0
Total Operating 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Research & Development 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Expense Jul-2021 Aug-2021 Sep-2021 Oct-2021 Nov-2021 Dec-2021 Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022 Total
Fixed $ 43,044.33 $ 43,044.33 $ 43,044.33 $ 43,044.33 $ 43,044.33 $ 43,044.33 $ 43,044.33 $ 43,044.33 $ 43,044.33 $ 43,044.33 $ 43,044.33 $ 43,044.33 $ 516,531.93
Variable $ 544,089.21 $ 549,530.10 $ 555,025.41 $ 560,575.66 $ 566,181.42 $ 571,843.23 $ 577,561.66 $ 583,337.28 $ 589,170.65 $ 595,062.36 $ 601,012.98 $ 607,023.11 $ 6,900,413.07

Sales Goals

2021-2022 Sales Targets Total 7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 1/1/22 2/1/22 3/1/22 4/1/22 5/1/22 6/1/22
Deals Created per Month
Total Deals Created per Month 1262 42 42 42 42 42 42 126 126 126 210 210 210
School Deals Created per Month 799 27 27 27 27 27 27 80 80 80 133 133 133
Non-profit Deals Created per Month 305 10 10 10 10 10 10 30 30 30 51 51 51
Small Network/District Deals Created per Month 159 5 5 5 5 5 5 16 16 16 26 26 26
IL 655 22 22 22 22 22 22 66 66 66 109 109 109
School Deals Created per Month 439 15 15 15 15 15 15 44 44 44 73 73 73
Non-profit Deals Created per Month 152 5 5 5 5 5 5 15 15 15 25 25 25
Small Network/District Deals Created per Month 63 2 2 2 2 2 2 6 6 6 11 11 11
NY/NJ/CT 206 7 7 7 7 7 7 21 21 21 34 34 34
School Deals Created per Month 160 5 5 5 5 5 5 16 16 16 27 27 27
Non-profit Deals Created per Month 30 1 1 1 1 1 1 3 3 3 5 5 5
Small Network/District Deals Created per Month 16 1 1 1 1 1 1 2 2 2 3 3 3
DC/VA/MD 195 7 7 7 7 7 7 20 20 20 33 33 33
School Deals Created per Month 80 3 3 3 3 3 3 8 8 8 13 13 13
Non-profit Deals Created per Month 91 3 3 3 3 3 3 9 9 9 15 15 15
Small Network/District Deals Created per Month 24 1 1 1 1 1 1 2 2 2 4 4 4
MO 206 7 7 7 7 7 7 21 21 21 34 34 34
School Deals Created per Month 120 4 4 4 4 4 4 12 12 12 20 20 20
Non-profit Deals Created per Month 30 1 1 1 1 1 1 3 3 3 5 5 5
Small Network/District Deals Created per Month 55 2 2 2 2 2 2 6 6 6 9 9 9
Pipeline revenue from new deals created per Month
Total New Pipeline Revenue Created per Month $31,112,805 $1,037,093 $1,037,093 $1,037,093 $1,037,093 $1,037,093 $1,037,093 $3,111,280 $3,111,280 $3,111,280 $5,185,467 $5,185,467 $5,185,467
School New Pipeline Revenue Created per Month $13,978,659 $465,955 $465,955 $465,955 $465,955 $465,955 $465,955 $1,397,866 $1,397,866 $1,397,866 $2,329,776 $2,329,776 $2,329,776
Non-profit New Pipeline Revenue Created per Month $7,621,951 $254,065 $254,065 $254,065 $254,065 $254,065 $254,065 $762,195 $762,195 $762,195 $1,270,325 $1,270,325 $1,270,325
Small Network/District New Pipeline Revenue Created per Month $9,512,195 $317,073 $317,073 $317,073 $317,073 $317,073 $317,073 $951,220 $951,220 $951,220 $1,585,366 $1,585,366 $1,585,366
IL $15,304,116 $510,137 $510,137 $510,137 $510,137 $510,137 $510,137 $1,530,412 $1,530,412 $1,530,412 $2,550,686 $2,550,686 $2,550,686
School New Pipeline Revenue Created per Month $7,688,262 $256,275 $256,275 $256,275 $256,275 $256,275 $256,275 $768,826 $768,826 $768,826 $1,281,377 $1,281,377 $1,281,377
Non-profit New Pipeline Revenue Created per Month $3,810,976 $127,033 $127,033 $127,033 $127,033 $127,033 $127,033 $381,098 $381,098 $381,098 $635,163 $635,163 $635,163
Small Network/District New Pipeline Revenue Created per Month $3,804,878 $126,829 $126,829 $126,829 $126,829 $126,829 $126,829 $380,488 $380,488 $380,488 $634,146 $634,146 $634,146
NY/NJ/CT $4,509,146 $150,305 $150,305 $150,305 $150,305 $150,305 $150,305 $450,915 $450,915 $450,915 $751,524 $751,524 $751,524
School New Pipeline Revenue Created per Month $2,795,732 $93,191 $93,191 $93,191 $93,191 $93,191 $93,191 $279,573 $279,573 $279,573 $465,955 $465,955 $465,955
Non-profit New Pipeline Revenue Created per Month $762,195 $25,407 $25,407 $25,407 $25,407 $25,407 $25,407 $76,220 $76,220 $76,220 $127,033 $127,033 $127,033
Small Network/District New Pipeline Revenue Created per Month $951,220 $31,707 $31,707 $31,707 $31,707 $31,707 $31,707 $95,122 $95,122 $95,122 $158,537 $158,537 $158,537
DC/VA/MD $5,111,280 $170,376 $170,376 $170,376 $170,376 $170,376 $170,376 $511,128 $511,128 $511,128 $851,880 $851,880 $851,880
School New Pipeline Revenue Created per Month $1,397,866 $46,596 $46,596 $46,596 $46,596 $46,596 $46,596 $139,787 $139,787 $139,787 $232,978 $232,978 $232,978
Non-profit New Pipeline Revenue Created per Month $2,286,585 $76,220 $76,220 $76,220 $76,220 $76,220 $76,220 $228,659 $228,659 $228,659 $381,098 $381,098 $381,098
Small Network/District New Pipeline Revenue Created per Month $1,426,829 $47,561 $47,561 $47,561 $47,561 $47,561 $47,561 $142,683 $142,683 $142,683 $237,805 $237,805 $237,805
MO $6,188,262 $206,275 $206,275 $206,275 $206,275 $206,275 $206,275 $618,826 $618,826 $618,826 $1,031,377 $1,031,377 $1,031,377
School New Pipeline Revenue Created per Month $2,096,799 $69,893 $69,893 $69,893 $69,893 $69,893 $69,893 $209,680 $209,680 $209,680 $349,466 $349,466 $349,466
Non-profit New Pipeline Revenue Created per Month $762,195 $25,407 $25,407 $25,407 $25,407 $25,407 $25,407 $76,220 $76,220 $76,220 $127,033 $127,033 $127,033
Small Network/District New Pipeline Revenue Created per Month $3,329,268 $110,976 $110,976 $110,976 $110,976 $110,976 $110,976 $332,927 $332,927 $332,927 $554,878 $554,878 $554,878
Deals Closed-Won per Month
Total Deals Closed-Won per Month 207 0 9 11 13 10 13 11 23 23 23 34 37
School New Pipeline Revenue Created per Month 131 0 6 6 7 6 7 7 15 14 15 24 24
Non-profit Deals Closed-Won per Month 50 0 3 2 3 2 3 3 5 6 6 8 9
Small Network/District Deals Closed-Won per Month 26 0 0 3 3 2 3 1 3 3 2 2 4
IL 107 0 4 5 6 5 6 5 13 12 13 19 19
School Deals Closed-Won per Month 72 0 3 3 4 3 4 3 9 8 9 13 13
Non-profit Deals Closed-Won per Month 25 0 1 1 1 1 1 1 3 3 3 5 5
Small Network/District Deals Closed-Won per Month 10 0 0 1 1 1 1 1 1 1 1 1 1
NY/NJ/CT 34 0 2 1 3 1 2 2 4 3 4 5 7
School Deals Closed-Won per Month 26 0 1 1 1 1 1 2 3 3 3 5 5
Non-profit Deals Closed-Won per Month 5 0 1 0 1 0 1 0 0 0 1 0 1
Small Network/District Deals Closed-Won per Month 3 0 0 0 1 0 0 0 1 0 0 0 1
DC/VA/MD 32 0 2 2 2 1 3 2 3 4 3 4 6
School Deals Closed-Won per Month 13 0 1 1 1 1 1 1 1 1 1 2 2
Non-profit Deals Closed-Won per Month 15 0 1 0 1 0 1 1 2 2 2 2 3
Small Network/District Deals Closed-Won per Month 4 0 0 1 0 0 1 0 0 1 0 0 1
MO 34 0 1 3 2 3 2 2 3 4 3 6 5
School Deals Closed-Won per Month 20 0 1 1 1 1 1 1 2 2 2 4 4
Non-profit Deals Closed-Won per Month 5 0 0 1 0 1 0 1 0 1 0 1 0
Small Network/District Deals Closed-Won per Month 9 0 0 1 1 1 1 0 1 1 1 1 1
Revenue Generated per Month (Closed)
Total Revenue Generated per Month $5,102,500 $0 $180,000 $335,000 $377,500 $275,000 $377,500 $257,500 $567,500 $575,000 $532,500 $740,000 $885,000
School New Pipeline Revenue Created per Month $2,292,500 $0 $105,000 $105,000 $122,500 $105,000 $122,500 $122,500 $262,500 $245,000 $262,500 $420,000 $420,000
Non-profit Revenue Generated per Month $1,250,000 $0 $75,000 $50,000 $75,000 $50,000 $75,000 $75,000 $125,000 $150,000 $150,000 $200,000 $225,000
Small Network/District Revenue Generated per Month $1,560,000 $0 $0 $180,000 $180,000 $120,000 $180,000 $60,000 $180,000 $180,000 $120,000 $120,000 $240,000
IL $2,485,000 $0 $77,500 $137,500 $155,000 $137,500 $155,000 $137,500 $292,500 $275,000 $292,500 $412,500 $412,500
School Revenue Generated per Month $1,260,000 $0 $52,500 $52,500 $70,000 $52,500 $70,000 $52,500 $157,500 $140,000 $157,500 $227,500 $227,500
Non-profit Revenue Generated per Month $625,000 $0 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $75,000 $75,000 $75,000 $125,000 $125,000
Small Network/District Revenue Generated per Month $600,000 $0 $0 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
NY/NJ/CT $760,000 $0 $42,500 $17,500 $102,500 $17,500 $42,500 $35,000 $112,500 $52,500 $77,500 $87,500 $172,500
School Revenue Generated per Month $455,000 $0 $17,500 $17,500 $17,500 $17,500 $17,500 $35,000 $52,500 $52,500 $52,500 $87,500 $87,500
Non-profit Revenue Generated per Month $125,000 $0 $25,000 $0 $25,000 $0 $25,000 $0 $0 $0 $25,000 $0 $25,000
Small Network/District Revenue Generated per Month $180,000 $0 $0 $0 $60,000 $0 $0 $0 $60,000 $0 $0 $0 $60,000
DC/VA/MD $842,500 $0 $42,500 $77,500 $42,500 $17,500 $102,500 $42,500 $67,500 $127,500 $67,500 $85,000 $170,000
School Revenue Generated per Month $227,500 $0 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $35,000 $35,000
Non-profit Revenue Generated per Month $375,000 $0 $25,000 $0 $25,000 $0 $25,000 $25,000 $50,000 $50,000 $50,000 $50,000 $75,000
Small Network/District Revenue Generated per Month $240,000 $0 $0 $60,000 $0 $0 $60,000 $0 $0 $60,000 $0 $0 $60,000
MO $1,015,000 $0 $17,500 $102,500 $77,500 $102,500 $77,500 $42,500 $95,000 $120,000 $95,000 $155,000 $130,000
School Revenue Generated per Month $350,000 $0 $17,500 $17,500 $17,500 $17,500 $17,500 $17,500 $35,000 $35,000 $35,000 $70,000 $70,000
Non-profit Revenue Generated per Month $125,000 $0 $0 $25,000 $0 $25,000 $0 $25,000 $0 $25,000 $0 $25,000 $0
Small Network/District Revenue Generated per Month $540,000 $0 $0 $60,000 $60,000 $60,000 $60,000 $0 $60,000 $60,000 $60,000 $60,000 $60,000
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

Sales Targets

21-22 Revenue Goal $5,102,500
Average School Cost $17,500
Average Non-profit Cost $25,000
Average Small Network/District Cost $60,000
Deal Created -> Closed Won Months 1.3
School Deal Created -> Closed Won Months 1
Non-profit Deal Created -> Closed Won Months 1
Small Network/District Deal Created-> Closed Won Months 2
Overall Deal -> Closed Won Conversion 16.4%
School Deal -> Closed Won Conversion 16.4% Region
Non-profit Deal -> Closed Won Conversion 16.4% Segment IL NY/NJ/CT DC/VA/MD MO
Small Network/District Deal -> Closed Won Conversion 16.4% % School 55% 20% 10% 15%
% Non-profit 50% 10% 30% 10%
# of Deals % Small Network/District 40% 10% 15% 35% Total
Total Deals Closed-Won 207 # School 72 26 13 20 131
School Deals Closed-Won 131 # Non-profit 25 5 15 5 50
Non-profit Deals Closed-Won 50 # Small Network/District 10 3 4 9 26
Small Network/District Deals Closed-Won 26
Deal RampUp Deals Created by Region
10% 10% 30% 50%
Q1 Q2 Q3 Q4 # of Deals Qtr 1 Region Qtr 2 Region Qtr 3 Region Qtr 4 Region
Avg. Deals Created per Qtr 316 126 126 379 631 1262 Segment IL NY/NJ/CT DC/VA/MD MO Segment IL NY/NJ/CT DC/VA/MD MO Segment IL NY/NJ/CT DC/VA/MD MO Segment IL NY/NJ/CT DC/VA/MD MO
Avg. School Deals Created per Qtr 200 80 80 240 399 799 School 44 16 8 12 80 School 44 16 8 12 80 School 132 48 24 36 240 School 220 80 40 60 399
Avg. Non-profit Deals Created per Qtr 76 30 30 91 152 305 Non-profit 15 3 9 3 30 Non-profit 15 3 9 3 30 Non-profit 46 9 27 9 91 Non-profit 200 40 120 40 399
Avg. Small Network/District Deals Created per Qtr 40 16 16 48 79 159 Small Network/District 6 2 2 6 16 Small Network/District 6 2 2 6 16 Small Network/District 19 5 7 17 48 Small Network/District 160 40 60 140 399
Total 66 21 20 21 126 Total 66 21 20 21 126 Total 197 62 59 62 379 Total 579 160 220 240 1198
Q1 Q2 Q3 Q4 # of Deals % of Deals
Avg. Deals Closed-Won per Qtr 52 21 21 62 104 207
Avg. School Deals Closed-Won per Qtr 32.75 13.1 13.1 39.3 65.5 131 63%
Avg. Non-profit Deals Closed-Won per Qtr 12.5 5 5 15 25 50 24%
Avg. Small Network/District Deals Closed-Won per Qtr 7 3 3 8 13 26 13%
Q1 Q2 Q3 Q4 Total Revenue % of Revenue Qtr 1 IL NY/NJ/CT DC/VA/MD MO Qtr 2 IL NY/NJ/CT DC/VA/MD MO Qtr 3 IL NY/NJ/CT DC/VA/MD MO Qtr 4 IL NY/NJ/CT DC/VA/MD MO Total Revenue IL NY/NJ/CT DC/VA/MD MO Revenue by Segment
Revenue Generated per Qtr $1,275,625 $510,250 $510,250 $1,530,750 $2,551,250 $5,102,500 Revenue by Region $250,988 $73,950 $83,825 $101,488 $510,250 Revenue by Region $250,988 $73,950 $83,825 $101,488 $510,250 Revenue by Region $752,963 $221,850 $251,475 $304,463 $1,530,750 Revenue by Region $1,254,938 $369,750 $419,125 $507,438 $2,551,250 Revenue by Region $2,509,875 $739,500 $838,250 $1,014,875 $5,102,500
Avg. School Revenue Generated per Qtr $573,125 $229,250 $229,250 $687,750 $1,146,250 $2,292,500 45% School $126,088 $45,850 $22,925 $34,388 $229,250 School $126,088 $45,850 $22,925 $34,388 $229,250 School $378,263 $137,550 $68,775 $103,163 $687,750 School $630,438 $229,250 $114,625 $171,938 $1,146,250 School $1,260,875 $458,500 $229,250 $343,875 $2,292,500
Avg. Non-profit Revenue Generated per Qtr $312,500 $125,000 $125,000 $375,000 $625,000 $1,250,000 24% Non-profit $62,500 $12,500 $37,500 $12,500 $125,000 Non-profit $62,500 $12,500 $37,500 $12,500 $125,000 Non-profit $187,500 $37,500 $112,500 $37,500 $375,000 Non-profit $312,500 $62,500 $187,500 $62,500 $625,000 Non-profit $625,000 $125,000 $375,000 $125,000 $1,250,000
Avg. Small Network/District Revenue Generated per Qtr $390,000 $156,000 $156,000 $468,000 $780,000 $1,560,000 31% Small Network/District $62,400 $15,600 $23,400 $54,600 $156,000 Small Network/District $62,400 $15,600 $23,400 $54,600 $156,000 Small Network/District $187,200 $46,800 $70,200 $163,800 $468,000 Small Network/District $312,000 $78,000 $117,000 $273,000 $780,000 Small Network/District $624,000 $156,000 $234,000 $546,000 $1,560,000
Monthly Breakdowns For every month in Q1 Region For every month in Q2 Region For every month in Q3 Region For every month in Q4 Region
Monthly in Q1 Monthly in Q2 Monthly in Q3 Monthly in Q4 Anual Target # of Deals For every month in Q1 IL NY/NJ/CT DC/VA/MD MO Total by Segment For every month in Q2 IL NY/NJ/CT DC/VA/MD MO Total by Segment For every month in Q3 IL NY/NJ/CT DC/VA/MD MO Total by Segment For every month in Q4 IL NY/NJ/CT DC/VA/MD MO Total by Segment
Avg. Deals Created per Month 105 42 42 126 210 1262 Total 22 7 7 7 42 Total 22 7 7 7 42 Total 66 21 20 21 126 Total 109 34 33 34 210
Avg. School Deals Created per Month 67 27 27 80 133 799 School 15 5 3 4 27 School 15 5 3 4 27 School 44 16 8 12 80 School 73 27 13 20 133
Avg. Non-profit Deals Created per Month 25 10 10 30 51 305 Non-profit 5 1 3 1 10 Non-profit 5 1 3 1 10 Non-profit 15 3 9 3 30 Non-profit 25 5 15 5 51
Avg. Small Network/District Deals Created per Month 13 5 5 16 26 159 Small Network/District 2 1 1 2 5 Small Network/District 2 1 1 2 5 Small Network/District 6 2 2 6 16 Small Network/District 11 3 4 9 26
Pipeline revenue Pipeline revenue Pipeline revenue Pipeline revenue
Monthly in Q1 Monthly in Q2 Monthly in Q3 Monthly in Q4 Anual Target Pipeline Revenue For every month in Q1 IL NY/NJ/CT DC/VA/MD MO Total by Segment For every month in Q2 IL NY/NJ/CT DC/VA/MD MO Total by Segment For every month in Q3 IL NY/NJ/CT DC/VA/MD MO Total by Segment For every month in Q4 IL NY/NJ/CT DC/VA/MD MO Total by Segment
Pipeline revenue from new deals created per Month $2,592,734 $1,037,093 $1,037,093 $3,111,280 $5,185,467 $31,112,805 Total by Region $510,137 $150,305 $170,376 $206,275 $1,037,093 Total by Region $510,137 $150,305 $170,376 $206,275 $1,037,093 Total by Region $1,530,412 $450,915 $511,128 $618,826 $3,111,280 Total by Region $2,550,686 $751,524 $851,880 $1,031,377 $5,185,467
Schools $1,164,888 $465,955 $465,955 $1,397,866 $2,329,776 $13,978,659 School $256,275 $93,191 $46,596 $69,893 $465,955 School $256,275 $93,191 $46,596 $69,893 $465,955 School $768,826 $279,573 $139,787 $209,680 $1,397,866 School $1,281,377 $465,955 $232,978 $349,466 $2,329,776
Nonprofits $635,163 $254,065 $254,065 $762,195 $1,270,325 $7,621,951 Non-profit $127,033 $25,407 $76,220 $25,407 $254,065 Non-profit $127,033 $25,407 $76,220 $25,407 $254,065 Non-profit $381,098 $76,220 $228,659 $76,220 $762,195 Non-profit $635,163 $127,033 $381,098 $127,033 $1,270,325
Small Network/District $792,683 $317,073 $317,073 $951,220 $1,585,366 $9,512,195 Small Network/District $126,829 $31,707 $47,561 $110,976 $317,073 Small Network/District $126,829 $31,707 $47,561 $110,976 $317,073 Small Network/District $380,488 $95,122 $142,683 $332,927 $951,220 Small Network/District $634,146 $158,537 $237,805 $554,878 $1,585,366
Closed Won Deals Closed Won Deals Closed Won Deals Closed Won Deals Closed Won Deals
Monthly in Q1 Monthly in Q2 Monthly in Q3 Monthly in Q4 Anual Closed-Won Deals For every month in Q1 IL NY/NJ/CT DC/VA/MD MO Total by Segment For every month in Q2 IL NY/NJ/CT DC/VA/MD MO Total by Segment For every month in Q3 IL NY/NJ/CT DC/VA/MD MO Total by Segment For every month in Q4 IL NY/NJ/CT DC/VA/MD MO Total by Segment Total IL NY/NJ/CT DC/VA/MD MO Total by Segment
Avg. Deals Closed-Won per Month 17 7 7 21 35 207 Total by Region 4 1 1 1 7 Total by Region 4 1 1 1 7 Total by Region $0 $0 $0 $0 $0 Total by Region $0 $0 $0 $0 $0 Total by Region $0 $0 $0 $0 $0
Avg. School Deals Closed-Won per Month 11 4 4 13 22 131 School 2 1 0 1 4 School 2 1 0 1 4 School $0 $0 $0 $0 $0 School $0 $0 $0 $0 $0 School $0 $0 $0 $0 $0
Avg. Non-profit Deals Closed-Won per Month 4 2 2 5 8 50 Non-profit 1 0 1 0 2 Non-profit 1 0 1 0 2 Non-profit $0 $0 $0 $0 $0 Non-profit $0 $0 $0 $0 $0 Non-profit $0 $0 $0 $0 $0
Avg. Small Network/District Deals Closed-Won per Month 2 1 1 3 4 26 Small Network/District 0 0 0 0 1 Small Network/District 0 0 0 0 1 Small Network/District $0 $0 $0 $0 $0 Small Network/District $0 $0 $0 $0 $0 Small Network/District $0 $0 $0 $0 $0
Closed Won Revenue Closed Won Revenue Closed Won Revenue Closed Won Revenue Closed Won Revenue
Monthly in Q1 Monthly in Q2 Monthly in Q3 Monthly in Q4 Anual Closed-Won Revenue For every month in Q1 IL NY/NJ/CT DC/VA/MD MO Revenue by Segment For every month in Q2 IL NY/NJ/CT DC/VA/MD MO Revenue by Segment For every month in Q3 IL NY/NJ/CT DC/VA/MD MO Revenue by Segment For every month in Q4 IL NY/NJ/CT DC/VA/MD MO Revenue by Segment Total IL NY/NJ/CT DC/VA/MD MO Revenue by Segment
Revenue Generated per Month (Closed) $425,208 $170,083 $170,083 $510,250 $850,417 $5,102,500 Revenue by Region $79,529 $23,617 $26,392 $30,213 $159,750 Revenue by Region $83,663 $24,650 $27,942 $33,829 $170,083 Revenue by Region $250,988 $73,950 $83,825 $101,488 $510,250 Revenue by Region $418,313 $123,250 $139,708 $169,146 $850,417 Revenue by Region $2,509,875 $739,500 $838,250 $1,014,875 $5,102,500
Avg. School Revenue Generated per Month $191,042 $76,417 $76,417 $229,250 $382,083 $2,292,500 School $42,029 $15,283 $7,642 $11,463 $76,417 School $42,029 $15,283 $7,642 $11,463 $76,417 School $126,088 $45,850 $22,925 $34,388 $229,250 School $210,146 $76,417 $38,208 $57,313 $382,083 School $1,260,875 $458,500 $229,250 $343,875 $2,292,500
Avg. Non-profit Revenue Generated per Month $104,167 $41,667 $41,667 $125,000 $208,333 $1,250,000 Non-profit $20,833 $4,167 $12,500 $4,167 $41,667 Non-profit $20,833 $4,167 $12,500 $4,167 $41,667 Non-profit $62,500 $12,500 $37,500 $12,500 $125,000 Non-profit $104,167 $20,833 $62,500 $20,833 $208,333 Non-profit $625,000 $125,000 $375,000 $125,000 $1,250,000
Avg. Small Network/District Revenue Generated per Month $130,000 $52,000 $52,000 $156,000 $260,000 $1,560,000 Small Network/District $16,667 $4,167 $6,250 $14,583 $41,667 Small Network/District $20,800 $5,200 $7,800 $18,200 $52,000 Small Network/District $62,400 $15,600 $23,400 $54,600 $156,000 Small Network/District $104,000 $26,000 $39,000 $91,000 $260,000 Small Network/District $624,000 $156,000 $234,000 $546,000 $1,560,000

Income Statement

Innovare - Social Innovation Partners
Profit and Loss
July 2020 - June 2021
Jul-2020 Aug-2020 Sep-2020 Oct-2020 Nov-2020 Dec-2020 Jan-2021 Feb-2021 Mar-2021 Apr-2021 May-2021 Jun-2021 Total Jul-2021 Aug-2021 Sep-2021 Oct-2021 Nov-2021 Dec-2021 Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022 Total
Income
Sales of Product Income 150,000.00 150,000.00 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
NFP 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
New 25,000.00 55,000.00 0.00 12,500.00 9,250.00 101,750.00 102,767.50 103,795.18 104,833.13 105,881.46 106,940.27 108,009.68 109,089.77 110,180.67 111,282.48 112,395.30 113,519.25 114,654.45 1,303,349.13
Total NFP $0.00 $0.00 $0.00 $0.00 $25,000.00 $55,000.00 $0.00 $0.00 $0.00 $0.00 $12,500.00 $9,250.00 $101,750.00 $102,767.50 $103,795.18 $104,833.13 $105,881.46 $106,940.27 $108,009.68 $109,089.77 $110,180.67 $111,282.48 $112,395.30 $113,519.25 $114,654.45 $1,303,349.13
School 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
New 25,000.00 32,500.00 7,500.00 55,000.00 15,000.00 7,500.00 60,384.00 62,500.00 265,384.00 268,037.84 270,718.22 273,425.40 276,159.65 278,921.25 281,710.46 284,527.57 287,372.84 290,246.57 293,149.04 296,080.53 299,041.33 3,399,390.71
Renewal 15,000.00 25,000.00 63,500.00 15,000.00 106,500.00 30,000.00 24,000.00 15,000.00 75,000.00 7,500.00 376,500.00 380,265.00 384,067.65 387,908.33 391,787.41 395,705.28 399,662.34 403,658.96 407,695.55 411,772.51 415,890.23 420,049.13 424,249.62 4,822,712.01
Total School $15,000.00 $25,000.00 $88,500.00 $47,500.00 $114,000.00 $85,000.00 $39,000.00 $15,000.00 $7,500.00 $60,384.00 $137,500.00 $7,500.00 $641,884.00 $648,302.84 $654,785.87 $661,333.73 $667,947.06 $674,626.53 $681,372.80 $688,186.53 $695,068.39 $702,019.08 $709,039.27 $716,129.66 $723,290.96 $8,222,102.72
Total Sales of Product Income $15,000.00 $25,000.00 $88,500.00 $47,500.00 $139,000.00 $140,000.00 $39,000.00 $15,000.00 $157,500.00 $60,384.00 $150,000.00 $16,750.00 $893,634.00 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Service Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
NFP 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
New 75,000.00 17,000.00 32,500.00 45,800.00 170,300.00 172,003.00 173,723.03 175,460.26 177,214.86 178,987.01 180,776.88 182,584.65 184,410.50 186,254.60 188,117.15 189,998.32 191,898.30 2,181,428.57
Renewal 25,500.00 25,000.00 50,500.00 51,005.00 51,515.05 52,030.20 52,550.50 53,076.01 53,606.77 54,142.84 54,684.26 55,231.11 55,783.42 56,341.25 56,904.66 646,871.07
Total NFP $0.00 $0.00 $0.00 $25,500.00 $75,000.00 $0.00 $0.00 $17,000.00 $25,000.00 $32,500.00 $45,800.00 $0.00 $220,800.00 $223,008.00 $225,238.08 $227,490.46 $229,765.37 $232,063.02 $234,383.65 $236,727.49 $239,094.76 $241,485.71 $243,900.57 $246,339.57 $248,802.97 $2,828,299.63
School 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
New 17,500.00 17,500.00 17,675.00 17,851.75 18,030.27 18,210.57 18,392.68 18,576.60 18,762.37 18,949.99 19,139.49 19,330.89 19,524.20 19,719.44 224,163.24
Total School $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $17,500.00 $0.00 $17,500.00 $17,675.00 $17,851.75 $18,030.27 $18,210.57 $18,392.68 $18,576.60 $18,762.37 $18,949.99 $19,139.49 $19,330.89 $19,524.20 $19,719.44 $224,163.24
Total Service Income $0.00 $0.00 $0.00 $25,500.00 $75,000.00 $0.00 $0.00 $17,000.00 $25,000.00 $32,500.00 $63,300.00 $0.00 $238,300.00 $240,683.00 $243,089.83 $245,520.73 $247,975.94 $250,455.69 $252,960.25 $255,489.85 $258,044.75 $260,625.20 $263,231.45 $265,863.77 $268,522.40 $3,052,462.87
xDiscounts given -5,000.00 -5,000.00 -125,000.00 -15,000.00 -15,000.00 -2,500.00 -14,750.00 -39,550.00 -221,800.00 -224,018.00 -226,258.18 -228,520.76 -230,805.97 -233,114.03 -235,445.17 -237,799.62 -240,177.62 -242,579.39 -245,005.19 -247,455.24 -249,929.79 -2,841,108.96
xOther Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Professional Development 200.00 200.00 202.00 204.02 206.06 208.12 210.20 212.30 214.43 216.57 218.74 220.92 223.13 225.37 2,561.87
Total xOther Income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $200.00 $0.00 $0.00 $0.00 $0.00 $200.00 $202.00 $204.02 $206.06 $208.12 $210.20 $212.30 $214.43 $216.57 $218.74 $220.92 $223.13 $225.37 $2,561.87
Total Income $15,000.00 $25,000.00 $83,500.00 $68,000.00 $89,000.00 $125,000.00 $24,000.00 $32,200.00 $180,000.00 $78,134.00 $173,750.00 $16,750.00 $910,334.00 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Cost of Goods Sold
Customer Support (After Sale) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Labor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Contractors 346.55 346.55 350.02 353.52 357.05 360.62 364.23 367.87 371.55 375.26 379.02 382.81 386.63 390.50 4,439.07
Team Building & Training 55.96 55.96 56.52 57.08 57.66 58.23 58.81 59.40 60.00 60.60 61.20 61.81 62.43 63.06 716.81
Total Labor $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $402.51 $0.00 $0.00 $0.00 $0.00 $402.51 $406.54 $410.60 $414.71 $418.85 $423.04 $427.27 $431.55 $435.86 $440.22 $444.62 $449.07 $453.56 $5,155.88
Total Customer Support (After Sale) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $402.51 $0.00 $0.00 $0.00 $0.00 $402.51 $406.54 $410.60 $414.71 $418.85 $423.04 $427.27 $431.55 $435.86 $440.22 $444.62 $449.07 $453.56 $5,155.88
Inventory Shrinkage (deleted) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Research & Development (COGS) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Data Infrastructure Base 272.60 279.07 278.95 281.62 275.25 281.59 282.85 281.08 293.15 2,526.16 2,551.42 2,576.94 2,602.71 2,628.73 2,655.02 2,681.57 2,708.39 2,735.47 2,762.82 2,790.45 2,818.36 2,846.54 32,358.41
Data Infrastructure Incremental 113.95 113.95 113.95 341.85 345.27 348.72 352.21 355.73 359.29 362.88 366.51 370.17 373.88 377.62 381.39 385.21 4,378.87
Labor 1,500.00 7,200.00 8,700.00 8,787.00 8,874.87 8,963.62 9,053.25 9,143.79 9,235.23 9,327.58 9,420.85 9,515.06 9,610.21 9,706.31 9,803.38 111,441.15
Contractors 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 36,000.00
Total Labor $0.00 $3,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,500.00 $7,200.00 $11,700.00 $11,787.00 $11,874.87 $11,963.62 $12,053.25 $12,143.79 $12,235.23 $12,327.58 $12,420.85 $12,515.06 $12,610.21 $12,706.31 $12,803.38 $147,441.15
Software 785.95 113.95 113.95 113.95 113.95 7,227.82 113.95 214.35 214.35 3,088.40 100.40 100.40 12,301.42 12,424.43 12,548.68 12,674.17 12,800.91 12,928.92 13,058.21 13,188.79 13,320.68 13,453.88 13,588.42 13,724.30 13,861.55 157,572.92
Total Research & Development (COGS) $1,058.55 $3,393.02 $392.90 $395.57 $389.20 $7,509.41 $396.80 $495.43 $507.50 $3,202.35 $1,714.35 $7,414.35 $26,869.43 $27,108.12 $27,349.21 $27,592.70 $27,838.62 $28,087.01 $28,337.88 $28,591.26 $28,847.17 $29,105.64 $29,366.70 $29,630.37 $29,896.67 $341,751.36
Total Cost of Goods Sold $1,058.55 $3,393.02 $392.90 $395.57 $389.20 $7,509.41 $396.80 $897.94 $507.50 $3,202.35 $1,714.35 $7,414.35 $27,271.94 $27,514.66 $27,759.81 $28,007.40 $28,257.48 $28,510.05 $28,765.15 $29,022.80 $29,283.03 $29,545.86 $29,811.32 $30,079.44 $30,350.23 $346,907.24
Gross Profit $13,941.45 $21,606.98 $83,107.10 $67,604.43 $88,610.80 $117,490.59 $23,603.20 $31,302.06 $179,492.50 $74,931.65 $172,035.65 $9,335.65 $883,062.06 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Expenses
Digital Sales & Marketing 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Marketing Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Labor 390.00 1,573.00 1,573.00 949.00 1,573.00 975.00 2,288.00 1,347.00 10,946.75 6,263.27 702.00 2,182.50 30,762.52 31,070.15 31,380.85 31,694.66 32,011.60 32,331.72 32,655.03 32,981.59 33,311.40 33,644.52 33,980.96 34,320.77 34,663.98 394,047.21
Operating 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Design/Content Creation 832.00 0.00 29.00 41.95 117.95 117.95 117.95 117.95 117.95 645.00 2,094.50 4,232.20 4,274.52 4,317.27 4,360.44 4,404.04 4,448.08 4,492.57 4,537.49 4,582.87 4,628.69 4,674.98 4,721.73 4,768.95 54,211.64
Facebook Spend 16.90 3.00 775.00 1,367.38 673.40 -178.66 2,657.02 2,683.59 2,710.43 2,737.53 2,764.91 2,792.55 2,820.48 2,848.69 2,877.17 2,905.94 2,935.00 2,964.35 2,994.00 34,034.64
LinkedIn Spend 87.19 87.19 87.19 87.19 87.19 174.38 261.57 261.57 261.57 1,198.83 261.57 2,855.44 2,883.99 2,912.83 2,941.96 2,971.38 3,001.10 3,031.11 3,061.42 3,092.03 3,122.95 3,154.18 3,185.72 3,217.58 36,576.27
Software 390.21 440.27 454.20 693.70 767.03 1,175.87 770.02 881.56 843.89 843.45 865.39 1,082.20 9,207.79 9,299.87 9,392.87 9,486.80 9,581.66 9,677.48 9,774.25 9,872.00 9,970.72 10,070.42 10,171.13 10,272.84 10,375.57 117,945.60
Twitter Spend 130.75 130.75 132.06 133.38 134.71 136.06 137.42 138.79 140.18 141.58 143.00 144.43 145.87 147.33 1,674.82
Website 59.00 59.00 59.00 179.00 179.00 179.00 179.00 179.00 179.00 179.00 179.00 179.00 1,788.00 1,805.88 1,823.94 1,842.18 1,860.60 1,879.21 1,898.00 1,916.98 1,936.15 1,955.51 1,975.06 1,994.82 2,014.76 22,903.08
Total Operating $1,281.21 $603.36 $600.39 $991.89 $1,980.92 $2,927.39 $1,914.75 $1,261.42 $1,402.41 $1,401.97 $2,888.22 $3,617.27 $20,871.20 $21,079.91 $21,290.71 $21,503.62 $21,718.65 $21,935.84 $22,155.20 $22,376.75 $22,600.52 $22,826.52 $23,054.79 $23,285.34 $23,518.19 $267,346.05
Travel & Meals 1,850.00 1,850.00 1,868.50 1,887.19 1,906.06 1,925.12 1,944.37 1,963.81 1,983.45 2,003.28 2,023.32 2,043.55 2,063.99 2,084.63 23,697.26
Total Marketing Expenses $1,671.21 $2,176.36 $2,173.39 $1,940.89 $3,553.92 $3,902.39 $4,202.75 $2,608.42 $12,349.16 $7,665.24 $3,590.22 $7,649.77 $53,483.72 $54,018.56 $54,558.74 $55,104.33 $55,655.37 $56,211.93 $56,774.05 $57,341.79 $57,915.20 $58,494.36 $59,079.30 $59,670.09 $60,266.79 $685,090.51
Sales Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Labor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Contractors 678.09 390.55 1,566.51 5,558.25 2,331.21 2,387.50 1,807.67 3,640.78 328.95 694.50 1,650.89 3,717.14 24,752.04 24,999.56 25,249.56 25,502.05 25,757.07 26,014.64 26,274.79 26,537.54 26,802.91 27,070.94 27,341.65 27,615.07 27,891.22 317,057.00
Team Building & Training 10.00 5.00 15.00 15.15 15.30 15.45 15.61 15.77 15.92 16.08 16.24 16.41 16.57 16.74 16.90 192.14
Total Labor $678.09 $390.55 $1,566.51 $5,558.25 $2,331.21 $2,387.50 $1,807.67 $3,640.78 $338.95 $694.50 $1,655.89 $3,717.14 $24,767.04 $25,014.71 $25,264.86 $25,517.51 $25,772.68 $26,030.41 $26,290.71 $26,553.62 $26,819.16 $27,087.35 $27,358.22 $27,631.80 $27,908.12 $317,249.14
Total Sales Expenses $678.09 $390.55 $1,566.51 $5,558.25 $2,331.21 $2,387.50 $1,807.67 $3,640.78 $338.95 $694.50 $1,655.89 $3,717.14 $24,767.04 $25,014.71 $25,264.86 $25,517.51 $25,772.68 $26,030.41 $26,290.71 $26,553.62 $26,819.16 $27,087.35 $27,358.22 $27,631.80 $27,908.12 $317,249.14
Total Digital Sales & Marketing $2,349.30 $2,566.91 $3,739.90 $7,499.14 $5,885.13 $6,289.89 $6,010.42 $6,249.20 $12,688.11 $8,359.74 $5,246.11 $11,366.91 $78,250.76 $79,033.27 $79,823.60 $80,621.84 $81,428.05 $82,242.34 $83,064.76 $83,895.41 $84,734.36 $85,581.70 $86,437.52 $87,301.90 $88,174.91 $1,002,339.65
Direct Sales & Marketing 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Marketing Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Operating 9,577.90 9,577.90 9,673.68 9,770.42 9,868.12 9,966.80 10,066.47 10,167.13 10,268.81 10,371.49 10,475.21 10,579.96 10,685.76 10,792.62 122,686.46
Collateral (Banners, Pens, Swag) 61.59 119.75 1,155.27 19.12 494.89 45.33 1,895.95 1,914.91 1,934.06 1,953.40 1,972.93 1,992.66 2,012.59 2,032.72 2,053.04 2,073.57 2,094.31 2,115.25 2,136.40 24,285.85
Event Sponsorship 2,400.00 2,500.00 737.00 5,637.00 5,693.37 5,750.30 5,807.81 5,865.88 5,924.54 5,983.79 6,043.63 6,104.06 6,165.10 6,226.75 6,289.02 6,351.91 72,206.18
Market Research 520.00 520.00 525.20 530.45 535.76 541.11 546.53 551.99 557.51 563.09 568.72 574.40 580.15 585.95 6,660.85
Partnerships/Dues/Subscriptions 5,000.00 5,950.00 2,500.00 3,500.00 16,950.00 17,119.50 17,290.70 17,463.60 17,638.24 17,814.62 17,992.77 18,172.69 18,354.42 18,537.97 18,723.35 18,910.58 19,099.68 217,118.11
Software 191.92 191.92 191.92 191.92 191.92 191.92 191.92 191.92 209.19 209.19 209.19 2,162.93 2,184.56 2,206.40 2,228.47 2,250.75 2,273.26 2,295.99 2,318.95 2,342.14 2,365.56 2,389.22 2,413.11 2,437.24 27,705.68
Total Operating $773.51 $191.92 $191.92 $191.92 $12,169.82 $7,811.67 $191.92 $5,950.00 $3,847.19 $3,728.31 $704.08 $991.52 $36,743.78 $37,111.22 $37,482.33 $37,857.15 $38,235.72 $38,618.08 $39,004.26 $39,394.31 $39,788.25 $40,186.13 $40,587.99 $40,993.87 $41,403.81 $470,663.13
Travel & Meals 90.00 47.00 585.89 722.89 0.00
Total Marketing Expenses $773.51 $191.92 $191.92 $191.92 $12,259.82 $7,858.67 $191.92 $5,950.00 $3,847.19 $3,728.31 $704.08 $1,577.41 $37,466.67 $37,111.22 $37,482.33 $37,857.15 $38,235.72 $38,618.08 $39,004.26 $39,394.31 $39,788.25 $40,186.13 $40,587.99 $40,993.87 $41,403.81 $470,663.13
Sales Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Labor 540.00 540.00 545.40 550.85 556.36 561.93 567.55 573.22 578.95 584.74 590.59 596.50 602.46 608.49 6,917.04
Contractors 899.00 2,500.00 3,500.00 432.00 7,331.00 7,404.31 7,478.35 7,553.14 7,628.67 7,704.95 7,782.00 7,859.82 7,938.42 8,017.81 8,097.98 8,178.96 8,260.75 93,905.18
Team Building & Training 169.15 102.04 271.19 273.90 276.64 279.41 282.20 285.02 287.87 290.75 293.66 296.60 299.56 302.56 305.58 3,473.76
Total Labor $899.00 $169.15 $0.00 $0.00 $2,500.00 $102.04 $0.00 $3,500.00 $0.00 $0.00 $540.00 $432.00 $8,142.19 $8,223.61 $8,305.85 $8,388.91 $8,472.80 $8,557.52 $8,643.10 $8,729.53 $8,816.83 $8,904.99 $8,994.04 $9,083.98 $9,174.82 $104,295.98
Operating 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Software 20.13 20.13 20.13 20.13 20.13 26.18 26.18 26.18 29.21 29.21 29.21 29.21 296.03 298.99 301.98 305.00 308.05 311.13 314.24 317.38 320.56 323.76 327.00 330.27 333.57 3,791.95
Total Operating $20.13 $20.13 $20.13 $20.13 $20.13 $26.18 $26.18 $26.18 $29.21 $29.21 $29.21 $29.21 $296.03 $298.99 $301.98 $305.00 $308.05 $311.13 $314.24 $317.38 $320.56 $323.76 $327.00 $330.27 $333.57 $3,791.95
Travel & Meals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Air Travel 69.95 547.90 92.10 246.59 1,325.69 2,282.23 2,305.05 2,328.10 2,351.38 2,374.90 2,398.65 2,422.63 2,446.86 2,471.33 2,496.04 2,521.00 2,546.21 2,571.67 29,233.83
Hotel 1,247.62 1,292.96 2,540.58 2,565.99 2,591.65 2,617.56 2,643.74 2,670.18 2,696.88 2,723.85 2,751.08 2,778.59 2,806.38 2,834.44 2,862.79 32,543.12
Incidentals 39.98 39.98 40.38 40.78 41.19 41.60 42.02 42.44 42.86 43.29 43.73 44.16 44.60 45.05 512.12
Internet 22.29 20.00 172.50 214.79 216.94 219.11 221.30 223.51 225.75 228.00 230.28 232.59 234.91 237.26 239.63 242.03 2,751.32
Meals 60.42 138.21 101.03 60.18 95.83 112.13 16.80 256.80 35.49 1,328.05 447.24 2,652.18 2,678.70 2,705.49 2,732.54 2,759.87 2,787.47 2,815.34 2,843.50 2,871.93 2,900.65 2,929.66 2,958.95 2,988.54 33,972.64
Transportation (Land) 84.68 139.03 93.67 47.72 169.72 306.75 571.44 253.53 414.39 187.55 835.48 808.15 3,912.11 3,951.23 3,990.74 4,030.65 4,070.96 4,111.67 4,152.78 4,194.31 4,236.25 4,278.62 4,321.40 4,364.62 4,408.26 50,111.50
Travel Meals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Travel & Meals $167.39 $297.24 $194.70 $107.90 $265.55 $418.88 $658.19 $510.33 $1,170.28 $279.65 $3,657.74 $3,914.02 $11,641.87 $11,758.29 $11,875.87 $11,994.63 $12,114.58 $12,235.72 $12,358.08 $12,481.66 $12,606.48 $12,732.54 $12,859.87 $12,988.47 $13,118.35 $149,124.53
Total Sales Expenses $1,086.52 $486.52 $214.83 $128.03 $2,785.68 $547.10 $684.37 $4,036.51 $1,199.49 $308.86 $4,226.95 $4,375.23 $20,080.09 $20,280.89 $20,483.70 $20,688.54 $20,895.42 $21,104.38 $21,315.42 $21,528.57 $21,743.86 $21,961.30 $22,180.91 $22,402.72 $22,626.75 $257,212.46
Total Direct Sales & Marketing $1,860.03 $678.44 $406.75 $319.95 $15,045.50 $8,405.77 $876.29 $9,986.51 $5,046.68 $4,037.17 $4,931.03 $5,952.64 $57,546.76 $57,392.11 $57,966.03 $58,545.69 $59,131.15 $59,722.46 $60,319.68 $60,922.88 $61,532.11 $62,147.43 $62,768.90 $63,396.59 $64,030.56 $727,875.59
General/Admin 2,158.00 2,158.00 2,179.58 2,201.38 2,223.39 2,245.62 2,268.08 2,290.76 2,313.67 2,336.80 2,360.17 2,383.77 2,407.61 2,431.69 27,642.53
Labor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Contractors 494.40 15.00 270.71 90.74 298.28 1,892.59 932.70 800.00 800.00 600.00 1,080.00 2,950.85 10,225.27 10,327.52 10,430.80 10,535.11 10,640.46 10,746.86 10,854.33 10,962.87 11,072.50 11,183.23 11,295.06 11,408.01 11,522.09 130,978.84
Recruiting 100.00 25.00 125.00 126.25 127.51 128.79 130.08 131.38 132.69 134.02 135.36 136.71 138.08 139.46 140.85 1,601.17
Team Building & Training 1,239.00 2,270.97 64.00 1,919.00 380.99 64.00 378.98 316.99 3,703.95 39.00 139.98 378.00 10,894.86 11,003.81 11,113.85 11,224.99 11,337.24 11,450.61 11,565.11 11,680.76 11,797.57 11,915.55 12,034.70 12,155.05 12,276.60 139,555.84
Total Labor $1,733.40 $2,285.97 $334.71 $2,009.74 $779.27 $1,956.59 $1,336.68 $1,116.99 $4,503.95 $639.00 $1,219.98 $3,328.85 $21,245.13 $21,457.58 $21,672.16 $21,888.88 $22,107.77 $22,328.85 $22,552.13 $22,777.65 $23,005.43 $23,235.49 $23,467.84 $23,702.52 $23,939.54 $272,135.84
Operating 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Bank & Processing Fees 25.00 25.00 25.00 25.00 194.00 190.00 484.00 488.84 493.73 498.67 503.65 508.69 513.78 518.91 524.10 529.34 534.64 539.98 545.38 6,199.71
Bank Charges -0.01 11.99 11.98 12.10 12.22 12.34 12.47 12.59 12.72 12.84 12.97 13.10 13.23 13.37 13.50 153.46
Total Bank & Processing Fees $25.00 $25.00 $24.99 $25.00 $11.99 $0.00 $0.00 $0.00 $194.00 $190.00 $0.00 $0.00 $495.98 $500.94 $505.95 $511.01 $516.12 $521.28 $526.49 $531.76 $537.08 $542.45 $547.87 $553.35 $558.88 $6,353.17
Donations 200.00 2,500.00 15.00 15.00 2,515.00 15.00 15.00 15.00 15.00 15.00 478.78 5,798.78 5,856.77 5,915.34 5,974.49 6,034.23 6,094.58 6,155.52 6,217.08 6,279.25 6,342.04 6,405.46 6,469.52 6,534.21 74,278.48
Dues & Subscriptions 596.45 159.00 250.00 1,005.45 1,015.50 1,025.66 1,035.92 1,046.28 1,056.74 1,067.31 1,077.98 1,088.76 1,099.65 1,110.64 1,121.75 1,132.97 12,879.14
Equipment 137.48 1,520.14 2,158.83 4.25 859.48 7,592.54 65.10 2,560.53 9.99 2,641.00 9.99 243.28 17,802.61 17,980.64 18,160.44 18,342.05 18,525.47 18,710.72 18,897.83 19,086.81 19,277.68 19,470.45 19,665.16 19,861.81 20,060.43 228,039.47
Gifts 31.60 42.26 175.80 103.79 801.67 284.66 1,439.78 1,454.18 1,468.72 1,483.41 1,498.24 1,513.22 1,528.36 1,543.64 1,559.08 1,574.67 1,590.41 1,606.32 1,622.38 18,442.61
Insurance 129.51 129.51 129.48 129.48 800.96 129.51 259.02 143.11 286.22 2,136.80 2,158.17 2,179.75 2,201.55 2,223.56 2,245.80 2,268.26 2,290.94 2,313.85 2,336.99 2,360.36 2,383.96 2,407.80 27,370.97
Interest Paid 925.17 801.04 864.67 630.64 569.15 656.24 561.61 619.19 599.24 694.98 849.26 1,042.11 8,813.30 8,901.43 8,990.45 9,080.35 9,171.16 9,262.87 9,355.50 9,449.05 9,543.54 9,638.98 9,735.37 9,832.72 9,931.05 112,892.45
Legal & Professional Services 474.00 599.00 1,073.00 1,083.73 1,094.57 1,105.51 1,116.57 1,127.73 1,139.01 1,150.40 1,161.91 1,173.52 1,185.26 1,197.11 1,209.08 13,744.41
Accounting 1,642.50 1,290.50 700.00 1,250.00 2,200.00 5,250.00 12,333.00 12,456.33 12,580.89 12,706.70 12,833.77 12,962.11 13,091.73 13,222.65 13,354.87 13,488.42 13,623.30 13,759.54 13,897.13 157,977.44
Legal 239.99 39.99 39.99 4,498.98 39.99 39.99 362.99 -60.01 68,424.99 73,626.90 74,363.17 75,106.80 75,857.87 76,616.45 77,382.61 78,156.44 78,938.00 79,727.38 80,524.66 81,329.90 82,143.20 82,964.63 943,111.11
Total Legal & Professional Services $713.99 $1,682.49 $1,330.49 $5,198.98 $39.99 $1,289.99 $2,562.99 -$60.01 $69,023.99 $0.00 $0.00 $5,250.00 $87,032.90 $87,903.23 $88,782.26 $89,670.08 $90,566.78 $91,472.45 $92,387.18 $93,311.05 $94,244.16 $95,186.60 $96,138.47 $97,099.85 $98,070.85 $1,114,832.97
Office Supplies 178.96 86.22 344.62 -10.05 1.99 139.95 741.69 749.11 756.60 764.16 771.81 779.52 787.32 795.19 803.14 811.18 819.29 827.48 835.75 9,500.55
Other Business Expenses 100.00 395.00 75.22 570.22 575.92 581.68 587.50 593.37 599.31 605.30 611.35 617.47 623.64 629.88 636.18 642.54 7,304.14
Rent & Lease 245.00 45.00 45.00 75.00 410.00 414.10 418.24 422.42 426.65 430.91 435.22 439.58 443.97 448.41 452.90 457.42 462.00 5,251.82
Shipping 215.89 11.85 11.97 7.62 173.60 464.95 250.75 1,136.63 1,148.00 1,159.48 1,171.07 1,182.78 1,194.61 1,206.56 1,218.62 1,230.81 1,243.12 1,255.55 1,268.10 1,280.78 14,559.47
Software 1,367.14 799.80 801.37 813.37 2,530.44 1,240.18 1,086.41 1,208.58 1,117.98 11,393.25 1,413.75 1,534.86 25,307.13 25,560.20 25,815.80 26,073.96 26,334.70 26,598.05 26,864.03 27,132.67 27,404.00 27,678.04 27,954.82 28,234.36 28,516.71 324,167.33
Taxes & Licenses 76.69 26.00 102.69 103.72 104.75 105.80 106.86 107.93 109.01 110.10 111.20 112.31 113.43 114.57 115.71 1,315.39
Total Operating $4,138.14 $5,717.25 $8,500.71 $6,895.21 $4,026.05 $14,106.88 $4,596.42 $4,877.69 $71,532.77 $15,152.56 $3,879.62 $9,370.66 $152,793.96 $154,321.90 $155,865.12 $157,423.77 $158,998.01 $160,587.99 $162,193.87 $163,815.81 $165,453.96 $167,108.50 $168,779.59 $170,467.38 $172,172.06 $1,957,187.96
Travel & Meals 19.63 19.63 19.83 20.02 20.22 20.43 20.63 20.84 21.05 21.26 21.47 21.68 21.90 22.12 251.45
Meals & Entertainment 53.80 106.49 74.60 104.93 20.57 3,272.85 3,633.24 3,669.57 3,706.27 3,743.33 3,780.76 3,818.57 3,856.76 3,895.33 3,934.28 3,973.62 4,013.36 4,053.49 4,094.03 46,539.36
Total Travel & Meals $0.00 $19.63 $0.00 $53.80 $0.00 $0.00 $106.49 $74.60 $104.93 $0.00 $20.57 $3,272.85 $3,652.87 $3,689.40 $3,726.29 $3,763.56 $3,801.19 $3,839.20 $3,877.60 $3,916.37 $3,955.53 $3,995.09 $4,035.04 $4,075.39 $4,116.15 $46,790.81
Total General/Admin $8,029.54 $8,022.85 $8,835.42 $8,958.75 $4,805.32 $16,063.47 $6,039.59 $6,069.28 $76,141.65 $15,791.56 $5,120.17 $15,972.36 $179,849.96 $181,648.46 $183,464.94 $185,299.59 $187,152.59 $189,024.12 $190,914.36 $192,823.50 $194,751.74 $196,699.25 $198,666.25 $200,652.91 $202,659.44 $2,303,757.14
Payroll Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Company Benefits & Contributions 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Athletic Facilities 383.50 21.00 58.82 68.91 21.00 201.00 231.00 231.00 231.00 244.79 231.00 376.78 2,299.80 2,322.80 2,346.03 2,369.49 2,393.18 2,417.11 2,441.28 2,465.70 2,490.35 2,515.26 2,540.41 2,565.81 2,591.47 29,458.89
Cell Service 537.35 436.01 451.35 732.51 378.43 396.76 396.76 322.56 416.61 416.10 416.10 4,900.54 4,949.55 4,999.04 5,049.03 5,099.52 5,150.52 5,202.02 5,254.04 5,306.58 5,359.65 5,413.24 5,467.38 5,522.05 62,772.62
Medical Benefits 3,087.40 396.60 2,510.10 3,342.19 2,375.06 4,033.16 4,737.85 6,586.01 4,757.59 3,827.01 4,487.67 6,005.98 46,146.62 46,608.09 47,074.17 47,544.91 48,020.36 48,500.56 48,985.57 49,475.42 49,970.18 50,469.88 50,974.58 51,484.32 51,999.17 591,107.19
Retirement Benefits 3,048.85 3,048.85 3,079.34 3,110.13 3,141.23 3,172.65 3,204.37 3,236.42 3,268.78 3,301.47 3,334.48 3,367.83 3,401.51 3,435.52 39,053.72
Total Company Benefits & Contributions $7,057.10 $853.61 $3,020.27 $4,143.61 $2,774.49 $4,630.92 $5,365.61 $7,139.57 $5,405.20 $4,487.90 $5,134.77 $6,382.76 $56,395.81 $56,959.77 $57,529.37 $58,104.66 $58,685.71 $59,272.56 $59,865.29 $60,463.94 $61,068.58 $61,679.27 $62,296.06 $62,919.02 $63,548.21 $722,392.43
Company Contributions 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Retirement 487.50 1,055.78 1,583.67 1,055.78 1,881.36 1,448.07 1,564.02 1,951.54 2,500.95 1,773.81 1,787.70 17,090.18 17,261.08 17,433.69 17,608.03 17,784.11 17,961.95 18,141.57 18,322.99 18,506.22 18,691.28 18,878.19 19,066.97 19,257.64 218,913.72
Total Company Contributions $0.00 $487.50 $1,055.78 $1,583.67 $1,055.78 $1,881.36 $1,448.07 $1,564.02 $1,951.54 $2,500.95 $1,773.81 $1,787.70 $17,090.18 $17,261.08 $17,433.69 $17,608.03 $17,784.11 $17,961.95 $18,141.57 $18,322.99 $18,506.22 $18,691.28 $18,878.19 $19,066.97 $19,257.64 $218,913.72
Reimbursements 649.99 649.99 656.49 663.05 669.69 676.38 683.15 689.98 696.88 703.85 710.88 717.99 725.17 732.43 8,325.94
Salary & Wages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
C-level - Salaries 15,769.22 31,538.44 31,538.44 78,846.10 79,634.56 80,430.91 81,235.22 82,047.57 82,868.04 83,696.72 84,533.69 85,379.03 86,232.82 87,095.15 87,966.10 88,845.76 1,009,965.56
Marketing - Salaries 5,384.62 19,126.94 16,512.90 41,024.46 41,434.70 41,849.05 42,267.54 42,690.22 43,117.12 43,548.29 43,983.77 44,423.61 44,867.85 45,316.53 45,769.69 46,227.39 525,495.77
Operations - Salaries 3,076.92 6,153.84 6,153.84 15,384.60 15,538.45 15,693.83 15,850.77 16,009.28 16,169.37 16,331.06 16,494.37 16,659.32 16,825.91 16,994.17 17,164.11 17,335.75 197,066.39
Sales - Salaries 2,692.31 5,384.62 5,384.62 13,461.55 13,596.17 13,732.13 13,869.45 14,008.14 14,148.22 14,289.71 14,432.60 14,576.93 14,722.70 14,869.93 15,018.63 15,168.81 172,433.41
Total Salary & Wages $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26,923.07 $62,203.84 $59,589.80 $148,716.71 $150,203.88 $151,705.92 $153,222.98 $154,755.20 $156,302.76 $157,865.78 $159,444.44 $161,038.89 $162,649.28 $164,275.77 $165,918.53 $167,577.71 $1,904,961.12
Taxes 2,843.33 1,440.46 2,966.37 4,282.74 2,773.18 5,407.45 4,605.98 5,101.67 4,908.69 6,163.59 4,809.94 4,565.66 49,869.06 4,565.66 4,565.66 4,565.66 4,565.66 4,565.66 4,565.66 4,565.66 4,565.66 4,565.66 4,565.66 4,565.66 4,565.66 54,787.92
Wages 37,115.37 18,173.08 35,192.32 52,788.48 35,192.32 64,461.56 48,269.24 58,288.44 58,897.83 53,365.37 461,744.01 38,478.67 38,478.67 38,478.67 38,478.67 38,478.67 38,478.67 38,478.67 38,478.67 38,478.67 38,478.67 38,478.67 38,478.67 461,744.01
Total Payroll Expenses $47,665.79 $20,954.65 $42,234.74 $62,798.50 $41,795.77 $76,381.29 $59,688.90 $72,093.70 $71,163.26 $93,440.88 $73,922.36 $72,325.92 $734,465.76 $268,125.54 $270,376.36 $272,649.68 $274,945.73 $277,264.74 $279,606.95 $281,972.57 $284,361.86 $286,775.03 $289,212.34 $291,674.02 $294,160.32 $3,371,125.14
Research & Development 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Operating 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Research 53.11 285.07 293.42 293.31 924.91 934.16 943.50 952.94 962.47 972.09 981.81 991.63 1,001.54 1,011.56 1,021.68 1,031.89 1,042.21 11,847.48
Total Operating $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $53.11 $0.00 $0.00 $285.07 $293.42 $293.31 $924.91 $934.16 $943.50 $952.94 $962.47 $972.09 $981.81 $991.63 $1,001.54 $1,011.56 $1,021.68 $1,031.89 $1,042.21 $11,847.48
Total Research & Development $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $53.11 $0.00 $0.00 $285.07 $293.42 $293.31 $924.91 $934.16 $943.50 $952.94 $962.47 $972.09 $981.81 $991.63 $1,001.54 $1,011.56 $1,021.68 $1,031.89 $1,042.21 $11,847.48
Total Expenses $59,904.66 $32,222.85 $55,216.81 $79,576.34 $67,531.72 $107,140.42 $72,668.31 $94,398.69 $165,039.70 $121,914.42 $89,513.09 $105,911.14 $1,051,038.15 $587,133.54 $592,574.43 $598,069.73 $603,619.99 $609,225.74 $614,887.56 $620,605.99 $626,381.61 $632,214.98 $638,106.69 $644,057.31 $650,067.44 $7,416,945.00
Net Operating Income -$45,963.21 -$10,615.87 $27,890.29 -$11,971.91 $21,079.08 $10,350.17 -$49,065.11 -$63,096.63 $14,452.80 -$46,982.77 $82,522.56 -$96,575.49 -$167,976.09 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Other Expenses
Other Miscellaneous Expense -7,500.00 7,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Other Expenses $0.00 $0.00 $0.00 -$7,500.00 $7,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Net Other Income $0.00 $0.00 $0.00 $7,500.00 -$7,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Net Income -$45,963.21 -$10,615.87 $27,890.29 -$4,471.91 $13,579.08 $10,350.17 -$49,065.11 -$63,096.63 $14,452.80 -$46,982.77 $82,522.56 -$96,575.49 -$167,976.09 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

Balance Sheet

Innovare - Social Innovation Partners
Balance Sheet
As of June 30, 2021
Jul-2020 Aug-2020 Sep-2020 Oct-2020 Nov-2020 Dec-2020 Jan-2021 Feb-2021 Mar-2021 Apr-2021 May-2021 Jun-2021 Jul-2021 Aug-2021 Sep-2021 Oct-2021 Nov-2021 Dec-2021 Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022
ASSETS
Current Assets
Bank Accounts
TOTAL BUS CHK (8622) 161,779.73 163,344.81 261,609.75 251,327.59 267,084.79 294,518.66 383,910.71 351,842.79 329,517.02 257,450.87 205,219.94 188,930.64 190,819.95 192,728.15 194,655.43 196,601.98 198,568.00 200,553.68 202,559.22 204,584.81 206,630.66 208,696.97 210,783.93 212,891.77
Total Bank Accounts $161,779.73 $163,344.81 $261,609.75 $251,327.59 $267,084.79 $294,518.66 $383,910.71 $351,842.79 $329,517.02 $257,450.87 $205,219.94 $188,930.64 $190,819.95 $192,728.15 $194,655.43 $196,601.98 $198,568.00 $200,553.68 $202,559.22 $204,584.81 $206,630.66 $208,696.97 $210,783.93 $212,891.77
Accounts Receivable
Accounts Receivable (A/R) 132,500.00 103,750.00 166,000.00 184,000.00 195,000.00 213,500.00 79,000.00 56,000.00 180,000.00 233,134.00 379,384.00 282,634.00 285,460.34 288,314.94 291,198.09 294,110.07 297,051.17 300,021.69 303,021.90 306,052.12 309,112.64 312,203.77 315,325.81 318,479.07
Total Accounts Receivable $132,500.00 $103,750.00 $166,000.00 $184,000.00 $195,000.00 $213,500.00 $79,000.00 $56,000.00 $180,000.00 $233,134.00 $379,384.00 $282,634.00 $285,460.34 $288,314.94 $291,198.09 $294,110.07 $297,051.17 $300,021.69 $303,021.90 $306,052.12 $309,112.64 $312,203.77 $315,325.81 $318,479.07
Other Current Assets
Inventory Asset 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Undeposited Funds 0.00 0.00 6,250.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Other Current Assets $0.00 $0.00 $6,250.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total Current Assets $294,279.73 $267,094.81 $433,859.75 $435,327.59 $462,084.79 $508,018.66 $462,910.71 $407,842.79 $509,517.02 $490,584.87 $584,603.94 $471,564.64 $476,280.29 $481,043.09 $485,853.52 $490,712.06 $495,619.18 $500,575.37 $505,581.12 $510,636.93 $515,743.30 $520,900.73 $526,109.74 $531,370.84
TOTAL ASSETS $294,279.73 $267,094.81 $433,859.75 $435,327.59 $462,084.79 $508,018.66 $462,910.71 $407,842.79 $509,517.02 $490,584.87 $584,603.94 $471,564.64 $476,280.29 $481,043.09 $485,853.52 $490,712.06 $495,619.18 $500,575.37 $505,581.12 $510,636.93 $515,743.30 $520,900.73 $526,109.74 $531,370.84
LIABILITIES AND EQUITY
Liabilities
Current Liabilities
Accounts Payable
Accounts Payable (A/P) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,000.00 1,010.00 1,020.10 1,030.30 1,040.60 1,051.01 1,061.52 1,072.14 1,082.86 1,093.69 1,104.62 1,115.67 1,126.83
Total Accounts Payable $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,000.00 $1,010.00 $1,020.10 $1,030.30 $1,040.60 $1,051.01 $1,061.52 $1,072.14 $1,082.86 $1,093.69 $1,104.62 $1,115.67 $1,126.83
Credit Cards
Chase Credit Cards 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Chase Ink (9835) 27,508.13 23,976.40 15,953.02 17,147.04 18,984.65 24,430.60 25,624.37 29,006.92 33,782.04 47,948.28 49,311.47 49,277.43 49,770.20 50,267.91 50,770.59 51,278.29 51,791.07 52,308.98 52,832.07 53,360.40 53,894.00 54,432.94 54,977.27 55,527.04
SWA VISA (4463) 21,065.87 17,696.43 13,006.54 14,708.05 23,201.10 15,324.15 15,854.24 15,648.83 15,943.31 15,781.93 15,711.67 17,065.28 17,235.93 17,408.29 17,582.38 17,758.20 17,935.78 18,115.14 18,296.29 18,479.25 18,664.05 18,850.69 19,039.19 19,229.58
United Credit Card (7341) 13,727.89 10,978.43 7,743.02 7,739.98 7,676.42 2,864.63 2,899.24 2,958.05 2,928.02 6,100.31 7,248.05 7,175.35 7,247.10 7,319.57 7,392.77 7,466.70 7,541.36 7,616.78 7,692.95 7,769.88 7,847.57 7,926.05 8,005.31 8,085.36
Total Chase Credit Cards $62,301.89 $52,651.26 $36,702.58 $39,595.07 $49,862.17 $42,619.38 $44,377.85 $47,613.80 $52,653.37 $69,830.52 $72,271.19 $73,518.06 $74,253.24 $74,995.77 $75,745.73 $76,503.19 $77,268.22 $78,040.90 $78,821.31 $79,609.52 $80,405.62 $81,209.68 $82,021.77 $82,841.99
CitiBusiness / AAdvantage Platinum (1195) 2,737.67 3,445.50 1,844.43 170.10 3,593.22 1,352.63 739.47 684.87 2,347.96 203.19 2,430.91 4,831.24 4,879.55 4,928.35 4,977.63 5,027.41 5,077.68 5,128.46 5,179.74 5,231.54 5,283.86 5,336.69 5,390.06 5,443.96
Divvy CC 2,172.04 1,199.00 2,849.85 3,183.53 2,827.37 5,778.65 3,504.45 2,364.42 1,690.66 4,611.91 2,386.76 6,437.80 6,502.18 6,567.20 6,632.87 6,699.20 6,766.19 6,833.85 6,902.19 6,971.21 7,040.93 7,111.34 7,182.45 7,254.27
Total Credit Cards $67,211.60 $57,295.76 $41,396.86 $42,948.70 $56,282.76 $49,750.66 $48,621.77 $50,663.09 $56,691.99 $74,645.62 $77,088.86 $84,787.10 $85,634.97 $86,491.32 $87,356.23 $88,229.80 $89,112.09 $90,003.22 $90,903.25 $91,812.28 $92,730.40 $93,657.71 $94,594.28 $95,540.23
Other Current Liabilities
Direct Deposit Payable 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payroll Liabilities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
CO Income Tax 73.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
CO Local Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
CO Unemployment Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
CT Income Tax 0.00 0.00 0.00 0.00 358.33 615.59 486.96 486.96 744.22 1,001.48 -77.65 -78.43 -79.21 -80.00 -80.80 -81.61 -82.43 -83.25 -84.08 -84.92 -85.77 -86.63 -87.50
CT Paid Family and Medical Leave 0.00 0.00 0.00 0.00 0.00 26.92 53.84 80.76 40.38 67.30 91.40 92.31 93.24 94.17 95.11 96.06 97.02 97.99 98.97 99.96 100.96 101.97 102.99
CT Unemployment Tax 0.00 0.00 0.00 0.00 228.31 400.62 572.93 480.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Federal Taxes (941/944) 3,089.29 0.00 0.00 4,792.65 4,792.57 0.00 0.00 0.00 0.00 7,502.47 8,185.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Federal Unemployment (940) 0.00 23.66 82.38 84.00 84.00 168.00 444.70 554.42 158.62 158.62 200.62 200.62 202.63 204.65 206.70 208.77 210.85 212.96 215.09 217.24 219.42 221.61 223.83 226.06
IL Income Tax 1,562.10 650.72 1,301.44 1,952.16 1,301.44 1,986.04 1,415.19 1,586.13 1,587.28 2,395.49 1,612.86 1,612.86 1,628.99 1,645.28 1,661.73 1,678.35 1,695.13 1,712.08 1,729.20 1,746.50 1,763.96 1,781.60 1,799.42 1,817.41
IL Unemployment Tax 0.00 16.23 48.68 30.95 30.95 30.95 200.72 394.98 452.95 21.15 21.15 21.15 21.36 21.58 21.79 22.01 22.23 22.45 22.68 22.90 23.13 23.36 23.60 23.83
MA Income Tax 62.11 310.65 434.92 434.92 764.36 999.54 519.01 204.25 536.83 1,053.39 432.25 436.57 440.94 445.35 449.80 454.30 458.84 463.43 468.06 472.75 477.47 482.25 487.07
MA Paid Family and Medical Leave 10.10 50.50 70.70 70.70 97.67 118.03 91.22 106.08 75.54 127.49 171.69 173.41 175.14 176.89 178.66 180.45 182.25 184.07 185.92 187.77 189.65 191.55 193.46
MA Unemployment Tax 5.33 168.27 230.09 230.09 393.91 517.55 405.97 4.83 4.83 14.19 4.45 4.49 4.54 4.58 4.63 4.68 4.72 4.77 4.82 4.87 4.92 4.96 5.01
MD Income Tax 0.00 0.00 413.86 827.72 1,241.58 1,448.51 1,448.51 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
MD Unemployment Tax 0.00 0.00 140.00 221.00 221.00 361.00 442.00 221.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
NY MCTMT Employer Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
NYS Employment Taxes 0.00 0.00 0.00 0.00 0.00 0.00 196.93 377.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
NYS Income Tax 0.00 0.00 0.00 0.00 0.00 0.00 312.30 624.60 468.45 780.75 312.30 315.42 318.58 321.76 324.98 328.23 331.51 334.83 338.18 341.56 344.97 348.42 351.91
SMPLIRA 3,611.85 914.88 4,594.66 2,795.16 2,795.16 -1,585.80 2,488.96 8,011.98 -2,013.88 972.50 8,959.85 -2,013.88 -2,034.02 -2,054.36 -2,074.90 -2,095.65 -2,116.61 -2,137.77 -2,159.15 -2,180.74 -2,202.55 -2,224.58 -2,246.82 -2,269.29
TX Unemployment Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Payroll Liabilities $8,336.24 $1,683.03 $6,556.58 $10,944.49 $10,788.55 $3,904.35 $9,037.33 $15,077.18 $2,771.05 $12,920.48 $22,024.82 $755.19 $762.74 $770.37 $778.07 $785.85 $793.71 $801.65 $809.67 $817.76 $825.94 $834.20 $842.54 $850.97
Total Other Current Liabilities $8,336.24 $1,683.03 $6,556.58 $10,944.49 $10,788.55 $3,904.35 $9,037.33 $15,077.18 $2,771.05 $12,920.48 $22,024.82 $755.19 $762.74 $770.37 $778.07 $785.85 $793.71 $801.65 $809.67 $817.76 $825.94 $834.20 $842.54 $850.97
Total Current Liabilities $75,547.84 $58,978.79 $47,953.44 $53,893.19 $67,071.31 $53,655.01 $57,659.10 $65,740.27 $59,463.04 $87,566.10 $99,113.68 $86,542.29 $87,407.71 $88,281.79 $89,164.61 $90,056.25 $90,956.82 $91,866.38 $92,785.05 $93,712.90 $94,650.03 $95,596.53 $96,552.49 $97,518.02
Long-Term Liabilities
Notes Payable 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
CHICAGO ERF 0.00 0.00 0.00 0.00 50,000.00 49,953.07 49,900.61 49,852.27 49,799.83 49,748.76 45,856.34 46,314.90 46,778.05 47,245.83 47,718.29 48,195.47 48,677.43 49,164.20 49,655.85 50,152.40 50,653.93 51,160.47 51,672.07
SBA EIDL 0.00 149,900.00 149,900.00 149,900.00 149,900.00 149,900.00 149,900.00 149,900.00 149,900.00 149,900.00 149,900.00 151,399.00 152,912.99 154,442.12 155,986.54 157,546.41 159,121.87 160,713.09 162,320.22 163,943.42 165,582.86 167,238.69 168,911.07
SBA PPP 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 173,547.00 173,547.00 173,547.00 173,547.00 175,282.47 177,035.29 178,805.65 180,593.70 182,399.64 184,223.64 186,065.87 187,926.53 189,805.80 191,703.86 193,620.89 195,557.10
Total Notes Payable $80,000.00 $80,000.00 $229,900.00 $229,900.00 $229,900.00 $279,900.00 $279,853.07 $279,800.61 $373,299.27 $373,246.83 $373,195.76 $369,303.34 $372,996.37 $376,726.34 $380,493.60 $384,298.54 $388,141.52 $392,022.94 $395,943.17 $399,902.60 $403,901.62 $407,940.64 $412,020.05 $416,140.25
Total Long-Term Liabilities $80,000.00 $80,000.00 $229,900.00 $229,900.00 $229,900.00 $279,900.00 $279,853.07 $279,800.61 $373,299.27 $373,246.83 $373,195.76 $369,303.34 $372,996.37 $376,726.34 $380,493.60 $384,298.54 $388,141.52 $392,022.94 $395,943.17 $399,902.60 $403,901.62 $407,940.64 $412,020.05 $416,140.25
Total Liabilities $155,547.84 $138,978.79 $277,853.44 $283,793.19 $296,971.31 $333,555.01 $337,512.17 $345,540.88 $432,762.31 $460,812.93 $472,309.44 $455,845.63 $460,404.09 $465,008.13 $469,658.21 $474,354.79 $479,098.34 $483,889.32 $488,728.22 $493,615.50 $498,551.65 $503,537.17 $508,572.54 $513,658.27
Equity
Opening Balance Equity -10,903.87 -10,903.87 -10,903.87 -10,903.87 -10,903.87 -10,903.87 -10,903.87 -10,903.87 -10,903.87 -10,903.87 -10,903.87 -10,903.87 -11,012.91 -11,123.04 -11,234.27 -11,346.61 -11,460.08 -11,574.68 -11,690.42 -11,807.33 -11,925.40 -12,044.66 -12,165.10 -12,286.75
Owner's Equity -526.85 -526.85 -526.85 -526.85 -526.85 -1,526.85 -1,526.85 -1,526.85 -1,526.85 -1,526.85 -1,526.85 -1,526.85 -1,542.12 -1,557.54 -1,573.12 -1,588.85 -1,604.73 -1,620.78 -1,636.99 -1,653.36 -1,669.89 -1,686.59 -1,703.46 -1,720.49
Retained Earnings 196,125.82 196,125.82 196,125.82 196,125.82 196,125.82 196,125.82 196,125.82 196,125.82 196,125.82 196,125.82 196,125.82 196,125.82 198,087.08 200,067.95 202,068.63 204,089.31 206,130.21 208,191.51 210,273.43 212,376.16 214,499.92 216,644.92 218,811.37 220,999.48
Net Income ERROR:#REF! -56,579.08 -28,688.79 -33,160.70 -19,581.62 -9,231.45 -58,296.56 -121,393.19 -106,940.39 -153,923.16 -71,400.60 -167,976.09 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Total Equity ERROR:#REF! $128,116.02 $156,006.31 $151,534.40 $165,113.48 $174,463.65 $125,398.54 $62,301.91 $76,754.71 $29,771.94 $112,294.50 $15,719.01 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
TOTAL LIABILITIES AND EQUITY ERROR:#REF! $267,094.81 $433,859.75 $435,327.59 $462,084.79 $508,018.66 $462,910.71 $407,842.79 $509,517.02 $490,584.87 $584,603.94 $471,564.64 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

Statement of Cash Flows

Innovare - Social Innovation Partners
Statement of Cash Flows
July 2020 - June 2021
Jul-2020 Aug-2020 Sep-2020 Oct-2020 Nov-2020 Dec-2020 Jan-2021 Feb-2021 Mar-2021 Apr-2021 May-2021 Jun-2021 Total Jul-2021 Aug-2021 Sep-2021 Oct-2021 Nov-2021 Dec-2021 Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022 Total
OPERATING ACTIVITIES
Net Income -45,963.21 -10,615.87 27,890.29 -4,471.91 13,579.08 10,350.17 -49,065.11 -63,096.63 14,452.80 -46,982.77 82,522.56 -96,575.49 -167,976.09 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Adjustments to reconcile Net Income to Net Cash provided by operations:
Accounts Receivable (A/R) -6,000.00 28,750.00 -62,250.00 -18,000.00 -11,000.00 -18,500.00 134,500.00 23,000.00 -124,000.00 -53,134.00 -146,250.00 96,750.00 -156,134.00 -157,695.34 -159,272.29 -160,865.02 -162,473.67 -164,098.40 -165,739.39 -167,396.78 -169,070.75 -170,761.46 -172,469.07 -174,193.76 -175,935.70 -1,999,971.62
Inventory Asset 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Accounts Payable (A/P) 1,000.00 1,000.00 1,010.00 1,010.00 1,020.10 1,020.10 1,030.30 1,030.30 1,040.60 1,040.60 1,051.01 1,051.01 1,061.52 1,061.52 12,427.07
Chase Credit Cards:Chase Ink (9835) 2,984.73 -3,531.73 -8,023.38 1,194.02 1,837.61 5,445.95 1,193.77 3,382.55 4,775.12 14,166.24 1,363.19 -34.04 24,754.03 -34.38 25,001.57 -34.72 25,251.59 -35.07 25,504.10 -35.42 25,759.14 -35.78 26,016.73 -36.13 26,276.90 153,598.53
Chase Credit Cards:SWA VISA (4463) 2,197.73 -3,369.44 -4,689.89 1,701.51 8,493.05 -7,876.95 530.09 -205.41 294.48 -161.38 -70.26 1,353.61 -1,802.86 1,367.15 -1,820.89 1,380.82 -1,839.10 1,394.63 -1,857.49 1,408.57 -1,876.06 1,422.66 -1,894.82 1,436.88 -1,913.77 -2,791.43
Chase Credit Cards:United Credit Card (7341) 278.00 -2,749.46 -3,235.41 -3.04 -63.56 -4,811.79 34.61 58.81 -30.03 3,172.29 1,147.74 -72.70 -6,274.54 -73.43 -6,337.29 -74.16 -6,400.66 -74.90 -6,464.66 -75.65 -6,529.31 -76.41 -6,594.60 -77.17 -6,660.55 -39,438.80
CitiBusiness / AAdvantage Platinum (1195) 706.62 707.83 -1,601.07 -1,674.33 3,423.12 -2,240.59 -613.16 -54.60 1,663.09 -2,144.77 2,227.72 2,400.33 2,800.19 2,424.33 2,828.19 2,448.58 2,856.47 2,473.06 2,885.04 2,497.79 2,913.89 2,522.77 2,943.03 2,548.00 2,972.46 32,313.61
Divvy CC 2,172.04 -973.04 1,650.85 333.68 -356.16 2,951.28 -2,274.20 -1,140.03 -673.76 2,921.25 -2,225.15 4,051.04 6,437.80 4,091.55 6,502.18 4,132.47 6,567.20 4,173.79 6,632.87 4,215.53 6,699.20 4,257.68 6,766.19 4,300.26 6,833.85 65,172.78
Direct Deposit Payable 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payroll Liabilities:CO Income Tax -91.00 -73.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -164.00 0.00 -165.64 0.00 -167.30 0.00 -168.97 0.00 -170.66 0.00 -172.37 0.00 -174.09 -1,019.02
Payroll Liabilities:CO Local Tax -19.50 -19.50 0.00 -19.70 0.00 -19.89 0.00 -20.09 0.00 -20.29 0.00 -20.49 0.00 -20.70 -121.16
Payroll Liabilities:CO Unemployment Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payroll Liabilities:CT Income Tax 358.33 257.26 -128.63 0.00 257.26 257.26 -1,079.13 -77.65 -1,089.92 -78.43 -1,100.82 -79.21 -1,111.83 -80.00 -1,122.95 -80.80 -1,134.18 -81.61 -1,145.52 -82.43 -7,187.69
Payroll Liabilities:CT Paid Family and Medical Leave 26.92 26.92 26.92 -40.38 26.92 24.10 91.40 24.34 92.31 24.58 93.24 24.83 94.17 25.08 95.11 25.33 96.06 25.58 97.02 717.66
Payroll Liabilities:CT Unemployment Tax 228.31 172.31 172.31 -92.93 -480.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payroll Liabilities:Federal Taxes (941/944) 3,089.29 -3,089.29 0.00 4,792.65 -0.08 -4,792.57 0.00 0.00 0.00 7,502.47 683.27 -8,185.74 0.00 -8,267.60 0.00 -8,350.27 0.00 -8,433.78 0.00 -8,518.11 0.00 -8,603.30 0.00 -8,689.33 0.00 -50,862.38
Payroll Liabilities:Federal Unemployment (940) 0.00 23.66 58.72 1.62 0.00 84.00 276.70 109.72 -395.80 0.00 42.00 0.00 200.62 0.00 202.63 0.00 204.65 0.00 206.70 0.00 208.77 0.00 210.85 0.00 212.96 1,246.56
Payroll Liabilities:IL Income Tax 502.12 -911.38 650.72 650.72 -650.72 684.60 -570.85 170.94 1.15 808.21 -782.63 0.00 552.88 0.00 558.41 0.00 563.99 0.00 569.63 0.00 575.33 0.00 581.08 0.00 586.89 3,435.34
Payroll Liabilities:IL Unemployment Tax 0.00 16.23 32.45 -17.73 0.00 0.00 169.77 194.26 57.97 -431.80 0.00 0.00 21.15 0.00 21.36 0.00 21.58 0.00 21.79 0.00 22.01 0.00 22.23 0.00 22.45 131.42
Payroll Liabilities:MA Income Tax 62.11 248.54 124.27 0.00 329.44 235.18 -480.53 -314.76 332.58 516.56 -621.14 432.25 -627.35 436.57 -633.62 440.94 -639.96 445.35 -646.36 449.80 -652.82 454.30 -659.35 458.84 -1,173.67
Payroll Liabilities:MA Paid Family and Medical Leave 10.10 40.40 20.20 0.00 26.97 20.36 -26.81 14.86 -30.54 51.95 44.20 171.69 44.64 173.41 45.09 175.14 45.54 176.89 45.99 178.66 46.45 180.45 46.92 182.25 1,341.44
Payroll Liabilities:MA Unemployment Tax 5.33 162.94 61.82 0.00 163.82 123.64 -111.58 -401.14 0.00 9.36 -9.74 4.45 -9.84 4.49 -9.94 4.54 -10.04 4.58 -10.14 4.63 -10.24 4.68 -10.34 4.72 -32.87
Payroll Liabilities:MD Income Tax 413.86 413.86 413.86 206.93 0.00 -1,448.51 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payroll Liabilities:MD Unemployment Tax 140.00 81.00 0.00 140.00 81.00 -221.00 -221.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payroll Liabilities:NY MCTMT Employer Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payroll Liabilities:NYS Employment Taxes 196.93 180.67 -377.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payroll Liabilities:NYS Income Tax 312.30 312.30 -156.15 312.30 -468.45 312.30 -473.13 315.42 -477.87 318.58 -482.64 321.76 -487.47 324.98 -492.35 328.23 -497.27 331.51 -970.24
Payroll Liabilities:SMPLIRA 3,611.85 -2,696.97 3,679.78 -1,799.50 0.00 -4,380.96 4,074.76 5,523.02 -10,025.86 2,986.38 7,987.35 -10,973.73 -2,013.88 -11,083.47 -2,034.02 -11,194.30 -2,054.36 -11,306.24 -2,074.90 -11,419.31 -2,095.65 -11,533.50 -2,116.61 -11,648.84 -2,137.77 -80,698.97
Payroll Liabilities:TX Unemployment Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Adjustments to reconcile Net Income to Net Cash provided by operations: $9,431.88 $12,180.95 -$73,275.35 -$12,060.25 $2,178.12 -$31,916.30 $138,504.09 $31,081.17 -$130,277.23 -$25,030.94 -$134,702.42 $84,178.61 -$129,707.67 -$170,392.44 -$132,581.70 -$173,689.09 -$135,516.17 -$177,050.72 -$138,512.31 -$180,478.62 -$141,571.40 -$183,974.11 -$144,694.73 -$187,538.55 -$147,883.62 -$1,913,883.47
Net cash provided by operating activities -$36,531.33 $1,565.08 -$45,385.06 -$16,532.16 $15,757.20 -$21,566.13 $89,438.98 -$32,015.46 -$115,824.43 -$72,013.71 -$52,179.86 -$12,396.88 -$297,683.76 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
FINANCING ACTIVITIES
Notes Payable:CHICAGO ERF 50,000.00 -46.93 -52.46 -48.34 -52.44 -51.07 -3,892.42 45,856.34 -3,931.34 46,314.90 -3,970.66 46,778.05 -4,010.36 47,245.83 -4,050.47 47,718.29 -4,090.97 48,195.47 -4,131.88 48,677.43 260,744.29
Notes Payable:SBA EIDL 149,900.00 149,900.00 0.00 151,399.00 0.00 152,912.99 0.00 154,442.12 0.00 155,986.54 0.00 157,546.41 0.00 159,121.87 931,408.93
Notes Payable:SBA PPP 93,547.00 93,547.00 0.00 94,482.47 0.00 95,427.29 0.00 96,381.57 0.00 97,345.38 0.00 98,318.84 0.00 99,302.03 581,257.58
Opening Balance Equity 26.90 26.90 0.00 27.17 0.00 27.44 0.00 27.72 0.00 27.99 0.00 28.27 0.00 28.55 167.14
Owner's Equity -1,000.00 -1,000.00 0.00 -1,010.00 0.00 -1,020.10 0.00 -1,030.30 0.00 -1,040.60 0.00 -1,051.01 0.00 -1,061.52 -6,213.54
Net cash provided by financing activities $26.90 $0.00 $149,900.00 $0.00 $0.00 $49,000.00 -$46.93 -$52.46 $93,498.66 -$52.44 -$51.07 -$3,892.42 $288,330.24 -$3,931.34 $291,213.54 -$3,970.66 $294,125.68 -$4,010.36 $297,066.93 -$4,050.47 $300,037.60 -$4,090.97 $303,037.98 -$4,131.88 $306,068.36 $1,767,364.41
Net cash increase for period -$36,504.43 $1,565.08 $104,514.94 -$16,532.16 $15,757.20 $27,433.87 $89,392.05 -$32,067.92 -$22,325.77 -$72,066.15 -$52,230.93 -$16,289.30 -$9,353.52 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!