To allow banks to estimate interest on a prior period adjustment, the FDIC is making available a spreadsheet (“Interest Estimator”) on which a bank may enter its originally reported and amended information. The Interest Estimator contains interest rate information going back three years and will estimate the interest that will apply based on information that a bank enters.
Download the Interest Estimator - Excel (Excel Help) updated as of June 12, 2024.
Disclaimer: The Interest Estimator does not purport to predict actual interest amounts for underpayments or overpayments and should not be so construed. The purpose of this workbook is to allow an institution to estimate the interest amount on an overpayment or underpayment.
Interest Rates (Expressed as a percentage) | |||
---|---|---|---|
Days Covered | |||
Quarter / Year | The Day After | Through | Interest Rate |
Second Quarter 2024 | September 30, 2024 | December 30, 2024 | 4.50% |
First Quarter 2024 | June 28, 2024 | September 30, 2024 | 5.24% |
Fourth Quarter 2023 | March 29, 2024 | June 28, 2024 | 5.23% |
Third Quarter 2023 | December 29, 2023 | March 29, 2024 | 5.26% |
Second Quarter 2023 | September 29, 2023 | December 29, 2023 | 5.33% |
First Quarter 2023 | June 30, 2023 | September 29, 2023 | 5.18% |
Fourth Quarter 2022 | March 30, 2023 | June 30, 2023 | 4.68% |
Third Quarter 2022 | December 30, 2022 | March 30, 2023 | 4.35% |
Second Quarter 2022 | September 30, 2022 | December 30, 2022 | 3.27% |
First Quarter 2022 | June 30, 2022 | September 30, 2022 | 1.75% |
Fourth Quarter 2021 | March 30, 2022 | June 30, 2022 | 0.61% |
Third Quarter 2021 | December 30, 2021 | March 30, 2022 | 0.09% |
Second Quarter 2021 | September 30, 2021 | December 30, 2021 | 0.04% |
First Quarter 2021 | June 30, 2021 | September 30, 2021 | 0.05% |
Fourth Quarter 2020 | March 30, 2021 | June 30, 2021 | 0.02% |
Third Quarter 2020 | December 30, 2020 | March 30, 2021 | 0.10% |
Second Quarter 2020 | September 30, 2020 | December 30, 2020 | 0.10% |
First Quarter 2020 | June 30, 2020 | September 30, 2020 | 0.15% |
Fourth Quarter 2019 | March 29, 2020 | June 30, 2020 | 0.09% |
Third Quarter 2019 | December 30, 2019 | March 30, 2020 | 1.55% |
Second Quarter 2019 | September 30, 2019 | December 30, 2019 | 1.88% |
First Quarter 2019 | June 28, 2019 | September 30, 2019 | 2.13% |
Fourth Quarter 2018 | March 29, 2019 | June 28, 2019 | 2.47% |
Third Quarter 2018 | December 28, 2018 | March 30, 2019 | 2.52% |
Second Quarter 2018 | September 28, 2018 | December 28, 2018 | 2.22% |
First Quarter 2018 | June 29, 2018 | September 28, 2018 | 1.94% |
Fourth Quarter 2017 | March 30, 2018 | June 29, 2018 | 1.79% |
Third Quarter 2017 | December 29, 2017 | March 30, 2018 | 1.47% |
Second Quarter 2017 | September 29, 2017 | December 29, 2017 | 1.07% |
First Quarter 2017 | June 30, 2017 | September 29, 2017 | 1.02% |
Fourth Quarter 2016 | March 30, 2017 | June 30, 2017 | 0.79% |
Third Quarter 2016 | December 30, 2016 | March 30, 2017 | 0.56% |
Second Quarter 2016 | September 30, 2016 | December 30, 2016 | 0.25% |
First Quarter 2016 | June 30, 2016 | September 30, 2016 | 0.26% |
Fourth Quarter 2015 | March 30, 2016 | June 30, 2016 | 0.30% |
Third Quarter 2015 | December 30, 2015 | March 30, 2016 | 0.27% |
Second Quarter 2015 | September 30, 2015 | December 30, 2015 | 0.02% |
First Quarter 2015 | June 30, 2015 | September 30, 2015 | 0.02% |
Fourth Quarter 2014 | March 30, 2015 | June 30, 2015 | 0.04% |
Third Quarter 2014 | December 30, 2014 | March 30, 2015 | 0.04% |
Second Quarter 2014 | September 30, 2014 | December 30, 2014 | 0.02% |
First Quarter 2014 | June 30, 2014 | September 30, 2014 | 0.04% |
Fourth Quarter 2013 | March 28, 2014 | June 30, 2014 | 0.05% |
Third Quarter 2013 | December 30, 2013 | March 28, 2014 | 0.07% |