{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Cover Page","Applicant Information","Estimated Award Calculation","Report of Transactions"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"merged":[[0,0,0,1],[1,0,1,1]]}
["Bank Enterprise Award Program"]
["2010 Application"]
[]
[]
["Table of Contents"]
[null,"Applicant Information "]
[null,"Worksheet 1: Estimated BEA Award Calculation"]
[null,"Worksheet 2: Report of Transactions"]
[]
["Instructions: "]
[null,"Complete the Applicant Information worksheet, Worksheet 1: Estimated Award Calculation, and Worksheet 2: Report of Transactions and attach it to your BEA Signature Page in myCDFIFund.  The Fund requires applicants to provide the name of their organization and other identifying information so that staff can assemble the various components of each application.  "]
[]
[null,"Please save this document with the following naming convention:    Bank Name 2010 BEA Charts"]

{"sheet":"Applicant Information","index":1,"n_rows":74,"n_cols":3,"rows_kept":74,"merged":[[0,0,0,1]]}
["Instructions: Please complete the yellow cells.  Please be sure to answer all questions.  Failure to respond to any of the questions could result in your application being rejected.  The Applicant Organization Name and EIN must match the information provided in the SF 424.",null,"Alaska"]
[]
["Applicant Information"]
["Applicant Organization Name:",null,"Arkansas"]
["Taxpayer/Employer Identification Number (EIN):"]
["FDIC Certificate Number:",null,"Colorado"]
["How many hours did it take you to complete this application?"]
["Applicant’s Total Assets (in thousands) from 12/31/2009 Call Report / TFR.",null,"Iowa"]
["Indicate whether any of the following apply to your institution:",null,"Idaho"]
["Minority Bank.  An institution classified by the FDIC as a Minority Depository Institution as of 12/31/2009.","No","Illinois"]
["Community Bank.  An institution that identifies itself as a community bank.","No","Indiana"]
["Certified CDFI.  An institution certified as a CDFI by the Fund as of 12/31/2009.","Yes","Kentucky"]
["Applicant's Type of Charter:",null,"Louisiana"]
["State in which the Applicant’s headquarters is physically located:",null,"Massachusetts"]
["Indicate which of the following states are within your service area:",null,"Maryland"]
["Alaska","No","Maine"]
["Alabama","No","Marshall Islands"]
["Arkansas","No","Michigan"]
["American Samoa","No","Minnesota"]
["Arizona","No","Missouri"]
["California","No","Northern Mariana Isl."]
["Colorado","No","Mississippi"]
["Connecticut","No","Montana"]
["District of Columbia","No","North Carolina"]
["Delaware","No","North Dakota"]
["Florida","No","Nebraska"]
["Fed. St. of Micronesia","No","New Hampshire"]
["Georgia","No","New Jersey"]
["Guam","No","New Mexico"]
["Hawaii","No","Nevada"]
["Iowa","No","New York"]
["Idaho","No","Ohio"]
["Illinois","No","Oklahoma"]
["Indiana","No","Oregon"]
["Kansas","No","Pennsylvania"]
["Kentucky","No","Puerto Rico"]
["Louisiana","No","Palau"]
["Massachusetts","No","Rhode Island"]
["Maryland","No","South Carolina"]
["Maine","No","South Dakota"]
["Marshall Islands","No","Tennessee"]
["Michigan","No","Texas"]
["Minnesota","No","Utah"]
["Missouri","No","Virginia"]
["Northern Mariana Isl.","No","Virgin Islands"]
["Mississippi","No","Vermont"]
["Montana","No","Washington"]
["North Carolina","No","Wisconsin"]
["North Dakota","No","West Virginia"]
["Nebraska","No","Wyoming"]
["New Hampshire","No"]
["New Jersey","No"]
["New Mexico","No"]
["Nevada","No"]
["New York","No"]
["Ohio","No"]
["Oklahoma","No"]
["Oregon","No"]
["Pennsylvania","No"]
["Puerto Rico","No"]
["Palau","No"]
["Rhode Island","No"]
["South Carolina","No"]
["South Dakota","No"]
["Tennessee","No"]
["Texas","No"]
["Utah","No"]
["Virginia","No"]
["Virgin Islands","No"]
["Vermont","No"]
["Washington","No"]
["Wisconsin","No"]
["West Virginia","No"]
["Wyoming","No"]

{"sheet":"Estimated Award Calculation","index":2,"n_rows":38,"n_cols":8,"rows_kept":38,"merged":[[0,0,0,7],[4,2,4,5],[6,0,6,7],[7,0,8,1],[11,1,11,6],[12,0,12,7],[13,0,14,1],[21,1,21,6],[22,1,22,4],[22,5,22,6],[23,0,23,7],[31,1,31,6],[32,1,32,4],[32,5,32,6],[33,0,33,7],[34,1,34,6],[35,1,35,6],[36,1,36,6],[37,1,37,6]]}
["Instructions:  As stated in the BEA Program regulations and Application materials, increases in CDFI Support Activities are multiplied by 18% for a CDFI applicant, 6% for a non-CDFI applicant.  Increases in Distressed Community Financing Activities and Service Activities are multiplied by 9% for a CDFI applicant, 3% for a non-CDFI applicant. The white cells are locked and can not be accessed. Organization name should pre-populate from the previous worksheet.  Do not change the formatting of this form or it will not upload properly."]
[]
["Worksheet 1: Estimated BEA Award Calculation"]
[]
["Applicant Organization Name:",null,"='Applicant Information'!$B$4"]
[]
["CDFI RELATED ACTIVITIES"]
[null,null,"A","B","C","D","E","F"]
[null,null,"Reporting","Baseline Period          2008","Assessment Period    2009","Change in Activity","Award Percent","Estimated Award Amount"]
[1,"Equity Investments (CEI)/ Equity-Like Loans (ELL)/ Grants (CG)","No",null,null,{"$f":"E10-D10","v":0},{"v":0.15,"d":"15%"},{"$f":"F10*G10","v":0}]
[2,"CDFI Support Activities: Loans (LNS), CDFI Deposits/Shares (DS), Technical Assistance (TAC) ","No",null,null,{"$f":"E11-D11","v":0},{"$f":"+IF('Applicant Information'!$B$12=\"Yes\",0.18,0.06)","v":{"v":0.18,"d":"18%"}},{"$f":"F11*G11","v":0}]
[3,"Estimated Award Amount for CDFI Related Activities:",{"$nulls":5},{"$f":"SUM(H10:H11)","v":0}]
["DISTRESSED COMMUNITY FINANCING ACTIVITIES"]
[null,null,"A","B","C","D","E","F"]
[null,null,"Reporting","Baseline Period          2008","Assessment Period    2009","Change in Activity","Priority Factor","Weighted Value "]
[4,"Affordable Home Mortgage Loans (AHM)","No",null,null,{"$f":"E16-D16","v":0},{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},{"$f":"F16*G16","v":0}]
[5,"Affordable Housing Development Loans and Project Investments (AHD)","No",null,null,0,{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},0]
[6,"Small Business Loans and Project Investments (SBL)","No",null,null,0,{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},0]
[7,"Home Improvement Loans (HIL)","No",null,null,0,{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},0]
[8,"Education Loans (EDU)","No",null,null,0,{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},0]
[9,"Commercial Real Estate Loans and Project Investments (CRE)","No",null,null,0,{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},0]
[10,"Total Score:",{"$nulls":5},{"$f":"SUM(H16:H21)","v":0}]
[11,"Estimated Award Amount for Distressed Community Financing Activities",{"$nulls":3},{"$f":"+IF('Applicant Information'!$B$12=\"Yes\",0.09,0.03)","v":{"v":0.09,"d":"9%"}},{"$f":"+IF('Applicant Information'!$B$12=\"Yes\",0.18,0.06)","v":{"v":0.18,"d":"18%"}},{"$f":"H22*F23","v":0}]
["SERVICE ACTIVITIES"]
[null,null,"A","B","C","D","E","F"]
[null,null,"Reporting","Baseline Period          2008","Assessment Period    2009","Change in Activity","Priority Factor","Weighted Value "]
[12,"Deposits (D)","No",null,null,{"$f":"E27-D27","v":0},{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},{"$f":"F27*G27","v":0}]
[13,"Community Services (CS)","No",null,null,{"$f":"E28-D28","v":0},{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},{"$f":"F28*G28","v":0}]
[14,"Financial Services (FS)","No",null,null,{"$f":"E29-D29","v":0},{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},{"$f":"F29*G29","v":0}]
[15,"Targeted Financial Services (TFS)","No",null,null,{"$f":"E30-D30","v":0},{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},{"$f":"F30*G30","v":0}]
[16,"Targeted Retail Savings/Investment Products (TSP)","No",null,null,{"$f":"E31-D31","v":0},{"$f":"+IF('Applicant Information'!$B$8>=1109000,1,IF('Applicant Information'!$B$8<274000, 5,3))","v":5},{"$f":"F31*G31","v":0}]
[17,"Total Score:",{"$nulls":5},{"$f":"SUM(H27:H31)","v":0}]
[18,"Estimated Award Amount for Service Activities",{"$nulls":3},{"$f":"+IF('Applicant Information'!$B$12=\"Yes\",0.09,0.03)","v":{"v":0.09,"d":"9%"}},{"$f":"+IF('Applicant Information'!$B$12=\"Yes\",0.18,0.06)","v":{"v":0.18,"d":"18%"}},{"$f":"H32*F33","v":0}]
["ESTIMATED AWARD"]
[19,"PRIORITY ONE AWARD (CDFI Related)",{"$nulls":5},{"$f":"H12","v":0}]
[20,"PRIORITY TWO AWARD (Distressed Community Financing)",{"$nulls":5},{"$f":"H23","v":0}]
[21,"PRIORITY THREE AWARD (Service Activities)",{"$nulls":5},{"$f":"H33","v":0}]
[22,"TOTAL ESTIMATED AWARD",{"$nulls":5},{"$f":"SUM(H35:H37)","v":0}]

{"sheet":"Report of Transactions","index":3,"n_rows":8,"n_cols":13,"rows_kept":8,"merged":[[0,0,0,12],[2,0,2,12]]}
["Instructions: Do not change the formatting, add transactions outside the assessment period, or include blank lines as this will prevent the chart from uploading into the review database.  Do not change the formatting under any circumstances."]
[]
["2010 BEA Report of Transactions"]
["Column A:","Column B:","Column C:","Column D:","Column E:","Column F:","Column G:","Column H:","Column I:","Column J:","Column K:","Column L:","Column M:"]
["Service Provided/Borrower/ Investee","Total Dollar\nValue or\nAmount of Transactions","Amount\nDisbursed to Date","Street Address","City","State","Zip (9 digits)","Census Tract          (11 digits)","Date of Execution\nmo/day/yyyy","Date of Initial\nDisbursement\nmo/day/yyyy","Date of Final\nDisbursement\nmo/day/yyyy","Type of\nActivity","Impact"]
["For Service Activities, report each activity or transaction carried out during the Assessment Period by the service provided.  For all other types of activities, report each activity by the borrower, investee, grantee, CDFI, or other recipient.","For Service Activities, report the grand total of each category of activity. For all other types of activities, report the total original dollar amount of each transaction.","List the total dollar amount disbursed on each transaction by the end of the Assessment Period. For Service Activities, TA provided to CDFIs, and Distressed Community Financing Activities of less than $250,000: record as fully disbursed. ","For all Financing Activity transactions: enter the street address of the borrower or the location of the property (in the case of real estate loans).","For all Financing Activity transactions: enter the City of the borrower or the location of the property (in the case of real estate loans).","For all Financing Activity transactions: enter the State of the borrower or the location of the property (in the case of real estate loans).","For all Financing Activity transactions: enter the Zip of the borrower or the location of the property (in the case of real estate loans).","For CDFI Related Activities, leave this column blank.               For all other types of activities, list in the census tract (including the state and county code) where the activity occurred or the borrower, investee, grantee, or other recipient is located.","List the date the activity occurred or the transaction was closed. Must occur in 2009.","List the date the Applicant made the initial disbursement.  Leave blank if no initial disbursement has been made.","List the date the Applicant made the final disbursement.  Leave blank if the transaction is not fully disbursed. Must be completed by 12/31/2009.","For all activities, select the type of activity using the abbreviations provided below.  See sidebar for explanation of abbreviations.","For Distressed Community Financing and Service Activities, see the Application for the appropriate measures of impact."]
["Smith  Contracting (example)",{"v":500000,"d":"$500,000"},{"v":275000,"d":"$275,000"},"123 Clover Avenue","New York","NY","11238-1234",12345678900,"2009-02-15","2009-02-15",null,"SBL",4]
["John Smith (example)",{"v":225000,"d":"$225,000"},{"v":225000,"d":"$225,000"},"456 Regal Drive","Philadelphia","PA","19150-1234",23456789001,"2009-09-28","2009-09-28","2009-09-28","AHM",1]