Perform cash flow calculations for the following activities assuming the followings:

• The contractors monthly indirect cost is $2,500.
• The Contractor will have a markup of 12%
• The retainage will be 10% monthly and will be paid back at the end of the project.
• The contractor will receive an advanced payment of 20% of the total project value. A deduction of equivalent percentage will be made from each progress payment.
• Tasks 1, 3 and 6 are subcontracted and being performed by the same subcontractor. Retention of 10% will be withheld from the subcontractors progress payments. The retention will be paid to subcontractors with the final payment to the subcontractor (i.e one month after finishing the work)
• The monthly interest rate used is 1%.

Mar 2011 Apr 2011 May 2011 Jun 2011 Jul 2011 Aug 2011 Sep 2011 ID Task Name Start Finish Duration Total Cost $ 3/6 3/133/203/27 4/3 4/10 4/174/24 5/1 5/8 5/15 5/225/296/5 6/126/196/267/3 7/107/17 7/24 7/31 8/7 8/148/21 8/28 94 9/11 9/18 9/25 1 Task 1 3/1/2011 3/28/2011 4w $ 20,000 $ 20,000 4/25/2011 6W $ 24,000 Task 2 $ 24,000 2 Task 2 | 3/15/2011 3 Task 341/2011 5/26/2011 8W $ 18,000 Task 3 $ 18,000 4 Task 4 4/1/2011 4/7/2011 1w $ 1,500 Task 4 $ 1,500 5 Task 5 4/7/2011 4/20/2011 2w $ 12,000 Task 5 $ 12,000 6 Task 6 5/30/2011 7/22/2011 8W $ 20,000 Task 6 $ 20,000 7 Task 7 7/25/2011 8/19/2011 4w $ 6,000 Task 7 $6,000 8 Task 8 8/22/2011 9/30/2011 6W $ 6,000 Task 8 $ 6,000 9 Task 9 8/22/2011 9/16/2011 4w $ 16,000 Task 9 $ 16,000 10 Task 10 9/1/2011 9/28/2011 4w $ 6,000 Task 10 $ 6,000