Description
Before returning to school for further education, I participated in my employers 401K plan, which offered several dozen different funds to choose from. I often found myself frustrated with the seemingly endless list of funds that I had to choose from. A common measure of overall mutual fund performance is to compare a particular mutual fund’s return with the S&P 500 index. With several thousand mutual funds to choose from, it can be a daunting task to go through each fund individually and determine whether or not the fund is right for you. As an investor, it is important to balance cost, risk and performance when choosing a mutual fund.
System Overview
To help assist me in this decision, I chose to build a model that will pull in mutual fund information based off of the user’s input of mutual fund ticker symbols. Once the data is pulled, the user can then customize his portfolio by selecting the funds that meet his criteria along with a desired investment amount. After the funds are selected, the user can then choose to maximize the portfolio’s return or minimize the portfolio’s risk simply by using the built in user forms.
http://files.gove.net/shares/files/11w/ecrane/VBA_Final_Project_version_1.9.xlsm
http://files.gove.net/shares/files/11w/ecrane/Final_Project_Write-up.pdf
No comments:
Post a Comment