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

Thursday, December 8, 2011

The Analysis

Executive Summary

Performing financial analyses require time. If they are desired to be run on multiple companies it can be repetitive. Many financial measurements as well as ratios are already available on financial websites. More complex analyses that are not accessible for free require time to compute for each company. This VBA project automates the process of performing certain analyses.

The program pulls financial data from the web, compute analyses, and formats the excel worksheets so the user can follow the assumptions and calculations made. The program is designed with one company in mind and then computes all of the same analyses for the three most comparable firms. The data is pulled from Yahoo! Finance, while the comparable firms are located on Google’s finance website. The program takes several minutes to run depending on the speed of the user’s internet connection.

The user simply inputs a stock ticker of a company that they want to look at and then waits while the program runs. Over 20 web queries are made to pull in the necessary information while the user waits. Screen updating has been left on so that the user doesn’t think the program stopped working and exits Excel. Key financial figures are pulled into an inputs tab for the company and then the excess web query tabs are deleted. Four analysis tabs are created as the final product; valuation, profitability, solvency, and accruals. The computations on these tabs allow the user to view the formulas and trace the inputs.

-Michael Jensen-

No comments:

Post a Comment

Blog Archive