This Excel spreadsheet uses lookup functionality to pull in the proper MACRS Half-year convention rate from a table to use in the depreciation schedule. The lookup that is functionally used is the VLookup as I felt this was the simpler method of accomplishing this functionality, but in column H it has also been demonstrated using the Index function just to drive home the point that there is more than one way to get the job done.
I don’t know if this has a lot of practical application as it will certainly not replace any type of tax depreciation software, but it is a fun exercise to gain additional familiarity with the uses of lookup and index functions. It may be useful to do some quick entry of a few items to see what the impact may be on some planning issues or for clients to track some of their purchases throughout the year. This spreadsheet will also function rather well within Google documents for those that do work in the cloud.