{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Exhibit Checklist","Application","Dev Team Info","Development Schedule","Rental Income Calc Worksheet","DEVBGT","Cash Flow","Sources of Funds","Sworn Cert","Fin Asst Wksht"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":12,"comments":7,"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":"Instructions","index":0,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,2],[29,0,30,0]]}
[]
["WORKBOOK INSTRUCTIONS"]
[]
[]
["Security/Macros:","The Funding Statement of Readiness application contains numerous Excel macros, meaning that various worksheets share information.  To allow the macros to work properly, the security setting on your Microsoft Excel program must be turned to LOW.  For Windows XP and lower, this is done through TOOLS->MACRO->SECURITY.  See screenshot below.  After setting security to LOW, close out of excel and re-open the document.  For Windows VISTA, click the Microsoft Office Button          and then click Excel Options. In the Trust Center category, click Trust Center Settings, and then click the Macro Settings category and set the security to low.  For Windows 7, choose File, Options, Trust Center and click on Trust Center Settings.  Set the macro security to low.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Exhibit Checklist:","● Use the Exhibit Checklist as your guide to indicate items completed and submitted for each type of funding request. Before printing the Exhibit Checklist to submit with your application, \"X\" each item that is included in your submission."]
[]
["Submission Date:","The Exhibit Checklist contains a \"Submission Date\" cell shaded in LIGHT YELLOW at the top of the page.  This cell is linked across all worksheets and should be completed by the applicant."]
["Auto-Filling Cells:","A number of cells contain self-generating summary calculations.  These summary cells are shaded GRAY and cannot be filled by the applicant. Cells highlighted in LIGHT YELLOW are formulas that can be typed over if the applicant has a modification."]
["Formula Errors:","Formula errors (i.e. #DIV/0!) may be visible in certain Auto-filled cells when you begin entering data.  These formula errors result when information necessary to make a numeric calculation is not fully entered.  These errors should dissipate once required information is completely entered."]
["Developer/  Development Name:","The Application worksheet contains two cells shaded in LIGHT YELLOW.  These are the Applicant Name and Development Name fields.  Once this information is entered on the Application worksheet, it will be linked to a similarly named cell on all other worksheets to avoid having multiple entries for these names.  "]
["Cash Flow Worksheet:","In the CASH FLOW worksheet, the applicant should fill in any cells highlighted in LIGHT YELLOW (if applicable)."]
["Proforma Stabilized Year:","The development's proforma stabilized year is entered in Exhibit 3.6 Development Schedule.  All income and expenses should be stabilized year projections."]

{"sheet":"Exhibit Checklist","index":1,"n_rows":43,"n_cols":20,"rows_kept":43,"cut":false,"hidden":false,"merged":[[16,10,16,11],[42,10,42,11],[40,10,40,11],[41,10,41,11],[18,10,18,11],[20,10,20,11],[24,10,24,11],[38,10,38,11],[39,10,39,11],[17,2,17,3],[13,2,13,3],[3,0,3,19],[12,0,12,3],[7,14,7,15],[11,12,11,18],[7,6,7,13],[7,16,7,19],[5,0,5,19],[17,0,17,1],[13,0,13,1],[17,4,17,5],[13,4,13,5],[11,19,12,19],[14,10,14,11],[15,10,15,11],[1,5,1,14],[11,0,11,11],[12,4,12,11],[13,13,13,18],[13,8,13,9],[13,10,13,11],[13,6,13,7],[2,17,2,19],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,10,37,11],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[17,8,17,9],[17,6,17,7],[17,10,17,11]]}
[]
[null,null,null,null,"SUBMISSION DATE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 2.0: 11/2013\n"]
["EXHIBIT CHECKLIST"]
[]
[]
[]
[null,null,null,null,null,"DEVELOPMENT NAME",{"$f":"Application!D50","v":0},null,null,null,null,null,null,null,"APPLICANT",null,{"$f":"Application!D10","v":0}]
[]
[]
[]
["\"X\" if submitted ",null,null,null,null,null,null,null,null,null,null,null,"THIS FORM MUST BE SUBMITTED WITH APPLICATION",null,null,null,null,null,null,"CHFA/ DOH use only"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit Number"]
[null,null,null,null,null,null,null,null,null,null,null,null,"A","Completed Exhibit Checklist (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B","Application (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C","Signature Page"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SECTION I. APPLICANT "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"No Exhibits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SECTION II. DEVELOPMENT TEAM & READINESS"]
[null,null,null,null,null,null,null,null,null,null,null,null,2.1,"Qualified Development Team Contact Information  (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,"Organizational Documents"]
[null,null,null,null,null,null,null,null,null,null,null,null,2.2999999999999998,"Litigation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SECTION III. DEVELOPMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.6,"Zoning Approval Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.7,"Development Schedule (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.8,"Architectural Plans and Specifications"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.9,"Architect Certifcation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3,10","A-2 Survey"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.11,"Flood Zone Map"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.12a","Hazardous Materials Environmental Site Assessment(s)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.12b","Hazardous Materials Survey(s)"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.13,"Relocation Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.14,"Anti-Displacement Certification"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.21,"Restrictive Covenant"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.22,"Financial Assistance Worksheet (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.23,"Plan of Stability of Operations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SECTION IV. BUDGET & FINANCING"]
[null,null,null,null,null,null,null,null,null,null,null,null,4.0999999999999996,"Rental Income Calculation Worksheet  (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,4.2,"Development Budget","(Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,4.3,"Cash Flow Projection","(Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,4.7,"Sources of Funds  (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,4.8,"Funding Commitment Letters"]

{"sheet":"Application","index":2,"n_rows":254,"n_cols":15,"rows_kept":254,"cut":false,"hidden":false,"merged":[[109,2,109,9],[206,2,206,8],[207,2,207,8],[242,2,242,8],[35,2,35,4],[203,2,203,7],[204,2,204,8],[201,2,201,8],[209,2,209,8],[190,4,191,4],[190,5,191,5],[194,4,194,5],[195,4,195,5],[68,4,68,7],[51,3,51,5],[140,7,140,8],[93,2,93,3],[94,2,94,8],[174,2,174,9],[175,2,175,9],[60,5,60,6],[227,2,227,8],[79,6,79,7],[100,7,100,8],[176,2,176,9],[63,2,63,3],[118,0,118,9],[121,2,121,5],[1,0,1,9],[4,0,4,9],[9,3,9,5],[11,3,11,5],[2,0,2,9],[13,3,13,5],[17,3,17,4],[17,7,17,9],[15,7,15,9],[19,7,19,9],[28,3,28,4],[15,3,15,5],[31,0,31,9],[19,3,19,4],[21,3,21,4],[21,7,21,9],[120,2,120,7],[78,6,78,7],[112,7,112,8],[36,2,36,9],[39,2,39,9],[41,2,41,9],[40,6,40,7],[62,2,62,3],[80,6,80,7],[165,0,165,9],[74,2,74,3],[198,2,198,8],[61,5,61,6],[64,5,64,6],[61,7,61,8],[64,7,64,8],[60,7,60,8],[73,2,73,3],[171,2,171,9],[66,2,66,9],[67,2,67,9],[179,2,179,9],[168,2,168,9],[64,2,64,3],[178,2,178,3],[140,2,140,4],[140,5,140,6],[211,0,211,9],[69,2,69,3],[231,2,231,8],[237,2,237,8],[238,2,238,8],[0,3,0,6],[72,2,72,9],[78,2,78,5],[80,2,80,5],[81,2,81,5],[82,2,82,5],[83,2,83,5],[45,0,45,9],[49,3,49,9],[87,2,87,9],[70,2,70,3],[213,2,213,8],[51,7,51,9],[53,3,53,5],[56,2,56,9],[57,2,57,9],[61,2,61,3],[63,5,63,6],[63,7,63,8],[215,2,215,8],[240,0,240,9],[248,1,248,9],[249,1,249,9],[245,1,245,5],[245,6,245,9],[241,2,241,8],[243,2,243,8],[247,1,247,9],[226,2,226,8],[224,2,224,8],[230,2,230,8],[216,2,216,8],[217,2,217,8],[218,2,218,8],[219,3,219,8],[220,3,220,8],[222,0,222,9],[229,2,229,8],[228,2,228,8],[236,2,236,8],[100,2,100,5],[101,2,101,7],[104,2,104,7],[83,6,83,7],[81,6,81,7],[82,6,82,7],[144,2,144,4],[144,5,144,6],[144,7,144,8],[135,2,135,3],[122,2,122,5],[123,2,123,5],[124,2,124,5],[125,2,125,5],[127,2,127,5],[128,2,128,5],[121,6,121,7],[122,6,122,7],[123,6,123,7],[124,6,124,7],[125,6,125,7],[126,6,126,7],[127,6,127,7],[158,2,158,4],[158,5,158,6],[158,7,158,8],[150,2,150,4],[150,5,150,6],[150,7,150,8],[151,2,151,4],[151,5,151,6],[151,7,151,8],[152,2,152,4],[152,5,152,6],[152,7,152,8],[136,2,136,8],[146,2,146,4],[154,2,154,4],[156,2,156,4],[156,5,156,6],[156,7,156,8],[157,2,157,4],[157,5,157,6],[157,7,157,8],[148,2,148,4],[148,5,148,6],[148,7,148,8],[149,2,149,4],[149,5,149,6],[149,7,149,8],[141,2,141,4],[141,5,141,6],[141,7,141,8],[142,2,142,4],[142,5,142,6],[142,7,142,8],[143,2,143,4],[143,5,143,6],[143,7,143,8],[79,2,79,5],[91,2,91,7],[173,2,173,8],[235,2,235,8],[232,2,232,8],[233,2,233,8],[234,2,234,8],[106,2,106,3],[107,2,107,3],[84,2,84,7],[111,2,111,7],[113,2,113,8],[116,2,116,7],[132,2,132,7],[133,2,133,8],[90,2,90,7],[97,2,97,8],[159,2,159,4],[159,5,159,6],[159,7,159,8],[160,2,160,4],[160,5,160,6],[160,7,160,8]]}
[null,null,null,"State-Sponsored Housing Portfolio"]
[" Application for ",null,null,null,null,null,null,null,null,null,null,"Version 1.0: 08/2013"]
[" Rental Development and Rehabilitation Projects"]
[]
["SECTION I.  APPLICANT "]
[]
["Applicant Information"]
[null,1.1000000000000001,"Applicant (Owner/Mortgagor)"]
[]
[null,null,"Applicant Name"]
[]
[null,null,"Applicant Address"]
[]
[null,null,"City",null,null,null,"State",null,"Zip"]
[]
[null,null,"Contact Name",null,null,null,"Title"]
[]
[null,null,"Phone",null,null,null,"Fax"]
[]
[null,null,"Email",null,null,null,"FEIN"]
[]
[null,null,"Website",null,null,null,"TIN"]
[]
[null,1.2,"Please check all that apply:"]
[]
[]
[]
[]
[null,null,null,null,null,"*Date Partnership was established: "]
[]
[]
["SECTION II. DEVELOPMENT TEAM & READINESS"]
[]
[null,2.1,"Qualified Development Team Contact Information (Form Provided)"]
[]
[null,2.2000000000000002,"Organizational Documents"]
[null,null,"For the Applicant and, if applicable, each entity that owns at least 25% of the applicant, submit a copy of its incorporation documents, including articles of incorporation, bylaws, LLC Agreement, partnership documents, including (if applicable) documentation of non-profit status and current certificate of legal existence.  Attach and label as Exhibit 2.2"]
[]
[null,2.2999999999999998,"Litigation"]
[null,null,"Is the applicant, any principal, any affiliate or any subcontractor a defendant in any litigation?"]
[]
[null,null,"If \"Yes\", indicate the nature and status of the litigation and attach and label as Exhibit 2.3"]
[]
[]
[]
["SECTION III. DEVELOPMENT "]
[]
[null,3.1,"Development Information"]
[]
[null,"Development Name"]
[]
[null,"Development Address",null,null,null,null," County"]
[]
[null,"City",null,null,null,null,"State",null,"Zip "]
[]
[null,3.2,"Narrative "]
[null,null,"Include a description of all proposed construction and/or rehabilitation activities and other material aspects of the development.   Include a description of the existing site use.    "]
[]
[null,3.3,"Development Scope "]
[]
[null,null,null,null,"Total Units","New Construction",null,"Rehab"]
[null,null,"Total number of units",null,{"$f":"SUM(F62:I62)","v":0}]
[null,null,"Total number of restricted affordable units",null,{"$f":"SUM(F63:I63)","v":0}]
[null,null,"Number of supportive housing units",null,{"$f":"SUM(F64:I64)","v":0}]
[null,null,"Number of units that are currently in the State-sponsored Housing Portfolio",27,{"$f":"SUM(F65:I65)","v":0}]
[]
[null,3.4,"Supportive Housing"]
[null,null,"For projects that include supportive housing units, complete the information below "]
[null,null,null,null,"Tenant Income Ranges"]
[null,null,"Total Number of Supportive Units",null,"0-25% AMI ","26-50% AMI","51-80% AMI","Greater than 80% AMI"]
[]
[]
[null,3.5,"Site Summary"]
[null,null,"Total Number of Buildings"]
[null,null,"Total Number of Parking Spaces"]
[]
[null,3.6,"Zoning"]
[null,null,"Please indicate the status of zoning approvals in the chart below: (Drop Menu)"]
[null,null,"Approved as of right - present zoning allows the proposed development as it is designed?"]
[null,null,"All required zoning approvals in place",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Special Permits Received",null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,"Variances Received",null,null,null,null,null,null,null,null,null,null,null,"Not Required"]
[null,null,"Inland Wetlands Permits Received"]
[" ",null,"Site Plan Approved"]
[null,null,"Attach and label evidence of zoning approval as Exhibit 3.6"]
[]
[null,3.7,"Development Schedule (Form Provided)"]
[null,null,"Submit a development schedule based on key events (acquisition, planning and zoning approval, construction, occupancy, etc.).  Attach and label as Exhibit 3.7"]
[]
[null,3.8,"Architectural Plans and Specifications"]
[null,"•","Please provide Building Plans and Specifications for all construction activities proposed to be funded through this request.  At a minimum, 40% drawings completed by a CT licensed architect must be submitted. The documents shall illustrate scope, character, relationships, form, size and appearance of the proposed activities by means of plan, section, elevation, typical construction detail and equipment layout drawings. They shall also include Design Development Specifications, which identify and generally establish the quality of proposed major materials, equipment and systems. Other documents required include: cost estimates, recommendations for the phasing of construction, site plans, landscape plans, and mechanical/electrical plans.                                                                     Attach as Exhibit 3.8.                                                                                                                                                                                                                                                                                                                                                                                                                         "]
[null,"•","All revitalization work to be carried out under this proposal must meet CHFA’s applicable Standards of Design and Construction & environmental Guidelines.  In addition, where applicable, they must meet design and construction standards of the United States Department of Housing and Urban Development.                                                                                                                      "]
[]
[null,3.9,"Architect Requirements"]
[null,null,"All architects providing services for the project must be licensed by the State of Connecticut and must have a minimum of five (5) years of relevant, multifamily residential design and construction experience. The Construction Administration portion of the Architect’s fee shall be a minimum of 35% of the total fee.                    Attach and Submit the Architect license as Exhibit 3.9"]
[]
[null,"3.1o","A-2 Survey"]
[null,null,"An A2 Survey must be submitted if the building footprint will change or there are significant alterations to site features or utilities.  Attach as Exhibit 3.10"]
[]
[null,3.11,"Flood Zone"]
[null,null,"Is any part of the project located in a 100 or 500 year flood plain?   "]
[null,null,"Submit a Flood Plain map showing project location. Attach and label as Exhibit 3.11"]
[]
[null,3.12,"Hazardous Materials"]
[null,"•","All Applicants must submit current (within 6 months) Phase I ESA reports authored by a CT Licensed Environmental Professional. A Phase II must also be submitted if such is required by the Phase I report.  All environmental deficiencies or issues noted in the Phase I ESA report must be addressed in the scope of work for the development activities.                                                                                        Attach and label as Exhibit 3.12a"]
[]
[null,null,"Date Phase 1 ESA completed"]
[null,null,"Date Phase 2 ESA completed"]
[]
[null,"•","For all projects including rehabilitation activities, submit a hazardous materials survey including radon & mold testing. All environmental deficiencies or issues noted in the hazardous materials reports, including radon and mold, must be addressed in the scope of work identified in 3.8 above.   Attach and label the Hazardous materials survey as Exhibit 3.12b."]
[]
[null,3.13,"Relocation Information"]
[null,null,"Are funds for relocation being requested?"]
[null,null,"Permanent relocation is not allowed under this initiative.  Funds for temporary relocation and alternative housing costs will be paid for not more than sixty days, but only when made necessary because of failure of a major building system or hazardous waste removal that would result in a loss of habitable units.  If necessary, please submit a temporary relocation plan.  Attachment 3.13."]
[]
[null,3.14,"Anti-Displacement Certification"]
[null,null,"All applicants must complete and attach a Sworn Certificate of Non-Displacement and submit as Attachment 3.14."]
[]
["The following section must be  completed for all State Supported Housing Portfolio developments seeking financial assistance through this State Sponsored moderate rehabilitation initiative\n"]
[]
[null,3.21,"Original Loan Background Information"]
[null,null,"Date of Original Assistance Agreement: "]
[null,null,"Original Project Number:"]
[null,null,"Name of Original Financing Program: "]
[null,null,"Original Date of Occupancy: "]
[null,null,"Is there a restrictive covenant on the property: "]
[null,null,"          If yes, attach copy as Attachment 3.21"]
[null,null,"What is the current vacancy rate for your project? "]
[]
[null,3.22,"Financial Assistance Worksheet:  "]
[null,null,"Complete Worksheet and submit as Attachment 3.22"]
[]
[null,3.23,"Plan of Sustainability of Operations"]
[null,null,"Please provide a narrative operational plan demonstrating how this funding will provide sustainability of operations for the project for the minimum requirement of 20 years.   Applications are scored based on steps to be taken regarding rent structures, marketing units, deposits to reserves to address future capital needs, reduction in operating expenses, etc.  Please provide a plan with back up documentation, if available.  Submit as Attachment 3.23"]
[]
[null,3.24,"Operating Reserves Information"]
[null,null,"Please detail the reserves expended on the development for which funds are being requested. This includes reserves expended in the past 3 years as well as for work in progress and additional commitments."]
[]
[null,null,"Reserves expended in most recent 3 years (from date of application):"]
[null,null,"Description",null,null,"Amount",null,"Date Completed"]
[]
[]
[]
[]
[]
[]
[null,null,"Reserves committed for work in progress: "]
[null,null,"Description",null,null,"Amount",null,"Date Completed"]
[]
[]
[]
[]
[]
[]
[null,null,"Reserves committed for this project:"]
[null,null,"Description",null,null,"Amount",null,"Date Completed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SECTION IV. BUDGET & FINANCING"]
[]
[null,4.0999999999999996,"Rental Income Calculation Worksheet (Form Provided)"]
[null,null,"In the provided form, identify the rent structure of the development by income targets, bedroom mix, and populations to be served.  Attach and label as Exhibit 4.1"]
[]
[null,4.2,"Development Budget (Form Provided)"]
[null,null,"Please complete the itemized budget listing all proposed uses of funds (hard and soft costs) for the project.  For proposals using Federal Low Income Housing Tax Credits (LIHTCs), Applicant should also complete the Tax Credit Eligible Basis columns.  All developments should complete the Finance Plan columns indicating from the drop down menu which sources will fund each line item in the development budget.  Attach and label as Exhibit 4.2"]
[]
[null,null,"Application Notes:  "]
[null,null,"- soft costs may be no greater than 15% of total development costs."]
[null,null,"- the financing plan shall provide a construction contingency equal to no less than 10% of the construction contract. "]
[null,null,"- no developer fees are allowed under the program."]
[]
[null,4.3,"Cash Flow Projection (Form Provided)"]
[null,null,"The Cash Flow Projection is self-generated based on information entered in other sections of the application.  No input required.  Attach and label as Exhibit 4.3"]
[]
[null,4.4000000000000004,"Financing Request"]
[null,null,null,null,"Construction Funding Amount","Permanent Funding Amount"]
[null,null,"DOH HOME ",null,{"$f":"'Sources of Funds'!C10+'Sources of Funds'!C35","v":0},{"$f":"'Sources of Funds'!E10+'Sources of Funds'!E35","v":0}]
[null,null,"DOH FLEX ",null,{"$f":"'Sources of Funds'!C11+'Sources of Funds'!C36","v":0},{"$f":"'Sources of Funds'!E11+'Sources of Funds'!E36","v":0}]
[null,null,"DOH CDBG",null,{"$f":"'Sources of Funds'!C13+'Sources of Funds'!C38","v":0},{"$f":"'Sources of Funds'!E13+'Sources of Funds'!E38","v":0}]
[]
[null,null,"State Hsg Portfolio $300M",null,{"$f":"'Sources of Funds'!C14+'Sources of Funds'!C39","v":0},{"$f":"'Sources of Funds'!E14+'Sources of Funds'!E40","v":0}]
[]
[null,4.5,"Equity Request"]
[null,null,null,null,"Construction Funding Amount","Permanent Funding Amount"]
[]
[null,null,"Developer Equity",null,{"$f":"'Sources of Funds'!C20","v":0},{"$f":"'Sources of Funds'!E20","v":0}]
[]
[null,null,"Total Development  Cost",null,{"$f":"DEVBGT!D75","v":0}]
[null,null,"Total Cost Per Unit",null,{"$f":"E195/E62","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,4.5999999999999996,"Will Davis Bacon wage rates be required for this project? (Select \"Yes\" if the project anticipates the use of federal funding)"]
[]
[null,4.7,"Sources of Funds (Form Provided)"]
[null,null,"Complete the Sources of Funds exhibit 4.7 (FORM PROVIDED).  "]
[]
[null,4.8,"Sources of Funds Commitment Letters"]
[null,null,"List all proposed sources for both construction and permanent financing, including existing debt on the property.  Be as descriptive as possible.  Provide terms and repayment provisions for all financing, including a detailed description of the terms and sources for interim or bridge financing, if any. Commitment letters for all additional sources identified in the Sources and Uses must be submitted as Exhibit 4.8."]
[]
[null,null,"NOTE: Sources of Funds"]
[null,null,"Applicants must identify available resources which may be leveraged, including but not limited to the following sources.  All such sources must be included in the Sources and Uses and documented with appropriate commitment letters.\n-RM&R to the extent available; minimum balance to remain in RM&R must be $1000/unit for elderly developments and $1500/unit for family developments along with 3 months operating expense.                                     \n-Owner Resources                                                                                                                         -Energy incentive/rebates \n-Confirmed CDBG Grants\n-Section 8 vouchers which may be project based.\n-Any other sources of readily available funds within the PHAs control including other loan funds (CHFA funds are considered other funds).\n"]
[]
[null,null,"NOTE: The Department of Housing and the Connecticut Housing Finance Authority reserve the right to determine the financing instrument, if any, regardless of the application request, based on the outcome of each agency’s underwriting."]
[]
["SECTION V. POLICY FEATURES"]
[]
[null,5.0999999999999996,"Please Indicate the policy features to which this proposed development complies (Drop menu)"]
[]
[null,null,"Brings new or vacant units on-line",null,null,null,null,null,null,null,null,null,null,null,"yes"]
[null,null,"Addresses immediate and longer term capital needs in accordance with the Capital Needs Assessment completed by Recap Advisors",null,null,null,null,null,null,null,null,null,null,null,"no"]
[null,null,"Leverages other resources"]
[null,null,"Sandy eligibility"]
[null,null,null,"Property was damaged by Super Storm Sandy"]
[null,null,null,"Property is creating replacement units for property damaged by Super Storm Sandy"]
[]
["SECTION VI. CERTIFICATIONS"]
[]
[null,6.1,"The respondent certifies to the following:"]
[null,null,null,null,null,null,null,null,null,"Yes/No"]
[null,null,"The applicant is the owner of a property in the State-sponsored Housing Portfolio and an eligible entity under CGS Section 8-37pp (Affordable Housing program)."]
[null,null,"The applicant is responsible for paying any and all of DOH’s/CHFA’s third party fees required to complete the due diligence review and to close the transaction, including a CHFA Field Observer Fee. These fees may be capitalized in the rehabilitation budget.  "]
[null,null,"A Resident Participation Plan compliance is required for housing authorities intending to undertake a major physical transformation of a property which it owns or manages.  The applicant certifies that it is in compliance with all of the requirements of CGS 8-64c regarding resident participation plans and related actions."]
[null,null,"The applicant is current on the payment of all federal, state, and local taxes."]
[null,null,"The requested activity is eligible under CGS Section 8-37pp.  "]
[null,null,"The applicant will maintain compliance with all program requirements.  "]
[null,null,"The Tenant selection plan is in compliance with state statute and regulation, approved by CHFA."]
[null,null,"Tenant profile submission is in compliance with C.G.S. §8-37bb for 2013 and submitted to CHFA."]
[null,null,"The development's Affirmative Fair Housing Marketing Plan and tenant selection methodology is in compliance with C.G.S. § 8-37ee and sections 8- 37ee-1 to 8-37ee-17 and 8-37ee-300 to 8-3 14 of the regulations of CT State Agencies."]
[null,null,"That all procurement transactions completed in conjunction with this request were completed in compliance with C.G.S. 8-44(b) regardless of type of entity receiving funds."]
[null,null,"That any general contractor hired in conjunction with activities proposed to be funded under this request are licensed to do business in the state of Connecticut."]
[null,null,"The applicant is in compliance with all existing DOH, CHFA and HUD Assistance Agreements.  (Waiver provision provided in extraordinary circumstances.)  "]
[null,null,"The applicant has identified how the project meets and is consistent with the goal/strategy (ies) of CGS Section 8-37pp or the DOH Consolidated Plan (Action Plan).  The applicant certifies that it will demonstrate its compliance with Fair Housing Guidelines to the satisfaction of DOH.  The applicant certifies that it is aware of the conditions of the Fair Housing Action Plan and that it will meet the requirements as applicable in the Plan including, but not limited to, the Analysis of Impediments to Fair Housing.  "]
[]
["SIGNATURE PAGE"]
[null,null,"Obligation of DOH and CHFA\nThe undersigned understands that there is no obligation for funding from the Department of Housing and/or the Connecticut Housing Finance Authority as a result of completing this statement.  \n"]
[null,null,"The Department of Housing and the Connecticut Housing Finance Authority reserve the right to determine the financing instrument, if any, they will offer the applicant regardless of the application request, based on the outcome of each agency’s underwriting."]
[null,null,"False Statement\nThe undersigned understands that the Department of Housing and/or the Connecticut Housing Finance Authority will rely on the information in this statement and that misrepresentations and/or incorrect statements in this statement may result in withdrawal of the statement from the review process at the Department of Housing’s and/or the Connecticut Housing Finance Authority’s discretion. The undersigned understands that he/she may be prosecuted for false statement under the laws of the State of Connecticut under Section 53a-157 of the General Statutes, as amended from time to time, for any false statement made herein.\n\nAuthorization\nThe undersigned has been duly authorized by resolution of the Applicant’s governing body to submit the attached in its name and knows of no reason why the Applicant cannot complete the project in accordance with the representations contained herein.  It is further understood and agreed that the undersigned is under a continuing obligation to inform the Department of Housing and/or the Connecticut Housing Finance Authority in writing of any corrections, omissions or material changes in this statement and its exhibits. \n"]
[]
[]
[null,"Signature of Authorized Party",null,null,null,null,"Date"]
[]
[]
[null,"Organization"]
[]
[]
[]
[null,null,null," "]

{"sheet":"Dev Team Info","index":3,"n_rows":163,"n_cols":13,"rows_kept":163,"cut":false,"hidden":false,"merged":[[126,0,126,2],[126,3,126,4],[126,5,126,7],[126,8,126,9],[123,0,123,2],[123,3,123,4],[123,5,123,7],[123,8,123,9],[124,0,124,2],[124,3,124,4],[124,5,124,7],[124,8,124,9],[125,0,125,2],[125,3,125,4],[125,5,125,7],[125,8,125,9],[120,5,120,7],[120,8,120,9],[121,0,121,2],[121,3,121,4],[121,5,121,7],[121,8,121,9],[122,0,122,2],[122,3,122,4],[122,5,122,7],[122,8,122,9],[105,0,105,2],[105,3,105,4],[105,5,105,7],[105,8,105,9],[106,0,106,2],[106,3,106,4],[106,5,106,7],[106,8,106,9],[117,0,117,9],[109,2,109,9],[102,0,102,2],[102,3,102,4],[102,5,102,7],[102,8,102,9],[103,0,103,2],[103,3,103,4],[103,5,103,7],[103,8,103,9],[104,0,104,2],[104,3,104,4],[104,5,104,7],[104,8,104,9],[99,0,99,2],[99,3,99,4],[99,5,99,7],[99,8,99,9],[100,0,100,2],[100,3,100,4],[100,5,100,7],[100,8,100,9],[101,0,101,2],[101,3,101,4],[101,5,101,7],[101,8,101,9],[77,0,77,9],[97,0,97,9],[98,0,98,2],[98,3,98,4],[98,5,98,7],[98,8,98,9],[84,0,84,2],[84,3,84,4],[84,5,84,7],[84,8,84,9],[85,0,85,2],[85,3,85,4],[85,5,85,7],[85,8,85,9],[86,0,86,2],[86,3,86,4],[86,5,86,7],[86,8,86,9],[81,0,81,2],[81,3,81,4],[81,5,81,7],[81,8,81,9],[82,0,82,2],[82,3,82,4],[82,5,82,7],[82,8,82,9],[83,0,83,2],[83,3,83,4],[83,5,83,7],[83,8,83,9],[78,0,78,2],[78,3,78,4],[78,5,78,7],[78,8,78,9],[79,0,79,2],[79,3,79,4],[79,5,79,7],[79,8,79,9],[80,0,80,2],[80,3,80,4],[80,5,80,7],[80,8,80,9],[61,0,61,2],[61,3,61,4],[61,5,61,7],[61,8,61,9],[62,0,62,2],[62,3,62,4],[62,5,62,7],[62,8,62,9],[58,5,58,7],[58,8,58,9],[59,0,59,2],[59,3,59,4],[59,5,59,7],[59,8,59,9],[60,0,60,2],[60,3,60,4],[60,5,60,7],[60,8,60,9],[33,0,33,9],[53,0,53,9],[54,0,54,2],[54,3,54,4],[54,5,54,7],[54,8,54,9],[55,0,55,2],[55,3,55,4],[55,5,55,7],[55,8,55,9],[40,0,40,2],[40,3,40,4],[40,5,40,7],[40,8,40,9],[41,0,41,2],[41,3,41,4],[41,5,41,7],[41,8,41,9],[42,0,42,2],[42,3,42,4],[42,5,42,7],[42,8,42,9],[37,0,37,2],[37,3,37,4],[37,5,37,7],[37,8,37,9],[38,0,38,2],[38,3,38,4],[38,5,38,7],[38,8,38,9],[39,0,39,2],[39,3,39,4],[39,5,39,7],[39,8,39,9],[34,0,34,2],[34,3,34,4],[34,5,34,7],[34,8,34,9],[35,0,35,2],[35,3,35,4],[35,5,35,7],[35,8,35,9],[36,0,36,2],[36,3,36,4],[36,5,36,7],[36,8,36,9],[95,5,95,7],[65,2,65,9],[66,2,66,5],[66,7,66,9],[92,2,92,5],[92,7,92,9],[1,0,1,9],[4,2,4,4],[4,7,4,9],[49,2,49,5],[49,7,49,9],[22,5,22,7],[22,8,22,9],[31,8,31,9],[31,5,31,7],[27,2,27,9],[73,2,73,4],[72,2,72,9],[44,2,44,9],[46,2,46,5],[46,7,46,9],[47,2,47,9],[68,7,68,9],[45,2,45,9],[128,2,128,9],[133,2,133,5],[130,2,130,5],[130,7,130,9],[115,5,115,7],[113,2,113,5],[113,7,113,9],[110,2,110,5],[110,7,110,9],[111,2,111,9],[112,2,112,5],[112,7,112,9],[131,2,131,9],[133,7,133,9],[118,0,118,2],[118,3,118,4],[118,5,118,7],[118,8,118,9],[119,0,119,2],[119,3,119,4],[119,5,119,7],[119,8,119,9],[120,0,120,2],[120,3,120,4],[141,7,141,9],[142,2,142,5],[142,7,142,9],[146,2,146,9],[162,8,162,9],[64,2,64,9],[160,2,160,5],[160,7,160,9],[162,5,162,7],[71,5,71,7],[159,2,159,5],[159,7,159,9],[137,2,137,9],[153,5,153,7],[157,7,157,9],[158,2,158,9],[157,2,157,5],[151,2,151,5],[151,7,151,9],[144,8,144,9],[129,2,129,9],[115,8,115,9],[132,2,132,5],[132,7,132,9],[93,7,93,9],[95,8,95,9],[91,2,91,9],[90,2,90,5],[71,8,71,9],[108,2,108,9],[93,2,93,5],[156,2,156,9],[155,2,155,9],[135,8,135,9],[153,8,153,9],[149,2,149,9],[150,2,150,5],[150,7,150,9],[147,2,147,9],[148,2,148,5],[148,7,148,9],[139,2,139,5],[139,7,139,9],[135,5,135,7],[144,5,144,7],[138,2,138,9],[140,2,140,9],[141,2,141,5],[48,2,48,5],[90,7,90,9],[89,2,89,9],[88,2,88,9],[67,2,67,9],[68,2,68,5],[48,7,48,9],[51,8,51,9],[51,5,51,7],[73,7,73,9],[74,2,74,5],[74,6,74,8],[69,2,69,5],[69,7,69,9],[56,0,56,2],[56,3,56,4],[56,5,56,7],[56,8,56,9],[57,0,57,2],[57,3,57,4],[57,5,57,7],[57,8,57,9],[58,0,58,2],[58,3,58,4],[29,2,29,5],[29,7,29,9],[19,2,19,5],[19,7,19,9],[20,2,20,5],[20,7,20,9],[24,2,24,9],[25,2,25,9],[26,2,26,5],[26,7,26,9],[28,2,28,5],[28,7,28,9],[2,0,2,9],[5,2,5,9],[7,2,7,9],[8,2,8,5],[8,7,8,9],[6,2,6,9],[13,5,13,7],[18,2,18,9],[9,2,9,9],[10,2,10,5],[10,7,10,9],[11,2,11,5],[11,7,11,9],[13,8,13,9],[15,2,15,9],[16,2,16,9],[17,2,17,5],[17,7,17,9]]}
[]
["Exhibit 2.1 - QUALIFIED DEVELOPMENT TEAM CONTACT INFORMATION"]
[]
[]
["DEVELOPMENT NAME",null,{"$f":"Application!D50","v":0},null,null,null,"APPLICANT",{"$f":"Application!D10","v":0}]
["APPLICANT"]
["(Owner/Mortgagor):",null,{"$f":"Application!D10","v":0}]
[null,"Address:",{"$f":"Application!D12","v":0}]
[null,null,{"$f":"CONCATENATE(Application!D14,\", \",Application!H14,\" \",\"0\",Application!J14)","v":",  0"},null,null,null,"Website:",{"$f":"Application!D22","v":0}]
[null,"Principal(s):"]
[null,"Contact Person:",{"$f":"Application!D16","v":0},null,null,null,"Email Address:",{"$f":"Application!D20","v":0}]
[null,"Telephone Number:",{"$f":"Application!D18","v":0}]
[]
[null,"Identity of interests:",null,null,"Entity:"]
["DEVELOPER"]
["(Legal Name):"]
[null,"Address:"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email Address:"]
[null,"Telephone Number:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[]
["ARCHITECT"]
[null,"Address:"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email Address:"]
[null,"Telephone Number:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[]
["Please identify all projects that you or your organization is currently assisting which include or potentially include CHFA or DOH funding.  This includes projects in the planning, development, or construction phases.  Also include any projects completed within the past year.  This list should include all projects being funded or potentially assisted with CHFA or DOH funds and is not limited to projects being completed by the developer under this application."]
["Project",null,null,"Location",null,"Status",null,null,"Date Completed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ENGINEER"]
[null,"Address:"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email Address:"]
[null,"Telephone Number:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[]
["Please identify all projects that you or your organization is currently assisting which include or potentially include CHFA or DOH funding.  This includes projects in the planning, development, or construction phases.  Also include any projects completed within the past year.  This list should include all projects being funded or potentially assisted with CHFA or DOH funds and is not limited to projects being completed by the developer under this application."]
["Project",null,null,"Location",null,"Status",null,null,"Date Completed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CONSULTANT",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email Address:"]
[null,"Telephone Number:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[null,"Services to be provided: "]
[null,"Estimated Cost: ",null,null,null,null,"Estimated Hours: "]
[null,"SS / Federal Tax ID #: ",null,null,null,null,"Is this firm a certified Small Business firm?"]
[null,null,null,null,null,null,null,null,"Is this firm a certified Minority/Women-Owned Enterprise?"]
[]
["Please identify all projects that you or your organization is currently assisting which include or potentially include CHFA or DOH funding.  This includes projects in the planning, development, or construction phases.  Also include any projects completed within the past year.  This list should include all projects being funded or potentially assisted with CHFA or DOH funds and is not limited to projects being completed by the developer under this application."]
["Project",null,null,"Location",null,"Status",null,null,"Date Completed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CONTRACTOR"]
[null,"Address:"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email Address:"]
[null,"Telephone Number:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[]
["Please identify all projects that you or your organization is currently assisting which include or potentially include CHFA or DOH funding.  This includes projects in the planning, development, or construction phases.  Also include any projects completed within the past year.  This list should include all projects being funded or potentially assisted with CHFA or DOH funds and is not limited to projects being completed by the developer under this application."]
["Project",null,null,"Location",null,"Status ",null,null,"Date Completed",null,null,"Predevelopment"]
[null,null,null,null,null,null,null,null,null,null,null,"Application"]
[null,null,null,null,null,null,null,null,null,null,null,"Construction"]
[null,null,null,null,null,null,null,null,null,null,null,"Pre-occupancy"]
[null,null,null,null,null,null,null,null,null,null,null,"Occupied"]
[]
[]
[]
[]
[]
["PROPERTY MANAGER"]
[null,"Address:"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email Address:"]
[null,"Telephone Number:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[]
["Please identify all projects that you or your organization is currently assisting which include or potentially include CHFA or DOH funding.  This includes projects in the planning, development, or construction phases.  Also include any projects completed within the past year.  This list should include all projects being funded or potentially assisted with CHFA or DOH funds and is not limited to projects being completed by the developer under this application."]
["Project",null,null,"Location",null,"Status",null,null,"Date Completed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TAX CREDIT SYNDICATOR"]
[null,"Address:"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email Address:"]
[null,"Telephone Number:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[]
["SERVICE PROVIDER"]
[null,"Address:"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email Address:"]
[null,"Telephone Number:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[]
["OTHER"]
[null,"Address:"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email Address:"]
[null,"Telephone Number:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[]
["OTHER"]
[null,"Address:"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email Address:"]
[null,"Telephone Number:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]

{"sheet":"Development Schedule","index":4,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[40,2,40,6],[46,2,46,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[33,1,33,6],[34,2,34,6],[25,1,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,1,29,6],[20,2,20,6],[21,2,21,6],[22,2,22,6],[23,2,23,6],[24,2,24,6],[15,2,15,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[0,4,0,6],[49,3,49,5],[53,0,53,3],[50,0,50,1],[1,0,1,6],[4,1,4,2],[4,4,4,6],[2,0,2,6],[6,0,7,0],[6,2,7,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6]]}
[null,null,null,null,"Version 2.0:11/2013\n"]
["Exhibit 3.6 - DEVELOPMENT SCHEDULE"]
[]
[]
["DEVELOPMENT NAME",{"$f":"Application!D50","v":0},null,"APPLICANT",{"$f":"Application!D10","v":0}]
[]
["Activity","Date:","Current Status Comments"]
[null,"Month/Year"]
[]
["Current Year:"]
["Site:"]
["Option/Contract"]
["Site Acquisition"]
["Zoning Approval"]
["Site Analysis"]
["Financing:"]
["Construction Loan"]
["Loan Application"]
["Conditional Commitment"]
["Firm Commitment"]
["Permanent Loan"]
["Loan Application"]
["Conditional Commitment"]
["Firm Commitment"]
["Other Loans & Grants"]
["Type & Source: ","(describe)"]
["Application"]
["Award"]
["Other Loans & Grants"]
["Type & Source: ","(describe)"]
["Application"]
["Award"]
["Other Loans & Grants"]
["Type & Source: ","(describe)"]
["Application"]
["Award"]
["Plans & Specifications:"]
["Schematics"]
["40% drawings"]
["100% drawings"]
["Closing & Transfer of Property"]
["Construction Start"]
["Completion of Construction"]
["Lease-up",null,null,null,null,null,null,null,null,null,null,"Yes"]
["Sustaining Occupancy",null,null,null,null,null,null,null,null,null,null,"No"]
["Proforma Stabilized Year*"]
["LIHT Credit Placed-In-Service Date"]
[]
["Will project construction be in phases?"]
[]
["If Yes, please indicate phase below and provide a separate schedule for each phase on separate sheet."]
["Phase:"]
[]
["* Proforma Stabilized Year (PSY) is the first full year following lease up with sustaining occupancy.  For example, if sustaining occupancy is projected to occur in March of 2012,  the PSY would be 2013."]

{"sheet":"Rental Income Calc Worksheet","index":5,"n_rows":77,"n_cols":28,"rows_kept":77,"cut":false,"hidden":false,"merged":[[1,0,1,8],[2,0,2,8],[4,2,4,4],[4,6,4,8],[55,8,57,8],[53,0,53,8],[6,7,6,8],[6,2,6,3],[8,0,8,8],[23,0,23,3],[23,4,23,8],[10,1,11,1],[10,2,10,3],[20,0,20,3],[25,0,25,15],[10,4,10,9]]}
[]
["Exhibit 4.1 - RENTAL INCOME CALCULATION WORKSHEET"]
[]
[]
[null,"DEVELOPMENT NAME",{"$f":"Application!D50","v":0},null,null,"APPLICANT",{"$f":"Application!D10","v":0}]
[]
[null,"Current Year",{"$f":"'Development Schedule'!B10","v":0},null,null,null,"Proforma Stabilized Year (PSY)",{"$f":"'Development Schedule'!B46","v":0}]
[]
["UTILITY ALLOWANCE"]
[]
[null,"Indicate Energy Source (e.g.: gas, electric)","\"X\" all that Apply",null,"Enter Current Year Tenant Paid Utility Allowance for all that Apply"]
[null,null,"Owner Paid","Tenant Paid","0BR","1BR","2BR","3BR","4BR","5BR"]
["Heating"]
["Hot Water"]
["Cooking"]
["Lighting"]
["Air Cond."]
["Refrigerator"]
["Range"]
["Other"]
["Total",null,null,null,{"$f":"SUM(E13:E20)","v":0},0,0,0,0,0]
[null,null,null,"Utility Allowance Trended to Proforma Stabilized Year:",{"$f":"-FV(0.05,$H$7-$C$7,0,E21,0)","v":0},0,0,0,0,0]
[]
["Source and Effective Date of Utility Allowances:"]
[]
["RENTAL INCOME"]
[]
[null,null,null,null,null,null,{"$f":"H7","v":0},{"$f":"H7","v":0},{"$f":"H7","v":0},{"$f":"H7","v":0},{"$f":"H7","v":0},{"$f":"H7","v":0},{"$f":"H7","v":0},{"$f":"M28","v":0},null,{"$f":"H7","v":0}]
["Funding Source ","AMI %","# Bedrooms","# Units","Unit Size (Square Feet)","Number of Baths per Unit","Applicant's Proposed Monthly Gross Rent","Utility Allowance","Applicant's Proposed Monthly Net (Contract) Rent","Estimated Monthly Rental Subsidy per Unit","Monthly Effective Rent","Annual Gross Contract Rent Revenue","Annual Gross Rental Subsidy Revenue","Total Annual Gross Revenue","Vacancy Rate","Effective Gross Income",null,null,"Vacancy","Total Square Feet"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(B31>100%,0,IF(C31=\"\",0,IF(AND(B31<=100%,C31=0),$E$22,IF(AND(B31<=100%,C31=1),$F$22,IF(AND(B31<=100%,C31=2),$G$22,IF(AND(B31<=100%,C31=3),$H$22,IF(AND(B31<=100%,C31>=4),$I$22,0)))))))","v":0},{"$f":"G31-H31","v":0},null,{"$f":"J31+I31","v":0},{"$f":"(I31)*D31*12","v":0},{"$f":"J31*D31*12","v":0},{"$f":"M31+L31","v":0},{"$f":"IF(B31=25%,2.5%,IF(AND(B31>25%,B31<60%),5%,IF(AND(B31>=60%,B31<80%),7%,IF(B31>=80%,10%,\"n/a\"))))","v":"n/a"},{"$f":"IF(O31=\"n/a\",0,((L31+M31)*(1-O31)))","v":0},null,null,{"$f":"IF(O31=\"n/a\",0,O31*N31)","v":0},{"$f":"E31*D31","v":0},null,null,null,null,null,null,0.25,0]
[null,null,null,null,null,null,null,{"$f":"IF(B32>100%,0,IF(C32=\"\",0,IF(AND(B32<=100%,C32=0),$E$22,IF(AND(B32<=100%,C32=1),$F$22,IF(AND(B32<=100%,C32=2),$G$22,IF(AND(B32<=100%,C32=3),$H$22,IF(AND(B32<=100%,C32>=4),$I$22,0)))))))","v":0},{"$f":"G32-H32","v":0},null,{"$f":"J32+I32","v":0},{"$f":"(I32)*D32*12","v":0},{"$f":"J32*D32*12","v":0},{"$f":"M32+L32","v":0},{"$f":"IF(B32=25%,2.5%,IF(AND(B32>25%,B32<60%),5%,IF(AND(B32>=60%,B32<80%),7%,IF(B32>=80%,10%,\"n/a\"))))","v":"n/a"},{"$f":"IF(O32=\"n/a\",0,((L32+M32)*(1-O32)))","v":0},null,null,{"$f":"IF(O32=\"n/a\",0,O32*N32)","v":0},0,null,null,null,null,null,null,0.5,1]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,{"$f":"IF(B33=25%,2.5%,IF(AND(B33>25%,B33<60%),5%,IF(AND(B33>=60%,B33<80%),7%,IF(B33>=80%,10%,\"n/a\"))))","v":"n/a"},0,null,null,0,0,null,null,null,null,null,null,0.6,2]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0,null,null,null,null,null,null,0.8,3]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0,null,null,null,null,"LIHTC ",null,1,4]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0,null,null,null,null,"DOH Home",null,1.2,5]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0,null,null,null,null,"DOH Flex",null,"120%+"]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0,null,null,null,null,"DOH HTF"]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0,null,null,null,null,"LIHTC & DOH Home"]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0,null,null,null,null,"LIHTC & DOH Flex"]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0,null,null,null,null,"LIHTC & DOH HTF"]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0,null,null,null,null,"Rental Subsidy"]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0,null,null,null,null,"Other"]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0,0,0,"n/a",0,null,null,0,0]
[null,null,null,{"$f":"SUM(D31:D49)","v":0},null,null,null,null,null,null,{"$f":"SUM(K31:K49)","v":0},{"$f":"SUM(L31:L49)","v":0},{"$f":"SUM(M31:M49)","v":0},{"$f":"SUM(N31:N49)","v":0},{"$f":"(L50+M50-P50)","v":0},{"$f":"SUM(P31:P49)","v":0}]
[]
[null,"Number of LITHC Qualified Units",{"$f":"SUMIF(B31:B49,\"<=60%\",D31:D49)","v":0},null,null,"Number of Other Affordable Units",{"$f":"SUMIF(B31:B49,\"=80%\",D31:D49)","v":0},null,"Number of Market Rate Units",{"$f":"D50-G52-C52","v":0}]
[]
["CHFA & DOH RENT GUIDELINES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIHTC GI Monthly ",null,"LIHTC EGI Annual","Non LIHTC GI Monthly "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIHTC",null,0.25,0,{"$f":"IF(O31=\"n/a\",0,O31)","v":0},{"$f":"Y55*L31","v":0}]
[null,null,{"$f":"C7","v":0},{"$f":"C7","v":0},{"$f":"D56","v":0},{"$f":"C7","v":0},{"$f":"H7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"HOME",null,0.5,1,0,0]
["AMI %",{"$f":"C29","v":"# Bedrooms"},"Maximum Allowable Family Income"," Allowable Housing Cost ","Maximum Allowable Gross Rent","Maximum Affordable Gross Rent","Maximum Affordable Gross Rent",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHFA Financing",null,0.6,2,0,0]
[null,null,"(DOH Only)","(DOH Only)","(DOH Only)","(CHFA Only)","(CHFA Only)",null,null,null,null,null,null,null,null,null,null,null,null,null,"FLEX Program",null,0.8,3,0,0]
[{"$f":"B31","v":0},0,null,{"$f":"C59/12*30%","v":0},null,null,{"$f":"-FV(2%,$H$7-$C$7,0,F59,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4,0,0]
[0,0,null,{"$f":"C60/12*30%","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4,5,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 140%",null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(Z55:Z73)","v":0},{"$f":"Z74*12","v":0}]
[0,0,null,0,null,null,0]
[0,0,null,0,null,null,0]
[0,0,null,0,null,null,0]

{"sheet":"DEVBGT","index":6,"n_rows":85,"n_cols":16,"rows_kept":85,"cut":false,"hidden":false,"merged":[[82,0,82,7],[84,6,84,7],[72,0,72,1],[73,0,73,1],[74,0,74,1],[77,0,77,2],[77,3,77,7],[78,1,78,2],[80,0,80,2],[79,1,79,2],[65,0,65,1],[39,0,39,1],[40,0,40,1],[42,0,42,1],[42,15,42,16],[50,0,50,1],[51,0,51,1],[52,0,52,1],[54,0,54,1],[54,15,54,16],[55,0,55,1],[55,15,55,16],[29,15,29,16],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[20,0,20,1],[20,15,20,16],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[1,0,1,11],[4,1,4,2],[4,4,4,6],[6,2,9,2],[6,3,9,3],[6,5,6,10],[7,10,9,10],[2,0,2,10]]}
[]
["Exhibit 4.2 - DEVELOPMENT BUDGET"]
[]
[]
["DEVELOPMENT NAME",{"$f":"Application!D50","v":0},null,"APPLICANT",{"$f":"Application!D10","v":0}]
[]
[null,null,"% ","BUDGET","TAX CREDIT ELIGIBLE BASIS","FINANCE PLAN"]
[null,null,null,null,"70% NPV - 9% or",null,null,null,null,null,"Total"]
[null,null,null,null,"30% NPV - 4% "]
[null,null,null,null,"(New / Rehab.)"]
["SITE & IMPROVEMENTS (Div. 1-16) Hard Costs",null,null,null,{"$f":"D11","v":0},null,null,null,null,null,{"$f":"SUM(F11:J11)","v":0}]
["GENERAL REQUIREMENTS (Max. 9% Site + Improvements)  ",null,{"$f":"IFERROR(D12/D11,\"-\")","v":"-"},null,{"$f":"D12","v":0},null,null,null,null,null,{"$f":"SUM(F12:J12)","v":0}]
["OVERHEAD and PROFIT ( Max. 7% Site + Improvements)",null,{"$f":"IFERROR(D13/D11,\"-\")","v":"-"},null,0,null,null,null,null,null,0]
["BOND PREMIUM / L.O.C. COST",null,null,null,0,null,null,null,null,null,0]
["BUILDING PERMITS and OTHER DEVELOPMENT FEES",null,null,null,0,null,null,null,null,null,0]
["CONSTRUCTION (Project Cost Summary) Sub-Total  ",null,null,{"$f":"SUM(D11:D15)","v":0},{"$f":"SUM(E11:E15)","v":0},{"$f":"SUM(F11:F15)","v":0},0,0,0,0,0]
["Other",null,null,null,0,null,null,null,null,null,0]
["Other",null,null,null,0,null,null,null,null,null,0]
["Other",null,null,null,0,null,null,null,null,null,0]
["CONSTRUCTION CONTINGENCY (10% Max) (% Const. >)",null,{"$f":"IFERROR(D20/D16,\"-\")","v":"-"},null,{"$f":"D20*0.5","v":0},null,null,null,null,null,0]
["CONSTRUCTION ",null,null,{"$f":"SUM(D16:D20)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F16:F20)","v":0},0,0,0,0,0]
["ARCHITECT - Design",null,null,null,{"$f":"D22","v":0},null,null,null,null,null,0]
["ARCHITECT - Contract Admin (Min. 35%) (% Contract > )",null,{"$f":"IFERROR(D23/(D22+D23),\"-\")","v":"-"},null,{"$f":"D23","v":0},null,null,null,null,null,0]
["ENGINEERING (Civil-Site / Structural / Etc.)",null,null,null,0,null,null,null,null,null,0]
["SURVEYS (A-2: Exist. Conditions and As-Built)",null,null,null,0,null,null,null,null,null,0]
["Other",null,null,null,0,null,null,null,null,null,0]
["Other",null,null,null,0,null,null,null,null,null,0]
["Other",null,null,null,0,null,null,null,null,null,0]
["Other",null,null,null,0,null,null,null,null,null,0]
["ARCHITECTURAL and ENGINEERING",null,null,{"$f":"SUM(D22:D29)","v":0},{"$f":"SUM(E22:E29)","v":0},{"$f":"SUM(F22:F29)","v":0},0,0,0,0,0]
["INTEREST (CHFA) - Const. + 2 Mos.Lease Up",null,null,null,{"$f":"D31","v":0},null,null,null,null,null,0]
["CHFA LOAN ORIG. / COMMIT. FEE ",null,{"$f":"IFERROR(D32/MAX(('Sources of Funds'!E31+'Sources of Funds'!E32+'Sources of Funds'!E33+'Sources of Funds'!C34),('Sources of Funds'!C31+'Sources of Funds'!C32+'Sources of Funds'!C33+'Sources of Funds'!C34)),\"-\")","v":"-"},null,"N/A",null,null,null,null,null,0]
["INTEREST - Bridge Loan",null,null,null,{"$f":"D33","v":0},null,null,null,null,null,0]
["FEES - Bridge Loan",null,null,null,{"$f":"D34","v":0},null,null,null,null,null,0]
["R. E. TAXES / PILOTS - Const. Period",null,null,null,{"$f":"D35","v":0},null,null,null,null,null,0]
["INSURANCE - Const. Period ( Builder's Risk / Liability / Hazard ) ",null,null,null,{"$f":"D36","v":0},null,null,null,null,null,0]
["UTILITIES - Const. Period ( If Owner Paid )",null,null,null,{"$f":"D37","v":0},null,null,null,null,null,0]
["Negative Arbitrage on Bonds (If Applic.)",null,null,null,"N/A",null,null,null,null,null,0]
["Credit Enhancement Premium (HUD or Private Perm. Mortg. Insur.)",null,null,null,"N/A",null,null,null,null,null,0]
["Other",null,null,null,{"$f":"D40","v":0},null,null,null,null,null,0]
["Other",null,null,null,{"$f":"D41","v":0},null,null,null,null,null,0]
["CHFA CONSTRUCTION OBSERVATION",null,null,null,{"$f":"D42","v":0},null,null,null,null,null,0]
["FINANCE and INTERIM COSTS",null,null,{"$f":"SUM(D31:D42)","v":0},{"$f":"SUM(E31:E42)","v":0},{"$f":"SUM(F31:F42)","v":0},0,0,0,0,0]
["LEGAL COUNSEL - Real Estate (Closing Docs and Title Work)",null,null,null,{"$f":"D44","v":0},null,null,null,null,null,0]
["CHFA EXTERNAL LEGAL COUNSEL",null,null,null,{"$f":"D45","v":0},null,null,null,null,null,0]
["TITLE INSUR. PREMIUMS and RECORDING COSTS",null,null,null,{"$f":"D46","v":0},null,null,null,null,null,0]
["APPRAISALS / MARKET STUDY (CHFA / LIHTC Required)",null,null,null,{"$f":"D47","v":0},null,null,null,null,null,0]
["LEASE UP & MARKETING",null,null,null,"N/A",null,null,null,null,null,0]
["COST CERTIFICATIONS (CHFA/LIHTC/DOH Required)  ",null,null,null,"N/A",null,null,null,null,null,0]
["ENVIRONMENTAL  REPORTS and TESTING",null,null,null,{"$f":"D50","v":0},null,null,null,null,null,0]
["Other",null,null,null,{"$f":"D51","v":0},null,null,null,null,null,0]
["Other",null,null,null,{"$f":"D52","v":0},null,null,null,null,null,0]
["Other",null,null,null,{"$f":"D53","v":0},null,null,null,null,null,0]
["SOFT COST CONTINGENCY (5% Max) (A&E+FIN+SOFT %)",null,{"$f":"IF((D43+D30+SUM(D44:D53))=0,0,D54/(D43+D30+SUM(D44:D53)))","v":0},null,{"$f":"D54","v":0},null,null,null,null,null,0]
["SOFT COSTS  -  Fees & Expenses",null,null,{"$f":"SUM(D44:D54)","v":0},{"$f":"SUM(E44:E54)","v":0},{"$f":"SUM(F44:F54)","v":0},0,0,0,0,0]
["TOTAL DEVELOPMENT COSTS  (TDC)  ",null,null,{"$f":"D55+D43+D30+D21","v":0},{"$f":"E55+E43+E30+E21","v":0},{"$f":"F55+F43+F30+F21","v":0},0,0,0,0,0]
["DEVELOPER ALLOWANCE / FEE (Max.15% TDC)",null,{"$f":"IF(D56=0,0,$D57/D56)","v":0},null,{"$f":"D57","v":0},null,null,null,null,null,0]
["PRE-DEVEL. FINANCING (Interest) COSTS [ Lender-Approved ]",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"DOH HOME"]
["   Land  Cost  ",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"DOH FLEX"]
["   Existing Building/s  ",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"DOH HTF"]
["SITE ACQUISITION  (Appraised \"As Is\" Value)",null,null,{"$f":"SUM(D59:D60)","v":0},0,0,0,0,0,0,0,null,null,null,null,"CHFA Mortgage"]
["Operating / Debt Serv./ Coverage  ",null,null,{"$f":"IF('Sources of Funds'!E34>0,'Cash Flow'!C101,IF(OR('Sources of Funds'!E31>0,'Sources of Funds'!E32>0,'Sources of Funds'!E33>0),'Cash Flow'!C96,0))","v":0},"N/A","N/A","N/A",null,null,null,0,null,null,null,null,"LIHTC"]
["Capital / Replacement  ",null,null,null,"N/A","N/A","N/A",null,null,null,0,null,null,null,null,"CDBG - Small Cities"]
["Other  ",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"CDBG - Entitlement"]
["CAPITALIZED RESERVES",null,null,{"$f":"SUM(D62:D64)","v":0},"N/A",{"$f":"SUM(F62:F64)","v":0},{"$f":"SUM(G62:G64)","v":0},{"$f":"SUM(H62:H64)","v":0},{"$f":"SUM(I62:I64)","v":0},{"$f":"SUM(J62:J64)","v":0},0,null,null,null,null,"Deferred Developer Fee"]
["RECOGNIZED LENDING COSTS  ",null,null,{"$f":"SUM(D56:D58)+D61+D65","v":0},{"$f":"SUM(E56:E64)","v":0},{"$f":"SUM(F56:F58)+F61+F65","v":0},{"$f":"SUM(G56:G58)+G61+G65","v":0},{"$f":"SUM(H56:H58)+H61+H65","v":0},{"$f":"SUM(I56:I58)+I61+I65","v":0},{"$f":"SUM(J56:J58)+J61+J65","v":0},0,null,null,null,null,"Federal Home Loan Bank"]
["Entity Organizational and Legal",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"Federal - other"]
["Syndicator Fees / Commissions",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"Historic Tax Credits - Federal"]
["Equity Bridge Loan Interest and Fees",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"Historic Tax Credits - State"]
["Tax Opinion and Entity Accounting ",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"HOME - Local"]
["CHFA Tax Credit Fee (8% Ann. Credit) ",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"Housing Authority"]
["CHFA LIHTC Applic. Fee ($1,000) and/or Historic Credit Applic. Fee ",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"HUD Section 202"]
["Other",null,null,null,"N/A",null,null,null,null,null,0,null,null,null,null,"HUD Section 811"]
["ENTITY and SYNDICATION COSTS  / OTHER",null,null,{"$f":"SUM(D67:D73)","v":0},0,0,0,0,0,0,0,null,null,null,null,"Local/State Funding"]
["TOTAL USES ",null,null,{"$f":"D66+D74","v":0},{"$f":"SUM(E66:E73)","v":0},{"$f":"F66+F74","v":0},{"$f":"G66+G74","v":0},{"$f":"H66+H74","v":0},{"$f":"I66+I74","v":0},{"$f":"J66+J74","v":0},0,null,null,null,null,"Private Financing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Private Grants"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales Proceed"]
["Prepared By:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[]
["Name & Title","Date     "]
[]
["Company"]
["Official Use Only"]
[null,null,"Budget Period:","From:",null,"to:"]
[null,null,"Revision #:",null,null,"Reason for Revision:"]

{"sheet":"Cash Flow","index":7,"n_rows":102,"n_cols":46,"rows_kept":102,"cut":false,"hidden":false,"merged":[[1,3,1,6],[4,33,4,34],[4,2,4,3],[4,7,4,8],[4,14,4,15],[4,22,4,23]]}
[]
[null,null,null,"Exhibit 4.3 - CASH FLOW PROJECTION"]
[]
[]
[null,"DEVELOPMENT NAME",{"$f":"Application!D50","v":0},null,null,null,"APPLICANT",{"$f":"Application!D10","v":0}]
[]
["INCOME",null,null,null,null,null,1,{"$f":"G7+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,null,null,null,"Growth %",null,{"$f":"'Development Schedule'!B46","v":0},{"$f":"G8+1","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39]
[]
[null,null,null,"RESIDENTIAL - Qualified / Afford. Gross Rental Income",0.02,null,{"$f":"SUMIF('Rental Income Calc Worksheet'!B31:B49,\"<100%\",'Rental Income Calc Worksheet'!N31:N49)","v":0},{"$f":"G10*(1+$E10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"W10*(1+$E10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"- RESIDENTIAL - Qualified / Afford. Vacancy Loss",0.02,null,{"$f":"SUMIF('Rental Income Calc Worksheet'!B31:B49,\"<100%\",'Rental Income Calc Worksheet'!S31:S49)","v":0},{"$f":"G11*(1+$E11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"= RESIDENTIAL - Qualified / Afford. Net Rental Income",0.02,null,{"$f":"SUMIF('Rental Income Calc Worksheet'!B31:B49,\"<100%\",'Rental Income Calc Worksheet'!P31:P49)","v":0},{"$f":"G12*(1+$E12)","v":0},{"$f":"H12*(1+$E12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"RESIDENTIAL - Market Rate Gross Rental Income",0.02,null,{"$f":"SUMIF('Rental Income Calc Worksheet'!B31:B49,\">=100%\",'Rental Income Calc Worksheet'!N31:N49)+SUMIF('Rental Income Calc Worksheet'!B31:B49,\"120%+\",'Rental Income Calc Worksheet'!N31:N49)","v":0},{"$f":"G13*(1+$E13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"- RESIDENTIAL - Market Rate Vacancy Loss",0.02,null,{"$f":"SUMIF('Rental Income Calc Worksheet'!B31:B49,\">=100%\",'Rental Income Calc Worksheet'!S31:S49)+SUMIF('Rental Income Calc Worksheet'!B31:B49,\"120%+\",'Rental Income Calc Worksheet'!S31:S49)","v":0},{"$f":"G14*(1+$E14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"= RESIDENTIAL - Market Rate Net Rental Income",0.02,null,{"$f":"SUMIF('Rental Income Calc Worksheet'!B31:B49,\">=100%\",'Rental Income Calc Worksheet'!P31:P49)+SUMIF('Rental Income Calc Worksheet'!B31:B49,\"120%+\",'Rental Income Calc Worksheet'!P31:P49)","v":0},{"$f":"G15*(1+$E15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Other Income",0.02,null,null,{"$f":"G16*(1+$E16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null," EFFECTIVE GROSS INCOME (EGI)  ",null,{"$f":"G12+G15+G16","v":0},{"$f":"H12+H15+H16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["EXPENSES",null,null,"Administrative",0.03,null,null,{"$f":"G19*(1+$E19)","v":0},{"$f":"H19*(1+$E19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Maintenance",0.03,null,null,{"$f":"G20*(1+$E20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Operating and Other",0.03,null,null,{"$f":"G21*(1+$E21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Other",0.03,null,null,{"$f":"G22*(1+$E22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Capital (Replacement) Reserve",0.04,null,null,{"$f":"G23*(1+$E23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Real  Estate Taxes / PILOT's",0.03,null,null,{"$f":"G24*(1+$E24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub Total: ANNUAL EXPENSES  ",null,{"$f":"SUM(G19:G24)","v":0},{"$f":"SUM(H19:H24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"NOI",null,{"$f":"G17-G25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Capital (Replacement) Reserve Balance",null,{"$f":"G23","v":0},{"$f":"G29+H23","v":0},{"$f":"H29+I23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["SCHEDULED ANNUAL DEBT SERVICE (ADS)"]
[]
[{"$f":"'Sources of Funds'!A31","v":"CHFA Loan 1st Mortg. Loan [ Tax-Exempt Bonds ]"},null,null,{"$f":"'Sources of Funds'!E31","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K31","v":0},{"$f":"G33","v":0},{"$f":"H33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F31","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G33=0),\"n/a\",G$27/(G$33))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H33=0),\"n/a\",H$27/(H$33))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G31","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$33=0,0,(FV('Sources of Funds'!$G$31/12,12,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(G35=0,0,(FV('Sources of Funds'!$G$31/12,12*H7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(H35=0,0,(FV('Sources of Funds'!$G$31/12,12*I7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(I35=0,0,(FV('Sources of Funds'!$G$31/12,12*J7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(J35=0,0,(FV('Sources of Funds'!$G$31/12,12*K7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(K35=0,0,(FV('Sources of Funds'!$G$31/12,12*L7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(L35=0,0,(FV('Sources of Funds'!$G$31/12,12*M7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(M35=0,0,(FV('Sources of Funds'!$G$31/12,12*N7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(N35=0,0,(FV('Sources of Funds'!$G$31/12,12*O7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(O35=0,0,(FV('Sources of Funds'!$G$31/12,12*P7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(P35=0,0,(FV('Sources of Funds'!$G$31/12,12*Q7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(Q35=0,0,(FV('Sources of Funds'!$G$31/12,12*R7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(R35=0,0,(FV('Sources of Funds'!$G$31/12,12*S7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(S35=0,0,(FV('Sources of Funds'!$G$31/12,12*T7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(T35=0,0,(FV('Sources of Funds'!$G$31/12,12*U7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(U35=0,0,(FV('Sources of Funds'!$G$31/12,12*V7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(V35=0,0,(FV('Sources of Funds'!$G$31/12,12*W7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(W35=0,0,(FV('Sources of Funds'!$G$31/12,12*X7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(X35=0,0,(FV('Sources of Funds'!$G$31/12,12*Y7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(Y35=0,0,(FV('Sources of Funds'!$G$31/12,12*Z7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(Z35=0,0,(FV('Sources of Funds'!$G$31/12,12*AA7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AA35=0,0,(FV('Sources of Funds'!$G$31/12,12*AB7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AB35=0,0,(FV('Sources of Funds'!$G$31/12,12*AC7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AC35=0,0,(FV('Sources of Funds'!$G$31/12,12*AD7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AD35=0,0,(FV('Sources of Funds'!$G$31/12,12*AE7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AE35=0,0,(FV('Sources of Funds'!$G$31/12,12*AF7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AF35=0,0,(FV('Sources of Funds'!$G$31/12,12*AG7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AG35=0,0,(FV('Sources of Funds'!$G$31/12,12*AH7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AH35=0,0,(FV('Sources of Funds'!$G$31/12,12*AI7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AI35=0,0,(FV('Sources of Funds'!$G$31/12,12*AJ7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AJ35=0,0,(FV('Sources of Funds'!$G$31/12,12*AK7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AK35=0,0,(FV('Sources of Funds'!$G$31/12,12*AL7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AL35=0,0,(FV('Sources of Funds'!$G$31/12,12*AM7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AM35=0,0,(FV('Sources of Funds'!$G$31/12,12*AN7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AN35=0,0,(FV('Sources of Funds'!$G$31/12,12*AO7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AO35=0,0,(FV('Sources of Funds'!$G$31/12,12*AP7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AP35=0,0,(FV('Sources of Funds'!$G$31/12,12*AQ7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AQ35=0,0,(FV('Sources of Funds'!$G$31/12,12*AR7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AR35=0,0,(FV('Sources of Funds'!$G$31/12,12*AS7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0},{"$f":"IF(AS35=0,0,(FV('Sources of Funds'!$G$31/12,12*AT7,'Sources of Funds'!$K$31/12,'Sources of Funds'!$E$31*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A32","v":"CHFA 1st Mortg. Loan [ Taxable Bonds ]"},null,null,{"$f":"'Sources of Funds'!E32","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K32","v":0},{"$f":"G37","v":0},{"$f":"H37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F32","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G37=0),\"n/a\",G$27/(G$33+G33))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H37=0),\"n/a\",H$27/(H$33+H33))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G32","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$37=0,0,(FV('Sources of Funds'!$G$32/12,12,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(G39=0,0,(FV('Sources of Funds'!$G$32/12,12*H7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(H39=0,0,(FV('Sources of Funds'!$G$32/12,12*I7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(I39=0,0,(FV('Sources of Funds'!$G$32/12,12*J7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(J39=0,0,(FV('Sources of Funds'!$G$32/12,12*K7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(K39=0,0,(FV('Sources of Funds'!$G$32/12,12*L7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(L39=0,0,(FV('Sources of Funds'!$G$32/12,12*M7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(M39=0,0,(FV('Sources of Funds'!$G$32/12,12*N7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(N39=0,0,(FV('Sources of Funds'!$G$32/12,12*O7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(O39=0,0,(FV('Sources of Funds'!$G$32/12,12*P7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(P39=0,0,(FV('Sources of Funds'!$G$32/12,12*Q7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(Q39=0,0,(FV('Sources of Funds'!$G$32/12,12*R7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(R39=0,0,(FV('Sources of Funds'!$G$32/12,12*S7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(S39=0,0,(FV('Sources of Funds'!$G$32/12,12*T7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(T39=0,0,(FV('Sources of Funds'!$G$32/12,12*U7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(U39=0,0,(FV('Sources of Funds'!$G$32/12,12*V7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(V39=0,0,(FV('Sources of Funds'!$G$32/12,12*W7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(W39=0,0,(FV('Sources of Funds'!$G$32/12,12*X7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(X39=0,0,(FV('Sources of Funds'!$G$32/12,12*Y7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(Y39=0,0,(FV('Sources of Funds'!$G$32/12,12*Z7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(Z39=0,0,(FV('Sources of Funds'!$G$32/12,12*AA7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AA39=0,0,(FV('Sources of Funds'!$G$32/12,12*AB7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AB39=0,0,(FV('Sources of Funds'!$G$32/12,12*AC7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AC39=0,0,(FV('Sources of Funds'!$G$32/12,12*AD7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AD39=0,0,(FV('Sources of Funds'!$G$32/12,12*AE7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AE39=0,0,(FV('Sources of Funds'!$G$32/12,12*AF7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AF39=0,0,(FV('Sources of Funds'!$G$32/12,12*AG7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AG39=0,0,(FV('Sources of Funds'!$G$32/12,12*AH7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AH39=0,0,(FV('Sources of Funds'!$G$32/12,12*AI7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AI39=0,0,(FV('Sources of Funds'!$G$32/12,12*AJ7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AJ39=0,0,(FV('Sources of Funds'!$G$32/12,12*AK7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AK39=0,0,(FV('Sources of Funds'!$G$32/12,12*AL7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AL39=0,0,(FV('Sources of Funds'!$G$32/12,12*AM7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AM39=0,0,(FV('Sources of Funds'!$G$32/12,12*AN7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AN39=0,0,(FV('Sources of Funds'!$G$32/12,12*AO7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AO39=0,0,(FV('Sources of Funds'!$G$32/12,12*AP7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AP39=0,0,(FV('Sources of Funds'!$G$32/12,12*AQ7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AQ39=0,0,(FV('Sources of Funds'!$G$32/12,12*AR7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AR39=0,0,(FV('Sources of Funds'!$G$32/12,12*AS7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AS39=0,0,(FV('Sources of Funds'!$G$32/12,12*AT7,'Sources of Funds'!$K$32/12,'Sources of Funds'!$E$32*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A33","v":"CHFA 1st Mortg. Loan [ Non-Bond Proceeds ]"},null,null,{"$f":"'Sources of Funds'!E33","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K33","v":0},{"$f":"G41","v":0},{"$f":"H41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F33","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G41=0),\"n/a\",G$27/(G$41+G37+G33))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H41=0),\"n/a\",H$27/(H$41+H37+H33))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G33","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$41=0,0,(FV('Sources of Funds'!$G$33/12,12,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(G43=0,0,(FV('Sources of Funds'!$G$33/12,12*H7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(H43=0,0,(FV('Sources of Funds'!$G$33/12,12*I7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(I43=0,0,(FV('Sources of Funds'!$G$33/12,12*J7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(J43=0,0,(FV('Sources of Funds'!$G$33/12,12*K7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(K43=0,0,(FV('Sources of Funds'!$G$33/12,12*L7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(L43=0,0,(FV('Sources of Funds'!$G$33/12,12*M7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(M43=0,0,(FV('Sources of Funds'!$G$33/12,12*N7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(N43=0,0,(FV('Sources of Funds'!$G$33/12,12*O7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(O43=0,0,(FV('Sources of Funds'!$G$33/12,12*P7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(P43=0,0,(FV('Sources of Funds'!$G$33/12,12*Q7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(Q43=0,0,(FV('Sources of Funds'!$G$33/12,12*R7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(R43=0,0,(FV('Sources of Funds'!$G$33/12,12*S7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(S43=0,0,(FV('Sources of Funds'!$G$33/12,12*T7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(T43=0,0,(FV('Sources of Funds'!$G$33/12,12*U7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(U43=0,0,(FV('Sources of Funds'!$G$33/12,12*V7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(V43=0,0,(FV('Sources of Funds'!$G$33/12,12*W7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(W43=0,0,(FV('Sources of Funds'!$G$33/12,12*X7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(X43=0,0,(FV('Sources of Funds'!$G$33/12,12*Y7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(Y43=0,0,(FV('Sources of Funds'!$G$33/12,12*Z7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(Z43=0,0,(FV('Sources of Funds'!$G$33/12,12*AA7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AA43=0,0,(FV('Sources of Funds'!$G$33/12,12*AB7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AB43=0,0,(FV('Sources of Funds'!$G$33/12,12*AC7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AC43=0,0,(FV('Sources of Funds'!$G$33/12,12*AD7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AD43=0,0,(FV('Sources of Funds'!$G$33/12,12*AE7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AE43=0,0,(FV('Sources of Funds'!$G$33/12,12*AF7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AF43=0,0,(FV('Sources of Funds'!$G$33/12,12*AG7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AG43=0,0,(FV('Sources of Funds'!$G$33/12,12*AH7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AH43=0,0,(FV('Sources of Funds'!$G$33/12,12*AI7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AI43=0,0,(FV('Sources of Funds'!$G$33/12,12*AJ7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AJ43=0,0,(FV('Sources of Funds'!$G$33/12,12*AK7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AK43=0,0,(FV('Sources of Funds'!$G$33/12,12*AL7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AL43=0,0,(FV('Sources of Funds'!$G$33/12,12*AM7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AM43=0,0,(FV('Sources of Funds'!$G$33/12,12*AN7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AN43=0,0,(FV('Sources of Funds'!$G$33/12,12*AO7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AO43=0,0,(FV('Sources of Funds'!$G$33/12,12*AP7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AP43=0,0,(FV('Sources of Funds'!$G$33/12,12*AQ7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AQ43=0,0,(FV('Sources of Funds'!$G$33/12,12*AR7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AR43=0,0,(FV('Sources of Funds'!$G$33/12,12*AS7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AS43=0,0,(FV('Sources of Funds'!$G$33/12,12*AT7,'Sources of Funds'!$K$33/12,'Sources of Funds'!$E$33*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A34","v":"CHFA Next Steps Funds"},null,null,{"$f":"'Sources of Funds'!E34","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K34","v":0},{"$f":"G45","v":0},{"$f":"H45","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F34","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G45=0),\"n/a\",G$27/(G$33+G45+G37+G41))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H45=0),\"n/a\",H$27/(H$33+H45+H37+H41))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G34","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF($D$45=0,0,(FV('Sources of Funds'!$G$34/12,12,'Sources of Funds'!$K$34/12,'Sources of Funds'!$E$34*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A35","v":"DOH / HUD HOME Funds"},null,null,{"$f":"'Sources of Funds'!E35","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K35","v":0},{"$f":"G49","v":0},{"$f":"H49","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F35","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G49=0),\"n/a\",G$27/(G$33+G49+G45+G41+G37))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H49=0),\"n/a\",H$27/(H$33+H49+H45+H41+H37))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G35","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$49=0,0,(FV('Sources of Funds'!$G$35/12,12,'Sources of Funds'!$K$35/12,'Sources of Funds'!$E$35*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A36","v":"DOH Affordable Housing Program - FLEX"},null,null,{"$f":"'Sources of Funds'!E36","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K36","v":0},{"$f":"G53","v":0},{"$f":"H53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F36","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G53=0),\"n/a\",G$27/(G$33+G53+G49+G45+G41+G37))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H53=0),\"n/a\",H$27/(H$33+H53+H49+H45+H41+H37))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G36","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$53=0,0,(FV('Sources of Funds'!$G$36/12,12,'Sources of Funds'!$K$36/12,'Sources of Funds'!$E$36*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A37","v":"DOH Housing Trust Fund"},null,null,{"$f":"'Sources of Funds'!E37","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K37","v":0},{"$f":"G57","v":0},{"$f":"H57","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F37","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G57=0),\"n/a\",G$27/(G$33+G57+G53+G49+G45+G41+G37))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H57=0),\"n/a\",H$27/(H$33+H57+H53+H49+H45+H41+H37))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G37","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$57=0,0,(FV('Sources of Funds'!$G$37/12,12,'Sources of Funds'!$K$37/12,'Sources of Funds'!$E$37*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A38","v":"DOH / HUD CDBG Small Cities Funds"},null,null,{"$f":"'Sources of Funds'!E38","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K38","v":0},{"$f":"G61","v":0},{"$f":"H61","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F38","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G61=0),\"n/a\",G$27/(G$33+G57+G53+G49+G45+G41+G37))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H61=0),\"n/a\",H$27/(H$33+H57+H53+H49+H45+H41+H37))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G38","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$61=0,0,(FV('Sources of Funds'!$G$38/12,12,'Sources of Funds'!$K$38/12,'Sources of Funds'!$E$38*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A39","v":"DOH $300MM Housing Portfolio"},null,null,{"$f":"'Sources of Funds'!E39","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K39","v":0},{"$f":"G65","v":0},{"$f":"H65","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F39","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G65=0),\"n/a\",G$27/(G$33+G61+G57+G65+G53+G49+G45+G41+G37))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H65=0),\"n/a\",H$27/(H$33+H61+H57+H65+H53+H49+H45+H41+H37))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G39","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$65=0,0,(FV('Sources of Funds'!$G$39/12,12,'Sources of Funds'!$K$39/12,'Sources of Funds'!$E$39*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A40","v":"Other Amortizing Debt [ Specify ]"},null,null,{"$f":"'Sources of Funds'!E40","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K40","v":0},{"$f":"G69","v":0},{"$f":"H69","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F40","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G69=0),\"n/a\",G$27/(G$33+G69+G65+G61+G57+G53+G49+G45+G41+G37))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H69=0),\"n/a\",H$27/(H$33+H69+H65+H61+H57+H53+H49+H45+H41+H37))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G40","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$69=0,0,(FV('Sources of Funds'!$G$40/12,12,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(G71=0,0,(FV('Sources of Funds'!$G$40/12,12*H7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(H71=0,0,(FV('Sources of Funds'!$G$40/12,12*I7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(I71=0,0,(FV('Sources of Funds'!$G$40/12,12*J7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(J71=0,0,(FV('Sources of Funds'!$G$40/12,12*K7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(K71=0,0,(FV('Sources of Funds'!$G$40/12,12*L7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(L71=0,0,(FV('Sources of Funds'!$G$40/12,12*M7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(M71=0,0,(FV('Sources of Funds'!$G$40/12,12*N7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(N71=0,0,(FV('Sources of Funds'!$G$40/12,12*O7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(O71=0,0,(FV('Sources of Funds'!$G$40/12,12*P7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(P71=0,0,(FV('Sources of Funds'!$G$40/12,12*Q7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(Q71=0,0,(FV('Sources of Funds'!$G$40/12,12*R7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(R71=0,0,(FV('Sources of Funds'!$G$40/12,12*S7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(S71=0,0,(FV('Sources of Funds'!$G$40/12,12*T7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(T71=0,0,(FV('Sources of Funds'!$G$40/12,12*U7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(U71=0,0,(FV('Sources of Funds'!$G$40/12,12*V7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(V71=0,0,(FV('Sources of Funds'!$G$40/12,12*W7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(W71=0,0,(FV('Sources of Funds'!$G$40/12,12*X7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(X71=0,0,(FV('Sources of Funds'!$G$40/12,12*Y7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(Y71=0,0,(FV('Sources of Funds'!$G$40/12,12*Z7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(Z71=0,0,(FV('Sources of Funds'!$G$40/12,12*AA7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AA71=0,0,(FV('Sources of Funds'!$G$40/12,12*AB7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AB71=0,0,(FV('Sources of Funds'!$G$40/12,12*AC7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AC71=0,0,(FV('Sources of Funds'!$G$40/12,12*AD7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AD71=0,0,(FV('Sources of Funds'!$G$40/12,12*AE7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AE71=0,0,(FV('Sources of Funds'!$G$40/12,12*AF7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AF71=0,0,(FV('Sources of Funds'!$G$40/12,12*AG7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AG71=0,0,(FV('Sources of Funds'!$G$40/12,12*AH7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AH71=0,0,(FV('Sources of Funds'!$G$40/12,12*AI7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AI71=0,0,(FV('Sources of Funds'!$G$40/12,12*AJ7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AJ71=0,0,(FV('Sources of Funds'!$G$40/12,12*AK7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AK71=0,0,(FV('Sources of Funds'!$G$40/12,12*AL7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AL71=0,0,(FV('Sources of Funds'!$G$40/12,12*AM7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AM71=0,0,(FV('Sources of Funds'!$G$40/12,12*AN7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AN71=0,0,(FV('Sources of Funds'!$G$40/12,12*AO7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AO71=0,0,(FV('Sources of Funds'!$G$40/12,12*AP7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AP71=0,0,(FV('Sources of Funds'!$G$40/12,12*AQ7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AQ71=0,0,(FV('Sources of Funds'!$G$40/12,12*AR7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AR71=0,0,(FV('Sources of Funds'!$G$40/12,12*AS7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF(AS71=0,0,(FV('Sources of Funds'!$G$40/12,12*AT7,'Sources of Funds'!$K$40/12,'Sources of Funds'!$E$40*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A41","v":"Other Amortizing Debt [ Specify ]"},null,null,{"$f":"'Sources of Funds'!E41","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K41","v":0},{"$f":"G73","v":0},{"$f":"H73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F41","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G73=0),\"n/a\",G$27/(G$33+G73+G69+G65+G61+G57+G53+G49+G45+G41+G37))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H73=0),\"n/a\",H$27/(H$33+H73+H69+H65+H61+H57+H53+H49+H45+H41+H37))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G41","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$73=0,0,(FV('Sources of Funds'!$G$41/12,12,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(G75=0,0,(FV('Sources of Funds'!$G$41/12,12*H7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(H75=0,0,(FV('Sources of Funds'!$G$41/12,12*I7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(I75=0,0,(FV('Sources of Funds'!$G$41/12,12*J7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(J75=0,0,(FV('Sources of Funds'!$G$41/12,12*K7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(K75=0,0,(FV('Sources of Funds'!$G$41/12,12*L7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(L75=0,0,(FV('Sources of Funds'!$G$41/12,12*M7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(M75=0,0,(FV('Sources of Funds'!$G$41/12,12*N7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(N75=0,0,(FV('Sources of Funds'!$G$41/12,12*O7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(O75=0,0,(FV('Sources of Funds'!$G$41/12,12*P7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(P75=0,0,(FV('Sources of Funds'!$G$41/12,12*Q7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(Q75=0,0,(FV('Sources of Funds'!$G$41/12,12*R7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(R75=0,0,(FV('Sources of Funds'!$G$41/12,12*S7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(S75=0,0,(FV('Sources of Funds'!$G$41/12,12*T7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(T75=0,0,(FV('Sources of Funds'!$G$41/12,12*U7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(U75=0,0,(FV('Sources of Funds'!$G$41/12,12*V7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(V75=0,0,(FV('Sources of Funds'!$G$41/12,12*W7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(W75=0,0,(FV('Sources of Funds'!$G$41/12,12*X7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(X75=0,0,(FV('Sources of Funds'!$G$41/12,12*Y7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(Y75=0,0,(FV('Sources of Funds'!$G$41/12,12*Z7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(Z75=0,0,(FV('Sources of Funds'!$G$41/12,12*AA7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AA75=0,0,(FV('Sources of Funds'!$G$41/12,12*AB7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AB75=0,0,(FV('Sources of Funds'!$G$41/12,12*AC7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AC75=0,0,(FV('Sources of Funds'!$G$41/12,12*AD7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AD75=0,0,(FV('Sources of Funds'!$G$41/12,12*AE7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AE75=0,0,(FV('Sources of Funds'!$G$41/12,12*AF7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AF75=0,0,(FV('Sources of Funds'!$G$41/12,12*AG7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AG75=0,0,(FV('Sources of Funds'!$G$41/12,12*AH7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AH75=0,0,(FV('Sources of Funds'!$G$41/12,12*AI7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AI75=0,0,(FV('Sources of Funds'!$G$41/12,12*AJ7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AJ75=0,0,(FV('Sources of Funds'!$G$41/12,12*AK7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AK75=0,0,(FV('Sources of Funds'!$G$41/12,12*AL7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AL75=0,0,(FV('Sources of Funds'!$G$41/12,12*AM7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AM75=0,0,(FV('Sources of Funds'!$G$41/12,12*AN7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AN75=0,0,(FV('Sources of Funds'!$G$41/12,12*AO7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AO75=0,0,(FV('Sources of Funds'!$G$41/12,12*AP7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AP75=0,0,(FV('Sources of Funds'!$G$41/12,12*AQ7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AQ75=0,0,(FV('Sources of Funds'!$G$41/12,12*AR7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AR75=0,0,(FV('Sources of Funds'!$G$41/12,12*AS7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AS75=0,0,(FV('Sources of Funds'!$G$41/12,12*AT7,'Sources of Funds'!$K$41/12,'Sources of Funds'!$E$41*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A42","v":"Other [ Specify ]"},null,null,{"$f":"'Sources of Funds'!E42","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K42","v":0},{"$f":"G77","v":0},{"$f":"H77","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F42","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G77=0),\"n/a\",G$27/(G$33+G77+G73+G69+G65+G61+G57+G53+G49+G45+G41+G37))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H77=0),\"n/a\",H$27/(H$33+H77+H73+H69+H65+H61+H57+H53+H49+H45+H41+H37))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G42","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$42/12,12,'Sources of Funds'!$K$42/12,'Sources of Funds'!$E$42*-1)))","v":0}]
[]
[{"$f":"'Sources of Funds'!A43","v":"Other [ Specify ]"},null,null,{"$f":"'Sources of Funds'!E43","v":0},"Pay Rate ADS",null,{"$f":"'Sources of Funds'!K43","v":0},{"$f":"G81","v":0},{"$f":"H81","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Term (Yrs.) > ",{"$f":"'Sources of Funds'!F43","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G81=0),\"n/a\",G$27/(G$33+G81+G77+G73+G69+G65+G61+G57+G53+G49+G45+G41+G37))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H81=0),\"n/a\",H$27/(H$33+H81+H77+H73+H69+H65+H61+H57+H53+H49+H45+H41+H37))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"Contract Rate > ",{"$f":"'Sources of Funds'!G43","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$77=0,0,(FV('Sources of Funds'!$G$43/12,12,'Sources of Funds'!$K$43/12,'Sources of Funds'!$E$43*-1)))","v":0}]
[]
[null,null,null,null,"ADS STOT. =",null,{"$f":"G33+G37+G41+G45+G49+G53+G57+G61+G65+G69+G73+G77+G81","v":0},{"$f":"H33+H37+H41+H45+H49+H53+H57+H61+H65+H69+H73+H77+H81","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"     CASH FLOW AFTER DEBT SERVICE (CFADS)",null,{"$f":"ROUND(G27-G85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"PROJECT DSC =",null,{"$f":"IF(OR(G27<=0,G85<=0),0,G27/G85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"EFFECTIVE DSC (w/Op-DSC Reserve) ",null,{"$f":"G102","v":"n/a"},{"$f":"H102","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["OPERATING / DEBT SERVICE / COVERAGE RESERVE"]
[]
["CHFA Financing Reserve",null,"NPV's",null,"Project Actual DSC >  ",null,{"$f":"G$88","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"For 1.0 DSC  ",{"$f":"NPV(E$96,G$95:U$95)","v":0},null,"BALANCE (B.O.Y.)",null,{"$f":"C96","v":0},{"$f":"G98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"For 1.0 - 1.15 DSC  ",{"$f":"NPV(E$96,G$99:U$99)","v":0},null,"OUTFLOWS (for 1.00 DSC)",null,{"$f":"IF(G27<0,G27*-1,IF(AND(G$85>0,G$88<1),G$85-G$27,0))","v":0},{"$f":"IF(H27<0,H27*-1,IF(AND(H$85>0,H$88<1),H$85-H$27,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL RESERVE  ",{"$f":"C94+C95","v":0},null,0.05,null,{"$f":"IF(G95>0,ROUND((G94-(G95/2)+(G97))*($E96),0),ROUND((G94+G97)*$E96,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Paid INTO Reserve",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Supportive Housing Reserve",null,"NPV's",null,"BALANCE (E.O.Y.)",null,{"$f":"(G94-G95)+SUM(G96,G97)","v":0},{"$f":"(H94-H95)+SUM(H96,H97)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"For 1.0 DSC  ",{"$f":"NPV(E$96,G$95:U$95)","v":0},null,"Economic Coverage (1.00  to 1.15 DSC)",null,{"$f":"IF(G27<=0,0,IF(G$88>1.15,0,IF(AND(G$88<1.15,G$88>1),(G$85*1.15)-(G$85*G$88),IF(G$88<1,(G$85*1.15)-G$85,0))))","v":0},{"$f":"IF(H27<=0,0,IF(H$88>1.15,0,IF(AND(H$88<1.15,H$88>1),(H$85*1.15)-(H$85*H$88),IF(H$88<1,(H$85*1.15)-H$85,0))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"For 1.0 - 1.05 DSC  ",{"$f":"NPV(E$96,G$100:U$100)","v":0},null,"Economic Coverage (1.00  to 1.05 DSC)",null,{"$f":"IF(G27<=0,0,IF(G$88>1.05,0,IF(AND(G$88<1.05,G$88>1),(G$85*1.05)-(G$85*G$88),IF(G$88<1,(G$85*1.05)-G$85,0))))","v":0},{"$f":"IF(H27<=0,0,IF(H$88>1.05,0,IF(AND(H$88<1.05,H$88>1),(H$85*1.05)-(H$85*H$88),IF(H$88<1,(H$85*1.05)-H$85,0))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL RESERVE  ",{"$f":"C99+C100","v":0},null,"EFFECTIVE NOI  ",null,{"$f":"IF(AND(G85=0,G27<0),0,IF(G$88>1.15,G$27,G$27+G95+G99))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(AA85=0,AA27<0),0,IF(AA$88>1.15,AA$27,AA$27+AA95))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"EFFECTIVE DSC  ",null,{"$f":"IF(OR(G101=0,G85=0),\"n/a\",G101/G85)","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]

{"sheet":"Sources of Funds","index":8,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,0,1,12],[4,8,4,10],[11,6,11,12],[12,6,12,12],[9,6,9,12],[10,6,10,12],[2,0,2,12],[4,2,4,5],[42,11,42,12],[32,11,32,12],[33,11,33,12],[35,11,35,12],[37,11,37,12],[34,11,34,12],[22,6,22,12],[41,11,41,12],[13,6,13,12],[21,6,21,12],[14,6,14,12],[36,11,36,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[30,11,30,12],[23,6,23,12],[31,11,31,12],[27,11,27,12]]}
[]
["Exhibit 4.8- SOURCES OF FUNDS"]
[]
[]
["DEVELOPMENT NAME",null,{"$f":"Application!D50","v":0},null,null,null,null,"APPLICANT",{"$f":"Application!D10","v":0}]
[]
[null,null,"Construction",null,"Permanent","Grant "]
["EQUITY CAPITAL, GRANTS, Etc.",null,"Sources",null,"Sources","[Y] or [N]"]
[]
["DOH / HUD HOME Funds"]
["DOH Affordable Housing Program - FLEX"]
["DOH Housing Trust Fund"]
["DOH / HUD CDBG Small Cities Funds"]
["DOH $300MM Housing Portfolio"]
["Other Public Funds [ Specify ]"]
["Federal LIHTC Net Proceeds",null,null,null,null,"N/A"]
["Federal Historic Tax Credit Net Proceeds",null,null,null,null,"N/A"]
["State Historic Tax Credit Net Proceeds",null,null,null,null,"N/A"]
["CT HTCC Tax Credit Proceeds",null,null,null,null,"N/A"]
["Developer / Investor Cash Equity",null,null,null,null,"N/A"]
["Deferred Developer Fee",null,null,null,null,"N/A"]
["Homeownership Sales Proceeds"]
["Other [ Specify ]"]
["Other [ Specify ]"]
["Sub-Total",null,{"$f":"SUM(C10:C24)","v":0},null,{"$f":"SUM(E10:E24)","v":0}]
[]
[null,null,"Construction",null,"Permanent","Perm.","Perm.","Const.","Fully","Deferred","Scheduled"]
[null,null,"Sources",null,"Sources","Loan ","Interest","Interest","Amortizing","PMT Loan","Debt","Financing Notes"]
["FINANCING  [Sources w/ Notes and Mortgages ]",null,null,null,null,"Amort. [Yrs.]","Rate","Rate","[Y] or [N]","[Y] or [N]","Service"]
[]
["CHFA Loan 1st Mortg. Loan [ Tax-Exempt Bonds ]",null,null,null,null,null,null,null,null,"N/A",{"$f":"IF(E31=0,0,(PMT(G31/12,F31*12,E31*-1,0))*12)","v":0}]
["CHFA 1st Mortg. Loan [ Taxable Bonds ]",null,null,null,null,null,null,null,null,"N/A",{"$f":"IF(E32=0,0,(PMT(G32/12,F32*12,E32*-1,0))*12)","v":0}]
["CHFA 1st Mortg. Loan [ Non-Bond Proceeds ]",null,null,null,null,null,null,null,null,"N/A",0]
["CHFA Next Steps Funds",null,null,null,null,null,null,null,null,null,{"$f":"IF(E34=0,0,(PMT(G34/12,F34*12,E34*-1,0))*12)","v":0}]
["DOH / HUD HOME Funds",null,null,null,null,null,null,null,null,null,0]
["DOH Affordable Housing Program - FLEX",null,null,null,null,null,null,null,null,null,0]
["DOH Housing Trust Fund",null,null,null,null,null,null,null,null,null,0]
["DOH / HUD CDBG Small Cities Funds",null,null,null,null,null,null,null,null,null,0]
["DOH $300MM Housing Portfolio",null,null,null,null,null,null,null,null,null,0]
["Other Amortizing Debt [ Specify ]",null,null,null,null,null,null,null,null,null,0]
["Other Amortizing Debt [ Specify ]",null,null,null,null,null,null,null,null,null,0]
["Other [ Specify ]",null,null,null,null,null,null,null,null,null,0]
["Other [ Specify ]",null,null,null,null,null,null,null,null,null,0]
["Sub-Total",null,{"$f":"SUM(C31:C43)","v":0},null,{"$f":"SUM(E31:E43)","v":0},null,null,null,null,"Total Scheduled Debt Service",{"$f":"SUM(K31:K43)","v":0}]
[]
["TOTAL Sources",null,{"$f":"C25+C44","v":0},null,{"$f":"E25+E44","v":0}]
["Total Development Budget",null,{"$f":"E47","v":0},null,{"$f":"DEVBGT!D75","v":0}]
["Sources LESS Uses",null,{"$f":"C46-C47","v":0},null,{"$f":"E46-E47","v":0}]
[]
["GRANTS: 3rd party sources for which no repayment is expected or required from other sources.  Soft Debt: 3rd party sources secured by a mortgage and which may require partial or full repayment"]
["(with or without interest) are considered financing and should be scheduled under the FINANCING section above. "]
[]
["Intra-Entity ( LP, LLC, etc. ) loans to be repaid from approved Owner's Distributions are considered Developer / Investor Cash Equity."]
[]
["Deferred/Pledged Developer Fees (\"DDF\") are considered cash equity contributions.  For transactions utilizing federal Low-Income Housing Tax Credits,  "]
["the amount of the DDF will be limited to a maximum of that which could be fully amortized from permitted Owner's Distributions at the Long-Term Applicable  Federal Rate within the first ten (10) "]
["years of operations.   CHFA, at its sole discretion, may approve a DDF for less than the permitted maximum."]
[]
["For construction / interim sources not fully converting to permanent sources, provide information on proposed permanent \"paydown\" source/s including estimated paydown amount/s "]
["and specific paydown terms and conditions as may be applicable."]

{"sheet":"Sworn Cert","index":9,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[42,0,42,5],[42,7,42,8],[43,7,43,8],[32,0,32,5],[32,7,32,9],[35,4,35,5],[38,2,38,10],[39,2,39,10],[40,0,40,5],[27,0,27,4],[27,6,27,8],[30,0,30,4],[30,7,30,9],[21,2,21,10],[25,0,25,4],[23,2,23,10],[11,2,11,10],[13,2,13,10],[17,2,17,10],[19,2,19,10],[1,0,1,11],[6,0,6,11],[8,1,8,10],[4,2,4,4],[4,7,4,9],[2,0,2,11]]}
[null,null,null," "]
["SWORN CERTIFICATE OF NON-DISPLACEMENT"]
[]
[]
[null,"DEVELOPMENT NAME",0,null,null,null,"APPLICANT",0]
[]
["SWORN CERTIFICATION OF NONDISPLACEMENT/NO LOSS OF UNITS IN LIEU OF RESIDENTIAL ANTIDISPLACEMENT AND RELOCATION PLAN – VACANT LAND OR VACANT BUILDINGS WITH SAME NUMBER OF RESIDENTIAL UNITS OR OWNER-OCCUPIED SINGLE FAMILY ACCESSIBILITY MODIFICATIONS"]
[]
[null,"I have read the requirements of the Federal Uniform Relocation Assistance and Real Property Acquisition Policies Act of 1970, as amended (URA) and Section 104 (d) of the Housing and Community Development Act of 1974, as amended (Barney Frank) and (CGS Chapter 135, Uniform Relocation Assistance Act) ; and having been duly sworn, do hereby certify that:"]
[null,"Check off all provisions that apply:"]
[]
["1.",null,"Because the proposed housing will be developed on completely vacant land, that has no active businesses, farm operations or nonprofit uses, the development will not cause any temporary or permanent displacement."]
[]
["2.",null,"Because the proposed housing will be developed in completely vacant structures, which have been vacant for at least one year prior to any contact with the Department of Economic and Community Development and/or the Connecticut Housing Finance Authority and which contain no active businesses, farm operations or nonprofit uses, the development will not cause any temporary or permanent displacement."]
[]
["3.",null,"There will be no demolition of residential units or portions of residential units."]
[]
["4.",null,"There will be no conversion of residential units to uses other than lower income dwelling units.  (“Other non-residential uses” includes emergency shelters.)"]
[]
["5.",null,"All occupied and vacant occupiable lower income dwelling units that are demolished or converted to other uses shall be replaced on a one-for-one basis with comparable lower income dwelling units.  If Section 104(d) applies: “Occupiable” is defined as occupied at any time (except by squatters) within a 3-month period prior to execution of a contract for demolition or rehabilitation; a unit in standard condition; or a substandard unit that is suitable for rehabilitation.  Replacement units shall meet federal requirements at 42.375(b) (1)-(5) of 24 CFR Part 42, effective 11/4/96."]
[]
["6.",null,"Because funds are being used to assist owner-occupied single family homeowners in making accessibility modifications to their premises, there shall be no displacement or loss of units."]
[]
["7.",null,"The project for which State assistance is provided will not cause the temporary or permanent displacement of persons and families residing in any single-family or multifamily dwelling.  "]
[]
[]
["Signature"]
[]
["Title",null,null,null,null,null,null,"Date"]
[]
["Sworn and subscribed before me this",null,null,null,null,null,"day of ","_______________, 20___."]
[]
[]
["Commissioner of the Superior Court/Notary Public",null,null,null,null,null,null,"  Official Stamp (Notary)"]
[]
["My Commission Expires on: "]
[]
["Relocation Plan Required: "]
[null,null,"I am unable to certify to the above, and I understand that a Relocation Plan will therefore be a required submission."]
[null,null,"In addition, in accordance with CGS 8-37z, the project for which State assistance is provided will cause only the minimum level of such displacement which cannot be avoided due to the nature of the project.  Attached for CHFA review and DECD review and approval are a relocation summary and an explanation of why relocation cannot be avoided and how it is being kept to the minimum levels."]
[]
["Signature"]
[]
["Title",null,null,null,null,null,null,"Date"]

{"sheet":"Fin Asst Wksht","index":10,"n_rows":111,"n_cols":20,"rows_kept":111,"cut":false,"hidden":false,"merged":[[3,2,3,10],[4,2,4,4],[12,0,12,10],[8,2,8,10],[9,2,9,4],[9,8,9,10],[4,8,4,10],[62,5,62,6],[62,9,62,10],[46,0,46,4],[47,7,47,8],[49,7,49,8],[51,7,51,8],[53,7,53,8],[58,0,58,8],[61,5,61,6],[84,7,84,8],[72,5,72,6],[72,9,72,10],[74,9,74,10],[76,9,76,10],[79,5,79,6],[80,5,80,6],[110,8,110,10],[104,4,104,5],[106,0,107,6],[106,8,107,10],[90,0,90,4],[90,7,90,8],[108,8,108,10],[109,0,109,6],[109,8,109,10],[95,0,95,10],[88,0,88,6],[88,7,88,8],[88,9,88,10],[85,0,85,10],[86,0,86,10],[0,0,0,10],[60,9,60,10],[61,9,61,10],[37,0,37,10],[44,2,44,5],[44,7,44,8],[40,7,40,8],[38,7,38,8],[41,7,41,8],[42,7,42,8],[18,1,18,2],[18,5,18,7],[39,7,39,8],[13,0,13,10],[14,0,14,10],[3,0,3,1],[64,5,64,6],[64,9,64,10],[66,5,66,6],[66,9,66,10],[68,5,68,6],[68,9,68,10]]}
["FINANCIAL Assistance Worksheet"]
[]
["Section 1. Borrower Information "]
["Borrower Name:"]
["Phone Number:",null,null,null,null,null,"Fax Number:"]
[]
["Section 2. Development Description"]
[]
["Development Name:"]
["CHFA Number(s):",null,null,null,null,null,"State Number(s):"]
[]
["Work Items - List below all work that needs to be performed:"]
[]
[]
[]
[]
[]
["Estimated Cost of this Rehab Project:"]
["Hard:",null,null,null,"Soft:",null,null,null,null,"Total:",""]
[]
[]
[null,null,null,"To be Rehabilitated",null,"Total"]
[]
["Number of Units:"]
[null,null,null,null,null,null,null,"Amount of Last"]
["Base Rents:",null,null,null,null,null,null,"Base Rent Increase:"]
[]
[null,null,null,null,null,null,null,"Effective Date:"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Amount of"]
["% of Income used for rent determination:",null,null,null,null,"Last % Increase:",null,null,null,"Effective Date:"]
[]
["Section 3. Development Reserves"]
["The 2830 account information for the following section can be found on the Liabilities and Equities page of the balance sheet."]
["Balance Sheet Dated:",null,null,null,null,null,null,"All Units",null,null,"Per Unit"]
["Enter amount reflected in Acct. #2830.4 RM & R:",null,null,null,null,null,null,null,null,null,""]
["Plus:  Acct. #2830 Unapp. Retained Earnings Balance",null,null,null,null,null,"             +",null,null,null,""]
["Plus or Minus:  Acct. #2830.1 Income & Expense Clearance",null,null,null,null,null,"             +",null,null,null,""]
["Plus or Minus:  Acct. #2830.5 APTS",null,null,null,null,null,"             +",null,null,null,""]
[]
[null,null,"Total Reserves Available:",null,null,null,"             =","",null,null,""]
[]
["Less:  CHFA Minimum RM&R Requirement P/U"]
["Elderly: $1,000:",null,null,"Family: $1,500:",null,null,"  -","",null,null,"",null,null,null,null,null,null,null,null,1]
[]
[null,null,"Available Balance (prior to rehab project):",null,null,null," =","",null,null,""]
[]
["Less:  Estimated Total Rehab Project Cost",null,null,null,null,null,"              -","",null,null,""]
[]
[null,null,"Net Available Balance(after rehab project):",null,null,null,"             =","",null,null,""]
[null,null,null,null,null," "]
["Financial Assistance Worksheet"]
["Page 2"]
[]
["Average Use of Reserves and Potential Growth to Savings/Reserve:"]
[]
[null,null,null,null,null,null,null,null,null,"Net Result of Operations"]
[null,"Year Ended",null,"Provision",null,"Expended",null,null,null,"(Operating Gain or Loss from Fin. Stmts.)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Avg.","",null,null,null,""]
[]
["Current Year Reserves:"]
[]
["Annual Provision from Management Plan Dated:  "]
[]
["Estimate of on-going usages, based on past 3yr analysis:",null,null,null,null,null,null,null,null,""]
[]
["Estimated amount added to Savings/Reserve:",null,null,null,null,null,null,null,null,""]
[]
["Section 4. For Elderly Only:"]
[null,"Current RAP:"]
[null,"Projected RAP with rent increase:"]
[]
["Section 5. Miscellaneous:"]
[]
["Outstanding Findings - from Audit Period - Date Ending:"]
[]
[]
[]
["Comprehensive Physical Needs Assessment Schedule Date:"]
[]
["Comprehensive Physical Needs Assessment Date:"]
[]
["The rehab work requested has been reviewed by staff and falls into the following category:"]
[]
["Section 5. Staff Recommendations"]
["CHFA staff will determine if a loan can be supported through the normal underwriting process.  DECD may provide a grant only after DECD determines that there is no probability that a deferred loan would be repaid by future operating funds, refinancing, or sale in accordance with exisitng statutes."]
[]
["Project Costs",null,null,""]
["Reserves"]
["Other Funds:"]
["Loan Amount:",null,null,null,null,"Rate:",null,null,null,"Term:"]
["Grant Amount:",null,null,""]
[]
[]
["Required Rent Adjustments:",null,null,null,"Rent Increase:",null,null,null,null,"% Increase:"]
[]
[]
[]
["CHFA  Asset Manager/Reviewer",null,null,null,null,null,null,null,"Date"]
[]
["CHFA  Administrator",null,null,null,null,null,null,null,"Date"]