ACT Technical Services

12 Month Cashflow Projection Example

 

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

Total

Cash In

 

 

 

 

 

 

 

 

 

 

 

 

 

Opening Cash Balance

 

 

 

 

 

 

 

 

 

 

 

 

 

Direct Training

$0

$0

$0

$3,096

$3,096

$6,191

$8,513

$11,609

$11,609

$8,513

$7,739

$3,870

$64,236

Training Sub-Contrating

$0

$0

$0

$1,311

$1,311

$2,622

$3,606

$4,917

$4,917

$3,606

$3,278

$1,639

$27,206

Manual Development $0

$0

$0

$891

$891

$1,782

$2,450

$3,341

$3,341

$2,450

$2,228

$1,114

$18,488

Other Revenue $0

$0

$0

$833

$833

$833

$833

$833

$833

$833

$833

$833

$7,500

Cash Equity

$11,665

-

-

-

-

-

-

-

-

-

-

-

$11,665

ADPC

$76,365

-

-

-

-

-

-

-

-

-

-

-

$76,365

Commercial Financing

$28,620

-

-

-

-

-

-

-

-

-

-

-

$28,620

Total Cash In

$116,650

$23,521

$33,441

$27,741

$105,482

$31,361

$33,611

$35,281

$39,281

$39,201

$43,121

$43,121

$234,080

 

 

 

 

                   

Cash Out

 

 

 

 

 

 

 

 

 

 

 

 

 

Purchases/Capitalization

$99,650

-

-

-

-

-

-

-

-

-

-

-

$99,650

Owners wages

$2,750

$2,750

$2,750

$2,750

$2,750

$2,750

$4,750

$4,750

$4,750

$4,750

$4,750

$4,750

$45,000

Sub-Contracting

 $1,559

  $1,559

  $3,118

 $4,288

 $5,847 

 $5,847 

  $4,288

 $3,898

  $1,949

 $1,949 

 $2,339 

 $2,339 

$38,978

Training Supplies

$171

$171

$342

$470

$641

$641

$470

$427

$214

$214

$256

$256

$4,273

Travel

$200

$200

$400

$550

$750

$750

$550

$500

$250

$250

$300

$300

$5,000

Accommodations

$220

$220

$440

$605

$825

$825

$605

$550

$275

$275

$330

$330

$5,500

Advertising

$1,000

$0

$0

$0

$0

$0

$0

$0

$1,000

$1,000

$1,000

$1,000

$5,000

Promotion

$208

$208

$208

$208

$208

$208

$208

$208

$208

$208

$208

$208

$2,500

Brochures & CD's

$1,000

$0

$0

$0

$0

$0

$0

$0

$0

$1,000

$1,000

$1,000

$5,000

Website

$150

$150

$150

$150

$150

$150

$150

$150

$150

$150

$150

$150

$1,800

Office Supplies

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$1,200

Insurance

$375

$375

$375

$375

$0

$0

$0

$0

$0

$0

$0

$0

$1,500

Telephone

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$2,400

Accounting

$0

$0

$625

$0

$0

$625

$0

$0

$625

$0

$0

$625

$2,500

Rent

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Bank charges

$25

$25

$25

$25

$25

$25

$25

$25

$25

$25

$25

$25

$300

Postage Courier

$25

$25

$25

$25

$25

$25

$25

$25

$25

$25

$25

$25

$300

Miscellaneous

$83

$83

$83

$83

$83

$83

$83

$83

$83

$83

$83

$83

$1,000

Interest Payment

$173

$171

$168

$166

$163

$161

$158

$156

$153

$151

$148

$146

$1,913

Principle Repayment $397 $400 $402 $404 $407 $409 $412 $414 $417 $419 $422 $424 $4,928

Total Cash Out

$108,287

$6,637

$9,412

$10,399

$12,174

$12,799

$12,024

$11,487

$11,424

$10,799

$11,337

$11,962

$228,743

Net Cash Flow

$8,363

($6,637)

($9,412)

($4,268)

($6,043)

($1,371)

$3,378

$9,213

$9,276

$4,603

$2,741

$(4,506)

$5,337

                           

Bank Balance Open

$5,000

$13,363

$6,726

($2,686)

($6,954)

($12,997)

($14,368)

($10,997)

($1,777)

$7,499

$12,102

$14,843

$10,337 

Bank Balance Close

$13,363

$6,726

($2,686)

($6,954)

($12,997)

($14,368)

($10,990)

($1,777)

$7,499

$12,102

$14,843

$10,337

 


Click here to return to Financial Plan Samples