A contractor has a five-month project with the expected direct costs as follows: 1^st month-$25,000, 2^nd month-$40,000, 3^rd month-$65,000, 4^th month-$80,000, and 5^th 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%. Suppose that a small corporation wishes to build an office building and finance by issuing a 20-year bond at an annual interest rate of 10% to be paid annually. The construction will require three years and cost a total of $15 million, assuming that $5 million is spent at the end of each year. Short term cash funds can be deposited in an account having a 10% annual interest rate. The principal will be repaid at the end of 20 years. The activation fee for issuing the bond is $200,000. Estimate the present value of the financing plan at MARR 15%