by CI Staff
Investment Risk Analyzer runs directly in Microsoft Excel. As the name implies, the program allows you to evaluate your investments and see how your portfolio is allocated among stocks, bonds and Treasury securities. The program will generate your expected return and risk using the data you input.
Investment Risk Analyzer opens directly in Microsoft Excel. Excel macros must be enabled for the program to work properly. In newer versions of Excel, you can enable macros by clicking on “options” at the top after opening a file that requires macros.
Cells that are color-coded in blue require user inputs. Any other cell values are generated automatically. Under Investment Information, enter your investment balances and annual investment amounts. There are categories for bond and Treasury, mixed, and stock. The program is designed so that stocks tend to move in the same direction in any given year, and the mixed category is programmed to be the average of stock and bond funds.
Under Historical Performance Data, enter the average return and average standard deviation of each investment. Both of these averages should be calculated over at least a 10-year period. The values may be hard to obtain, so a worksheet is available to help you calculate an approximation. The worksheet allows users to enter up to 30 years of share prices. The percentage gains and losses, as well as the standard deviation, will be calculated.
After entering all the required information, you may evaluate your portfolio. Varying the amount of money in each investment will allow you to observe the amount of change that could occur within your overall portfolio. The program will display a “Min Year” (how much you can expect to lose during a very bad year) and a “Max Year” (how much you can expect to gain during a very good year) for each investment. Over the long run, stocks with higher returns and standard deviations should generate more return than bonds with lower returns and standard deviations. However, bonds have lower min years, making them safer. For investors with a short time horizon, it may be more beneficial to invest in holdings with a lower standard deviation. You are able to constantly recalculate to see the effects on your portfolio during a down year.
Investment Risk Analyzer is currently available free of charge.
Investment Risk Analyzer
System Requirements: Windows 98 or newer; Microsoft Excel