Converting Effective Life to the percentage depreciation rate - Spreadsheet Calculator

If you need a hand with the conversion of effective life in years to a depreciation percentage, we’ve built a simple spreadsheet in MS Excel which does the job.

The calculator converts number of years to a depreciation percentage rate so you can get an actual depreciation claim amount in dollars. You can also see the comparison between the Diminishing Value and Prime Cost calculation methods.