There are many ways to calculate cash flows by project. I've seen some pretty complicated worksheets out there so I've put together a simple one you can download below. There are natural complexities like payroll and related liabilities that should be considered, but I hope this worksheet will help get you on the right track.
Two tabs:
The cash flow by job worksheet
Legend explaining each column
Cash Flow by Job
.xlsx
Download XLSX • 15KB
Thank you!
Ara