ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
 T O T A L R E V E N U E T O T A L E X P E N S E S P R O F I T T O T A L C O G S T O T A L N E T I N C O M E
4
5
$1,525,000$1,074,500$450,500$762,500$300,720
6
7
8
9
10
11
12
#VALUE!21.56%increase vs. total revenue last year!#VALUE!29.54% profit for this year!50%20%
13
50%$1,525,00020%$1,525,000
14
15
16
 R E V E N U EJanuary E X P E N S E SCOST OF GOODS SOLD (COGS)OPERATING INICOME
17
$312,000
18
$120,000$85,000January$60,000
19
0.08012820513
20
February$40,000
21
0.07051282051
22
March$75,000
23
0.09615384615
24
April$45,000
25
 is the revenue for the month of January! is the expenses for the month of January! 0.05769230769
26
May$80,000
27
0.1025641026
28
MONTHLY REVENUEJune$50,000
29
0.0641025641EARNINGS BEFORE TAXOPERATING EXPENSES
30
⬛Revenue🟦ExpensesJuly$85,000
31
0.108974359January$25,000
32
August$42,5000.08012820513
33
0.05448717949February$22,000
34
September$87,5000.07051282051
35
0.1121794872March$30,000
36
October$47,5000.09615384615
37
0.0608974359April$18,000
38
November$95,0000.05769230769
39
0.1217948718May$32,000
40
December$55,0000.1025641026
41
0.07051282051June$20,000
42
0.0641025641
43
 A V E R A G E R E V E N U EJuly$34,000
44
0.108974359
45
$127,083August$17,000
46
0.05448717949
47
September$35,000
48
0.1121794872
49
October$19,000
50
0.0608974359
51
November$38,000
52
0.1217948718
53
is the total average revenue!December$22,000
54
0.07051282051
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