This case asks students to assume the role of a tax professional and demonstrate their technology savvy. Students are asked to work with various client tax fixed asset information schedules and IRS MACRS tax depreciation rate tables to calculate tax depreciation and test the accuracy of personal property mid quarter convention determinations and then automate these processes. The case solutions are provided in Excel and Alteryx.

Suitable courses: This case is suitable for a management, AIS, or data analytics course

Link to download files (requires login)