{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Select Institution Type","RE Calc - Unregulated CDFI","RE Calc - Credit Union","RE Calc - Cooperativa","RE Calc - Bank","UTILITY"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Select Institution Type","index":0,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,3,2,4],[3,3,3,4],[2,0,2,2],[3,0,3,2]]}
["CDFI Program: Financial Assistance Application"]
["Retained Earnings Calculator"]
["Name of Financial Institution: ",null,null,null,null,"<-- Enter the name of your financial institution."]
["Type of Financial Institution: ",null,null,"Please Select Type from List",null,"<-- Select your Financial Institution type to complete the correct Retained Earnings Calculator for your CDFI."]
[null,null,null,null,null,"* Note: You must select an option from the picklist in cell D4 to view the correct calculator for your CDFI."]

{"sheet":"RE Calc - Unregulated CDFI","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":true,"merged":[[18,8,20,9],[22,3,23,4],[36,1,36,3],[15,6,15,7],[30,6,30,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[20,6,20,7],[19,6,19,7],[22,6,24,7],[25,6,25,7],[26,6,27,7],[5,3,5,5],[13,6,13,7],[5,1,5,2],[7,1,7,7],[21,6,21,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[14,6,14,7],[12,6,12,7],[38,5,38,6],[39,5,39,6],[28,6,28,7],[29,6,29,7],[32,6,32,7],[33,6,34,7],[37,5,37,6],[31,6,31,7]]}
[null,"UNITED STATES DEPARTMENT OF THE TREASURY "]
[null,"Community Development Financial Institutions Fund"]
[null,"CDFI Program Financial Assistance Application"]
[null,"Retained Earnings Calculator for Unregulated CDFIs "]
[]
[null,"Organization Name:",null,{"$f":"'Select Institution Type'!D3","v":0}]
[]
[null,"Retained Earnings Calculator: Non-Regulated Entities"]
[null,"Line","Financial Data","Please Select:","Please Select:","Select Most Recent FYE:","Notes/ Documentation:"]
[null,"A","Total Income/Revenue "]
[null,"B","LESS Income from Federal Sources\n(Itemize source and amount in the lines below.  Add additional lines as necessary)",{"$f":"SUM(D12:D16)","v":0},{"$f":"SUM(E12:E16)","v":0},{"$f":"SUM(F12:F16)","v":0}]
[]
[]
[]
[]
[]
[null,"C","LESS Income listed as Matching Funds Used\n(Itemize source and amount in the lines below.  Add additional lines as necessary).",{"$f":"SUM(D18:D20)","v":0},{"$f":"SUM(E18:E20)","v":0},{"$f":"SUM(F18:F20)","v":0}]
[]
[]
[]
[null,"D","LESS Retained Earnings Used in Previous Award Years",{"$f":"D22","v":0},{"$f":"E22","v":0},{"$f":"F22","v":0}]
[null,"D1","FYE Retained Earnings Used"]
[null,"D2","Previous 3 Year Average Retained Earnings Used (Two Year Overlap)"]
[null,"D3","Previous 3 Year Average Retained Earnings Used (OneYear Overlap)"]
[null,"E","Subtotal: Adjusted Operating Income/Revenue",{"$f":"+D10-D11-D17-D21","v":0},{"$f":"+E10-E11-E17-E21","v":0},{"$f":"+F10-F11-F17-F21","v":0}]
[null,"F","Total Expenses"]
[null,"G","LESS Total Expenses Associated with Lines B and C\n(Itemize source and amount in the lines below.  Add additional lines as necessary)",{"$f":"SUM(D29:D33)","v":0},{"$f":"SUM(E29:E33)","v":0},{"$f":"SUM(F29:F33)","v":0}]
[null,null,"Review?",{"$f":"IF(D27>D26+1, \"Review!\", \"Ok!\")","v":"Ok!"},{"$f":"IF(E27>E26+1, \"Review!\", \"Ok!\")","v":"Ok!"},{"$f":"IF(F27>F26+1, \"Review!\", \"Ok!\")","v":"Ok!"}]
[null,null,"Salary and fringe benefits"]
[null,null,"Bad debt/loan loss provision"]
[null,null,"Program services funded through grants"]
[null,null,"Grant expense "]
[null,null,"Other"]
[null,"H","Subtotal: Adjusted Expenses",{"$f":"D26-D27","v":0},{"$f":"E26-E27","v":0},{"$f":"F26-F27","v":0}]
[null,"I","TOTAL RETAINED EARNINGS (E-H)",{"$f":"D25-D34","v":0},{"$f":"E25-E34","v":0},{"$f":"F25-F34","v":0}]
[]
[null,"Any of the Results Below Can Be Used As Match:"]
[null,"J","Retained Earnings Increase from Fiscal Year End(s) within the Matching Funds Window:",null,null,"Three Year Average Retained Earnings Initial Increase",null,{"$f":"IF(AVERAGE(D35:F35)>0,AVERAGE(D35:F35),\"$0\")","v":"$0"}]
[null,"K","Three Year Average Retained Earnings Eligible for MF",{"$f":"H38-H39-H40","v":0},null,"Prior Three Year Average Retained Earnings Used for MF (Two Years of Overlap)",null,{"$f":"F23*(2/3)","v":0}]
[null,"L","Matching Funds Used ",null,null,"Prior Three Year Average Retained Earnings Used for MF (One Year of Overlap)",null,{"$f":"F24*(1/3)","v":0}]
[]
[]
[null,null,null,"* END *"]

{"sheet":"RE Calc - Credit Union","index":2,"n_rows":64,"n_cols":23,"rows_kept":64,"cut":false,"hidden":true,"merged":[[7,1,7,7],[15,15,17,16],[29,1,29,3],[30,5,30,6],[31,5,31,6],[37,4,37,7],[38,4,38,7],[39,4,39,7],[40,4,40,7],[32,5,32,6],[43,1,43,3],[49,1,49,3],[59,1,59,3],[35,1,35,3],[42,1,42,3]]}
[null,"UNITED STATES DEPARTMENT OF THE TREASURY "]
[null,"Community Development Financial Institutions Fund"]
[null,"CDFI Program Financial Assistance Application"]
[null,"Retained Earnings Calculator for Credit Union CDFIs "]
[]
[null,null,"Organization Name:",{"$f":"'Select Institution Type'!D3","v":0}]
[]
[null,"Retained Earnings Calculator: Credit Unions"]
[null,"Line","Call Report and other Financial Data","Please Select:","Please Select:","Please Select:","Select Most Recent FYE:","Notes/ Documentation:"]
[null,"A","Total Net Worth                                                        (from PCA Net Worth Calculation Worksheet, Line 8 in Call Report Form 5300)"]
[null,"B ","LESS: Uninsured Secondary Capital                   (Call Report Form 5300: Line 9. Uninsured Secondary Capital, \"Total Amount\" )"]
[null,null,"Subtotal Modified Retained Earnings (A-B)",{"$f":"D10-D11","v":0},{"$f":"E10-E11","v":0},{"$f":"F10-F11","v":0},{"$f":"G10-G11","v":0}]
[null,null,"Change in Modified Retained Earnings","N/A",{"$f":"E12-D12","v":0},{"$f":"F12-E12","v":0},{"$f":"G12-F12","v":0}]
[null,"C","LESS Income from Federal Sources\nItemize source and amount in the lines below.  ",{"$f":"SUM(D15:D18)","v":0},{"$f":"SUM(E15:E18)","v":0},{"$f":"SUM(F15:F18)","v":0},{"$f":"SUM(G15:G18)","v":0}]
[]
[]
[]
[]
[null,"D","LESS Matching Funds Used (include current and prior years)  \n(Itemize source and amount in the lines below, including retained earnings previously used.)",{"$f":"SUM(D20:D23)","v":0},{"$f":"SUM(E20:E23)","v":0},{"$f":"SUM(F20:F23)","v":0},{"$f":"SUM(G20:G23)","v":0}]
[]
[]
[]
[]
[null,"E","LESS Retained Earnings Used in Previous Award Years (Insert year retained earnings generated)",{"$f":"D25","v":0},{"$f":"E25","v":0},{"$f":"F25","v":0},{"$f":"G25","v":0}]
[null,"E1","FYE Retained Earnings Used"]
[null,"E2","Previous 3 Year Average Retained Earnings Used (Two Year Overlap)"]
[null,"E3","Previous 3 Year Average Retained Earnings Used (OneYear Overlap)"]
[null,"F","Adjusted Retained Earnings","N/A",{"$f":"E13-E14-E19-E24","v":0},{"$f":"F13-F14-F19-F24","v":0},{"$f":"G13-G14-G19-G24","v":0}]
[]
[null,"Any of the Results Below Can Be Used As Match:"]
[null,"G","Retained Earnings Increase from Fiscal Year End(s) within the Matching Funds Window:",null,null,"Three Year Average Retained Earnings Increase",null,{"$f":"IF(AVERAGE(E28:G28)>0,AVERAGE(E28:G28),\"$0\")","v":"$0"}]
[null,"H","Three Year Average Retained Earnings:",{"$f":"H31-H32-H33","v":0},null,"Prior Three Year Average Retained Earnings Used for MF (Two Years of Overlap)",null,{"$f":"G26*(2/3)","v":0}]
[null,"I ","Matching Funds Used",null,null,"Prior Three Year Average Retained Earnings Used for MF (One Year of Overlap)",null,{"$f":"G27*(1/3)","v":0}]
[]
[null,"Applicants using Retained Earnings Since Inception, must complete Test 1 and Test 2 below"]
[null," Test #1"]
[null,"K","Total FA Request Amount (Base-FA + PPC-FA + DF-FA)"]
[null,"L","Total Net Worth                                                        (from PCA Net Worth Calculation Worksheet, Line 8 in Call Report Form 5300)",{"$f":"G10","v":0}]
[null,"M","LESS: Uninsured Secondary Capital                 (Call Report Form 5300: Line 9. Uninsured Secondary Capital, \"Total Amount\" )",{"$f":"G11","v":0}]
[null,"N","Adjusted Retained Earnings",{"$f":"D38-D39","v":0}]
[null,"O","Since Inception Match Available",{"$f":"IF(D40>D37, \"Yes, move forward to Test 2\", \"No, not eligible to use Since Inception option\")","v":"No, not eligible to use Since Inception option"}]
[]
[null,"Test #2"]
[null,"Section I: Shares/Deposits"]
[null,"P","Dec 31, 2019                                                            Call Report Form 5300: Line 19c. Total Shares and Deposits, \"Total Amount\" \n"]
[null,"Q","Dec 31, 2020                                                      Call Report Form 5300: Line 19c. Total Shares and Deposits, \"Total Amount\" "]
[null,"R","Increase over the past year",{"$f":"D46-D45","v":0}]
[null,"S","% of Award",{"$f":"D47/D37","v":{"$error":"#DIV/0!"}}]
[null,"T","Minimum Threshold Met",{"$f":"IF(D48>=0.25, \"Yes, eligible to move to Test 3 - to be completed by the CDFI Fund\", \"No\")","v":{"$error":"#DIV/0!"}}]
[null,"Section II: Loans & Leases"]
[null,"U","Dec 31, 2019                                                               Call Report Form 5300: Loans & Leases",{"$f":"D52-D53","v":0}]
[null,"U1","Dec 31, 2019                                                              Call Report Form 5300: Line 16. Total Loans & Leases, \"Amount\""]
[null,"U2","Dec 31, 2019                                                      Call Report Form 5300: Line 17. Less: Allowance for Loan & Lease Losses, \"Amount\""]
[null,"V","Dec 31, 2020                                                            Call Report Form 5300: Loans & Leases",{"$f":"D55-D56","v":0}]
[null,"V1","Dec 31, 2020                                                              Call Report Form 5300: Line 16. Total Loans & Leases, \"Amount\""]
[null,"V2","Dec 31, 2020                                                               Call Report Form 5300: Line 17. Less: Allowance for Loan & Lease Losses, \"Amount\""]
[null,"W","Increase over the past year",{"$f":"D54-D51","v":0}]
[null,"X","% of Award",{"$f":"D57/D37","v":{"$error":"#DIV/0!"}}]
[null,"Y","Minimum Threshold Met",{"$f":"IF(D58>=0.25, \"Yes, eligible to move to Test 3 - to be completed by the CDFI Fund\", \"No\")","v":{"$error":"#DIV/0!"}}]
[null,"Section III: Increase in Shares/Deposits and Loans & Leases"]
[null,"Z","Minimum Threshold Met",{"$f":"IF(W61>=0.25, \"Yes, eligible to move to Test 3 - to be completed by the CDFI Fund\", \"No, not eligible to use Since Inception option\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D58+D48","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,"* END *"]

{"sheet":"RE Calc - Cooperativa","index":3,"n_rows":64,"n_cols":23,"rows_kept":64,"cut":false,"hidden":true,"merged":[[43,1,43,3],[49,1,49,3],[59,1,59,3],[35,1,35,3],[37,4,37,7],[38,4,38,7],[39,4,39,7],[40,4,40,7],[42,1,42,3],[32,5,32,6],[7,1,7,7],[15,15,17,16],[29,1,29,3],[30,5,30,6],[31,5,31,6]]}
[null,"UNITED STATES DEPARTMENT OF THE TREASURY "]
[null,"Community Development Financial Institutions Fund"]
[null,"CDFI Program Financial Assistance Application"]
[null,"Retained Earnings Calculator for Cooperativa CDFIs"]
[]
[null,null,"Organization Name:",{"$f":"'Select Institution Type'!D3","v":0}]
[]
[null,"Retained Earnings Calculator: Cooperativas"]
[null,"Line","Call Report and other Financial Data","Please Select:","Please Select:","Please Select:","Select Most Recent FYE:","Notes/ Documentation:"]
[null,"A","Total Net Worth                                                        (from Total de Capital Indivisible, AITSA 16530)"]
[null,"B ","LESS: Uninsured Secondary Capital                (from  Obligaciones de Capital, AITSA 30501)"]
[null,null,"Subtotal Modified Retained Earnings (A-B)",{"$f":"D10-D11","v":0},{"$f":"E10-E11","v":0},{"$f":"F10-F11","v":0},{"$f":"G10-G11","v":0}]
[null,null,"Change in Modified Retained Earnings","N/A",{"$f":"E12-D12","v":0},{"$f":"F12-E12","v":0},{"$f":"G12-F12","v":0}]
[null,"C","LESS Income from Federal Sources\nItemize source and amount in the lines below.  ",{"$f":"SUM(D15:D18)","v":0},{"$f":"SUM(E15:E18)","v":0},{"$f":"SUM(F15:F18)","v":0},{"$f":"SUM(G15:G18)","v":0}]
[]
[]
[]
[]
[null,"D","LESS Matching Funds Used (include current and prior years)  \n(Itemize source and amount in the lines below, including retained earnings previously used.)",{"$f":"SUM(D20:D23)","v":0},{"$f":"SUM(E20:E23)","v":0},{"$f":"SUM(F20:F23)","v":0},{"$f":"SUM(G20:G23)","v":0}]
[]
[]
[]
[]
[null,"E","LESS Retained Earnings Used in Previous Award Years (Insert year retained earnings generated)",{"$f":"D25","v":0},{"$f":"E25","v":0},{"$f":"F25","v":0},{"$f":"G25","v":0}]
[null,"E1","FYE Retained Earnings Used"]
[null,"E2","Previous 3 Year Average Retained Earnings Used (Two Year Overlap)"]
[null,"E3","Previous 3 Year Average Retained Earnings Used (OneYear Overlap)"]
[null,"F","Adjusted Retained Earnings","N/A",{"$f":"E13-E14-E19-E24","v":0},{"$f":"F13-F14-F19-F24","v":0},{"$f":"G13-G14-G19-G24","v":0}]
[]
[null,"Any of the Results Below Can Be Used As Match:"]
[null,"G","Retained Earnings Increase from Fiscal Year End(s) within the Matching Funds Window:",null,null,"Three Year Average Retained Earnings Increase",null,{"$f":"IF(AVERAGE(E28:G28)>0,AVERAGE(E28:G28),\"$0\")","v":"$0"}]
[null,"H","Three Year Average Retained Earnings:",{"$f":"H31-H32-H33","v":0},null,"Prior Three Year Average Retained Earnings Used for MF (Two Years of Overlap)",null,{"$f":"G26*(2/3)","v":0}]
[null,"I ","Matching Funds Used",null,null,"Prior Three Year Average Retained Earnings Used for MF (One Year of Overlap)",null,{"$f":"G27*(1/3)","v":0}]
[]
[null,"Applicants using Retained Earnings Since Inception, must complete Test 1 and Test 2 below"]
[null," Test #1"]
[null,"K","Total FA Request Amount (Base-FA + PPC-FA + DF-FA)"]
[null,"L","Total Net Worth                                                        (from Total de Capital Indivisible, AITSA 16530)",{"$f":"G10","v":0}]
[null,"M","LESS: Uninsured Secondary Capital                (from Obligaciones de Capital, AITSA 30501)",{"$f":"G11","v":0}]
[null,"N","Adjusted Retained Earnings",{"$f":"D38-D39","v":0}]
[null,"O","Since Inception Match Available",{"$f":"IF(D40>D37, \"Yes, move forward to Test 2\", \"No, not eligible to use Since Inception option\")","v":"No, not eligible to use Since Inception option"}]
[]
[null,"Test #2"]
[null,"Section I: Shares/Deposits"]
[null,"P","Dec 31, 2019                                                           \nAITSA: Sum of \"Acciones\" and \"Depósitos\" (20500 + 30500)"]
[null,"Q","Dec 31, 2020                                                     \nAITSA: Sum of \"Acciones\" and \"Depósitos\" (20500 + 30500)"]
[null,"R","Increase over the past year",{"$f":"D46-D45","v":0}]
[null,"S","% of Award",{"$f":"D47/D37","v":{"$error":"#DIV/0!"}}]
[null,"T","Minimum Threshold Met",{"$f":"IF(D48>=0.25, \"Yes, eligible to move to Test 3 - to be completed by the CDFI Fund\", \"No\")","v":{"$error":"#DIV/0!"}}]
[null,"Section II: Loans & Leases"]
[null,"U","Dec 31, 2019                                                                \nAITSA: Préstamos ",{"$f":"D52-D53","v":0}]
[null,"U1","Dec 31, 2019                                                              \nAITSA: Préstamos (10500)"]
[null,"U2","Dec 31, 2019                                                       \nAITSA: Provisión de Préstamos Incobrables (11000)"]
[null,"V","Dec 31, 2020                                                            \nAITSA: Préstamos ",{"$f":"D55-D56","v":0}]
[null,"V1","Dec 31, 2020                                                                \nAITSA: Préstamos (10500)"]
[null,"V2","Dec 31, 2020                                                               \nAITSA: Provisión de Préstamos Incobrables (11000)"]
[null,"W","Increase over the past year",{"$f":"D54-D51","v":0}]
[null,"X","% of Award",{"$f":"D57/D37","v":{"$error":"#DIV/0!"}}]
[null,"Y","Minimum Threshold Met",{"$f":"IF(D58>=0.25, \"Yes, eligible to move to Test 3 - to be completed by the CDFI Fund\", \"No\")","v":{"$error":"#DIV/0!"}}]
[null,"Section III: Increase in Shares/Deposits and Loans & Leases"]
[null,"Z","Minimum Threshold Met",{"$f":"IF(W61>=0.25, \"Yes, eligible to move to Test 3 - to be completed by the CDFI Fund\", \"No, not eligible to use Since Inception option\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D58+D48","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,"* END *"]

{"sheet":"RE Calc - Bank","index":4,"n_rows":61,"n_cols":23,"rows_kept":61,"cut":false,"hidden":true,"merged":[[43,1,43,3],[44,1,44,3],[50,1,50,3],[56,1,56,3],[7,1,7,7],[30,1,30,3],[31,5,31,6],[32,5,32,6],[33,5,33,6],[36,1,36,3],[38,4,38,7],[39,4,39,7],[40,4,40,7],[41,4,41,7]]}
[null,"UNITED STATES DEPARTMENT OF THE TREASURY "]
[null,"Community Development Financial Institutions Fund"]
[null,"CDFI Program Financial Assistance Application"]
[null,"Retained Earnings Calculator for Bank & Bank Holding Co. CDFIs "]
[]
[null,null,"Organization Name:",{"$f":"'Select Institution Type'!D3","v":0}]
[]
[null,"Retained Earnings Calculator: Bank & Bank Holding Companies"]
[null,"Line","Call Report Data","Please Select:","Please Select:","Please Select:","Select Most Recent FYE:","Notes/ Documentation:"]
[null,"A","Retained earnings \n(Line 16c from Holding Company report FR Y-9SP; line 20d from FR Y-9LP; Schedule RC, line 26a from Bank Call Report)"]
[null,"B","Accumulated other comprehensive income \n(Line 16d from Holding Company report FR Y-9SP; line 20e from TFR Y-9LP; Schedule RC, line 26b from Bank Call Report)"]
[null,null,"Subtotal Modified Retained Earnings (A+B)",{"$f":"SUM(D10:D11)","v":0},{"$f":"SUM(E10:E11)","v":0},{"$f":"SUM(F10:F11)","v":0},{"$f":"SUM(G10:G11)","v":0}]
[null,null,"Change in Modified Retained Earnings","N/A",{"$f":"E12-D12","v":0},{"$f":"F12-E12","v":0},{"$f":"G12-F12","v":0}]
[null,"C","LESS Income from Federal Sources\n(Itemize source and amount in the lines below.)",{"$f":"SUM(D15:D19)","v":0},{"$f":"SUM(E15:E19)","v":0},{"$f":"SUM(F15:F19)","v":0},{"$f":"SUM(G15:G19)","v":0}]
[]
[]
[]
[]
[]
[null,"D","LESS Matching Funds Used (include current and prior years)  \n(Itemize source and amount in the lines below, including retained earnings previously used.)",{"$f":"SUM(D21:D24)","v":0},{"$f":"SUM(E21:E24)","v":0},{"$f":"SUM(F21:F24)","v":0},{"$f":"SUM(G21:G24)","v":0}]
[]
[]
[]
[]
[null,"E","LESS Retained Earnings Used in Previous Award Years (Insert year retained earnings generated)","N/A",{"$f":"E26","v":0},{"$f":"F26","v":0},{"$f":"G26","v":0}]
[null,"E1","FYE Retained Earnings Used"]
[null,"E2","Previous 3 Year Average Retained Earnings Used (Two Year Overlap)"]
[null,"E3","Previous 3 Year Average Retained Earnings Used (One Year Overlap)"]
[null,"F","Adjusted Retained Earnings","N/A",{"$f":"E13-E14-E20-E25","v":0},{"$f":"F13-F14-F20-F25","v":0},{"$f":"G13-G14-G20-G25","v":0}]
[]
[null,"Any of the Results Below Can Be Used As Match:"]
[null,"G","Retained Earnings Increase from Fiscal Year End(s) within the Matching Funds Window:",null,null,"Three Year Average Retained Earnings Initial Increase",null,{"$f":"IF(AVERAGE(E29:G29)>0,AVERAGE(E29:G29),\"$0\")","v":"$0"}]
[null,"H","Three Year Average Retained Earnings Increase:",{"$f":"H32-H33-H34","v":0},null,"Prior Three Year Average Retained Earnings Used for MF (Two Years of Overlap)",null,{"$f":"G27*(2/3)","v":0}]
[null,"I","Matching Funds Used ",null,null,"Prior Three Year Average Retained Earnings Used for MF (One Year of Overlap)",null,{"$f":"G28*(1/3)","v":0}]
[]
[null,"Applicants using Retained Earnings Since Inception, must complete Test 1 and Test 2 below"]
[null," Test #1"]
[null,"K","Total FA Request Amount (Base-FA + PPC-FA + DF-FA)"]
[null,"L","Retained earnings \n(Line 16c from Holding Company report FR Y-9SP; line 20d from FR Y-9LP; Schedule RC, line 26a from Bank Call Report)  Dec 31, 2019",{"$f":"G10","v":0}]
[null,"M","LESS Accumulated other comprehensive income \n(Line 16d from Holding Company report FR Y-9SP; line 20e from TFR Y-9LP; Schedule RC, line 26b from Bank Call Report)  Dec 31, 2019",{"$f":"G11","v":0}]
[null,"N","Adjusted Retained Earnings",{"$f":"D39-D40","v":0}]
[null,"O","Since Inception Match Available",{"$f":"IF(D41>D38, \"Yes, move forward to Test 2\", \"No, not eligible to use Since Inception option\")","v":"No, not eligible to use Since Inception option"}]
[]
[null,"Test #2"]
[null,"Section I: Deposits"]
[null,"P","Dec 31, 2019 \nCall Report: Schedule RC - Balance Sheet, Line 13a - Deposits: In domestic offices"]
[null,"Q","Dec 31, 2020 \nCall Report: Schedule RC - Balance Sheet, Line 13a - Deposits: In domestic offices"]
[null,"R","Increase over the past year",{"$f":"D47-D46","v":0}]
[null,"S","% of Award",{"$f":"D48/D38","v":{"$error":"#DIV/0!"}}]
[null,"T","Minimum Threshold Met",{"$f":"IF(D49>=0.25, \"Yes, eligible to move to Test 3 - to be completed by the CDFI Fund\", \"No\")","v":{"$error":"#DIV/0!"}}]
[null,"Section II: Loans & Leases"]
[null,"U","Dec 31, 2019 \nCall Report: In Schedule RC - Balance Sheet, Line 4d - Loans and leases held for investment, net of allowance"]
[null,"V","Dec 31, 2020 \nCall Report: In Schedule RC - Balance Sheet, Line 4d - Loans and leases held for investment, net of allowance"]
[null,"W","Increase over the past year",{"$f":"D53-D52","v":0}]
[null,"X","% of Award",{"$f":"D54/D38","v":{"$error":"#DIV/0!"}}]
[null,"Y","Minimum Threshold Met",{"$f":"IF(D55>=0.25, \"Yes, eligible to move to Test 3 - to be completed by the CDFI Fund\", \"No\")","v":{"$error":"#DIV/0!"}}]
[null,"Section III: Increase in Deposits and Loans & Leases"]
[null,"Z","Minimum Threshold Met",{"$f":"IF(W58>=0.25, \"Yes, eligible to move to Test 3 - to be completed by the CDFI Fund\", \"No, not eligible to use Since Inception option\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D49+D55","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,"* END *"]

{"sheet":"UTILITY","index":5,"n_rows":8,"n_cols":18,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Please Select Type from List",null,"Select Most Recent FYE:","Please Select:","Please Select:","Please Select:","Please Select:","Please Select:","Please Select:","Please Select:",null,null,null,null,null,null,"Select Most Recent FYE:","Please Select:"]
["Unregulated CDFI","Please Select:",{"$f":"B3","v":2021},"Yes - Using Retained Earnings","Grant","In-Hand","Yes","Financial Products","I certify that the matching funds source is non-federal or funds no longer have federal character.","I certify that documentation for this source can be provided upon request.",null,null,null,null,null,null,{"$f":"C2","v":2021},{"$f":"Q2","v":2021}]
["Credit Union",2021,{"$f":"C2&\"-Unaudited\"","v":"2021-Unaudited"},"No - Not Using Retained Earnings","In-Kind Contribution","Committed","No","Financial Services","I do not certify and thus acknowledge that this source cannot be used. ","I do not certify and acknowledge that this source cannot be used. ",null,null,null,null,null,null,{"$f":"Q2-1","v":2020},{"$f":"R2-1","v":2020}]
["Cooperativa",{"$f":"B3-1","v":2020},{"$f":"C2-1","v":2020},null,"Loan",null,"N/A - Type is not a Loan","Development Services",null,null,null,null,null,null,null,null,{"$f":"Q3-1","v":2019},{"$f":"R3-1","v":2019}]
["Bank/Bank Holding Company",{"$f":"B4-1","v":2019},{"$f":"C4&\"-Unaudited\"","v":"2020-Unaudited"},null,"Equity Investment",null,null,"Loan Loss Reserves",null,null,null,null,null,null,null,null,2018,2018]
[null,2018,{"$f":"C4-1","v":2019},null,"Secondary Capital",null,null,"Capital Reserves",null,null,null,null,null,null,null,null,2017,2017]
[null,2017,{"$f":"C6-1","v":2018},null,"Credit Union Shares",null,null,null,null,null,null,null,null,null,null,null,2016,2016]
[null,null,{"$f":"C7-1","v":2017},null,"Deposits"]