Table 1 gives the planned cost expenditures for a construction project. Calculate the maximum interim financing required by the contractor. Assume a 12% markup and a 10% retainage throughout the project. Finance charge is 0.9% per month. Payments are billed at the end of each month and received one month later. The last payment is planned for the end of fifth month. Calculate the final value of markup considering finance charges. Now consider the same problem but assume that the expenditures in each month happen at the midpoint of the month. The effect of that on the interest is that the time for interest calculation for the expenses in the month is only a half-month. Redo the spreadsheet with this assumption and calculate the final value of markup