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
- 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 Cash-flow 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