ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
*Cash basis means the actual cash you receive and pay out each month. Money that has actually hit your accounts or left your accounts.
2
*Only touch the blue
3
4
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberQ1Q2Q3Q4
5
Revenue$100,000$105,000$110,250$115,763$121,551$127,628$134,010$140,710$147,746$155,133$162,889$171,034$315,250$364,941$422,465$489,056
6
Cost of Goods Sold (COGS)
7
Employees$25,000$26,250$27,563$28,941$30,388$31,907$33,502$35,178$36,936$38,783$40,722$42,758$78,813$91,235$105,616$122,264
8
Contractors$25,000$25,000$25,000$25,000$25,000$25,000$25,000$25,000$25,000$25,000$25,000$25,000$75,000$75,000$75,000$75,000
9
Software to serve customers$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$3,000$3,000$3,000$3,000
10
Total COGS$51,000$52,250$53,563$54,941$56,388$57,907$59,502$61,178$62,936$64,783$66,722$68,758$156,813$169,235$183,616$200,264
11
Gross Profit$49,000$52,750$56,688$60,822$65,163$69,721$74,507$79,533$84,809$90,350$96,167$102,275$158,438$195,706$238,849$288,792
12
Gross Profit Margin49.00%50.24%51.42%52.54%53.61%54.63%55.60%56.52%57.40%58.24%59.04%59.80%50.26%53.63%56.54%59.05%
13
14
15
Operating Expenses (Opex)
16
Sales & Marketing$1,000$1,020$1,040$1,061$1,082$1,104$1,126$1,149$1,172$1,195$1,219$1,243$3,060$3,248$3,447$3,657
17
Legal$1,000$1,020$1,040$1,061$1,082$1,104$1,126$1,149$1,172$1,195$1,219$1,243$3,060$3,248$3,447$3,657
18
Accounting$1,000$1,020$1,040$1,061$1,082$1,104$1,126$1,149$1,172$1,195$1,219$1,243$3,060$3,248$3,447$3,657
19
Rent$1,000$1,020$1,040$1,061$1,082$1,104$1,126$1,149$1,172$1,195$1,219$1,243$3,060$3,248$3,447$3,657
20
Non-billable employees$1,000$1,020$1,040$1,061$1,082$1,104$1,126$1,149$1,172$1,195$1,219$1,243$3,060$3,248$3,447$3,657
21
Non-billable contractors$1,000$1,020$1,040$1,061$1,082$1,104$1,126$1,149$1,172$1,195$1,219$1,243$3,060$3,248$3,447$3,657
22
Etc
23
Total Opex$6,000$6,120$6,242$6,367$6,495$6,624$6,757$6,892$7,030$7,171$7,314$7,460$18,362$19,486$20,679$21,945
24
Profit (Before Tax)$43,000$46,630$50,445$54,455$58,668$63,097$67,750$72,640$77,779$83,179$88,853$94,815$140,075$151,530$163,568$176,220
25
Profit Margin43.00%44.41%45.76%47.04%48.27%49.44%50.56%51.62%52.64%53.62%54.55%55.44%44.43%41.52%38.72%36.03%
26
27
Tax Rate30%
28
Taxes$12,900$13,989$15,134$16,336$17,601$18,929$20,325$21,792$23,334$24,954$26,656$28,445$42,023$45,459$49,070$52,866
29
30
Net Profit (After Tax)$30,100$32,641$35,312$38,118$41,068$44,168$47,425$50,848$54,445$58,225$62,197$66,371$98,053$106,071$114,498$123,354
31
32
Owners Draw
33
34
35
36
Year to Date (YTD) Numbers
37
Revenue$100,000$205,000$315,250$431,013$552,563$680,191$814,201$954,911$1,102,656$1,257,789$1,420,679$1,591,713
38
COGS$51,000$103,250$156,813$211,753$268,141$326,048$385,550$446,728$509,664$574,447$641,170$709,928
39
Gross Profit$49,000$101,750$158,438$219,259$284,422$354,143$428,651$508,183$592,992$683,342$779,509$881,784
40
Gross Profit Margin49.00%49.63%50.26%50.87%51.47%52.07%52.65%53.22%53.78%54.33%54.87%55.40%
41
Opex$6,000$12,120$18,362$24,730$31,224$37,849$44,606$51,498$58,528$65,698$73,012$80,473
42
Net Profit (Before Tax)$43,000$89,630$140,075$194,530$253,198$316,295$384,045$456,685$534,465$617,644$706,497$801,312
43
Net Profit Margin43.00%43.72%44.43%45.13%45.82%46.50%47.17%47.82%48.47%49.11%49.73%50.34%
44
Net Profit (After Tax)$30,100$62,741$98,053$136,171$177,239$221,406$268,831$319,680$374,125$432,351$494,548$560,918
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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100