A construction company is negotiating on a construction project with a six-month duration. On the last day of each month the construction company may bill the owner for the work completed during the month. The owner pays the monthly bills one month after they are received. For example, the construction company receives payment for work completed during June on July 31. Upload your excel sheet of solution as well The owner also holds 10% retention. Final payment is expected one month after completion of the project and will include payment of the retention. The construction company pays subcontractors when it receives payment from the owner but withholds 11% retention from the subcontractor's payment. The construction company pays for labor weekly. P&GOH is 10% of direct cost. Determine the monthly cash flows and the total cash generated by the project at the end of each month and just before each payment is received from the project's owner. The construction company pays material suppliers, equipment, and project overhead in full when it receives payment from the owner. What is the maximum amount of cash invested by the company during the completion of the project and in which month?

A construction company is negotiating on a construction project with a six-month duration. On the last day of each month the construction company may bill the owner for the work completed during the month. The owner pays the monthly bills one month after they are received. For example, the construction company receives payment for work completed during June on July 31. - The owner also holds 10% retention. Final payment is expected one month after completion of the project and will include payment of the retention. - The construction company pays material suppliers, equipment, and project overhead in full when it receives payment from the owner. - The construction company pays subcontractors when it receives payment from the owner but withholds 11% retention from the subcontractor's payment. - The construction company pays for labor weekly. - P\&GOH is 10% of direct cost. Determine the monthly cash flows and the total cash generated by the project at the end of each month and just before each payment is received from the project's owner. What is the maximum amount of cash invested by the company during the completion of the project and in which month