Assignment:
You have been hired by Risky Ventures, Inc., as a consultant to help them analyze interest rate trends. They are initially interested in determining the historical relationship between long- and short-term interest rates. The biggest task you must immediately undertake is collecting market interest-rate data. You know the best source of this information is the web.
1. You decide that your best indicator of long-term interest rates is the 10-year U.S. Treasury note. Your first task is to gather historical data. Go to
https://www.federalreserve.gov/releases/
and select “H.15 Selected Interest Rates Historical data.”
Click on “Historical data.” Scroll down to “U.S. Government securities/Treasury constant maturities/10 year.” Scroll over to the right and click on “annual.”
2. While you have located an accurate source of historical interest-rate data, getting it onto a spreadsheet will be very tedious. You recall that Excel will let you convert text data into columns. Begin by highlighting the two columns of data (the year and rate). Right click on the mouse and choose COPY. Now open Excel and put the cursor in a cell. Click paste. Now choose
DATA from the tool bar and click on TEXT TO COLUMNS. Follow the wizard, checking the fixed –width option. The list of interest rates should now have the year in one column and the interest rate in the next column. Label your columns.
Repeat the above steps to collect the 1-year interest-rate series. Put it in the column next to the 10-year series. Be sure to line up the years correctly and delete any years that are not included in both series.
3. You now want to analyze the interest rates by graphing them. Again highlight the two columns of data you just created in Excel. Click on the charts icon on the tool bar (or INSERT/CHART). Select “scatter diagram” and choose any type of scatter diagram that connects the dots. Let the Excel wizard take you through the steps of completing the graph. (See the accompanying figure.)
4. Now go to
https://www.forecasts.org/data/index.htm
click on “stock indices” at the top of the page, and choose “U.S. Stock indices—monthly option.” Finally, choose the “Dow Jones Industrial Average” option and again repeat the instructions outlined in steps 2 and 3.