Depreciation is a method of allocating costs over the useful economic life of an asset (e.g. a building, a car, a computer). This function returns the depreciation of an asset for a specified period using what is known as the fixed-declining balance method (explained below).
On the final Friday of each month, we set an Excel problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.
On the final Friday of each month, we’re going to set an Excel challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only!