Be The Dream 925 S. Sailfish Dr


CTC Cash Flow Projection- Year 4



Download 1.06 Mb.
Page29/30
Date29.01.2017
Size1.06 Mb.
1   ...   22   23   24   25   26   27   28   29   30

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




Download 1.06 Mb.

Share with your friends:
1   ...   22   23   24   25   26   27   28   29   30




The database is protected by copyright ©ininet.org 2020
send message

    Main page