Income statement
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRST
1
1Q2Q3Q4Q
2
Revenue
3
Fee collected from parents$50,000.00$25,000.00$30,000.00$45,000.00
4
MCYS Grant$31,000.00$69,600.00$40,500.00$20,600.00
5
6
Total Revenue$81,000.00$94,600.00$70,500.00$65,600.00
7
8
9
10
11
12
13
14
COGS
15
Ice cream$3,000.00$4,050.00$5,476.00$7,094.00
16
Toppings$95.00$38.00$57.00$107.00
17
18
Total COGS$3,095.00$4,088.00$5,533.00$7,201.00
19
Gross Margin
20
21
22
Expenses
23
Loan Interest$0.00$0.00$0.00$0.00
24
Incorperation expenses$369.00$0.00$0.00$0.00
25
Insurance$160.00$20.00$20.00$20.00
26
Marketing expenses$2,500.00$1,000.00$1,000.00$1,000.00
27
Rent Expenses$15,000.00$15,000.00$15,000.00$15,000.00
28
Salaries Expenses$20,000.00$20,000.00$20,000.00$20,000.00
29
Supplies used$2,000.00$3,000.00$4,000.00$5,000.00
30
Maintainance Expenses$0.00$0.00$0.00$0.00
31
Bank Charges$400.00$20.00$20.00$20.00
32
Utilities Expenses$5,000.00$6,500.00$4,000.00$5,500.00
33
Others*$0.00$0.00$0.00$0.00
34
$45,429.00$45,540.00$44,040.00$46,540.00
35
36
37
38
39
40
Total expenses$45,429.00$45,540.00$44,040.00$46,540.00
41
Operating Income-$42,334.00-$41,452.00-$38,507.00-$39,339.00
42
Interest Income$50.00$50.00$50.00$50.00
43
Other Income$0.00$0.00$0.00$0.00
44
Profit before tax-$166,379.00$182,090.00$151,540.00$158,090.00
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
Loading...
 
 
 
Sheet1