The following steps are helpful to calculate the cash flow in excel for a construction project. 1. Enter the starting balance or cash on hand. 2. Enlist all the cash inflows and do a total. 3. Enlist all the cash outflows and do a total. 4. Subtract cash outflows from cash inflows to calculate net cash flow. 5. Add the net cash flow in starting balance to find the closing balance.