Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Authentication
digital resources
204x Filetype XLSX File size 0.04 MB Source: www.fdic.gov
Sheet 1: User Information
| Interest Estimator | |||||||||
| User Information | |||||||||
| This Interest Estimator allows a financial institution to estimate the amount of interest that the FDIC will pay due to an overpayment to the FDIC and the amount the FDIC will charge due to an underpayment to the FDIC for its deposit insurance. | |||||||||
| Helpful Information | |||||||||
| In order to estimate the overpayment or underpayment amount, it is useful to download the invoice for the call report date that you are amending. You may download the invoice via FDICconnect. Enter the original values from the invoice and then enter the amended values on the interest estimation sheet. The Interest Estimator will estimate the overpayment or underpayment as well as the interest due on the amount. | |||||||||
| Questions/Comments/Problems? | |||||||||
| Instructions | ||||||||
| To use this estimator, complete the yellow cells: Enter your bank name and certificate number. Select the call report date that you are amending. Enter the original values from lines 1, 2, and 3 of your invoice. Enter the original FDIC quarterly multiplier from line 5. Next, enter the amended values and press enter. Scroll down to see the estimated interest amount. | ||||||||
| Bank Name: | Certificate Number: | |||||||
| Call Report Date: | 3/31/2022 | Assessment Period: | FR-1 | |||||
| Original Values | Amended Values | Adjustment | ||||||
| Average Consolidated Assets (Invoice Line 1) | 0 | 0 | ||||||
| Average Tangible Equity (Invoice Line 2) | 0 | 0 | ||||||
| Total Allowable Deductions (Invoice Line 3) | 0 | 0 | ||||||
| Assessment Base (Line 1 - Line 2 - Line 3) | $0 | $0 | 0 | No change in assessment base | ||||
| FDIC Rate | - | - | 0.0000000 | No change in rates | ||||
| Over or Under | ||||||||
| Total PPP and MMLF Assets Reported on Page 2 of Invoice (RC-M - 17b + RC-M - 18b) | Payment Amount | |||||||
| 0.00 | 0.00 | |||||||
| PPP and MMLF Offset Amount (Invoice Line 7) | $0.00 | $0.00 | $0.00 | No change in Offset | ||||
| FDIC Assessment (FDIC Rate x Assessment Base) | $0.00 | $0.00 | $0.00 | No Change in Assessment | ||||
| ASSESSMENT INTEREST CALCULATION | ||||||||
| Assessment | ||||||||
| Assessment | Call Report | Interest | Over or (Under) | Quarterly | Interest Rate | Number of Days | ||
| Period | Date | Amount | Interest Period¹ | Payment Amount | Interest Rate | Divisor (days) | in Interest Period | |
| Begins the day after: | And ends: | |||||||
| FK-2 | 12/31/2018 | 0.00 | 03/29/19 | 06/28/19 | 0.00 | 2.47% | 365 | 91 |
| FL-1 | 3/31/2019 | 0.00 | 06/28/19 | 09/30/19 | 0.00 | 2.13% | 365 | 94 |
| FL-2 | 6/30/2019 | 0.00 | 09/30/19 | 12/30/19 | 0.00 | 1.88% | 365 | 91 |
| FM-1 | 9/30/2019 | 0.00 | 12/30/19 | 03/30/20 | 0.00 | 1.55% | 366 | 91 |
| FM-2 | 12/31/2019 | 0.00 | 03/30/20 | 06/30/20 | 0.00 | 0.09% | 366 | 92 |
| FN-1 | 3/31/2020 | 0.00 | 06/30/20 | 09/30/20 | 0.00 | 0.15% | 366 | 92 |
| FN-2 | 6/30/2020 | 0.00 | 09/30/20 | 12/30/20 | 0.00 | 0.10% | 366 | 91 |
| FO-1 | 9/30/2020 | 0.00 | 12/30/20 | 03/30/21 | 0.00 | 0.10% | 365 | 90 |
| FO-2 | 12/31/2020 | 0.00 | 03/30/21 | 06/30/21 | 0.00 | 0.02% | 365 | 92 |
| FP-1 | 3/31/2021 | 0.00 | 06/30/21 | 09/30/21 | 0.00 | 0.05% | 365 | 92 |
| FP-2 | 6/30/2021 | 0.00 | 09/30/21 | 12/30/21 | 0.00 | 0.04% | 365 | 91 |
| FQ-1 | 9/30/2021 | 0.00 | 12/30/21 | 03/30/22 | 0.00 | 0.09% | 365 | 90 |
| FQ-2 | 12/31/2021 | 0.00 | 03/30/22 | 06/30/22 | 0.00 | 0.61% | 365 | 92 |
| FR-1 | 3/31/2022 | 0.00 | 06/30/22 | 09/30/22 | 0.00 | 1.75% | 365 | 92 |
| FDIC Interest | $0.00 | FDIC Adjustment | $0.00 | |||||
| Combined Adjustment and Interest: | ||||||||
| FDIC Adjustment | $0.00 | FDIC Interest | $0.00 | |||||
| Total: | $0.00 | |||||||
| ¹ Interest Period begins with the day after ACH settlement and continues through (and including) the next ACH settlement date. | ||||||||
| Glossary of Data Elements | |
| Variable | Description |
| Average Consolidated Assets | From the Call Report, schedule RC-O Line 4/Quarterly Certified Statement Invoice Line 1 |
| Average Tangible Equity | From the Call Report, schedule RC-O Line 5/Quarterly Certified Statement Invoice Line 2 |
| Total Allowable Deductions | Allowable Banker's Bank deduction plus allowable Custodial Bank deduction/Quarterly Certified Statement Invoice Line 3 |
| FDIC Rate | The bank's FDIC rate converted from basis points to a quarterly multiplier. |
| Assessment Period | The alphanumeric assessment period designation associated with a specific Call Report date. The assessment period is found on the invoice. |
| Call Report Date | The Call Report date of the financial data that is being amended. |
| Interest Amount | The estimated amount of interest for the adjustment amount and specific quarter. The interest amount is estimated by multiplying the adjsutment amount times the interest rate, dividing by the number of days in the year and then multiplying by the number of days in the quarter. This column is summed to result in an estimate of the total amount of interest due for the adjustment amount. |
| Days Covered | Interest on over and under payments for deposit insurance is estimated beginning the day after the payment date for the quarter in which the amount was originally due through the payment date for the assessment payment in which the underpayment or overpayment is discharged. |
| Over or Under Payment Amount | The estimated over or underpayment subject to interest. |
| Quarterly Interest Rate | The interest rate charged for the quarter. |
| Interest Rate Divisor | The number of days in the year. |
| Number of Days | The number of days in the quarter. |
| PPP and MMLF Offset Amount: | Deduction to assessment payment to account for PPP and MMLF loans held by bank. |
| Questions/Comments/Problems? | |
no reviews yet
Please Login to review.
