Zervant's Free Depreciation Calculator

Free Depreciation Calculator in Excel

When you run a small business there are a million and one things you need to calculate and keep track of. Which is why we’ve created this free depreciation calculator. It works for both straight-line and reducing balance methods. And if you need any help with getting paid, be sure to check out Zervant’s online invoicing software. It’s free to use, and you can create an unlimited amount of invoices.

Try Free Invoicing Software

Free Depreciation Calculator

depreciation calculator excel download for free

Getting Started

We’ve included a few instructions here to help you get started with the tool, and the download link is included below. In fact, this article is the perfect side-kick to our other article on what depreciation is and why it matters. So be sure to read that too.

The tool has two tabs, one for the straight-line, and one for reducing balance method. For straight-line depreciation you’ll first need to fill in the “Fixed Asset Information” box in the top left (just under the Zervant logo). This includes:

  • The value of the asset when it was purchased.
  • Its’ expected lifetime (in your business).
  • And an estimated residual value.

Warning! Be sure not to enter anything in the grey box. This contains a formula that will calculate the asset’s annual depreciation, based on the information you provide.

The tool will then automatically fill out the “Straight-line Depreciation Table” for you. It will provide information for the number of years you have stated as the “expected lifetime” of the asset eg. if you’ve written 5 years the tool will provide 5 rows of data. It can calculate up to a maximum of 20 years.

If you need a figure for reducing balance depreciation, switch to the appropriate tab at the bottom. Then follow exactly the same procedure as above – fill in all the fields in the “Fixed Asset Information” box in the top left. (There is no grey box in this formula, as annual depreciation is not a constant figure when using the reducing balance method.) The tool will calculate everything else for you.

What’s even easier than a free invoice template?

Zervant, of course! Create an account and you’ll get free, unlimited invoicing. No catches, fees or hidden costs.

Create Free Account
invoice software