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