{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dev Fee Instructions","Dev Fee"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":75,"comments":1,"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":"Dev Fee Instructions","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Overview Instructions"]
[]
["This worksheet calculates developer fee limits under the 2017 Uniform Multifamily Regulations.  For projects without tax credits, the calculation is based primarily on unit count and construction type.  For other projects, it is based on TCAC fee limits.  References to UMR and TCAC sections are located within the form."]
[]
["Data can be entered only into yellow shaded cells.  Some cells have drop down menus.\nTo use the form: \nFirst: select the Project Phase from the drop down menu (when submitting a funding application to HCD, select Origination).  Once selected, references willl appear to the far right, indicating the source document where the requested information can be found.\nSecond: select the type of tax credits in the project: 4%, 9% or None.\nThird:  select the Construction Type from the drop down menu in Section 1a."]
[]
["Section 1 of the worksheet calculates the fee allowable under the 9% tax credit program, which under the UMRs limits the fee paid from development sources, even if the project is using 4% credits.  For 4% projects, this may include applying TCAC's high cost adjustment."]
[]
["Section 2 of the worksheet applies only to projects using 4% tax credits.  This section calculates the developer fee allowed in basis under TCAC rules for 4% projects, then, pursuant to UMR Section 8312, uses this amount to calculate the maximum total developer fee, the maximum developer fee payable from funding sources, and the maximum deferred developer fee paid exclusively from operating income."]
[]
["Section 2 (j) through (p) calculates TCAC's unit adjustment as well as requirements for deferral or equity contribution to the project.  Although not part of the UMR, these requirements must be reflected in sources and uses statements submitted to HCD."]
[]
["Section 3 only shows when None is selected for Proposed/Reserved Tax Credits in the Project. This section calculates the developer fee for projects that do not use tax credits."]

{"sheet":"Dev Fee","index":1,"n_rows":64,"n_cols":39,"rows_kept":64,"cut":false,"hidden":false,"merged":[[28,23,28,24],[6,13,6,14],[11,16,11,17],[13,16,13,17],[2,10,2,14],[2,15,2,19],[9,18,9,19],[2,20,2,24],[11,21,11,22],[13,21,13,22],[8,5,8,6],[7,20,7,24],[8,23,8,24],[8,18,8,19],[4,18,4,19],[4,23,4,24],[5,16,5,17],[5,18,5,19],[6,18,6,19],[7,1,7,7],[3,0,3,5],[3,6,3,8],[6,23,6,24],[0,0,0,8],[2,0,2,1],[1,7,1,8],[6,1,6,5],[5,1,5,5],[1,0,1,1],[1,3,1,4],[2,2,2,4],[4,3,4,4],[4,1,4,2],[53,0,53,8],[59,0,59,8],[15,1,15,4],[9,1,9,5],[14,1,14,5],[27,1,27,6],[10,1,10,6],[12,1,12,6],[29,1,29,5],[28,1,28,6],[16,5,16,6],[13,1,13,2],[13,4,13,5],[11,4,11,5],[62,0,62,6],[63,0,63,6],[13,18,13,19],[11,13,11,14],[13,13,13,14],[39,18,39,19],[28,12,28,14],[11,18,11,19],[17,5,17,6],[24,1,24,5],[25,1,25,5],[26,1,26,6],[11,1,11,2],[24,18,24,19],[36,18,36,19],[48,0,48,8],[45,18,45,19],[9,23,9,24],[15,23,15,24],[13,23,13,24],[11,23,11,24],[39,23,39,24],[42,23,42,24],[45,23,45,24],[15,18,15,19],[25,18,25,19],[19,18,19,19],[26,18,26,19],[27,18,27,19],[28,18,28,19],[26,23,26,24],[27,23,27,24]]}
["HCD 2017 UMR Developer Fee Calculator - revised 8/6/18\nWhen opening this file, a yellow banner at the top may appear with a button that says \"Enable Content\" or \"Enable Editing\".  It is essential that you click this box so that the macros are enabled. Enabling macros is necessary for full worksheet functionality. Macros do not work with MIcrosoft's Excel version for Apple Mac.  Please either complete this form using a PC or contact your HCD Rep for further assistance.\nFor guidance see the Instructions worksheet."]
["Project Phase:",null,null,"Proposed/Reserved Tax Credits in the Project:",null,null,"TCAC Project #:",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,null,null,false,false,false]
["Project Name:",null,null,null,null,"HCD Contract #s:",null,null,null,null,{"$f":"IF(AM2=TRUE,\"\",\"Instructions: where to find the data at Application Origination\")","v":"Instructions: where to find the data at Application Origination"},null,null,null,null,{"$f":"IF(AM2=TRUE,\"\",\"Instructions: where to find the data at Construction Close\")","v":"Instructions: where to find the data at Construction Close"},null,null,null,null,{"$f":"IF(AM2=TRUE,\"\",\"Instructions: where to find the data at Perm Close\")","v":"Instructions: where to find the data at Perm Close"}]
["Section 1. UMR §8312(c)(1) - for all 4% and 9% Projects (project costs per TCAC 9% rules)",null,null,null,null,null,{"$f":"IF(AND(C2=\"Origination\",AL2=TRUE),\"NOTE: Submit TCAC 9% Application\",IF(AND(C2=\"Origination\",AL2=FALSE),\"NOTE: Submit TCAC 4% Application\",IF(AND(C2=\"Construction Close\",AL2=TRUE),\"NOTE: Submit TCAC 9% Application and TCAC 9% Project Staff Report\",IF(AND(C2=\"Construction Close\",AL2=FALSE),\"NOTE: Submit TCAC 4% Application and TCAC 4% Project Staff Report\",IF(AND(C2=\"Perm Close\",AL2=TRUE),\"NOTE: Submit Signed Cost Cert and TCAC 9% Project Staff Report\",IF(AND(C2=\"Perm Close\",AL2=FALSE),\"NOTE: Submit Signed Cost Cert and TCAC 4% Project Staff Report\",\"\"))))))","v":""},null,null,null,"Origination Document","Worksheet","Document/Worksheet Section","Row Reference","Column Reference","Const. Close Document","Worksheet","Document/Worksheet Section","Row Reference","Column Reference","Perm Document","Worksheet","Document/Worksheet Section","Row Reference","Column Reference"]
["a.","Select the Construction type",null,null,null,null,null,null,{"$f":"IF(D5=\"\",0,IF(D5=\"New Construction\",2200000,2000000))","v":0},null,"Universal Application","General","Proposed Development","cell A51","Development Type",{"$f":"IF($AL$2=TRUE,\"TCAC 9% Project Staff Report\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,"Project Information","Construction Type",null,"TCAC 4% Project Staff Report",null,"Project Information","Construction Type"]
["b.","Project's Eligible Basis (w/o developer fee) - §10327(c)(2)(A), §10327(c)(2)(C)",null,null,null,null,null,"x 15% =",{"$f":"G6*0.15","v":0},null,"Universal Application","Dev Budget","Eligible Basis Costs","SUBTOTAL (cell G118)",0.7,{"$f":"IF($AL$2=TRUE,\"TCAC 9% Project Staff Report\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},"Eligible Basis and Basis Limit, and\nDetermination of Credit Amount(s)",null,"Actual Eligible Basis minus\nApproved Developer Fee in Eligible Basis",null,"Cost Cert",null,"Sources and Uses","Total Project Costs minus Total Developer Costs","Eligible Basis"]
["c.","Basis for Non-Residential Costs (Commercial) - §10327(c)(2)(A)",null,null,null,null,null,"x 15% =",{"$f":"G7*0.15","v":0},null,"Universal Application","Dev Budget","Commercial","Use only if 1b is less than 1a and Budgeted Developer Fee is greater than 1b.",null,{"$f":"IF($AL$2=TRUE,\"TCAC 9% Applicant\",\"TCAC 4% Applicant\")","v":"TCAC 4% Applicant"},"Sources and Uses Budget","Sources and Uses Budget","Use only if 1b is less than 1a and Budgeted Developer Fee is greater than 1b.",null,"Cost Cert",null,"Sources and Uses","Use only if 1b is less than 1a and Budgeted Developer Fee is greater than 1b."]
["d.",{"$f":"IF(D5=\"New Construction\",\"Base limit: amt that could be included in project costs under 9% rules - lesser of 1a or (1b + 1c.):\",\"Max developer fee that could be included in project costs under 9% rules - lesser of 1a or (1b + 1c):\")","v":"Max developer fee that could be included in project costs under 9% rules - lesser of 1a or (1b + 1c):"},null,null,null,null,null,null,{"$f":"MIN(I5,I6+I7)","v":0}]
["High Cost Adjustment 1f-1g not allowed for 9%",null,null,null,null,{"$f":"IF(AL2=TRUE,\"Not Applicable\",\"Total Unadjusted Threshold Basis Limit\")","v":"Total Unadjusted Threshold Basis Limit"},null,null,null,null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Application\")","v":"TCAC 4% Application"},{"$f":"IF($AL$2=TRUE,\"\",\"Application\")","v":"Application"},{"$f":"IF($AL$2=TRUE,\"\",\"PROJECT FINANCING - THRESHOLD BASIS LIMIT\")","v":"PROJECT FINANCING - THRESHOLD BASIS LIMIT"},{"$f":"IF($AL$2=TRUE,\"\",\"TOTAL UNADJUSTED THRESHOLD BASIS LIMIT\")","v":"TOTAL UNADJUSTED THRESHOLD BASIS LIMIT"},null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,{"$f":"IF($AL$2=TRUE,\"\",\"Eligible Basis and Basis Limit\")","v":"Eligible Basis and Basis Limit"},{"$f":"IF($AL$2=TRUE,\"\",\"Unadjusted Threshold Basis Limit\")","v":"Unadjusted Threshold Basis Limit"},null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,{"$f":"IF($AL$2=TRUE,\"\",\"Eligible Basis and Basis Limit\")","v":"Eligible Basis and Basis Limit"},{"$f":"IF($AL$2=TRUE,\"\",\"Unadjusted Threshold Basis Limit\")","v":"Unadjusted Threshold Basis Limit"}]
["e.",{"$f":"IF(AL2=TRUE,\"Total Adjusted Threshold Basis Limit under 9% rules - §10327(c)(5)\",\"Total Adjusted Threshold Basis Limit under 4% rules - §10327(c)(5)\")","v":"Total Adjusted Threshold Basis Limit under 4% rules - §10327(c)(5)"},null,null,null,null,null,null,null,null,{"$f":"IF($AL$2=TRUE,\"TCAC 9% Application\",\"TCAC 4% Application\")","v":"TCAC 4% Application"},"Application","PROJECT FINANCING - THRESHOLD BASIS LIMIT","TOTAL ADJUSTED THRESHOLD BASIS LIMIT",null,{"$f":"IF($AL$2=TRUE,\"TCAC 9% Project Staff Report\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,"Eligible Basis and Basis Limit","Total Adjusted Threshold Basis Limit",null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,{"$f":"IF($AL$2=TRUE,\"\",\"Eligible Basis and Basis Limit\")","v":"Eligible Basis and Basis Limit"},{"$f":"IF($AL$2=TRUE,\"\",\"Total Adjusted Threshold Basis Limit\")","v":"Total Adjusted Threshold Basis Limit"}]
["f.",{"$f":"IF(AL2=TRUE,\"Not Applicable\",\"1% basis adjustment for each 1% of units income targeted at 50%-36% of AMI - §10327(c)(5)(C)\")","v":"1% basis adjustment for each 1% of units income targeted at 50%-36% of AMI - §10327(c)(5)(C)"},null,null,null,null,null,null,{"$f":"H12*$H$9","v":0}]
[null,{"$f":"IF(AL2=TRUE,\"Not Applicable\",\"Total Rental Units:\")","v":"Total Rental Units:"},null,null,{"$f":"IF(AL2=TRUE,\"Not Applicable\",\"Total Rental Units @ 50% to 36% of AM\")","v":"Total Rental Units @ 50% to 36% of AM"},null,null,{"$f":"IF(G12=\"\",0,ROUNDDOWN(G12/D12,2))","v":0},null,null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Application\")","v":"TCAC 4% Application"},{"$f":"IF($AL$2=TRUE,\"\",\"Application\")","v":"Application"},{"$f":"IF($AL$2=TRUE,\"\",\"PROJECT FINANCING - THRESHOLD BASIS LIMIT\")","v":"PROJECT FINANCING - THRESHOLD BASIS LIMIT"},{"$f":"IF($AL$2=TRUE,\"\",\"1% basis adjustment for each 1% of units income targeted at 50%-36% of AMI:\")","v":"1% basis adjustment for each 1% of units income targeted at 50%-36% of AMI:"},null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},{"$f":"IF($AL$2=TRUE,\"\",\"Eligible Basis and Basis Limit (Adjustments to Basis Limits) / Project Information / Unit Mix\")","v":"Eligible Basis and Basis Limit (Adjustments to Basis Limits) / Project Information / Unit Mix"},null,{"$f":"IF($AL$2=TRUE,\"\",\"No. & % of Tax Credit Units: (yellow cell D12) / No. of Units @ or below 50% of AMI: (yellow cell G12)\")","v":"No. & % of Tax Credit Units: (yellow cell D12) / No. of Units @ or below 50% of AMI: (yellow cell G12)"},null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},{"$f":"IF($AL$2=TRUE,\"\",\"Eligible Basis and Basis Limit (Adjustments to Basis Limits) / Project Information / Unit Mix\")","v":"Eligible Basis and Basis Limit (Adjustments to Basis Limits) / Project Information / Unit Mix"},null,{"$f":"IF($AL$2=TRUE,\"\",\"No. & % of Tax Credit Units: (yellow cell D12) / No. of Units @ or below 50% of AMI: (yellow cell G12)\")","v":"No. & % of Tax Credit Units: (yellow cell D12) / No. of Units @ or below 50% of AMI: (yellow cell G12)"}]
["g.",{"$f":"IF(AL2=TRUE,\"Not Applicable\",\"2% basis adjustment for each 1% of units income targeted at 35% of AMI and below - §10327(c)(5)(C)\")","v":"2% basis adjustment for each 1% of units income targeted at 35% of AMI and below - §10327(c)(5)(C)"},null,null,null,null,null,null,{"$f":"H14*2*$H$9","v":0}]
[null,{"$f":"IF(AL2=TRUE,\"Not Applicable\",\"Total Rental Units:\")","v":"Total Rental Units:"},null,null,{"$f":"IF(AL2=TRUE,\"Not Applicable\",\"Total Rental Units @ 35% of AMI or below\")","v":"Total Rental Units @ 35% of AMI or below"},null,null,{"$f":"IF(G14=\"\",0,ROUNDDOWN(G14/D14,2))","v":0},null,null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Application\")","v":"TCAC 4% Application"},{"$f":"IF($AL$2=TRUE,\"\",\"Application\")","v":"Application"},{"$f":"IF($AL$2=TRUE,\"\",\"PROJECT FINANCING - THRESHOLD BASIS LIMIT\")","v":"PROJECT FINANCING - THRESHOLD BASIS LIMIT"},{"$f":"IF($AL$2=TRUE,\"\",\"1% basis adjustment for each 1% of units income targeted at 35% of AMI or Below:\")","v":"1% basis adjustment for each 1% of units income targeted at 35% of AMI or Below:"},null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},{"$f":"IF($AL$2=TRUE,\"\",\"Eligible Basis and Basis Limit (Adjustments to Basis Limits) / Project Information / Unit Mix\")","v":"Eligible Basis and Basis Limit (Adjustments to Basis Limits) / Project Information / Unit Mix"},null,{"$f":"IF($AL$2=TRUE,\"\",\"No. & % of Tax Credit Units: (yellow cell D14) / No. of Units @ or below 35% of AMI: (yellow cell G14)\")","v":"No. & % of Tax Credit Units: (yellow cell D14) / No. of Units @ or below 35% of AMI: (yellow cell G14)"},null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},{"$f":"IF($AL$2=TRUE,\"\",\"Eligible Basis and Basis Limit (Adjustments to Basis Limits) / Project Information / Unit Mix\")","v":"Eligible Basis and Basis Limit (Adjustments to Basis Limits) / Project Information / Unit Mix"},null,{"$f":"IF($AL$2=TRUE,\"\",\"No. & % of Tax Credit Units: (yellow cell D14) / No. of Units @ or below 35% of AMI: (yellow cell G14)\")","v":"No. & % of Tax Credit Units: (yellow cell D14) / No. of Units @ or below 35% of AMI: (yellow cell G14)"}]
["h.","Total Adjusted Threshold Basis Limit under 9% rules (1e - 1f - 1g)\"",null,null,null,null,null,null,{"$f":"I10-I11-I13","v":0}]
["i.","Total Eligible Basis - §10327(c)(2)(A), §10327(c)(2)(C)",null,null,null,null,null,null,null,null,"Universal Application","Dev Budget",null,"ELIGIBLE BASIS (cell G133)","Eligible Basis Costs 70%",{"$f":"IF($AL$2=TRUE,\"TCAC 9% Project Staff Report\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,"Eligible Basis and Basis Limit","Actual Eligible Basis",null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,"Eligible Basis and Basis Limit","Actual Eligible Basis"]
["j.","High Cost Test Factor - §10327(c)(2)(A); (1i / 1h)",null,null,null,{"$f":"CONCATENATE(\"= \",ROUND(I16,0),\" / \",ROUND(I15,0))","v":"= 0 / 0"},null,null,{"$f":"IF(I15=0,0,I16/I15)","v":0}]
["k.","Max Dev Fee in Project Costs under 9% rules - §10327(c)(2)(A)",null,null,null,{"$f":"IF(D5<>\"New Construction\",\"\",CONCATENATE(\"=(2 - \",ROUND(I17,2),\") x \",ROUND(I8,0)))","v":""},null,null,{"$f":"IF(D5=\"New Construction\",(2-I17)*I8,I8)","v":0}]
["l.","Max Developer Fee payable from development funding sources w/o capital contributions - UMR §8312(c)(1)",null,null,null,null,null,null,{"$f":"I18","v":0}]
["m.","Capital Contribution by Sponsor or affiliate - UMR §8312(d)",null,null,null,null,null,null,null,null,"Universal Application","Perm S&U (Row 4-5)","Amount GP/Sponsor Equity/Contribution","Total Developer Costs\n(row 130)","GP/Sponsor Equity/Contribution",{"$f":"IF($AL$2=TRUE,\"TCAC 9% Project Staff Report\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,"Permanent Financing",{"$f":"IF($AL$2=TRUE,\"\",\"GP/Sponsor Equity/Contribution\")","v":"GP/Sponsor Equity/Contribution"},null,"Cost Cert",null,"Permanent Sources","Total Use of Funds/\nTotal Project Costs","GP/Sponsor Equity/Contribution"]
["n.","Maximum Developer Fee payable from development funding sources - UMR §8312(c)(1); §8312(d)",null,null,null,null,null,null,{"$f":"+I19+H20","v":0}]
[]
["Section 2. UMR §8312(c)(2) - Max Developer Fee allowed in Eligible Basis under TCAC 4% rules"]
[null,"Max Developer Fee allowed in Eligible Basis under TCAC 4% rules"]
["a.",{"$f":"IF(OR(C2=\"\",OR(D5=\"New Construction\",D5=\"Rehabilitation\")),\"New Construction & Rehab - Unadjusted Eligible Basis (exclude Dev Fee) - §10327(c)(2)(B)(i)\",\"Not Applicable\")","v":"New Construction & Rehab - Unadjusted Eligible Basis (exclude Dev Fee) - §10327(c)(2)(B)(i)"},null,null,null,null,null,"x 15% =",{"$f":"G25*0.15","v":0},null,"Universal Application","Dev Budget","Eligible Basis Costs","Total Use of Funds\n(cell G118)","Present Value Calc (PVC) 70%","TCAC 4% Project Staff Report",null,"Eligible Basis and Basis Limit","Requested Unadjusted Eligible Basis",null,"Cost Cert",null,null,"Total Use of Funds / Total Project Costs","Eligible Basis"]
["b.",{"$f":"IF(AND(C2<>\"\",D5<>\"Acq/Rehab\"),\"Not Applicable\",\"Acq/Rehab - Unadjusted Eligible Const. Related Basis (exclude Dev Fee) - §10327(c)(2)(B)(ii)\")","v":"Acq/Rehab - Unadjusted Eligible Const. Related Basis (exclude Dev Fee) - §10327(c)(2)(B)(ii)"},null,null,null,null,null,"x 15% =",{"$f":"G26*0.15","v":0},null,"Universal Application","Dev Budget","Eligible Basis Costs","Total Use of Funds\n(cell G118)","Present Value Calc (PVC) 70%","TCAC 4% Project Staff Report",null,"Eligible Basis and Basis Limit","Requested Unadjusted Eligible Basis",null,"Cost Cert",null,null,"Total Use of Funds / Total Project Costs","Eligible Basis"]
["c1.",{"$f":"IF(AND(C2<>\"\",D5<>\"Acq/Rehab\"),\"Not Applicable\",\"Acq/Rehab - at-risk development meeting the requirements of §10325(g)(4)? - §10327(c)(2)(B)(ii)\")","v":"Acq/Rehab - at-risk development meeting the requirements of §10325(g)(4)? - §10327(c)(2)(B)(ii)"},null,null,null,null,null,null,null,{"$f":"IF(H27=\"Yes\",1,IF(H27=\"No\",2,0))","v":0},"Universal Application","General","Row 55","Federally \"At Risk\"?","Yes/No","TCAC 4% Project Staff Report",null,"Information","Housing Type",null,"TCAC 4% Project Staff Report",null,"Information","Housing Type"]
["c2.",{"$f":"IF(AND(C2<>\"\",D5<>\"Acq/Rehab\"),\"Not Applicable\",\"Acq/Rehab - rehabilitation hard construction costs per unit at least $25,000 per unit? - §10327(c)(2)(B)(ii)\")","v":"Acq/Rehab - rehabilitation hard construction costs per unit at least $25,000 per unit? - §10327(c)(2)(B)(ii)"},null,null,null,null,null,null,null,{"$f":"IF(H28=\"Yes\",1,IF(H28=\"No\",2,0))","v":0},"Universal Application","Dev Budget ","Rehabilitation","Column D, Rows 17, 18 & 19","Sum of Site work, Structures & Gen. Req.","TCAC 4% Application","Sources and Uses Budget","Sources and Uses Budget","Residential Costs- Site Work, Structures, Prevailing Wage divided by total units including manager units",null,"TCAC 4% Application","Sources and Uses Budget","Sources and Uses Budget","Residential Costs- Site Work, Structures, Prevailing Wage divided by total units including manager units"]
["c3.",{"$f":"IF(AND(C2<>\"\",D5<>\"Acq/Rehab\"),\"Not Applicable\",\"Acq/Rehab-30% or more of units restricted to incomes and rents of 50% AMI or less? - §10327(c)(2)(B)(ii)\")","v":"Acq/Rehab-30% or more of units restricted to incomes and rents of 50% AMI or less? - §10327(c)(2)(B)(ii)"},null,null,null,null,null,null,null,0,"Universal Application","Rents ","Total Units Restricted at or below 50% AMI divided bt Total Units",null,null,"TCAC 4% Project Staff Report",null,"Project Information / 55 Year Use Affordability","Number of Units at or below 50% AMI divided by total number of tax credit units",null,"TCAC 4% Project Staff Report",null,"Project Information / 55 Year Use Affordability","Number of Units at or below 50% AMI divided by total number of tax credit units"]
["c4.",{"$f":"IF(AND(C2<>\"\",D5<>\"Acq/Rehab\"),\"Not Applicable\",\"Acq/Rehab - Unadj. Eligible Acq. Basis - §10327(c)(2)(B)(ii) = 15% if c1, c2 or c3 is Yes\")","v":"Acq/Rehab - Unadj. Eligible Acq. Basis - §10327(c)(2)(B)(ii) = 15% if c1, c2 or c3 is Yes"},null,null,null,null,null,{"$f":"IF(OR(J27=1,J28=1,J29=1),\"x 15% =\",\"x 5% = \")","v":"x 5% = "},{"$f":"IF(OR(J27=1,J28=1,J29=1),G30*0.15,G30*0.05)","v":0},null,"Universal Application","Dev Budget ","Eligible Basis Costs","Total Acquisition (Row 13)","Present Value Calc (PVC) 30%","TCAC 4% Application","Sources and Uses Budget","Sources and Uses Budget","Total Eligible Basis","30% Present Value Calc (PVC) for Acquisition","TCAC 4% Application","Sources and Uses Budget","Sources and Uses Budget","Total Eligible Basis","30% Present Value Calc (PVC) for Acquisition"]
["d.","Maximum Developer Fee in Eligible Basis under 4% rules",null,null,null,null,null,null,{"$f":"IF(D5=\"New Construction\",I25,I26+I30)","v":0},null,null,null,null,null,null,null,null,null,null,"\\"]
[null,"Max Developer Fee per §8312(c)"]
["e.","Total Developer Fee Limit (including deferred fee and with no sponsor contribution)"]
[null," -- lesser of $3,500,000 or amount in Eligible Basis under 4% rules (2d above)",null,null,null,null,null,{"$f":"MIN(3500000,I31)","v":0}]
["f.","Capital Contribution by Sponsor or affiliate  - UMR §8312(d) (1m above)",null,null,null,null,null,{"$f":"H20","v":0}]
["g.","Maximum Total Developer Fee - UMR §8312(c)",null,null,null,null,null,{"$f":"+H34+H35","v":0}]
[{"$f":"IF($AL$2=TRUE,\"o.\",\"h.\")","v":"h."},"Budgeted Developer Fee paid from Development Sources ",null,null,null,"cannot exceed:",{"$f":"I21","v":0},null,{"$f":"IF(H37>I21,\"<- Exceeds max from sources\",\"\")","v":""},null,"Universal Application","Perm S&U","Sum of all sources less Def Dev Fee","Total Developer Costs (Row 130)","Columns E thru S less Def. Dev. Fee",{"$f":"IF($AL$2=TRUE,\"TCAC 9% Project Staff Report\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,"Determination of Credit Amount(s)","Approved Developer Fee in Eligible Basis minus Deferred Developer Fee",null,"Cost Cert",null,null,"Total Developer Costs","Total Developer Costs minus Def. Developer Fee"]
["i.","Maximum Deferred Developer Fee payable exclusively from Operating Income - UMR §8312(c)(2)",null,null,null,null,null,{"$f":"+H36-H37","v":0}]
[null,"TCAC-Required Fee Deferral or Contribution - §10327(c)(2)(B)"]
["j.","Tax credit units:",null,null,"§10327(c)(2)(B)",null,{"$f":"CONCATENATE(\"= \",\"$10,000 x \",IF(D40<=100,0,D40-100))","v":"= $10,000 x 0"},{"$f":"IF(D40<=100,0,(D40-100)*10000)","v":0},null,null,"Universal Application","General","LIHTC units","Cell D53",null,"TCAC 4% Project Staff Report",null,"Project Information","No. & % of Tax Credit Units",null,{"$f":"IF($AL$2=TRUE,\"Not Applicable\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,"Project Information",{"$f":"IF($AL$2=TRUE,\"\",\"No. & % of Tax Credit Units\")","v":"No. & % of Tax Credit Units"}]
["k.","Unadjustment max fee without deferral, equity contribution or unit count adj - §10327(c)(2)(B)",null,null,null,null,null,2500000]
["l.","Maximum fee with unit adjustment and without deferral or equity contribution - §10327(c)(2)(B)",null,null,null,null,null,{"$f":"H40+H41","v":2500000}]
[{"$f":"IF($AL$2=TRUE,\"p.\",\"m.\")","v":"m."},"Budgeted Deferred Developer Fee  - §10327(c)(2)(B)",null,null,null,null,null,null,null,null,"Universal Application","Perm S&U (Row 4-5)","Amount for Def. Dev. Fee","Total Developer Costs (Row 130)","Deferred Developer Fee",{"$f":"IF($AL$2=TRUE,\"TCAC 9% Project Staff Report\",\"TCAC 4% Project Staff Report\")","v":"TCAC 4% Project Staff Report"},null,"Permanent Financing","Source","Deferred Developer Fee","Cost Cert",null,"Total Developer Costs","Total Deferred Developer Fee"]
["n.","Budgeted Developer Fee contributed as equity to project - §10327(c)(2)(B) (same as 1m above)",null,null,null,null,null,{"$f":"H20","v":0}]
["o.","Maximum Total Developer Fee under TCAC rules - §10327(c)(2)(B)",null,null,null,null,null,{"$f":"SUM(H42:H44)","v":2500000}]
[{"$f":"IF($AL$2=TRUE,\"q.\",\"p.\")","v":"p."},{"$f":"IF(AL2=TRUE, \"Total Developer Fee\",\"Budgeted Total Developer Fee\")","v":"Budgeted Total Developer Fee"},null,null,null,null,null,null,{"$f":"IF(AL2=TRUE,H37+H43,\"\")","v":""},null,"Universal Application","Perm S&U ","Sum of all sources","Total Developer Costs\n(cell T130)","Total Residential Sources","TCAC 4% Project Staff Report",null,"Determination of Credit Amount(s)","Approved Developer Fee (in Project Cost & Eligible Basis)",null,"Cost Cert",null,"Total Developer Costs","Total Developer Costs"]
[]
["Section 3. UMR §8312(a) Instructions:  Complete the yellow, shaded cells - choose only one in the 'A', 'B' or 'C' sections."]
["a.  New construction and substantial rehab projects UMR §8312(a)(1)"]
["a1.","Number of units (include manager's unit)"]
["a2.","First 30 units at: ",null,26000,"each",null,{"$f":"IF(F50>29,D51*30,+F50*D51)","v":0}]
["a3.","Units in excess of 30 at:  ",null,10500,"each",null,{"$f":"IF(F50<30,0,(F50-30)*D52)","v":0}]
["a4.","Total (a2 + a3)",null,null,null,null,null,{"$f":"+G51+G52","v":0}]
["b.  Acquisition and rehab projects UMR §8312(a)(2)"]
[null,"with construction cost for rehab work (excluding contractor profit and overhead) between $10,500 - $36,000 per unit"]
["b1.","Number of units (include manager's unit)"]
["b2.","First 30 units at: ",null,12000,"each",null,{"$f":"IF(F56>29,D57*30,+F56*D57)","v":0}]
["b3.","Units in excess of 30 at: ",null,5500,"each",null,{"$f":"IF(F56<30,0,(F56-30)*D58)","v":0}]
["b4.","Total (b2 + b3)",null,null,null,null,null,{"$f":"+G57+G58","v":0}]
["c.  All other projects UMR §8312(a)(3)"]
["c1.","Number of units (include manager's unit)"]
["c2.","Total at:",null,2000,"per unit",null,null,{"$f":"+F61*D62","v":0}]
["d. Sponsor capital contribution of funds or real property UMR §8312(d)"]
["e.  Maximum allowable Developer Fee (a4, b4 or c2; plus d)",null,null,null,null,null,null,{"$f":"H53+H59+H62+H63","v":0}]