£75
The advanced project cashflow is designed for people with a better knowledge of terminology and the process with forecasting cost and value. This is also ideal for bigger projects which will have multiple cost heads or a more complex set-up.
First, you fix your budget. In theory, an entire tender can be made with this tab too. You input net costs for all cost heads, add overheads and turnover to calculate an overhead percentage and then your net profit margin percentage. This will generate a "sell price" to the client and which you set as the budget for both costs and your contract value to track incoming money.
When done, you need to plot this in the yellow cells on the "cashflow" tab. Forecast when you expect cash to leave the bank and not when you'll receive an invoice or the service on site. Populate this so that the check cells on the right side of the tab all say "TRUE". You want them to match the contract value or cost budgets.
Then input things like your retention percentage (if any, if none just put 0%).
Once this is done and you're happy with the initial set up, you need to track when money will land from your client. Taking each contract term for payment, input when the first application will land and then the intervals for following payments. You'll almost certainly have the last payment land after the planned completion date for your project.
When this is done and correct, it'll show a weekly net cashflow and margin percentage. Anything under 0.01% will show in red and anything above in green.
After the initial set up you can tweak costs / values and adjust for how the project progresses.