Ibonds and more

Site link: Excel Workbooks Available for Download

Forum discussion: Re: Ibond calculator

… an Excel spreadsheet that uses a macro to compute the values of each I Bond in a portfolio. It differs from the Savings Bond Calculator and Savings Bond Wizard in a couple of ways:

  • Computes the values for twelve months at a time instead of only one.
  • Works with any denomination; not just the ones that paper bonds were issued in.

Here is a sample screen shot:
Image
The values agree with one row from my web pages that show the entire history of an I Bond. For example, the 12 values for the first bond listed above correspond to the year 2012 in $25 I Bond with 3.40% Fixed Rate Purchased September 1998.

Click the following link to open or download the Excel file: IBondPortfolioCalculator.XLS

Edit 8/10/12: … a couple of enhancements:

  • Added an option to compute the Gain instead of the Value
About

Barry Barnitz, administrator of both the Bogleheads® wiki and of Financial Page, a Bogleheads® blog. In addition I serve as an administrator of finiki, the Canadian financial wiki, and as an administrator of the John C. Bogle Center for Financial Literacy site.

Posted in
Archives
Categories
Follow Financial Page on WordPress.com
%d bloggers like this: