MODULE 10
Cash-flow & S-curve
ADVANCE PAYMENT %
RETENTION %
PAYMENT LAG (MONTHS)
MONTHLY WEIGHT % (must sum to ~100; current Σ = 100.0%)
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
CUMULATIVE S-CURVE
- Cum Cost
- Cum Cash In
- Cash Position
MONTHLY DETAIL
| Month | Weight % | Month Cost | Cum Cost | Month Revenue (net of retention) | Cum Cash-In | Cash Position |
|---|---|---|---|---|---|---|
| M1 | 10.0 | 857,491 | 857,491 | 838,537 | 882,670 | 25,179 |
| M2 | 15.0 | 1,286,237 | 2,143,728 | 1,257,805 | 1,721,207 | -422,521 |
| M3 | 15.0 | 1,286,237 | 3,429,965 | 1,257,805 | 2,979,011 | -450,954 |
| M4 | 15.0 | 1,286,237 | 4,716,202 | 1,257,805 | 4,236,816 | -479,386 |
| M5 | 12.0 | 1,028,990 | 5,745,192 | 1,006,244 | 5,494,621 | -250,571 |
| M6 | 10.0 | 857,491 | 6,602,683 | 838,537 | 6,500,865 | -101,818 |
| M7 | 8.0 | 685,993 | 7,288,677 | 670,829 | 7,339,401 | 50,724 |
| M8 | 7.0 | 600,244 | 7,888,920 | 586,976 | 8,010,230 | 121,310 |
| M9 | 5.0 | 428,746 | 8,317,666 | 419,268 | 8,597,206 | 279,540 |
| M10 | 3.0 | 257,247 | 8,574,914 | 251,561 | 9,016,474 | 441,560 |