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 |
|