How Do You Construct Yield Curves In Excel 2007?
Microsoft Excel 2007 is an excellent program for constructing charts of yield curves. The process is not particularly straightforward, but once learned it may be repeated whenever data requires it. A yield curve requires appropriate data to be properly constructed. Usually the yield data is derived from financial instruments, such as the United States Treasury Bonds. In fact, the U.S. Treasury yield curve is a good example of how these charts are built in Excel 2007. The U.S. Treasury yield curve is a significant variable in the investing industry and is watched around the world. Identify yield data for the construction of the yield curve. This data requires clear yield information associated with time factors. Yahoo! Finance provides yield data as part of its free service for sharing bond information. Open Excel 2007. Create a new blank worksheet. Press the “New” button at the top of the program window, or choose the “File” menu and the “New” option. Type or import the yield informati
