The Pages
Contents
- One Year’s Interest and OID for All TIPS (example)
- Click a year on the right side of the top table.
- One Year’s IRs for One TIPS (example)
- Click Mature of desired TIPS in the bottom table.
- One Year’s Interest and OID for One TIPS Bought or Sold in After Market (example)
- Click Mature of desired TIPS in the bottom table. Then click [After Market] button at top of Index Ratio page.
- Half Month IRs for All TIPS (example)
- Click a month in the top table.
- List of All TIPS (example)
- Click the top button in the Hamilton portrait.
- List of All TIPS Auctions (example)
- Click the top button in Hamilton portrait. Then click [Separate Auctions] at top of TIPS List page.
- One TIPS History (example)
- Click Coupon of the desired TIPS in the bottom table.
- Table of CPI-U (example)
- Click the second button in the Hamilton portrait.
- One Year’s Ref CPI (example)
- Click a year on the left side of the top table.
One Year’s Interest and OID for All TIPS
This page shows the interest per $1,000 for all TIPS active during the year in each month it was paid, and in total for the year. It also shows the OID per $1,000 for the entire year, or the portion of the year the bond was outstanding. For the current year interest and OID are shown through the latest Ref CPI date. Only the initial auction of each TIPS is shown. If you need to the see the first year's OID for a purchase made at a later auction, view the bond's History page, and click on the date for the desired auction. You can display one of these pages by clicking the right year link in the top table on the home page. There are links at the top of the page for the previous year and the next year. Clicking a coupon on the left displays the History page for that TIPS. Clicking on the month caption displays a page showing IRs for all TIPS for the first half of that month. top
One Year’s IRs for One TIPS
This page shows the IRs for one TIPS for every day during one year – or the portion of the year from its dated date through its maturity date. For the current year it runs up through the latest Ref CPI date. It also shows the IR on Jan 1 of the succeeding year – which can be useful since Jan 1 is the date used for calculating OID. You can display one of these pages by clicking the Mature date link in the bottom table on the Home page. There are links at the top of the page to show the previous year and the next year, and also links to the After Market and History pages mentioned below. (The History page has links to each possible year in its middle section. Going to that page and clicking one of these links may be faster than repeatedly clicking [Prev] or [Next].) Clicking on the month caption displays a page showing IRs for ALL TIPS for the first half of that month. top
Interest & OID on After Market Purchase or Sale
This page shows accrued interest and OID per $1,000 for one TIPS for every day during the year when it might have been bought or sold in the after market (aka secondary market). Unfortunately, I couldn't fit a link to these pages onto the Home Page. You must first click the Mature date link in the bottom table on the Home page. This takes you to the page of Index Ratios for one TIPS for one year mentioned in the previous section. On that page click the [After Market] button. The page shows the accrued interest and OID for purchases or sales that take place on any of the settlement dates shown in the left hand column. For a purchase the accrued interest is subtracted from regular interest for the year. For a sale it is added. OID for a purchase covers the settlement date until the end of the period. For a sale, OID covers the beginning of the period until the settlement date. In both cases the OID shown multiplied by the number of bonds you hold is what should appear on your tax form 1099-OID for the year.
If you buy and sell a TIPS within the same year, subtract the OID on your purchase date from the OID on your sale date using the far right column for both dates. There are links at the top of the page for the previous year and the next year, and also to the History page and One Year Index Ratios page. The month links at the top of the page jump to the month so you don't have to scroll down. Since settlement never occurs on Saturdays or Sundays, they are omitted. If you need to see an Index Ratio for one of these days, click the [Index Ratios] button at the top of the page. top
Half Month IRs for All TIPS
This page shows the IRs for all TIPS active for the first half of one month. At the top of the page are links to display the previous or next half month. You can display one of these pages by clicking the month link in the top table on the Home page. You can also display one by clicking the month name on a Year page discussed in a previous section. Just above the row listing each day is the Ref CPI for that date. (It's shown in two parts with the decimal point suppressed to keep the page from being too wide.) The IR in each cell is the result of dividing this Ref CPI by the one in the column that shows the Ref CPI on each TIPS' dated date. Clicking the coupon for one of the TIPS displays a page of IRs for that TIPS for the entire year. Clicking "Ref CPI" displays a page of Ref CPI for the entire year. top
List of All TIPS
The TIPS List page shows every TIPS issued with key information such as coupon, dated date, and maturity date. You can display this page by clicking the link on the left side of the Home page. The # in the left column is a sequential identification number I've assigned to each TIPS in the order they were originally issued. Clicking on the original issue date or additional issue dates displays a page with a history of that TIPS – which is explained below. Click [Separate Auctions] at the top of the page to display the list with each auction on a separate row. Click 5, 10, 20, or 30 Year to list only TIPS with that maturity. top
List of All TIPS Auctions
This page shows each TIPS auction on a separate row. You can display this page by clicking [Separate Auctions] at the top of the List of All TIPS page. Click an auction date to view the auction results PDF file in a separate window. Each row shows: Price Before IR, Index Ratio on issue date, and their product: Price After IR. "Real" yield to maturity (YTM) excludes inflation adjustment and is reported by the Treasury at the time of auction. "Actual" YTM includes inflation adjustment and is only shown for TIPS that have matured. For more information about actual YTM see the left sidebar. Click [Combine Auctions] at the top of the page to display only one TIPS per row. Click 5, 10, 20, or 30 Year to list only auctions for TIPS with that maturity. top
One TIPS History
The top section of this page shows the Ref CPI and IR on each issue date, the dated date, and, if the TIPS has matured, on the maturity date. You can display this page by clicking the coupon on the lower home page table or by clicking an issued date in the TIPS List or TIP Auction pages. If the TIPS has more than one issue date, you can click on the desired one to use as the starting point for the OID and Interest sections below. If you purchased a TIPS at auction and haven't sold it before maturity, you can multiply these amounts by your holdings in 1,000's to determine the OID and interest that apply to you. If you didn't purchase the TIPS at auction or if you sold it before maturity, consult the Interest and OID for After Market page for the year you purchased or sold.
The middle section shows the Ref CPI and IR on the selected issue date, on Jan 1 of succeeding years, and, if the TIPS has matured, on the maturity date. OID is calculated by subtracting the IR from the previous IR and multiplying it by 1,000. (Note: Jan 1 is the valuation date used in determining the OID taxable for the preceding year.) For the current year OID is shown through the latest Ref CPI date.
The bottom section shows the Ref CPI, IR, and interest on the issue date and on each subsequent interest payment date. If the issue date didn't fall on the dated date or on one of the semi-annual interest payment dates, accrued interest was payable, in addition to principal, at the time of purchase. The bottom section is expanded for TIPS that have matured. A complete cash flow is shown including the principal paid on the issue date and the principal collected at maturity. In addition, the totals of principal and interest are discounted to their present value based on the actual yield to maturity. (For more information about how the yield to maturity is calculated see the Technical Notes in the sidebar.) The total in the principal column is divided between OID and capital gain or loss. The gain or loss represents the amount that the purchase price differed from par value, adjusted for the IR on the purchase date. top
Table of CPI-U
This page shows the Consumer Price Index - All Urban Consumers (CPI-U), before seasonal adjustment, for each month from January 1971 through the latest month reported. The CPI for any month is used as the Ref CPI for the first of the month 3 months later. For example, the CPI for October 1996 is used as the Ref CPI for the 1st day of January 1997 (the month the first TIPS was issued.) The original uncorrected figures are used for Jan - Aug 2000. See Bureau of Labor Statistics on Links page for more information.
To the right of December is a column showing the purchasing power equivalent in the row year of $100 in the latest year. The next column shows the inverse. I.e., the purchasing power equivalent in the latest year of $100 in the row year. Next are columns showing the annual rate of change for 1, 2, 5, 10, and 30 year periods. By default, the two purchasing power of $100 columns and the five annual rate of change columns refer to the latest reported month. But any other month can be selected by clicking its column heading at the top or bottom of the table. The figures for the month selected are displayed in bold.
By default the page shows the monthly reported CPI figures. However, clicking [Show YTD Avg] at the top of the page, will display the year-to-date averages for each month. For example, Feb will be the average of Jan & Feb; Mar will be the average of Jan, Feb, & Mar; etc. Dec will be the average of all twelve months. The two value of $100 columns and the annual change columns on the right side will correspond to the displayed YTD figures. To revert to the normal display, click [Show Month]. top
One Year’s Ref CPI
This page shows the Ref CPI for every day during one year or, for the current year, up through the latest Ref CPI date. It also shows the Ref CPI on Jan 1 of the succeeding year. You can display one of these pages by clicking the left year link in the top table on the Home page. There are links at the top of the page for the previous year and the next year. Clicking on the month caption displays a page showing IRs for all TIPS for the first half of that month. top
Miscellaneous
TIPS Ordering
Pages that list each TIPS can be shown in either maturity date or issue date order by clicking the Matures or Dated column headings. The alternating row background color changes shades to visually indicate which order is being displayed. Some pages with navigation links at the top to the Home, List, or Auctions pages have one button to the page in maturity order and another to the page in issue order.
Printing
Most browsers let you control whether backgrounds, such as the row shading, appears when the page is printed. For example,
Internet Explorer: Tools / Internet Options / Advanced Tab / Printing / Print background colors and images
Safari: Print background check box in the Print dialog (make sure to expand the dialog)
I've designed the TIPS List and TIPS History pages to print on a single page in portrait mode, and the Year and Half-Month pages to print on a single page in landscape mode. You may need to use your browser's Print Setup for proper printing. Unfortunately, because they have a row for every workday during a year, the After Market Interest & OID pages can't be printed on a single page. (I did this to reduce the number individual files comprising the site.)
Importing
You should be able to copy and paste rows from any of the tables into a spreadsheet for further manipulation. Excel – at least my version – does a good job of pasting each table element into the appropriate cell.
Errors and Comments
In a project of this size, errors are to be expected. I suggest checking any index ratios used for critital purposes against those on the Treasury Direct web site. I welcome comments about errors or suggested improvements. Please email me at
tipscruncher@eyebonds.info