💰 Cash Flow Projection Calculator
Project cash flow for construction projects and your entire company. Essential for financial planning and avoiding cash crunches.
Why Cash Flow Projections Matter
Construction is cash-intensive. You pay for materials and labor before you get paid. Cash flow projections help you:
- Avoid cash crunches - Know when you'll need money
- Plan financing - Line up credit before you need it
- Make decisions - Can you take on that new project?
- Manage payments - Prioritize who gets paid when
Cash Flow Kills More Contractors Than Profitability
Many profitable contractors fail because they run out of cash. Track it religiously.
How Construction Cash Flow Works
The Cash Flow Cycle
Pay for Materials/Labor → Wait for Payment → Receive Payment → Pay Next Cycle
(Week 1-4) (Week 5-8) (Week 9-12)
Typical Timeline:
- Week 1-4: Pay for work performed
- Week 5-8: Wait for owner payment
- Week 9-12: Receive payment (if approved on time)
The Problem
You're always paying for work before you get paid. This creates negative cash flow that must be funded.
Project Cash Flow Projection
Step 1: Project Schedule
Break your project into phases and estimate:
- Start date for each phase
- Duration of each phase
- Completion date
Step 2: Estimate Costs by Period
For each period (week/month), estimate:
- Direct Costs: Labor, materials, equipment, subcontractors
- Indirect Costs: General conditions, overhead allocation
- Total Costs: Sum of direct and indirect
Step 3: Estimate Revenue by Period
For each period, estimate:
- Work Completed: % complete × contract value
- Retention: Typically 5-10% withheld
- Net Revenue: Work completed - retention
Step 4: Calculate Cash Flow
Cash Flow = Revenue Received - Costs Paid
Timing Matters:
- Costs paid: When you pay (typically weekly/bi-weekly)
- Revenue received: When owner pays (typically 30-60 days after invoice)
Step 5: Calculate Cumulative Cash Flow
Cumulative Cash Flow = Previous Cumulative + Current Period Cash Flow
Interactive Calculator
Interactive calculator component coming soon
For now, use this process:
Monthly Cash Flow Projection
| Month | Costs Paid | Revenue Received | Net Cash Flow | Cumulative |
|---|---|---|---|---|
| Month 1 | $_______ | $_______ | $_______ | $_______ |
| Month 2 | $_______ | $_______ | $_______ | $_______ |
| Month 3 | $_______ | $_______ | $_______ | $_______ |
| Month 4 | $_______ | $_______ | $_______ | $_______ |
| Month 5 | $_______ | $_______ | $_______ | $_______ |
| Month 6 | $_______ | $_______ | $_______ | $_______ |
Key Metrics
- Peak Negative Cash Flow: $_______ (lowest point)
- Breakeven Point: Month _______
- Total Cash Needed: $_______
- Payback Period: _______ months
Company-Wide Cash Flow
Step 1: List All Projects
For each active project:
- Project name
- Contract value
- % complete
- Costs to date
- Billed to date
- Received to date
Step 2: Estimate Monthly Costs
- Project Costs: Sum of all project costs
- Overhead Costs: Office, admin, non-project costs
- Debt Service: Loan payments
- Other: Taxes, distributions, etc.
Step 3: Estimate Monthly Revenue
- Project Payments: Expected payments from projects
- Other Income: Equipment rental, etc.
Step 4: Calculate Net Cash Flow
Net Cash Flow = Total Revenue - Total Costs
Common Cash Flow Scenarios
Scenario 1: Growing Company
- Taking on more work
- Cash needs increase faster than revenue
- Solution: Line of credit, retain earnings, slow growth
Scenario 2: Slow Payment
- Owner pays late
- Cash gap widens
- Solution: Invoice promptly, follow up, consider financing
Scenario 3: Front-Loaded Project
- Early payments cover costs
- Positive cash flow early
- Risk: Must finish project to collect remaining
Scenario 4: Back-Loaded Project
- Most payment at end
- Negative cash flow throughout
- Risk: Need significant working capital
Improving Cash Flow
- Invoice Promptly - Don't delay billing
- Follow Up - Stay on top of receivables
- Negotiate Terms - Better payment terms
- Front-Load SOV - More payment early (ethically)
- Reduce Retention - Negotiate lower retention
- Line of Credit - Have credit available
- Retain Earnings - Build working capital
- Manage Payables - Pay on time but not early
Red Flags
Watch for these warning signs:
- Cumulative cash flow stays negative
- Peak negative exceeds available credit
- Multiple projects all negative at once
- Receivables aging beyond 60 days
- Can't pay bills on time