Cash-flow Excel file

Problem 1. A contractor anticipates his spending to be as shown in the 10-months 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 Cash-flow Excel file

    1. Calculate the cash flow, net cash flow, and cumulative cash flow
    2. Calculate the cost of borrowing money, maximum debt, and total contract sum
    3. Draw the cash flow diagram Use the calculation sheet as in the Cash-flow Excel file.
    4. 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