{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Page 1","Page 2","Page 3 a.","Page 4","Page 5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Page 1","index":0,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,0,57,9]],"flags":["formulas_cached_only"]}
[]
[]
["Name of Organization",null,null,"IRP/RDLF/RMAP Fund Number:",null,null,null,"Report Period",null,"Date"]
[]
["Address:",null,null,"Telephone No.:",null,"Contact Person:",null,"Date Intermediary IRP/RDLF/RMAP"]
[{"$nulls":7},"Loan was approved:"]
[null,null,null,"Tax I.D. No.:",null,null,null,"DUNS No.:"]
[]
[{"$nulls":7},"REPORT PERIOD",null,"TO DATE"]
["LOANS"]
[]
["1.","Amount of IRP/RDLF/RMAP Loan",{"$nulls":5},"$",null,"$"]
[]
["2.","Principal of loans disbursed",{"$nulls":5},"$",null,"$"]
["3.","Principal of loans received",{"$nulls":5},"$",null,"$"]
[]
["4.","Net Lending (line 2 minus 3)",{"$nulls":5},"$",null,"$"]
[]
[]
["AVAILABLE ASSETS",{"$nulls":8},"END OF PERIOD"]
["5.","Total Assets (less furniture & equipment)",{"$nulls":7},"$"]
["6.","Loans Outstanding ",{"$nulls":7},"$"]
["7.","Loan Loss Reserve (5% required) - RMAP",{"$nulls":7},"$"]
[" ","                                          (6% required) - IRP"]
["8.","Funds Available for Relending (line 5 minus line 6 and 7)",{"$nulls":7},"$"]
[]
["9.","Percent of Assets Available for Relending (Line 8 divided by Line 5)",{"$nulls":7},"%"]
[]
[]
["BALANCE SHEET"]
[]
["ASSETS"]
["1.","Cash  (minus Loan Loss Reserve)",{"$nulls":7},"$"]
["2.","Loan Loss Reserve",{"$nulls":7},"$"]
["3.","Loans Outstanding",{"$nulls":7},"$"]
["4.","Interest-Bearing Deposits",{"$nulls":7},"$"]
["5.","Other Assets (specify)",null,"  Fixed Assets (furniture and fixtures)",{"$nulls":5},"$"]
[{"$nulls":9},"$"]
[{"$nulls":9},"$"]
[]
["6.","TOTAL ASSETS",{"$nulls":7},"$"]
[]
["LIABILITIES"]
["7.","Loan Payable to RBS",{"$nulls":7},"$"]
["8.","Accounts Payable",{"$nulls":7},"$"]
["9.","Other Liabilities"]
[{"$nulls":9},"$"]
[{"$nulls":9},"$"]
["10.","TOTAL LIABILITIES",{"$nulls":7},"$"]
[{"$nulls":9},"$"]
["11.","FUND BALANCE (Assets minus Liabilities)",{"$nulls":7},"$"]
[]
[]
["According to the Paperwork Reduction Act of 1995, an agency may not conduct or sponsor, and a person is not required to respond to a collection of information unless it displays a valid OMB control number.  The valid OMB control number for this information collection is      0570-NEW.  The time required to complete this information collection is estimated to average 4  hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the       collection of information."]

{"sheet":"Page 2","index":1,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["IRP/RDLF/RMAP INCOME AND EXPENSE STATEMENT"]
["Report Period"]
["00:00:00"]
[{"$nulls":5},"USDA Approved","Prior","Reporting","Program to "]
[{"$nulls":5},"Budget","Fiscal Year","Period","Date"]
["1.  IRP/RDLF/RMAP INCOME (All Sources)",{"$nulls":4},"$","$","$","$"]
["2.  EXPENSES (IRP/RDLF/RMAP Related Expenses)"]
["     a. Employee Salaries",{"$nulls":4},"$","$","$","$"]
["     b. Employee Fringe Benefits",{"$nulls":4},"$","$","$","$"]
["     c. IRP/RDLF/RMAP-related Travel",{"$nulls":4},"$","$","$","$"]
["     d. Loan Processing/Closing Costs",{"$nulls":4},"$","$","$","$"]
["     e. Interest Paid RBS",{"$nulls":4},"$","$","$","$"]
["     f. Professional Services",{"$nulls":4},"$","$","$","$"]
["     g.  Marketing",{"$nulls":4},"$","$","$","$"]
["     h. Staff Training",{"$nulls":4},"$","$","$","$"]
["     i. Equipment - Rental",{"$nulls":4},"$","$","$","$"]
["                         - Acquisition",{"$nulls":4},"$","$","$","$"]
["     j.  Bad Debt (Loan Losses)",{"$nulls":4},"$","$","$","$"]
["     k.  Loan Loss Recovery (negative number)",{"$nulls":4},"$","$","$","$"]
["     l.  Space (rent)",{"$nulls":4},"$","$","$","$"]
["     m. Audit",{"$nulls":4},"$","$","$","$"]
["     n. Indirect Costs",{"$nulls":4},"$","$","$","$"]
["     o.  Other (Specify)",{"$nulls":4},"$","$","$","$"]
["3.  TOTAL EXPENSES (sum line 2.a. thru line 2.o)",{"$nulls":4},"$","$","$","$"]
["4.  NET IRP/RDLF/RMAP INCOME (line 1 minus line 3)",{"$nulls":4},"$","$","$","$"]
["5.  EXPENSES as % of IRP/RDLF/RMAP INCOME (line 3/line 1)",{"$nulls":4},"%","%","%","%"]
[]
["6.  If salaries & expenses are not charged against the IRP/RDLF/RMAP fund, how are theses expenses paid ?"]
["     EXPLANATION:"]
["7.  What is the total program income that was used to cover administrative costs?",{"$nulls":6},"$"]
["8 . Describe any encumbrances, liens, compensating balances, or assignments on any of the assets in the IRP/RDLF/RMAP, including those  "]
["      pursuant to any guarantees made."]
[]
["Description:"]
{"$rows_empty":8}
["CERTIFICATION OF AUTHORIZED REPRESENTATIVE :  I certify that the above information and any attachments"]
[" thereto are complete and accurate to the best of my knowledge and belief."]
[]
[]
["By: __________________________________________________________",{"$nulls":6},"Date:________________________"]
[]
["Name and Position: ______________________________________________________________"]

{"sheet":"Page 3 a.","index":2,"n_rows":82,"n_cols":12,"rows_kept":82,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"ULTIMATE RECIPIENT/MICROENTERPRISE INFORMATION:"]
[null,"Recipient Name:",{"$nulls":4},"Recipient Tax ID#:"]
[]
[null,"Applicant Type:"]
[null,"Indian Tribe (IRP/RMAP)",null,null,null,"Partnership "]
[null,"Profit-making Corporation",null,null,null,"Trust"]
[null,"Proprietorship",null,null,null,"Other "]
[null,"Public Body",null,null,null,"Non-Profit Corporation"]
[null,"Institution of Higher Learning (RMAP 0nly)",null,null,null,"Non-Profit Entity (RMAP Only)"]
[null,"Facility Location"]
[null,"Street Address:",{"$nulls":4},"Borrower's Address:"]
[{"$nulls":6},"  (if different)"]
[null,"City:"]
[null,"State:",null,null,null,"Zip Code",{"$nulls":5},"-"]
[null,"County:",null,null,null,"-"]
[]
[null,"Project Information"]
[null,"Jobs Saved:"]
[null,"Jobs Created:",{"$nulls":4},"NAICS Code"]
[]
[null,"Third Party Document"]
[null,"Approved"]
[]
[null,"RECIPIENT LOAN INFORMATION:"]
[null,"Loan Amount :",null,null,"$",null,"Closing Date:"]
[null,"Loan Balance:",null,null,"$",null,"Status:",null,null,"Ahead"]
[null,"Term: (Months)",{"$nulls":7},"Current"]
[null,"Interest Rate :",null,null,"%",{"$nulls":4},"Delinquent"]
[null,"Interest Rate Type:",{"$nulls":7},"Loss/Charged Off"]
[null,null,null,"Fixed",null,"Variable",null,null,null,"Paid in Full"]
[{"$nulls":9},"Suspended/Deferred"]
[null,null,null,"Terms Renegotiated:"]
[{"$nulls":6},"Pay-Off Date:"]
[null,"Recipient Loan Funded by:"]
[null,null,null,"Initial USDA Loan Funds and approved by RD",{"$nulls":4},"Revolving Funds"]
[]
[null,null,"Agency Contribution:",null,null,null,"$"]
[null,null,"Advanced Date (ACH):"]
[null,null,"Intermediary Contribution:",null,null,null,"$"]
[]
[null,"Modifications to Amortization:"]
[null,null,null,"Balloon Payments",{"$nulls":4},"Delayed Payment"]
[null,null,null,"Interest Only Payments",{"$nulls":4},"Other"]
[]
[null,"Collateral Information:"]
[null,null,null,"Equipment",null,null,null,"Personal Guarantees"]
[null,null,null,"Real Estate",null,null,null,"Other"]
[]
[null,null,"Lien Position:",null,null,null,"1st Position",null,null,"3rd Position"]
[{"$nulls":6},"2nd Position",null,null,"Other"]
[{"$nulls":7},"   Other Description"]
[]
[null,"Supplemental Funding Amounts:"]
[null,"State/Local",null,null,"$",null,"Federal Funds",null,null,"$"]
[null,"Bank Loans",null,null,"$",null,"Other",null,null,"$"]
[]
[null,"Sources of USDA Funding For This Loan"]
[]
[]
[null,"PAYMENT INFORMATION :"]
[null,"Payment Frequency:",null,null,"Annually",null,null,"Other"]
[{"$nulls":4},"Monthly",null,"Other Description:"]
[]
[null,"Number of Payments:"]
[null,"Due (since inception)",null,null,null,"Made Late (30 days past due or less)"]
[null,"# Made on Time",null,null,null,"Made Late (more than 30 days)"]
[]
["Comments:"]
[]
[]
[]
["For Official Use Only"]
[null,"Race Information",null,"White",{"$nulls":5},"Veteran"]
[null,null,null,"Black/African American"]
[null,null,null,"American Indian/Alaskan Native",null,null,null,"Ethnicity",null,"Hispanic or Latino"]
[null,null,null,"Asian",{"$nulls":5},"Not Hispanic or Latino"]
[null,null,null,"Native Hawaiian or Other Pacific Islander"]
[]
[{"$nulls":8},"Sex:"]
[{"$nulls":9},"Male"]
[{"$nulls":9},"Female"]
[{"$nulls":9},"Public Body"]

{"sheet":"Page 4","index":3,"n_rows":4,"n_cols":22,"rows_kept":4,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["ULTIMATE RECIPIENT/MICROENTERPRISE INFORMATION",null,null,null,"RECIPIENT LOAN INFORMATION",{"$nulls":9},"PAYMENT INFORMATION",{"$nulls":4},"For Official"]
[{"$nulls":5},"Supplemental Funding",{"$nulls":5},"**",{"$nulls":7},"Use Only"]
[null,"Jobs","Jobs","Date","Original","Private","In-Kind ","Indirect","Other","Equity","Current ","Loan ","Loan Loss","Loan Loss",null,"# Made","# >","#<"]
["Recipient Name","Saved","Created","Verified","Loan Amount","Funding","Funding","Costs","Funding","Injection","Balance","Status","Amount","Recovery","# Due","on time","30 days","30 days",null,"Race","Ethnicity","Sex"]

{"sheet":"Page 5","index":4,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["PART I:  PORTFOLIO STATUS"]
[]
["Status of Loans",{"$nulls":5},"Current Principal","#","Orig. Loan Amount"]
[{"$nulls":6},"Balance","Loans"]
["1.","Total Loans Made:",{"$nulls":5},0,"$"]
["2.","Fully Repaid",{"$nulls":5},0,"$"]
["3.","Current",{"$nulls":4},"$",0,"$"]
["4.","Delinquent (>30 days)",{"$nulls":4},"$",0,"$"]
["5.","Default",{"$nulls":4},"$",0,"$"]
["6.","Total Active Loans (Add lines 3, 4, and 5)",{"$nulls":4},"$",0,"$"]
["7.","Total Written Off",{"$nulls":4},"$",0,"$"]
[]
[]
["PART II:  PORTFOLIO SUMMARY"]
[]
["A.  Summary of Loan Activities:  ",null,null,"Provide information below on Active Loans and Total Loans closed to date."]
[{"$nulls":6},"Active Loans",null,"Total Loans"]
["1.","# IRP/RDLF/RMAP Loans"]
["2.","Total $$ Loaned:",null,null,null,"$",null,"$"]
["3.","Non-IRP/RDLF/RMAP Leveraged"]
[null,"a.    Private",null,null,null,"$",null,"$"]
[null,"b.   Other",null,null,null,"$",null,"$"]
[null,"c.   Equity Injection"]
[null,"d.  Total Leveraged $$ (a+b+c)",null,null,null,"$",null,"$"]
["4.","Total Project Leverage (2 + 3d)",null,null,null,"$",null,"$"]
["5.","Private Sector Jobs:"]
[null,"a.   Created"]
[null,"b.   Saved"]
[null,"c.   Total Jobs (a + b)"]
[]
["For Official Use Only"]
["B.  Summary of Demographics:",null,null,"Provide information below on each borrower regarding race and ethnicity."]
[{"$nulls":8},"Total Loans"]
["1.","# of IRP/RDLF/RMAP Loans to Borrowers per Race:"]
[null,"a.  White"]
[null,"b.  Black/African American"]
[null,"c.  American Indian/Alaskan Native"]
[null,"d.  Asian"]
[null,"e.  Native Hawaiian/Other Pacific Islander"]
[]
["2.","# of IRP/RDLF/RMAP Loans to Borrowers per Ethnicity:"]
[null,"a.  Hispanic or Latino"]
[null,"b.  Not-Hispanic or Latino"]
[]
["3.","# of IRP/RDLF/RMAP Loans to Borrowers per Sex:"]
[null,"a.  Male"]
[null,"b. Female"]