{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Exhibit Checklist","Application","2.1 Dev Team Info","3.7 Development Schedule","3.14 Sworn Cert","3.16 Fincl Asst Wksht","4.1 Rental Income Calc Wrksht","4.2 Exploded Trade Breakdown","4.3 Estmd Development Budget","4.4 Cash Flow Projection","4.8 Sources of Funds"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":22,"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":[[2,0,2,2],[30,0,31,0]]}
[]
[]
["WORKBOOK INSTRUCTIONS"]
[]
[]
["Security/Macros:","This Consolidated Application (Short Version) 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."]
[]
["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.7 Development Schedule.  All income and expenses should be stabilized year projections."]

{"sheet":"Exhibit Checklist","index":1,"n_rows":44,"n_cols":20,"rows_kept":44,"cut":false,"hidden":false,"merged":[[16,10,16,11],[43,10,43,11],[41,10,41,11],[42,10,42,11],[18,10,18,11],[20,10,20,11],[24,10,24,11],[38,10,38,11],[40,10,40,11],[21,10,21,11],[22,10,22,11],[33,10,33,11],[34,10,34,11],[35,10,35,11],[36,10,36,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],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[32,10,32,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.1: 4/14\n"]
["EXHIBIT CHECKLIST"]
[]
[]
[]
[null,null,null,null,null,"DEVELOPMENT NAME",{"$f":"IF(ISBLANK(Application!D49), \"\", Application!D49)","v":""},null,null,null,null,null,null,null,"APPLICANT",null,{"$f":"IF(ISBLANK(Application!D11), \"\", Application!D11)","v":""}]
[]
[]
[]
["\"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 Requirements"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.1,"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.15,"Original Loan Background Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.16,"Financial Assistance Worksheet (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,3.17,"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,"Exploded Trade Breakdown (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,4.3,"Estimated Development Budget (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,4.4000000000000004,"Cash Flow Projection","(Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,4.8,"Sources of Funds  (Form Provided)"]
[null,null,null,null,null,null,null,null,null,null,null,null,4.9000000000000004,"Funding Commitment Letters"]

{"sheet":"Application","index":2,"n_rows":259,"n_cols":14,"rows_kept":259,"cut":false,"hidden":false,"merged":[[113,2,113,9],[211,2,211,8],[212,2,212,8],[247,2,247,8],[36,2,36,4],[210,2,210,8],[207,2,207,8],[214,2,214,8],[196,4,197,4],[196,5,197,5],[200,4,200,5],[201,4,201,5],[70,4,70,7],[50,3,50,5],[143,7,143,8],[96,2,96,3],[97,2,97,8],[180,2,180,9],[181,2,181,9],[62,5,62,6],[232,2,232,8],[82,6,82,7],[103,7,103,8],[182,2,182,9],[65,2,65,3],[122,0,122,9],[125,2,125,5],[2,0,2,9],[5,0,5,9],[10,3,10,5],[12,3,12,5],[3,0,3,9],[14,3,14,5],[18,3,18,4],[18,7,18,9],[16,7,16,9],[20,7,20,9],[29,3,29,4],[16,3,16,5],[32,0,32,9],[20,3,20,4],[22,3,22,4],[22,7,22,9],[124,2,124,7],[81,6,81,7],[116,7,116,8],[37,2,37,9],[40,2,40,9],[42,2,42,9],[41,6,41,7],[64,2,64,3],[83,6,83,7],[168,0,168,9],[76,2,76,3],[204,2,204,8],[63,5,63,6],[66,5,66,6],[63,7,63,8],[66,7,66,8],[62,7,62,8],[75,2,75,3],[177,2,177,9],[68,2,68,9],[69,2,69,9],[185,2,185,9],[171,2,171,9],[66,2,66,3],[184,2,184,3],[143,2,143,4],[143,5,143,6],[103,2,103,5],[128,6,128,7],[216,0,216,9],[71,2,71,3],[236,2,236,8],[242,2,242,8],[243,2,243,8],[1,3,1,6],[74,2,74,9],[81,2,81,5],[83,2,83,5],[84,2,84,5],[85,2,85,5],[86,2,86,5],[45,0,45,9],[48,3,48,9],[90,2,90,9],[72,2,72,3],[218,2,218,8],[50,7,50,9],[52,3,52,5],[55,2,55,9],[56,2,56,9],[63,2,63,3],[65,5,65,6],[65,7,65,8],[220,2,220,8],[245,0,245,9],[253,1,253,9],[254,1,254,9],[250,1,250,5],[250,6,250,9],[246,2,246,8],[248,2,248,8],[252,1,252,9],[231,2,231,8],[229,2,229,8],[235,2,235,8],[221,2,221,8],[222,2,222,8],[223,2,223,8],[224,3,224,8],[225,3,225,8],[227,0,227,9],[234,2,234,8],[233,2,233,8],[241,2,241,8],[130,6,130,7],[131,6,131,7],[140,2,140,8],[144,2,144,4],[152,5,152,6],[152,7,152,8],[145,5,145,6],[145,7,145,8],[146,2,146,4],[146,5,146,6],[146,7,146,8],[145,2,145,4],[152,2,152,4],[144,7,144,8],[151,5,151,6],[151,7,151,8],[112,2,112,3],[125,6,125,7],[126,6,126,7],[161,2,161,4],[161,5,161,6],[161,7,161,8],[153,2,153,4],[153,5,153,6],[153,7,153,8],[154,2,154,4],[154,5,154,6],[154,7,154,8],[155,2,155,4],[155,5,155,6],[155,7,155,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],[127,6,127,7],[129,6,129,7],[144,5,144,6],[162,7,162,8],[163,2,163,4],[163,5,163,6],[163,7,163,8],[82,2,82,5],[94,2,94,7],[149,2,149,4],[157,2,157,4],[104,2,104,7],[107,2,107,7],[86,6,86,7],[84,6,84,7],[85,6,85,7],[147,2,147,4],[147,5,147,6],[147,7,147,8],[139,2,139,3],[126,2,126,5],[127,2,127,5],[128,2,128,5],[129,2,129,5],[131,2,131,5],[132,2,132,5],[151,2,151,4],[79,2,79,3],[209,2,209,3],[64,5,64,6],[64,7,64,8],[77,2,77,3],[174,2,174,7],[58,2,60,9],[179,2,179,8],[240,2,240,8],[237,2,237,8],[238,2,238,8],[239,2,239,8],[109,2,109,3],[110,2,110,3],[87,2,87,7],[115,2,115,7],[117,2,117,8],[120,2,120,7],[136,2,136,7],[137,2,137,8],[93,2,93,7],[100,2,100,8],[162,2,162,4],[162,5,162,6]]}
[]
[null,null,null,"State-Sponsored Housing Portfolio"]
[" Application for ",null,null,null,null,null,null,null,null,null,"Version 2.1:  4/10/2014"]
[" 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,"Scope of Work Priorities:  1.) All health, life safety, code and environmental deficiencies, 2.) All exterior envelope deficiencies including but not limited to roofing, siding, exterior doors, and windows, 3.) Mechanical/electrical/plumbing deficiencies, 4.) Energy efficiency investments, 5.) Interior upgrades such as kitchen and bathroom renovations, 6.) All aesthetic issues such as carpeting and painting."]
[]
[]
[]
[null,null,null,null,"Total Units","New Construction",null,"Rehab"]
[null,null,"Total number of units",null,{"$f":"SUM(F64:I64)","v":0}]
[null,null,"Total number of restricted affordable units",null,{"$f":"SUM(F65:I65)","v":0}]
[null,null,"Number of supportive housing units",null,0]
[null,null,"Number of units that are currently in the State-sponsored Housing Portfolio",27,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,null,"Acres"]
[]
[null,3.6,"Zoning Approval Information"]
[null,null,"Please indicate the status of zoning approvals in the chart below: "]
[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,"Yes"]
[null,null,"Special Permits Received",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,"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,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,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.1,"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 Map"]
[null,null,"Is any part of the project site 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.12a","Hazardous Materials Environmental Site Assessment(s)"]
[null,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,"3.12b","Hazardous Materials Survey(s)"]
[null,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 relocation will not be advanced to the borrower until a relocation plan is reviewed and approved by DOH or CHFA.   Funds for temporary relocation and alternative housing costs will be paid for not more than sixty days per family, 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.  Submit as Exhibit 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 Exhibit 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.15,"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 Exhibit 3.15."]
[null,null,"What is the current vacancy rate for your project? "]
[]
[null,3.16,"Financial Assistance Worksheet (Form Provided)"]
[null,null,"Complete Worksheet and submit as Exhibit 3.16."]
[]
[null,3.17,"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 Exhibit 3.17."]
[]
[null,3.18,"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,"Exploded Trade Breakdown (Form Provided)"]
[null,null,"Please complete the form provided.  Attach and label as Exhibit 4.2"]
[]
[null,4.3,"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.   Attach and label as Exhibit 4.3"]
[]
[null,null,"Application Notes:  "]
[null,null,"- soft costs may be no greater than 15% of total development costs.  The \"soft costs\" portion of the Pro Forma for the development shall include a contigency for the removal of underground debris, environmental remediation and site restoration to a \"buildable\" condition, in an amount equal to or exceeding 1.5% of the construction contract amount."]
[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, except for a 4% LIHTC deal that must utilize the CON APP."]
[]
[null,4.4000000000000004,"Cash Flow Projection (Form Provided)"]
[null,null,"The Cash Flow Projection is a combination of self-generated information entered in other sections of the application and from your input into the nine (9) yellow highlighted cells.     Attach and label as Exhibit 4.4"]
[]
[null,4.5,"Financing Request"]
[null,null,null,null,"Construction Funding Amount","Permanent Funding Amount"]
[null,null,null,"DOH HOME ",{"$f":"'4.8 Sources of Funds'!C11+'4.8 Sources of Funds'!C37","v":0},{"$f":"'4.8 Sources of Funds'!E11+'4.8 Sources of Funds'!E37","v":0}]
[null,null,null,"DOH FLEX ",{"$f":"'4.8 Sources of Funds'!C12+'4.8 Sources of Funds'!C38","v":0},{"$f":"'4.8 Sources of Funds'!E12+'4.8 Sources of Funds'!E38","v":0}]
[null,null,null,"DOH CDBG",{"$f":"'4.8 Sources of Funds'!C14+'4.8 Sources of Funds'!C40","v":0},{"$f":"'4.8 Sources of Funds'!E14+'4.8 Sources of Funds'!E40","v":0}]
[]
[null,null,null,"State Hsg Portfolio $300M",{"$f":"'4.8 Sources of Funds'!C15+'4.8 Sources of Funds'!C41","v":0},{"$f":"'4.8 Sources of Funds'!E15+'4.8 Sources of Funds'!E42","v":0}]
[]
[null,4.5999999999999996,"Equity Request"]
[null,null,null,null,"Construction Funding Amount","Permanent Funding Amount"]
[]
[null,null,"Developer Equity",null,{"$f":"'4.8 Sources of Funds'!C21","v":0},{"$f":"'4.8 Sources of Funds'!E21","v":0}]
[]
[null,null,"Total Development  Cost",null,{"$f":"'4.3 Estmd Development Budget'!H86","v":0}]
[null,null,"Total Cost Per Unit",null,{"$f":"E201/E64","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,4.7,"Will Davis Bacon wages and/or Prevailing wages rates be required for this project?  (Respond \"Yes\" if the project anticipates the use of federal funding or state funding that triggers prevailing wages.)  State Prevaling wages must be determined prior to application submission based on CT DOL prevailing wage criteria."]
[]
[null,4.8,"Sources of Funds (Form Provided)"]
[null,null,"Complete the Sources of Funds worksheet and attach as Exhibit 4.8."]
[]
[null,4.9000000000000004,"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.9. "]
[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 in a narrative and attach as 5.1"]
[]
[null,null,"Brings new or vacant units on-line",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,"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."]
[]
[]
[null,"Signature of Authorized Party",null,null,null,null,"Date"]
[]
[]
[null,"Organization"]
[]
[]
[]
[null,null,null," "]

{"sheet":"2.1 Dev Team Info","index":3,"n_rows":171,"n_cols":13,"rows_kept":171,"cut":false,"hidden":false,"merged":[[107,0,107,2],[108,0,108,2],[109,0,109,2],[107,3,107,4],[103,1,103,7],[107,8,107,9],[108,8,108,9],[109,8,109,9],[110,8,110,9],[108,3,108,4],[109,3,109,4],[110,3,110,4],[107,5,107,7],[108,5,108,7],[109,5,109,7],[134,0,134,2],[134,3,134,4],[134,5,134,7],[134,8,134,9],[131,0,131,2],[131,3,131,4],[131,5,131,7],[131,8,131,9],[132,0,132,2],[132,3,132,4],[132,5,132,7],[132,8,132,9],[133,0,133,2],[133,3,133,4],[133,5,133,7],[133,8,133,9],[128,5,128,7],[128,8,128,9],[129,0,129,2],[129,3,129,4],[129,5,129,7],[129,8,129,9],[130,0,130,2],[130,3,130,4],[130,5,130,7],[130,8,130,9],[113,5,113,7],[114,5,114,7],[125,0,125,9],[117,2,117,9],[114,0,114,2],[113,0,113,2],[114,8,114,9],[113,8,113,9],[110,5,110,7],[111,5,111,7],[112,5,112,7],[110,0,110,2],[111,0,111,2],[112,0,112,2],[112,8,112,9],[114,3,114,4],[112,3,112,4],[113,3,113,4],[111,8,111,9],[111,3,111,4],[84,0,84,9],[105,0,105,9],[106,0,106,2],[106,3,106,4],[106,5,106,7],[106,8,106,9],[91,0,91,2],[91,3,91,4],[91,5,91,7],[91,8,91,9],[92,0,92,2],[92,3,92,4],[92,5,92,7],[92,8,92,9],[93,0,93,2],[93,3,93,4],[93,5,93,7],[93,8,93,9],[88,5,88,7],[88,8,88,9],[89,5,89,7],[89,8,89,9],[90,0,90,2],[90,3,90,4],[90,5,90,7],[90,8,90,9],[85,0,85,2],[85,3,85,4],[85,5,85,7],[85,8,85,9],[86,5,86,7],[86,8,86,9],[87,5,87,7],[87,8,87,9],[86,0,86,2],[87,0,87,2],[88,0,88,2],[89,0,89,2],[86,3,86,4],[87,3,87,4],[88,3,88,4],[89,3,89,4],[68,0,68,2],[68,3,68,4],[68,5,68,7],[68,8,68,9],[69,0,69,2],[69,3,69,4],[69,5,69,7],[69,8,69,9],[65,5,65,7],[65,8,65,9],[66,0,66,2],[66,3,66,4],[66,5,66,7],[66,8,66,9],[67,0,67,2],[67,3,67,4],[67,5,67,7],[67,8,67,9],[40,0,40,9],[60,0,60,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],[47,0,47,2],[47,3,47,4],[47,5,47,7],[47,8,47,9],[48,0,48,2],[48,3,48,4],[48,5,48,7],[48,8,48,9],[49,0,49,2],[49,3,49,4],[49,5,49,7],[49,8,49,9],[44,0,44,2],[44,3,44,4],[44,5,44,7],[44,8,44,9],[45,0,45,2],[45,3,45,4],[45,5,45,7],[45,8,45,9],[46,0,46,2],[46,3,46,4],[46,5,46,7],[46,8,46,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],[43,0,43,2],[43,3,43,4],[43,5,43,7],[43,8,43,9],[102,5,102,7],[72,2,72,9],[73,2,73,5],[73,7,73,9],[99,2,99,5],[99,7,99,9],[2,0,2,9],[5,2,5,4],[5,7,5,9],[56,2,56,5],[56,7,56,9],[29,5,29,7],[29,8,29,9],[38,8,38,9],[38,5,38,7],[34,2,34,9],[80,2,80,4],[79,2,79,9],[51,2,51,9],[53,2,53,5],[53,7,53,9],[54,2,54,9],[75,7,75,9],[52,2,52,9],[136,2,136,9],[141,2,141,5],[138,2,138,5],[138,7,138,9],[123,5,123,7],[121,2,121,5],[121,7,121,9],[118,2,118,5],[118,7,118,9],[119,2,119,9],[120,2,120,5],[120,7,120,9],[139,2,139,9],[141,7,141,9],[126,0,126,2],[126,3,126,4],[126,5,126,7],[126,8,126,9],[127,0,127,2],[127,3,127,4],[127,5,127,7],[127,8,127,9],[128,0,128,2],[128,3,128,4],[149,7,149,9],[150,2,150,5],[150,7,150,9],[154,2,154,9],[170,8,170,9],[71,2,71,9],[168,2,168,5],[168,7,168,9],[170,5,170,7],[78,5,78,7],[167,2,167,5],[167,7,167,9],[145,2,145,9],[161,5,161,7],[165,7,165,9],[166,2,166,9],[165,2,165,5],[159,2,159,5],[159,7,159,9],[152,8,152,9],[137,2,137,9],[123,8,123,9],[140,2,140,5],[140,7,140,9],[100,7,100,9],[102,8,102,9],[98,2,98,9],[97,2,97,5],[78,8,78,9],[116,2,116,9],[100,2,100,5],[164,2,164,9],[163,2,163,9],[143,8,143,9],[161,8,161,9],[157,2,157,9],[158,2,158,5],[158,7,158,9],[155,2,155,9],[156,2,156,5],[156,7,156,9],[147,2,147,5],[147,7,147,9],[143,5,143,7],[152,5,152,7],[146,2,146,9],[148,2,148,9],[149,2,149,5],[55,2,55,5],[97,7,97,9],[96,2,96,9],[95,2,95,9],[74,2,74,9],[75,2,75,5],[55,7,55,9],[58,8,58,9],[58,5,58,7],[80,7,80,9],[81,2,81,5],[81,6,81,8],[76,2,76,5],[76,7,76,9],[63,0,63,2],[63,3,63,4],[63,5,63,7],[63,8,63,9],[64,0,64,2],[64,3,64,4],[64,5,64,7],[64,8,64,9],[65,0,65,2],[65,3,65,4],[36,2,36,5],[36,7,36,9],[26,2,26,5],[26,7,26,9],[27,2,27,5],[27,7,27,9],[31,2,31,9],[32,2,32,9],[33,2,33,5],[33,7,33,9],[35,2,35,5],[35,7,35,9],[3,0,3,9],[6,2,6,9],[8,2,8,9],[9,2,9,5],[9,7,9,9],[7,2,7,9],[14,5,14,7],[25,2,25,9],[10,2,10,9],[11,2,11,5],[11,7,11,9],[12,2,12,5],[12,7,12,9],[14,8,14,9],[22,2,22,9],[23,2,23,9],[24,2,24,5],[24,7,24,9]]}
[" "]
[]
["Exhibit 2.1 - QUALIFIED DEVELOPMENT TEAM CONTACT INFORMATION"]
[]
[]
["DEVELOPMENT NAME",null,{"$f":"IF(ISBLANK(Application!D49), \"\", Application!D49)","v":""},null,null,null,"APPLICANT",{"$f":"IF(ISBLANK(Application!D11), \"\", Application!D11)","v":""}]
["APPLICANT"]
["(Owner/Mortgagor):",null,{"$f":"IF(ISBLANK(Application!D11),\"\",Application!D11)","v":""}]
[null,"Address:",{"$f":"IF(ISBLANK(Application!D13),\"\",Application!D13)","v":""}]
[null,null,{"$f":"IF(ISBLANK(Application!D15),\"\", Application!D15)","v":""},null,null,null,"State",{"$f":"IF(ISBLANK(Application!H15), \"\", Application!H15)","v":""}]
[null,"Principal(s):"]
[null,"Contact Person:",{"$f":"IF(ISBLANK(Application!D17),\"\",Application!D17)","v":""},null,null,null,"Title",{"$f":"IF(ISBLANK(Application!H17), \"\", Application!H17)","v":""}]
[null,"Telephone Number:",{"$f":"IF(ISBLANK(Application!D19), \"\", Application!D19)","v":""}]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[]
["Provide the information requested below for your last three rehabilitation projects"]
[null,"Project Name","Original Budget","Actual Budget","Scheduled Completion Date","Actual Completion Date"]
[]
[]
[]
["DEVELOPER"]
["(Legal Name):"]
[null,"Address:"]
[null,null,null,null,null,null,"Website:"]
[null,"Principal(s):"]
[null,"Contact Person:",null,null,null,null,"Email:"]
[null,"Telephone Number:",null,null,null,null,"Fax:"]
[]
[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:"]
[null,"Telephone Number:",null,null,null,null,"Fax:"]
[]
[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:"]
[null,"Telephone Number:",null,null,null,null,"Fax:"]
[]
[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:"]
[null,"Telephone Number:",null,null,null,null,"Fax:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[null,"Services to be provided: "]
[null,"Estimated Cost: "]
[null,"SS / Federal Tax ID #: "]
[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:"]
[null,"Telephone Number:",null,null,null,null,"Fax:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]
[null,".General Contractor: A contractor licensed to do business in the State of Connecticut is required"]
[]
["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:"]
[null,"Telephone Number:",null,null,null,null,"Fax:"]
[]
[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:"]
[null,"Telephone Number:",null,null,null,null,"Fax:"]
[]
[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:"]
[null,"Telephone Number:",null,null,null,null,"Fax:"]
[]
[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:"]
[null,"Telephone Number:",null,null,null,null,"Fax:"]
[]
[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:"]
[null,"Telephone Number:",null,null,null,null,"Fax:"]
[]
[null,"Identity of interests:",null,null,"Entity:"]

{"sheet":"3.7 Development Schedule","index":4,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[41,2,41,6],[47,2,47,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[46,2,46,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[33,2,33,6],[34,1,34,6],[35,2,35,6],[31,2,31,6],[32,2,32,6],[29,2,29,6],[26,1,26,6],[27,2,27,6],[28,2,28,6],[30,1,30,6],[21,2,21,6],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[1,4,1,6],[50,3,50,5],[54,0,54,3],[51,0,51,1],[2,0,2,6],[5,1,5,2],[5,4,5,6],[3,0,3,6],[7,0,8,0],[7,2,8,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6]]}
[]
[null,null,null,null,"Version 2.1:  4/14\n"]
["Exhibit 3.7 - DEVELOPMENT SCHEDULE"]
[]
[]
["DEVELOPMENT NAME",{"$f":"IF(ISBLANK(Application!D49), \"\", Application!D49)","v":""},null,"APPLICANT",{"$f":"IF(ISBLANK(Application!D11), \"\", Application!D11)","v":""}]
[]
["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: "]
["Application"]
["Award"]
["Other Loans & Grants"]
["Type & Source: "]
["Application"]
["Award"]
["Other Loans & Grants"]
["Type & Source: "]
["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":"3.14 Sworn Cert","index":5,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[45,0,45,5],[45,7,45,8],[46,7,46,8],[35,0,35,5],[35,7,35,9],[38,4,38,5],[41,2,41,10],[42,2,42,10],[43,0,43,5],[30,0,30,4],[30,6,30,8],[33,0,33,4],[33,7,33,9],[24,2,24,10],[28,0,28,4],[26,2,26,10],[14,2,14,10],[16,2,16,10],[20,2,20,10],[22,2,22,10],[2,0,2,11],[9,0,9,11],[11,1,11,10],[3,0,3,11],[7,2,7,5],[7,0,7,1],[7,7,7,11]]}
[]
[null,null,null," "]
["SWORN CERTIFICATE OF NON-DISPLACEMENT"]
["Exhibit 3.14"]
[]
[]
[]
["DEVELOPMENT NAME",null,{"$f":"IF(ISBLANK(Application!D49), \"\", Application!D49)","v":""},null,null,null,"APPLICANT",{"$f":"IF(ISBLANK(Application!D11), \"\", Application!D11)","v":""}]
[]
["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 Housing 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":"3.16 Fincl Asst Wksht","index":6,"n_rows":115,"n_cols":20,"rows_kept":115,"cut":false,"hidden":false,"merged":[[6,2,6,10],[7,2,7,4],[15,0,15,10],[11,2,11,10],[12,8,12,10],[7,8,7,10],[12,2,12,5],[89,7,89,8],[77,9,77,10],[79,9,79,10],[81,9,81,10],[84,5,84,6],[85,5,85,6],[77,5,77,6],[89,5,89,6],[114,8,114,10],[109,4,109,5],[111,0,111,6],[111,8,111,10],[95,0,95,4],[95,7,95,8],[112,8,112,10],[113,0,113,6],[113,8,113,10],[100,0,100,10],[105,6,105,7],[93,0,93,6],[93,7,93,8],[93,9,93,10],[90,0,90,10],[91,0,91,10],[73,5,73,6],[73,9,73,10],[1,0,1,10],[65,9,65,10],[66,9,66,10],[40,0,40,10],[47,2,47,5],[47,7,47,8],[43,7,43,8],[41,7,41,8],[44,7,44,8],[45,7,45,8],[21,1,21,2],[21,5,21,7],[42,7,42,8],[16,0,16,10],[2,0,2,10],[69,5,69,6],[69,9,69,10],[71,5,71,6],[71,9,71,10],[17,0,17,10],[6,0,6,1],[67,5,67,6],[67,9,67,10],[49,0,49,4],[50,7,50,8],[52,7,52,8],[54,7,54,8],[56,7,56,8],[63,0,63,8],[66,5,66,6]]}
[]
["FINANCIAL Assistance Worksheet"]
["Exhibit 3.16"]
[]
[]
["Section 1. Borrower Information "]
["Borrower Name:",null,{"$f":"IF(ISBLANK(Application!D11), \"\", Application!D11)","v":""}]
["Phone Number:",null,{"$f":"IF(ISBLANK(Application!D19), \"\", Application!D19)","v":""},null,null,null,"Fax Number:",null,{"$f":"IF(ISBLANK(Application!H19), \"\", Application!H19)","v":""}]
[]
["Section 2. Development Description"]
[]
["Development Name:",null,{"$f":"IF(ISBLANK(Application!D49),\"\",Application!D49)","v":""}]
["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:",{"$f":"SUM(B22+F22)","v":0}]
[]
[]
[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,{"$f":"IF(ISBLANK(H43),\"\",(H43/$F$27))","v":""}]
["Plus:  Acct. #2830 Unapp. Retained Earnings Balance",null,null,null,null,null,"             +",null,null,null,{"$f":"IF(ISBLANK(H44),\"\",(H44/$F$27))","v":""}]
["Plus or Minus:  Acct. #2830.1 Income & Expense Clearance",null,null,null,null,null,"             +",null,null,null,{"$f":"IF(ISBLANK(H45),\"\",(H45/$F$27))","v":""}]
["Plus or Minus:  Acct. #2830.5 APTS",null,null,null,null,null,"             +",null,null,null,{"$f":"IF(ISBLANK(H46),\"\",(H46/$F$27))","v":""}]
[]
[null,null,"Total Reserves Available:",null,null,null,"             =",{"$f":"SUM(H43:I46)","v":0},null,null,{"$f":"IF(ISBLANK(H48),\"\",(H48/$F$27))","v":{"$error":"#DIV/0!"}}]
[]
["Less:  CHFA Minimum RM&R Requirement P/U"]
["Elderly: $1,000:",null,null,"Family: $1,500:",null,null,"  -",null,null,null,{"$f":"IF(ISBLANK(H51),\"\",(H51/$F$27))","v":""},null,null,null,null,null,null,null,null,1]
[]
[null,null,"Available Balance (prior to rehab project):",null,null,null," =",{"$f":"SUM(H48-H51)","v":0},null,null,{"$f":"IF(ISBLANK(H53),\"\",(H53/$F$27))","v":{"$error":"#DIV/0!"}}]
[]
["Less:  Estimated Total Rehab Project Cost",null,null,null,null,null,"              -",null,null,null,{"$f":"IF(ISBLANK(H55),\"\",(H55/$F$27))","v":""}]
[]
[null,null,"Net Available Balance(after rehab project):",null,null,null,"             =",{"$f":"+H53-H55","v":0},null,null,{"$f":"IF(ISBLANK(H57),\"\",(H57/$F$27))","v":{"$error":"#DIV/0!"}}]
[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.",{"$f":"SUM(F68+F70+F72 / 3)","v":0},null,null,null,{"$f":"SUM(J68+J70+J72 / 3)","v":0}]
[]
["Current Year Reserves:"]
[]
["Annual Provision from Management Plan Dated:  "]
[]
["Estimate of on-going usages, based on past 3yr analysis:"]
[]
["Estimated amount added to Savings/Reserve:"]
[]
["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 6. Staff Recommendations"]
["CHFA staff will determine if a loan can be supported through the normal underwriting process.  DOH may provide a grant only after DOH 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"]
["Reserves"]
["Other Funds:"]
["Loan Amount:",null,null,null,null,"Rate:",null,null,null,"Term:"]
["Grant Amount:"]
[]
[]
["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"]

{"sheet":"4.1 Rental Income Calc Wrksht","index":7,"n_rows":78,"n_cols":28,"rows_kept":78,"cut":false,"hidden":false,"merged":[[2,0,2,8],[3,0,3,8],[5,2,5,4],[5,6,5,8],[56,8,58,8],[54,0,54,8],[7,7,7,8],[7,2,7,3],[9,0,9,8],[24,0,24,3],[24,4,24,8],[11,1,12,1],[11,2,11,3],[21,0,21,3],[26,0,26,15],[11,4,11,9]]}
[]
[]
["Exhibit 4.1 - RENTAL INCOME CALCULATION WORKSHEET"]
[]
[]
[null,"DEVELOPMENT NAME",{"$f":"IF(ISBLANK(Application!D49), \"\", Application!D49)","v":""},null,null,"APPLICANT",{"$f":"IF(ISBLANK(Application!D11), \"\", Application!D11)","v":""}]
[]
[null,"Current Year",{"$f":"IF(ISBLANK('3.7 Development Schedule'!B11),\"\",'3.7 Development Schedule'!B11)","v":""},null,null,null,"Proforma Stabilized Year (PSY)",{"$f":"IF(ISBLANK('3.7 Development Schedule'!B47), \"\", '3.7 Development Schedule'!B47)","v":""}]
[]
["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(E14:E21)","v":0},0,0,0,0,0]
[null,null,null,"Utility Allowance Trended to Proforma Stabilized Year:",{"$f":"-FV(0.05,$H$8-$C$8,0,E22,0)","v":{"$error":"#VALUE!"}},{"$f":"-FV(0.05,$H$8-$C$8,0,F22,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Source and Effective Date of Utility Allowances:"]
[]
["RENTAL INCOME"]
[]
[null,null,null,null,null,null,{"$f":"H8","v":""},{"$f":"H8","v":""},{"$f":"H8","v":""},{"$f":"H8","v":""},{"$f":"H8","v":""},{"$f":"H8","v":""},{"$f":"H8","v":""},{"$f":"M29","v":""},null,{"$f":"H8","v":""}]
["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(B32>100%,0,IF(C32=\"\",0,IF(AND(B32<=100%,C32=0),$E$23,IF(AND(B32<=100%,C32=1),$F$23,IF(AND(B32<=100%,C32=2),$G$23,IF(AND(B32<=100%,C32=3),$H$23,IF(AND(B32<=100%,C32>=4),$I$23,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},{"$f":"E32*D32","v":0},null,null,null,null,null,null,0.25,0]
[null,null,null,null,null,null,null,{"$f":"IF(B33>100%,0,IF(C33=\"\",0,IF(AND(B33<=100%,C33=0),$E$23,IF(AND(B33<=100%,C33=1),$F$23,IF(AND(B33<=100%,C33=2),$G$23,IF(AND(B33<=100%,C33=3),$H$23,IF(AND(B33<=100%,C33>=4),$I$23,0)))))))","v":0},{"$f":"G33-H33","v":0},null,{"$f":"J33+I33","v":0},{"$f":"(I33)*D33*12","v":0},{"$f":"J33*D33*12","v":0},{"$f":"M33+L33","v":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"},{"$f":"IF(O33=\"n/a\",0,((L33+M33)*(1-O33)))","v":0},null,null,{"$f":"IF(O33=\"n/a\",0,O33*N33)","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(B34=25%,2.5%,IF(AND(B34>25%,B34<60%),5%,IF(AND(B34>=60%,B34<80%),7%,IF(B34>=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(D32:D50)","v":0},null,null,null,null,null,null,{"$f":"SUM(K32:K50)","v":0},{"$f":"SUM(L32:L50)","v":0},{"$f":"SUM(M32:M50)","v":0},{"$f":"SUM(N32:N50)","v":0},{"$f":"(L51+M51-P51)","v":0},{"$f":"SUM(P32:P50)","v":0}]
[]
[null,"Number of LITHC Qualified Units",{"$f":"SUMIF(B32:B50,\"<=60%\",D32:D50)","v":0},null,null,"Number of Other Affordable Units",{"$f":"SUMIF(B32:B50,\"=80%\",D32:D50)","v":0},null,"Number of Market Rate Units",{"$f":"D51-G53-C53","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(O32=\"n/a\",0,O32)","v":0},{"$f":"Y56*L32","v":0}]
[null,null,{"$f":"C8","v":""},{"$f":"C8","v":""},{"$f":"D57","v":""},{"$f":"C8","v":""},{"$f":"H8","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"HOME",null,0.5,1,0,0]
["AMI %",{"$f":"C30","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":"B32","v":0},0,null,{"$f":"C60/12*30%","v":0},null,null,{"$f":"-FV(2%,$H$8-$C$8,0,F60,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4,0,0]
[0,0,null,{"$f":"C61/12*30%","v":0},null,null,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},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,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(Z56:Z74)","v":0},{"$f":"Z75*12","v":0}]
[0,0,null,0,null,null,{"$error":"#VALUE!"}]
[0,0,null,0,null,null,{"$error":"#VALUE!"}]
[0,0,null,0,null,null,{"$error":"#VALUE!"}]

{"sheet":"4.2 Exploded Trade Breakdown","index":8,"n_rows":375,"n_cols":14,"rows_kept":375,"cut":false,"hidden":false,"merged":[[7,12,8,12],[7,13,8,13],[9,3,9,5],[9,6,9,8],[1,0,1,9],[2,0,2,9],[3,0,3,5],[5,3,5,5],[5,8,5,9],[5,12,5,13],[121,3,121,5],[121,6,121,8],[7,3,7,5],[7,6,7,8],[7,9,8,9],[39,1,40,1],[96,3,96,5],[96,6,96,8],[110,3,110,5],[110,6,110,8],[132,3,132,5],[132,6,132,8],[155,3,155,5],[155,6,155,8],[186,3,186,5],[186,6,186,8],[202,3,202,5],[202,6,202,8],[232,3,232,5],[232,6,232,8],[248,3,248,5],[248,6,248,8],[352,3,352,5],[352,6,352,8],[270,3,270,5],[270,6,270,8],[279,3,279,5],[279,6,279,8],[289,3,289,5],[289,6,289,8],[294,1,295,1],[298,3,298,5],[298,6,298,8],[334,3,334,5],[334,6,334,8],[367,1,367,2],[369,0,369,9],[370,0,370,4],[370,5,370,9],[371,0,371,3],[371,5,371,8],[372,0,372,3],[372,5,372,8],[373,0,373,3],[373,5,373,8],[374,0,374,3],[374,5,374,8]]}
[]
["Connecticut Housing Finance Authority"]
["Exhibit 4.2 - EXPLODED TRADE PAYMENT BREAKDOWN"]
[]
[]
[null,null,"DEVELOPMENT NAME",{"$f":"IF(ISBLANK(Application!D49), \"\", Application!D49)","v":""},null,null,null,"APPLICANT",{"$f":"IF(ISBLANK(Application!D11),\"\",Application!D11)","v":""},null,null,null,"For Contractor Use"]
[]
[null,null,null,"RESIDENTIAL",null,null,"COMMERCIAL",null,null,"COMBINED TOTAL",null,null,"Requisitioned to Date","Current Requisition"]
["DIVISION",null,"TRADE  ITEM ","QUANTITY","COST ","TOTAL","QUANTITY","COST ","TOTAL"]
["01  GENERAL REQUIREMENTS"]
[null,"General","Project Manager",null,null,{"$f":"D11*E11","v":0},null,null,{"$f":"G11*H11","v":0},{"$f":"I11+F11","v":0},null,null,{"$f":"L11+H11","v":0},0]
[null,"Requirements","Superintendent",null,null,{"$f":"D12*E12","v":0},null,null,0,{"$f":"I12+F12","v":0},null,null,0,0]
[null,null,"Secretary",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Vehicle Expense",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Travel Expense",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Snow Removal",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"OSHA Protection",null,null,{"$f":"D17*E17","v":0},null,null,0,0,null,null,0,0]
[null,null,"Survey & Layout ( Site & Bldg.)",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Weather Protection",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Project Photographs",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Dumpsters",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Record Drawings",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Broken Glass Repair",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Temporary Toilets",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Temporary Fencing",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Temporary Heat (Winter Cond'n)",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Temporary Power",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Temporary Water",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Temporary Office",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Temporary Telephone",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Temporary Fire Protection",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Tests & Inspect'ns (Unless Spec'd)",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Construction Sign",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Materials Storage",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F11:F34)","v":0},null,null,{"$f":"SUM(I11:I34)","v":0},0,null,null,0,0]
[]
[null,"TOTAL FOR GENERAL REQUIREMENTS:",null,null,null,{"$f":"F35","v":0},null,null,{"$f":"I35","v":0},0,null,null,{"$f":"L37+H37","v":0},{"$f":"M37+I37","v":0}]
[]
["02   SITE WORK"]
[null,"Special Testing ","Asbestos Removal",null,null,{"$f":"D40*E40","v":0},null,null,{"$f":"G40*H40","v":0},0,null,null,{"$f":"L40+H40","v":0},{"$f":"M40+I40","v":0}]
[null,null,"SUBTOTAL:",null,null,{"$f":"F40","v":0},null,null,{"$f":"I40","v":0},0,null,null,{"$f":"L41+H41","v":0},{"$f":"M41+I41","v":0}]
[]
[null,"Environmental","Lead-Based Paint Removal",null,null,0,null,null,{"$f":"G43*H43","v":0},0,null,null,{"$f":"L43+H43","v":0},0]
[null,null,"Others (Specify)",null,null,0,null,null,{"$f":"G44*H44","v":0},0,null,null,0,0]
[null,null,"Demolition",null,null,0,null,null,{"$f":"G45*H45","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F43:F45)","v":0},null,null,{"$f":"SUM(I43:I45)","v":0},0,null,null,0,0]
[]
[null,"Grading &","Clearing & Grubbing",null,null,0,null,null,{"$f":"G48*H48","v":0},0,null,null,{"$f":"L48+H48","v":0},0]
[null,"Excavation","Cut & Fill",null,null,0,null,null,{"$f":"G49*H49","v":0},0,null,null,0,0]
[null,null,"Rock Excavation",null,null,0,null,null,{"$f":"G50*H50","v":0},0,null,null,0,0]
[null,null,"Foundation Excavation & Backfill",null,null,0,null,null,{"$f":"G51*H51","v":0},0,null,null,0,0]
[null,null,"Trenching",null,null,0,null,null,{"$f":"G52*H52","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F48:F52)","v":0},null,null,{"$f":"SUM(I48:I52)","v":0},0,null,null,0,0]
[]
[null,"Site Utilities","Water Supply",null,null,0,null,null,{"$f":"G55*H55","v":0},0,null,null,{"$f":"L55+H55","v":0},0]
[null,null,"Sanitary Sewer",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Storm Sewer",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Gas",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Electric Trenching",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Electric conduit and wire",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Offsite",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F55:F61)","v":0},null,null,{"$f":"SUM(I55:I61)","v":0},0,null,null,0,0]
[]
[null,"Paving","Bituminous Paving",null,null,0,null,null,{"$f":"G64*H64","v":0},0,null,null,{"$f":"L64+H64","v":0},0]
[null,"Walks &","Boxing Out Paving",null,null,0,null,null,0,0,null,null,0,0]
[null,"Signs","Rough / Binder Course",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Finish Coat",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Curbing",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Signs",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Concrete Walks and Steps",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Terrace (Specify)",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F64:F71)","v":0},null,null,{"$f":"SUM(I64:I71)","v":0},0,null,null,0,0]
[]
[null,"Unusual Site","Rock Excavation",null,null,0,null,null,{"$f":"G74*H74","v":0},0,null,null,{"$f":"L74+H74","v":0},0]
[null,"Conditions","Unsuitable Soil",null,null,0,null,null,{"$f":"G75*H75","v":0},0,null,null,0,0]
[null,null,"Others (Specify)",null,null,0,null,null,{"$f":"G76*H76","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F74:F76)","v":0},null,null,{"$f":"SUM(I74:I76)","v":0},{"$f":"I77+F77","v":0},null,null,0,0]
[]
["02   SITE WORK      (Continued)"]
[null,"Lawns &","Topsoil",null,null,0,null,null,{"$f":"G80*H80","v":0},0,null,null,{"$f":"L80+H80","v":0},0]
[null,"Planting","Seeding & Sodding",null,null,0,null,null,{"$f":"G81*H81","v":0},0,null,null,0,0]
[null,null,"Plantings",null,null,0,null,null,{"$f":"G82*H82","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F80:F82)","v":0},null,null,{"$f":"SUM(I80:I82)","v":0},0,null,null,0,0]
[]
[null,"Other","Retaining Walls & Fences",null,null,0,null,null,{"$f":"G85*H85","v":0},0,null,null,{"$f":"L85+H85","v":0},0]
[null,"Site","Benches,Tables,Playgr'nd Equip.",null,null,0,null,null,0,0,null,null,0,0]
[null,"Work","Irrigation",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Site Lighting",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Basketball Court, Tennis Court",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Pool & Equipment",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F85:F90)","v":0},null,null,{"$f":"SUM(I85:I90)","v":0},0,null,null,0,0]
[]
[null,"Demolition","(Specify)",null,null,0,null,null,{"$f":"G93*H93","v":0},0,null,null,{"$f":"L93+H93","v":0},{"$f":"M93+I93","v":0}]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F93)","v":0},null,null,{"$f":"SUM(I93)","v":0},0,null,null,{"$f":"L94+H94","v":0},{"$f":"M94+I94","v":0}]
[]
[null,null,"Allowance for Division 2 Site Work",null,null,{"$f":"D96*E96","v":0},null,null,{"$f":"G96*H96","v":0},0,null,null,{"$f":"L96+H96","v":0},{"$f":"M96+I96","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR SITE WORK:",null,null,null,{"$f":"F94+F91+F83+F77+F72+F62+F53+F46+F41+F96","v":0},null,null,{"$f":"I94+I91+I83+I77+I72+I62+I53+I46+I41+I96","v":0},0,null,null,{"$f":"L99+H99","v":0},{"$f":"M99+I99","v":0}]
[]
["03  CONCRETE"]
[null,"Concrete","Concrete Footings",null,null,0,null,null,{"$f":"G102*H102","v":0},0,null,null,{"$f":"L102+H102","v":0},0]
[null,null,"Foundation Walls",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Columns",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Slab-On-Grade",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Structural Slabs / Roof Deck",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Reinforcing Steel ",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F102:F107)","v":0},null,null,{"$f":"SUM(I102:I107)","v":0},0,null,null,0,0]
[]
[null,null,"Allowance for Division 3 Concrete",null,null,{"$f":"D110*E110","v":0},null,null,{"$f":"G110*H110","v":0},0,null,null,{"$f":"L110+H110","v":0},{"$f":"M110+I110","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR CONCRETE:",null,null,null,{"$f":"F108+F110","v":0},null,null,{"$f":"I108+I110","v":0},0,null,null,{"$f":"L113+H113","v":0},{"$f":"M113+I113","v":0}]
[]
["04  MASONRY"]
[null,"Masonry"," Face Brick",null,null,{"$f":"D116*E116","v":0},null,null,{"$f":"G116*H116","v":0},0,null,null,{"$f":"L116+H116","v":0},0]
[null,null,"Concrete Block",null,null,{"$f":"D117*E117","v":0},null,null,{"$f":"G117*H117","v":0},0,null,null,0,0]
[null,null,"Ties & Reinforcing Trusses ",null,null,{"$f":"D118*E118","v":0},null,null,{"$f":"G118*H118","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F116:F118)","v":0},null,null,{"$f":"SUM(I116:I118)","v":0},0,null,null,0,0]
[]
[null,null,"Allowance for Division 4 Masonry",null,null,{"$f":"D121*E121","v":0},null,null,{"$f":"G121*H121","v":0},0,null,null,{"$f":"L121+H121","v":0},{"$f":"M121+I121","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR MASONRY:",null,null,null,{"$f":"F119+F121","v":0},null,null,{"$f":"I119+I121","v":0},0,null,null,{"$f":"L124+H124","v":0},{"$f":"M124+I124","v":0}]
[]
["05  METALS"]
[null,"Metals","Structural Steel",null,null,{"$f":"D127*E127","v":0},null,null,{"$f":"G127*H127","v":0},0,null,null,{"$f":"L127+H127","v":0},0]
[null,null,"Misc. Lintels & Ladders",null,null,{"$f":"D128*E128","v":0},null,null,{"$f":"G128*H128","v":0},0,null,null,0,0]
[null,null,"Steel Stairs & Handrails",null,null,{"$f":"D129*E129","v":0},null,null,{"$f":"G129*H129","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F127:F129)","v":0},null,null,{"$f":"SUM(I127:I129)","v":0},0,null,null,0,0]
[]
[null,null,"Allowance for Division 5 Metals",null,null,{"$f":"D132*E132","v":0},null,null,{"$f":"G132*H132","v":0},0,null,null,{"$f":"L132+H132","v":0},{"$f":"M132+I132","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR METALS:",null,null,null,{"$f":"SUM(F130)+F132","v":0},null,null,{"$f":"SUM(I130)+I132","v":0},0,null,null,{"$f":"L135+H135","v":0},{"$f":"M135+I135","v":0}]
[]
["06  CARPENTRY"]
[null,"Rough","Floor Framing Lumber",null,null,{"$f":"D138*E138","v":0},null,null,{"$f":"G138*H138","v":0},0,null,null,{"$f":"L138+H138","v":0},0]
[null,"Carpentry","Floor Framing Trusses",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Wall Framing",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Roof Framing Lumber",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Roof Framing Trusses",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Exterior Wall Sheathing",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Plywood Subflooring",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Plywood Underlayment",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F138:F145)","v":0},null,null,{"$f":"SUM(I138:I145)","v":0},{"$f":"I146+F146","v":0},null,null,0,0]
[]
[null,"Finish","Wood Stairs & Handrails",null,null,{"$f":"D148*E148","v":0},null,null,{"$f":"G148*H148","v":0},0,null,null,{"$f":"L148+H148","v":0},0]
[null,"Carpentry","Closet Shelving, Rods",null,null,{"$f":"D149*E149","v":0},null,null,{"$f":"G149*H149","v":0},0,null,null,0,0]
[null,null,"Wood Base & Moulding",null,null,{"$f":"D150*E150","v":0},null,null,{"$f":"G150*H150","v":0},0,null,null,0,0]
[null,null,"Wood Door  & Window Trim",null,null,{"$f":"D151*E151","v":0},null,null,{"$f":"G151*H151","v":0},0,null,null,0,0]
[null,null,"Millwork",null,null,{"$f":"D152*E152","v":0},null,null,{"$f":"G152*H152","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F148:F152)","v":0},null,null,{"$f":"SUM(I148:I152)","v":0},0,null,null,0,0]
["06  CARPENTRY      (Continued)"]
[null,null,"Allowance for Division 6 Carpentry",null,null,{"$f":"D155*E155","v":0},null,null,{"$f":"G155*H155","v":0},0,null,null,{"$f":"L155+H155","v":0},{"$f":"M155+I155","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR CARPENTRY:",null,null,null,{"$f":"SUM(+F153+F146)+F155","v":0},null,null,{"$f":"SUM(+I153+I146)+I155","v":0},0,null,null,{"$f":"L158+H158","v":0},{"$f":"M158+I158","v":0}]
[]
["07  THERMAL & MOISTURE PROTECTION "]
[null,"Moisture","Dampproofing",null,null,{"$f":"D161*E161","v":0},null,null,{"$f":"G161*H161","v":0},0,null,null,{"$f":"L161+H161","v":0},0]
[null,"Protection","Waterproofing",null,null,{"$f":"D162*E162","v":0},null,null,{"$f":"G162*H162","v":0},0,null,null,0,0]
[null,null,"Membrane Waterproofing",null,null,{"$f":"D163*E163","v":0},null,null,{"$f":"G163*H163","v":0},0,null,null,0,0]
[null,null,"Prefab. Foundation Drainage",null,null,{"$f":"D164*E164","v":0},null,null,{"$f":"G164*H164","v":0},0,null,null,0,0]
[null,null,"Caulking",null,null,{"$f":"D165*E165","v":0},null,null,{"$f":"G165*H165","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F161:F165)","v":0},null,null,{"$f":"SUM(I161:I165)","v":0},0,null,null,0,0]
[]
[null,"Insulation","Foundation Insulation",null,null,{"$f":"D168*E168","v":0},null,null,{"$f":"G168*H168","v":0},0,null,null,{"$f":"L168+H168","v":0},0]
[null,null,"Wall Insulation",null,null,{"$f":"D169*E169","v":0},null,null,{"$f":"G169*H169","v":0},0,null,null,0,0]
[null,null,"Ceiling  Insulation",null,null,{"$f":"D170*E170","v":0},null,null,{"$f":"G170*H170","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F168:F170)","v":0},null,null,{"$f":"SUM(I168:I170)","v":0},0,null,null,0,0]
[]
[null,"Roofing","Shingle Roofing (Specify)",null,null,{"$f":"D173*E173","v":0},null,null,{"$f":"G173*H173","v":0},0,null,null,{"$f":"L173+H173","v":0},0]
[null,null,"Builtup Roofing (Specify)",null,null,{"$f":"D174*E174","v":0},null,null,{"$f":"G174*H174","v":0},0,null,null,0,0]
[null,null,"Single Ply Roofing (Specify)",null,null,{"$f":"D175*E175","v":0},null,null,{"$f":"G175*H175","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F173:F175)","v":0},null,null,{"$f":"SUM(I173:I175)","v":0},0,null,null,0,0]
[]
[null,"Sheet Metal","Gutters & Leaders",null,null,{"$f":"D178*E178","v":0},null,null,{"$f":"G178*H178","v":0},0,null,null,{"$f":"L178+H178","v":0},0]
[null,null,"Flashing",null,null,{"$f":"D179*E179","v":0},null,null,{"$f":"G179*H179","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F178:F179)","v":0},null,null,{"$f":"SUM(I178:I179)","v":0},0,null,null,0,0]
[]
[null,"Siding","Vinyl / Aluminum Siding (Specify)",null,null,{"$f":"D182*E182","v":0},null,null,{"$f":"G182*H182","v":0},0,null,null,{"$f":"L182+H182","v":0},0]
[null,null,"Wood Shingles / Siding (Specify)",null,null,{"$f":"D183*E183","v":0},null,null,{"$f":"G183*H183","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F182:F183)","v":0},null,null,{"$f":"SUM(I182:I183)","v":0},0,null,null,0,0]
[]
[null,null,"Allowance for Division 7 Thermal & Moisture",null,null,{"$f":"D186*E186","v":0},null,null,{"$f":"G186*H186","v":0},0,null,null,{"$f":"L186+H186","v":0},{"$f":"M186+I186","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR THERMAL & MOISTURE PROTECTION:",null,null,null,{"$f":"SUM(+F180+F176+F171+F166+F184)+F186","v":0},null,null,{"$f":"SUM(+I180+I176+I171+I166+I184)+I186","v":0},0,null,null,{"$f":"L189+H189","v":0},{"$f":"M189+I189","v":0}]
[]
["08  DOORS & WINDOWS"]
[null,"Doors &","Doors & Frames Exterior",null,null,{"$f":"D192*E192","v":0},null,null,{"$f":"G192*H192","v":0},0,null,null,{"$f":"L192+H192","v":0},0]
[null,"Hardware","Doors & Frames-Interior",null,null,{"$f":"D193*E193","v":0},null,null,{"$f":"G193*H193","v":0},0,null,null,0,0]
[null,null,"Door Hardware",null,null,{"$f":"D194*E194","v":0},null,null,{"$f":"G194*H194","v":0},0,null,null,0,0]
[null,null,"Specialty Doors & Frames",null,null,{"$f":"D195*E195","v":0},null,null,{"$f":"G195*H195","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F192:F195)","v":0},null,null,{"$f":"SUM(I192:I195)","v":0},0,null,null,0,0]
[]
[null,"Windows","Windows & Glazing",null,null,{"$f":"D198*E198","v":0},null,null,{"$f":"G198*H198","v":0},0,null,null,{"$f":"L198+H198","v":0},0]
[null,null,"Aluminum Storefront ",null,null,{"$f":"D199*E199","v":0},null,null,{"$f":"G199*H199","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F198:F199)","v":0},null,null,{"$f":"SUM(I198:I199)","v":0},0,null,null,0,0]
[]
[null,null,"Allowance for Division 8 Doors & Windows",null,null,{"$f":"D202*E202","v":0},null,null,{"$f":"G202*H202","v":0},0,null,null,{"$f":"L202+H202","v":0},{"$f":"M202+I202","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR DOORS & WINDOWS:",null,null,null,{"$f":"SUM(+F196)+F200+F202","v":0},null,null,{"$f":"SUM(+I196)+I200+I202","v":0},0,null,null,{"$f":"L205+H205","v":0},{"$f":"M205+I205","v":0}]
[]
["09  FINISHES"]
[null,"Acoustical Tile","Ceilings",null,null,{"$f":"D208*E208","v":0},null,null,{"$f":"G208*H208","v":0},0,null,null,{"$f":"L208+H208","v":0},{"$f":"M208+I208","v":0}]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F208)","v":0},null,null,{"$f":"SUM(I208)","v":0},0,null,null,{"$f":"L209+H209","v":0},{"$f":"M209+I209","v":0}]
[]
[null,"Drywall ","Gypsum Board Walls",null,null,{"$f":"D211*E211","v":0},null,null,{"$f":"G211*H211","v":0},{"$f":"I211+F211","v":0},null,null,{"$f":"L211+H211","v":0},0]
[null,null,"Gypsum Board Ceilings",null,null,{"$f":"D212*E212","v":0},null,null,{"$f":"G212*H212","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F211:F212)","v":0},null,null,{"$f":"SUM(I211:I212)","v":0},0,null,null,0,0]
[]
[null,"Ceramic Tile","Flooring & Base",null,null,{"$f":"D215*E215","v":0},null,null,{"$f":"G215*H215","v":0},0,null,null,{"$f":"L215+H215","v":0},{"$f":"M215+I215","v":0}]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F215)","v":0},null,null,{"$f":"SUM(I215)","v":0},0,null,null,{"$f":"L216+H216","v":0},{"$f":"M216+I216","v":0}]
[]
[null,"Wood Flooring","Flooring & Base",null,null,{"$f":"D218*E218","v":0},null,null,{"$f":"G218*H218","v":0},0,null,null,{"$f":"L218+H218","v":0},0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F218)","v":0},null,null,{"$f":"SUM(I218)","v":0},0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,0,0]
[null,"Res. Flooring","Flooring & Base",null,null,{"$f":"D221*E221","v":0},null,null,{"$f":"G221*H221","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F221)","v":0},null,null,{"$f":"SUM(I221)","v":0},0,null,null,0,0]
[]
[null,"Painting","Interior Painting",null,null,{"$f":"D224*E224","v":0},null,null,{"$f":"G224*H224","v":0},0,null,null,{"$f":"L224+H224","v":0},0]
[null,null,"Exterior Painting",null,null,{"$f":"D225*E225","v":0},null,null,{"$f":"G225*H225","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F224:F225)","v":0},null,null,{"$f":"SUM(I224:I225)","v":0},0,null,null,0,0]
[]
["09  FINISHES      (Continued)"]
[null,"Carpet","Flooring",null,null,{"$f":"D229*E229","v":0},null,null,{"$f":"G229*H229","v":0},0,null,null,{"$f":"L229+H229","v":0},{"$f":"M229+I229","v":0}]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F229)","v":0},null,null,{"$f":"SUM(I229)","v":0},0,null,null,{"$f":"L230+H230","v":0},{"$f":"M230+I230","v":0}]
[]
[null,null,"Allowance for Division 9 Finishes",null,null,{"$f":"D232*E232","v":0},null,null,{"$f":"G232*H232","v":0},0,null,null,{"$f":"L232+H232","v":0},{"$f":"M232+I232","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR FINISHES:",null,null,null,{"$f":"SUM(F226+F230+F222+F219+F216+F213+F209)+F232","v":0},null,null,{"$f":"SUM(I226+I230+I222+I219+I216+I213+I209)+I232","v":0},0,null,null,{"$f":"L235+H235","v":0},{"$f":"M235+I235","v":0}]
[]
["10   SPECIALTIES"]
[null,"Unit A/C","Unit A/C and/or Sleeves (Specify)",null,null,{"$f":"D238*E238","v":0},null,null,{"$f":"G238*H238","v":0},0,null,null,{"$f":"L238+H238","v":0},{"$f":"M238+I238","v":0}]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F238)","v":0},null,null,{"$f":"SUM(I238)","v":0},0,null,null,{"$f":"L239+H239","v":0},{"$f":"M239+I239","v":0}]
[]
[null,"Specialties","Toilet Accessories",null,null,{"$f":"D241*E241","v":0},null,null,{"$f":"G241*H241","v":0},0,null,null,{"$f":"L241+H241","v":0},0]
[null,null,"Interior Signage",null,null,{"$f":"D242*E242","v":0},null,null,{"$f":"G242*H242","v":0},0,null,null,0,0]
[null,null,"Interior Mailboxes",null,null,{"$f":"D243*E243","v":0},null,null,{"$f":"G243*H243","v":0},0,null,null,0,0]
[null,null,"Other (Specify)",null,null,{"$f":"D244*E244","v":0},null,null,{"$f":"G244*H244","v":0},0,null,null,0,0]
[null,null,"Fire Extinguishers",null,null,{"$f":"D245*E245","v":0},null,null,{"$f":"G245*H245","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F241:F245)","v":0},null,null,{"$f":"SUM(I241:I245)","v":0},0,null,null,0,0]
[]
[null,null,"Allowance for Division 10 Specialties",null,null,{"$f":"D248*E248","v":0},null,null,{"$f":"G248*H248","v":0},0,null,null,{"$f":"L248+H248","v":0},{"$f":"M248+I248","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR SPECIALTIES:",null,null,null,{"$f":"SUM(F246+F239)+F248","v":0},null,null,{"$f":"SUM(I246+I239)+I248","v":0},0,null,null,{"$f":"L251+H251","v":0},{"$f":"M251+I251","v":0}]
[]
["11  EQUIPMENT"]
[null,"Special Equip.","(Specify)",null,null,{"$f":"D254*E254","v":0},null,null,{"$f":"G254*H254","v":0},0,null,null,{"$f":"L254+H254","v":0},{"$f":"M254+I254","v":0}]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F254)","v":0},null,null,{"$f":"SUM(I254)","v":0},0,null,null,{"$f":"L255+H255","v":0},{"$f":"M255+I255","v":0}]
[]
[null,"Cabinets ","Kitchen Cabinets",null,null,{"$f":"D257*E257","v":0},null,null,{"$f":"G257*H257","v":0},0,null,null,{"$f":"L257+H257","v":0},0]
[null,"& Vanities","Bathroom Vanities",null,null,{"$f":"D258*E258","v":0},null,null,{"$f":"G258*H258","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F257:F258)","v":0},null,null,{"$f":"SUM(I257:I258)","v":0},0,null,null,0,0]
["11  EQUIPMENT      (Continued)"]
[null,"Kitchen","Dishwasher",null,null,{"$f":"D261*E261","v":0},null,null,{"$f":"G261*H261","v":0},0,null,null,{"$f":"L261+H261","v":0},0]
[null,"Appliances","MicroWave",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Range",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Range Hood",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Refrigerator",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Washer & Drain Pan",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Dryer",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F261:F267)","v":0},null,null,{"$f":"SUM(I261:I267)","v":0},0,null,null,0,0]
[]
[null,null,"Allowance for Division 11 Equipment",null,null,{"$f":"D270*E270","v":0},null,null,{"$f":"G270*H270","v":0},0,null,null,{"$f":"L270+H270","v":0},{"$f":"M270+I270","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR EQUIPMENT:",null,null,null,{"$f":"SUM(F268+F259+F255)+F270","v":0},null,null,{"$f":"SUM(I268+I259+I255)+I270","v":0},0,null,null,{"$f":"L273+H273","v":0},{"$f":"M273+I273","v":0}]
[]
["12  FURNISHINGS"]
[null,"Furnishing","Blinds, Shades & Artwork",null,null,{"$f":"D276*E276","v":0},null,null,{"$f":"G276*H276","v":0},0,null,null,{"$f":"L276+H276","v":0},{"$f":"M276+I276","v":0}]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F276)","v":0},null,null,{"$f":"SUM(I276)","v":0},0,null,null,{"$f":"L277+H277","v":0},{"$f":"M277+I277","v":0}]
[]
[null,null,"Allowance for Division 12 Furnishings",null,null,{"$f":"D279*E279","v":0},null,null,{"$f":"G279*H279","v":0},{"$f":"I279+F279","v":0},null,null,{"$f":"L279+H279","v":0},{"$f":"M279+I279","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR FURNISHINGS:",null,null,null,{"$f":"SUM(F277)+F279","v":0},null,null,{"$f":"SUM(I277)+I279","v":0},0,null,null,{"$f":"L282+H282","v":0},{"$f":"M282+I282","v":0}]
[]
["13  SPECIAL CONSTRUCTION"]
[null,"Special","Indoor Swimming Pool",null,null,{"$f":"D285*E285","v":0},null,null,{"$f":"G285*H285","v":0},0,null,null,{"$f":"L285+H285","v":0},0]
[null,"Construction","Greenhouse",null,null,{"$f":"D286*E286","v":0},null,null,{"$f":"G286*H286","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F285:F286)","v":0},null,null,{"$f":"SUM(I285:I286)","v":0},0,null,null,0,0]
[]
[null,null,"Allowance for Division 13 Special Construction",null,null,{"$f":"D289*E289","v":0},null,null,{"$f":"G289*H289","v":0},0,null,null,{"$f":"L289+H289","v":0},{"$f":"M289+I289","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR SPECIAL CONSTRUCTION:",null,null,null,{"$f":"SUM(F287)+F289","v":0},null,null,{"$f":"SUM(I287)+I289","v":0},0,null,null,{"$f":"L292+H292","v":0},{"$f":"M292+I292","v":0}]
[]
["14  CONVEYING SYSTEM"]
[null,"Conveying Sys","Elevators",null,null,{"$f":"D295*E295","v":0},null,null,{"$f":"G295*H295","v":0},0,null,null,{"$f":"L295+H295","v":0},{"$f":"M295+I295","v":0}]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F295)","v":0},null,null,{"$f":"SUM(I295)","v":0},0,null,null,{"$f":"L296+H296","v":0},{"$f":"M296+I296","v":0}]
[]
[null,null,"Allowance for Division 14 Conveying System",null,null,{"$f":"D298*E298","v":0},null,null,{"$f":"G298*H298","v":0},0,null,null,{"$f":"L298+H298","v":0},{"$f":"M298+I298","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR CONVEYING SYSTEM:",null,null,null,{"$f":"SUM(F296)+F298","v":0},null,null,{"$f":"SUM(I296)+I298","v":0},0,null,null,{"$f":"L301+H301","v":0},{"$f":"M301+I301","v":0}]
[]
["15  PLUMBING, HVAC & FIRE SUPPRESSIONOT WATER "]
[null,"Rough","Water Supply Piping",null,null,{"$f":"D304*E304","v":0},null,null,{"$f":"G304*H304","v":0},0,null,null,{"$f":"L304+H304","v":0},0]
[null,"Plumbing","Drain,Waste & Vent Piping",null,null,{"$f":"D305*E305","v":0},null,null,{"$f":"G305*H305","v":0},0,null,null,0,0]
[null,null,"Pipe Insulation",null,null,{"$f":"D306*E306","v":0},null,null,{"$f":"G306*H306","v":0},0,null,null,0,0]
[null,null,"Gas Piping",null,null,{"$f":"D307*E307","v":0},null,null,{"$f":"G307*H307","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F304:F307)","v":0},null,null,{"$f":"SUM(I304:I307)","v":0},0,null,null,0,0]
[]
[null,"Finish","Kitchen Sinks & Faucets",null,null,{"$f":"D310*E310","v":0},null,null,{"$f":"G310*H310","v":0},0,null,null,{"$f":"L310+H310","v":0},0]
[null,"Plumbing","Toilet Fixtures",null,null,{"$f":"D311*E311","v":0},null,null,{"$f":"G311*H311","v":0},0,null,null,0,0]
[null,null,"Lavatory Fixtures & Faucets",null,null,{"$f":"D312*E312","v":0},null,null,{"$f":"G312*H312","v":0},0,null,null,0,0]
[null,null,"Shower & Tub Enclosures",null,null,{"$f":"D313*E313","v":0},null,null,{"$f":"G313*H313","v":0},0,null,null,0,0]
[null,null,"Hot Water Heaters & Drain Pans",null,null,{"$f":"D314*E314","v":0},null,null,{"$f":"G314*H314","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F310:F314)","v":0},null,null,{"$f":"SUM(I310:I314)","v":0},0,null,null,0,0]
[]
[null,"Hydronic","Boiler Equipment",null,null,{"$f":"D317*E317","v":0},null,null,{"$f":"G317*H317","v":0},0,null,null,{"$f":"L317+H317","v":0},0]
[null,"Heating","Baseboard Radiation",null,null,0,null,null,{"$f":"G318*H318","v":0},0,null,null,0,0]
[null,null,"Supply & Return Piping",null,null,0,null,null,{"$f":"G319*H319","v":0},0,null,null,0,0]
[null,null,"Pipe Insulation",null,null,0,null,null,{"$f":"G320*H320","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F317:F320)","v":0},null,null,{"$f":"SUM(I317:I320)","v":0},0,null,null,0,0]
[]
[null,"Heating","Rooftop Equipment / Furnaces",null,null,0,null,null,{"$f":"G323*H323","v":0},0,null,null,{"$f":"L323+H323","v":0},0]
[null,"Ventilation","Supply & Return Ductwork",null,null,0,null,null,0,0,null,null,0,0]
[null,"A/C","Registers & Grilles",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Bathroom Exhaust Fans",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Kitchen Exhuast Ductwork & Grille",null,null,0,null,null,0,0,null,null,0,0]
[null,null," Central-air System",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F323:F328)","v":0},null,null,{"$f":"SUM(I323:I328)","v":0},0,null,null,0,0]
[]
[null,"Suppr System","Suppression System - Dry / Wet",null,null,0,null,null,{"$f":"G331*H331","v":0},0,null,null,{"$f":"L331+H331","v":0},{"$f":"M331+I331","v":0}]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F331)","v":0},null,null,{"$f":"SUM(I331)","v":0},0,null,null,{"$f":"L332+H332","v":0},{"$f":"M332+I332","v":0}]
["15  PLUMBING, HVAC & FIRE SUPPRESSIONOT WATER      (Continued)"]
[null,null,"Allowance for Division 15 Plumbing, HVAC & Fire",null,null,{"$f":"D334*E334","v":0},null,null,{"$f":"G334*H334","v":0},0,null,null,{"$f":"L334+H334","v":0},{"$f":"M334+I334","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR PLUMBING, HVAC & FIRE SUPPRESSION:",null,null,null,{"$f":"SUM(F329+F321+F315+F308+F332)+F334","v":0},null,null,{"$f":"SUM(I329+I321+I315+I308+I332)+I334","v":0},0,null,null,{"$f":"L337+H337","v":0},{"$f":"M337+I337","v":0}]
[]
["16  ELECTRICAL (Building Only)"]
[null,"Rough","Main Service Panel & Meters",null,null,0,null,null,{"$f":"G340*H340","v":0},0,null,null,{"$f":"L340+H340","v":0},0]
[null,"Electrical","Rough Wiring",null,null,0,null,null,{"$f":"G341*H341","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F340:F341)","v":0},null,null,{"$f":"SUM(I340:I341)","v":0},0,null,null,0,0]
[]
[null,"Finish","Switches,Receptacles",null,null,0,null,null,{"$f":"G344*H344","v":0},0,null,null,{"$f":"L344+H344","v":0},0]
[null,"Electrical","Lighting Fixtures",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Cable T.V.System",null,null,0,null,null,0,{"$f":"I346+F346","v":0},null,null,0,0]
[null,null,"Security System",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Emergency Generator",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"Emergency Call for Aid System",null,null,0,null,null,0,0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F344:F349)","v":0},null,null,{"$f":"SUM(I344:I349)","v":0},0,null,null,0,0]
[]
[null,null,"Allowance for Division 16 Electrical",null,null,{"$f":"D352*E352","v":0},null,null,{"$f":"G352*H352","v":0},0,null,null,{"$f":"L352+H352","v":0},{"$f":"M352+I352","v":0}]
[null,null,"Allowance Scope ","(describe here)",null,null,"(describe here)"]
[]
[null,"TOTAL FOR ELECTRICAL:",null,null,null,{"$f":"SUM(F350+F342)+F352","v":0},null,null,{"$f":"SUM(I350+I342)+I352","v":0},0,null,null,{"$f":"L355+H355","v":0},{"$f":"M355+I355","v":0}]
[]
[null,"TOTAL FOR ALL DIVISIONS (2-16):",null,null,null,{"$f":"SUM(F355+F337+F301+F292+F282+F273+F251+F235+F205+F189+F158+F135+F124+F113+F99)","v":0},null,null,{"$f":"SUM(I355+I337+I301+I292+I282+I273+I251+I235+I205+I189+I158+I135+I124+I113+I99)","v":0},0,null,null,{"$f":"L357+H357","v":0},{"$f":"M357+I357","v":0}]
[null,"% of Total"]
[null,{"$f":"E359/$F$357","v":{"$error":"#DIV/0!"}},"GENERAL REQUIREMENTS (Div. 01 from above)",null,{"$f":"F37","v":0},{"$f":"E359","v":0},null,null,null,0,null,null,{"$f":"L359+H359","v":0},0]
[null,{"$f":"E360/$F$357","v":{"$error":"#DIV/0!"}},"OVERHEAD & PROFIT",null,null,{"$f":"E360","v":0},null,null,null,0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F359:F360)","v":0},null,null,null,0,null,null,0,0]
[]
[null,"Misc. Items:","BUILDING PERMIT",null,null,{"$f":"E363","v":0},null,null,{"$f":"H363","v":0},0,null,null,{"$f":"L363+H363","v":0},0]
[null,null,"OTHER FEES",null,null,{"$f":"E364","v":0},null,null,{"$f":"H364","v":0},0,null,null,0,0]
[null,null,"BOND PREMIUM",null,null,{"$f":"E365","v":0},null,null,{"$f":"H365","v":0},0,null,null,0,0]
[null,null,"SUBTOTAL:",null,null,{"$f":"SUM(F363:F365)","v":0},null,null,{"$f":"SUM(I363:I365)","v":0},0,null,null,0,0]
[]
[null,"GRAND TOTAL OF ALL COSTS:",null,null,null,{"$f":"F366+F361+F357","v":0},null,null,{"$f":"I366+I361+I357","v":0},0,null,null,{"$f":"L368+H368","v":0},{"$f":"M368+I368","v":0}]
["I hereby certify that the proposed housing can be built for the cost shown above."]
["Note:  Signatures are not required at time of application but will be required following approval.  Indicate the individual who prepared the cost estimates below for application."]
["Contractor",null,null,null,null,"CHFA Staff"]
[]
["Signature",null,null,null,"Date","Signature",null,null,null,"Date"]
[]
["Contractor Name",null,null,null,"Title","Construction Tax Credit Cost Manager"]

{"sheet":"4.3 Estmd Development Budget","index":9,"n_rows":86,"n_cols":15,"rows_kept":86,"cut":false,"hidden":false,"merged":[[9,7,10,7],[9,8,9,13],[9,14,10,14],[5,2,5,9],[5,13,5,14],[6,3,6,9],[6,13,6,14],[7,13,7,14],[22,1,22,6],[11,1,11,6],[12,1,12,6],[13,1,13,6],[14,1,14,6],[15,1,15,6],[16,1,16,6],[17,1,17,6],[18,1,18,6],[19,1,19,6],[20,1,20,6],[21,1,21,6],[34,1,34,6],[23,1,23,6],[24,1,24,6],[25,1,25,6],[26,1,26,6],[27,1,27,6],[28,1,28,6],[29,1,29,6],[30,1,30,6],[31,1,31,6],[32,1,32,6],[33,1,33,6],[57,1,57,6],[46,1,46,6],[35,1,35,6],[36,1,36,6],[37,1,37,6],[38,1,38,6],[39,1,39,6],[40,1,40,6],[41,1,41,6],[42,1,42,6],[43,1,43,6],[44,1,44,6],[45,1,45,6],[52,1,52,6],[53,1,53,6],[54,1,54,6],[55,1,55,6],[56,1,56,6],[47,1,47,6],[48,1,48,6],[49,1,49,6],[50,1,50,6],[51,1,51,6],[68,1,68,6],[69,1,69,6],[70,1,70,6],[71,1,71,6],[60,1,60,6],[63,1,63,6],[64,1,64,6],[65,1,65,6],[66,1,66,6],[67,1,67,6],[2,0,2,14],[85,1,85,6],[73,1,73,6],[74,1,74,6],[75,1,75,6],[76,1,76,6],[77,1,77,6],[78,1,78,6],[79,1,79,6],[80,1,80,6],[81,1,81,6],[82,1,82,6],[84,1,84,6],[72,1,72,6],[61,1,61,6],[62,1,62,6]]}
[]
[]
["Exhibit 4.3 - ESTIMATED DEVELOPMENT BUDGET"]
[]
[]
["Mortgagor:",null,{"$f":"IF(ISBLANK(Application!D49), \"\", Application!D49)","v":""},null,null,null,null,null,null,null,null,null,"CHFA Loan No.:",{"$f":"IF(ISBLANK('3.16 Fincl Asst Wksht'!C13),\" \", '3.16 Fincl Asst Wksht'!C13)","v":" "}]
["Development Name:",null,null,{"$f":"IF(ISBLANK(Application!D11), \"\", Application!D11)","v":""},null,null,null,null,null,null,null,null,"CHFA Held Sources Amount:",{"$f":"+O86","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Alternate Sources Amount:",{"$f":"+N86","v":0}]
[]
[null,null,null,null,null,null,null,"TOTAL ESTIMATED BUDGET","ALTERNATE SOURCES",null,null,null,null,null,"CHFA\n(Loan,Escrow,Other)"]
[null,null,null,null,null,null,null,null,"UTILITY","OWNER HELD RESERVES","DECD\n(Home,CDBG,Flex)","OTHER","OTHER","Total"]
[1,"Testing",null,null,null,null,null,{"$f":"+N12+O12","v":0},null,null,null,null,null,{"$f":"+I12+J12+K12+L12+M12","v":0}]
[2,"Environmental",null,null,null,null,null,{"$f":"+N13+O13","v":0},null,null,null,null,null,0]
[3,"Grading & Excavation",null,null,null,null,null,0,null,null,null,null,null,0]
[4,"Site Utilities",null,null,null,null,null,0,null,null,null,null,null,0]
[5,"Paving Walks and Signs",null,null,null,null,null,{"$f":"+N16+O16","v":0},null,null,null,null,null,0]
[6,"Unusual Site Conditions",null,null,null,null,null,{"$f":"+N17+O17","v":0},null,null,null,null,null,0]
[7,"Lawns and Plantings",null,null,null,null,null,{"$f":"+N18+O18","v":0},null,null,null,null,null,0]
[8,"Other Site Work",null,null,null,null,null,0,null,null,null,null,null,0]
[9,"Demolition",null,null,null,null,null,0,null,null,null,null,null,0]
[10,"Concrete",null,null,null,null,null,0,null,null,null,null,null,0]
[11,"Masonry",null,null,null,null,null,0,null,null,null,null,null,0]
[12,"Metals",null,null,null,null,null,0,null,null,null,null,null,0]
[13,"Rough Carpentry",null,null,null,null,null,0,null,null,null,null,null,0]
[14,"Finish Carpentry",null,null,null,null,null,{"$f":"+N25+O25","v":0},null,null,null,null,null,0]
[15,"Moisture Protection",null,null,null,null,null,{"$f":"+N26+O26","v":0},null,null,null,null,null,0]
[16,"Insulation",null,null,null,null,null,{"$f":"+N27+O27","v":0},null,null,null,null,null,0]
[17,"Roofing",null,null,null,null,null,0,null,null,null,null,null,0]
[18,"Sheet Metal",null,null,null,null,null,0,null,null,null,null,null,0]
[19,"Siding",null,null,null,null,null,0,null,null,null,null,null,0]
[20,"Doors & Hardware",null,null,null,null,null,0,null,null,null,null,null,0]
[21,"Windows & Glazing",null,null,null,null,null,0,null,null,null,null,null,0]
[22,"Acoustical Tile",null,null,null,null,null,0,null,null,null,null,null,0]
[23,"Drywall",null,null,null,null,null,0,null,null,null,null,null,0]
[24,"Ceramic Tile",null,null,null,null,null,0,null,null,null,null,null,0]
[25,"Wood Flooring",null,null,null,null,null,0,null,null,null,null,null,0]
[26,"Resilient Flooring",null,null,null,null,null,0,null,null,null,null,null,0]
[27,"Painting and Decorating",null,null,null,null,null,0,null,null,null,null,null,0]
[28,"Carpet",null,null,null,null,null,0,null,null,null,null,null,0]
[29,"Unit AC and/or Sleeves",null,null,null,null,null,0,null,null,null,null,null,0]
[30,"Specialties",null,null,null,null,null,0,null,null,null,null,null,0]
[31,"Special Equipment (specify)",null,null,null,null,null,0,null,null,null,null,null,0]
[32,"Cabinets & Vanities",null,null,null,null,null,0,null,null,null,null,null,0]
[33,"Appliances",null,null,null,null,null,0,null,null,null,null,null,0]
[34,"Blinds and Shades,Décor",null,null,null,null,null,0,null,null,null,null,null,0]
[35,"Special Construction",null,null,null,null,null,0,null,null,null,null,null,0]
[36,"Elevators",null,null,null,null,null,0,null,null,null,null,null,0]
[37,"Plumbing & Hot Water",null,null,null,null,null,0,null,null,null,null,null,0]
[38,"Hydronic Heating",null,null,null,null,null,0,null,null,null,null,null,0]
[39,"HVAC",null,null,null,null,null,0,null,null,null,null,null,0]
[40,"Fire Suppression",null,null,null,null,null,0,null,null,null,null,null,0]
[41,"Electrical ",null,null,null,null,null,0,null,null,null,null,null,0]
[42,"Total Allowances for All Divisions",null,null,null,null,null,0,null,null,null,null,null,0]
[43,"General Requirements",null,null,null,null,null,0,null,null,null,null,null,0]
[44,"Builders Overhead/Profit",null,null,null,null,null,0,null,null,null,null,null,0]
[45,"Change Order Summary",null,null,null,null,null,0,null,null,null,null,null,0]
[46,"Building Permits/Performance & Payment Bonds",null,null,null,null,null,0,null,null,null,null,null,0]
[47,"Subtotal",null,null,null,null,null,{"$f":"SUM(H12:H57)","v":0},0,0,0,0,0,0,0]
[48,"Hard Cost Contingency ",null,null,null,null,null,{"$f":"+N59+O59","v":0},null,null,null,null,null,0]
[49,"TOTAL CONSTRUCTION COSTS",null,null,null,null,null,{"$f":"+H58+H59","v":0},{"$f":"+I58+I59","v":0},0,0,0,0,0,0]
[50,"Architectural Design",null,null,null,null,null,{"$f":"+N61+O61","v":0},null,null,null,null,null,0]
[51,"Architectural Supervision",null,null,null,null,null,0,null,null,null,null,null,0]
[52,"Engineering",null,null,null,null,null,0,null,null,null,null,null,0]
[53,"Blueprints/Copies/Printing",null,null,null,null,null,0,null,null,null,null,null,0]
[54,"Property Survey",null,null,null,null,null,0,null,null,null,null,null,0]
[55,"Env. Testing/Monitoring",null,null,null,null,null,0,null,null,null,null,null,0]
[56,"Construction Interest",null,null,null,null,null,0,null,null,null,null,null,0]
[57,"Construction Insurance",null,null,null,null,null,0,null,null,null,null,null,0]
[58,"Construction Period Utilities",null,null,null,null,null,0,null,null,null,null,null,0]
[59,"Real Estate Taxes",null,null,null,null,null,0,null,null,null,null,null,0]
[60,"Appraisal/Market Study",null,null,null,null,null,0,null,null,null,null,null,0]
[61,"Relocation",null,null,null,null,null,0,null,null,null,null,null,0]
[62,"Legal Fees",null,null,null,null,null,0,null,null,null,null,null,0]
[63,"Title & Recording",null,null,null,null,null,0,null,null,null,null,null,0]
[64,"Predevelopment Loan Orig. Fee",null,null,null,null,null,0,null,null,null,null,null,0]
[65,"Predevelopment Interest Costs",null,null,null,null,null,0,null,null,null,null,null,0]
[66,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"+I77+J77+K77+L77+M77","v":0}]
[67,null,null,null,null,null,null,0,null,null,null,null,null,0]
[68,null,null,null,null,null,null,0,null,null,null,null,null,0]
[69,null,null,null,null,null,null,0,null,null,null,null,null,0]
[70,null,null,null,null,null,null,0,null,null,null,null,null,0]
[71,null,null,null,null,null,null,0,null,null,null,null,null,0]
[72,"Subtotal",null,null,null,null,null,{"$f":"SUM(H61:H82)","v":0},0,0,0,0,0,0,0]
[73,"Soft Cost Contingency",null,null,null,null,null,{"$f":"+N84+O84","v":0},null,null,null,null,null,0]
[74,"TOTAL Soft Costs",null,null,null,null,null,{"$f":"+H83+H84","v":0},{"$f":"+I83+I84","v":0},0,0,0,0,0,0]
[75,"PROJECT TOTAL",null,null,null,null,null,{"$f":"+H85+H60","v":0},{"$f":"+I85+I60","v":0},0,0,0,0,0,0]

{"sheet":"4.4 Cash Flow Projection","index":10,"n_rows":102,"n_cols":46,"rows_kept":102,"cut":false,"hidden":false,"merged":[[2,3,2,6],[5,33,5,34],[5,2,5,3],[5,7,5,8],[5,14,5,15],[5,22,5,23]]}
[]
[]
[null,null,null,"Exhibit 4.4 - CASH FLOW PROJECTION"]
[]
[]
[null,"DEVELOPMENT NAME",{"$f":"IF(ISBLANK(Application!D49), \"\", Application!D49)","v":""},null,null,null,"APPLICANT",{"$f":"IF(ISBLANK(Application!D11), \"\", Application!D11)","v":""}]
[]
["INCOME",null,null,null,null,null,1,{"$f":"G8+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":"'3.7 Development Schedule'!B47","v":0},{"$f":"+G9+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":"IF(ISBLANK('4.1 Rental Income Calc Wrksht'!N51),\"\",'4.1 Rental Income Calc Wrksht'!N51)","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. Vacancy Loss",0.02,null,{"$f":"IF(ISBLANK('4.1 Rental Income Calc Wrksht'!O51),\"\",'4.1 Rental Income Calc Wrksht'!O51)","v":0},{"$f":"G12*(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,0]
[null,null,null,"= RESIDENTIAL - Qualified / Afford. Net Rental Income",0.02,null,{"$f":"G11-G12","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 Gross Rental Income",0.02,null,null,{"$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 Vacancy Loss",0.02,null,null,{"$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,"= RESIDENTIAL - Market Rate Net Rental Income",0.02,null,{"$f":"G14-G15","v":0},{"$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,"Other Income",0.02,null,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]
[null,null,null,null," EFFECTIVE GROSS INCOME (EGI)  ",null,{"$f":"G13+G16+G17","v":0},{"$f":"H13+H16+H17","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":"G20*(1+$E20)","v":0},{"$f":"H20*(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]
[null,null,null,"Maintenance",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,"Operating and Other",0.03,null,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]
[null,null,null,"Other",0.03,null,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]
[null,null,null,"Capital (Replacement) Reserve",0.04,null,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]
[null,null,null,"Real  Estate Taxes / PILOT's",0.03,null,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]
[null,null,null,null,"Sub Total: ANNUAL EXPENSES  ",null,{"$f":"SUM(G20:G25)","v":0},{"$f":"SUM(H20:H25)","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":"G18-G26","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":"G24","v":0},{"$f":"G29+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]
[]
["SCHEDULED ANNUAL DEBT SERVICE (ADS)"]
[{"$f":"'4.8 Sources of Funds'!A33","v":"CHFA Loan 1st Mortg. Loan [ Tax-Exempt Bonds ]"},null,null,{"$f":"'4.8 Sources of Funds'!E33","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K33","v":0},{"$f":"G32","v":0},{"$f":"H32","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":"'4.8 Sources of Funds'!F33","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G32=0),\"n/a\",G$27/(G$32))","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"]
[null,null,"Contract Rate > ",{"$f":"'4.8 Sources of Funds'!G33","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$32=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(G34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*H8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(H34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*I8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(I34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*J8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(J34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*K8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(K34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*L8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(L34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*M8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(M34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*N8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(N34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*O8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(O34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*P8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(P34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*Q8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(Q34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*R8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(R34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*S8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(S34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*T8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(T34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*U8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(U34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*V8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(V34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*W8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(W34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*X8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(X34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*Y8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(Y34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*Z8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(Z34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AA8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AA34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AB8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AB34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AC8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AC34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AD8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AD34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AE8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AE34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AF8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AF34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AG8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AG34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AH8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AH34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AI8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AI34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AJ8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AJ34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AK8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AK34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AL8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AL34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AM8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AM34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AN8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AN34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AO8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AO34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AP8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AP34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AQ8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AQ34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AR8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AR34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AS8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0},{"$f":"IF(AS34=0,0,(FV('4.8 Sources of Funds'!$G$32/12,12*AT8,'4.8 Sources of Funds'!$K$32/12,'4.8 Sources of Funds'!$E$32*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A34","v":"CHFA 1st Mortg. Loan [ Taxable Bonds ]"},null,null,{"$f":"'4.8 Sources of Funds'!E34","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K34","v":0},{"$f":"G36","v":0},{"$f":"H36","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":"'4.8 Sources of Funds'!F34","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G36=0),\"n/a\",G$27/(G$32+G36))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H36=0),\"n/a\",H$27/(H$32+H32))","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":"'4.8 Sources of Funds'!G34","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$36=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(G38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*H8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(H38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*I8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(I38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*J8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(J38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*K8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(K38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*L8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(L38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*M8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(M38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*N8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(N38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*O8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(O38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*P8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(P38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*Q8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(Q38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*R8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(R38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*S8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(S38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*T8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(T38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*U8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(U38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*V8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(V38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*W8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(W38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*X8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(X38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*Y8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(Y38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*Z8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(Z38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AA8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AA38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AB8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AB38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AC8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AC38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AD8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AD38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AE8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AE38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AF8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AF38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AG8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AG38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AH8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AH38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AI8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AI38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AJ8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AJ38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AK8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AK38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AL8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AL38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AM8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AM38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AN8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AN38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AO8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AO38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AP8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AP38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AQ8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AQ38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AR8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AR38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AS8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0},{"$f":"IF(AS38=0,0,(FV('4.8 Sources of Funds'!$G$33/12,12*AT8,'4.8 Sources of Funds'!$K$33/12,'4.8 Sources of Funds'!$E$33*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A35","v":"CHFA 1st Mortg. Loan [ Non-Bond Proceeds ]"},null,null,{"$f":"'4.8 Sources of Funds'!E35","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K35","v":0},{"$f":"G40","v":0},{"$f":"H40","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":"'4.8 Sources of Funds'!F35","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G40=0),\"n/a\",G$27/(G$40+G36+G32))","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"]
[null,null,"Contract Rate > ",{"$f":"'4.8 Sources of Funds'!G35","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$40=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF(G42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*H8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(H42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*I8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(I42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*J8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(J42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*K8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(K42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*L8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(L42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*M8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(M42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*N8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(N42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*O8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(O42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*P8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(P42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*Q8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(Q42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*R8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(R42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*S8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(S42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*T8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(T42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*U8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(U42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*V8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(V42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*W8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(W42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*X8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(X42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*Y8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(Y42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*Z8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(Z42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AA8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AA42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AB8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AB42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AC8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AC42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AD8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AD42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AE8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AE42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AF8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AF42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AG8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AG42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AH8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AH42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AI8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AI42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AJ8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AJ42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AK8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AK42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AL8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AL42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AM8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AM42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AN8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AN42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AO8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AO42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AP8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AP42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AQ8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AQ42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AR8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AR42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AS8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0},{"$f":"IF(AS42=0,0,(FV('4.8 Sources of Funds'!$G$34/12,12*AT8,'4.8 Sources of Funds'!$K$34/12,'4.8 Sources of Funds'!$E$34*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A36","v":"CHFA Next Steps Funds"},null,null,{"$f":"'4.8 Sources of Funds'!E36","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K36","v":0},{"$f":"G44","v":0},{"$f":"H44","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":"'4.8 Sources of Funds'!F36","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G44=0),\"n/a\",G$27/(G$32+G36+G40+G44))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H44=0),\"n/a\",H$27/(H$32+H44+H36+H40))","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":"'4.8 Sources of Funds'!G36","v":0},"Bal. (E.O.Y.)",null,{"$f":"'4.8 Sources of Funds'!$E$36","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0},{"$f":"IF($D$44=0,0,(FV('4.8 Sources of Funds'!$G$35/12,12,'4.8 Sources of Funds'!$K$35/12,'4.8 Sources of Funds'!$E$35*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A37","v":"DOH / HUD HOME Funds"},null,null,{"$f":"'4.8 Sources of Funds'!E37","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K37","v":0},{"$f":"G48","v":0},{"$f":"H48","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":"'4.8 Sources of Funds'!F37","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G48=0),\"n/a\",G$27/(G$32+G48+G44+G40+G36))","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"]
[null,null,"Contract Rate > ",{"$f":"'4.8 Sources of Funds'!G37","v":0},"Bal. (E.O.Y.)",null,{"$f":"'4.8 Sources of Funds'!E37","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0},{"$f":"IF($D$48=0,0,(FV('4.8 Sources of Funds'!$G$36/12,12,'4.8 Sources of Funds'!$K$36/12,'4.8 Sources of Funds'!$E$36*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A38","v":"DOH Affordable Housing Program - FLEX"},null,null,{"$f":"'4.8 Sources of Funds'!E38","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K38","v":0},{"$f":"G52","v":0},{"$f":"H52","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":"'4.8 Sources of Funds'!F38","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G52=0),\"n/a\",G$27/(G$32+G52+G48+G44+G40+G36))","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"]
[null,null,"Contract Rate > ",{"$f":"'4.8 Sources of Funds'!G38","v":0},"Bal. (E.O.Y.)",null,{"$f":"'4.8 Sources of Funds'!E38","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0},{"$f":"IF($D$52=0,0,(FV('4.8 Sources of Funds'!$G$37/12,12,'4.8 Sources of Funds'!$K$37/12,'4.8 Sources of Funds'!$E$37*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A39","v":"DOH Housing Trust Fund"},null,null,{"$f":"'4.8 Sources of Funds'!E39","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K39","v":0},{"$f":"G56","v":0},{"$f":"H56","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":"'4.8 Sources of Funds'!F39","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G56=0),\"n/a\",G$27/(G$32+G56+G52+G48+G44+G40+G36))","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"]
[null,null,"Contract Rate > ",{"$f":"'4.8 Sources of Funds'!G39","v":0},"Bal. (E.O.Y.)",null,{"$f":"'4.8 Sources of Funds'!F39","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0},{"$f":"IF($D$56=0,0,(FV('4.8 Sources of Funds'!$G$38/12,12,'4.8 Sources of Funds'!$K$38/12,'4.8 Sources of Funds'!$E$38*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A40","v":"DOH / HUD CDBG Small Cities Funds"},null,null,{"$f":"'4.8 Sources of Funds'!E40","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K40","v":0},{"$f":"G60","v":0},{"$f":"H60","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":"'4.8 Sources of Funds'!F40","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G60=0),\"n/a\",G$27/(G$32+G56+G52+G48+G44+G40+G36))","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"]
[null,null,"Contract Rate > ",{"$f":"'4.8 Sources of Funds'!G40","v":0},"Bal. (E.O.Y.)",null,{"$f":"'4.8 Sources of Funds'!E40","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0},{"$f":"IF($D$60=0,0,(FV('4.8 Sources of Funds'!$G$39/12,12,'4.8 Sources of Funds'!$K$39/12,'4.8 Sources of Funds'!$E$39*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A41","v":"DOH $300MM Housing Portfolio"},null,null,{"$f":"'4.8 Sources of Funds'!E41","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K41","v":0},{"$f":"G64","v":0},{"$f":"H64","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":"'4.8 Sources of Funds'!F41","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G64=0),\"n/a\",G$27/(G$32+G60+G56+G64+G52+G48+G44+G40+G36))","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"]
[null,null,"Contract Rate > ",{"$f":"'4.8 Sources of Funds'!G41","v":0},"Bal. (E.O.Y.)",null,{"$f":"'4.8 Sources of Funds'!E41","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0},{"$f":"IF($D$64=0,0,(FV('4.8 Sources of Funds'!$G$40/12,12,'4.8 Sources of Funds'!$K$40/12,'4.8 Sources of Funds'!$E$40*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A42","v":"Other Amortizing Debt [ Specify ]"},null,null,{"$f":"'4.8 Sources of Funds'!E42","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K42","v":0},{"$f":"G68","v":0},{"$f":"H68","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":"'4.8 Sources of Funds'!F42","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G68=0),\"n/a\",G$27/(G$32+G68+G64+G60+G56+G52+G48+G44+G40+G36))","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"]
[null,null,"Contract Rate > ",{"$f":"'4.8 Sources of Funds'!G42","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$68=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(G70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*H8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(H70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*I8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(I70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*J8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(J70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*K8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(K70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*L8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(L70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*M8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(M70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*N8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(N70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*O8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(O70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*P8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(P70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*Q8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(Q70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*R8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(R70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*S8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(S70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*T8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(T70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*U8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(U70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*V8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(V70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*W8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(W70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*X8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(X70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*Y8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(Y70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*Z8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(Z70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AA8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AA70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AB8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AB70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AC8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AC70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AD8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AD70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AE8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AE70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AF8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AF70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AG8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AG70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AH8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AH70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AI8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AI70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AJ8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AJ70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AK8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AK70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AL8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AL70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AM8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AM70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AN8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AN70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AO8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AO70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AP8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AP70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AQ8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AQ70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AR8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AR70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AS8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0},{"$f":"IF(AS70=0,0,(FV('4.8 Sources of Funds'!$G$41/12,12*AT8,'4.8 Sources of Funds'!$K$41/12,'4.8 Sources of Funds'!$E$41*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A43","v":"Other Amortizing Debt [ Specify ]"},null,null,{"$f":"'4.8 Sources of Funds'!E43","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K43","v":0},{"$f":"G72","v":0},{"$f":"H72","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":"'4.8 Sources of Funds'!F43","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G72=0),\"n/a\",G$27/(G$32+G72+G68+G64+G60+G56+G52+G48+G44+G40+G36))","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"]
[null,null,"Contract Rate > ",{"$f":"'4.8 Sources of Funds'!G43","v":0},"Bal. (E.O.Y.)",null,{"$f":"IF($D$72=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF(G74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*H8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(H74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*I8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(I74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*J8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(J74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*K8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(K74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*L8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(L74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*M8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(M74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*N8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(N74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*O8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(O74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*P8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(P74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*Q8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(Q74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*R8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(R74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*S8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(S74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*T8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(T74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*U8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(U74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*V8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(V74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*W8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(W74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*X8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(X74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*Y8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(Y74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*Z8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(Z74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AA8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AA74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AB8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AB74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AC8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AC74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AD8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AD74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AE8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AE74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AF8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AF74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AG8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AG74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AH8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AH74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AI8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AI74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AJ8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AJ74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AK8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AK74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AL8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AL74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AM8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AM74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AN8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AN74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AO8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AO74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AP8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AP74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AQ8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AQ74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AR8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AR74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AS8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0},{"$f":"IF(AS74=0,0,(FV('4.8 Sources of Funds'!$G$42/12,12*AT8,'4.8 Sources of Funds'!$K$42/12,'4.8 Sources of Funds'!$E$42*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A44","v":"Other [ Specify ]"},null,null,{"$f":"'4.8 Sources of Funds'!E44","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K43","v":0},{"$f":"G76","v":0},{"$f":"H76","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":"'4.8 Sources of Funds'!F44","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G76=0),\"n/a\",G$27/(G$33+G76+G72+G68+G64+G60+G56+G52+G48+G44+G40+G36))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H76=0),\"n/a\",H$27/(H$32+H76+H72+H68+H64+H60+H56+H52+H48+H44+H40+H36))","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":"'4.8 Sources of Funds'!G44","v":0},"Bal. (E.O.Y.)",null,{"$f":"'4.8 Sources of Funds'!$E$44","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$43/12,12,'4.8 Sources of Funds'!$K$43/12,'4.8 Sources of Funds'!$E$43*-1)))","v":0}]
[]
[{"$f":"'4.8 Sources of Funds'!A45","v":"Other [ Specify ]"},null,null,{"$f":"'4.8 Sources of Funds'!E45","v":0},"Pay Rate ADS",null,{"$f":"'4.8 Sources of Funds'!K44","v":0},{"$f":"G80","v":0},{"$f":"H80","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":"'4.8 Sources of Funds'!F45","v":0},"DSC",null,{"$f":"IF(OR(G$27<=0,G80=0),\"n/a\",G$27/(G$33+G80+G76+G72+G68+G64+G60+G56+G52+G48+G44+G40+G36))","v":"n/a"},{"$f":"IF(OR(H$27<=0,H80=0),\"n/a\",H$27/(H$32+H80+H76+H72+H68+H64+H60+H56+H52+H48+H44+H40+H36))","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":"'4.8 Sources of Funds'!G45","v":0},"Bal. (E.O.Y.)",null,{"$f":"'4.8 Sources of Funds'!F44","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0},{"$f":"IF($D$76=0,0,(FV('4.8 Sources of Funds'!$G$44/12,12,'4.8 Sources of Funds'!$K$44/12,'4.8 Sources of Funds'!$E$44*-1)))","v":0}]
[]
[null,null,null,null,"ADS STOT. =",null,{"$f":"G32+G36+G40+G44+G48+G52+G56+G60+G64+G68+G72+G76+G80","v":0},{"$f":"H32+H36+H40+H44+H48+H52+H56+H60+H64+H68+H72+H76+H80","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-G84,0)","v":0},{"$f":"ROUND(H27-H84,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,null,null,null,"PROJECT DSC =",null,{"$f":"IF(OR(G27<=0,G84<=0),0,G27/G84)","v":0},{"$f":"IF(OR(H27<=0,H84<=0),0,H27/H84)","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 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},{"$f":"H$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]
[]
[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$84>0,H$88<1),H$84-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},{"$f":"IF(H95>0,ROUND((H94-(H95/2)+(H97))*($E96),0),ROUND((H94+H97)*$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]
[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$84*1.15)-(H$84*H$88),IF(H$88<1,(H$84*1.15)-H$84,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$84*1.05)-(H$84*H$88),IF(H$88<1,(H$84*1.05)-H$84,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(G84=0,G27<0),0,IF(G$88>1.15,G$27,G$27+G95+G99))","v":0},{"$f":"IF(AND(H84=0,H27<0),0,IF(H$88>1.15,H$27,H$27+H95+H99))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(AA84=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,G84=0),\"n/a\",G101/G84)","v":"n/a"},{"$f":"IF(OR(H101=0,H84=0),\"n/a\",H101/H84)","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"]

{"sheet":"4.8 Sources of Funds","index":11,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[[2,0,2,12],[5,8,5,10],[12,6,12,12],[13,6,13,12],[10,6,10,12],[11,6,11,12],[3,0,3,12],[5,2,5,5],[44,11,44,12],[34,11,34,12],[35,11,35,12],[37,11,37,12],[39,11,39,12],[36,11,36,12],[23,6,23,12],[43,11,43,12],[14,6,14,12],[22,6,22,12],[15,6,15,12],[38,11,38,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[32,11,32,12],[24,6,24,12],[33,11,33,12],[28,11,28,12]]}
[]
[]
["Exhibit 4.8- SOURCES OF FUNDS"]
[]
[]
["DEVELOPMENT NAME",null,{"$f":"IF(ISBLANK(Application!D49), \"\", Application!D49)","v":""},null,null,null,null,"APPLICANT",{"$f":"IF(ISBLANK(Application!D11), \"\", Application!D11)","v":""}]
[]
[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(C11:C25)","v":0},null,{"$f":"SUM(E11:E25)","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(E33=0,0,(PMT(G33/12,F33*12,E33*-1,0))*12)","v":0}]
["CHFA 1st Mortg. Loan [ Taxable Bonds ]",null,null,null,null,null,null,null,null,"N/A",{"$f":"IF(E34=0,0,(PMT(G34/12,F34*12,E34*-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(E36=0,0,(PMT(G36/12,F36*12,E36*-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,0,null,{"$f":"SUM(E33:E45)","v":0},null,null,null,null,"Total Scheduled Debt Service",{"$f":"SUM(K33:K45)","v":0}]
[]
["TOTAL Sources",null,0,null,{"$f":"E26+E46","v":0}]
["Total Development Budget",null,0,null,{"$f":"'4.3 Estmd Development Budget'!H86","v":0}]
["Sources LESS Uses",null,0,null,{"$f":"E48-E49","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."]