Help with cashflow forecast

[Budlightyear]

Hi There,

I am wondering if its possible to autopopulate a monthly cashflow forecast accounting for initial start date, works already complete via a status bar and applying the remaining costs to be disbursed on a monthly basis on a reducing scale i.e. as more work is completed and the progress bar increases the amount in a given month forecasted reduces.

Difficult to articulate but hope it makes some sense.

I have included a sample workbook for you to have a look and would greatly appreciate any assistance.

Thanks,
B