CPM tutor

click back to return to CPM Tutor

cash flow example 1

  Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Total
Direct Cost $2,000 $4,200 $6,000 $5,500 $3,000     $20,700
Indirects (10%) $200 $420 $600 $550 $300     $2,070
Total Costs $2,200 $4,620 $6,600 $6,050 $3,300     $22,770
Markup (5%) $110 $231 $330 $302 $165     $1,138
Earned Value $2,310 $4,851 $6,930 $6,352 $3,465     $23,908
Retainage(10%) $231 $486 $693 $635 $346     $2,391
Payment Due $2,071 $4,365 $6,237 $5,717 $3,119     $21,517
2 mo. offset     $2,079 $4,365 $6,237 $5,717 $5,510 $23,908
Cash Outflow $2,200 $4,620 $6,600 $6,050 $3,300     $22,770
Cumulative Outflow $2,200 $6,820 $13,420 $19,470 $22,770 $22,770 $22,770 $22,770
Cum. Income $0 $0 $2,079 $6,444 $12,681 $18,398 $23,908 $23,908
Cum. Interest $0 $22 $68 $114 $131 $102 $45 $0
Overdraft $2,200 $6,842 $11,409 $13,140 $10,220 $4,478 $1,093
$22 $68 $114 $131 $102 $45 $0 $482