A contractor has a five-month project with the expected direct costs as follows: 1st month - $25,000, 2nd month - $40,000, 3rd month - $65,000, 4th month – $80,000, and 5th month - $30,000. It is assumed that (1) the monthly indirect cost is $6,000; (b) retainage is 10% for the first three months, and 0% thereafter; (c) the markup is 25%; and, (d) the monthly interest rate is 1%. The contractor submits payment requests at the end of each month, and payments are received at the end of the next month. The accumulated retainage will be paid to the contractor with the last payment.
1) Create an overdraft calculation table.
2) Draw an overdraft profile plot.
3) Calculate the present values of profits at interest rates 0%, 6%, and 10%.