Depreciation Comparison Calculator

Book-method comparison of straight-line, sum-of-years-digits and double-declining balance with final-year true-up. No tax depreciation, MACRS or acquisition conventions. Final-year salvage true-up is an explicit convention of this comparison model, not a claim about automatic behavior of Microsoft DDB.

Your workbenchInputs are not stored

Result

Enter your values and run the tool to see your result.

How to use this tool

Check the units, enter your values, and run the tool. Results follow the assumptions and method below.

References

https://www.ifrs.org/content/dam/ifrs/publications/pdf-standards/english/2021/issued/part-a/ias-16-property-plant-and-equipment.pdf?bypass=on
https://learn.microsoft.com/en-us/dax/sln-function-dax
https://learn.microsoft.com/en-us/dax/syd-function-dax
https://learn.microsoft.com/en-us/dax/ddb-function-dax