A | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 03/01/2023 | 04/01/2023 | 05/01/2023 | 06/01/2023 | 07/01/2023 | 08/01/2023 | 09/01/2023 | 10/01/2023 | 11/01/2023 | 12/01/2023 | 01/01/2024 | 02/01/2024 | 03/01/2024 | 04/01/2024 | 05/01/2024 | 06/01/2024 | 07/01/2024 | 08/01/2024 | 09/01/2024 | 10/01/2024 | 11/01/2024 | 12/01/2024 | 01/01/2025 | 02/01/2025 | 03/01/2025 | 04/01/2025 | 05/01/2025 | 06/01/2025 | 07/01/2025 | 08/01/2025 | 09/01/2025 | 10/01/2025 | 11/01/2025 | 12/01/2025 | 01/01/2026 | 02/01/2026 | 03/01/2026 | 04/01/2026 | 05/01/2026 | 06/01/2026 | 07/01/2026 | 08/01/2026 | 09/01/2026 | 10/01/2026 | 11/01/2026 | 12/01/2026 | |
2 | Starting Cash | $5,000,000 | $4,914,467 | $4,815,486 | $4,717,716 | $4,557,339 | $4,399,509 | $4,245,775 | $4,032,330 | $3,824,336 | $3,623,353 | $3,365,583 | $3,116,198 | $2,876,767 | $2,518,140 | $2,170,643 | $1,837,396 | $1,129,353 | $437,440 | -$229,046 | -$860,774 | -$1,457,629 | -$2,019,494 | -$2,807,702 | -$3,561,559 | -$4,274,787 | -$4,941,086 | -$5,560,301 | -$6,132,274 | -$6,918,298 | -$7,657,637 | -$8,343,972 | -$8,970,962 | -$9,538,410 | -$10,046,118 | -$10,755,336 | -$11,405,287 | -$11,989,609 | -$12,501,920 | -$12,941,980 | -$13,309,550 | -$13,865,836 | -$14,350,017 | -$14,755,692 | -$15,403,246 | -$15,966,674 | -$16,437,992 |
3 | Investment | $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 | $0 | $0 | $0 | $0 | $0 | $0 |
4 | |||||||||||||||||||||||||||||||||||||||||||||||
5 | Current R&D Gross | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 |
6 | Current Employees | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
7 | Interest On Cash | $16,667 | $16,382 | $16,052 | $15,726 | $15,191 | $14,665 | $14,153 | $13,441 | $12,748 | $12,078 | $11,219 | $10,387 | $9,589 | $8,394 | $7,235 | $6,125 | $3,765 | $1,458 | -$763 | -$2,869 | -$4,859 | -$6,732 | -$9,359 | -$11,872 | -$14,249 | -$16,470 | -$18,534 | -$20,441 | -$23,061 | -$25,525 | -$27,813 | -$29,903 | -$31,795 | -$33,487 | -$35,851 | -$38,018 | -$39,965 | -$41,673 | -$43,140 | -$44,365 | -$46,219 | -$47,833 | -$49,186 | -$51,344 | -$53,222 | -$54,793 |
8 | Steady State Burn | -$33,333 | -$33,618 | -$33,948 | -$34,274 | -$34,809 | -$35,335 | -$35,847 | -$36,559 | -$37,252 | -$37,922 | -$38,781 | -$39,613 | -$40,411 | -$41,606 | -$42,765 | -$43,875 | -$46,235 | -$48,542 | -$50,763 | -$52,869 | -$54,859 | -$56,732 | -$59,359 | -$61,872 | -$64,249 | -$66,470 | -$68,534 | -$70,441 | -$73,061 | -$75,525 | -$77,813 | -$79,903 | -$81,795 | -$83,487 | -$85,851 | -$88,018 | -$89,965 | -$91,673 | -$93,140 | -$94,365 | -$96,219 | -$97,833 | -$99,186 | -$101,344 | -$103,222 | -$104,793 |
9 | |||||||||||||||||||||||||||||||||||||||||||||||
10 | Sales Reps | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 6 | 6 | 6 | 12 | 12 | 12 | 12 | 12 | 12 | 16 | 16 | 16 | 16 | 16 | 16 | 20 | 20 | 20 | 20 | 20 | 20 | 24 | 24 | 24 | 24 | 24 | 24 | 28 | 28 | 28 | 33 | 33 | 33 | 39 |
11 | New SM Employees | 3 | 3 | 3 | 6 | 6 | 6 | 9 | 9 | 9 | 12 | 12 | 12 | 18 | 18 | 18 | 35 | 35 | 35 | 35 | 35 | 35 | 47 | 47 | 47 | 47 | 47 | 47 | 59 | 59 | 59 | 59 | 59 | 59 | 70 | 70 | 70 | 70 | 70 | 70 | 82 | 82 | 82 | 97 | 97 | 97 | 114 |
12 | New SM Cost | -$52,200 | -$52,200 | -$52,200 | -$104,400 | -$104,400 | -$104,400 | -$156,600 | -$156,600 | -$156,600 | -$208,800 | -$208,800 | -$208,800 | -$313,200 | -$313,200 | -$313,200 | -$626,400 | -$626,400 | -$626,400 | -$626,400 | -$626,400 | -$626,400 | -$835,200 | -$835,200 | -$835,200 | -$835,200 | -$835,200 | -$835,200 | -$1,044,000 | -$1,044,000 | -$1,044,000 | -$1,044,000 | -$1,044,000 | -$1,044,000 | -$1,252,800 | -$1,252,800 | -$1,252,800 | -$1,252,800 | -$1,252,800 | -$1,252,800 | -$1,461,600 | -$1,461,600 | -$1,461,600 | -$1,722,600 | -$1,722,600 | -$1,722,600 | -$2,035,800 |
13 | Quota | $0 | $0 | $31,250 | $62,500 | $62,500 | $93,750 | $125,000 | $125,000 | $156,250 | $187,500 | $187,500 | $218,750 | $250,000 | $250,000 | $312,500 | $375,000 | $375,000 | $562,500 | $750,000 | $750,000 | $750,000 | $750,000 | $750,000 | $875,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,125,000 | $1,250,000 | $1,250,000 | $1,250,000 | $1,250,000 | $1,250,000 | $1,375,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,625,000 | $1,750,000 | $1,750,000 | $1,906,250 | $2,062,500 |
14 | Net New ARR | $0 | $0 | $25,000 | $50,000 | $50,000 | $75,000 | $100,000 | $100,000 | $125,000 | $150,000 | $150,000 | $175,000 | $200,000 | $200,000 | $250,000 | $300,000 | $300,000 | $450,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $700,000 | $800,000 | $800,000 | $800,000 | $800,000 | $800,000 | $900,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,000,000 | $1,100,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,200,000 | $1,300,000 | $1,400,000 | $1,400,000 | $1,525,000 | $1,650,000 |
15 | Net Sales Cost | -$52,200 | -$52,200 | -$27,200 | -$54,400 | -$54,400 | -$29,400 | -$56,600 | -$56,600 | -$31,600 | -$58,800 | -$58,800 | -$33,800 | -$113,200 | -$113,200 | -$63,200 | -$326,400 | -$326,400 | -$176,400 | -$26,400 | -$26,400 | -$26,400 | -$235,200 | -$235,200 | -$135,200 | -$35,200 | -$35,200 | -$35,200 | -$244,000 | -$244,000 | -$144,000 | -$44,000 | -$44,000 | -$44,000 | -$252,800 | -$252,800 | -$152,800 | -$52,800 | -$52,800 | -$52,800 | -$261,600 | -$261,600 | -$161,600 | -$322,600 | -$322,600 | -$197,600 | -$385,800 |
16 | |||||||||||||||||||||||||||||||||||||||||||||||
17 | New R&D | 0 | 1 | 1 | 3 | 3 | 3 | 4 | 4 | 4 | 6 | 6 | 6 | 9 | 9 | 9 | 18 | 18 | 18 | 18 | 18 | 18 | 23 | 23 | 23 | 23 | 23 | 23 | 29 | 29 | 29 | 29 | 29 | 29 | 35 | 35 | 35 | 35 | 35 | 35 | 41 | 41 | 41 | 48 | 48 | 48 | 57 |
18 | New R&D Costs | $0 | -$29,250 | -$29,250 | -$58,500 | -$58,500 | -$58,500 | -$87,750 | -$87,750 | -$87,750 | -$117,000 | -$117,000 | -$117,000 | -$175,500 | -$175,500 | -$175,500 | -$351,000 | -$351,000 | -$351,000 | -$351,000 | -$351,000 | -$351,000 | -$468,000 | -$468,000 | -$468,000 | -$468,000 | -$468,000 | -$468,000 | -$585,000 | -$585,000 | -$585,000 | -$585,000 | -$585,000 | -$585,000 | -$702,000 | -$702,000 | -$702,000 | -$702,000 | -$702,000 | -$702,000 | -$819,000 | -$819,000 | -$819,000 | -$965,250 | -$965,250 | -$965,250 | -$1,140,750 |
19 | New G&A | 0 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 11 | 11 | 11 | 11 | 11 | 11 | 14 | 14 | 14 | 14 | 14 | 14 | 18 | 18 | 18 | 18 | 18 | 18 | 21 | 21 | 21 | 21 | 21 | 21 | 25 | 25 | 25 | 29 | 29 | 29 | 34 |
20 | G&A Costs | $0 | -$13,163 | -$13,163 | -$26,325 | -$26,325 | -$26,325 | -$39,488 | -$39,488 | -$39,488 | -$52,650 | -$52,650 | -$52,650 | -$78,975 | -$78,975 | -$78,975 | -$157,950 | -$157,950 | -$157,950 | -$157,950 | -$157,950 | -$157,950 | -$210,600 | -$210,600 | -$210,600 | -$210,600 | -$210,600 | -$210,600 | -$263,250 | -$263,250 | -$263,250 | -$263,250 | -$263,250 | -$263,250 | -$315,900 | -$315,900 | -$315,900 | -$315,900 | -$315,900 | -$315,900 | -$368,550 | -$368,550 | -$368,550 | -$434,363 | -$434,363 | -$434,363 | -$513,338 |
21 | Net New Burn (SM+GA+RD) | -$52,200 | -$94,613 | -$69,613 | -$139,225 | -$139,225 | -$114,225 | -$183,838 | -$183,838 | -$158,838 | -$228,450 | -$228,450 | -$203,450 | -$367,675 | -$367,675 | -$317,675 | -$835,350 | -$835,350 | -$685,350 | -$535,350 | -$535,350 | -$535,350 | -$913,800 | -$913,800 | -$813,800 | -$713,800 | -$713,800 | -$713,800 | -$1,092,250 | -$1,092,250 | -$992,250 | -$892,250 | -$892,250 | -$892,250 | -$1,270,700 | -$1,270,700 | -$1,170,700 | -$1,070,700 | -$1,070,700 | -$1,070,700 | -$1,449,150 | -$1,449,150 | -$1,349,150 | -$1,722,213 | -$1,722,213 | -$1,597,213 | -$2,039,888 |
22 | |||||||||||||||||||||||||||||||||||||||||||||||
23 | 03/01/2023 | 04/01/2023 | 05/01/2023 | 06/01/2023 | 07/01/2023 | 08/01/2023 | 09/01/2023 | 10/01/2023 | 11/01/2023 | 12/01/2023 | 01/01/2024 | 02/01/2024 | 03/01/2024 | 04/01/2024 | 05/01/2024 | 06/01/2024 | 07/01/2024 | 08/01/2024 | 09/01/2024 | 10/01/2024 | 11/01/2024 | 12/01/2024 | 01/01/2025 | 02/01/2025 | 03/01/2025 | 04/01/2025 | 05/01/2025 | 06/01/2025 | 07/01/2025 | 08/01/2025 | 09/01/2025 | 10/01/2025 | 11/01/2025 | 12/01/2025 | 01/01/2026 | 02/01/2026 | 03/01/2026 | 04/01/2026 | 05/01/2026 | 06/01/2026 | 07/01/2026 | 08/01/2026 | 09/01/2026 | 10/01/2026 | 11/01/2026 | 12/01/2026 | |
24 | Employees | 6 | 8 | 8 | 14 | 14 | 14 | 19 | 19 | 20 | 25 | 25 | 25 | 36 | 37 | 37 | 69 | 69 | 70 | 71 | 72 | 73 | 94 | 95 | 96 | 97 | 98 | 100 | 122 | 123 | 124 | 126 | 127 | 128 | 151 | 152 | 154 | 156 | 157 | 159 | 182 | 183 | 185 | 213 | 215 | 218 | 251 |
25 | ARR | $0 | $0 | $25,000 | $75,000 | $125,000 | $200,000 | $300,000 | $400,000 | $525,000 | $675,000 | $825,000 | $1,000,000 | $1,200,000 | $1,400,000 | $1,650,000 | $1,950,000 | $2,250,000 | $2,700,000 | $3,300,000 | $3,900,000 | $4,500,000 | $5,100,000 | $5,700,000 | $6,400,000 | $7,200,000 | $8,000,000 | $8,800,000 | $9,600,000 | $10,400,000 | $11,300,000 | $12,300,000 | $13,300,000 | $14,300,000 | $15,300,000 | $16,300,000 | $17,400,000 | $18,600,000 | $19,800,000 | $21,000,000 | $22,200,000 | $23,400,000 | $24,700,000 | $26,100,000 | $27,500,000 | $29,025,000 | $30,675,000 |
26 | Customers | 0 | 0 | 1 | 3 | 5 | 8 | 13 | 17 | 22 | 28 | 34 | 42 | 50 | 58 | 69 | 81 | 94 | 113 | 138 | 163 | 188 | 213 | 238 | 267 | 300 | 333 | 367 | 400 | 433 | 471 | 513 | 554 | 596 | 638 | 679 | 725 | 775 | 825 | 875 | 925 | 975 | 1029 | 1088 | 1146 | 1209 | 1278 |
27 | COGS | $0 | $0 | -$208 | -$625 | -$1,042 | -$1,667 | -$2,500 | -$3,333 | -$4,375 | -$5,625 | -$6,875 | -$8,333 | -$10,000 | -$11,667 | -$13,750 | -$16,250 | -$18,750 | -$22,500 | -$27,500 | -$32,500 | -$37,500 | -$42,500 | -$47,500 | -$53,333 | -$60,000 | -$66,667 | -$73,333 | -$80,000 | -$86,667 | -$94,167 | -$102,500 | -$110,833 | -$119,167 | -$127,500 | -$135,833 | -$145,000 | -$155,000 | -$165,000 | -$175,000 | -$185,000 | -$195,000 | -$205,833 | -$217,500 | -$229,167 | -$241,875 | -$255,625 |
28 | Customer Success / Support | $0 | $0 | -$334 | -$1,003 | -$1,671 | -$2,674 | -$4,010 | -$5,347 | -$7,018 | -$9,023 | -$11,029 | -$13,368 | -$16,042 | -$18,715 | -$22,057 | -$26,068 | -$30,078 | -$36,094 | -$44,115 | -$52,135 | -$60,156 | -$68,177 | -$76,198 | -$85,556 | -$96,250 | -$106,944 | -$117,639 | -$128,333 | -$139,028 | -$151,059 | -$164,427 | -$177,795 | -$191,163 | -$204,531 | -$217,899 | -$232,604 | -$248,646 | -$264,688 | -$280,729 | -$296,771 | -$312,813 | -$330,191 | -$348,906 | -$367,622 | -$388,008 | -$410,065 |
29 | Success People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 4 | 5 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 14 | 15 | 16 | 17 | 19 | 20 | 22 | 23 | 24 | 26 | 28 | 30 | 31 | 33 | 35 | 37 | 39 | 41 | 43 |
30 | Total COGS | $0 | $0 | -$543 | -$1,628 | -$2,713 | -$4,340 | -$6,510 | -$8,681 | -$11,393 | -$14,648 | -$17,904 | -$21,701 | -$26,042 | -$30,382 | -$35,807 | -$42,318 | -$48,828 | -$58,594 | -$71,615 | -$84,635 | -$97,656 | -$110,677 | -$123,698 | -$138,889 | -$156,250 | -$173,611 | -$190,972 | -$208,333 | -$225,694 | -$245,226 | -$266,927 | -$288,628 | -$310,330 | -$332,031 | -$353,733 | -$377,604 | -$403,646 | -$429,688 | -$455,729 | -$481,771 | -$507,813 | -$536,024 | -$566,406 | -$596,788 | -$629,883 | -$665,690 |
31 | Net Churn | $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 | $0 | $0 | $0 | $0 | $0 | $0 |
32 | Costs | -$85,533 | -$98,981 | -$99,853 | -$166,627 | -$168,247 | -$170,400 | -$238,445 | -$241,327 | -$244,733 | -$314,021 | -$318,135 | -$322,764 | -$458,627 | -$464,163 | -$470,747 | -$870,543 | -$879,414 | -$891,486 | -$906,728 | -$921,855 | -$936,865 | -$1,213,209 | -$1,228,857 | -$1,246,561 | -$1,266,299 | -$1,285,881 | -$1,305,307 | -$1,586,024 | -$1,606,005 | -$1,628,001 | -$1,651,990 | -$1,675,782 | -$1,699,375 | -$1,984,218 | -$2,008,284 | -$2,034,322 | -$2,062,311 | -$2,090,061 | -$2,117,569 | -$2,406,286 | -$2,434,182 | -$2,464,008 | -$2,822,554 | -$2,855,095 | -$2,890,068 | -$3,319,621 |
33 | Monthly Burn | -$85,533 | -$98,981 | -$97,770 | -$160,377 | -$157,830 | -$153,734 | -$213,445 | -$207,994 | -$200,983 | -$257,771 | -$249,385 | -$239,431 | -$358,627 | -$347,496 | -$333,247 | -$708,043 | -$691,914 | -$666,486 | -$631,728 | -$596,855 | -$561,865 | -$788,209 | -$753,857 | -$713,227 | -$666,299 | -$619,215 | -$571,973 | -$786,024 | -$739,339 | -$686,334 | -$626,990 | -$567,448 | -$507,708 | -$709,218 | -$649,950 | -$584,322 | -$512,311 | -$440,061 | -$367,569 | -$556,286 | -$484,182 | -$405,674 | -$647,554 | -$563,428 | -$471,318 | -$763,371 |
34 | Cumulative Burn | -$85,533 | -$184,514 | -$282,284 | -$442,661 | -$600,491 | -$754,225 | -$967,670 | -$1,175,664 | -$1,376,647 | -$1,634,417 | -$1,883,802 | -$2,123,233 | -$2,481,860 | -$2,829,357 | -$3,162,604 | -$3,870,647 | -$4,562,560 | -$5,229,046 | -$5,860,774 | -$6,457,629 | -$7,019,494 | -$7,807,702 | -$8,561,559 | -$9,274,787 | -$9,941,086 | -$10,560,301 | -$11,132,274 | -$11,918,298 | -$12,657,637 | -$13,343,972 | -$13,970,962 | -$14,538,410 | -$15,046,118 | -$15,755,336 | -$16,405,287 | -$16,989,609 | -$17,501,920 | -$17,941,980 | -$18,309,550 | -$18,865,836 | -$19,350,017 | -$19,755,692 | -$20,403,246 | -$20,966,674 | -$21,437,992 | -$22,201,363 |
35 | Cash on Hand | $5,000,000 | $4,914,467 | $4,815,486 | $4,717,716 | $4,557,339 | $4,399,509 | $4,245,775 | $4,032,330 | $3,824,336 | $3,623,353 | $3,365,583 | $3,116,198 | $2,876,767 | $2,518,140 | $2,170,643 | $1,837,396 | $1,129,353 | $437,440 | -$229,046 | -$860,774 | -$1,457,629 | -$2,019,494 | -$2,807,702 | -$3,561,559 | -$4,274,787 | -$4,941,086 | -$5,560,301 | -$6,132,274 | -$6,918,298 | -$7,657,637 | -$8,343,972 | -$8,970,962 | -$9,538,410 | -$10,046,118 | -$10,755,336 | -$11,405,287 | -$11,989,609 | -$12,501,920 | -$12,941,980 | -$13,309,550 | -$13,865,836 | -$14,350,017 | -$14,755,692 | -$15,403,246 | -$15,966,674 | -$16,437,992 |
36 | |||||||||||||||||||||||||||||||||||||||||||||||
37 | 24 | 25 | 26 | 33 | 34 | 35 | 24 | 6 | 10 | 11 | 17 | 19 | 29 | ||||||||||||||||||||||||||||||||||
38 | Rep Growth | Corp Growth | Date | Reps | Employees | ARR | Customers | Wins | Meetings | Date | Monthly Burn | Cumulative Burn | Cash on Hand | Employees | Current Employees | Sales Reps | New SM Employees | New R&D | New G&A | Success People | Date | SM | GA | RD | |||||||||||||||||||||||
39 | 3/1/2023 | 1 | 6 | $0 | 0 | 0 | 0 | 3/1/2023 | -$85,533 | -$85,533 | $5,000,000 | 6 | 3 | 1 | 3 | 0 | 0 | 0 | 3/1/2023 | 49.37% | 0.00% | 50.63% | |||||||||||||||||||||||||
40 | 6/1/2023 | 2 | 14 | $75,000 | 3 | 3 | 13 | 6/1/2023 | -$160,377 | -$442,661 | $4,717,716 | 14 | 3 | 2 | 6 | 3 | 2 | 0 | 6/1/2023 | 43.68% | 12.87% | 43.45% | |||||||||||||||||||||||||
41 | 406.25% | 294.50% | 9/1/2023 | 3 | 19 | $300,000 | 13 | 9 | 38 | 9/1/2023 | -$213,445 | -$967,670 | $4,245,775 | 19 | 3 | 3 | 9 | 4 | 3 | 0 | 9/1/2023 | 47.86% | 13.70% | 38.44% | |||||||||||||||||||||||
42 | 2462.89% | 216.05% | 186.86% | 12/1/2023 | 4 | 25 | $675,000 | 28 | 16 | 63 | 12/1/2023 | -$257,771 | -$1,634,417 | $3,623,353 | 25 | 3 | 4 | 12 | 6 | 4 | 1 | 12/1/2023 | 50.58% | 14.03% | 35.39% | ||||||||||||||||||||||
43 | 898.87% | 406.25% | 342.74% | 3/1/2024 | 6 | 36 | $1,200,000 | 50 | 22 | 88 | 3/1/2024 | -$358,627 | -$2,481,860 | $2,876,767 | 36 | 3 | 6 | 18 | 9 | 5 | 2 | 3/1/2024 | 53.03% | 14.51% | 32.46% | ||||||||||||||||||||||
44 | 597.29% | 1500.00% | 1202.83% | 6/1/2024 | 12 | 69 | $1,950,000 | 81 | 31 | 125 | 6/1/2024 | -$708,043 | -$3,870,647 | $1,837,396 | 69 | 3 | 12 | 35 | 18 | 11 | 3 | 6/1/2024 | 54.91% | 15.28% | 29.82% | ||||||||||||||||||||||
45 | 720.20% | 0.00% | 11.48% | 9/1/2024 | 12 | 71 | $3,300,000 | 138 | 56 | 225 | 9/1/2024 | -$631,728 | -$5,860,774 | -$229,046 | 71 | 3 | 12 | 35 | 18 | 11 | 5 | 9/1/2024 | 56.11% | 14.87% | 29.02% | ||||||||||||||||||||||
46 | 470.46% | 216.05% | 215.84% | 12/1/2024 | 16 | 94 | $5,100,000 | 213 | 75 | 300 | 12/1/2024 | -$788,209 | -$7,807,702 | -$2,019,494 | 94 | 3 | 16 | 47 | 23 | 14 | 7 | 12/1/2024 | 57.17% | 14.87% | 27.96% | ||||||||||||||||||||||
47 | 297.24% | 0.00% | 13.11% | 3/1/2025 | 16 | 97 | $7,200,000 | 300 | 88 | 350 | 3/1/2025 | -$666,299 | -$9,941,086 | -$4,274,787 | 97 | 3 | 16 | 47 | 23 | 14 | 10 | 3/1/2025 | 58.47% | 14.42% | 27.11% | ||||||||||||||||||||||
48 | 216.05% | 144.14% | 144.89% | 6/1/2025 | 20 | 122 | $9,600,000 | 400 | 100 | 400 | 6/1/2025 | -$786,024 | -$11,918,298 | -$6,132,274 | 122 | 3 | 20 | 59 | 29 | 18 | 14 | 6/1/2025 | 59.11% | 14.41% | 26.48% | ||||||||||||||||||||||
49 | 169.49% | 0.00% | 13.06% | 9/1/2025 | 20 | 126 | $12,300,000 | 513 | 113 | 450 | 9/1/2025 | -$626,990 | -$13,970,962 | -$8,343,972 | 126 | 3 | 20 | 59 | 29 | 18 | 17 | 9/1/2025 | 60.35% | 13.97% | 25.68% | ||||||||||||||||||||||
50 | 139.41% | 107.36% | 108.24% | 12/1/2025 | 24 | 151 | $15,300,000 | 638 | 125 | 500 | 12/1/2025 | -$709,218 | -$15,755,336 | -$10,046,118 | 151 | 3 | 24 | 70 | 35 | 21 | 22 | 12/1/2025 | 60.79% | 13.96% | 25.25% | ||||||||||||||||||||||
51 | 118.42% | 0.00% | 12.88% | 3/1/2026 | 24 | 156 | $18,600,000 | 775 | 138 | 550 | 3/1/2026 | -$512,311 | -$17,501,920 | -$11,989,609 | 156 | 3 | 24 | 70 | 35 | 21 | 26 | 3/1/2026 | 61.96% | 13.54% | 24.50% | ||||||||||||||||||||||
52 | 102.94% | 85.26% | 86.09% | 6/1/2026 | 28 | 182 | $22,200,000 | 925 | 150 | 600 | 6/1/2026 | -$556,286 | -$18,865,836 | -$13,309,550 | 182 | 3 | 28 | 82 | 41 | 25 | 31 | 6/1/2026 | 62.28% | 13.53% | 24.20% | ||||||||||||||||||||||
53 | 91.05% | 92.94% | 90.69% | 9/1/2026 | 33 | 213 | $26,100,000 | 1088 | 163 | 650 | 9/1/2026 | -$647,554 | -$20,403,246 | -$14,755,692 | 213 | 3 | 33 | 97 | 48 | 29 | 37 | 9/1/2026 | 62.42% | 13.57% | 24.02% | ||||||||||||||||||||||
54 | 90.80% | 95.08% | 92.66% | 12/1/2026 | 39 | 251 | $30,675,000 | 1278 | 191 | 763 | 12/1/2026 | -$763,371 | -$22,201,363 | -$16,437,992 | 251 | 3 | 39 | 114 | 57 | 34 | 43 | 12/1/2026 | 62.52% | 13.61% | 23.87% | ||||||||||||||||||||||
55 | |||||||||||||||||||||||||||||||||||||||||||||||
56 | Span of Control | 8 | Sales Quota | $750,000 | $600,000 | Ramp Time (Mo) | Gross Churn | ||||||||||||||||||||||||||||||||||||||||
57 | ACV | $24,000 | 3 | 10% | |||||||||||||||||||||||||||||||||||||||||||
58 | Sales Team Cost | Cost Per | Ratios | Total | Net Profit | $17,750 | |||||||||||||||||||||||||||||||||||||||||
59 | Rep | $200,000 | 1 | $240,000 | Deals per Rep | 31 | Attainment | Add-On | |||||||||||||||||||||||||||||||||||||||
60 | Pre-Sales | $175,000 | 0.5 | $105,000 | Lead Win Rate | 3% | 80% | 10% | |||||||||||||||||||||||||||||||||||||||
61 | Implementation | $175,000 | 0.3 | $63,000 | Leads / Rep / Yr | 1042 | $28.80 | ||||||||||||||||||||||||||||||||||||||||
62 | SDR | $100,000 | 0.5 | $60,000 | Meetings Win Rate | 25% | R&D Multiplier | Salary | Staff Multiplier | Salary | |||||||||||||||||||||||||||||||||||||
63 | Marketer | $140,000 | 0.3 | $50,400 | Meetings / Rep / Yr | 125 | $240.00 | 50% | $200,000 | 30% | $150,000 | ||||||||||||||||||||||||||||||||||||
64 | Managers | $200,000 | 0.33 | $78,000 | Meetings / Month | 10 | $135,000 | $240,000 | benefits adj | $45,000 | $180,000 | benefits adj | |||||||||||||||||||||||||||||||||||
65 | Marketing Spend | $30,000 | $30,000 | with GA/RD | CAC | $20,045 | |||||||||||||||||||||||||||||||||||||||||
66 | Total Headcount | 2.925 | $626,400 | $806,400 | MTR | 13.6 | Benefits Gross Up | ||||||||||||||||||||||||||||||||||||||||
67 | 20% | see Monthly Costs sheet | |||||||||||||||||||||||||||||||||||||||||||||
68 | Sales Team Cost | Cost Per | Ratio | Per Customer | |||||||||||||||||||||||||||||||||||||||||||
69 | Support | $80,000 | 50 | $1,600 | 6.67% | COGS | note not people | Current Cash | $5,000,000 | Current Team | 3 | ||||||||||||||||||||||||||||||||||||
70 | Customer Success | $150,000 | 100 | $1,500 | 6.25% | 10% | Burn to Date | $0 | Gross Burn (Monthly) | $50,000 | |||||||||||||||||||||||||||||||||||||
71 | Managers | $200,000 | 266.7 | $750 | 3.13% | Interest | 4% | ||||||||||||||||||||||||||||||||||||||||
72 | Total Headcount | 29.6 | $3,850 | 16.04% | |||||||||||||||||||||||||||||||||||||||||||
73 | |||||||||||||||||||||||||||||||||||||||||||||||
74 | |||||||||||||||||||||||||||||||||||||||||||||||
75 | |||||||||||||||||||||||||||||||||||||||||||||||
76 | |||||||||||||||||||||||||||||||||||||||||||||||
77 | |||||||||||||||||||||||||||||||||||||||||||||||
78 | |||||||||||||||||||||||||||||||||||||||||||||||
79 | |||||||||||||||||||||||||||||||||||||||||||||||
80 | |||||||||||||||||||||||||||||||||||||||||||||||
81 | |||||||||||||||||||||||||||||||||||||||||||||||
82 | |||||||||||||||||||||||||||||||||||||||||||||||
83 | |||||||||||||||||||||||||||||||||||||||||||||||
84 | |||||||||||||||||||||||||||||||||||||||||||||||
85 | |||||||||||||||||||||||||||||||||||||||||||||||
86 | |||||||||||||||||||||||||||||||||||||||||||||||
87 | |||||||||||||||||||||||||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||||||||||||||||||||||
91 | |||||||||||||||||||||||||||||||||||||||||||||||
92 | |||||||||||||||||||||||||||||||||||||||||||||||
93 | |||||||||||||||||||||||||||||||||||||||||||||||
94 | |||||||||||||||||||||||||||||||||||||||||||||||
95 | |||||||||||||||||||||||||||||||||||||||||||||||
96 | |||||||||||||||||||||||||||||||||||||||||||||||
97 | |||||||||||||||||||||||||||||||||||||||||||||||
98 | |||||||||||||||||||||||||||||||||||||||||||||||
99 | |||||||||||||||||||||||||||||||||||||||||||||||
100 |