Thread: waterfall_calculation

Hi,

Need your support on the following:

I am looking to calculate the actuals vs forecasted values based upon a waterfall calculation as attached (tab overview)

I am basically looking out a way to calculate the actuals vs forecasted values based on some % increament. Any suggestion/support around it would be welcome.

I need to span the budget as follows:
In Jan month, we would spend 100 and rest 11 month will be forecasted..
in feb month, we would spend 100 + 100 and rest 10 month will be forecasted..

like this when we reach Dec, we would have just 1 actual 100 rs to spend...

at the end, I would like to calculate the actuals spent and forecasted amount...

looking forward to your support. Thanks in advance.

HI,

Thanks for the quick reply.

I need the solution in D43,D44 cells...One will capture the actuals and other capture forecasted values..

Attached the updated version...with yellow cells as required cells...