Asset Depreciation Workflow in Alteryx Using Diminishing Value Method

[Buddhi_DB]

Hi Community,

I’m looking to build an asset depreciation workflow in Alteryx using the Diminishing Value Method. Below is the input data I plan to use for the calculation:

Depreciation Start Date Asset Cost Depreciation Rate Depreciation Method

31 Mar 2013

1,156.00

12%

Diminishing Value

I’ve attached an example of the expected result.

Requirements:

Depreciation should be calculated monthly, starting from the depreciation start date, and should continue until the Net Book Value (NBV) reaches $10.

Could someone guide me on how to set up this workflow in Alteryx? Specifically, I’m looking for help on:

1. Setting up monthly depreciation calculations using the diminishing value method.
2. Generating rows for each month until the NBV reaches the $10 threshold.

[Raj]

@Buddhi_DB 
find the workflow attached
mark done of solved.

[Buddhi_DB]

Hi @Raj ,  Thank you for considering this. If you have a moment, please refer to the attached expected result. The depreciation should be calculated as follows: (Net Book Value - Monthly Depreciation). This calculation is based on the diminishing value method.

The monthly depreciation rate can be calculated using the formula: "1 - (1 - 0.12)^(1/12)."

[Raj · Accepted solution]

@Buddhi_DB 
i have updated the formula and this produces expected results.

[Buddhi_DB]

Hi @Raj , It works! Thank you very much for your support, as always.