FGN Savings Bond Coupon Payments Tracker Template

Please read this page from start to finish before you make a purchase. Click "More details" below to see it all.

This is the customisable spreadsheet for keeping track of all the FGN Savings Bond investments you made for any consecutive months (maximum of 12 months). You must not invest in every month of that year to use this spreadsheet. Once you invest in FGN Savings Bond for more than 3 months, keeping track of all these dates and numbers becomes more challenging. This spreadsheet is a great tool that will do all the work for you.

Please note that this spreadsheet is for experienced FGN Savings Bond investors (including my Bootcamp participants) who have learnt know how to find the information they need such as coupon payment dates, interest rates offered for each month etc to keep track of their coupon payments.

If you purchase the spreadsheet on this page, you will be able to:

1. Track all your coupon payments for your past and future FGN Savings Bond investments.
2. Enter the dates for those coupon payments.
3. Enter the amounts you invested each month to see how much you will receive as coupon payments.
4. See the cumulative earnings for each month if you invested in more than 3 months during the year.
5. Coupon payments till maturity: 2 years for 2-yr bond and 3 years for 3-yr bond.

Before you purchase:

1. Ensure you have Microsoft Excel installed on your computer.
2. Intermediate knowledge of MS Excel is important.