S. Refer to an incomplete cash fow analysis chart of a project below. There is a

Question

S. Refer to an incomplete cash fow analysis chart of a project below. There is a one-month time lag in the schedule of monthly payment from the owner to the general contractor. 10% of monthly value shall be held as retention Monthly payment begins two months after working period. The retention shal be released over two months in equal amount after the completion of job. Monthly subcontract cost is 90%of Value Per Month, which is to be paid with a lag time of one month, Subcontract paymennt is not subject to retention. Complete this chart. 100 150 200 300250 200 Cumulative Value Cumulative Value Less Retention (10%) Cumulative Payment Received From Certification Cumulative Retention Payment Cumulative Cash-in Subcontract Cost Per Month Cumulative Subcontract Payment Cumulative Cash out Net) Cumulative Cash Flow

Explanation / Answer

1 2 3 4 5 6 7 8 VALUE PER MONTH    100.00    150.00    200.00    300.00       250.00         200.00 CUMULATIVE VALUE    100.00    250.00    450.00    750.00    1,000.00      1,200.00 CUMULATIVE VALUE LESS RETENTION (10%)      90.00    225.00    405.00    675.00       900.00      1,080.00 CUMULATIVE PAYMENT RECEIVED ROM CERTIFICATION            -             -        90.00    225.00       405.00         675.00      900.00     1,080.00 CUMULATIVE RETENTION PAYMENT            -          5.00      17.50      35.00         60.00           87.50      110.00        120.00 CUMULATIVE CASH IN            -          5.00    107.50    260.00       465.00         762.50 1,010.00     1,200.00 SUBCONTRACT COST PER MONTH      90.00    135.00    180.00    270.00       225.00         180.00 CUMULATIVE SUB CONTRACT COST      90.00    225.00    405.00    675.00       900.00      1,080.00 1,080.00     1,080.00 CUMULATIVE SUB CONTRACT PAYMENT            -        90.00    225.00    405.00       675.00         900.00 1,080.00     1,080.00 CUMULATIVE CASH OUT            -        90.00    225.00    405.00       675.00         900.00 1,080.00     1,080.00 CASH FLOW FOR THE MONTH            -      (85.00)    (32.50)    (27.50)       (65.00)           72.50        67.50        190.00 NET CUMULATIVE CASH FLOWS            -      (85.00) (117.50) (145.00)     (210.00)        (137.50)      (70.00)        120.00

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.