Cumulative decrease by x% of total

[Beek]

Hi, I am trying to figure out how to reduce a total balance by x% every month, where the new total is then multiplied by x%. So for example, in the first period the total balance is reduced by x%, then the next period the new total is reduced by x% and so on. Maybe easier to explain with excel:

Any help would be much appreciated. 

[atcodedog05]

Hi @Beek 

Can you provide the above excel file so that we can take a look into it.

[Maskell_Rascal · Accepted solution]

Hi @Beek 

You can accomplish this with a couple Multi-Row Formula tools. The funny thing about these calculations is that you can easily calculate the New_Amt first and then calculate the Depreciation vs how it is done in Excel. 

Attached is a sample workflow. 

Let me know if this solve the problem. 

Cheers!

Phil

[atcodedog05]

Nicely done @Maskell_Rascal 🙂👍

[Beek]

Your solution worked a treat. Many thanks!