{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INSTRUCTIONS","1. SOURCES OF FUNDS","2. BUDGET (SOURCES & USES)","3. CLEAN-UP BUDGET","4. PROPERTY VALUE AND TAXES","ROI (Grant)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[23,2,23,10],[25,2,25,10],[27,2,27,10],[18,2,21,10],[2,2,3,10],[13,2,13,10],[14,2,16,10],[6,3,6,8],[8,3,8,8],[10,2,11,10]]}
[]
[]
[null,null,"RG APPLICATION\nPART B: SECTION III\nFINANCING, BUDGET, AND RETURN ON INVESTMENT DETAILS"]
[]
[]
[]
[null,null,"Applicant Name:",null,null,null,null,null,null,"(same as application main form)",null,null,{"$f":"D7","v":0}]
[]
[null,null,"Project Name:",null,null,null,null,null,null,"(same as application main form)",null,null,{"$f":"D9","v":0}]
[]
[null,null,"All Tabs must be completed.  This is part of the Application Form submission.  Applications without this attachment will be deemed incomplete.  Information provided in the various tabs should be consistent throughout the tabs/tables.  Additional Instructions on the tabs are provided below."]
[]
[]
[null,null,"1. SOURCES OF FUNDS"]
[null,null,"Use this table to describe all of the sources of funds in place or anticipated for both the cleanup and the redevelopment project.\n     DESCRIPTION COLUMN: Provide additional description (such as name of program, name of bank, philanthropic source, CHFA 4% Financing, etc.) \n     AMOUNT COLUMN: Amount expected or budgeted for that line item\n     TYPE COLUMN: Include whether the funding is debt, equity/cash, or tax credit\n     STATUS COLUMN: Describe status of fund assembly (examples: current request, in place, requested-decision pending (date), will be requested in future (date), not competitive  \n                                      source/automatic approval, will be requested in future (date), positive indication from Board, funding gap, source to be identified.  "]
[]
[]
[]
[null,null,"2. BUDGET (SOURCES/USES)\nThis table will help OBRD/DECD understand the overall budget, especially the uses of OBRD and other funds.\n      * The Sources of Funds row automatically populate from entries in Tab 1.\n      * Please be sure to read the notes at the bottom of the table.\n      * Percentage of grant expenses on soft costs including DECD legal fees and professional project management expenses hired by primary recipient should be limited to 5%.  \n      * DECD is expecting that all funding has been identified and there is no funding gap apart from the current request.  "]
[]
[]
[]
[]
[null,null,"3. CLEAN-UP BUDGET\nThis tab provides the finer details of the cleanup budget.  \n     * DECD prefers that the majority (more than 95%) of program funds are used for hard costs (abatement, remediation, demolition etc.). \n     * It is prefered that assessment, engineering, project management, and other soft costs are funded from non-DECD sources.  The information provided should have a complete breakout \n       of remedial/cleanup activities by line item \n             (examples: soil excavation, transportation and disposal, engineered controls, capping, paving, building foundation, landscaping, parking cap, environmental use restrictions, demolition, \n              abatement, etc.).  \n     * There are dedicated rows to include the assessment/monitoring expenses and soft costs.    \n     \nFIRST COLUMN:      (OBRD-Current Round) Only include the current funding request.  If the grant will be used for limited assessment work or soft costs, please indicate as such.  The \n                                   total requested funding in this column (last row) must match what is requested in the main Application Form.  \n                                  ** Please verify before submitting. \nSECOND COLUMN: (Other DECD funding) Include amounts from other DECD sources including OBRD funding from previous rounds that are designated for this project's cleanup \n                                   budget. \nTHIRD COLUMN:      Include amounts of all other non-DECD sources that are designated for this project's cleanup budget.\nFOURTH COLUMN:  Include justification for the budget/estimates.  If the estimate is based on contractor bids or other formal estimates, please attach copies of the bid/estimate \n                                   documents. If details are not from actual cost estimates, please provide justification on how the numbers were arrived at (example – 150 cubic yards to be hauled; \n                                   estimated at $x/cubic yards) with details included in the total Budget Table."]
[]
[null,null,"4. PROPERTY VALUE & TAXES\nPlease fill in the current and projected appraised value and the taxes."]
[]
[null,null,"5. RETURN ON INVESTMENT (auto-generated)\nThis tab is auto-generated based on the entries in Tab 2.  Please do not fill out"]

{"sheet":"1. SOURCES OF FUNDS","index":1,"n_rows":73,"n_cols":17,"rows_kept":73,"cut":false,"hidden":false,"merged":[[56,2,56,3],[38,8,39,8],[49,2,49,4],[50,1,50,11],[6,2,6,9],[8,2,8,9],[12,8,16,8],[18,8,22,8],[24,8,30,8],[32,8,36,8],[10,10,47,10],[7,3,7,5],[2,2,3,10],[41,8,42,8],[44,8,47,8],[10,9,22,9],[24,9,47,9],[5,3,5,5]]}
[]
[]
[null,null,"SOURCES OF FUNDS"]
[]
[]
[null,null,"Applicant Name:",{"$f":"INSTRUCTIONS!M7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E6","v":0}]
[]
[null,null,"Project Name:",{"$f":"INSTRUCTIONS!M9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E8","v":0}]
[]
[null,null,"Organization","Sources of Funds","Description","Amount","Type","Status","Section Total 1","Section Total 2","Budget Total "]
[null,null,"DECD","Brownfield","Current round",null,null,null,{"$f":"F11","v":0},{"$f":"SUM(I11:I23)","v":0},{"$f":"SUM(F11:F49)","v":0}]
[]
[null,null,"DECD","Brownfield (previous round - same phase)",null,null,null,null,{"$f":"SUM(F13:F17)","v":0}]
[null,null,"DECD","Community Investment Fund (CIF30)"]
[null,null,"DECD","CT Community Challenge Grant"]
[null,null,"DECD","Other (UA/STEAP, Special Act, USRAP, SCRIF, etc.)"]
[null,null,"DECD","Other (UA/STEAP, Special Act, USRAP, SCRIF, etc.)"]
[]
[null,null,"State","Other (e.g., DOH-state bonded, DOT, DEEP, CT Green Bank)",null,null,null,null,{"$f":"SUM(F19:F23)","v":0}]
[null,null,"State","Other (e.g., DOH-state bonded, DOT, DEEP, CT Green Bank)"]
[null,null,"State","Other (e.g., DOH-state bonded, DOT, DEEP, CT Green Bank)"]
[null,null,"State","Other (e.g., DOH-state bonded, DOT, DEEP, CT Green Bank)"]
[null,null,"State","Other State Funds "]
[]
[null,null,"Federal","Federal EPA",null,null,null,null,{"$f":"SUM(F25:F31)","v":0},{"$f":"SUM(I25:I49)","v":0}]
[null,null,"Federal","CHFA 9% Low-Income Housing Tax Credit (LIHTC)"]
[null,null,"Federal","CHFA 4% Low-Income Housing Tax Credit (LIHTC)"]
[null,null,"Federal","State Historic Tax Credits"]
[null,null,"Federal","Federal Historic Tax Credits"]
[null,null,"Federal","Other (HOME, ARPA, IIJA, BIL, etc.)"]
[null,null,"Federal","Other (HOME, ARPA, IIJA, BIL, etc.)"]
[]
[null,null,"Local","Local Municipal Bonds",null,null,null,null,{"$f":"SUM(F33:F37)","v":0}]
[null,null,"Local","Local Tax Abatement/Credits"]
[null,null,"Local","Local Contribution"]
[null,null,"Local","Local Other"]
[null,null,"Local","Local Other "]
[]
[null,null,"Developer (debt 1)","Bank Financing 1",null,null,null,null,{"$f":"SUM(F39:F40)","v":0}]
[null,null,"Developer (debt 2)","Bank Financing 2"]
[]
[null,null,"Developer (equity 1)","Developer Contribution (Private Cash/Equity)",null,null,null,null,{"$f":"SUM(F42:F43)","v":0}]
[null,null,"Developer (equity 2)","Developer Contribution (Private Cash/Equity)"]
[]
[null,null,"Other Private Cash/Equity","Philanthropic",null,null,null,null,{"$f":"SUM(F45:F48)","v":0}]
[null,null,"Other Private Cash/Equity","Community Development Corporation "]
[null,null,"Other Private Cash/Equity","(describe)"]
[null,null,"Other Private Cash/Equity","(describe)"]
[]
[null,null,"Total Funding",null,null,{"$f":"SUM(F11:F49)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,"Total Brownfield Sources",null,{"$f":"F11","v":0}]
[null,null,"Browwnfield","Total Brownfield (Current Round)",{"$f":"F11","v":0}]
[null,null,"DECD 1","Total DECD Non-Brownfield  Sources",{"$f":"SUM(F11:F17)-F11","v":0}]
[null,null,"DECD 2","Total Non-DECD State Sources",{"$f":"SUM(F19:F23)","v":0}]
[null,null,"State 1","Total State Sources (no tax credits)",{"$f":"SUM(F11:F23)-F19","v":0}]
[null,null,"State 2","Total State Sources (with tax credits)",{"$f":"SUM(F11:F23)","v":0}]
[null,null,"Federal 1","Total Federal Sources (no tax credits)",{"$f":"SUM(F25:F31)-F26","v":0}]
[null,null,"Federal 2","Total Federal Sources (with tax credits)",{"$f":"SUM(F25:F31)","v":0}]
[null,null,"Local ","Total Local Sources",{"$f":"SUM(F33:F37)","v":0}]
[null,null,"Other","Total Other Sources",{"$f":"SUM(F39:F43)","v":0}]
[null,null,"Developer","Total Developer Sources",{"$f":"SUM(F45:F48)","v":0}]
[null,null,"Total","Total Project Sources",{"$f":"SUM(F11:F48)","v":0}]
[null,null,null,"Total Project Sources (10% variance)",{"$f":"SUM(F11:F49)-((SUM(F11:F49)*0.1))","v":0}]
[]
[null,null,null,"Non State Share",{"$f":"E64+E65+E66+E67","v":0}]
[null,null,null,"Developer Equity",{"$f":"F45","v":0}]
[null,null,null,"Developer Debt",{"$f":"F48","v":0}]

{"sheet":"2. BUDGET (SOURCES & USES)","index":2,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,2,48,11],[49,2,49,11],[50,2,50,11],[42,2,42,11],[43,2,43,11],[44,2,44,11],[45,2,45,11],[46,2,46,11],[38,2,38,11],[35,2,36,3],[33,2,33,3],[5,2,5,3],[47,2,47,11],[5,4,5,8],[7,4,7,8],[14,2,14,3],[10,2,10,3],[2,2,3,11],[36,6,36,11],[35,6,35,11],[9,2,9,11],[13,2,13,11]]}
[]
[]
[null,null,"BUDGET (SOURCES & USES)"]
[]
[]
[null,null,"Applicant Name",null,{"$f":"INSTRUCTIONS!M7","v":0}]
[]
[null,null,null,"Project Name",{"$f":"INSTRUCTIONS!D9","v":0}]
[]
[null,null,"Sources of Funds"]
[null,null,"Source of Funds",null,"Current\nDECD \nBrownfield Request","Other DECD Sources","Other State Funds","Federal Funds \n(7)","Local Funds \n(8)","Private/ Developer Debt\n(9)","Private Developer Cash/Equity","Total"]
[null,null,null,"Amount of Funding",{"$f":"'1. SOURCES OF FUNDS'!F11","v":0},{"$f":"SUM('1. SOURCES OF FUNDS'!F13:F17)","v":0},{"$f":"SUM('1. SOURCES OF FUNDS'!F19:F23)","v":0},{"$f":"SUM('1. SOURCES OF FUNDS'!F25:F31)","v":0},{"$f":"SUM('1. SOURCES OF FUNDS'!F33:F37)","v":0},{"$f":"SUM('1. SOURCES OF FUNDS'!F39:F40)","v":0},{"$f":"SUM('1. SOURCES OF FUNDS'!F42:F48)","v":0},{"$f":"SUM(E12:K12)","v":0}]
[]
[null,null,"Uses of Funds"]
[null,null,"Project Activity",null,"Current\nDECD \nBrownfield Request","Other DECD Sources","Other State Funds","Federal Funds \n(7)","Local Funds \n(8)","Private/ Developer Debt\n(9)","Private Developer Cash/Equity","Total"]
[null,null,1,"Land Purchase (2)","Not Eligible",null,null,null,null,null,null,{"$f":"SUM(E16:K16)","v":0}]
[null,null,2,"Pre-Development (2)","Not Eligible",null,null,null,null,null,null,0]
[null,null,3,"Development Fee (2)","Not Eligible",null,null,null,null,null,null,0]
[null,null,4,"Planning (3)",null,null,null,null,null,null,null,0]
[null,null,5,"Environmental Assessment (3)",null,null,null,null,null,null,null,0]
[null,null,6,"Environmental Remediation",null,null,null,null,null,null,null,0]
[null,null,7,"Environmental Abatement",null,null,null,null,null,null,null,0]
[null,null,8,"Environmental Monitoring",null,null,null,null,null,null,null,0]
[null,null,9,"Demolition",null,null,null,null,null,null,null,0]
[null,null,10,"Construction",null,null,null,null,null,null,null,0]
[null,null,11,"Engineering",null,null,null,null,null,null,null,0]
[null,null,12,"Administration Soft Costs (4)",null,null,null,null,null,null,null,0]
[null,null,13,"DECD Legal Fee (5)",null,null,null,null,null,null,null,0]
[null,null,14,"Legal Costs (6)",null,null,null,null,null,null,null,0]
[null,null,15,"Contingency",null,null,null,null,null,null,null,0]
[null,null,16,"Other (Specify)",null,null,null,null,null,null,null,0]
[null,null,17,"Other (Specify)",null,null,null,null,null,null,null,0]
[null,null,18,"Other (Specify)",null,null,null,null,null,null,null,0]
[null,null,"TOTAL FUDING FOR CLEAN-UP  ",null,{"$f":"SUM(E19:E33)","v":0},{"$f":"SUM(F16:F33)","v":0},0,0,0,0,0,{"$f":"SUM(L16:L33)","v":0}]
[]
[null,null,"SOFT COSTS PERCENTAGE  ",null,"Total Project",{"$f":"(L18+L27+L28+L29)/L34","v":{"$error":"#DIV/0!"}},"(Development Fee + Admin Soft Costs + DECD Legal + Legal Costs) / Total"]
[null,null,null,null,"Brownfield \nPortion",{"$f":"(E27+E28+E29)/E34","v":{"$error":"#DIV/0!"}},"(Admin Soft Costs + DECD Legal + Legal Costs) / Current DECD Brownfield Request Total"]
[]
[null,null,"Additional Notes and Comments (if any):\n-Example: Deferred developer fee = $5,250,000 and Private investement of equity = $30,000,000\n-\n-\n-\n-\n-\n-"]
[]
[]
[]
[null,null,"Note 1: If the DECD funds include sources other than this funding round of the Brownfield Grant, please indicate as such.  Also, DECD prefers that the majority (more than 95%) of program funds are used for hard costs (abatement, remediation, demolition, etc.) as presented in the Clean-up estimates Table.  It is preferable that assessment, any engineering, project management and other soft costs are funded from non-DECD sources."]
[null,null,"Note 2: DECD Brownfield Funding is not eligible to be used for this line item."]
[null,null,"Note 3: DECD prefers that these line items are supported by other sources of funding (non-DECD sources) under this offering."]
[null,null,"Note 4: It should be noted that total administration expenses (including costs for DECD Legal) cannot exceed 5% of the total DECD funding request.  DECD will usually only pay for project management expenses."]
[null,null,"Note 5: DECD’s legal expenses for the DECD contract work (Assistance Agreement) are usually in the range of $5K to $10K depending on the complexity of the project.  DECD funds cannot be used for reimbursement of the legal expenses of the client’s legal team for the Assistance Agreement work."]
[null,null,"Note 6: Legal costs (non-DECD) could include legal work with regards to the actual clean-up (example: environmental use restriction, transfer act obligations, etc.) but not for any legal work associated with the DECD contract/Assistance Agreement."]
[null,null,"Note 7: Include Low Income Housing Tax Credits (LIHTC) and Historic Tax Credits in this column along with other federal grants."]
[null,null,"Note 8: Only include applicant’s direct share or contributions.  Land acquisition by applicant can be included as equity."]
[null,null,"Note 9: Private column should include all the expected debt.  Tax credits should be included in the Federal column.  Developer should only include developer’s cash & equity share.  Land acquisition by the developer can be included in this column."]

{"sheet":"3. CLEAN-UP BUDGET","index":3,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[28,3,28,4],[39,3,39,4],[10,3,10,4],[43,3,47,8],[58,3,58,8],[54,3,54,8],[55,3,55,8],[56,3,56,8],[57,3,57,8],[59,3,61,8],[2,3,3,8],[41,3,42,8],[5,3,5,4],[7,3,7,4],[5,5,5,8],[7,5,7,8],[12,5,12,7],[30,5,30,7],[4,3,4,8],[38,3,38,8],[29,3,29,8],[11,3,11,8],[48,3,48,8],[9,3,9,4],[37,3,37,4]]}
[]
[]
[null,null,null,"CLEAN-UP BUDGET"]
[]
[]
[null,null,null,"Applicant Name",null,{"$f":"INSTRUCTIONS!D7","v":0}]
[]
[null,null,null,"Project Name",null,{"$f":"INSTRUCTIONS!D9","v":0}]
[]
[null,null,null,"Sources of Funds",null,"Brownfield - \nCurrent \nRound\n(1)","Other DECD Sources\n(2)","Non-DECD Sources\n(3)","Budget Justification"]
[null,null,null,"Amount",null,{"$f":"'1. SOURCES OF FUNDS'!F11","v":0},{"$f":"G40","v":0},{"$f":"H40","v":0}]
[]
[null,null,null,null,null,"Hard Costs",null,null,"Justification for Budget Estimates (5)"]
[null,null,null,1,"Example: Soil Excavation"]
[null,null,null,2,"Example: Transportation & Disposal"]
[null,null,null,3,"Example: Cap Contaminated Soils"]
[null,null,null,4,"Example: Capping"]
[null,null,null,5,"Example: Paving or Parking Cap"]
[null,null,null,6,"Example: Hazardous Abatement"]
[null,null,null,7,"Example: Demolition"]
[null,null,null,8,"Example: Abatement"]
[null,null,null,9,"Example: Underground Utilities"]
[null,null,null,10,"Example: Partial Demolition"]
[null,null,null,11,"Example: Vapor Intrusion Mitigation"]
[null,null,null,12,"Other (specify)"]
[null,null,null,13,"Other (specify)"]
[null,null,null,14,"Other (specify)"]
[null,null,null,15,"Contingency (< 10% of funding)"]
[null,null,null,"Hard Costs - Subtotal",null,{"$f":"SUM(F14:F28)","v":0},{"$f":"SUM(G14:G28)","v":0},{"$f":"SUM(H14:H28)","v":0}]
[]
[null,null,null,null,null,"Soft Costs",null,null,"Justification for Budget Estimates (5)"]
[null,null,null,16,"Administrative Soft Costs (4)"]
[null,null,null,17,"Pre-development","Not Eligible"]
[null,null,null,18,"Planning Studies / Enviro Counsel"]
[null,null,null,19,"Limited-Assessment"]
[null,null,null,20,"Legal (DECD)"]
[null,null,null,21,"Legal (non-DECD)","Not Eligible"]
[null,null,null,"Soft Costs - Subtotal",null,{"$f":"SUM(F32:F37)","v":0},{"$f":"SUM(G32:G37)","v":0},{"$f":"SUM(H32:H37)","v":0}]
[]
[null,null,null,"Total",null,{"$f":"SUM(F38+F29)","v":0},{"$f":"G29+G38","v":0},{"$f":"H29+H38","v":0}]
[]
[null,null,null,"Please use this space to describe whether cost comparisons were made between proposed remedial methodologies. If available, please also provide EPA’s Analysis of Brownfield Cleanup Alternatives (ABCA) report."]
[]
[null,null,null,"\n\n\n\n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Note 1: Brownfield Grant/Loan requested in this application only.  Any Brownfield Grant/Loan previously awarded must be entered in Other DECD Sources column."]
[null,null,null,"Note 2: Include other DECD sources of funds that will go to Brownfield clean-up activities, including OBRD Brownfield funds awarded in previous rounds for \n              this phase of the project"]
[null,null,null,"Note 3: Include non-DECD sources of funds that will go to clean-up activities."]
[null,null,null,"Note 4: It should be noted that total administration expenses (including costs for DECD Legal) cannot exceed 5% of the total DECD funding \n             request.  DECD will usually only pay for project management expenses."]
[null,null,null,"Note 5: If the estimate is based on contractor bids or other formal estimates, please attach copies of the bid/estimate documents. If details are not from actual \n             cost estimates, please provide justification on how the numbers were arrived at (example – 150 cubic yards to be hauled; estimated at $x/cubic yards). \n             with details included in the total Budget Table."]

{"sheet":"4. PROPERTY VALUE AND TAXES","index":4,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":false,"merged":[[7,6,7,12],[15,5,15,8],[15,9,15,12],[13,2,13,12],[12,2,12,12],[17,2,20,12],[15,2,15,4],[2,2,3,12],[14,2,14,4],[14,5,14,8],[14,9,14,12],[10,5,10,8],[10,2,10,4],[9,2,9,12],[10,9,10,12],[11,2,11,4],[11,5,11,8],[11,9,11,12],[5,3,5,5],[5,6,5,12],[7,3,7,5]]}
[]
[]
[null,null,"Project Property Value and Tax Impact"]
[]
[]
[null,null,null,"Applicant Name",null,null,{"$f":"INSTRUCTIONS!$D$7","v":0},null,null,null,null,null,null,null,null,null,{"$f":"G6","v":0},{"$f":"M6","v":0}]
[]
[null,null,null,"Project Name",null,null,{"$f":"INSTRUCTIONS!$D$9","v":0}]
[]
[null,null,"Summary of Property Value Impact"]
[null,null,"Current Appraised Value \n(or valuation) \nof the Project Site",null,null,"Project Apprraised Value \n(or valuation) \nPost-development",null,null,null,"% Increase"]
[null,null,null,null,null,null,null,null,null,{"$f":"(F12-C12)/C12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"C12","v":0},{"$f":"F12","v":0}]
[]
[null,null,"Summary of Tax Impact"]
[null,null,"Most Recent Year Taxes \n(min $1)",null,null,"Projected Taxes\nYear 1 After\nRedevelopment Completed\n(min $1)",null,null,null,"% Increase"]
[null,null,null,null,null,null,null,null,null,{"$f":"(F16-C16)/C16","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Comments: \n\n\n"]

{"sheet":"ROI (Grant)","index":5,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,3,23,4],[24,3,24,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[16,2,16,5],[17,2,17,5],[5,3,5,7],[7,3,7,7],[2,2,3,9],[13,5,13,6],[14,3,14,4],[14,5,14,6],[13,3,13,4]]}
[]
[]
[null,null,"Return on Investment Metrics"]
[]
[]
[null,null,"Applicant Name",{"$f":"INSTRUCTIONS!M7","v":0}]
[]
[null,null,"Project Name",{"$f":"INSTRUCTIONS!M9","v":0}]
[]
[null,null,null,"All DECD Funding\n(X)","All State Funding\n(X)","Local (Applicant Share)\n(X)","Non-state Public Share\n(X)","Private/Developer Debt\n(X)","Developer Cash/Equity\n(X)","TOTAL REDEVELOPMENT PROJECT COST\n(Y)"]
[null,null,"AMOUNT",{"$f":"F19","v":0},{"$f":"F20","v":0},{"$f":"F21","v":0},{"$f":"F22","v":0},{"$f":"F23","v":0},{"$f":"F24","v":0},{"$f":"'1. SOURCES OF FUNDS'!F50","v":0}]
[null,null,"% SHARE OF TOTAL REDEVELOPMENT PROJECT \n(X/Y)",{"$f":"D11/J11","v":{"$error":"#DIV/0!"}},{"$f":"E11/J11","v":{"$error":"#DIV/0!"}},{"$f":"F11/J11","v":{"$error":"#DIV/0!"}},{"$f":"G11/J11","v":{"$error":"#DIV/0!"}},{"$f":"H11/J11","v":{"$error":"#DIV/0!"}},{"$f":"I11/J11","v":{"$error":"#DIV/0!"}},"---"]
[]
[null,null,"Future Appraised Value\nA","Current Appraised Value\nB",null,"Total Redevelopment Cost\nC",null,"Overall ROI\n(A-B) / C"]
[null,null,{"$f":"'4. PROPERTY VALUE AND TAXES'!S12","v":0},{"$f":"'4. PROPERTY VALUE AND TAXES'!R12","v":0},null,{"$f":"J11","v":0},null,{"$f":"(C15-D15)/F15","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Project Funding Totals"]
[null,null,"Data From Tab 1. Sources of Funds"]
[null,null,"All DECD Funding","DECD",null,{"$f":"SUM('1. SOURCES OF FUNDS'!F11:F17)","v":0}]
[null,null,"All State Funding","DECD + State",null,{"$f":"SUM('1. SOURCES OF FUNDS'!F11:F23)","v":0}]
[null,null,"Local (Applicant Share)","Local",null,{"$f":"SUM('1. SOURCES OF FUNDS'!F33:F37)","v":0}]
[null,null,"Non-State Public Share","Local + Federal",null,{"$f":"SUM('1. SOURCES OF FUNDS'!F25:F37)","v":0}]
[null,null,"Private/Developer Debt","Debt1 + Debt2",null,{"$f":"SUM('1. SOURCES OF FUNDS'!F39:F40)","v":0}]
[null,null,"Developer Cash/Equity","Equity1 + Equity2 + Other",null,{"$f":"SUM('1. SOURCES OF FUNDS'!F42:F48)","v":0}]
[null,null,"Total Redevelopment Project Cost","Total ",null,{"$f":"'1. SOURCES OF FUNDS'!F50","v":0}]