Skip to main content
Skip to main content

๐Ÿ’ฐ 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โ€‹

MonthCosts PaidRevenue ReceivedNet Cash FlowCumulative
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โ€‹

  1. Invoice Promptly - Don't delay billing
  2. Follow Up - Stay on top of receivables
  3. Negotiate Terms - Better payment terms
  4. Front-Load SOV - More payment early (ethically)
  5. Reduce Retention - Negotiate lower retention
  6. Line of Credit - Have credit available
  7. Retain Earnings - Build working capital
  8. 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)

Was this page helpful?