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