Terra Engineering
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
As you can see, the cash flow is broken down monthly. If you want to see the yearly break down, I’ve included it as sources and uses of funds.
Simply click the link below and you can see how the cash flow is broken down by the year. I would add the monthly cash flow first and
than follow it up with the yearly break down.
Click here to see the projected yearly cash flow statement of the sources and uses of funds
Click here to return to financial plan page
Click here to return to business plan outlines