{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Funding","Pro Forma"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":356,"comments":2,"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":"Funding","index":0,"n_rows":187,"n_cols":51,"rows_kept":187,"cut":false,"hidden":false,"merged":[[165,33,165,39],[166,33,166,39],[167,33,167,39],[168,33,168,39],[13,5,13,8],[39,10,39,11],[163,33,163,39],[164,33,164,39],[15,5,15,8],[16,5,16,8],[27,10,27,11],[18,10,18,11],[43,10,43,11],[47,10,47,11],[51,10,51,11],[52,3,55,11],[8,5,8,8],[9,5,9,8],[10,5,10,8],[11,5,11,8],[12,5,12,8],[36,6,36,7],[37,6,37,7],[36,8,36,11],[37,8,37,11],[39,4,39,9],[56,2,56,11],[62,4,62,11],[65,4,65,10],[68,4,68,8],[0,0,0,11],[4,1,4,11],[27,2,27,9],[29,2,29,11],[31,10,31,11],[41,10,41,11],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[31,2,31,9],[71,4,71,6],[73,4,73,10],[74,4,74,8],[76,4,76,10],[80,4,80,11],[92,3,92,11],[94,3,94,10],[96,3,96,11],[98,3,98,11],[82,4,82,8],[84,4,84,8],[86,4,86,8],[88,4,88,11],[90,3,90,11]]}
["Exhibit A\nRFA 2023-211 Construction Inflation Response Viability Funding"]
[]
["A.","Criteria and Timing"]
[]
[null,"Applicants will continue to be held to the terms and conditions of the RFA under which the Active Award was made and the applicable rule chapter in effect at the time of the Original Application.  The eligibility criteria and timing requirements are outlined in this RFA."]
[]
["B.","Required Information"]
[]
[null,1,"Name of Development",null,null,"<select one>"]
[null,null,"Name of Applicant",null,null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,6)),\" \",VLOOKUP($F$9,AppSubRptData,6))","v":0},null,null,null,null,"Original RFA #",{"$f":"IF(F9=\"<select one>\",\"\",IF(ISERROR(VLOOKUP($F$9,AppSubRptData,3)),\" \",VLOOKUP($F$9,AppSubRptData,3)))","v":""}]
[null,null,"Name of County",null,null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,5)),\" \",VLOOKUP($F$9,AppSubRptData,5))","v":0},null,null,null,null,"Original App #",{"$f":"IF(F9=\"<select one>\",\"\",IF(ISERROR(VLOOKUP($F$9,AppSubRptData,2)),\" \",VLOOKUP($F$9,AppSubRptData,2)))","v":""}]
[null,null,"Demographic",null,null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,10)),\" \",VLOOKUP($F$9,AppSubRptData,10))","v":0}]
[null,null,"Development Category",null,null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,11)),\" \",VLOOKUP($F$9,AppSubRptData,11))","v":0}]
[null,null,"Number of Units",null,null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,13)),\" \",VLOOKUP($F$9,AppSubRptData,13))","v":0}]
[]
[null,null,"Authorized Principal",null,null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,14)),\" \",VLOOKUP($F$9,AppSubRptData,14))","v":0}]
[null,null,"Operational Contact",null,null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,15)),\" \",VLOOKUP($F$9,AppSubRptData,15))","v":0}]
[]
[null,null,"What Date was the Applicant invited to answer Credit Underwriting?",null,null,null,null,null,null,null,{"$f":"IF(F9=\"<select one>\",\"\",IF(ISERROR(VLOOKUP($F$9,AppSubRptData,16)),\" \",VLOOKUP($F$9,AppSubRptData,16)))","v":""}]
[]
[null,null,"Competitive Active Awards:"]
[null,null,null,"SAIL",null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,25)),\" \",VLOOKUP($F$9,AppSubRptData,25))","v":0}]
[null,null,null,"ELI",null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,26)),\" \",VLOOKUP($F$9,AppSubRptData,26))","v":0}]
[null,null,null,"NHTF",null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,27)),\" \",VLOOKUP($F$9,AppSubRptData,27))","v":0}]
[null,null,null,"HOME",null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,28)),\" \",VLOOKUP($F$9,AppSubRptData,28))","v":0}]
[null,null,null,"9%HC",null,{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,29)),\" \",VLOOKUP($F$9,AppSubRptData,29))","v":0}]
[]
[null,2,"Does the Original Application qualify as a Self-Sourced Application funded in RFA 2020-205 or RFA 2021-205?",null,null,null,null,null,null,null,{"$f":"IF(F9=\"<select one>\",\"\",IF(ISERROR(VLOOKUP($F$9,AppSubRptData,7)),\" \",VLOOKUP($F$9,AppSubRptData,7)))","v":""}]
[]
[null,null,"If “Yes”, to be eligible in this RFA, the Self-Sourced Applicant must knowingly, voluntarily and irrevocably commit to waive the option to convert the Development to market rate, including any option or right to submit a request for a qualified contract, after year 14, and any other option, right or process available to the Applicant to terminate (or that would result in the termination of) the 50-year set aside period at any time prior to the expiration of its full term."]
[]
[null,null,"Does the Self-Sourced Applicant waive the option to convert?",null,null,null,null,null,null,null,"<select one>"]
[]
[null,3,"Request Amount"]
[]
[null,null,"(a)","Maximum Viability Request Amount:"]
[null,null,null,"(1)","Per Unit Limit:",null,{"$f":"IF($F$9=\"<select one>\",\"\",IF(OR(N(Number_of_Units)<175,SUM(F22:G26)=0),125000,38000))","v":""},null,{"$f":"IF(N(G37)>0,TEXT(Number_of_Units,\"0\")&\" total units multiplied by \"&TEXT(G37,\"$#,##0\")&\" PU totals \"&TEXT(N(Number_of_Units)*N(G37),\"$#,##0\")&\".\",\"\")","v":""}]
[null,null,null,"(2)","Per Development Limit:",null,{"$f":"IF($F$9=\"<select one>\",\"\",IF(OR(N(Number_of_Units)<175,SUM(F22:G26)=0),4300000,15000000-N(SAIL_Request_Amount)-N(ELI_Request_Amount)-N(NHTF_Request_Amount)-N(HOME_Request_Amount)))","v":""},null,{"$f":"IF(F9=\"<select one>\",\"\",IF(N(G38)>0,IF(OR(N(Number_of_Units)<175,SUM(F22:G26)=0),\"The RFA limit for Developments with \"&IF(SUM(F22:G26)=0,\"either less than 175 units or has only been awarded non-competitive Corporation funding\",\"less than 175 units\")&\" is $4,300,000.\",\"The RFA limit for Developments with at least 175 units is $15,000,000, less any Active Awards of SAIL, ELI, NHTF and/or HOME, which for this Development totals \"&TEXT(N(SAIL_Request_Amount)+N(ELI_Request_Amount)+N(NHTF_Request_Amount)+N(HOME_Request_Amount),\"$#,##0\")&\", netting \"&TEXT(15000000-(N(SAIL_Request_Amount)+N(ELI_Request_Amount)+N(NHTF_Request_Amount)+N(HOME_Request_Amount)),\"$#,##0\")&\".\")))","v":""}]
[]
[null,null,null,null,"Lesser of Maximum Request Amount Per Development, or\nMaximum Request Amount via Per Unit Limit:",null,null,null,null,null,{"$f":"MIN(N(Number_of_Units)*N(G37),IF(OR(N(Number_of_Units)<175,SUM(F22:G26)=0),4300000,15000000-(N(SAIL_Request_Amount)+N(ELI_Request_Amount)+N(NHTF_Request_Amount)+N(HOME_Request_Amount))))","v":0}]
[]
[null,null,null,"Applicant's Viability Request Amount:"]
[]
[null,null,null,null,"Applicant's Eligible Viability Request Amount:",null,null,null,null,null,{"$f":"MIN(N(Max_Viability),N(Viability_Request_Amount))","v":0}]
[]
[null,null,"(b)","Updating Non-Competitive Housing Credit Request Amount, if applicable:"]
[]
[null,null,null,"Non-Competitive Housing Credit Request Amount (annual amount):"]
[]
[null,null,"(c)","Updating Corporation-Issued MMRB Loan Request Amount, if applicable:"]
[]
[null,null,null,"Corporation-Issued MMRB Loan Request Amount (if applicable):"]
[null,null,null,{"$f":"IF(AND(N(MMRB_Request_Amount)>0,N(MMRB_Request_Amount)<>ConstrAnalysis__1st_Mtg,ConstrAnalysis__1st_Type=\"FHFC - MMRB\"),\"Please ensure the FHFC - MMRB request is in the First Mortgage Financing line in the Construction Funding Sources section of the Pro Forma, and that the request amount matches the amount entered above. It currently does not match.\",IF(AND(N(MMRB_Request_Amount)>0,ConstrAnalysis__1st_Type<>\"FHFC - MMRB\"),\"Please ensure FHFC - MMRB is listed as the First Mortgage Financing's Lender/Type of Funding in the Construction Funding Sources section of the Pro Forma. It currently has not been selected.\",\"\"))","v":""}]
[]
[]
[]
[null,4,"Applicants must either return a recent Competitive Award OR commit to a limited number of Priority I Applications in certain RFAs in the 2023/2024 Funding Cycle by selecting option a. or b. below. "]
[]
[null,null,"(a)","Return of recent Competitive Housing Credit Award (“Returned Award”)"]
[]
[null,null,null,"(1)","Withdrawal of recent award"]
[]
[null,null,null,null,"A Withdrawal Letter signed by the Authorized Principal Representative of the Returned Award has been provided as Attachment 1 providing the required information outlined in RFA. "]
[null,null,null,null,"Does the Applicant commit to withdraw a recent Competitive Award?",null,null,null,null,null,null,"<select one>"]
[]
[null,null,null,null,"If “Yes”, provide the required withdrawal letter as Attachment 1 and answer the questions below:"]
[]
[null,null,null,null,"Name of Development of the Returned Award"]
[]
[]
[null,null,null,null,"Application Number of Returned Award"]
[]
[]
[null,null,null,null,"Name of at least one Principal of the Applicant of the Active Award that is also a Principal of the Applicant in the Returned Award"]
[]
[]
[null,null,null,null,"The Returned Award will not be considered a Withdrawn Application for the purpose of any withdrawal disincentive points in any future RFA."]
[]
[null,null,null,"(2)","Up to three Shared Applications in this RFA may use on the same Returned Award"]
[]
[null,null,null,null,"If applicable, include a list up to three Applications that meet the requirements to be considered Shared Applications in the RFA:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"The Returned Award will be considered withdrawn effective as of the date the Application in this RFA is submitted and the letter is received by the Corporation.  This is not revokable.  The Returned Award will not be considered a Withdrawn Application for the purpose of any withdrawal disincentive points in any future RFA."]
[]
[null,null,"(b)","Commit to a limited number of Priority I Applications in certain RFAs in the 2024/2025  Funding Cycle, based on funding awarded in this RFA"]
[]
[null,null,null,"If an Applicant in this RFA commits to this option, All Principals of an Active Award will be limited to how many Priority I Applications can be submitted in a Future Corresponding RFA in the 2024/2025 Funding Cycle."]
[]
[null,null,null,"Does the Applicant commit to limit the number of Priority I Applications in the Future Corresponding RFA as outlined in the RFA?",null,null,null,null,null,null,null,"<select one>"]
[]
[null,null,null,"Note:  Points for Determining the Priority I Applications associated with Active Awards that qualify for the Quick Close Incentive will be removed and the average value of Points for Determining the Priority I Applications will be recalculated as further explained in the RFA."]
[]
[null,null,null,"Applicants that select b. will not be held to the provisions in paragraph a. and should submit “Not Applicable” as Attachment 1."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Development","Original App No","Original RFA","New App. No","County","Applicant","Self-Sourced?","Developer","Funding Type","Demographic","Development Category","Development Type","Number of Units","Authorized Principal Representative","Operational Contact","Date Invited into Credit Underwriting ","Max GC Fee","Max Hard Cost Contingency","Max Soft Cost Contingency","Max Dev Fee Acq Costs","Max Dev Fee Non-Acq Costs","Max Demographic Dev Fee","Original HC Funding (Yes/No)",null,"SAIL","ELI","NHTF","HOME","9%HC","Counting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<select one>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"52 at Park","2021-112B","Non-Comp",null,"Orange","Parkwood Plaza Apartments, Ltd.","No","Parkwood Plaza Developer LLC","MMRB/4%","Family","New Construction","Garden",300,"Russell Condas","Jordan Richter","2022-04-20",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barnett Villas","2021-108B","Non-Comp",null,"Orange","BDG Barnett Villas, LP","No","BDG Barnett Villas Developer, LLC ","MMRB/4%","Family","New Construction","Garden",156,"Scott Zimmerman","Alex Kiss","2022-03-23",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bear Creek Commons","2022-163SN","2021-205",null,"Pinellas","Blue 64th Street, LLC","No","Blue Sky Developer, LLC","SAIL/4%/NHTF","Elderly, Non-ALF","New Construction","Mid-Rise 4",85,"Shawn Wilson","Scott Macdonald","2022-03-01",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,2250000,600000,1189000,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonair Towers","2021-044C","2020-204",null,"Lee","Bonair Towers, LLLP","No","Bonair Towers MBS Member, LLC / Southwest Florida Affordable Housing Choice Foundation, Inc","HC","Elderly, Non-ALF","Acquisition and Preservation","High Rise",101,"Marcia Davis","Marcia Davis","2021-02-03",0.14000000000000001,0.15,0.05,0.16,0.16,0,"Yes",null,null,null,null,null,1484000,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bristol Manor","2022-075C","2021-201",null,"Volusia","Bristol Manor, Ltd.","No","Bristol Manor Developer, LLC","HC","Elderly, Non-ALF","New Construction","Garden",80,"Julie von Weller","Jennie D Lagmay","2022-05-05",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",null,null,null,null,null,1699990,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Casa di Francesco","2022-165SN","2021-205",null,"Hillsborough","Blue St. Francis, Ltd.","No","Blue Sky Developer, LLC; \nCCDOSP Developer, Inc.","SAIL/4%/NHTF","Elderly, Non-ALF","New Construction","Mid-Rise 4",140,"Shawn Wilson","Scott Macdonald","2022-03-01",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,3500000,600000,1090000,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coleman Park Renaissance","2021-219SN","2020-205",null,"Palm Beach","CP Renaissance, LLC","No","NRI Development Corp.; Neighborhood Renaissance, Inc.; Stone Soup Development, Inc.","4%/SAIL/NHTF","Family","New Construction","Garden",43,"Terri Murray","Michael Pecar","2021-06-24",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,2940000,571300,1196493,null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Courtside Apartments, Phase II","2021-323S","2021-208",null,"Miami-Dade","AMC HTG 2, Ltd.","No","AMC HTG 2 Developer, LLC","SAIL/4%","Workforce","New Construction","Mid-Rise 5/6",120,"Matthew A. Rieger","Jordan D. Tolman","2021-07-12",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,2750000,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cross Creek Gardens at Quincy","2022-247H","2021-206",null,"Gadsden","Cross Creek Gardens at Quincy, LLC","No","ACRUVA Community Developers, LLC; Neighborhood Renaissance, Inc.","HOME","Family","New Construction","Garden",34,"Terri Muray","Guy T. Kempe","2022-03-29",0.14000000000000001,0.05,0.05,0.16,0.16,0,"No",null,null,null,null,6000000,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Everglades Village Phase 5.6","2022-237S","2022-104",null,"Miami-Dade","Everglades village Phase 5.6, LLC","No","Rural Neighborhoods, Incorporated","SAIL","Farmworker","New Construction","Garden",20,"Steven Kirk",null,"2022-03-11",0.14000000000000001,0.05,0.05,0.16,0.16,0,"No",null,4300000,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fletcher Black II","2021-127C/2022-278C","2020-201",null,"Bay","Fletcher Black II, LLC","No","Royal American Properties, LLC; InVictus Development, LLC; PCHA Developer, LLC","HC","Family","New Construction","Garden",64,"Joseph F. Chapman, IV","James A Boyd","2021-05-07",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",null,null,null,null,null,1100000,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Founders Point","2022-262S","2022-102",null,"Pinellas","Pinellas Affordable Living, Inc.","No","Pinellas Affordable Living, Inc.; \nBoley Centers, Inc.","SAIL","PSN","New Construction","Garden",15,"Jack D. Humburg","Jeri J. Flanagan","2022-06-30",0.14000000000000001,0.05,0.05,0.16,0.16,0,"No",null,3750000,214500,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Griffin Lofts","2022-257CSN","2022-103",null,"Polk","Allegre Pointe, LLC","No","Carrfour Supportive Housing, Inc.","HC/SAIL/NHTF","Homeless","New Construction","Mid-Rise 4",60,"Stephanie Berman","Paola Roman","2022-05-23",0.14000000000000001,0.05,0.05,0.16,0.16,0.05,"Yes",null,4200000,140300,870000,null,1700000,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heritage Oaks","2022-120C","2021-202",null,"Pinellas","Heritage Oaks, LLLP","No","Norstar Development USA, LP, \nPCHA Development, LLC\nNewstar Development, LLC","HC","Elderly, Non-ALF","New Construction","Garden",80,"Brian Evjen","Justin Corder","2022-01-21",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",null,null,null,null,null,1868000,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jade Bridge Apartments","2021-111B","Non-Comp",null,"Orange","Jade Bridge Apartments, Ltd.","No","Jade Bridge Developer, LLC","MMRB/4%","Elderly, Non-ALF","New Construction","Mid-Rise 5/6",218,"Russell Condas","Jordan Richter","2022-02-23",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liberty Square Phase Four","2020-468BS","2020-208",null,"Miami-Dade","Liberty Square Phase Four, LLC","No","Liberty Square Phase Four Developers, LLC","MMRB/SAIL/4%","Workforce","New Construction","Mid-Rise 5/6",193,"Alberto Milo, Jr.",null,"2020-10-21",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,3250000,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lofts at Bahama Village","2022-265CS","2022-208",null,"Monroe","Bahama Village Community, Ltd.","No","TVC Development, Inc.","HC/SAIL","Workforce","New Construction","Garden",98,"James R. Hoover","Kevin Troup","2022-05-02",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",null,5520000,null,null,null,1800000,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa Grove","2022-252C","2022-301",null,"Duval","Melissa Grove, Ltd.","No","TVC Development, Inc.","HC","Elderly, Non-ALF","New Construction","Garden",90,"James R. Hoover","Kevin Troup","2022-05-05",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",null,null,null,null,null,1868000,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Naranja Grand","2022-084C","2021-203",null,"Miami-Dade","Naranja Grand Senior, Ltd","No","Naranja Grand Developer, LLC","HC","Elderly, Non-ALF","New Construction","High Rise",120,"Matthew A. Rieger","Glenda Brown","2021-12-17",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",null,null,null,null,null,2858700,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Naranja Grand II","2022-201BSN","2021-205",null,"Miami-Dade","Naranja Grand II, LLC","Yes","Naranja Grand II Developer, LLC","MMRB/SAIL/4%/NHTF","Family","New Construction","High Rise",200,"Matthew A. Rieger","Glenda Brown","2022-03-01",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,5000000,600000,1546000,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oasis at Aventura","2022-099C","2021-203",null,"Miami-Dade","HTG Oasis, Ltd","No","HTG Oasis Developer, LLC","HC","Family","New Construction","High Rise",95,"Matthew A. Rieger","Glenda Brown","2022-01-24",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",null,null,null,null,null,2266000,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Osprey Sound","2021-107B","Non-Comp",null,"Orange","Osprey Sound Apartments, L.P.","No","Osprey Sound Developer, LLC","MMRB/4%","Elderly, Non-ALF","New Construction","Mid-Rise 5/6",294,"Jonathan Gruskin","Ryan Watt","2022-02-16",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pembroke Tower II","2020-382SN","2019-116",null,"Broward","SP Broward, LLC","No","Southport Development, Inc.","SAIL/NHTF","Elderly, Non-ALF","New Construction","Mid-Rise 5/6",88,"J. David Page","Brianne E Heffner","2020-07-20",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,2000000,600000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pinnacle at La Cabana","2022-131C","2021-202",null,"Broward","Pinnacle at La Cabana, LLLP","No","Pinnacle Communities, LLC","HC","Elderly, Non-ALF","New Construction","Mid-Rise 5/6",110,"David O. Deutch","Timothy P. Wheat","2022-01-28",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",null,null,null,null,null,2882000,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pinnacle at the Wesleyan","2021-098C","2020-201",null,"Osceola","Pinnacle at the Wesleyan, LLC","No","Pinnacle Communities, LLC","HC","Family","New Construction","Garden",96,"David O. Deutch","Timothy P. Wheat","2021-05-07",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",0,null,null,null,null,1699000,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pollywog Creek Mews","2022-242H","2021-206",null,"Hendry","Pollywog Creek Mews, LLC","No","Rural Neighborhoods, Inc.; \nOdyssey Development Group, LLC","HOME","Family","New Construction","Garden",28,"Steven Kirk","Jason Goldfarb","2022-03-29",0.14000000000000001,0.05,0.05,0.16,0.16,0,"No",null,null,null,null,5690000,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Princeton Crossings","2021-244BS","2020-205",null,"Miami-Dade","Princeton Crossings LLC","Yes","RS Development Corp.; \nLewis V. Swezy","MMRB/SAIL/4%","Family","New Construction","High Rise",150,"Lewis V Swezy","Paul Bilton","2021-06-23",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,4020000,600000,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rainbow Village","2021-315S","2021-208",null,"Miami-Dade","RGC Phase I, LLC","No","RGC Phase I Developer, LLC","SAIL/4%","Workforce","New Construction","High Rise",310,"Matthew A. Rieger","Jordan D. Tolman","2021-07-12",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,6000000,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandcastle Manor","2022-244H","2021-206",null,"Baker","Sandcastles Foundation, Inc.","No","Sandcastles Foundation, Inc.; \nFBC Holdings, LLC","HOME","Family","New Construction","Single Family",22,"Jessica L. Criss","Jessica L. Criss","2022-03-29",0.14000000000000001,0.05,0.05,0.16,0.16,0,"No",null,null,null,null,5544000,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southwick Commons","2021-269SN","2020-205",null,"Orange","Southwick Commons, Ltd.","No","Southwick Commons Property Developer, LLC","4%/SAIL/NHTF","Family","New Construction","Garden",195,"Jonathan L. Wolf","Jennie D. Lagmay","2021-06-23",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,7000000,600000,1089548,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Salix on Vine","2021-110B","Non-Comp",null,"Osceola","Vineland Family Apartments, Ltd.","No","Vineland Family Developer, LLC","MMRB/4%","Family","New Construction","Garden",252,"Russell Condas","Jordan Richter","2022-02-23",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Verandas of Punta Gorda III","2022-070C","2021-201",null,"Charlotte","The Verandas of Punta Gorda III, LLLP","No","Norstar Development USA, L.P.; \nPunta Gorda Developers, L.L.C.;\nNewstar Development, LLC","HC","Family","New Construction","Garden",72,"Richard L Higgins","Brian Evjen","2022-05-05",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",null,null,null,null,null,1523000,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tranquility at Hope School Phase II","2022-241H","2021-206",null,"Jackson","East Lake Florida 3, LLC","No","Timshel Hill Tide Developers, LLC; \nELCD Development, LLC","HOME","Family","New Construction","Garden",32,"Eric H. Lipp","Todd M. Wind","2022-03-29",0.14000000000000001,0.05,0.05,0.16,0.16,0,"No",null,null,null,null,5500000,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Villages of New Augustine","2022-043C","2021-201",null,"Saint Johns","Ability VNA, LLC","No","Ability Housing, Inc.","HC","Family","New Construction","Garden",92,"Shannon L. Nazworth","Andrew S. Fink","2022-05-05",0.14000000000000001,0.05,0.05,0.16,0.16,0,"Yes",null,null,null,null,null,1625000,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vincentian Village","2022-255CSN","2022-103",null,"Pinellas","Ability SVdP, LLC","No","Ability Housing, Inc.","HC/SAIL/NHTF","Homeless","New Construction","Mid-Rise 5/6",73,"Shannon L. Nazworth","Andrew S. Fink","2022-05-23",0.14000000000000001,0.05,0.05,0.16,0.16,0.05,"Yes",null,4895500,214500,1340000,null,2375000,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vista Breeze","2022-159SN","2021-205",null,"Miami-Dade","Vista Breeze, Ltd.","No","APC Vista Breeze Development, LLC; \nHACMB Development, LLC","SAIL/4%/NHTF","Elderly, Non-ALF","New Construction","Mid-Rise 4",119,"Kenneth Naylor","Michael O'Hara","2022-03-01",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,3000000,600000,1301500,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whispering Oaks","2022-144BS","2021-205",null,"Orange","SP East LLC","No","Southport Development, Inc.","MMRB/SAIL/4%","Family","New Construction","Garden",192,"J. David Page","Brianne E Heffner","2022-03-01",0.14000000000000001,0.05,0.05,0.18,0.18,0,"Yes",null,3960000,600000,null,null,null,12]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Development Finance Data Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<select one>",null,null,null,null,null,null,null,null,"Eligible Request","Funding?","Tracking","Nickname","Sort Priority","Funded Program"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,"SAIL",{"$f":"F22","v":0},{"$f":"IF(AC157>0,1,0)","v":0},{"$f":"IF($AD157=0,0,COUNTIF($AD$157:$AD157,$AD157))","v":0},"SAIL",1,{"$f":"IFERROR(VLOOKUP(1,Track_Funding,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,"ELI",{"$f":"F23","v":0},{"$f":"IF(AC158>0,1,0)","v":0},{"$f":"IF($AD158=0,0,COUNTIF($AD$157:$AD158,$AD158))","v":0},"ELI",2,{"$f":"IFERROR(VLOOKUP(2,Track_Funding,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHTF",{"$f":"F24","v":0},0,{"$f":"IF($AD159=0,0,COUNTIF($AD$157:$AD159,$AD159))","v":0},"NHTF",3,{"$f":"IFERROR(VLOOKUP(3,Track_Funding,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Viability NC:",4300000,null,null,null,null,null,null,"HOME",{"$f":"F25","v":0},0,{"$f":"IF($AD160=0,0,COUNTIF($AD$157:$AD160,$AD160))","v":0},"HOME",4,{"$f":"IFERROR(VLOOKUP(4,Track_Funding,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Viability Rehab:",4300000,null,null,null,null,null,null,"Viability",{"$f":"K44","v":0},0,{"$f":"IF($AD161=0,0,COUNTIF($AD$157:$AD161,$AD161))","v":0},"Viability",5,{"$f":"IFERROR(VLOOKUP(5,Track_Funding,2,FALSE),\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max GC Fee",{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,17)),\" \",VLOOKUP($F$9,AppSubRptData,17))","v":0},"DS_MaxGCFee",null,null,null,null,null,null,"#","FHFC Sources","Original Request Amounts","Source Label","Max Rqst Amts","Adjusted Request Amounts",null,null,null,null,null,null,"Adjusted Sources"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Hard Cost Contingency",{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,18)),\" \",VLOOKUP($F$9,AppSubRptData,18))","v":0},"DS_MaxHCC",null,null,null,null,null,null,{"$f":"IF(AD165=\"SAIL\",1,IF(AD165=\"ELI\",2,IF(AD165=\"NHTF\",3,IF(AD165=\"HOME\",4,IF(AD165=\"Viability\",5,\"\")))))","v":""},{"$f":"IFERROR(VLOOKUP(1,Track_Funding,2,FALSE),\"\")","v":""},{"$f":"CHOOSE(N(AC165)+1,\"\",N(SAIL_Request_Amount),N(ELI_Request_Amount),N(NHTF_Request_Amount),N(HOME_Request_Amount),N(Viability_Request_Amount),\"\")","v":""},{"$f":"CHOOSE(N(AC165)+1,\"Enter request on Funding Tab\",\"FHFC - SAIL\",\"FHFC - ELI\",\"FHFC - NHTF\",\"FHFC - HOME\",\"FHFC - Viability\",\"\")","v":"Enter request on Funding Tab"},{"$f":"CHOOSE(N(AC165)+1,\"\",N(Max_SAIL),N(Max_ELI),N(Max_NHTF),N(Max_HOME),N(Max_Viability),\"\")","v":""},{"$f":"IF(N(DS_FHFC_Source_1_Amt)>N(DS_FHFC_Source_1_Max_Amt),\"The \"&TEXT(DS_FHFC_Source_1_Name,\"0\")&\" request amount has been adjusted to the Maximum of \"&TEXT(N(DS_FHFC_Source_1_Max_Amt),\"$#,##0\")&\".\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(N(DS_FHFC_Source_1_Amt)>N(DS_FHFC_Source_1_Max_Amt),DS_FHFC_Source_1_Label,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Soft Cost Contingency",{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,19)),\" \",VLOOKUP($F$9,AppSubRptData,19))","v":0},"DS_MaxSCC",null,null,null,null,null,null,{"$f":"IF(AD166=\"SAIL\",1,IF(AD166=\"ELI\",2,IF(AD166=\"NHTF\",3,IF(AD166=\"HOME\",4,IF(AD166=\"Viability\",5,\"\")))))","v":""},{"$f":"IFERROR(VLOOKUP(2,Track_Funding,2,FALSE),\"\")","v":""},{"$f":"CHOOSE(N(AC166)+1,\"\",N(SAIL_Request_Amount),N(ELI_Request_Amount),N(NHTF_Request_Amount),N(HOME_Request_Amount),N(Viability_Request_Amount),\"\")","v":""},{"$f":"CHOOSE(N(AC166)+1,\"Enter request on Funding Tab\",\"FHFC - SAIL\",\"FHFC - ELI\",\"FHFC - NHTF\",\"FHFC - HOME\",\"FHFC - Viability\",\"\")","v":"Enter request on Funding Tab"},{"$f":"CHOOSE(N(AC166)+1,\"\",N(Max_SAIL),N(Max_ELI),N(Max_NHTF),N(Max_HOME),N(Max_Viability),\"\")","v":""},{"$f":"IF(N(DS_FHFC_Source_2_Amt)>N(DS_FHFC_Source_2_Max_Amt),\"The \"&TEXT(DS_FHFC_Source_2_Name,\"0\")&\" request amount has been adjusted to the Maximum of \"&TEXT(N(DS_FHFC_Source_2_Max_Amt),\"$#,##0\")&\".\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(N(DS_FHFC_Source_2_Amt)>N(DS_FHFC_Source_2_Max_Amt),DS_FHFC_Source_2_Label,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Dev Fee Acq Costs",{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,20)),\" \",VLOOKUP($F$9,AppSubRptData,20))","v":0},"DS_MaxDevFeeAcq_Percent",null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(3,Track_Funding,2,FALSE),\"\")","v":""},{"$f":"CHOOSE(N(AC167)+1,\"\",N(SAIL_Request_Amount),N(ELI_Request_Amount),N(NHTF_Request_Amount),N(HOME_Request_Amount),N(Viability_Request_Amount),\"\")","v":""},"Enter request on Funding Tab",{"$f":"CHOOSE(N(AC167)+1,\"\",N(Max_SAIL),N(Max_ELI),N(Max_NHTF),N(Max_HOME),N(Max_Viability),\"\")","v":""},{"$f":"IF(N(DS_FHFC_Source_3_Amt)>N(DS_FHFC_Source_3_Max_Amt),\"The \"&TEXT(DS_FHFC_Source_3_Name,\"0\")&\" request amount has been adjusted to the Maximum of \"&TEXT(N(DS_FHFC_Source_3_Max_Amt),\"$#,##0\")&\".\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(N(DS_FHFC_Source_3_Amt)>N(DS_FHFC_Source_3_Max_Amt),DS_FHFC_Source_3_Label,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Dev Fee Non-Acq Costs",{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,21)),\" \",VLOOKUP($F$9,AppSubRptData,21))","v":0},"DS_MaxDevFeeNonAcq_Percent",null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(4,Track_Funding,2,FALSE),\"\")","v":""},{"$f":"CHOOSE(N(AC168)+1,\"\",N(SAIL_Request_Amount),N(ELI_Request_Amount),N(NHTF_Request_Amount),N(HOME_Request_Amount),N(Viability_Request_Amount),\"\")","v":""},"Enter request on Funding Tab",{"$f":"CHOOSE(N(AC168)+1,\"\",N(Max_SAIL),N(Max_ELI),N(Max_NHTF),N(Max_HOME),N(Max_Viability),\"\")","v":""},{"$f":"IF(N(DS_FHFC_Source_4_Amt)>N(DS_FHFC_Source_4_Max_Amt),\"The \"&TEXT(DS_FHFC_Source_4_Name,\"0\")&\" request amount has been adjusted to the Maximum of \"&TEXT(N(DS_FHFC_Source_4_Max_Amt),\"$#,##0\")&\".\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(N(DS_FHFC_Source_4_Amt)>N(DS_FHFC_Source_4_Max_Amt),DS_FHFC_Source_4_Label,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Demographic Dev Fee",{"$f":"IF(ISERROR(VLOOKUP($F$9,AppSubRptData,22)),\" \",VLOOKUP($F$9,AppSubRptData,22))","v":0},"DS_MaxDevFeeDemographic_Percent",null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(5,Track_Funding,2,FALSE),\"\")","v":""},{"$f":"CHOOSE(N(AC169)+1,\"\",N(SAIL_Request_Amount),N(ELI_Request_Amount),N(NHTF_Request_Amount),N(HOME_Request_Amount),N(Viability_Request_Amount),\"\")","v":""},"Enter request on Funding Tab",{"$f":"CHOOSE(N(AC169)+1,\"\",N(Max_SAIL),N(Max_ELI),N(Max_NHTF),N(Max_HOME),N(Max_Viability),\"\")","v":""},{"$f":"IF(N(DS_FHFC_Source_5_Amt)>N(DS_FHFC_Source_5_Max_Amt),\"The \"&TEXT(DS_FHFC_Source_5_Name,\"0\")&\" request amount has been adjusted to the Maximum of \"&TEXT(N(DS_FHFC_Source_5_Max_Amt),\"$#,##0\")&\".\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(N(DS_FHFC_Source_5_Amt)>N(DS_FHFC_Source_5_Max_Amt),DS_FHFC_Source_5_Label,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max ODR",0.05,"DS_Max_ODR"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<select from menu>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FHFC - MMRB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local HFA Bonds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Mortgage Lender"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Government Subsidy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self-Sourced: Bond-Financing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self-Sourced: Non-Bond-Financing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seller Financing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Legislation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USDA RD 514/516"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USDA RD 515"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USDA RD 538"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deferred Development Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]

{"sheet":"Pro Forma","index":1,"n_rows":482,"n_cols":24,"rows_kept":482,"cut":false,"hidden":false,"merged":[[139,3,139,4],[73,3,73,4],[68,3,68,4],[188,3,188,4],[190,3,190,4],[193,3,193,4],[111,16,112,25],[104,16,105,25],[119,16,120,25],[129,16,130,25],[170,16,171,25],[155,16,156,25],[195,3,195,4],[194,16,195,25],[198,16,199,25],[430,11,430,13],[431,11,431,13],[432,11,432,13],[377,8,377,10],[378,8,378,10],[379,8,379,10],[370,3,370,13],[375,6,375,7],[376,6,376,7],[377,6,377,7],[378,6,378,7],[377,3,377,5],[378,3,378,5],[379,3,379,5],[375,11,375,13],[378,11,378,13],[376,3,376,5],[374,3,374,5],[375,3,375,5],[374,11,374,13],[400,11,400,13],[433,11,433,13],[434,11,434,13],[442,11,442,13],[443,11,443,13],[444,11,444,13],[446,11,446,13],[447,11,447,13],[448,11,448,13],[449,11,449,13],[435,11,435,13],[436,11,436,13],[437,11,437,13],[438,11,438,13],[450,11,450,13],[451,11,451,13],[445,11,445,13],[478,11,478,13],[479,11,479,13],[453,11,453,13],[457,11,457,13],[458,11,458,13],[459,11,459,13],[460,11,460,13],[461,11,461,13],[462,11,462,13],[463,11,463,13],[467,11,467,13],[468,11,468,13],[469,11,469,13],[470,11,470,13],[474,11,474,13],[475,11,475,13],[476,11,476,13],[477,11,477,13],[345,17,345,21],[333,10,333,13],[335,10,335,13],[337,10,337,13],[373,11,373,13],[368,10,368,12],[341,4,341,5],[371,3,371,5],[372,3,372,5],[373,3,373,5],[371,6,371,7],[371,8,371,10],[372,6,372,7],[373,6,373,7],[371,11,371,13],[339,17,340,22],[341,10,341,13],[343,10,343,13],[353,12,353,13],[345,10,346,13],[351,16,353,22],[331,10,331,13],[321,10,321,13],[293,4,293,5],[269,10,269,13],[279,10,279,13],[281,10,281,13],[283,10,283,13],[319,10,319,13],[343,4,343,5],[293,10,293,13],[295,10,295,13],[305,12,305,13],[297,17,297,21],[271,10,271,13],[313,10,313,13],[327,10,327,13],[329,10,329,13],[295,4,295,5],[308,16,311,25],[291,17,292,22],[265,10,265,13],[325,10,325,13],[265,17,267,23],[297,10,298,13],[303,16,305,22],[0,0,0,15],[273,10,273,13],[275,10,275,13],[277,10,277,13],[323,10,323,13],[37,10,37,13],[254,16,257,25],[62,16,63,25],[80,16,81,25],[84,16,85,25],[175,16,176,25],[94,16,95,25],[96,16,97,25],[109,16,110,25],[177,16,179,25],[196,16,197,25],[157,16,158,25],[163,16,164,25],[267,10,267,13],[249,5,251,14],[259,10,259,13],[39,16,41,25],[46,16,47,25],[39,6,39,13],[242,5,244,14],[121,16,122,25],[133,16,134,25],[125,16,126,25],[123,16,124,28],[127,16,128,25],[60,16,61,25],[48,16,49,25],[100,16,101,25],[115,16,116,25],[117,16,118,25],[180,16,181,25],[192,16,193,25],[233,5,237,14],[216,5,218,14],[220,5,222,14],[227,5,231,14],[67,16,68,25],[72,16,73,25],[138,16,139,25],[187,16,188,25],[189,16,190,25],[399,10,399,12],[379,6,379,7],[372,8,372,10],[373,8,373,10],[374,6,374,7],[379,11,379,13],[372,11,372,13],[384,10,384,12],[375,8,375,10],[376,8,376,10],[376,11,376,13],[374,8,374,10],[43,16,44,25],[197,3,197,4],[402,11,402,13],[412,11,412,13],[414,11,414,13],[416,11,417,13],[380,3,381,13],[387,11,387,13],[388,11,388,13],[389,11,389,13],[391,11,391,13],[392,11,392,13],[393,11,393,13],[395,11,395,13],[397,10,397,12],[386,10,386,12],[383,11,383,13],[396,11,396,13],[406,11,406,13],[404,11,404,13],[408,11,408,13],[410,11,410,13],[394,11,394,13],[377,11,377,13]]}
["Section 4.A.10\nDevelopment Cost Pro Forma"]
[null,{"$f":"\"RFA 2023-211 DEVELOPMENT COST PRO FORMA\"","v":"RFA 2023-211 DEVELOPMENT COST PRO FORMA"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(Page 1 of 6)\"","v":"(Page 1 of 6)"}]
[]
[null,null,null,"NOTES:",1,"Applicants will be held to the terms and conditions of the RFA under which the Active Award was made, and the applicable"]
[null,null,null,null,null,"rule chapter in effect at the time of the Original Application. This includes, but is not limited to, Developer Fee limits, Hard"]
[null,null,null,null,null,"and Soft Cost limits, and Operating Deficit Reserves."]
[]
[null,null,null,null,{"$f":"MAX(E$4:E5)+1","v":2},"If Housing Credit equity proceeds are being used as a source of financing, complete Columns 1 and 2, otherwise, complete "]
[null,null,null,null,null,"column 1 only. The various FHFC Program fees should be estimated and included in column 2 for at least the Housing Credit"]
[null,null,null,null,null,"Program, along with the MMRB Program, if applicable."]
[null,null,null,null,null,"General Contractor's fee is limited to 14% of actual construction cost (for Application purposes, this is represented by "]
[null,null,null,null,null,"A1.1. Column 3), rounded down to nearest dollar. The General Contractor's fee must be disclosed.  The General Contractor's "]
[null,null,null,null,null,"fee includes General Conditions, Overhead, and Profit."]
[null,null,null,null,null,"For Application purposes, the maximum hard and soft cost contingencies allowed cannot exceed 5% of hard and soft costs "]
[null,null,null,null,null,"(column 3 for A1.3. TOTAL ACTUAL CONSTRUCTION COSTS and column 3 for A2.1. TOTAL GENERAL DEVELOPMENT "]
[null,null,null,null,null,"COST, respectively), as further described in Rule Chapter 67-48, F.A.C., or this RFA. "]
[null,null,null,null,null,"new construction.  Otherwise the maximum is 15%.  The maximum soft cost contingency allowed cannot exceed "]
[null,null,null,null,null,"5% of the amount provided in column 3 for A2.1 TOTAL GENERAL DEVELOPMENT COST.  Limitations on these contingency "]
[null,null,null,null,null,"line items post-Application are provided in Rule Chapter 67-48, F.A.C. (if applicable) and this RFA."]
[null,null,null,null,null,"Operating Deficit Reserves (ODR) of any kind are not to be included in C. DEVELOPMENT COST and cannot be used in "]
[null,null,null,null,null,"determining the maximum Developer fee.  In addition, an ODR is not permitted in this Application at all.  If one has been "]
[null,null,null,null,null,"included, it will be removed by the scorer, reducing total costs.  However, one may be included during the credit underwriting "]
[null,null,null,null,null,"process where it will be sized. The final cost certification may include an ODR, but it cannot exceed the amount sized during "]
[null,null,null,null,null,"credit underwriting."]
[null,null,null,null,{"$f":"MAX(E$4:E23)+1","v":3},"Commercial, retail, and office space are not functionally related and subordinate to the residential units, and are not "]
[null,null,null,null,null,"considered to be community service facilities. As such, these costs are neither considered in eligible basis nor included"]
[null,null,null,null,null,"in the TDC PU Limitation process."]
[null,null,null,null,{"$f":"MAX(E$4:E27)+1","v":4},"Although the Corporation acknowledges that the costs listed on the Development Cost Pro Forma, Detail/Explanation Sheet, "]
[null,null,null,null,null,"Construction or Rehab Analysis and Permanent Analysis are subject to change during credit underwriting, such costs are "]
[null,null,null,null,null,"subject to the Total Development Cost Per Unit Limitation as provided in the RFA, as well as the other cost limitations provided "]
[null,null,null,null,null,"in Rule Chapter 67-48, F.A.C., as applicable."]
[null,null,null,null,{"$f":"MAX(E$4:E31)+1","v":5},"To the extent any variances occur between this Pro forma and the other worksheet tabs of Exhibit A., the responses in the other "]
[null,null,null,null,null,"worksheet tabs of Exhibit A. will take precedence."]
[]
[null,null,"USE THE DETAIL/EXPLANATION SHEET FOR EXPLANATION OF * ITEMS.  IF ADDITIONAL SPACE IS REQUIRED, ENTER THE"]
[null,null,"INFORMATION ON THE ADDENDA LOCATED AT THE END OF THE APPLICATION. "]
[]
[null,null,null,null,null,null,null,null,"What was the Development Category of the Proposed Development:",null,{"$f":"Funding!F13","v":0},null,null,null,null,{"$f":"IF(K38=\"Category Input Required\",\"**\",\"\")","v":""},null,"**","If a double asterisk is indicated within the Development Cost Pro Forma, there is an error on that line item."]
[null,null,null,null,null,null,null,null,"Indicate the number of total units in the proposed Development:",null,{"$f":"Funding!F14","v":0},null,null,null,null,{"$f":"IF(N(K39)=0,\"**\",\"\")","v":"**"}]
[null,null,null,null,null,null,{"$f":"IF(SUM(I45:I201)+SUM(L45:L201)>0,\"The \"&TEXT(SUM(I45:I201)+SUM(L45:L201),\"0\")&\" highlighted cell\"&IF(SUM(I45:I201)+SUM(L45:L201)>1,\"s\",\"\")&\" should be corrected to have a whole number\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Some Suggestive Assistance\nThe criteria below attempts to help the user to know the maximum limits of some cost items, when possible.  FHFC is not responsible for any programming errors related to the assistance offered below.  Applicant is responsible to verify all inputs to RFA criteria.\n*criteria will not be evaluated at time of Application, but will be evaluated at time of credit underwriting and final cost certification"]
[null,null,null,null,null,null,null,1,null,null,{"$f":"IF(E42=2,\"‡\",2)","v":"‡"},null,null,3]
[null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(Funding!F9,AppSubRptData,23)),\" \",IF(VLOOKUP(Funding!F9,AppSubRptData,23)=\"Yes\",3,2))","v":2},null,null,{"$f":"IF(E42=2,\"PROPOSED                                                                         COSTS\",\"HC ELIGIBLE                                                                               COSTS\")","v":"PROPOSED                                                                         COSTS"},null,null,{"$f":"IF(E42=2,\"See Note at Right\",\"HC INELIGIBLE\nCOSTS\")","v":"See Note at Right"},null,null,"TOTAL\nCOSTS"]
[null,"DEVELOPMENT COSTS"]
[null,null,"Actual Construction Costs ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E42=2,\"‡ A Housing Credit Request Amount must be entered on the Funding Tab in order to view and input data into Column 2.\",\"\")","v":"‡ A Housing Credit Request Amount must be entered on the Funding Tab in order to view and input data into Column 2."}]
[null,null,null,"Accessory Buildings",null,null,null,null,null,null,null,{"$f":"IF(N(K45)<>ROUNDDOWN(N(K45),0),1,\"\")","v":""},null,{"$f":"IF(H45+IF($E$42=3,K45,0)=0,\"\",H45+IF($E$42=3,K45,0))","v":""}]
[]
[null,null,null,"Demolition",null,null,null,null,null,null,null,{"$f":"IF(N(K47)<>ROUNDDOWN(N(K47),0),1,\"\")","v":""},null,{"$f":"IF(AND($E$42=3,K47=0),\"\",IF(AND($E$42=3,K47>0),K47,IF(AND($E$42=2,H47=0),\"\",IF(AND($E$42=2,H47>0),H47))))","v":""},null,null,"The cost of demolition is to be excluded from eligible basis.*  "]
[]
[null,null,null,"Commercial/Retail Space See Note (3)",null,null,null,null,null,null,null,{"$f":"IF(N(K49)<>ROUNDDOWN(N(K49),0),1,\"\")","v":""},null,{"$f":"IF(AND($E$42=3,K49=0),\"\",IF(AND($E$42=3,K49>0),K49,IF(AND($E$42=2,H49=0),\"\",IF(AND($E$42=2,H49>0),H49))))","v":""},null,null,"The cost of commercial/retail space is to be excluded from eligible basis.*  "]
[]
[null,null,null,"New Rental Units",null,null,null,null,null,null,null,{"$f":"IF(N(K51)<>ROUNDDOWN(N(K51),0),1,\"\")","v":""},null,{"$f":"IF(H51+IF($E$42=3,K51,0)=0,\"\",H51+IF($E$42=3,K51,0))","v":""}]
[]
[null,null,null,"*Off-Site Work (explain in detail)",null,null,null,null,null,null,null,{"$f":"IF(N(K53)<>ROUNDDOWN(N(K53),0),1,\"\")","v":""},null,{"$f":"IF(H53+IF($E$42=3,K53,0)=0,\"\",H53+IF($E$42=3,K53,0))","v":""}]
[]
[null,null,null,"Recreational Amenities",null,null,null,null,null,null,null,{"$f":"IF(N(K55)<>ROUNDDOWN(N(K55),0),1,\"\")","v":""},null,{"$f":"IF(H55+IF($E$42=3,K55,0)=0,\"\",H55+IF($E$42=3,K55,0))","v":""}]
[]
[null,null,null,"Rehab of Existing Common Areas",null,null,null,null,null,null,null,{"$f":"IF(N(K57)<>ROUNDDOWN(N(K57),0),1,\"\")","v":""},null,{"$f":"IF(H57+IF($E$42=3,K57,0)=0,\"\",H57+IF($E$42=3,K57,0))","v":""}]
[]
[null,null,null,"Rehab of Existing Rental Units",null,null,null,null,null,null,null,{"$f":"IF(N(K59)<>ROUNDDOWN(N(K59),0),1,\"\")","v":""},null,{"$f":"IF(H59+IF($E$42=3,K59,0)=0,\"\",H59+IF($E$42=3,K59,0))","v":""}]
[]
[null,null,null,"Site Work",null,null,null,null,null,null,null,{"$f":"IF(N(K61)<>ROUNDDOWN(N(K61),0),1,\"\")","v":""},null,{"$f":"IF(H61+IF($E$42=3,K61,0)=0,\"\",H61+IF($E$42=3,K61,0))","v":""},null,null,"The cost of clearing, grubbing, cutting, filling and grading necessary to bring the land to a suitable grade (but not activity that provides a proper setting for a building or a paved roadway) are to be excluded from eligible basis.*"]
[]
[null,null,null,"*Other (explain in detail)",null,null,null,null,null,null,null,{"$f":"IF(N(K63)<>ROUNDDOWN(N(K63),0),1,\"\")","v":""},null,{"$f":"IF(H63+IF($E$42=3,K63,0)=0,\"\",H63+IF($E$42=3,K63,0))","v":""},null,null,"The cost of landscaping that would not be physically destroyed when the proposed building(s) is to be demolished (at the end of its useful life) and replaced is to be excluded from eligible basis.*"]
[]
[null,"A1.1.","Actual Construction Cost ",null,null,null,"$",{"$f":"IF(SUM(H45:H63)=0,\"\",SUM(H45:H63))","v":""},null,"$",{"$f":"IF(SUM(K45:K63)=0,\"\",SUM(K45:K63))","v":""},null,"$",{"$f":"IF(N(H65)+IF($E$42=3,N(K65),0)=0,\"\",N(H65)+IF($E$42=3,N(K65),0))","v":""}]
[]
[null,"A1.2.","General Contractor Fee See Note (1)"]
[null,null,{"$f":"\"(Max. \"&TEXT(DS_MaxGCFee,\"0%\")&\" of A1.1., column 3)\"","v":"(Max. 0% of A1.1., column 3)"},null,null,null,"$",null,null,"$",null,{"$f":"IF(N(K68)<>ROUNDDOWN(N(K68),0),1,\"\")","v":""},"$",{"$f":"IF($E$42=2,IF(AND(N(Actual_GCfee_eligible)=0,N(Actual_Constructioncost_total)>0),N(GCF_DollarMax),IF(N(Actual_GCfee_eligible)>N(GCF_DollarMax),N(GCF_DollarMax),N(Actual_GCfee_eligible))),IF(AND(SUM(N(Actual_GCfee_eligible),N(Actual_GCfee_ineligible))=0,N(Actual_Constructioncost_total)>0),N(GCF_DollarMax),IF(SUM(N(Actual_GCfee_eligible),N(Actual_GCfee_ineligible))>N(GCF_DollarMax),N(GCF_DollarMax),SUM(N(Actual_GCfee_eligible),N(Actual_GCfee_ineligible)))))","v":0},null,{"$f":"IF(P69=\"No\",\"**\",\"\")","v":""},{"$f":"IF(P69=\"No\",IF(AND(N(Actual_Constructioncost_total)>0,SUM(N(Actual_GCfee_eligible),N(Actual_GCfee_ineligible))=0),\"The GC Fee must be disclosed.  If it is not, the maximum Total GC Fee of \"&TEXT(N(GCF_DollarMax),\"$#,##0.00\")&\" will be utilized. This will impact cost totals and subtotals below.\",\"\")&IF(N(Actual_GCfee_total)<SUM(N(Actual_GCfee_eligible)+N(Actual_GCfee_ineligible)),\"Because the combined Eligible and Ineligible amounts entered for 'General Contractor Fee' are too high by \"&TEXT(N(Actual_GCfee_eligible)+N(Actual_GCfee_ineligible)-N(GCF_DollarMax),\"$#,##0.00\")&\", the maximum Total GC Fee of \"&TEXT(N(GCF_DollarMax),\"$#,##0.00\")&\" has been utilized. This will impact cost totals and subtotals below.  \",\"\"),\"\")","v":""}]
[null,null,null,{"$f":"\"Max GCF @ \"&TEXT(DS_MaxGCFee,\"#0%\")&\":\"","v":"Max GCF @ 0%:"},null,{"$f":"ROUNDDOWN(DS_MaxGCFee*N(Actual_Constructioncost_total),0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(SUM(N(Actual_GCfee_eligible),N(Actual_GCfee_ineligible))=0,N(Actual_Constructioncost_total)>0),SUM(N(Actual_GCfee_eligible),N(Actual_GCfee_ineligible))>GCF_DollarMax),\"No\",\"Yes\")","v":"Yes"}]
[null,"A1.3.","TOTAL ACTUAL CONSTRUCTION"]
[null,null,null,"COSTS",null,null,"$",{"$f":"IF(SUM(H65:H70)=0,\"\",SUM(H65:H70))","v":""},null,"$",{"$f":"IF(SUM(K65:K70)=0,\"\",SUM(K65:K70))","v":""},null,"$",{"$f":"IF(N(N65)+N(N68)=0,\"\",N(N65)+N(N68))","v":""}]
[]
[null,"A1.4.","HARD COST CONTINGENCY See Note (1)",null,null,null,"$",null,null,"$",null,{"$f":"IF(N(K73)<>ROUNDDOWN(N(K73),0),1,\"\")","v":""},"$",{"$f":"IF($E$42=2,IF(N(Contingency_Hard_eligible)=0,\"\",IF(N(Contingency_Hard_eligible)>N(HCC_DollarMax),N(HCC_DollarMax),N(Contingency_Hard_eligible))),IF(SUM(N(Contingency_Hard_eligible),N(Contingency_Hard_ineligible))=0,\"\",IF(SUM(N(Contingency_Hard_eligible),N(Contingency_Hard_ineligible))>N(HCC_DollarMax),N(HCC_DollarMax),SUM(N(Contingency_Hard_eligible),N(Contingency_Hard_ineligible)))))","v":""},null,{"$f":"IF($P$74=\"No\",\"**\",\"\")","v":""},{"$f":"IF(AND(DS_Pro_Forma_Dev_Cat=\"Category Input Required\",N(Actual_TotalConstructioncost_total)>0),\"Please select the applicable Development Category from the drop-down menu at the top of the 'Proposed Development Info' tab.\",IF(P74=\"No\",\"Because the combined Eligible and Ineligible amounts entered for 'Hard Cost Contingency' are too high by \"&TEXT(SUM(N(Contingency_Hard_eligible),N(Contingency_Hard_ineligible))-N(HCC_DollarMax),\"$#,##0.00\")&\", the maximum Total Hard Cost Contingency of \"&TEXT(N(HCC_DollarMax),\"$#,##0.00\")&\" has been utilized.\",\"\"))","v":""}]
[null,null,null,{"$f":"\"Max HCC @ \"&TEXT(DS_MaxHCC,\"#0%\")&\":\"","v":"Max HCC @ 0%:"},null,{"$f":"IF(AND(DS_Pro_Forma_Dev_Cat=\"Category Input Required\",N(Actual_TotalConstructioncost_total)>0),0,N(DS_MaxHCC)*N(Actual_TotalConstructioncost_total))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N(Contingency_Hard_eligible),N(Contingency_Hard_ineligible))<=HCC_DollarMax,\"Yes\",\"No\")","v":"Yes"}]
[]
[]
[null,{"$f":"B$2","v":"RFA 2023-211 DEVELOPMENT COST PRO FORMA"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(Page 2 of 6)\"","v":"(Page 2 of 6)"}]
[null,null,null,null,null,null,null,{"$f":"H41","v":1},null,null,{"$f":"K41","v":"‡"},null,null,{"$f":"N41","v":3}]
[null,null,null,null,null,null,null,{"$f":"H42","v":"PROPOSED                                                                         COSTS"},null,null,{"$f":"IF(E42=2,\"See Note at Upper Right\",\"HC INELIGIBLE\nCOSTS\")","v":"See Note at Upper Right"},null,null,{"$f":"N42","v":"TOTAL\nCOSTS"}]
[null,null,"General Development Costs"]
[null,null,null,"Accounting Fees",null,null,null,null,null,null,null,{"$f":"IF(N(K81)<>ROUNDDOWN(N(K81),0),1,\"\")","v":""},null,{"$f":"IF(H81+IF($E$42=3,K81,0)=0,\"\",H81+IF($E$42=3,K81,0))","v":""},null,null,"The cost of preparing the cost certifications and any accounting fees associated with organizing the Applicant entity are to be excluded from eligible basis.*"]
[]
[null,null,null,"Appraisal",null,null,null,null,null,null,null,{"$f":"IF(N(K83)<>ROUNDDOWN(N(K83),0),1,\"\")","v":""},null,{"$f":"IF(H83+IF($E$42=3,K83,0)=0,\"\",H83+IF($E$42=3,K83,0))","v":""}]
[]
[null,null,null,"Architect's Fee - Site/Building Design",null,null,null,null,null,null,null,{"$f":"IF(N(K85)<>ROUNDDOWN(N(K85),0),1,\"\")","v":""},null,{"$f":"IF(H85+IF($E$42=3,K85,0)=0,\"\",H85+IF($E$42=3,K85,0))","v":""},null,null,"The cost of the preparation of erosion control plan, grading plan, utility plans, general details, easement descriptions, sewer and sanitary plans and traffic engineering are to be excluded from eligible basis.*"]
[]
[null,null,null,"Architect's Fee - Supervision",null,null,null,null,null,null,null,{"$f":"IF(N(K87)<>ROUNDDOWN(N(K87),0),1,\"\")","v":""},null,{"$f":"IF(H87+IF($E$42=3,K87,0)=0,\"\",H87+IF($E$42=3,K87,0))","v":""}]
[]
[null,null,null,"Builder's Risk Insurance",null,null,null,null,null,null,null,{"$f":"IF(N(K89)<>ROUNDDOWN(N(K89),0),1,\"\")","v":""},null,{"$f":"IF(H89+IF($E$42=3,K89,0)=0,\"\",H89+IF($E$42=3,K89,0))","v":""}]
[]
[null,null,null,"Building Permit",null,null,null,null,null,null,null,{"$f":"IF(N(K91)<>ROUNDDOWN(N(K91),0),1,\"\")","v":""},null,{"$f":"IF(H91+IF($E$42=3,K91,0)=0,\"\",H91+IF($E$42=3,K91,0))","v":""}]
[]
[null,null,null,"Capital Needs Assessment",null,null,null,null,null,null,null,{"$f":"IF(N(K93)<>ROUNDDOWN(N(K93),0),1,\"\")","v":""},null,{"$f":"IF(H93+IF($E$42=3,K93,0)=0,\"\",H93+IF($E$42=3,K93,0))","v":""}]
[]
[null,null,null,"Engineering Fees",null,null,null,null,null,null,null,{"$f":"IF(N(K95)<>ROUNDDOWN(N(K95),0),1,\"\")","v":""},null,{"$f":"IF(H95+IF($E$42=3,K95,0)=0,\"\",H95+IF($E$42=3,K95,0))","v":""},null,null,"The cost of the preparation of erosion control plan, grading plan, utility plans, general details, easement descriptions, sewer and sanitary plans and traffic engineering are to be excluded from eligible basis.*"]
[]
[null,null,null,"Environmental Report",null,null,null,null,null,null,null,{"$f":"IF(N(K97)<>ROUNDDOWN(N(K97),0),1,\"\")","v":""},null,{"$f":"IF(H97+IF($E$42=3,K97,0)=0,\"\",H97+IF($E$42=3,K97,0))","v":""},null,null,"The cost of environment surveys such as percolation tests and contamination studies are to be excluded from eligible basis.*"]
[]
[null,null,null,"FHFC Administrative Fee See Note (2) ",null,null,null,null,null,null,null,{"$f":"IF(N(K99)<>ROUNDDOWN(N(K99),0),1,\"\")","v":""},null,{"$f":"IF(H99+IF($E$42=3,K99,0)=0,\"\",H99+IF($E$42=3,K99,0))","v":""}]
[]
[null,null,null,"FHFC Application Fee See Note (2) ",null,null,null,null,null,null,null,{"$f":"IF(N(K101)<>ROUNDDOWN(N(K101),0),1,\"\")","v":""},null,{"$f":"IF(H101+IF($E$42=3,K101,0)=0,\"\",H101+IF($E$42=3,K101,0))","v":""},null,null,"If tax-exempt bonds are part of the construction financing, this line item cannot have any costs in the first column."]
[]
[null,null,null,"FHFC Compliance Fee See Note (2) ",null,null,null,null,null,null,null,{"$f":"IF(N(K103)<>ROUNDDOWN(N(K103),0),1,\"\")","v":""},null,{"$f":"IF(H103+IF($E$42=3,K103,0)=0,\"\",H103+IF($E$42=3,K103,0))","v":""}]
[]
[null,null,null,"FHFC PRL/Credit Underwriting Fees See Note (2)",null,null,null,null,null,null,null,{"$f":"IF(N(K105)<>ROUNDDOWN(N(K105),0),1,\"\")","v":""},null,{"$f":"IF(H105+IF($E$42=3,K105,0)=0,\"\",H105+IF($E$42=3,K105,0))","v":""},null,null,"If tax-exempt bonds are part of the construction financing, this line item cannot have any costs in the first column."]
[]
[null,null,null,"Green Building Certification/"]
[null,null,null,null,"HERS Inspection Costs",null,null,null,null,null,null,{"$f":"IF(N(K108)<>ROUNDDOWN(N(K108),0),1,\"\")","v":""},null,{"$f":"IF(H108+IF($E$42=3,K108,0)=0,\"\",H108+IF($E$42=3,K108,0))","v":""}]
[]
[null,null,null,"*Impact Fees (list in detail)",null,null,null,null,null,null,null,{"$f":"IF(N(K110)<>ROUNDDOWN(N(K110),0),1,\"\")","v":""},null,{"$f":"IF(H110+IF($E$42=3,K110,0)=0,\"\",H110+IF($E$42=3,K110,0))","v":""},null,null,"Do not include any part of any impact fees that are to be paid initially, but will be returned/refunded back to the Applicant at a later date, usually upon delivery of an affordable housing development."]
[]
[null,null,null,"Inspection Fees",null,null,null,null,null,null,null,{"$f":"IF(N(K112)<>ROUNDDOWN(N(K112),0),1,\"\")","v":""},null,{"$f":"IF(H112+IF($E$42=3,K112,0)=0,\"\",H112+IF($E$42=3,K112,0))","v":""},null,null,"Bank inspector fees associated with tax-exempt bonds are to be excluded from eligible basis.*"]
[]
[null,null,null,"Insurance",null,null,null,null,null,null,null,{"$f":"IF(N(K114)<>ROUNDDOWN(N(K114),0),1,\"\")","v":""},null,{"$f":"IF(H114+IF($E$42=3,K114,0)=0,\"\",H114+IF($E$42=3,K114,0))","v":""}]
[]
[null,null,null,"Legal Fees",null,null,null,null,null,null,null,{"$f":"IF(N(K116)<>ROUNDDOWN(N(K116),0),1,\"\")","v":""},null,{"$f":"IF(H116+IF($E$42=3,K116,0)=0,\"\",H116+IF($E$42=3,K116,0))","v":""},null,null,"Certain legal fees are to be excluded from eligible basis, such as those associated with issuance of tax-exempt bonds, partnership costs, land acquisition, and negotiating financing.*"]
[]
[null,null,null,"Market Study",null,null,null,null,null,null,null,{"$f":"IF(N(K118)<>ROUNDDOWN(N(K118),0),1,\"\")","v":""},null,{"$f":"IF(AND($E$42=3,K118=0),\"\",IF(AND($E$42=3,K118>0),K118,IF(AND($E$42=2,H118=0),\"\",IF(AND($E$42=2,H118>0),H118))))","v":""},null,null,"The market study required by IRS prior to the issuance of the Carryover Agreement is to be excluded from eligible basis.*"]
[]
[null,null,null,"Marketing/Advertising",null,null,null,null,null,null,null,{"$f":"IF(N(K120)<>ROUNDDOWN(N(K120),0),1,\"\")","v":""},null,{"$f":"IF(AND($E$42=3,K120=0),\"\",IF(AND($E$42=3,K120>0),K120,IF(AND($E$42=2,H120=0),\"\",IF(AND($E$42=2,H120>0),H120))))","v":""},null,null,"If tax-exempt bonds are part of the construction financing, this line item cannot have any costs in the first column."]
[]
[null,null,null,"Property Taxes",null,null,null,null,null,null,null,{"$f":"IF(N(K122)<>ROUNDDOWN(N(K122),0),1,\"\")","v":""},null,{"$f":"IF(H122+IF($E$42=3,K122,0)=0,\"\",H122+IF($E$42=3,K122,0))","v":""},null,null,"The cost of property taxes accrued outside of the term beginning at time of acquisition through issuance of the certificate of occupancy (or temporary) are to be excluded from eligible basis.*"]
[]
[null,null,null,"Soil Test Report",null,null,null,null,null,null,null,{"$f":"IF(N(K124)<>ROUNDDOWN(N(K124),0),1,\"\")","v":""},null,{"$f":"IF(H124+IF($E$42=3,K124,0)=0,\"\",H124+IF($E$42=3,K124,0))","v":""},null,null,"The cost of certain surveys that will not necessarily need to be redone when the proposed building(s) are demolished and replaced are to be excluded from eligible basis, including soil borings, geotechnical investigations, suitability studies, wetland reviews, mapping of wetland, and inspections of wetland, wetland characterization, and groundwater investigations."]
[]
[null,null,null,"Survey",null,null,null,null,null,null,null,{"$f":"IF(N(K126)<>ROUNDDOWN(N(K126),0),1,\"\")","v":""},null,{"$f":"IF(H126+IF($E$42=3,K126,0)=0,\"\",H126+IF($E$42=3,K126,0))","v":""},null,null,"The cost of a land, boundary or mortgage survey that help to define the entire property is to be excluded from eligible basis.*"]
[]
[null,null,null,"Tenant Relocation Costs",null,null,null,null,null,null,null,{"$f":"IF(N(K128)<>ROUNDDOWN(N(K128),0),1,\"\")","v":""},null,{"$f":"IF(H128+IF($E$42=3,K128,0)=0,\"\",H128+IF($E$42=3,K128,0))","v":""},null,null,"Relocation costs are considered to be ineligible basis when the building from which the tenants came is demolished, unless otherwise addressed by IRC Section 42.*"]
[]
[null,null,null,"Title Insurance & Recording Fees",null,null,null,null,null,null,null,{"$f":"IF(N(K130)<>ROUNDDOWN(N(K130),0),1,\"\")","v":""},null,{"$f":"IF(H130+IF($E$42=3,K130,0)=0,\"\",H130+IF($E$42=3,K130,0))","v":""},null,null,"Title insurance and recording fees associated with permanent financing sources are not to be included in eligible basis.*"]
[]
[null,null,null,"Utility Connection Fee",null,null,null,null,null,null,null,{"$f":"IF(N(K132)<>ROUNDDOWN(N(K132),0),1,\"\")","v":""},null,{"$f":"IF(H132+IF($E$42=3,K132,0)=0,\"\",H132+IF($E$42=3,K132,0))","v":""}]
[]
[null,null,null,"*Other (explain in detail)",null,null,null,null,null,null,null,{"$f":"IF(N(K134)<>ROUNDDOWN(N(K134),0),1,\"\")","v":""},null,{"$f":"IF(H134+IF($E$42=3,K134,0)=0,\"\",H134+IF($E$42=3,K134,0))","v":""},null,null,"Some items placed in this general category should be classified as ineligible basis. Examples include tenant relocation costs when the building they were occupying is to be demolished, partnership organization fees, syndication legal fees.*"]
[]
[null,"A2.1.","TOTAL GENERAL DEVELOPMENT"]
[null,null,null,"COST",null,null,"$",{"$f":"IF(SUM(H81:H134)=0,\"\",SUM(H81:H134))","v":""},null,"$",{"$f":"IF(SUM(K81:K134)=0,\"\",SUM(K81:K134))","v":""},null,"$",{"$f":"IF(N(H137)+IF($E$42=3,N(K137),0)=0,\"\",N(H137)+IF($E$42=3,N(K137),0))","v":""}]
[]
[null,"A2.2.","SOFT COST CONTINGENCY See Note (1)",null,null,null,"$",null,null,"$",null,{"$f":"IF(N(K139)<>ROUNDDOWN(N(K139),0),1,\"\")","v":""},"$",{"$f":"IF($E$42=2,IF(N(Contingency_Soft_eligible)=0,\"\",IF(N(Contingency_Soft_eligible)>N(SCC_DollarMax),N(SCC_DollarMax),N(Contingency_Soft_eligible))),IF(SUM(N(Contingency_Soft_eligible),N(Contingency_Soft_ineligible))=0,\"\",IF(SUM(N(Contingency_Soft_eligible),N(Contingency_Soft_ineligible))>N(SCC_DollarMax),N(SCC_DollarMax),SUM(N(Contingency_Soft_eligible),N(Contingency_Soft_ineligible)))))","v":""},null,{"$f":"IF($P$140=\"No\",\"**\",\"\")","v":""},{"$f":"IF(P140=\"No\",\"Because the combined Eligible and Ineligible amounts entered for 'Soft Cost Contingency' are too high by \"&TEXT(SUM(N(Contingency_Soft_eligible),N(Contingency_Soft_ineligible))-N(SCC_DollarMax),\"$#,##0.00\")&\", the maximum Total Soft Cost Contingency of \"&TEXT(N(SCC_DollarMax),\"$#,##0.00\")&\" has been utilized.\",\"\")","v":""}]
[null,null,null,{"$f":"\"Max SCC @ \"&TEXT(DS_MaxSCC,\"#0%\")&\":\"","v":"Max SCC @ 0%:"},null,{"$f":"DS_MaxSCC*N(General_totaldevelopmentcost_total)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N(Contingency_Soft_eligible),N(Contingency_Soft_ineligible))<=N(SCC_DollarMax),\"Yes\",\"No\")","v":"Yes"}]
[]
[]
[null,{"$f":"B$2","v":"RFA 2023-211 DEVELOPMENT COST PRO FORMA"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(Page 3 of 6)\"","v":"(Page 3 of 6)"}]
[null,null,null,null,null,null,null,{"$f":"H41","v":1},null,null,{"$f":"K41","v":"‡"},null,null,{"$f":"N41","v":3}]
[null,null,null,null,null,null,null,{"$f":"H42","v":"PROPOSED                                                                         COSTS"},null,null,{"$f":"K79","v":"See Note at Upper Right"},null,null,{"$f":"N42","v":"TOTAL\nCOSTS"}]
[null,null,"Financial Costs "]
[null,null,null,"Construction Loan Origination/"]
[null,null,null,null,"Commitment Fee(s)",null,null,null,null,null,null,{"$f":"IF(N(K148)<>ROUNDDOWN(N(K148),0),1,\"\")","v":""},null,{"$f":"IF(H148+IF($E$42=3,K148,0)=0,\"\",H148+IF($E$42=3,K148,0))","v":""}]
[]
[null,null,null,"Construction Loan Credit"]
[null,null,null,null,"Enhancement Fee(s)",null,null,null,null,null,null,{"$f":"IF(N(K151)<>ROUNDDOWN(N(K151),0),1,\"\")","v":""},null,{"$f":"IF(H151+IF($E$42=3,K151,0)=0,\"\",H151+IF($E$42=3,K151,0))","v":""}]
[]
[null,null,null,"Construction Loan Interest",null,null,null,null,null,null,null,{"$f":"IF(N(K153)<>ROUNDDOWN(N(K153),0),1,\"\")","v":""},null,{"$f":"IF(H153+IF($E$42=3,K153,0)=0,\"\",H153+IF($E$42=3,K153,0))","v":""}]
[]
[null,null,null,"Non-Permanent Loan(s) Closing"]
[null,null,null,null,"Costs",null,null,null,null,null,null,{"$f":"IF(N(K156)<>ROUNDDOWN(N(K156),0),1,\"\")","v":""},null,{"$f":"IF(H156+IF($E$42=3,K156,0)=0,\"\",H156+IF($E$42=3,K156,0))","v":""},null,null,"Any costs associated with the issuance of tax-exempt bonds are to be excluded from eligible basis.*"]
[]
[null,null,null,"Permanent Loan Origination/",null,null,null,null,null,null,null,null,null,null,null,null,"If tax-exempt bonds are part of the construction financing, this line item cannot have any costs in the first column."]
[null,null,null,null,"Commitment Fee(s)",null,null,null,null,null,null,{"$f":"IF(N(K159)<>ROUNDDOWN(N(K159),0),1,\"\")","v":""},null,{"$f":"IF(AND($E$42=3,K159=0),\"\",IF(AND($E$42=3,K159>0),K159,IF(AND($E$42=2,H159=0),\"\",IF(AND($E$42=2,H159>0),H159))))","v":""}]
[]
[null,null,null,"Permanent Loan Credit"]
[null,null,null,null,"Enhancement Fee(s)",null,null,null,null,null,null,{"$f":"IF(N(K162)<>ROUNDDOWN(N(K162),0),1,\"\")","v":""},null,{"$f":"IF(AND($E$42=3,K162=0),\"\",IF(AND($E$42=3,K162>0),K162,IF(AND($E$42=2,H162=0),\"\",IF(AND($E$42=2,H162>0),H162))))","v":""}]
[]
[null,null,null,"Permanent Loan Closing Costs",null,null,null,null,null,null,null,{"$f":"IF(N(K164)<>ROUNDDOWN(N(K164),0),1,\"\")","v":""},null,{"$f":"IF(AND($E$42=3,K164=0),\"\",IF(AND($E$42=3,K164>0),K164,IF(AND($E$42=2,H164=0),\"\",IF(AND($E$42=2,H164>0),H164))))","v":""},null,null,"If tax-exempt bonds are part of the construction financing, this line item cannot have any costs in the first column."]
[]
[null,null,null,"Bridge Loan Origination/"]
[null,null,null,null,"Commitment Fee(s)",null,null,null,null,null,null,{"$f":"IF(N(K167)<>ROUNDDOWN(N(K167),0),1,\"\")","v":""},null,{"$f":"IF(H167+IF($E$42=3,K167,0)=0,\"\",H167+IF($E$42=3,K167,0))","v":""}]
[]
[null,null,null,"Bridge Loan Interest",null,null,null,null,null,null,null,{"$f":"IF(N(K169)<>ROUNDDOWN(N(K169),0),1,\"\")","v":""},null,{"$f":"IF(H169+IF($E$42=3,K169,0)=0,\"\",H169+IF($E$42=3,K169,0))","v":""}]
[]
[null,null,null,"*Other (explain in detail)",null,null,null,null,null,null,null,{"$f":"IF(N(K171)<>ROUNDDOWN(N(K171),0),1,\"\")","v":""},null,{"$f":"IF(H171+IF($E$42=3,K171,0)=0,\"\",H171+IF($E$42=3,K171,0))","v":""},null,null,"Some items placed in this general category should be classified as ineligible basis.* Examples include syndication fees, credit underwriting of a tax-exempt bond, bond issuance costs.*"]
[]
[null,"A3.","TOTAL FINANCIAL COSTS",null,null,null,"$",{"$f":"IF(SUM(H148:H171)=0,\"\",SUM(H148:H171))","v":""},null,"$",{"$f":"IF(SUM(K148:K171)=0,\"\",SUM(K148:K171))","v":""},null,"$",{"$f":"IF(N(H173)+IF($E$42=3,N(K173),0)=0,\"\",N(H173)+IF($E$42=3,N(K173),0))","v":""}]
[]
[null,null,"ACQUISITION COST OF EXISTING"]
[null,null,"DEVELOPMENT (excluding land)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"The amount to be recognized for the allocation of the purchase price of the building cannot exceed the appraised value of the enitre proposed property, less the land allocation.  Do not include any related acquisition costs on this line.*\"","v":"The amount to be recognized for the allocation of the purchase price of the building cannot exceed the appraised value of the enitre proposed property, less the land allocation.  Do not include any related acquisition costs on this line.*"}]
[null,null,null,"Existing Building(s)",null,null,null,null,null,null,null,{"$f":"IF(N(K177)<>ROUNDDOWN(N(K177),0),1,\"\")","v":""},null,{"$f":"IF(H177+IF($E$42=3,K177,0)=0,\"\",H177+IF($E$42=3,K177,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include a pro rata share of any acquisition brokerage fees of Applicant within 'Other'.  Other activities performed by a broker for the Applicant may be considered as consulting fees.  May not include any seller costs.  Rule Chapter 67-48, F.A.C. provides limits.  Land portion is ineligible basis and should be included within 'F. Total Land Costs.'*"]
[null,null,null,"*Other (explain in detail)",null,null,null,null,null,null,null,{"$f":"IF(N(K179)<>ROUNDDOWN(N(K179),0),1,\"\")","v":""},null,{"$f":"IF(H179+IF($E$42=3,K179,0)=0,\"\",H179+IF($E$42=3,K179,0))","v":""}]
[]
[null,"B.","TOTAL ACQUISITION COSTS OF EXISTING",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"The amount to be recognized for the allocation of the purchase price of the building cannot exceed the \"\"as is\"\" appraised value of the enitre proposed property, less the land allocation.*\"","v":"The amount to be recognized for the allocation of the purchase price of the building cannot exceed the \"as is\" appraised value of the enitre proposed property, less the land allocation.*"}]
[null,null,"DEVELOPMENT (excluding land)",null,null,null,"$",{"$f":"IF(SUM(H177:H180)=0,\"\",SUM(H177:H180))","v":""},null,"$",{"$f":"IF(SUM(K177:K180)=0,\"\",SUM(K177:K180))","v":""},null,"$",{"$f":"IF(N(H182)+IF($E$42=3,N(K182),0)=0,\"\",N(H182)+IF($E$42=3,N(K182),0))","v":""}]
[]
[null,"C.","DEVELOPMENT COST ",null,null,null,"$",{"$f":"IF(SUM(H71,H73,H137,H139,H173,H182)=0,\"\",SUM(H71,H73,H137,H139,H173,H182))","v":""},null,"$",{"$f":"IF(SUM(K71,K73,K137,K139,K173,K182)=0,\"\",SUM(K71,K73,K137,K139,K173,K182))","v":""},null,"$",{"$f":"IF(SUM(N71,N73,N137,N139,N173,N182)=0,\"\",SUM(N71,N73,N137,N139,N173,N182))","v":""}]
[null,null,null,"(A1.3+A1.4+A2.1+A2.2+A3+B)"]
[]
[null,null,"Developer Fee See Note (1)",null,null,null,null,null,null,null,null,null,null,null,null,null,"The Developer Fee on Acquisition or Non-Acquisition Costs cannot exceed the maximum developer fee percentage of the relative qualifying costs:"]
[null,null,null,"Developer Fee on Acquisition Costs",null,null,null,null,null,null,null,{"$f":"IF(N(K188)<>ROUNDDOWN(N(K188),0),1,\"\")","v":""},null,{"$f":"IF($E$42=2,IF(OR(N(Developer_fee_acq_eligible)=0,N(Developer_fee_acq_eligible)>N(Dev_Fee_Max_Acq)),N(Dev_Fee_Max_Acq),IF(N(Developer_fee_non_acq_eligible)>N(Dev_Fee_Max_Non_Acq),MIN(N(Dev_Fee_Max_Acq),SUM(N(Developer_fee_acq_eligible),N(Developer_fee_non_acq_eligible)))-N(Dev_Fee_Max_Non_Acq),N(Developer_fee_acq_eligible))),IF(OR(SUM(N(Developer_fee_acq_eligible),N(Developer_fee_acq_ineligible))=0,SUM(N(Developer_fee_acq_eligible),N(Developer_fee_acq_ineligible))>N(Dev_Fee_Max_Acq)),N(Dev_Fee_Max_Acq),IF(SUM(N(Developer_fee_non_acq_eligible),N(Developer_fee_non_acq_ineligible))>N(Dev_Fee_Max_Non_Acq),MIN(N(Dev_Fee_Max_Acq),SUM(N(Developer_fee_acq_eligible),N(Developer_fee_acq_ineligible),N(Developer_fee_non_acq_eligible),N(Developer_fee_non_acq_ineligible))-N(Dev_Fee_Max_Non_Acq)),SUM(N(Developer_fee_acq_eligible),N(Developer_fee_acq_ineligible)))))","v":0},null,{"$f":"IF(P189=\"No\",\"**\",\"\")","v":""},{"$f":"IF(P189=\"No\",\"Because the amount for 'Developer Fee on Acquisition Costs' is too high by \"&TEXT(SUM(N(Developer_fee_acq_eligible),N(Developer_fee_acq_ineligible))-N(Dev_Fee_Max_Acq),\"$#,##0.00\")&\", the maximum Total Developer Fee on Acquisition Costs of \"&TEXT(N(Dev_Fee_Max_Acq),\"$#,##0.00\")&\" has been utilized. Any excess fee has been applied to the Total Developer Fee on Non-Acquisition Costs to the extent allowable.\",\"\")","v":""}]
[null,null,null,{"$f":"\"Max DF @ \"&TEXT(DS_MaxDevFeeAcq_Percent,\"#0%\")&\":\"","v":"Max DF @ 0%:"},null,{"$f":"ROUNDDOWN(N(DS_MaxDevFeeAcq_Percent)*N(Acquisition_total),0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N(Acquisition_total)>0,N(Developer_fee_acq_total)=0,N(Developer_fee_total)=0),\"No\",IF(SUM(N(Developer_fee_acq_eligible),N(Developer_fee_acq_ineligible))>ROUNDDOWN(N(Acquisition_total)*IF(N(DS_MaxDevFeeAcq_Percent)=21%,16%,N(DS_MaxDevFeeAcq_Percent)),0),\"No\",\"Yes\"))","v":"Yes"}]
[null,null,null,"Developer Fee on Non-Acquisition Costs",null,null,null,null,null,null,null,{"$f":"IF(N(K190)<>ROUNDDOWN(N(K190),0),1,\"\")","v":""},null,{"$f":"IF($E$42=2,IF(OR(N(Developer_fee_non_acq_eligible)=0,N(Developer_fee_non_acq_eligible)>N(Dev_Fee_Max_Non_Acq)),N(Dev_Fee_Max_Non_Acq),IF(N(Developer_fee_acq_eligible)>N(Dev_Fee_Max_Acq),MIN(N(Dev_Fee_Max_Non_Acq),SUM(N(Developer_fee_non_acq_eligible),N(Developer_fee_acq_eligible)))-N(Dev_Fee_Max_Acq),N(Developer_fee_non_acq_eligible))),IF(OR(SUM(N(Developer_fee_non_acq_eligible),N(Developer_fee_non_acq_ineligible))=0,SUM(N(Developer_fee_non_acq_eligible),N(Developer_fee_non_acq_ineligible))>N(Dev_Fee_Max_Non_Acq)),N(Dev_Fee_Max_Non_Acq),IF(SUM(N(Developer_fee_acq_eligible),N(Developer_fee_acq_ineligible))>N(Dev_Fee_Max_Acq),MIN(N(Dev_Fee_Max_Non_Acq),SUM(N(Developer_fee_non_acq_eligible),N(Developer_fee_non_acq_ineligible),N(Developer_fee_acq_eligible),N(Developer_fee_acq_ineligible))-N(Dev_Fee_Max_Acq)),SUM(N(Developer_fee_non_acq_eligible),N(Developer_fee_non_acq_ineligible)))))","v":0},null,{"$f":"IF(P191=\"No\",\"**\",\"\")","v":""},{"$f":"IF(P191=\"No\",\"Because the amount for 'Developer Fee on Non-Acquisition Costs' is too high by \"&TEXT(SUM(N(Developer_fee_non_acq_eligible),N(Developer_fee_non_acq_ineligible))-N(Dev_Fee_Max_Non_Acq),\"$#,##0.00\")&\", the maximum Total Developer Fee on Non-Acquisition Costs of \"&TEXT(N(Dev_Fee_Max_Non_Acq),\"$#,##0.00\")&\" has been utilized. Any excess fee has been applied to the Total Developer Fee on Acquisition Costs to the extent allowable.\",\"\")","v":""}]
[null,null,null,{"$f":"\"Max DF @ \"&TEXT(DS_MaxDevFeeNonAcq_Percent,\"#0%\")&\":\"","v":"Max DF @ 0%:"},null,{"$f":"ROUNDDOWN(N(DS_MaxDevFeeNonAcq_Percent)*(N(Development_Cost_total)-N(Acquisition_total)),0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(SUM(N(Developer_fee_non_acq_eligible),N(Developer_fee_non_acq_ineligible))>ROUNDDOWN((N(Development_Cost_total)-N(Acquisition_total))*IF(N(DS_MaxDevFeeNonAcq_Percent)=21%,16%,N(DS_MaxDevFeeNonAcq_Percent)),0),AND(N(Development_Cost_total)-N(Acquisition_total)>0,N(Developer_fee_non_acq_total)=0,N(Developer_fee_total)=0)),\"No\",\"Yes\")","v":"Yes"}]
[null,null,null,"Additional 5% Developer Fee for the RFA's"]
[null,null,null,"designated Demographic Commitment",null,null,null,{"$f":"IF(N(Dev_Fee_Max_Demo)=0,\"\",N(Dev_Fee_Max_Demo))","v":""},null,null,null,null,null,{"$f":"IF(N(Dev_Fee_Max_Demo)=0,\"\",MIN(N(Dev_Fee_Max_Demo),N(H193)))","v":""},null,null,{"$f":"IF((Funding!U167+Funding!U169)=21%,\"If the Max. Dev. Fee is 21%, the 5% demographic-based portion will be automatically entered on this row and is considered to be in addition to the amount(s) listed on the other 16% Developer Fee line item(s).\",\"\")","v":""}]
[null,null,null,{"$f":"\"Max DF @ \"&TEXT(DS_MaxDevFeeDemographic_Percent,\"#0%\")&\":\"","v":"Max DF @ 0%:"},null,{"$f":"ROUNDDOWN(N(DS_MaxDevFeeDemographic_Percent)*N(Development_Cost_total),0)","v":0}]
[null,"D.","TOTAL DEVELOPER FEE",null,null,null,"$",{"$f":"IF(SUM(H188:H193)=0,\"\",SUM(H188:H193))","v":""},null,"$",{"$f":"IF(SUM(K188:K193)=0,\"\",SUM(K188:K193))","v":""},null,"$",{"$f":"IF($E$42=2,IF(OR(N(Developer_fee_eligible)=0,N(Developer_fee_eligible)>N(Dev_Fee_Max_Total),SUM(N(Developer_fee_acq_total),N(Developer_fee_non_acq_total))>N(Dev_Fee_Max_Total)),N(Dev_Fee_Max_Total),SUM(N(Developer_fee_acq_total),N(Developer_fee_non_acq_total))),IF(SUM(N(Developer_fee_eligible),N(Developer_fee_ineligible))=0,Dev_Fee_Max_Total,IF(SUM(N(Developer_fee_eligible),N(Developer_fee_ineligible))>N(Dev_Fee_Max_Total),N(Dev_Fee_Max_Total),SUM(N(Developer_fee_acq_total),N(Developer_fee_non_acq_total),N(Developer_fee_demo)))))","v":0},null,{"$f":"IF(P196=\"No\",\"**\",\"\")","v":""},{"$f":"IF(P196=\"No\",IF(AND(N(Development_Cost_total)>0,SUM(N(Developer_fee_eligible),N(Developer_fee_ineligible))=0),\"A Developer fee must be entered. If it is not, the maximum Total Developer Fee of \"&TEXT(N(Dev_Fee_Max_Total),\"$#,##0.00\")&\" will be utilized. This will impact cost totals below.\",IF(SUM(N(Developer_fee_eligible),N(Developer_fee_ineligible))>N(Dev_Fee_Max_Total),\"Because the resulting 'Total Developer Fee' is too high by \"&TEXT(SUM(N(Developer_fee_eligible),N(Developer_fee_ineligible))-N(Dev_Fee_Max_Total),\"$#,##0.00\")&\", the maximum Total Developer Fee of \"&TEXT(N(Dev_Fee_Max_Total),\"$#,##0.00\")&\" has been utilized. This will impact the Total Development Cost.\",\"\")),\"\")","v":""}]
[null,null,null,"Max Total DF:",null,{"$f":"IF(SUM(N(Dev_Fee_Max_Acq),N(Dev_Fee_Max_Non_Acq),N(Dev_Fee_Max_Demo))=0,\"\",SUM(N(Dev_Fee_Max_Acq),N(Dev_Fee_Max_Non_Acq),N(Dev_Fee_Max_Demo)))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(SUM(N(Developer_fee_eligible),N(Developer_fee_ineligible))=0,N(Development_Cost_total)>0),SUM(N(Developer_fee_eligible),N(Developer_fee_ineligible))>Dev_Fee_Max_Total),\"No\",\"Yes\")","v":"Yes"}]
[null,"E.","OPERATING DEFICIT RESERVES See Note (1)",null,null,null,"$",null,null,"$",null,null,"$",{"$f":"IF($E$42=3,IF(N(ODR_ineligible)=0,\"\",IF(N(ODR_ineligible)>N(ODR_Max),N(ODR_Max),N(ODR_ineligible))),\"\")","v":""},null,{"$f":"IF(P198=\"No\",\"**\",\"\")","v":""},{"$f":"IF(N(ODR_Max)=0,\"\",IF(P198=\"No\",\"Because the amount entered for 'Operating Deficit Reserves' is too high by \"&TEXT(SUM(N(ODR_eligible),N(ODR_ineligible))-N(ODR_Max),\"$#,##0.00\")&\", the maximum Total Operating Deficit Reserve of \"&TEXT(N(ODR_Max),\"$#,##0.00\")&\" has been utilized. This will impact the Total Development Cost.\",\"\"))","v":""}]
[null,null,null,"Max ODR:",null,{"$f":"ROUNDDOWN(N(DS_Max_ODR)*N(Development_Cost_total),0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N(ODR_eligible),N(ODR_ineligible))<=N(ODR_Max),\"Yes\",\"No\")","v":"Yes"}]
[null,"F.","TOTAL LAND COST",null,null,null,"$",null,null,"$",null,{"$f":"IF(N(K199)<>ROUNDDOWN(N(K199),0),1,\"\")","v":""},"$",{"$f":"IF(AND($E$42=3,K199=0),\"\",IF(AND($E$42=3,K199>0),K199,IF(AND($E$42=2,H199=0),\"\",IF(AND($E$42=2,H199>0),H199))))","v":""},null,null,{"$f":"\"The amount to be recognized for the \"&IF(N(N182)>0,\"allocation of \",\"\")&\"the purchase price of the land cannot exceed the \"\"as is\"\" appraised value.  Include a prorata share of any acquisition brokerage fees.  See note above under Acquisition Costs of Existing Development for additional direction.* \"","v":"The amount to be recognized for the the purchase price of the land cannot exceed the \"as is\" appraised value.  Include a prorata share of any acquisition brokerage fees.  See note above under Acquisition Costs of Existing Development for additional direction.* "}]
[]
[null,"G.","TOTAL DEVELOPMENT COST See Note (4)",null,null,null,"$",{"$f":"IF(SUM(H184,H195,H197,H199)=0,\"\",SUM(H184,H195,H197,H199))","v":""},null,"$",{"$f":"IF(SUM(K184,K195,K197,K199)=0,\"\",SUM(K184,K195,K197,K199))","v":""},null,"$",{"$f":"IF(SUM(N184,N195,N197,N199)=0,\"\",SUM(N184,N195,N197,N199))","v":""}]
[null,null,null,"(C+D+E+F)"]
[]
[]
[null,{"$f":"B$2","v":"RFA 2023-211 DEVELOPMENT COST PRO FORMA"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(Page 4 of 6)\"","v":"(Page 4 of 6)"}]
[]
[null,"Detail/Explanation Sheet"]
[]
[null,"Totals must agree with Pro Forma.  Provide component descriptions and amounts for each item that has been "]
[null,"completed on the Pro Forma that requires a detailed list or explanation."]
[]
[null,"DEVELOPMENT COSTS"]
[]
[null,null,"Actual Construction Cost"]
[null,null,"(as listed at Item A1.)"]
[]
[null,null,null,"Off-Site Work:  ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F217=\"\",N53<>\"\"),\"**\",\"\")","v":""}]
[]
[]
[]
[null,null,null,"Other:  ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F221=\"\",N63<>\"\"),\"**\",\"\")","v":""}]
[]
[]
[]
[null,null,"General Development Costs"]
[null,null,"(as listed at Item A2.)"]
[]
[null,null,null,"Impact Fees:  ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F228=\"\",N110<>\"\"),\"**\",\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,null,"Other:  ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F234=\"\",N134<>\"\"),\"**\",\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,"Financial Costs"]
[null,null,"(as listed at Item A3.)"]
[]
[null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F243=\"\",N171<>\"\"),\"**\",\"\")","v":""}]
[]
[]
[]
[null,null,"Acquisition Cost of Existing Developments"]
[null,null,"(as listed at Item B2. )"]
[]
[null,null,null,"Other:  ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F250=\"\",N179<>\"\"),\"**\",\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Some Suggestive Assistance\nThe criteria below attempts to help the user to know the maximum limits of the restricted funding sources, when possible.  FHFC is not responsible for any programming errors related to the assistance offered below.  Applicant is responsible to verify all inputs to RFA criteria."]
[null,{"$f":"B$2","v":"RFA 2023-211 DEVELOPMENT COST PRO FORMA"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(Page 5 of 6)\"","v":"(Page 5 of 6)"}]
[]
[]
[null,"CONSTRUCTION/REHAB ANALYSIS"]
[null,null,null,null,null,null,null,"AMOUNT",null,null,"LENDER/TYPE OF FUNDS"]
[]
[null,"A.","Total Development Costs",null,null,null,"$",{"$f":"IF(N201=\"\",\"\",N201)","v":""}]
[]
[null,"B.","Construction Funding Sources:",null,null,null,null,null,null,null,null,null,null,null,null,null,"$ Per Unit"]
[]
[null,{"$f":"MAX(B$265:B265)+1","v":1},"First Mortgage Financing",null,null,null,"$",null,null,null,"FHFC - MMRB",null,null,null,null,{"$f":"IF(OR(AND(N(MMRB_Request_Amount)>0,N(Non_Competitive_HC_Request_Amount)>0,ConstrAnalysis__1st_Type<>\"FHFC - MMRB\",ConstrAnalysis__1st_Type<>\"Local HFA Bonds\"),AND(N(MMRB_Request_Amount)>0,ConstrAnalysis__1st_Type=\"FHFC - MMRB\",ConstrAnalysis__1st_Mtg<>MMRB_Request_Amount),AND(N(ConstrAnalysis__1st_Mtg)>0,ConstrAnalysis__1st_Type=\"<select from menu>\")),\"**\",\"\")","v":""},{"$f":"IF(N(K$39)=0,0,N(H266)/K$39)","v":0},{"$f":"IF(AND(N(MMRB_Request_Amount)>0,N(Non_Competitive_HC_Request_Amount)>0,ConstrAnalysis__1st_Type<>\"FHFC - MMRB\",ConstrAnalysis__1st_Type<>\"Local HFA Bonds\"),\"The Applicant indicates a Non-Competetive Housing Credit Request amount. Please designate the First Mortgage Financing as FHFC - MMRB or Local HFA Bonds as applicable.\",IF(AND(N(MMRB_Request_Amount)>0,ConstrAnalysis__1st_Type=\"FHFC - MMRB\",ConstrAnalysis__1st_Mtg<>MMRB_Request_Amount),\"The First Mortgage Finacing amount entered does not match the Corporation-Issued MMRB Loan Request Amount on the Funding Tab.\",IF(AND(N(MMRB_Request_Amount)>0,ConstrAnalysis__1st_Type<>\"FHFC - MMRB\",N(MMRB_Request_Amount)>0),\"An MMRB Loan Request Amount has been provided on the Funding Tab but the Lender/Type of Funds does not identify as such for the First Mortgage Financing in the Construction Funding Sources.\", \"\")))","v":""}]
[]
[null,{"$f":"MAX(B$265:B267)+1","v":2},"Second Mortgage Financing",null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H268)/K$39)","v":0}]
[]
[null,{"$f":"MAX(B$265:B269)+1","v":3},"Third Mortgage Financing",null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H270)/K$39)","v":0}]
[]
[null,{"$f":"MAX(B$265:B271)+1","v":4},"Fourth Mortgage Financing",null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H272)/K$39)","v":0}]
[]
[null,{"$f":"MAX(B$265:B273)+1","v":5},"Fifth Mortgage Financing",null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H274)/K$39)","v":0}]
[]
[null,{"$f":"MAX(B$265:B275)+1","v":6},"Sixth Mortgage Financing",null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H276)/K$39)","v":0}]
[]
[null,{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_1_Name)=\"\",\"\",MAX(B$265:B277)+1)","v":""},{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(DS_FHFC_Source_1_Name)=\"\",\"\",DS_FHFC_Source_1_Name))&\" Financing\"","v":" Financing"},null,null,null,"$",{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_1_Name)=\"\",\"\",MIN(N(DS_FHFC_Source_1_Amt),N(DS_FHFC_Source_1_Max_Amt)))","v":""},null,null,{"$f":"_xlfn.SINGLE(DS_FHFC_Source_1_Label)","v":"Enter request on Funding Tab"},null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H278)/K$39)","v":0}]
[]
[null,{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_2_Name)=\"\",\"\",MAX(B$265:B279)+1)","v":""},{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(DS_FHFC_Source_2_Name)=\"\",\"\",DS_FHFC_Source_2_Name))&\" Financing\"","v":" Financing"},null,null,null,"$",{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_2_Name)=\"\",\"\",MIN(N(DS_FHFC_Source_2_Amt),N(DS_FHFC_Source_2_Max_Amt)))","v":""},null,null,{"$f":"_xlfn.SINGLE(DS_FHFC_Source_2_Label)","v":"Enter request on Funding Tab"},null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H280)/K$39)","v":0}]
[]
[null,{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_3_Name)=\"\",\"\",MAX(B$265:B281)+1)","v":""},{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(DS_FHFC_Source_3_Name)=\"\",\"\",DS_FHFC_Source_3_Name))&\" Financing\"","v":" Financing"},null,null,null,"$",{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_3_Name)=\"\",\"\",MIN(N(DS_FHFC_Source_3_Amt),N(DS_FHFC_Source_3_Max_Amt)))","v":""},null,null,{"$f":"_xlfn.SINGLE(DS_FHFC_Source_3_Label)","v":"Enter request on Funding Tab"},null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H282)/K$39)","v":0}]
[]
[null,{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_4_Name)=\"\",\"\",MAX(B$265:B283)+1)","v":""},{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(DS_FHFC_Source_4_Name)=\"\",\"\",DS_FHFC_Source_4_Name))&\" Financing\"","v":" Financing"},null,null,null,"$",{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_4_Name)=\"\",\"\",MIN(N(DS_FHFC_Source_4_Amt),N(DS_FHFC_Source_4_Max_Amt)))","v":""},null,null,{"$f":"_xlfn.SINGLE(DS_FHFC_Source_4_Label)","v":"Enter request on Funding Tab"},null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H284)/K$39)","v":0}]
[]
[null,{"$f":"MAX(B$265:B285)+1","v":7},"HC Equity Proceeds Paid Prior to"]
[null,null,"Completion of Construction which"]
[null,null,"is Prior to Receipt of Final Certificate"]
[null,null,"of Occupancy or in the case of "]
[null,null,"Rehabilitation, prior to placed-in"]
[null,null,"service date as determined by the "]
[null,null,"Applicant.",null,null,null,"$",null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(_xlfn.SINGLE(Competitive_HC_Request_Amount)>0,_xlfn.SINGLE(Non_Competitive_HC_Request_Amount)>0),ConstrAnalysis_HC=0),\"**\",\"\")","v":""},{"$f":"IF(N(K$39)=0,0,N(H292)/K$39)","v":0},"The Applicant has entered a Housing Credit Request Amount on the Funding Tab. Please state the amount of HC Equity Proceeds Paid Prior to Completion of Construction."]
[]
[null,{"$f":"MAX(B$265:B293)+1","v":8},"Other:",null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H294)/K$39)","v":0}]
[]
[null,{"$f":"MAX(B$265:B295)+1","v":9},"Other:",null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H296)/K$39)","v":0}]
[]
[null,{"$f":"MAX(B$265:B297)+1","v":10},{"$f":"\"Deferred Developer Fee (\"&TEXT(N(ConstrAnalysis_deferredfee)/(N(Developer_fee_total)-N(Developer_fee_demo)),\"0.0%\")&\")\"","v":{"$error":"#DIV/0!"}},null,null,null,"$",{"$f":"MAX(30%*(N(Developer_fee_total)-N(Developer_fee_demo)),MIN(N(TDC_total)-SUM(H266:H296),N(Developer_fee_total)-N(Developer_fee_demo)))","v":0},null,null,{"$f":"IF(N(ConstrAnalysis_deferredfee)>0,\"The RFA Minimum is 30%.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H298)/K$39)","v":0},{"$f":"IF(ConstrAnalysis_deferredfee>Developer_fee_total,\"The Deferred Developer Fee is greater than than the Total Developer Fee.\",\"\")","v":""}]
[null,null,null,{"$f":"\"30% DDF: \"&TEXT(30%*(N(Developer_fee_total)-N(Developer_fee_demo)),\"$#,##0.00\")","v":"30% DDF: $0.00"}]
[null,{"$f":"MAX(B$265:B299)+1","v":11},"Total Construction Sources",null,null,null,"$",{"$f":"IF(SUM(H265:H299)<1,\"\",SUM(H265:H299))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H300)/K$39)","v":0}]
[]
[null,"C.","Construction Funding Surplus"]
[null,null,null,{"$f":"\"(B.\"&TEXT(B300,\"0\")&\". \"&C300&\", \"","v":"(B.11. Total Construction Sources, "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N(H304)<0,\"**\",\"\")","v":""}]
[null,null,null,{"$f":"\" less \"&B262&\" \"&C262&\"):\"","v":" less A. Total Development Costs):"},null,null,"$",{"$f":"IF(AND(N(H300)=0,N(H262)=0),\"\",N(H300)-N(H262))","v":""},null,"(A negative number here represents a funding shortfall.)",null,null,null,null,null,null,{"$f":"IF(N(H304)=0,\"Construction Funding Sources are equal to Total Development Costs.\",IF(N(H304)<0,\"There is a shortfall in Construction Funding Sources which must be corrected.\",\"There is a surplus of Construction Funding Sources which is permitted at time of Application. Final Viability will be sized in Credit Underwriting and Final Cost Cert (when applicable)\"))","v":"Construction Funding Sources are equal to Total Development Costs."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Met Construction Financing Threshold for sources equal or exceed uses:",{"$f":"IF(ConstrAnalysis_surplus=\"\",\"\",IF(ConstrAnalysis_surplus>=0,\"Yes\",\"No\"))","v":""}]
[]
[null,"Each Attachment must be listed behind its own Tab.  DO NOT INCLUDE ALL ATTACHMENTS BEHIND ONE TAB."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Some Suggestive Assistance\nThe criteria below attempts to help the user to know the maximum limits of the restricted funding sources, when possible.  FHFC is not responsible for any programming errors related to the assistance offered below.  Applicant is responsible to verify all inputs to RFA criteria."]
[null,{"$f":"B$2","v":"RFA 2023-211 DEVELOPMENT COST PRO FORMA"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(Page 6 of 6)\"","v":"(Page 6 of 6)"}]
[]
[]
[null,"PERMANENT ANALYSIS"]
[null,null,null,null,null,null,null,"AMOUNT",null,null,"LENDER/TYPE OF FUNDS"]
[]
[null,"A.","Total Development Costs",null,null,null,"$",{"$f":"IF(N201=\"\",\"\",N201)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash"]
[null,"B.","Permanent Funding Sources:",null,null,null,null,null,null,null,null,null,null,null,null,"Funding?","$ Per Unit"]
[]
[null,{"$f":"MAX(B$319:B319)+1","v":1},{"$f":"C266","v":"First Mortgage Financing"},null,null,null,"$",null,null,null,"Local Government Subsidy",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H320)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis__1st_Type)),PermAnalysis__1st_Mtg,0)","v":0}]
[]
[null,{"$f":"MAX(B$319:B321)+1","v":2},{"$f":"C268","v":"Second Mortgage Financing"},null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H322)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis__2nd_Type)),PermAnalysis__2nd_Mtg,0)","v":0}]
[]
[null,{"$f":"MAX(B$319:B323)+1","v":3},{"$f":"C270","v":"Third Mortgage Financing"},null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H324)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis__3rd_Type)),PermAnalysis__3rd_Mtg,0)","v":0}]
[]
[null,{"$f":"MAX(B$319:B325)+1","v":4},{"$f":"C272","v":"Fourth Mortgage Financing"},null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H326)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis__4th_Type)),PermAnalysis__4th_Mtg,0)","v":0}]
[]
[null,{"$f":"MAX(B$319:B327)+1","v":5},{"$f":"C274","v":"Fifth Mortgage Financing"},null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H328)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis__5th_Type)),PermAnalysis__5th_Mtg,0)","v":0}]
[]
[null,{"$f":"MAX(B$319:B329)+1","v":6},{"$f":"C276","v":"Sixth Mortgage Financing"},null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H330)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis__6th_Type)),PermAnalysis__6th_Mtg,0)","v":0}]
[]
[null,{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_1_Name)=\"\",\"\",MAX(B$319:B331)+1)","v":""},{"$f":"C278","v":" Financing"},null,null,null,"$",{"$f":"ConstrAnalysis__7th_Mtg","v":""},null,null,{"$f":"ConstrAnalysis__7th_Type","v":"Enter request on Funding Tab"},null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H332)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis__7th_Type)),PermAnalysis__7th_Mtg,0)","v":""}]
[]
[null,{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_2_Name)=\"\",\"\",MAX(B$319:B333)+1)","v":""},{"$f":"C280","v":" Financing"},null,null,null,"$",{"$f":"ConstrAnalysis__8th_Mtg","v":""},null,null,{"$f":"ConstrAnalysis__8th_Type","v":"Enter request on Funding Tab"},null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H334)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis__8th_Type)),PermAnalysis__8th_Mtg,0)","v":""}]
[]
[null,{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_3_Name)=\"\",\"\",MAX(B$319:B335)+1)","v":""},{"$f":"C282","v":" Financing"},null,null,null,"$",{"$f":"ConstrAnalysis__9th_Mtg","v":""},null,null,{"$f":"ConstrAnalysis__9th_Type","v":"Enter request on Funding Tab"},null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H336)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis__9th_Type)),PermAnalysis__9th_Mtg,0)","v":""}]
[]
[null,{"$f":"IF(_xlfn.SINGLE(DS_FHFC_Source_4_Name)=\"\",\"\",MAX(B$319:B337)+1)","v":""},{"$f":"C284","v":" Financing"},null,null,null,"$",{"$f":"ConstrAnalysis_10th_Mtg","v":""},null,null,{"$f":"ConstrAnalysis_10th_Type","v":"Enter request on Funding Tab"},null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H338)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis_10th_Type)),PermAnalysis_10th_Mtg,0)","v":""}]
[]
[null,{"$f":"MAX(B$319:B339)+1","v":7},"HC Syndication/HC Equity Proceeds",null,null,null,"$",null,null,null,null,null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H340)/K$39)","v":0},"The Applicant has entered a Housing Credit Request Amount on the Funding Tab. Please state the amount of HC Syndication/HC Equity Proceeds."]
[]
[null,{"$f":"MAX(B$319:B341)+1","v":8},"Other:",null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H342)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis_Other_1_Type)),PermAnalysis_other1,0)","v":0}]
[]
[null,{"$f":"MAX(B$319:B343)+1","v":9},"Other:",null,null,null,"$",null,null,null,"<select from menu>",null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H344)/K$39)","v":0},null,null,null,null,null,null,{"$f":"IF(ISERROR(SEARCH(\"Deferred Development Costs\",PermAnalysis_Other_2_Type)),PermAnalysis_other2,0)","v":0}]
[]
[null,{"$f":"MAX(B$319:B345)+1","v":10},"Deferred Developer Fee",null,null,null,"$",{"$f":"MAX(30%*(N(Developer_fee_total)-N(Developer_fee_demo)),MIN(N(TDC_total)-SUM(H320:H344),N(Developer_fee_total)-N(Developer_fee_demo)))","v":0},null,null,{"$f":"IF(N(ConstrAnalysis_deferredfee)>0,\"The RFA Minimum is 30%.\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H346)/K$39)","v":0},{"$f":"IF(PermAnalysis_deferredfee>Developer_fee_total,\"The Deferred Developer Fee is greater than than the Total Developer Fee.\",\"\")","v":""}]
[null,null,null,{"$f":"\"30% DDF: \"&TEXT(30%*(N(Developer_fee_total)-N(Developer_fee_demo)),\"$#,##0.00\")","v":"30% DDF: $0.00"}]
[null,{"$f":"MAX(B$319:B347)+1","v":11},"Total Permanent Funding Sources",null,null,null,"$",{"$f":"IF(SUM(H319:H347)<1,\"\",SUM(H319:H347))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(N(K$39)=0,0,N(H348)/K$39)","v":0},null,null,null,null,null,null,{"$f":"SUM(X320:X344)","v":0}]
[]
[null,"C.","Permanent Funding Surplus"]
[null,null,null,{"$f":"\"(B.\"&TEXT(B348,\"0\")&\". \"&C348&\", \"","v":"(B.11. Total Permanent Funding Sources, "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N(H352)<0,\"**\",\"\")","v":""}]
[null,null,null,{"$f":"\" less \"&B316&\" \"&C316&\"):\"","v":" less A. Total Development Costs):"},null,null,"$",{"$f":"IF(AND(N(H348)=0,N(H316)=0),\"\",N(H348)-N(H316))","v":""},null,"(A negative number here represents a funding shortfall.)",null,null,null,null,null,null,{"$f":"IF(N(H352)=0,\"Permanent Funding Sources are equal to Total Development Costs.\",IF(N(H352)<0,\"There is a shortfall in Permanent Funding Sources which must be corrected.\",\"There is a surplus of Permanent Funding Sources which is permitted at time of Application. Final Viability will be sized in Credit Underwriting and Final Cost Cert (when applicable)\"))","v":"Permanent Funding Sources are equal to Total Development Costs."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Met Permanent Financing Threshold for sources equal or exceed uses:",{"$f":"IF(PermAnalysis_surplus=\"\",\"\",IF(PermAnalysis_surplus>=0,\"Yes\",\"No\"))","v":""}]
[]
[null,"Each Attachment must be listed behind its own Tab.  DO NOT INCLUDE ALL ATTACHMENTS BEHIND ONE TAB."]
[]
[null,{"$f":"B$2","v":"RFA 2023-211 DEVELOPMENT COST PRO FORMA"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N(Non_Competitive_HC_Request_Amount)>0,$P$422>0,#REF!=\"No\"),\"(Page 7 of 8)\",IF(#REF!=\"Yes\",\"(NA)\",\"(Page 7 of 7)\"))","v":{"$error":"#REF!"}}]
[]
[null,"The intent of this page is to assist the Applicant in determining a TDC PU Limitation for the proposed Development and comparing it to the appropriate "]
[null,"RFA's TDC PU Limitation. The accuracy of the comparison is dependent upon the accuracy of the inputs and Florida Housing takes no responsibility in "]
[null,"any programing errors. FHFC will not use this page to score TDC PU Limitation criteria.  If FHFC makes any adjustments to the Applicant's data or "]
[null,"assumptions, FHFC's TDC PU for Limitation purposes of the proposed Development or the TDC PU Limitation determined by FHFC may be different than the "]
[null,"amounts provided below. Please read the RFA for qualifying responses and definition of terms. This table is optional and its use is at the sole discretion "]
[null,"of the Applicant. Applicant is responsible to verify and be in compliance with all aspects of the Application to meet RFA criteria."]
[]
[null,"TDC PU LIMITATION ANALYSIS"]
[]
[null,null,"In which county is the proposed Development to be located?...............................................................................",null,null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(IF(_xlfn.SINGLE(County)=_xlfn.SINGLE(DS_Select_One),\"County input required\",County))","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(K369=\"County input required\",\"\",\"(\"&VLOOKUP(K369,DS_CountyData,2)&\" County)\")","v":{"$error":"#NAME?"}}]
[]
[null,null,null,"Blended Characteristic TDC PU Base Limitation*"]
[null,null,null,"Unit Category, Type, and ESS Designation",null,null,"Unit Count",null,"Maximum TDC PU Limitation",null,null,"Pro Rata Limits"]
[null,null,null,"NC Garden Non-ESS",null,null,{"$f":"IF(AND(Garden_non_ESS_NC_units=0,SiF_Non_ESS_NC_Units=0,Other_Non_ESS_NC_units=0),\"\",Garden_non_ESS_NC_units+SiF_Non_ESS_NC_Units+Other_Non_ESS_NC_units)","v":{"$error":"#NAME?"}},{"$f":"IF(AND(Garden_non_ESS_NC_units=0,SiF_Non_ESS_NC_Units=0,Other_Non_ESS_NC_units=0),\"\",Garden_non_ESS_NC_units+SiF_Non_ESS_NC_Units+Other_Non_ESS_NC_units)","v":{"$error":"#NAME?"}},{"$f":"_xlfn.SINGLE(IF(G373=\"\",\"\",IF(_xlfn.SINGLE(County)=_xlfn.SINGLE(DS_Select_One),\"County input required\",IF(OR(_xlfn.SINGLE(County)=\"Broward\",_xlfn.SINGLE(County)=\"Miami-Dade\",_xlfn.SINGLE(County)=\"Palm Beach\"),DS_SFNCGAW,DS_PFNCGAW))))","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(OR(G$380=\"\",G373=\"\",_xlfn.SINGLE(County)=_xlfn.SINGLE(DS_Select_One)),\"\",G373*I373/G$380)","v":{"$error":"#NAME?"}}]
[null,null,null,"NC Garden ESS",null,null,{"$f":"IF(AND(Garden_ESS_NC_units=0,SiF_ESS_NC_Units=0,Other_ESS_NC_units=0),\"\",Garden_ESS_NC_units+SiF_ESS_NC_Units+Other_ESS_NC_units)","v":{"$error":"#NAME?"}},null,{"$f":"_xlfn.SINGLE(IF(G374=\"\",\"\",IF(_xlfn.SINGLE(County)=_xlfn.SINGLE(DS_Select_One),\"County input required\",IF(OR(_xlfn.SINGLE(County)=\"Broward\",_xlfn.SINGLE(County)=\"Miami-Dade\",_xlfn.SINGLE(County)=\"Palm Beach\"),DS_SFNCGAE,DS_PFNCGAE))))","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
[null,null,null,"NC Mid-Rise Non-ESS",null,null,{"$f":"IF(MR_Non_ESS_NC_units=0,\"\",MR_Non_ESS_NC_units)","v":{"$error":"#NAME?"}},null,{"$f":"_xlfn.SINGLE(IF(G375=\"\",\"\",IF(_xlfn.SINGLE(County)=_xlfn.SINGLE(DS_Select_One),\"County input required\",IF(OR(_xlfn.SINGLE(County)=\"Broward\",_xlfn.SINGLE(County)=\"Miami-Dade\",_xlfn.SINGLE(County)=\"Palm Beach\"),DS_SFNCMRW,DS_PFNCMRW))))","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
[null,null,null,"NC Mid-Rise ESS",null,null,{"$f":"IF(MR_ESS_NC_units=0,\"\",MR_ESS_NC_units)","v":{"$error":"#NAME?"}},null,{"$f":"_xlfn.SINGLE(IF(G376=\"\",\"\",IF(_xlfn.SINGLE(County)=_xlfn.SINGLE(DS_Select_One),\"County input required\",IF(OR(_xlfn.SINGLE(County)=\"Broward\",_xlfn.SINGLE(County)=\"Miami-Dade\",_xlfn.SINGLE(County)=\"Palm Beach\"),DS_SFNCMRE,DS_PFNCMRE))))","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
[null,null,null,"NC High-Rise",null,null,{"$f":"IF(HR_ESS_NC_units=0,\"\",HR_ESS_NC_units)","v":{"$error":"#NAME?"}},null,{"$f":"_xlfn.SINGLE(IF(G377=\"\",\"\",IF(_xlfn.SINGLE(County)=_xlfn.SINGLE(DS_Select_One),\"County input required\",IF(OR(_xlfn.SINGLE(County)=\"Broward\",_xlfn.SINGLE(County)=\"Miami-Dade\",_xlfn.SINGLE(County)=\"Palm Beach\"),DS_SFNCHRE,DS_PFNCHRE))))","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
[null,null,null,"Rehab Garden",null,null,{"$f":"IF(AND(Garden_ESS_Rehab_units=0,Garden_non_ESS_Rehab_units=0,Other_ESS_Rehab_units=0,Other_non_ESS_Rehab_units=0),\"\",Garden_ESS_Rehab_units+Garden_non_ESS_Rehab_units+Other_ESS_Rehab_units+Other_non_ESS_Rehab_units)","v":{"$error":"#NAME?"}},null,{"$f":"_xlfn.SINGLE(IF(G378=\"\",\"\",IF(_xlfn.SINGLE(County)=_xlfn.SINGLE(DS_Select_One),\"County input required\",IF(OR(_xlfn.SINGLE(County)=\"Broward\",_xlfn.SINGLE(County)=\"Miami-Dade\",_xlfn.SINGLE(County)=\"Palm Beach\"),DS_SFRCGA,DS_PFRCGA))))","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
[null,null,null,"Rehab Non-Garden",null,null,{"$f":"IF(AND(MR_and_HR_ESS_Rehab_units=0,MR_and_HR_non_ESS_Rehab_units=0),\"\",MR_and_HR_ESS_Rehab_units+MR_and_HR_non_ESS_Rehab_units)","v":{"$error":"#NAME?"}},null,{"$f":"_xlfn.SINGLE(IF(G379=\"\",\"\",IF(_xlfn.SINGLE(County)=_xlfn.SINGLE(DS_Select_One),\"County input required\",IF(OR(_xlfn.SINGLE(County)=\"Broward\",_xlfn.SINGLE(County)=\"Miami-Dade\",_xlfn.SINGLE(County)=\"Palm Beach\"),DS_SFRCNG,DS_PFRCNG))))","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
[null,null,null,"Total Blended TDC PU Base Limitation",null,null,{"$f":"IF(SUM(G373:G379)>0,SUM(G373:G379),\"\")","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"IF(G380=\"\",\"\",SUM(L373:L379))","v":{"$error":"#NAME?"}}]
[null,null,null,"*For TDC PU Limitation purposes, Garden Apartments include all structure types that are 3 stories or less (Garden Apartments, Single Family Homes, Duplexes, Quadraplexes, and Townhouses)."]
[]
[]
[null,null,"The TDC PU Base Limitation for the above defined Development is………………………………………....",null,null,null,null,null,null,null,null,{"$f":"IF(TDC_Base_Limit=0,\"County input required\",TDC_Base_Limit)","v":{"$error":"#NAME?"}}]
[]
[null,null,"Does the proposed Development qualify for any TDC PU Add-Ons or Multipliers?"]
[]
[null,null,"Applicable Add-On(s):",null,null,null,null,null,null,null,"Add-On","TDC PU Base Limitation"]
[null,null,null,{"$f":"IF(AND(_xlfn.SINGLE(DS_Add_On_1_Y)=1,OR(_xlfn.SINGLE(PHA_land_lease)=\"Yes\",_xlfn.SINGLE(PHA_as_Principal)=\"Yes\")),\"PHA Add-On\",IF(AND(_xlfn.SINGLE(DS_Add_On_1_Y)=1,_xlfn.SINGLE(HOME_Request_Amount)>0),\"Requesting HOME funds from FHFC Add-On\",IF(AND(_xlfn.SINGLE(DS_Add_On_2_Y)=1,_xlfn.SINGLE(Non_Competitive_HC_Request_Amount)>0),\"Tax-Exempt Bond Add-On\",\"No applicable Add-Ons\")))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(IF(AND(_xlfn.SINGLE(DS_Add_On_1_Y)=1,OR(_xlfn.SINGLE(PHA_land_lease)=\"Yes\",_xlfn.SINGLE(PHA_as_Principal)=\"Yes\")),DS_PHA_FED_ADDON,IF(AND(_xlfn.SINGLE(DS_Add_On_1_Y)=1,_xlfn.SINGLE(HOME_Request_Amount)>0),DS_PHA_FED_ADDON,IF(AND(_xlfn.SINGLE(DS_Add_On_2_Y)=1,_xlfn.SINGLE(Non_Competitive_HC_Request_Amount)>0),DS_Bond_ADDON,\"\"))))","v":{"$error":"#NAME?"}},{"$f":"IF(OR($K$369=\"County input required\",N(TDC_Base_Limit)=0),0,IF(N(K389)>0,TDC_Base_Limit+N(K389),TDC_Base_Limit))","v":{"$error":"#NAME?"}}]
[null,null,null,{"$f":"IF(AND(OR($D$389=\"PHA Add-On\",$D$389=\"Requesting HOME funds from FHFC Add-On\",$D$389=\"Requesting CDBG-DR funde from FHFC Add-On\"),_xlfn.SINGLE(DS_Add_On_2_Y)=1,_xlfn.SINGLE(Non_Competitive_HC_Request_Amount)>0),\"Tax-Exempt Bond Add-On\",\"\")","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(IF(AND(_xlfn.SINGLE(DS_Add_On_2_Y)=1,_xlfn.SINGLE(Non_Competitive_HC_Request_Amount)>0,D390=\"Tax-Exempt Bond Add-On\"),DS_Bond_ADDON,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF($K$369=\"County input required\",\"\",IF(N(K390)>0,N(K390)+N(L389),\"\"))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Applicable Multiplier(s):",null,null,null,null,null,null,null,"Multiplier","TDC PU Base Limitation"]
[null,null,null,{"$f":"IF(AND(_xlfn.SINGLE(County)=\"Monroe\",_xlfn.SINGLE(FLKeys_N_S)=\"North Florida Keys Area\"),\"Geographic Multiplier for North Florida Keys Area\",IF(AND(_xlfn.SINGLE(County)=\"Monroe\",_xlfn.SINGLE(FLKeys_N_S)=\"South Florida Keys Area\"),\"Geographic Multiplier for South Florida Keys Area\",IF(AND(_xlfn.SINGLE(DS_Multiplier_5_Y)=1,_xlfn.SINGLE(ConstrFeaturesMultiplier)=\"Yes\"),IF(OR(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\"),\"Non-Geographic Multiplier for Enhanced Construction Features\",\"No applicable Multipliers\"),IF(AND(_xlfn.SINGLE(DS_Multiplier_3_Y)=1,_xlfn.SINGLE(County)<>\"Monroe\",OR(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\"),_xlfn.SINGLE(Total_Units)<51),\"Non-Geographic Multiplier for fewer than 51 Units\",IF(AND(_xlfn.SINGLE(DS_Multiplier_4_Y)=1,_xlfn.SINGLE(County)<>\"Monroe\",OR(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\"),AND(_xlfn.SINGLE(Total_Units)>50,_xlfn.SINGLE(Total_Units)<81)),\"Non-Geographic Multiplier for 51 to 80 Units\",IF(_xlfn.SINGLE(DS_Multiplier_2_Y)=1,IF(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",\"Non-Geographic Multiplier for Persons with Developmental Disabilities\",IF(_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\",\"Non-Geographic Multiplier for Persons with a Disabling Condition\",IF(_xlfn.SINGLE(Demographic)=\"Persons with Special Needs\",\"Non-Geographic Multiplier for Persons with Special Needs\",IF(_xlfn.SINGLE(Demographic)=\"Homeless\",\"Non-Geographic Multiplier for Homeless\",\"No applicable Multipliers\")))),IF(AND(_xlfn.SINGLE(DS_Multiplier_1_Y)=1,_xlfn.SINGLE(Demographic)=\"Elderly ALF\"),\"Non-Geographic Multiplier for Elderly ALF\",\"No applicable Multipliers\")))))))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"IF(OR($K$369=\"County input required\",$D$393=\"No applicable Multipliers\"),\"\",IF($D$393=\"Geographic Multiplier for North Florida Keys Area\",DS_N_Keys_Multiplier,IF($D$393=\"Geographic Multiplier for South Florida Keys Area\",DS_S_Keys_Multiplier,IF($D$393=\"Non-Geographic Multiplier for Persons with Developmental Disabilities\",DS_Demo_Multiplier,IF($D$393=\"Non-Geographic Multiplier for Persons with a Disabling Condition\",DS_Demo_Multiplier,IF($D$393=\"Non-Geographic Multiplier for Enhanced Construction Features\",DS_Constr_Feat_Multiplier,IF($D$393=\"Non-Geographic Multiplier for Persons with Special Needs\",DS_Demo_Multiplier,IF($D$393=\"Non-Geographic Multiplier for Homeless\",DS_Demo_Multiplier,IF($D$393=\"Non-Geographic Multiplier for Elderly ALF\",DS_Elderly_ALF_Multiplier,IF($D$393=\"Non-Geographic Multiplier for fewer than 51 Units\",DS_PDDDC_51_Multiplier,IF($D$393=\"Non-Geographic Multiplier for 51 to 80 Units\",DS_PDDDC_81_Multiplier,\"100%\")))))))))))","v":{"$error":"#NAME?"}},{"$f":"IF($K$369=\"County input required\",0,IF(N(K393)>0,MAX(N(L389),N(L390))/N(K393),MAX(N(L389),N(L390))))","v":{"$error":"#NAME?"}}]
[null,null,null,{"$f":"IF(AND(_xlfn.SINGLE(DS_Multiplier_5_Y)=1,OR(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\"),_xlfn.SINGLE(ConstrFeaturesMultiplier)=\"Yes\",$D$393<>\"Non-Geographic Multiplier for Enhanced Construction Features\"),\"Non-Geographic Multiplier for Enhanced Construction Features\",IF(AND(_xlfn.SINGLE(DS_Multiplier_3_Y)=1,_xlfn.SINGLE(County)<>\"Monroe\",OR(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\"),_xlfn.SINGLE(Total_Units)<51,$D$393<>\"Non-Geographic Multiplier for fewer than 51 Units\"),\"Non-Geographic Multiplier for fewer than 51 Units\",IF(AND(_xlfn.SINGLE(DS_Multiplier_4_Y)=1,_xlfn.SINGLE(County)<>\"Monroe\",OR(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\"),AND(_xlfn.SINGLE(Total_Units)>50,_xlfn.SINGLE(Total_Units)<81),$D$393<>\"Non-Geographic Multiplier for 51 to 80 Units\"),\"Non-Geographic Multiplier for 51 to 80 Units\",IF(_xlfn.SINGLE(DS_Multiplier_2_Y)=1,IF(AND(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",$D$393<>\"Non-Geographic Multiplier for Persons with Developmental Disabilities\"),\"Non-Geographic Multiplier for Persons with Developmental Disabilities\",IF(AND(_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\",$D$393<>\"Non-Geographic Multiplier for Persons with a Disabling Condition\"),\"Non-Geographic Multiplier for Persons with a Disabling Condition\",IF(AND(_xlfn.SINGLE(Demographic)=\"Persons with Special Needs\",$D$393<>\"Non-Geographic Multiplier for Persons with Special Needs\"),\"Non-Geographic Multiplier for Persons with Special Needs\",IF(AND(_xlfn.SINGLE(Demographic)=\"Homeless\",$D$393<>\"Non-Geographic Multiplier for Homeless\"),\"Non-Geographic Multiplier for Homeless\",\"\")))),IF(AND(_xlfn.SINGLE(DS_Multiplier_1_Y)=1,_xlfn.SINGLE(Demographic)=\"Elderly ALF\",$D$393<>\"Non-Geographic Multiplier for Elderly ALF\"),\"Non-Geographic Multiplier for Elderly ALF\",\"\")))))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"IF($K$369=\"County input required\",\"\",IF($D$394=\"Geographic Multiplier for North Florida Keys Area\",DS_N_Keys_Multiplier,IF($D$394=\"Geographic Multiplier for South Florida Keys Area\",DS_S_Keys_Multiplier,IF($D$394=\"Non-Geographic Multiplier for Persons with Developmental Disabilities\",DS_Demo_Multiplier,IF($D$394=\"Non-Geographic Multiplier for Persons with a Disabling Condition\",DS_Demo_Multiplier,IF($D$394=\"Non-Geographic Multiplier for Enhanced Construction Features\",DS_Constr_Feat_Multiplier,IF($D$394=\"Non-Geographic Multiplier for Persons with Special Needs\",DS_Demo_Multiplier,IF($D$394=\"Non-Geographic Multiplier for Homeless\",DS_Demo_Multiplier,IF($D$394=\"Non-Geographic Multiplier for Elderly ALF\",DS_Elderly_ALF_Multiplier,IF($D$394=\"Non-Geographic Multiplier for fewer than 51 Units\",DS_PDDDC_51_Multiplier,IF($D$394=\"Non-Geographic Multiplier for 51 to 80 Units\",DS_PDDDC_81_Multiplier,\"\")))))))))))","v":{"$error":"#NAME?"}},{"$f":"IF($K$369=\"County input required\",\"\",IF(N(K394)>0,N(L393)/N(K394),\"\"))","v":{"$error":"#NAME?"}}]
[null,null,null,{"$f":"IF(AND(_xlfn.SINGLE(DS_Multiplier_5_Y)=1,OR(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\"),_xlfn.SINGLE(ConstrFeaturesMultiplier)=\"Yes\",$D$393<>\"Non-Geographic Multiplier for Enhanced Construction Features\",$D$394<>\"Non-Geographic Multiplier for Enhanced Construction Features\"),\"Non-Geographic Multiplier for Enhanced Construction Features\",IF(AND(_xlfn.SINGLE(DS_Multiplier_3_Y)=1,_xlfn.SINGLE(County)<>\"Monroe\",OR(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\"),_xlfn.SINGLE(Total_Units)<51,$D$393<>\"Non-Geographic Multiplier for fewer than 51 Units\",$D$394<>\"Non-Geographic Multiplier for fewer than 51 Units\"),\"Non-Geographic Multiplier for fewer than 51 Units\",IF(AND(_xlfn.SINGLE(DS_Multiplier_4_Y)=1,_xlfn.SINGLE(County)<>\"Monroe\",OR(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\"),AND(_xlfn.SINGLE(Total_Units)>50,_xlfn.SINGLE(Total_Units)<81),$D$393<>\"Non-Geographic Multiplier for 51 to 80 Units\",$D$394<>\"Non-Geographic Multiplier for 51 to 80 Units\"),\"Non-Geographic Multiplier for 51 to 80 Units\",IF(_xlfn.SINGLE(DS_Multiplier_2_Y)=1,IF(AND(_xlfn.SINGLE(Demographic)=\"Persons with Developmental Disabilities\",$D$393<>\"Non-Geographic Multiplier for Persons with Developmental Disabilities\",$D$394<>\"Non-Geographic Multiplier for Persons with Developmental Disabilities\"),\"Non-Geographic Multiplier for Persons with Developmental Disabilities\",IF(AND(_xlfn.SINGLE(Demographic)=\"Persons with a Disabling Condition\",$D$393<>\"Non-Geographic Multiplier for Persons with a Disabling Condition\",$D$394<>\"Non-Geographic Multiplier for Persons with a Disabling Condition\"),\"Non-Geographic Multiplier for Persons with a Disabling Condition\",IF(AND(_xlfn.SINGLE(Demographic)=\"Persons with Special Needs\",$D$393<>\"Non-Geographic Multiplier for Persons with Special Needs\",$D$394<>\"Non-Geographic Multiplier for Persons with Special Needs\"),\"Non-Geographic Multiplier for Persons with Special Needs\",IF(AND(_xlfn.SINGLE(Demographic)=\"Homeless\",$D$393<>\"Non-Geographic Multiplier for Homeless\",$D$394<>\"Non-Geographic Multiplier for Homeless\"),\"Non-Geographic Multiplier for Homeless\",\"\")))),IF(AND(_xlfn.SINGLE(DS_Multiplier_1_Y)=1,_xlfn.SINGLE(Demographic)=\"Elderly ALF\",$D$393<>\"Non-Geographic Multiplier for Elderly ALF\",$D$394<>\"Non-Geographic Multiplier for Elderly ALF\"),\"Non-Geographic Multiplier for Elderly ALF\",\"\")))))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"IF($K$369=\"County input required\",\"\",IF($D$395=\"Geographic Multiplier for North Florida Keys Area\",DS_N_Keys_Multiplier,IF($D$395=\"Geographic Multiplier for South Florida Keys Area\",DS_S_Keys_Multiplier,IF($D$395=\"Non-Geographic Multiplier for Persons with Developmental Disabilities\",DS_Demo_Multiplier,IF($D$395=\"Non-Geographic Multiplier for Persons with a Disabling Condition\",DS_Demo_Multiplier,IF($D$395=\"Non-Geographic Multiplier for Enhanced Construction Features\",DS_Constr_Feat_Multiplier,IF($D$395=\"Non-Geographic Multiplier for Persons with Special Needs\",DS_Demo_Multiplier,IF($D$395=\"Non-Geographic Multiplier for Homeless\",DS_Demo_Multiplier,IF($D$395=\"Non-Geographic Multiplier for Elderly ALF\",DS_Elderly_ALF_Multiplier,IF($D$395=\"Non-Geographic Multiplier for fewer than 51 Units\",DS_PDDDC_51_Multiplier,IF($D$395=\"Non-Geographic Multiplier for 51 to 80 Units\",DS_PDDDC_81_Multiplier,\"\")))))))))))","v":{"$error":"#NAME?"}},{"$f":"IF($K$369=\"County input required\",\"\",IF(N(K395)>0,N(L394)/N(K395),\"\"))","v":{"$error":"#NAME?"}}]
[]
[null,null,"The final overall TDC PU Limitation for the above defined Development is……….....………………",null,null,null,null,null,null,null,null,{"$f":"IF(_xlfn.SINGLE(County)=_xlfn.SINGLE(DS_Select_One),\"County input required\",IF(L393>0,MAX(L393:L395),\"TBD\"))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Derivation of the TDC PU of the proposed Development for Limitation purposes:"]
[]
[null,null,"Total Development Costs (Line G., column 3)….....................................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(OR(N(TDC_total)=0,N(TDC_total)=\"TBD\"),0,TDC_total)","v":0}]
[]
[null,null,"Less Acq. Cost of Existing Dev. (excluding land) - Existing Building(s)….....................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(OR(Acquisition_total=0,Acquisition_total=\"\"),0,Acquisition_total)","v":0}]
[]
[null,null,"Less Land Acquisition Costs (Line F., column 3)…..............................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(OR(Land_total=0,Land_total=\"\"),0,Land_total)","v":0}]
[]
[null,null,"Less Operating Deficit Reserves (Line E., column 3)…..........................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(OR(ODR_total=0,ODR_total=\"\"),0,ODR_total)","v":0}]
[]
[null,null,"Less Demolition and Relocation Costs, if applicable…...................................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N(Actual_Demolition_total)+N(General_relocation_total))=0,0,SUM(N(Actual_Demolition_total)+N(General_relocation_total)))","v":0}]
[]
[null,null,"Less Commercial/Retail Space Costs, if applicable….................................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(OR(Actual_Comm_Retail_total=0,Actual_Comm_Retail_total=\"\"),0,Actual_Comm_Retail_total)","v":0}]
[]
[null,null,"TDC of the proposed Development for Limitation Purposes:….................................................................................",null,null,null,null,null,null,null,null,{"$f":"L401-L403-L405-L407-L409-L411","v":0}]
[]
[null,null,"TDC PU of the proposed Development for Limitation Purposes:…..............................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(OR(N(Total_Units)=0,N(Total_Units)=\"\"),0,L413/N(Total_Units))","v":{"$error":"#NAME?"}}]
[]
[null,null,"Is the proposed Development's TDC PU for Limitation purposes equal ",null,null,null,null,null,null,null,null,{"$f":"IF(AND(N(FO_TDC_PU_Limit)>0,N(L415)>0),IF(L415<=N(FO_TDC_PU_Limit),\"Yes\",\"No\"),\"TBD\")","v":{"$error":"#NAME?"}}]
[null,null,null,"to or less than the TDC PU Limitation provided in the RFA?.......................................................",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L417=\"No\",\"**\",\"\")","v":{"$error":"#NAME?"}}]
[]
[]
[null,{"$f":"B$2","v":"RFA 2023-211 DEVELOPMENT COST PRO FORMA"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N(Non_Competitive_HC_Request_Amount)>0,$P$422>0,#REF!=\"No\"),\"(Page 8 of 8)\",IF($P$422=0,\"(NA)\",\"(Page 7 of 7)\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"PRELIMENARY TAX-EXEMPT BOND ANALYSES"]
[]
[null,"This section of the Pro forma is intended for information purposes only, and is not scored. The resulting analyses is based on various"]
[null,"inputs throughout this application, and is not indicative of the analyses conducted at Credit Underwriting or Final Cost Certification."]
[]
[null,"Qualified Basis Calculations"]
[]
[null,"A.","Acquisition"]
[null,null,"Acquisition Cost of Land and Existing Improvements…..........................................................................",null,null,null,null,null,null,null,null,{"$f":"N(Acquisition_total)+N(Land_total)","v":0}]
[null,null,null,"Less Land Costs…......................................................................................................................",null,null,null,null,null,null,null,{"$f":"IF(N(Land_total)>0,N(Land_total),0)","v":0}]
[null,null,null,"Plus Developer Fee Attributable to Acquisition…...........................................................................",null,null,null,null,null,null,null,{"$f":"N(Developer_fee_acq_total)","v":0}]
[null,null,"Total Eligible Basis….........................................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L431)-N(L432)+N(L433)","v":0}]
[null,null,"Applicable Fraction (percent set-aside units)…..............................................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(Minimum_SetAside_per_Sec_42=\"Average Income Test\",AIT_HC_SA_Percent,NonAIT_HC_SA_Percent)","v":{"$error":"#NAME?"}}]
[null,null,"DDA/QCT Basis Credit, if applicable….................................................................................................",null,null,null,null,null,null,null,null,1]
[null,null,"Qualified Basis…................................................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L434)*N(L435)*N(L436)","v":{"$error":"#NAME?"}}]
[null,null,"Housing Credit Percentage (Federal allocation)…................................................................................",null,null,null,null,null,null,null,null,0.04]
[null,null,"Annual Housing Credit Allocation….......................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L437)*N(L438)","v":{"$error":"#NAME?"}}]
[]
[]
[null,"B.","New Costs"]
[null,null,"Total Development Cost..…...............................................…..............................................................",null,null,null,null,null,null,null,null,{"$f":"N(TDC_total)","v":0}]
[null,null,null,"Less Cost of Land and Existing Improvements...............................................................................................",null,null,null,null,null,null,null,{"$f":"N(Acquisition_total)+N(Land_total)","v":0}]
[null,null,null,"Less Developer Fee on Acquisition of Buildings….................................................................",null,null,null,null,null,null,null,{"$f":"IF(N(Developer_fee_acq_total)>0,N(Developer_fee_acq_total),0)","v":0}]
[null,null,null,"Less Other Ineligible Costs…..................................................................................................",null,null,null,null,null,null,null,{"$f":"IF(N(TDC_ineligible)>0,N(TDC_ineligible)-N(Land_total),0)","v":0}]
[null,null,"Total Eligible Basis…...........................................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L443)-N(L444)-N(L445)-N(L446)","v":0}]
[null,null,"Applicable Fraction (percent set-aside units)…..............................................................................................................",null,null,null,null,null,null,null,null,{"$f":"L435","v":{"$error":"#NAME?"}}]
[null,null,"DDA/QCT Basis Credit, if applicable….................................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(OR(#REF!=\"Yes\",#REF!=\"Yes\",#REF!=\"Yes\",#REF!=\"Yes\",#REF!=\"Yes\",AND(#REF!=1,#REF!=0,OR(#REF!=\"Yes\",#REF!=\"Yes\",#REF!=\"Yes\"))),1.3,1)","v":{"$error":"#REF!"}}]
[null,null,"Qualified Basis…..............................................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L447)*N(L448)*N(L449)","v":{"$error":"#NAME?"}}]
[null,null,"Housing Credit Percentage (Federal allocation)….......................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!=0,#REF!=1),4%,IF(AND(#REF!=1,#REF!=0),9%,0%))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(AND(#REF!=1,#REF!=1),\"Funding Tab Error\",\"\")","v":{"$error":"#REF!"}}]
[null,null,"Annual Housing Credit Allocation….....................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L450)*N(L451)","v":{"$error":"#NAME?"}}]
[]
[null,null,"Annual Housing Credit Allocation Per Qualified Basis…......................................................",null,null,null,null,null,null,null,null,{"$f":"N(L439)+N(L452)","v":{"$error":"#NAME?"}}]
[]
[]
[null,"Gap Calculation"]
[null,null,"Total Development Cost (including land and ineligible costs)...........…..............................................................",null,null,null,null,null,null,null,null,{"$f":"IF(N(TDC_total)=0,0,TDC_total)","v":0}]
[null,null,null,"Less Mortgages…....................................................................................................................",null,null,null,null,null,null,null,{"$f":"Total_NonGrant_Mtg","v":0}]
[null,null,"Equity Gap…............…........................................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L458)-N(L459)","v":0}]
[null,null,"HC Percentage to Investment Partnership…..............................................................................................................",null,null,null,null,null,null,null,null,0.99990000000000001,null,null,null,null,"Assumed to be 99.99%. Change as necessary."]
[null,null,"HC Syndication Pricing…..............................................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(AND(N(Competitive_HC_Request_Amount)=0,N(Non_Competitive_HC_Request_Amount)=0),\"TBD\",PermAnalysis_HC/(_xlfn.SINGLE(IF(N(L451)=9%,Competitive_HC_Request_Amount,Non_Competitive_HC_Request_Amount))*10*Percent_Credits_Purchased))","v":"TBD"}]
[null,null,"HC Required to meet Equity Gap…..............................................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(OR(L462=0,L462=\"TBD\"),\"TBD\",N(L460)/N(L461)/N(L462))","v":"TBD"}]
[null,null,"Annual HC Required….......................................................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(L463=\"TBD\",\"TBD\",N(L463)/10)","v":"TBD"}]
[]
[]
[null,"HC Summary"]
[null,null,"HC Per Qualified Basis…............…..............................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L454)","v":{"$error":"#NAME?"}}]
[null,null,"HC Per GAP Calculation…....................................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L464)","v":0}]
[null,null,"Annual HC Recommended…................................................................................................................",null,null,null,null,null,null,null,null,{"$f":"MIN(N(L468),N(L469))","v":{"$error":"#NAME?"}}]
[null,null,"HC Proceeds Recommended…...................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L470)*N(L461)*N(L462)*10","v":{"$error":"#NAME?"}}]
[]
[]
[null,"Tax Exempt Bond 50% Test"]
[null,null,"Total DEPRECIABLE Cost….........................................…..............................................................",null,null,null,null,null,null,null,null,{"$f":"IF(N(TDC_eligible)>0,N(TDC_eligible)+N(Actual_Comm_Retail_total),0)","v":0}]
[null,null,null,"Plus Land Cost…....................................................................................................................",null,null,null,null,null,null,null,{"$f":"IF(N(Land_total)>0,N(Land_total),0)","v":0}]
[null,null,"Aggregate Basis…............…..............................................................................................................",null,null,null,null,null,null,null,null,{"$f":"N(L475)+N(L476)","v":0}]
[null,null,"Tax Exempt Bond Amount…............…..............................................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!=1,#REF!=1,#REF!>0),#REF!,IF(AND(#REF!=1,#REF!=1,#REF!=0),ConstrAnalysis__1st_Mtg,0))","v":{"$error":"#REF!"}}]
[null,null,"Equals Tax Exempt Proceeds Used for Building and Land*.........................................................................................................",null,null,null,null,null,null,null,null,{"$f":"L478","v":{"$error":"#REF!"}}]
[null,null,"Tax Exempt Proceeds as a Percentage of Aggregate Basis..............................................................................................................",null,null,null,null,null,null,null,null,{"$f":"IF(N(L477)=0,\"TBD\",N(L479)/N(L477))","v":"TBD"}]
[]
[null,null,"* Based on the assumption that 100% of the Tax Exempt Proceeds will be used for Building and Land."]