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.
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
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2013
(102)
-
▼
April
(46)
- Work Activity Tracker VBA
- Blake Wise - SEO Report
- Sheet merger for student database
- VBA Danny Stakland
- Sean Swenson Natural Gas Workbook Executive Sum...
- Sales Report Generator
- EVE Profitability Tools
- Storage Economic Data Parser
- CapSim Market Share Analysis
- Entering Transaction Data and Generating a Report ...
- Download and Use Updated Actuarial Tables
- Fantasy Football Analysis
- Graphs for Evidence Exhibits in Court
- Automatically Create a Grocery List
- MACRS Asset Database and Analysis
- Testing the CAPM
- S & J Investments
- Finding the Cheapest Flights
- BYU mymap Schedule helper
- Project Analysis for Current Employer
- Novarad SOW Document Creator
- Database Table Editor for Excel
- Library Space Survey
- Business Intelligence Data Getter
- Using Excel as A Front End For R and SQL
- Management Business Process Application
- Binomial Option Pricing Model for Employee Stock O...
- OPI Sign up Utility
- BYU Treasury Services
- Options Trading
- Learning Suite Schedule Importer
- Database Growth Tracker
- Batch Email/Text Sender with Data Import
- Fantasy Basketball League Analysis
- Searching for MMA Fighters
- Title Of Liberty Press CRM
- Tax Ninja!
- Local Eats
- Automated Class Scheduler
- simplifying record keeping for the Utah County Hea...
- TwitterDeck the Social Media Analysis Spreadshee...
- Book Prices
- Elections Office Task Sheets
- Financial Mathematics Problem Generator
- Interview Simulator
- Weekly Marketing Report
-
▼
April
(46)
No comments:
Post a Comment