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.

Download the Free Depreciation Calculator

We’ve included a few instructions here to help you get started with the tool, and the download link is inlcuded 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.

Depreciation Calculator in Excel

Download Depreciation Calculator

Getting Started

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.

Fixed Asset Information Table

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.

If you’ve got any questions or comments about the tool please do let us know in the comments box below.

Don’t forget to try our invoicing software!

Sign up for Zervant and you’ll get free, unlimited invoicing. No catches, fees or hidden costs.

Create Free Account
Free invoicing software

Create and send an unlimited number of invoices, for free!

  • For freelancers and small businesses in the UK
  • Trusted by thousands
  • Quick & friendly customer support