Problem 1. A contractor anticipates his spending to be as shown in the 10months project. Owner’s reimbursement lags by a month and owner retains 10% till the final and satisfactory completion of the project. Borrowing money cost the contractor 1% per month. The contractor will add a 5% profit to the total. I did part a and b but I need you ONLY to Draw the cash flow diagram Use the calculation sheet as in the Cashflow Excel file

 Calculate the cash flow, net cash flow, and cumulative cash flow
 Calculate the cost of borrowing money, maximum debt, and total contract sum
 Draw the cash flow diagram Use the calculation sheet as in the Cashflow Excel file.

Month Spending 1 $1,500,000 2 $1,950,000 3 $2,600,000 4 $3,350,000 5 $3,760,000 6 $4,200,000 7 $2,890,000 8 $2,200,000 9 $1,670,000 10 $920,000 Total $25,040,000