Running Total With Declining Value

  • Hi - I have attached a sample of what I am trying to accomplish. I have a value(s) that needs to decline over a period of time, essentially I want to be able to change the number of years it takes to see a balance hit zero on the table, while also being able to start the process again every year.

    In the sample in 2022, There is a starting balance of $1,000,000 declining by 33% (aka 3 years), year 2 has no balance but year 3 has a residual from year 1 but starts a new declining balance of $1,200,000 (totaling $1,533,333.33). Is this doable without a macro?

    Any help would be appreciated

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!