3 Replies Latest reply on Nov 30, 2018 9:24 AM by Jim Dehner

    Accumulated Change

    James Brown

      All,

       

      I am attempting to show the forecasted/future cash flow and in this workbook I have areas that will impact the future balance.

      If I have the current month end date set to 8/31/18, then it's showing 0, since the ending cash balance at 8/31/18 would not need to be adjusted.

      You'll see manual adjustments in each future month.

       

       

      Question: Can you help me put together a calculation that will accumulate the manual adjustments?

      For example, capital purchases would show -300k in September, -600k in October, -900k in November, etc.

      It would need to be flexible to work with the date parameters.

       

      Thanks!