ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
[YOUR COMPANY NAME]
2
Company Monthly Analysis
3
4
JanFebMarAprMayJunJulAugSepOctNovDecTOTAL
5
AUDAUDAUDAUDAUDAUDAUDAUDAUDAUDAUDAUDAUD
6
7
Revenue 90,654 108,783 110,595 97,170 94,277 98,320 84,057 112,801 88,615 106,737 80,479 119,636 1,192,124
8
Cost of Goods Sold 54,814 57,445 40,762 53,536 41,123 52,296 40,731 44,544 47,016 40,297 45,392 57,863 575,819
9
Gross Profit 35,840 51,338 69,833 43,634 53,154 46,024 43,326 68,257 41,599 66,440 35,087 61,773 616,305
10
Gross Profit Margin (in %)40%47%63%45%56%47%52%61%47%62%44%52%52%52%48%30%
11
12
Operating Expenses (OPEX)
13
Distribution Cost 3,394 6,148 6,240 14,065 9,701 4,736 11,562 1,146 9,955 17,051 15,085 18,987 118,070
14
Selling & Administrative Expenses 5,446 18,562 9,431 8,321 14,100 5,058 15,966 7,911 12,428 19,601 6,202 10,978 134,004
15
Other Operating Costs 1,227 2,495 2,528 2,470 3,995 569 3,717 1,750 718 4,599 1,653 3,176 28,895
16
Total Operating Expenses 10,067 27,205 18,199 24,856 27,796 10,363 31,245 10,807 23,101 41,251 22,940 33,141 280,969 24%76%30%
17
Operating Profit 25,773 24,134 51,634 18,778 25,358 35,661 12,081 57,451 18,498 25,189 12,147 28,633 335,336
18
Operating Profit Margin28%22%47%19%27%36%14%51%21%24%15%24%28%28%72%30%
19
20
Other Revenue 5,000 200 109 5,309
21
Profit Before Interest & Taxes 30,773 24,134 51,634 18,778 25,358 35,861 12,081 57,451 18,607 25,189 12,147 28,633 340,645
22
Interest Expense 136 975 383 250 595 942 207 281 353 861 890 935 6,808
23
Profit Before Taxes 30,637 23,159 51,251 18,528 24,763 34,919 11,874 57,170 18,254 24,328 11,257 27,698 333,837
24
Income Tax - - - - - - - - - - - - -
25
Net Profit 30,637 23,159 51,251 18,528 24,763 34,919 11,874 57,170 18,254 24,328 11,257 27,698 333,837
26
Net Profit Margin34%21%46%19%26%36%14%51%21%23%14%23%28%28%72%30%
27
Target Net Profit 30,000 30,900 31,827 32,782 33,765 34,778 35,822 36,896 38,003 39,143 40,317 41,527 42,773
28
29
30
31
32
33
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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100