Reference no: EM131136587

Set up a spreadsheet to solve Problem 6.

In Problem 6, the construction company in Problem 2 decides to act as the owner on the project. The construction company plans to sell the project for $1,250,000 at the end of the seventh month. In addition to the construction costs the construction company has the following soft costs: land purchase, $250,000; engineering and design fees, $30,000; building permits, $7,000; government fees, $15,000; and other miscellaneous costs, $10,000. The soft costs will be paid at the end of month zero. The construction company pays material suppliers in full on the fifteenth day of the month following the month the materials were supplied to the project. For example, materials supplied during the first month will be paid for on the fifteenth of the second month. The subcontractors will be paid on the same schedule as the suppliers; however, the construction company will withhold 10% retention from the subcontractors' payments, which will be paid to the subcontractors on the fifteenth day of the seventh month. The construction company pays for labor weekly. Determine the monthly cash flows and total cash generated by the project at the end of each month and just before the payment is received. What is the maximum amount of cash invested by the company during the completion of the project?