Chapter 12 has a Sidebar 12-1 (pg. 169) Cash flow example.Anticipating you are using the exact same process, if the bill to the owners in weeks one - ten were 1M and the Material, Labor and Subcontractor columns were 200K per month each, what would the total cash be at the end of month 10? (Anticipate paid in thirty days with 5% retainage.) (Show your work - use Excel and provide a paste document with this if you like)

Cash Flows for Construction Projects 169 add Table 121 Monthly Costs and Billings for sly, Example 123 l of the cur ash ash Ct 5 Solution: To analyze the cash needs of this project, we begin at the beginning of the project and work our way to _3) the end of the project, calculating the cash flow and total cash generated at the end of each month and just before 'Wn each payment is received from the project's owner. Because \"\"3 the first payment from the owner is not received until the l 0f second month, the first point in time where we calculate the cm total cash generated by the project is at the end of the first be month. For the first month, the peak cash flow occurs at fter the end of the month. Because material suppliers and sub- ay- contractors are paid only when the construction company the receives payment from the owner, no material or subcon- :ek, tractor payments are made during the first month. Payments 0\