This model has two main parts. Part 1 allows you to display up to 30 years worth of depreciation happening with up to 95 different fixed assets at once. The monthly and annual display will show the depreciation and book value over time.
You inputs will be the useful life, salvage value, purchase price, and date of purchase.
The second part of this model is a comparative tool that spans 15 years and will show you the difference in annual and monthly depreciation when using double-declining balance vs. straight line. This is designed for just a single asset and there are two visuals that come along with this.