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) is 10% for the first three months, and 0% thereafter, (e) the markup is 25% and, d) the monthly interest rate is 1% The contractor submit payment requests at the end of each month, and payments are received at the end of the next month. The accumulated 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 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 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%. 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) is 10% for the first three months, and 0% thereafter, (e) the markup is 25% and, d) the monthly interest rate is 1% The contractor submit payment requests at the end of each month, and payments are received at the end of the next month. The accumulated 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 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 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%