๐ฐ 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
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
Interactive Calculatorโ
Percentage of revenue spent on direct costs (default 85%)
Percentage withheld from each payment (default 10%)
Average days from invoice to payment (default 30)