{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["DropDowns2017","Start","MF Cover and Table of Contents","MF Generals & Readiness","MF Units & Target Populations","MF Funding Sources","MF Applicant & Ownership","MF Contact Information","HO Cover and Table of Contents","HO Generals & Readiness","HO Units & Target Populations","HO Funding Sources","HO Design","HO Production Pipeline","HO Contact Information"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"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":"DropDowns2017","index":0,"n_rows":170,"n_cols":2,"rows_kept":170,"cut":false,"hidden":true,"merged":[]}
[]
[]
["OrgType_2017","Select…"]
[null,"Local Government"]
[null,"Local Housing Authority"]
[null,"Nonprofit Community, Neighborhood, State or Regional Organization"]
[null,"Federally-recognized Indian Tribe in the State of Washington"]
[null,"Regional Support Network (established under RCW Chapter 71.24)"]
[]
[]
["List_2017","Select…"]
[null,"Chronically Mentally Ill persons"]
[null,"Households/Families with Children"]
[null,"Veterans"]
[null,"Youth Under 18"]
[null,"Young Adults 18-24"]
[null,"Persons with a Disability"]
[null,"Seniors"]
[null,"Farmworkers"]
[null,"Seasonal/Migrant Farmworkers"]
[null,"Other low-income and/or special needs"]
[]
[]
["Res_Types","Select…"]
[null,"Shelter"]
[null,"Transitional"]
[null,"Permanent Supportive"]
[null,"Service-Enriched"]
[null,"Affordable Rental"]
[]
[]
["HousingStatus","Select…"]
[null,"Stably Housed"]
[null,"Homeless"]
[null,"At Risk of Homelessness"]
[null,"Any"]
[]
[]
["Configuration","Select…"]
[null,"Sleeping Room 1 Bed"]
[null,"Sleeping Room 2 Bed"]
[null,"Sleeping Room 3 Bed"]
[null,"Sleeping Room 4+ Bed"]
[null,"Beds (common room)"]
[null,"SRO"]
[null,"Studio"]
[null,"1 Bedroom"]
[null,"2 Bedroom"]
[null,"3 Bedroom"]
[null,"4 Bedroom"]
[null,"5+ Bedroom"]
[]
[]
["Counties","Select…"]
[null,"Adams"]
[null,"Asotin"]
[null,"Benton"]
[null,"Chelan"]
[null,"Clallam"]
[null,"Clark"]
[null,"Columbia"]
[null,"Cowlitz"]
[null,"Douglas"]
[null,"Ferry"]
[null,"Franklin"]
[null,"Garfield"]
[null,"Grant"]
[null,"Grays Harbor"]
[null,"Island"]
[null,"Jefferson"]
[null,"King"]
[null,"Kitsap"]
[null,"Kittitas"]
[null,"Klickitat"]
[null,"Lewis"]
[null,"Lincoln"]
[null,"Mason"]
[null,"Okanogan"]
[null,"Pacific"]
[null,"Pend Oreille"]
[null,"Pierce"]
[null,"San Juan"]
[null,"Skagit"]
[null,"Skamania"]
[null,"Snohomish"]
[null,"Spokane"]
[null,"Stevens"]
[null,"Thurston"]
[null,"Wahkiakum"]
[null,"Walla Walla"]
[null,"Whatcom"]
[null,"Whitman"]
[null,"Yakima"]
[]
[]
["LegDistricts","Select…"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[]
[]
["CongDistricts","Select…"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
[]
[]
[]
["Type","Select…"]
[null,"HO"]
[null,"MF"]
[]
[]
["ProjectYear","Select…"]
[null,"Year 1"]
[null,"Year 2"]

{"sheet":"Start","index":1,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[24,2,24,4],[24,5,24,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Project Type:",null,null,"Select…"]
[]
[]
[null,null,null,null,null,null,null,null,null,null," 2017 HTF Stage 1 v1.1"]

{"sheet":"MF Cover and Table of Contents","index":2,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[[11,2,11,8],[8,2,8,8],[16,2,16,8]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Project Name"]
[]
[]
[null,null,"Applicant Organization Name"]
[]
[]
[null,null,null,"This Organization is eligible to apply, per RCW and the criteria laid out in the NOFA:"]
[]
[null,null,"Development Consultant Firm Name (if Applicable)"]
[]
[]
[null,null,"Table of Contents and Checklist"]
[]
[null,null,null,"Generals & Readiness"]
[]
[null,null,null,"Units & Target Populations"]
[]
[null,null,null,"Funding Sources"]
[]
[null,null,null,"Applicant & Ownership"]
[]
[null,null,null,"Contact Information"]

{"sheet":"MF Generals & Readiness","index":3,"n_rows":92,"n_cols":16,"rows_kept":92,"cut":false,"hidden":true,"merged":[[45,10,45,12],[47,10,47,12],[12,3,19,15],[67,10,67,12],[49,3,49,5],[67,5,67,9],[70,13,70,14],[70,10,70,12],[21,3,21,5],[68,10,68,12],[69,10,69,12],[65,13,65,14],[66,13,66,14],[67,13,67,14],[68,13,68,14],[69,13,69,14],[43,10,43,12],[33,5,35,15],[39,5,41,15],[66,10,66,12],[65,5,65,9],[66,5,66,9],[71,10,71,12],[71,5,71,9],[71,13,71,14],[62,3,62,5],[51,3,51,5],[64,10,64,12],[64,13,64,14],[53,6,53,15],[55,6,55,9],[55,12,55,13],[64,5,64,9],[55,10,55,11],[64,3,64,4],[70,3,70,4],[71,3,71,4],[65,10,65,12],[68,5,68,9],[69,5,69,9],[70,5,70,9],[65,3,65,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[91,3,92,15],[94,3,97,15],[73,3,73,5],[75,3,76,15],[78,3,80,15],[86,3,89,15]]}
[]
[null,"GENERALS & READINESS"]
[]
[]
[null,null,null,"Project General Information"]
[]
[null,null,null,"Priority to Applicant (if multiple Projects submitted):",null,null,null,null,null,null,null,"of"]
[]
[null,null,null,"Is this a Year 1 (2017) or a Year 2 (2018) project?",null,null,null,null,null,null,"Select…"]
[]
[null,null,null,"Provide a brief narrative description of the proposed Project:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Project Activities"]
[]
[null,null,null,"Select all that apply"]
[]
[null,null,null,null,"New Construction",null,null,null,"Redevelopment",null,null,null,"Expiring Tax Credit Property"]
[]
[null,null,null,null,"Acquisition",null,null,null,"HUD/USDA Preservation",null,null,null,"Adaptive Reuse"]
[]
[null,null,null,null,"Rehabilitation"]
[]
[null,null,null,null,"Mixed Use (please explain):"]
[]
[]
[]
[]
[]
[null,null,null,null,"Other (please explain):"]
[]
[]
[]
[]
[]
[null,null,null,"Estimated Financial Closing Date (mm/dd/yyyy):"]
[]
[null,null,null,"Estimated Construction Start Date (mm/dd/yyyy):"]
[]
[null,null,null,"Estimated Certificate of Occupancy Date (mm/dd/yyyy):"]
[]
[null,null,null,"Project Location"]
[]
[null,null,null,"Single-Site Project"]
[]
[null,null,null,"Street Address"]
[]
[null,null,null,"City",null,null,null,null,null,null,"County",null,"Select…"]
[]
[null,null,null,"Legislative  District",null,null,"Select…"]
[]
[null,null,null,"Congressional District",null,null,"Select…"]
[]
[]
[null,null,null,"Multi-site Project"]
[]
[null,null,null,"Site Name/ID",null,"Street Address",null,null,null,null,"City",null,null,"County",null,"Leg District"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Select…",null,"Select…"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Site Control and Zoning"]
[]
[null,null,null,"Briefly describe the type of Site Control (e.g. Purchase & Sale Agreement, Land Lease, existing Ownership) being used, or intended to be used, to secure the project Site(s), and give an assessment of its status."]
[]
[]
[]
[]
[]
[]
[null,null,null,"Are all sites propertly zoned for the project?"]
[]
[null,null,null,"If no, explain how the project differs from the use for which project sites are currently zoned:"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Outline the steps that will be taken to address the described zoning issues (e.g. administrative, conditional use, hearing examiner, council approval), what approvals are required , and the time frame needed to resolve these issues:"]

{"sheet":"MF Units & Target Populations","index":4,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[11,10,11,11],[14,3,14,4],[8,10,8,11],[9,10,9,11],[10,10,10,11],[26,10,26,12],[25,10,25,12],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[7,12,7,13],[8,12,8,13],[9,12,9,13],[10,12,10,13],[11,12,11,13],[25,3,25,6],[25,7,25,9],[26,3,26,6],[26,7,26,9],[27,3,27,6],[27,7,27,9],[28,3,28,6],[28,7,28,9],[29,10,29,12],[28,10,28,12],[27,10,27,12],[30,7,30,9],[34,3,37,14],[31,3,31,6],[31,7,31,9],[31,10,31,12],[29,3,29,6],[29,7,29,9],[30,3,30,6],[30,10,30,12],[23,3,24,6],[23,7,24,9],[23,10,24,12],[23,13,24,13],[23,14,24,14]]}
[]
[null,"UNITS & TARGET POPULATIONS"]
[]
[]
[]
[null,null,null,"Unit Sizes"]
[]
[null,null,null,"Configuration",null,"Qty.","Area (ft2)","Avg # Persons Served",null,null,null,null,"Total Area (ft2)"]
[null,null,null,"Select…",null,null,null,null,null,null,"Residential"]
[null,null,null,null,null,null,null,null,null,null,"Common Area"]
[null,null,null,null,null,null,null,null,null,null,"Non-residential"]
[null,null,null,null,null,null,null,null,null,null,"Grand Total",null,{"$f":"SUM(M9:N11)","v":0}]
[]
[]
[null,null,null,"Totals",null,{"$f":"SUM(F9:F14)","v":0},null,{"$f":"SUMPRODUCT(F9:F14,H9:H14)","v":0}]
[]
[null,null,null,"Incomes to be Served"]
[]
[null,null,null,null,"≤30% AMI","40% AMI","50% AMI","60% AMI","80% AMI","Total LIH Units","Market Rate ","Common Area"," TOTAL UNITS"]
[null,null,null,"Qty.",null,null,null,null,null,{"$f":"SUM(E20:I20)","v":0},null,null,{"$f":"J20+K20+L20","v":0}]
[]
[null,null,null,"Populations to be Served"]
[]
[null,null,null,"Population Type",null,null,null,"Housing Status at Intake",null,null,"Residency Type",null,null,"Units or Beds?","Qty."]
[]
[null,null,null,"Select…",null,null,null,"Select…",null,null,"Select…",null,null,"Select…"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Units",{"$f":"SUM(O26:O32)","v":0}]
[null,null,null,"In the space below, provide detail on units for \"Other\" populations:"]

{"sheet":"MF Funding Sources","index":5,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":true,"merged":[[1,1,1,8],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[33,7,34,7],[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,6,20,6],[19,7,20,7],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[33,6,34,6],[51,7,52,7],[42,2,43,2],[42,3,43,3],[42,4,43,4],[42,5,43,5],[42,6,43,6],[42,7,43,7],[51,2,52,2],[51,3,52,3],[51,4,52,4],[51,5,52,5],[51,6,52,6]]}
[]
[null,"PROJECT FUNDING"]
[]
[]
[null,null,"Permanent Capital Funding Sources "]
[null,null,"Residential"]
[null,null,"Source and Type","Proposed Funding","Committed/ Conditional Funding","Application \nDate","Award Date","Total Funding"]
[]
[null,null,"WA State Housing Trust Fund (HTF) ",null,null,null,null,{"$f":"D9+E9","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Total Residential Development Cost",{"$f":"SUM(D9:D14)","v":0},{"$f":"SUM(E9:E14)","v":0},null,null,{"$f":"SUM(H9:H14)","v":0}]
[]
[null,null,null,"If proposing 9% Credits, state the assumed Tax Credit Pricing:"]
[]
[null,null,"Non-Residential"]
[null,null,"Source and Type","Proposed Funding","Committed/ Conditional Funding","Application \nDate","Award Date","Total Funding"]
[]
[null,null,null,null,null,null,null,{"$f":"D22+E22","v":0}]
[null,null,null,null,null,null,null,{"$f":"D23+E23","v":0}]
[null,null,null,null,null,null,null,{"$f":"D24+E24","v":0}]
[null,null,null,null,null,null,null,{"$f":"D25+E25","v":0}]
[null,null,"Total Non-Residential Development Cost",{"$f":"SUM(D22:D25)","v":0},{"$f":"SUM(E22:E25)","v":0},null,null,{"$f":"SUM(H22:H25)","v":0}]
[]
[]
[null,null,"Total Development Cost",{"$f":"+D26+D15","v":0},{"$f":"+E26+E15","v":0},null,null,{"$f":"+H26+H15","v":0}]
[]
[]
[null,null,"Annual Subsidy Sources"]
[null,null,"Operating"]
[null,null,"Source and Type","Proposed Funding","Committed/ Conditional Funding","Application \nDate","Award Date","Total Funding"]
[]
[null,null,null,null,null,null,null,{"$f":"D36+E36","v":0}]
[null,null,null,null,null,null,null,{"$f":"D37+E37","v":0}]
[null,null,null,null,null,null,null,{"$f":"D38+E38","v":0}]
[null,null,null,null,null,null,null,{"$f":"D39+E39","v":0}]
[null,null,"Total Annual Operating Subsidy Sources",{"$f":"SUM(D36:D39)","v":0},{"$f":"SUM(E36:E39)","v":0},null,null,{"$f":"SUM(H36:H39)","v":0}]
[]
[null,null,"Rent"]
[null,null,"Source and Type","Proposed Funding","Committed/ Conditional Funding","Application \nDate","Award Date","Total Funding"]
[]
[null,null,null,null,null,null,null,{"$f":"D45+E45","v":0}]
[null,null,null,null,null,null,null,{"$f":"D46+E46","v":0}]
[null,null,null,null,null,null,null,{"$f":"D47+E47","v":0}]
[null,null,null,null,null,null,null,{"$f":"D48+E48","v":0}]
[null,null,"Total Rent Subsidy Sources",{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0},null,null,{"$f":"SUM(H45:H48)","v":0}]
[]
[null,null,"Services"]
[null,null,"Source and Type","Proposed Funding","Committed/ Conditional Funding","Application \nDate","Award Date","Total Funding"]
[]
[null,null,null,null,null,null,null,{"$f":"D54+E54","v":0}]
[null,null,null,null,null,null,null,{"$f":"D55+E55","v":0}]
[null,null,null,null,null,null,null,{"$f":"D56+E56","v":0}]
[null,null,null,null,null,null,null,{"$f":"D57+E57","v":0}]
[null,null,"Total Annual Operating Subsidy Sources",{"$f":"SUM(D54:D57)","v":0},{"$f":"SUM(E54:E57)","v":0},null,null,{"$f":"SUM(H54:H57)","v":0}]

{"sheet":"MF Applicant & Ownership","index":6,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":true,"merged":[[14,5,16,13],[26,5,28,13],[34,7,34,11],[43,3,43,11],[41,3,41,11],[42,3,42,11],[38,6,38,7],[32,12,32,13],[36,5,36,7],[36,10,36,11]]}
[]
[null,"PROJECT OWNERSHIP"]
[]
[]
[null,null,"Proposed Ownership Structure"]
[]
[null,null,null,"Nonprofit",null,null,null,"Limited Corporation / Partnership"]
[]
[null,null,null,"Nonprofit Single Asset Entity",null,null,null,"Other Corporation"]
[]
[null,null,null,"Local Unit of Government",null,null,null,"Joint Venture"]
[]
[null,null,null,"CHDO"]
[]
[null,null,null,"Other (please specify):"]
[]
[]
[]
[null,null,"Role of Applicant in the Project"]
[]
[null,null,null,"Owner",null,null,null,"Managing Partner/Managing Member"]
[]
[null,null,null,"Sponsoring Organization",null,null,null,"Property Management"]
[]
[null,null,null,"Developer",null,null,null,"Social Services Provider"]
[]
[null,null,null,"Other (please specify):"]
[]
[]
[]
[null,null,"Tax Credit Projects"]
[]
[null,null,"Is this project proposing to use Low-Income Housing Tax Credit financing?"]
[]
[null,null,"Limited Corporation/Partnership Type:"]
[]
[null,null,"Legal Status of LLP/LLC",null,null,null,null,null,null,"Tax Year:",null,null,"to"]
[]
[null,null,null,"If To Be Formed, Estimated Date:",null,null,null,null,null,"Accounting Method:"]
[]
[null,null,"Individuals/Organizations comprising the Ownership Entity (if known at time of application)."]
[null,null,1]
[null,null,2]
[null,null,3]

{"sheet":"MF Contact Information","index":7,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":true,"merged":[[42,4,42,6],[6,2,6,6],[18,4,18,6],[32,2,32,6],[36,4,36,6],[26,4,26,6],[29,1,29,6],[30,2,30,6],[38,2,38,6],[40,2,40,6],[24,2,24,6],[8,2,8,6],[12,4,12,6],[1,1,1,7],[3,1,3,6],[4,2,4,6],[16,2,16,6],[22,2,22,6]]}
[]
[null,"CONTACT INFORMATION"]
[]
[null,"Project Sponsor/Developer"]
[null,"Firm Name:",{"$f":"IF('MF Cover and Table of Contents'!C12=\"\",\"Enter on Cover and Table of Contents tab\",'MF Cover and Table of Contents'!C12:I12)","v":"Enter on Cover and Table of Contents tab"}]
[]
[null,"Organization Type"]
[]
[null,"Address:"]
[]
[null,"City:",null,"State: ",null,"Zip Code:"]
[]
[null,"Phone:",null,"Email:"]
[]
[]
[]
[null,"Executive Director/CEO"]
[]
[null,"Phone:",null,"Email:"]
[]
[]
[]
[null,"Contact Person:"]
[]
[null,"Contact Person Title:"]
[]
[null,"Phone:",null,"Email:"]
[]
[]
[null,"Development Consultant"]
[null,"Firm Name:",{"$f":"IF('MF Cover and Table of Contents'!C17=\"\",\"Enter on Cover and Table of Contents tab\",'MF Cover and Table of Contents'!C17)","v":"Enter on Cover and Table of Contents tab"}]
[]
[null,"Address:"]
[]
[null,"City:",null,"State: ",null,"Zip Code:"]
[]
[null,"Phone:",null,"Email:"]
[]
[null,"Contact Person:"]
[]
[null,"Contact Person Title:"]
[]
[null,"Phone:",null,"Email:"]

{"sheet":"HO Cover and Table of Contents","index":8,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[[8,2,8,8],[11,2,11,8],[16,2,16,8]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Project Name"]
[]
[]
[null,null,"Applicant Organization Name"]
[]
[]
[null,null,null,"This Organization is eligible to apply, per RCW and the criteria laid out in the NOFA:"]
[]
[null,null,"Development Consultant Firm Name (if Applicable)"]
[]
[]
[null,null,"Table of Contents and Checklist"]
[]
[null,null,null,"Generals & Readiness"]
[]
[null,null,null,"Design"]
[]
[null,null,null,"Units & Target Populations"]
[]
[null,null,null,"Funding"]
[]
[null,null,null,"Production Pipeline"]

{"sheet":"HO Generals & Readiness","index":9,"n_rows":86,"n_cols":16,"rows_kept":86,"cut":false,"hidden":true,"merged":[[38,10,38,12],[40,10,40,12],[32,5,34,15],[13,3,20,15],[22,3,22,5],[58,3,58,4],[58,5,58,9],[58,10,58,12],[58,13,58,14],[36,10,36,12],[42,3,42,5],[44,3,44,5],[46,6,46,15],[48,6,48,9],[48,10,48,11],[48,12,48,13],[55,3,55,5],[57,3,57,4],[57,5,57,9],[57,10,57,12],[57,13,57,14],[59,3,59,4],[59,5,59,9],[59,10,59,12],[59,13,59,14],[60,3,60,4],[60,5,60,9],[60,10,60,12],[60,13,60,14],[61,3,61,4],[61,5,61,9],[61,10,61,12],[61,13,61,14],[62,3,62,4],[62,5,62,9],[62,10,62,12],[62,13,62,14],[63,3,63,4],[63,5,63,9],[63,10,63,12],[63,13,63,14],[64,3,64,4],[64,5,64,9],[64,10,64,12],[64,13,64,14],[72,3,74,15],[80,3,83,15],[85,3,86,15],[88,3,91,15],[65,3,65,4],[65,5,65,8],[65,9,65,11],[65,12,65,13],[67,3,67,5],[69,3,70,15]]}
[]
[null,"GENERALS & READINESS"]
[]
[]
[null,null,null,"Project General Information"]
[]
[]
[null,null,null,"Priority to Applicant (if multiple Projects submitted):",null,null,null,null,null,null,null,"of"]
[]
[null,null,null,"Is this a Year 1 (2017) or a Year 2 (2018) project?",null,null,null,null,null,null,"Select…"]
[]
[null,null,null,"Brief narrative description of project:"]
[]
[null,null,null,"asdfsadfasdfafasdfaf"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Project Activities"]
[]
[null,null,null,"Select all that apply:"]
[]
[null,null,null,null,"Acquisition",null,null,null,"Rehabilitation",null,null,null,"Downpayment Assistance"]
[]
[null,null,null,null,"Acquisition - Land Only",null,null,null,"New Construction"]
[]
[null,null,null,null,"Other (please explain):"]
[]
[]
[]
[]
[]
[null,null,null,"Estimated Financial Closing Date (mm/dd/yyyy):"]
[]
[null,null,null,"Estimated Construction Start Date (mm/dd/yyyy):"]
[]
[null,null,null,"Estimated Certificate of Occupancy Date (mm/dd/yyyy):"]
[]
[null,null,null,"Project Location"]
[]
[null,null,null,"If Single-Site Project"]
[]
[null,null,null,"Street Address"]
[]
[null,null,null,"City",null,null,null,null,null,null,"County",null,"Select…"]
[]
[null,null,null,"Legislative  District",null,null,"Select…"]
[]
[null,null,null,"Congressional District",null,null,"Select…"]
[]
[]
[null,null,null,"If Multi-site Project"]
[]
[null,null,null,"Site Name/ID",null,"Street Address",null,null,null,null,"City",null,null,"County",null,"Leg District"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Select…",null,"Select…"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Site Control and Zoning"]
[]
[null,null,null,"Briefly describe the type of Site Control (e.g. Purchase & Sale Agreement, Land Lease, Existing Ownership) being used, or intended to be used, to secure the project Site(s), and give an assessment of its status."]
[]
[]
[]
[]
[]
[]
[null,null,null,"Are all sites propertly zoned for the project?"]
[]
[null,null,null,"If no, explain how the project differs from the use for which project sites are currently zoned:"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Outline the steps that will be taken to address the described zoning issues (e.g. administrative, conditional use, hearing examiner, council approval), what approvals are required , and the time frame needed to resolve these issues:"]

{"sheet":"HO Units & Target Populations","index":10,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":true,"merged":[[21,3,21,6],[4,3,4,4],[7,3,7,5],[7,12,7,14],[14,3,14,4],[16,3,16,5],[16,10,16,12],[18,3,19,6],[18,7,19,7],[18,11,19,11],[18,12,19,12],[20,3,20,6],[28,3,28,6],[31,3,31,13],[32,3,35,13],[37,3,37,4],[22,3,22,6],[23,3,23,6],[24,3,24,6],[25,3,25,6],[26,3,26,6],[27,3,27,6]]}
[]
[null,"UNITS & TARGET POPULATIONS"]
[]
[]
[null,null,null,"Unit Sizes"]
[]
[]
[null,null,null,"Units by Bedroom Count",null,null,null,null,null,null,null,null,"Square footage Range"]
[]
[null,null,null,"1BR","2BR","3BR","4BR","5BR",">5BR","Homes",null,null,"High"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D11:J11)","v":0},null,"Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Average"]
[]
[]
[null,null,null,"Demographics"]
[]
[null,null,null,"Populations to be Served",null,null,null,null,null,null,"Household Size (# Persons)"]
[]
[null,null,null,"Population Type",null,null,null,"Qty.",null,null,null,"Qty","# Served"]
[]
[null,null,null,"Select…",null,null,null,null,null,null,1,null,{"$f":"K21*L21","v":0}]
[null,null,null,null,null,null,null,null,null,null,2,null,{"$f":"K22*L22","v":0}]
[null,null,null,null,null,null,null,null,null,null,3,null,{"$f":"K23*L23","v":0}]
[null,null,null,null,null,null,null,null,null,null,4,null,{"$f":"K24*L24","v":0}]
[null,null,null,null,null,null,null,null,null,null,5,null,{"$f":"K25*L25","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Other",null,{"$f":"(IF(K26<>\"Other\",(K26*L26),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Other",null,{"$f":"(IF(K27<>\"Other\",(K27*L27),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Other",null,{"$f":"(IF(K28<>\"Other\",(K28*L28),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total Persons Served",null,{"$f":"SUM(M21:M28)","v":0}]
[null,null,null,null,null,null,"Total Households"]
[]
[null,null,null,"In the space below, provide detail on units for \"Other\" populations:"]
[]
[]
[]
[]
[]
[null,null,null,"Incomes Served"]
[]
[null,null,null,null,"30% AMI","40% AMI","50% AMI","60% AMI","80% AMI","LIH Units","Market Rate","Total Households"]
[null,null,null,"Qty.",null,null,null,null,null,{"$f":"SUM(E41:I41)","v":0},null,{"$f":"J41+K41","v":0}]

{"sheet":"HO Funding Sources","index":11,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[[1,1,1,8],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,7,8,7],[35,2,40,7],[22,2,23,2],[22,3,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,6],[22,7,23,7]]}
[]
[null,"FUNDING SOURCES"]
[]
[]
[null,null,"Permanent Capital Funding Sources "]
[null,null,"Residential"]
[]
[null,null,"Source and Type","Proposed Funding","Committed/ Conditional Funding","Application Date","Award Date","Total Funding"]
[]
[null,null,"WA State Housing Trust Fund (HTF) ",null,null,null,null,{"$f":"D10+E10","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Total Residential Development Cost",{"$f":"SUM(D10:D16)","v":0},{"$f":"SUM(E10:E16)","v":0},null,null,{"$f":"SUM(H10:H16)","v":0}]
[]
[null,null,null,null,"If proposing 9% Low Income Housing Tax Credits, state the assumed Tax Credit Pricing: "]
[]
[null,null,"Non-Residential"]
[]
[null,null,"Source and Type","Proposed Funding","Committed/ Conditional Funding","Application Date","Award Date","Total Funding"]
[]
[null,null,null,null,null,null,null,{"$f":"D25+E25","v":0}]
[null,null,null,null,null,null,null,{"$f":"D26+E26","v":0}]
[null,null,null,null,null,null,null,{"$f":"D27+E27","v":0}]
[null,null,null,null,null,null,null,{"$f":"D28+E28","v":0}]
[null,null,"Total Non-Residential Development Cost",{"$f":"SUM(D25:D28)","v":0},{"$f":"SUM(E25:E28)","v":0},null,null,{"$f":"SUM(H25:H28)","v":0}]
[]
[]
[null,null,"Total Development Cost",{"$f":"+D29+D17","v":0},{"$f":"+E29+E17","v":0},null,null,{"$f":"+H29+H17","v":0}]
[]
[]
[null,null,"What, if any, are your contingency plans to close funding gaps resulting from not receiving the above-proposed funds?"]

{"sheet":"HO Design","index":12,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":true,"merged":[[47,3,47,5],[53,4,55,15],[7,3,7,5],[14,3,14,5],[20,4,22,15],[24,3,24,5],[32,4,34,15],[40,3,40,5]]}
[]
[null,"DESIGN"]
[]
[]
[]
[null,null,null,"Program Design"]
[]
[null,null,null,"Ownership Model"]
[]
[null,null,null,null,"Community Land Trust",null,null,null,"Cooperative",null,null,null,"Fee Simple Title"]
[]
[null,null,null,null,"Condominium",null,null,null,"Detached Single-Family",null,null,null,"Tribal"]
[]
[]
[null,null,null,"Multi-unit Structures"]
[]
[null,null,null,null,"Zero-Lot Line Attached",null,null,null,"Row Houses",null,null,null,"Flats"]
[]
[null,null,null,null,"Other. Please explain:"]
[]
[]
[]
[]
[]
[null,null,null,"Contruction Type"]
[]
[null,null,null,null,"Stick Built",null,null,null,"Panelized Construction",null,null,null,"Modular"]
[]
[null,null,null,null,"Manufactured Homes",null,null,null,"Straw Bale"]
[]
[null,null,null,null,"Other. Please Explain:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Financial"]
[]
[null,null,null,"Revolving Loan Fund"]
[]
[null,null,null,null,"Service In-House",null,null,null,"Payment Deferred",null,null,null,"Repayment from Onset"]
[]
[null,null,null,null,"Outsourced Servicing",null,null,null,"Due on Sale or Change of Use"]
[]
[]
[null,null,null,"Buyer Takes Title At…"]
[]
[null,null,null,null,"Acquisition",null,null,null,"Construction Start",null,null,null,"Occupancy "]
[]
[null,null,null,null,"Other. Please Describe:"]

{"sheet":"HO Production Pipeline","index":13,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":true,"merged":[[1,1,1,16],[7,15,8,15],[17,3,20,15],[26,15,27,15],[36,3,38,15]]}
[]
[null,"PRODUCTION PIPELINE"]
[]
[]
[]
[null,null,"Project Year",2018]
[]
[null,null,null,"Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Total HTF Funds"]
[null,null,"Project Activity","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sept","Oct","Nov","Dec"]
[null,null,"Down Payment Assistance",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D10:O10)","v":0}]
[null,null,"Acquisition - Land",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D11:O11)","v":0}]
[null,null,"Acquisition - Rehab",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D12:O12)","v":0}]
[null,null,"Construction",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D13:O13)","v":0}]
[null,null,"Construction to Permanent Financing",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D14:O14)","v":0}]
[]
[null,null,"UNITS COMPLETED",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D16:O16)","v":0}]
[]
[null,null,"Pipeline Notes:"]
[]
[]
[]
[]
[]
[]
[null,null,"Project Year",2019]
[]
[null,null,null,"Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Total HTF Funds"]
[null,null,"Project Activity","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,null,"Down Payment Assistance",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D29:O29)","v":0}]
[null,null,"Acquisition - Land",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D30:O30)","v":0}]
[null,null,"Acquisition - Rehab",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Construction",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Construction to Permanent Financing",0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"UNITS COMPLETED",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D35:O35)","v":0}]
[]
[null,null,"Pipeline Notes:"]

{"sheet":"HO Contact Information","index":14,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":true,"merged":[[42,4,42,6],[16,2,16,6],[18,4,18,6],[22,2,22,6],[24,2,24,6],[26,4,26,6],[29,1,29,6],[30,2,30,6],[32,2,32,6],[36,4,36,6],[38,2,38,6],[40,2,40,6],[12,4,12,6],[1,1,1,7],[3,1,3,6],[4,2,4,6],[6,2,6,6],[8,2,8,6]]}
[]
[null,"CONTACT INFORMATION"]
[]
[null,"Project Sponsor/Developer"]
[null,"Firm Name:",{"$f":"IF('HO Cover and Table of Contents'!C12=\"\",\"Enter on Cover and Table of Contents tab\",'HO Cover and Table of Contents'!C12:I12)","v":"Enter on Cover and Table of Contents tab"}]
[]
[null,"Organization Type"]
[]
[null,"Address:"]
[]
[null,"City:",null,"State: ",null,"Zip Code:"]
[]
[null,"Phone:",null,"Email:"]
[]
[]
[]
[null,"Executive Director/CEO"]
[]
[null,"Phone:",null,"Email:"]
[]
[]
[]
[null,"Contact Person:"]
[]
[null,"Contact Person Title:"]
[]
[null,"Phone:",null,"Email:"]
[]
[]
[null,"Development Consultant"]
[null,"Firm Name:",{"$f":"IF('HO Cover and Table of Contents'!C17=\"\",\"Enter on Cover and Table of Contents tab\",'HO Cover and Table of Contents'!C17)","v":"Enter on Cover and Table of Contents tab"}]
[]
[null,"Address:"]
[]
[null,"City:",null,"State: ",null,"Zip Code:"]
[]
[null,"Phone:",null,"Email:"]
[]
[null,"Contact Person:"]
[]
[null,"Contact Person Title:"]
[]
[null,"Phone:",null,"Email:"]