CASH FLOW

650,000.00
2,703,901.74 2,750,000.00
550,000.00
2,224,747.19 2,250,000.00
450,000.00

350,000.00
1,722,603.15 1,750,000.00
1,643,994.67
250,000.00
1,286,411.34 1,250,000.00
150,000.00
989,744.67
50,000.00
750,000.00
639,953.00
(50,000.00) Start 44501 44531 44562 44593 44621 44652 44682 44713 44743 45108 45139 Start 44501 44531 44562 44593 44621 44652 44682 44713 44743 45108 45139
385,328.00 335,196.42
CASH IN Payment (15 days for cer- 385,328.00 -NaN285,328.00 149,868 404,757 449,792 396,667 457,583 178,608 602,144 579,155 56,714 192,664 250,000.00
(150,000.00)
tificate + 15 days for payment)

Cost -NaN 100000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 -NaN -NaN
Net -NaN -100000 49868.4215 304756.5785 349791.6695 296666.6695 357583.3305 78608.477 502144.046 479154.5465 -NaN -NaN

Carry Forward 385,328.00 285,328.00 335,196.42 639,953.00 989,744.67 1,286,411.34 1,643,994.67 1,722,603.15 2,224,747.19 2,703,901.74 -NaN -NaN

CASH IN Payment (15 days for certificate + 15 days for payment) Cost Net Carry Forward

Start Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Jul-23 Aug-23
Description
Start Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9

Monthly Projected Value 176,316 476,184 529,167 466,667 538,333 210,128 708,405 681,358 66,723

Add Advance payment 385,328

Deduct Advance payment Recovery -17,632 -47,618 -52,917 -46,667 -53,833 -21,013 -70,840 -68,136 -6,672

Deduct 5% Retention -8,816 -23,809 -26,458 -23,333 -26,917 -10,506 -35,420 -34,068 -3,336

Add 5 % Retention on Liaility Period Completion 192,664

Total Valuation for the Month 385,328 149,868 404,757 449,792 396,667 457,583 178,608 602,144 579,155 56,714 192,664

CASH IN Payment (15 days for certificate + 15 days for payment) 385,328.00 149,868 404,757 449,792 396,667 457,583 178,608 602,144 579,155 56,714 192,664

Cost 100000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000

Net -100000 49868.4215 304756.5785 349791.6695 296666.6695 357583.3305 78608.477 502144.046 479154.5465

Carry Forward 385,328.00 285,328.00 335,196.42 639,953.00 989,744.67 1,286,411.34 1,643,994.67 1,722,603.15 2,224,747.19 2,703,901.74
Learn Project Control at
www.smartpmtraining.com

Click below to follow me on LinkedIn