12 Month Cashflow Projection

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

Beginning Cash

$0

Billable Hours

$5,500

$5,500

$8,500

$8,500

$8,500

$8,500

$9,000

$9,000

$9,000

$3,000

$3,000

$4,000

$82,000

Payment for Sub-Contractors

$2,750

$2,750

$4,250

$4,250

$4,250

$4,250

$4,500

$4,500

$4,500

$1,500

$1,500

$2,000

$41,000

Payment for Travel

$825

$825

$1,275

$1,275

$1,275

$1,275

$1,350

$1,350

$1,350

$450

$450

$600

$12,300

Administrative Fees

$413

$413

$638

$638

$638

$638

$675

$675

$675

$225

$225

$300

$6,150

Cash Equity

$10,200

–

–

–

–

–

–

–

–

–

–

–

$10,200

Environmental Grant

–

–

$40,800

–

$8,500

–

–

–

$5,000

–

–

–

$54,300

Bridge Loan

$40,800

–

–

–

–

–

–

–

–

–

–

–

$40,800

Commercial Loan

$17,000

–

–

–

–

–

–

–

–

–

–

–

$17,000

Total Cash In

$77,588

$9,488

$55,463

$14,663

$23,163

$14,663

$15,525

$15,525

$20,525

$5,175

$5,175

$6,900

$263,850

Cost of Sales

Sub-Contractor Fees

$2,750

$2,750

$4,250

$4,250

$4,250

$4,250

$4,500

$4,500

$4,500

$1,500

$1,500

$2,000

$41,000

Direct Travel

$825

$825

$1,275

$1,275

$1,275

$1,275

$1,350

$1,350

$1,350

$450

$450

$600

$12,300

Total Cost

$3,575

$3,575

$5,525

$5,525

$5,525

$5,525

$5,850

$5,850

$5,850

$1,950

$1,950

$2,600

$53,300

Gross Revenue

$74,013

$5,913

$49,938

$9,138

$17,638

$9,138

$9,675

$9,675

$14,675

$3,225

$3,225

$4,300

$210,550

Cash Out

Start Up Capital

$48,000

–

–

–

–

–

–

–

–

–

–

–

$48,000

Marketing Activities

$7,250

$250

$250

$250

$250

$250

$250

$250

$250

$250

$250

$250

$10,000

Trade Show Participation

$5,000

$5,000

$10,000

Salary

$4,167

$4,167

$4,167

$4,167

$4,167

$4,167

$4,167

$4,167

$4,167

$4,167

$4,167

$4,167

$50,000

Utilities

$120

$120

$120

$120

$120

$120

$120

$120

$120

$120

$120

$120

$1,440

Communications

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$2,400

Repairs and Maintenance

–

–

–

–

–

$500

–

–

–

–

–

–

$500

Insurance

$2,000

–

–

–

–

$2,000

–

–

–

–

–

–

$2,000

Incorporation Expense

$360

–

–

–

–

–

–

–

–

–

–

–

$360

Travel Expense

$150

$150

$150

$150

$150

$150

$150

$150

$150

$150

$150

$150

$1,800

Leasing Expense

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$6,000

Office Supplies

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$100

$1,200

Bank Charges

$30

$30

$30

$30

$30

$30

$30

$30

$30

$30

$30

$30

$360

Bridge Loan Repayment

–

–

$40,800

–

–

–

–

–

–

–

–

–

$40,800

Loan Interest

$142

$139

$137

$134

$132

$129

$127

$124

$122

$119

$117

$114

$1,536

Principle Payment

$289

$292

$294

$297

$299

$302

$304

$307

$309

$312

$315

$317

$3,638

Professional Fees

$1000

–

$1,000

–

–

–

–

–

–

$1,000

–

$1,000

$4,000

Total Cash Out

$64,308

$5,948

$47,748

$10,948

$5,948

$8,448

$5,948

$10,948

$5,948

$6,948

$5,948

$6,948

$186,034

Net Cash Flow

$9,705

($35)

$2,190

($1,810)

$11,690

$690

$3,727

($1,273)

$8,727

($3,723)

($2,723)

($2,648)

$24,516

Cumulative Cash Flow

$9,605

$9,669

$11,859

$10,049

$21,738

$22,428

$26,155

$24,882

$33,610

$29,887

$27,164

$24,516