These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 17, 2013

MACRS Asset Database and Analysis

Executive Summary:

Many tax professionals face the challenge of keeping track of asset data, computing depreciation, and generating reports based on the data set. The manual tracking, calculation, and analysis process is mundane and prone to mistakes, especially when a taxpayer such as a corporation owns thousands of business assets. Instead of manually executing the tasks, I created a VBA-based solution where the user simply needs to click the customized ribbon buttons under the MACRS tab, then the spreadsheet will automatically, efficiently, and accurately accept new records, update the database, calculate depreciation for any asset in a particular year, and generate Pivot Tables based on information in the database.

1 comment:

  1. eToro is the best forex broker for rookie and professional traders.


Blog Archive