Progress curves: financial. Provided in the table are data taken from the progress curves of cost and value as shown in Figure 8.15. Fill in the final six columns of the table: A positive sign on net cash flow indicates a net receipt of monies, a negative sign indicates a net expenditure for the time period. Determine the loan amount necessary and use that figure for the initial balance in the contractor's savings account. Assume that the loan is to be repaid incrementally as soon as possible, and devise a plan to do that. The final balance in the savings account represents net profit from the project.
End of week | Cum. Value | Cum. Cost | Disbursement (-) | Receipt (+) | Net Cash Flow (+/-) | Cum. Cash Flow (+/-) | Payment on Loan | Savings Account Balance |
0 | 0 | 0 |
|
|
|
|
|
|
1 | - | 4500 |
|
|
|
|
|
|
2 | 14.000 | 11.500 |
|
|
|
|
|
|
3 | - | 21.500 |
|
|
|
|
|
|
4 | 48.000 | 39.500 |
|
|
|
|
|
|
5 | - | 63.000 |
|
|
|
|
|
|
6 | 85.000 | 78.000 |
|
|
|
|
|
|
7 | - | 86.000 |
|
|
|
|
|
|
8 | 99.000 | 90.000 |
|
|
|
|
|
|
9 | - | 90.000 |
|
|
|
|
|
|
10 | 99.000 | 90.000 |
|
|
|
|
|
|
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.