Please do on excelPlease fix on number 4,7,8,9,10
Thanks
Sheet1 Q1) We have chosen Liberty bank in the city of Middletown, Connecticut for the repricing gap analysis FDIC certificate number for the bank is 17943 Q2)Repricing Time BucketsMaturities£3m>3m-1y>1y-3y>3y-5y>5y-15y>15y Securities3928114853420105241560500 MBS pass-throughs7818250206607177392652519361 AssetOther MBS632186321863218440359440359440359 Loans 1-4 family3150714323427931717757928370237168 Other loans944796257073709628604936398433368 Brokered deposits £250k000000 LiabilitiesBrokered deposits >250k000000 Time deposits £250k145354433181259786194331943319433 Time deposits >250k2666729714152262137413741374 Q3)MaturitiesAmount in $Run off % estimated MMDA80258032.5260838.5 Other Saving deposits171951932.5558843.675 Total 819682.175 Q4)Repricing time bucket£3m>3m-1y>1y-3y>3y-5y>5y-15y>15yRepricing time bucket£3m>3m-1y>1y-3y>3y-5y>5y-15y>15y Rate Sensitive assests006321880130675022057397Rate sensitive liablities412026916823.175312048208072080720807 Q5)Repricing time bucket£3m>3m-1y>1y-3y>3y-5y>5y-15y>15y Repricing gap-412026-916823.175-24883078049972941336590 Q6)Liberty bank has reinvestment risk over 3 months through 3 years period due to negative repricing gap. This risk occurs to the bank when it holds assest with maturities less than it liabilities The bank has refinancing risk over 3 year peiods , because it has positive repricing gap. Indicating that the bank holds asset with maturity is greater than the liabilities Q7)Repricing time bucket1yr3yr>3yr Cummulative gap-1328849.175-1577679.1751546502 Q8)Liberty bank has cumulative reinvestment risk over 1 year through 3 years period due to negative cumulative repricing gap. The bank has refinancing risk over 3 year peiods , because it has positive cumulative repricing gap. Q9)a)∆R=-0.25% Repricing time bucket>3m-1y>1y-3y>3y-5y>5y-15y>15y ∆NII=Repricing gap*∆R2292.0579375622.075-1951.2475-1823.5325-91.475 b)∆R=0.5% Repricing time bucket>3m-1y>1y-3y>3y-5y>5y-15y>15y ∆NII=Repricing gap*∆R-4584-1244.23902.4953647.065182.95 ∆R=1.25% Q10)Repricing time bucket>1y-3y>3y-5y>5y-15y>15y ∆NII=Repricing gap*∆R-3110.3759756.23759117.6625457.375 Q11)Repricing time bucket>1y-3y>3y-5y>5y-15y>15y RSA @ increase by 150 basis points948.2712019.5911253.3860.955 RSL @ increase by 100 basis points3120.48208.07208.07208.07 Repricing gap-2172.2111811.5211045.23652.885 Change in interest rate has a effect of low NII for the period over 1 year through 3 years, due to a negative spread effect. A negative spread effect will influence the spread of a interest income earned on RSA less than interest on the cost of RSL lead to a fall and result in low NII Change in interset rate has a effect of High NII for the period over 3 years , due to a positive spread effect. A Positive spread effect will influence the spread of a interest income earned on RSA greater than interest on the cost of RSL lead to a increase and result in high NII 12) a)For the period over 3 months to 1 year, the bank faces its largest decrase on NII when the interest rate increases . For these periods, the maturity of liabilities is greater than the maturity of assets, impacting the NII to be negative with a rise in interest rate. This can be minimized by investing on assets, which are maturing at short duration. b)i)Change in the investment of assets will lead to increases in the liberty bank's interest income. ii)Change in the investment of assets will lead to a decrease in the liberty bank's interest expense. iii)Net effect on the change in bank's interest income will be positive, since RSA>RSL Sheet2 12. Sheet3 Consolidated Reports of Condition and Income Board of Governors of the Federal Reserve System Federal Deposit Insurance Corporation Office of the Comptroller of the Currency Federal Financial Institutions Examination Council Consolidated Reports of Condition and Income for A Bank With Domestic Offices Only - FFIEC 041 Institution Name LIBERTY BANK City MIDDLETOWN State CT Zip Code 06457 Call Report Report Date 6/30/2019 Report Type 041 RSSD-ID 587800 FDIC Certificate Number 17943 OCC Charter Number 0 ABA Routing Number 211170282 Last updated on 7/30/2019 Federal Financial Institutions Examination Council Signature Page Consolidated Reports of Condition and Income for A Bank With Domestic Offices Only - FFIEC 041 Report at the close of business June 30, 2019 This report is required by law: 12 U.S.C. §324 (State member banks); 12 U.S.C. §1817 (State non member banks); 12 U.S.C. §161 (National banks); and 12 U.S.C. §1464 (Savings associations). (20190630) (RCON 9999) Unless the context indicates otherwise, the term “bank” in this report form refers to both banks and savings associations. This report form is to be filed by banks with branches and consolidated subsidiaries in U.S. territories and possessions, Edge or Agreement subsidiaries, foreign branches, consolidated foreign subsidiaries, or International Banking Facilities. NOTE: Each bank’s board of directors and senior management are responsible for establishing and maintaining an effective system of internal control, including controls over the Reports of Condition and Income. The Reports of Condition and Income are to be prepared in accordance with federal regulatory authority instructions.The Reports of Condition and Income must be signed by the Chief Financial Officer (CFO) of the reporting bank (or by the individual performing an equivalent function) and attested to by not less than two directors (trustees) for state non member banks and three directors for state member banks, national banks, and savings associations. I, the undersigned CFO (or equivalent) of the named bank, attest that the Reports of Condition and Income (including the supporting schedules) for this report date have been prepared in conformance with the instructions issued by the appropriate Federal regulatory authority and are true and correct to the best of my knowledge and belief. We, the undersigned directors (trustees), attest to the correctness of the Reports of Condition and Income (including the supporting schedules) for this report date and declare that the Reports of Condition and Income have been examined by us and to the best of our knowledge and belief have been prepared in conformance with the instructions issued by the appropriate Federal regulatory authority and are true and correct. Signature of Chief Financial Officer (or Equivalent) Date of Signature Director (Trustee) Director (Trustee) Director (Trustee) Submission of Reports Each bank must file its Reports of Condition and Income (Call Report) data by either: (a) Using computer software to prepare its Call Report and then submitting the report data directly to the FFIEC’s Central Data Repository (CDR), an Internet-based system for datacollection (https://cdr.ffiec.gov/cdr/), or (b) Completing its Call Report in paper form and arranging with a software vendor or another party to convert the data in to the electronic format that can be processed by the CDR. The software vendor or other party then must electronically submit the bank’s data file to the CDR. For technical assistance with submissions to the CDR, please contact the CDR Help Desk by telephone at (888) CDR-3111, by fax at (703) 774-3946, or by e-mail at
[email protected]. FDIC Certificate Number 17943 (RSSD 9050) To fulfill the signature and attestation requirement for the Reports of Condition and Income for this report date, attach your bank’s completed signature page (or a photocopy or a computer generated version of this page) to the hard-copy record of the data file submitted to the CDR that your bank must place in its files. The appearance of your bank’s hard-copy record of the submitted data file need not match exactly the appearance of the FFIEC’s sample report forms, but should show at least the caption of each Call Report item and the reported amount. LIBERTY BANK Legal Title of Bank (RSSD 9017) MIDDLETOWN City (RSSD 9130) CT 06457 State Abbreviation (RSSD 9200) Zip Code (RSSD 9220) The estimated average burden associated with this information collection is 50.4 hours per respondent and is estimated to vary from 20 to 775 hours per response, depending on individual circumstances. Burden estimates include the time for reviewing instructions, gathering and maintaining data in the required form, and completing the information collection, but exclude the time for compiling and maintaining business records in the normal course of a respondent’s activities. A Federal agency may not conduct or sponsor, and an organization (or a person) is not required to respond to a collection of information, unless it displays a currently valid OMB control number. Comments concerning the accuracy of this burden estimate and suggestions for reducing this burden should be directed to the Office of Information and Regulatory Affairs, Office of Management and Budget, Washington, DC 20503, and to one of the following: Secretary, Board of Governors of the Federal Reserve System, 20th and C Streets, NW, Washington, DC 20551; Legislative and Regulatory Analysis Division, Office of the Comptroller of the Currency, Washington, DC 20219; Assistant Executive Secretary, Federal Deposit Insurance Corporation, Washington, DC 20429. Consolidated Reports of Condition and Income for A Bank With Domestic Offices Only - FFIEC 041 Table of Contents Signature Page............................................................1 Table of Contents.........................................................2 USA PATRIOT Act Section 314(a) Anti-Money Laundering Contact Information............................3 Schedule RI - Income Statement.................................4 Schedule RI-A - Changes in Bank Equity Capital...................................................................7 Schedule RI-B Part I - Charge-offs and Recoveries on Loans and Leases............................................8 Schedule RI-B Part II - Changes in Allowances for Credit Losses........................................................9 Schedule RI-C Part I - Disaggregated Data on the Allowance for Loan and Lease Losses................10 Schedule RI-C Part II - Disaggregated Data on the Allowances for Credit Losses..............................11 Schedule RI-E - Explanations ...................................11 Schedule RC - Balance Sheet......