Multiple sheets each calculating the monthly values for one I Bond. Portfolio sheet summarizes multiple single bond sheets. Uses only formulas; no macros.
Change log:
11/06/2022: Replace Old I Bond Monthly Calculator
11/06/2022: New single bond sheet shows 12 monthly columns
11/06/2022: New Portfolio sheet summarizes multiple single bond sheets
11/06/2022: Does not use macros
04/02/2025: Modify Portfolio sheet to help if choosing to pay tax annually
05/01/2025: Add latest rates
Click following link to download: IBondCalculatorNoMacro.XLSX