CTC Cash Flow Projection- Year 4
Year 4
|
|
|
Month
|
Month
|
Month
|
Month
|
Month
|
Month
|
Month
|
Month
|
Month
|
Month
|
Month
|
Month
|
Total
|
|
|
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
Year 4
|
Beginning Cash
|
|
1,829,632
|
1,902,530
|
1,980,218
|
2,063,456
|
2,150,951
|
2,243,986
|
2,341,848
|
2,444,165
|
2,551,298
|
2,663,869
|
2,780,743
|
2,902,542
|
|
Cash In:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
e-curriculum sales
|
|
150,000
|
155,000
|
160,000
|
165,000
|
170,000
|
175,000
|
180,000
|
185,000
|
190,000
|
195,000
|
200,000
|
205,000
|
2,130,000
|
User fees
|
|
|
60
|
100
|
100
|
100
|
160
|
160
|
160
|
200
|
200
|
200
|
240
|
240
|
1,920
|
Fundraising
|
|
200
|
|
200
|
|
200
|
|
200
|
|
200
|
|
200
|
|
1,200
|
Grants
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
46,000
|
Value of In-Kind Contributions
|
600
|
600
|
600
|
600
|
600
|
600
|
600
|
600
|
600
|
600
|
600
|
600
|
23,700
|
Interest on Savings Account
|
1,613
|
1,523
|
1,423
|
1,330
|
1,225
|
1,122
|
1,007
|
888
|
756
|
629
|
489
|
350
|
15,481
|
Total Cash In
|
|
152,473
|
157,223
|
162,323
|
167,030
|
172,185
|
176,882
|
181,967
|
186,688
|
191,756
|
196,429
|
201,529
|
206,190
|
2,218,301
|
Start-Up Expenses:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Utility deposits
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Office Equipment
|
|
5,000
|
|
|
|
|
|
|
|
|
|
|
|
5,000
|
Computer Hardware
|
|
10,000
|
|
|
|
|
|
|
|
|
|
|
|
10,000
|
Computer Software
|
|
15,000
|
|
|
|
|
|
|
|
|
|
|
|
15,000
|
Renovations
|
|
5,000
|
|
|
|
|
|
|
|
|
|
|
|
5,000
|
On-Going Expenses:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Salaries
|
|
|
70,000
|
70,000
|
70,000
|
70,000
|
70,000
|
70,000
|
70,000
|
70,000
|
70,000
|
70,000
|
70,000
|
70,000
|
840,000
|
Health Insurance
|
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
3,400
|
FICA Social Security
|
|
4,340
|
4,340
|
4,340
|
4,340
|
4,340
|
4,340
|
4,340
|
4,340
|
4,340
|
4,340
|
4,340
|
4,340
|
52,080
|
FICA Medicare
|
|
1,015
|
1,015
|
1,015
|
1,015
|
1,015
|
1,015
|
1,015
|
1,015
|
1,015
|
1,015
|
1,015
|
1,015
|
12,180
|
Workers Comp
|
|
315
|
315
|
315
|
315
|
315
|
315
|
315
|
315
|
315
|
315
|
315
|
315
|
3,780
|
Unemployment Insurance
|
385
|
385
|
385
|
385
|
385
|
385
|
385
|
385
|
385
|
385
|
385
|
385
|
4,620
|
Professional Fees
|
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
1,200
|
Insurance
|
|
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
2,800
|
Telephone
|
|
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
2,600
|
Water
|
|
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
1,400
|
Electricity
|
|
|
500
|
500
|
500
|
500
|
500
|
500
|
500
|
500
|
500
|
500
|
500
|
500
|
2,100
|
Rent
|
|
|
1,000
|
1,000
|
1,000
|
1,000
|
1,000
|
1,000
|
1,000
|
1,000
|
1,000
|
1,000
|
1,000
|
1,000
|
11,200
|
Security
|
|
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
1,250
|
Equipment maintenance
|
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
200
|
2,400
|
On-line services
|
|
50
|
50
|
50
|
50
|
50
|
50
|
50
|
50
|
50
|
50
|
50
|
50
|
600
|
Advertising
|
|
500
|
500
|
|
500
|
|
|
500
|
500
|
|
500
|
500
|
|
500
|
Printing
|
|
|
100
|
100
|
100
|
100
|
100
|
|
100
|
|
100
|
|
100
|
|
340
|
Postage
|
|
|
20
|
20
|
20
|
20
|
20
|
20
|
20
|
20
|
20
|
20
|
20
|
20
|
240
|
Newsletter
|
|
|
50
|
|
50
|
|
50
|
20
|
50
|
20
|
50
|
20
|
50
|
20
|
300
|
Equipment Replacement
|
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
100
|
1,200
|
Supplies
|
|
|
100
|
60
|
60
|
60
|
95
|
95
|
95
|
110
|
110
|
110
|
135
|
135
|
1,215
|
Educational Materials
|
|
|
50
|
50
|
50
|
80
|
80
|
80
|
100
|
100
|
100
|
120
|
120
|
1,430
|
Total Cash Out:
|
|
79,575
|
79,535
|
79,085
|
79,535
|
79,150
|
79,020
|
79,650
|
79,555
|
79,185
|
79,555
|
79,730
|
79,100
|
981,835
|
Cash Flow:
|
|
72,898
|
77,688
|
83,238
|
87,495
|
93,035
|
97,862
|
102,317
|
107,133
|
112,571
|
116,874
|
121,799
|
127,090
|
|
Ending Cash:
|
|
1,902,530
|
1,980,218
|
2,063,456
|
2,150,951
|
2,243,986
|
2,341,848
|
2,444,165
|
2,551,298
|
2,663,869
|
2,780,743
|
2,902,542
|
3,029,632
|
|
Share with your friends: |
