Projected Income Statement (sample and template)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKL
1
Raffles Childcare Centre Projected Income Statement (P&L Forecast)Cash Flow Forecast for Raffles Childcare Centre for First Year
2
3
1Q122Q123Q124Q121Q122Q123Q124Q12
4
Revenue
5
Fee collected from parents14400162001800019800Beginning Cash50000106895103660104925
6
MCYS Grant18000324003600039600
7
Sales of School Uniforms500100100100Cash In
8
Total revenue32900487005410059500Service Revenue32400486005400059400
9
Product Revenue500100100100
10
Cash Equity (from investors)100000000
11
COGSBank Loan0000
12
Services (Enrichment class)4500540063007200Deposits Paid by Clients4800600600600
13
Cost of Sales400808080Other incoming Cash**0101010
14
15
Total COGS4900548063807280
16
17
Gross Margin28000432204772052220Total Cash in137700493105471060110
18
19
20
ExpensesCash Out
21
Loan Interest0000COGS (Cost of Goods Sold)400808080
22
Incorporation expenses2700000Fees for Enrichment classes0450054006300
23
Insurance 160202020Insurance160202020
24
Marketing expenses3000900900900Marketing expenses3000900900900
25
Rent expenses12000900090009000Rent expenses12000900090009000
26
Salaries expenses24000240002400024000Salaries expenses24000240002400024000
27
Supplies used1200130014001500Supplies used1200130014001500
28
Maintenance expenses10008008001000Maintenance expenses10008008001000
29
Bank Charges345454545Bank Charges345454545
30
Utilities expenses6000690078008700Utilities expenses6000690078008700
31
Others*30000500040003000Loan Interest0000
32
Principal Payment0000
33
Start Up Capital***27700000
34
Others5000500040003000
35
36
Total expenses80405479654796548165Total Cash Out80805525455344554545
37
Operating Income-52405-4745-2454055
38
Interest Income10101010
39
Other Income0000
40
Profit Before Tax-52395-4735-2354065
41
Net Cash Flow56895-323512655565
42
*includes $25000 for renovation and furniture.Ending Cash106895103660104925110490
43
44
Do we need to account for GST?
45
Amortisation***Can this be broken down?e.g. renovation, furniture and incorporation expenses
46
Depreciation** Such as Interest Income
47
R&D expenses
48
Taxes
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