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.
Solved! Go to 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
Nicely done @Maskell_Rascal 🙂👍
Your solution worked a treat. Many thanks!