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 Expenditure 200 150 250 400 800 900 133 300 220 130 900 880 Value of Work 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? End of month cumulative Month Actual Receipt Negative cash flow Before payment After payment Marks Expenditure Value of work 3 3 1 1.5 2. 2.5 3 3.5 4 4,5 5 5.3 6 63 3 2 2 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) Figure 1: Cashflows Figure 2: Negative Cashflow 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 Expenditure 200 150 250 400 800 900 133 300 220 130 900 880 Value of Work 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? End of month cumulative Month Actual Receipt Negative cash flow Before payment After payment Marks Expenditure Value of work 3 3 1 1.5 2. 2.5 3 3.5 4 4,5 5 5.3 6 63 3 2 2 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) Figure 1: Cashflows Figure 2: Negative Cashflow