ABCDEFGHIJKLMNOPQRS
1
$564,629Yearly 2024 Forecast
2
Quarter 1Quarter 2Quarter 3Quarter 4SUM TOTALNet ProfitProfit % to Total Sales
3
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember$2,594,340$564,62921.76%
4
Average New Revenue per client$1,850$1,850$1,850$1,850$1,850$1,850$1,850$1,850$1,850$1,850$1,850$1,850
5
6
7
Starting Revenue$156,000$159,846$163,514$175,900$185,985$205,335$206,041$227,800$246,410$248,410$257,410$259,410
8
New Sold MRR$15,000$11,500$18,600$18,000$24,000$12,000$30,000$30,000$12,000$24,000$30,000$30,000$255,100
9
Churn %7.2%4.9%3.8%4.5%2.5%5.5%4.0%5.0%5.0%7.0%12.0%12.0%6.11%
10
Churn $$$11,154$7,832$6,214$7,916$4,650$11,293$8,242$11,390$10,000$15,000$28,000$31,129
11
12
EOM Revenue$159,846$163,514$175,900$185,985$205,335$206,041$227,800$246,410$248,410$257,410$259,410$258,281$2,594,340
13
14
Stripe Fees3.30%$5,275$5,396$5,805$6,137$6,776$6,799$7,517$8,132$8,198$8,495$8,561$8,523$85,613
15
Credits/Refunds Given$0$0$0$0$0$0$0$0$0$3,500$6,500$6,500$16,500
16
Delinquents$1,500
17
Recovered Delinquents$1,500
18
19
Budgetable Net Revenue (hit bank account)$153,071$159,618$170,095$179,847$198,559$199,242$220,282$238,278$240,212$245,415$244,349$243,257$2,492,227
20
5000 COGS$21,583$23,623$25,174$26,617$29,387$29,488$32,602$35,265$35,551$36,321$36,164$36,002
21
COGS % BUDGET14.1%14.8%14.8%14.8%14.8%14.8%14.8%14.8%14.8%14.8%14.8%14.8%
22
Gross Income$131,488$135,994$144,921$153,230$169,172$169,754$187,681$203,013$204,661$209,094$208,186$207,255
23
6200 INTERNAL LABOR$74,399$74,431$72,450$82,041$75,238$79,518$82,183$89,198$88,628$92,033$95,361$111,319
24
Employee Benefits$1,113$1,113$1,372$1,372$1,372$1,372$1,372$1,372$1,372$1,372$1,372$11,872
25
Assurity$145.00$145.00$145.00$145.00$145.00$145.00$145.00$145.00$145.00$145.00$145.00$145.00
26
Cigna$664.42$664.42$664.42$664.42$664.42$664.42$664.42$664.42$664.42$664.42$664.42$664.42
27
Healthiest you$18.00$18.00$18.00$18.00$18.00$18.00$18.00$18.00$18.00$18.00$18.00$18.00
28
United health$285.21$285.21$545.00$545.00$545.00$545.00$545.00$545.00$545.00$545.00$545.00$545.00
29
End of Year Team Gifts$10,500
30
Executive$12,020$12,020$12,020$13,020$12,200$14,200$14,200$17,200$14,200$15,200$14,200$14,200
31
CEO$10,000$10,000$10,000$10,000$10,000$12,000$12,000$12,000$12,000$12,000$12,000$12,000
32
EA$2,020$2,020$2,020$2,020$2,200$2,200$2,200$2,200$2,200$2,200$2,200$2,200
33
Bonus$1,000$3,000$1,000
34
35
36
Marketing$1,040$1,040$1,790$1,790$1,790$1,790$1,790$1,873$1,873$1,873$1,873$1,873
37
Marketing Contractor$1,040$1,040$1,040$1,040$1,040$1,040$1,040$1,123$1,123$1,123$1,123$1,123
38
Marketing PM/Helper$0$0$750$750$750$750$750$750$750$750$750$750
39
$0$0$0$0$0$0$0$0$0$0$0$0
40
Customer Success$12,400$13,400$12,820$14,320$12,820$12,820$14,644$13,144$15,644$20,144$18,644$18,644
41
CSM 11.12$7,000$7,000$7,420$7,420$7,420$7,420$7,420$7,420$7,420$7,420$7,420$7,420
42
CSM 2$5,400$5,400$5,400$5,400$5,400$5,400$5,724$5,724$5,724$5,724$5,724$5,724
43
Bonuses$1,000$1,500$1,500$1,500
44
AM TBD$2,500$5,500$5,500$5,500
45
46
Sales$11,824$11,824$10,494$13,192$12,964$15,244$10,684$17,524$17,524$10,684$19,244$21,524
47
Sales Person 1$6,124$6,124$6,124$6,124$6,124$6,124$6,124$6,124$6,124$6,124$6,124$6,124
48
Commission$5,700$5,700$4,370$7,068$6,840$9,120$4,560$11,400$11,400$4,560$9,120$11,400
49
BDR?$4,000$4,000$12,500
50
SEO Team$21,391$20,423$19,343$23,736$19,481$19,481$24,882$23,036$22,966$27,710$24,821$27,603
51
Non-Clients$6,550$6,550$6,550$10,805$6,550$6,550$9,788$7,770$7,700$10,792$7,700$10,200
52
SEO Manager$6,550$6,550$6,550$6,550$6,550$6,550$6,550$7,770$7,700$7,700$7,700$7,700Jan payout
Total COGS Bonus
53
Bonus$4,255$3,238$3,092$2,500$2,500$13,085
54
55
SEO Specialist$14,841$13,873$12,793$12,931$12,931$12,931$15,094$15,266$15,266$16,918$17,121$17,403
56
SEO Person 1$2,617$2,617$2,617$2,617$2,617$2,617$2,617$2,617$2,617$2,617$2,826$2,826
57
SEO Person 2$2,379$2,379$2,379$2,379$2,379$2,379$2,379$2,379$2,379$2,379$2,376$2,550
58
SEO Person 3$2,595$2,595$2,595$2,595$2,595$2,595$2,595$2,595$2,595$2,595$2,592$2,700
59
SEO Person 4$1,727$1,727$1,727$1,865$1,865$1,865$1,865$1,865$1,865$1,865$1,865$1,865
60
SEO Person 5$2,160$1,080$0$0$0$0$0$0$0$0$0$0
61
SEO Person 6$1,963$1,963$1,963$1,963$1,963$1,963$1,963$2,135$2,135$2,135$2,135$2,135
62
SEO Person 7$1,400$1,512$1,512$1,512$1,512$1,512$1,512$1,512$1,512$1,512$1,512$1,512
63
SEO Person 8 FUTURE$2,163$2,163$2,163$2,163$2,163$2,163
64
SEO Person 9 FUTURE$1,652$1,652$1,652
65
Outbound Team$4,168$4,168$4,168$4,168$4,168$4,168$4,168$4,168$4,168$4,168$4,325$4,325
66
Outreach 1$1,963$1,963$1,963$1,963$1,963$1,963$1,963$1,963$1,963$1,963$2,120$2,120
67
Outreach 2$2,205$2,205$2,205$2,205$2,205$2,205$2,205$2,205$2,205$2,205$2,205$2,205
68
Website Production Team$10,443$10,443$10,443$10,443$10,443$10,443$10,443$10,881$10,881$10,881$10,881$11,277
69
Website PM$5,482$5,482$5,482$5,482$5,482$5,482$5,482$5,920$5,920$5,920$5,920$5,920
70
Web Dev 1$2,998$2,998$2,998$2,998$2,998$2,998$2,998$2,998$2,998$2,998$2,998$3,237
71
Web Dev 2$1,963$1,963$1,963$1,963$1,963$1,963$1,963$1,963$1,963$1,963$1,963$2,120
72
73
Future
74
6600 SOFTWARE + UTILITIES$18,052$14,758$16,727$16,328$17,612$16,328$16,328$16,328$16,328$16,328$20,821$16,328
75
Marketing- Software$430$428$428$428$428$428$428$428$428$428$428$428
76
YouTube$15.08$15.08$15.08$15.08$15.08$15.08$15.08$15.08$15.08$15.08$15.08$15.08
77
TypeForm$106.52$106.52$106.52$106.52$106.52$106.52$106.52$106.52$106.52$106.52$106.52$106.52
78
Wistia$132.12$129.96$129.96$129.96$129.96$129.96$129.96$129.96$129.96$129.96$129.96$129.96
79
Canva$12.99$12.99$12.99$12.99$12.99$12.99$12.99$12.99$12.99$12.99$12.99$12.99
80
Envato$77.97$77.97$77.97$77.97$77.97$77.97$77.97$77.97$77.97$77.97$77.97$77.97
81
Ez Texting$55.00$55.00$55.00$55.00$55.00$55.00$55.00$55.00$55.00$55.00$55.00$55.00
82
Zapier$29.99$29.99$29.99$29.99$29.99$29.99$29.99$29.99$29.99$29.99$29.99$29.99
83
Customer Success - Software$2,125$0$1,900$1,900$1,900$1,900$1,900$1,900$1,900$1,900$1,900$1,900
84
LeadSnap$2,120.00$0.00$1,900.00$1,900.00$1,900.00$1,900.00$1,900.00$1,900.00$1,900.00$1,900.00$1,900.00$1,900.00
85
Handywritten$5.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
86
Sales - Software$1,108$283$283$283$283$283$283$283$283$283$283$283
87
Microsoft$58.50$58.50$58.50$58.50$58.50$58.50$58.50$58.50$58.50$58.50$58.50$58.50
88
Open AI$38.00$38.00$38.00$38.00$38.00$38.00$38.00$38.00$38.00$38.00$38.00$38.00
89
Calendly$107.60$86.08$86.08$86.08$86.08$86.08$86.08$86.08$86.08$86.08$86.08$86.08
90
Lemlist$472.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00
91
Paddle.com$432.12$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
92
93
SEO - Software$4,605$4,605$4,605$4,605$4,605$4,605$4,605$4,605$4,605$4,605$4,605$4,605
94
Ahrefs.com (SEO + Outreach)$739.28$739.28$739.28$739.28$739.28$739.28$739.28$739.28$739.28$739.28$739.28$739.28
95
Places Scout$665.00$665.00$665.00$665.00$665.00$665.00$665.00$665.00$665.00$665.00$665.00$665.00
96
Serpfox.com$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00
97
Process.st$510.00$510.00$510.00$510.00$510.00$510.00$510.00$510.00$510.00$510.00$510.00$510.00
98
SEMRUSH.COM$373.59$373.59$373.59$373.59$373.59$373.59$373.59$373.59$373.59$373.59$373.59$373.59
99
Whitespark$49.00$49.00$49.00$49.00$49.00$49.00$49.00$49.00$49.00$49.00$49.00$49.00
100
LeadSnap$1,700.00$1,700.00$1,700.00$1,700.00$1,700.00$1,700.00$1,700.00$1,700.00$1,700.00$1,700.00$1,700.00$1,700.00