Question 4 (25%) (CLO 4: 100%) A contractor monthly cashflow (in thousands SR) to build a Villa is as follows: Month 1 2 3 4 5 6 150 250 400 800 900 Expenditure 200 Value of 133 Work 300 220 130 900 880 Progress payments are calculated at the end of each month and received at the middle of the following month with a Retainage of 15% until project completion. The final project payment, including released retainage is received the middle of the month following project completion. Answer the followings: 1. Calculate and fill in the below table? Actual Receipt Negative cash flow Before payment After payment Marks End of month cumulative Month Expenditure Value of work 1 15 2 2.5 3 3.5 4 3 3 2 4.5 5 5.5 2 6 6.5 2 2. What is the contractor's least negative cash flow and when does it occurs? 4 3 Plot the accumulated project expenditures, value of work, and progress payments received versus time (3) 4 Draw the negative cash flow profile and show the values in the graph. (3) 4 Figure 1: Cashflows Figure 22 Negative Cashflow