{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["SIGNATURE","INSTRUCTIONS","RENTAL_INCOME","RENTAL_EXPENSES","RENTAL_PREDEVELOPMENT_BUDGET","RENTAL_DEVELOPMENT_BUDGET","RENTAL_SOURCES","RENTAL_PRO_FORMA","LIHTC_ELIGIBLE_BASIS","LIHTC_EQUITY","DHCD_UNDERWRITING_STANDARDS","DHCD_UNDERWRITING_BUDGET"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":22,"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":"SIGNATURE","index":0,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,15,44,16],[15,7,15,14],[18,7,18,14],[4,0,4,17],[2,0,2,17],[3,0,3,17],[6,7,6,14],[9,7,9,14],[12,7,12,14],[29,2,29,8],[26,10,26,13],[29,10,29,13],[26,2,26,8],[21,8,21,15],[44,3,44,5]]}
[]
["DEVELOPMENT FINANCE DIVISION"]
["FINANCING  APPLICATION"]
["FORM 202"]
["Application Cover Page"]
[]
[null,null,"Funding Round",null,null,null,null,"Summer 2018 Consolidated RFP"]
[]
[]
[null,null,"Project Type",null,null,null,null,"New Construction Rental"]
[]
[]
[null,null,"LIHTC Funding Requested?",null,null,null,null,"No"]
[]
[]
[null,null,"Organization Name"]
[]
[]
[null,null,"Project Title"]
[]
[]
[null,null,"I certify that I am authorized to obligate ",null,null,null,null,null,{"$f":"H16","v":0}]
[null," ","to apply for funding from the District of Columbia Department of Housing and Community Development.  "]
[null,null,"Furthermore, I certify that all information contained herein is accurate to the best of my knowledge."]
[]
[]
[]
[null,null,"Authorized Organization Official",null,null,null,null,null,null,null,"Date"]
[]
[]
[null,null,"Print Name",null,null,null,null,null,null,null,"Title"]
["TOPA Acquisition"]
["Summer 2018 Consolidated RFP"]
[]
["Acquisition ",null,null,null,null,"Application"]
["Acquisition + Critical Repairs",null,null,null,null,"Initial Underwriting"]
["New Construction Rental",null,null,null,null,"Loan Review Committee"]
["New Construction Homeownership",null,null,null,null,"Closing"]
["Moderate Rehabilitation",null,null,null,null,"8609 Issuance"]
["Substantial Rehabilitation"]
[]
["Yes"]
["No"]
[]
[null,"Project Stage",null,"Application",null,null,null,null,null,null,null,null,null,"DHCD Internal",null,"No"]

{"sheet":"INSTRUCTIONS","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["FORM 202 INSTRUCTIONS"]

{"sheet":"RENTAL_INCOME","index":2,"n_rows":85,"n_cols":13,"rows_kept":85,"cut":false,"hidden":false,"merged":[[57,0,57,8]]}
[null,null,0.3,0.5,0.6,0.8,"Market","Studio","1 Bedroom","2 Bedroom","3 Bedroom","4 Bedroom","5 Bedroom"]
["PROJECT INCOME"]
[]
["RESIDENTIAL INCOME"]
["Unit Description",null,"Median","Number of","Unit Size","Tenant Paid","Contract","Rent","Income per","Monthly","Annual"]
["Bedrooms","Baths","Income","Units","(Net leasable SF)","Utilities*","Rent","Subsidy","Unit","Income","Income"]
[null,null,null,null,null,null,null,null,{"$f":"G7-F7+H7","v":0},{"$f":"D7*I7","v":0},{"$f":"J7*12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G8-F8+H8","v":0},{"$f":"D8*I8","v":0},{"$f":"J8*12","v":0}]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,0]
[null,null,null,null,0,null,0,null,0,0,{"$f":"J11*12","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"D12*I12","v":0},{"$f":"J12*12","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"D13*I13","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,null,0,{"$f":"D26*I26","v":0},{"$f":"J26*12","v":0}]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,0]
[null,null,null,null,0,null,0,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
["Total",null,null,{"$f":"SUM(D7:D31)","v":0},{"$f":"SUM(D7*E7,D8*E8,D9*E9,D10*E10,D11*E11,D12*E12,D13*E13,D14*E14,D16*E16,D15*E15,D17*E17,D18*E18,D19*E19,D20*E20,D21*E21,D22*E22,D23*E23,D24*E24,D25*E25,D26*E26,D27*E27,D28*E28,D29*E29,D30*E30,D31*E31)","v":0},null,null,null,null,{"$f":"+SUM(J7:J31)","v":0},{"$f":"SUM(K7:K31)","v":0}]
["Vacancy Allowance (Total Annual Income x Vacancy Rate)",null,null,null,null,"%",null,null,null,null,{"$f":"-(F33*K32)","v":0}]
["Effective Gross Income/Units (Total Annual Income - Vacancy Allowance)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K32+K33)","v":0}]
["MEDIAN FAMILY INCOME OF UNITS",null,null,null,null,null,"* TENANT PAID UTILITIES (check all utilities to be paid by tenants)"]
["# of Units","Max MFI%","% of Units","% of Sq. Ft.",null,null,"Air Conditioning (describe)"]
[{"$f":"SUMIF($C$7:$C$31,B37,$D$7:$D$31)","v":0},0.3,{"$f":"IF(A37>0,A37/$D$32,0)","v":0},{"$f":"IF($E$32>0,((SUMIF($C$7:$C$31,B37,$E$7:$E$31))*(SUMIF($C$7:$C$31,B37,$D$7:$D$31)))/($E$32),0)","v":0},null,null,"Household Electric (describe)"]
[{"$f":"SUMIF($C$7:$C$31,B38,$D$7:$D$31)","v":0},0.5,{"$f":"IF(A38>0,A38/$D$32,0)","v":0},{"$f":"IF($E$32>0,((SUMIF($C$7:$C$31,B38,$E$7:$E$31))*(SUMIF($C$7:$C$31,B38,$D$7:$D$31)))/($E$32),0)","v":0},null,null,"Cooking (describe)"]
[0,0.6,0,0,null,null,"Hot Water (describe)"]
[0,0.8,0,0,null,null,"Heat (describe)"]
["Please fill in the boxes below:",null,null,null,null,null,"Other (describe)"]
["Total Gross Square Feet"]
[]
[]
["NON-RESIDENTIAL INCOME"]
["Description of Type and Size",null,null,null,null,null,null,null,"Sq. Ft.","Monthly Income","Annual Income"]
[0,null,null,null,null,null,null,null,0,null,{"$f":"J47*12","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J48*12","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["Total Non-residential",null,null,null,null,null,null,null,{"$f":"SUM(I47:I51)","v":0},{"$f":"SUM(J47:J51)","v":0},{"$f":"SUM(K47:K51)","v":0}]
["Vacancy Allowance (Total Annual Income x Vacancy Rate)",null,null,null,null,"%",null,null,null,null,{"$f":"-(F53*K52)","v":0}]
["Effective Gross Income/Non-residential Space (Total Annual Income - Vacancy Allowance)",null,null,null,null,null,null,null,null,null,{"$f":"K52+K53","v":0}]
["Effective Gross Income (sum Residential and Non-residential totals)",null,null,null,null,null,null,null,null,null,{"$f":"K34+K54","v":0}]
[]
["NON-INCOME PRODUCING UNITS (management units, tenant services units, recreation, etc.)"]
["Description of Type and Size",null,null,null,null,null,null,null,null,"# of Units","Sq. Ft."]
[null,null,null,null,null,null,null,null,null,0,0]
[]
[]
["Total Non-income",null,null,null,null,null,null,null,null,{"$f":"SUM(J59:J61)","v":0},{"$f":"SUM(J59*K59)+(J60*K60)+(J61*K61)","v":0}]
[]
["INELIGIBLE CONDO RESIDENTIAL INCOME (Please complete if the project is utilizing a condo structure to separate ineligible uses)"]
["Unit Description",null,"Median","Number of","Unit Size","Tenant Paid","Contract","Rent","Income per","Monthly","Annual"]
["Bedrooms","Baths","Income","Units","(Net leasable SF)","Utilities*","Rent","Subsidy","Unit","Income","Income"]
["Studio",null,null,null,0,null,0,null,{"$f":"G67-F67+H67","v":0},{"$f":"D67*I67","v":0},{"$f":"J67*12","v":0}]
[null,null,null,null,null,null,0,null,{"$f":"G68-F68+H68","v":0},{"$f":"D68*I68","v":0},{"$f":"J68*12","v":0}]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,0]
[null,null,null,null,0,null,0,null,0,0,0]
["Total",null,null,{"$f":"SUM(D67:D71)","v":0},{"$f":"SUM(D67*E67,D68*E68,D69*E69,D70*E70,D71*E71)","v":0},null,null,null,null,{"$f":"+SUM(J67:J71)","v":0},{"$f":"SUM(K67:K71)","v":0}]
["Vacancy Allowance (Total Annual Income x Vacancy Rate)",null,null,null,null,"%",null,null,null,null,{"$f":"-(F73*K72)","v":0}]
["Effective Gross Income/Units (Total Annual Income - Vacancy Allowance)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K72+K73)","v":0}]
[]
["INELIGIBLE CONDO NON-RESIDENTIAL INCOME (Please complete if the project is utilizing a condo structure to separate ineligible uses)"]
["Description of Type and Size",null,null,null,null,null,null,null,"Sq. Ft.","Monthly Income","Annual Income"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J78*12","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J80*12","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J81*12","v":0}]
["Total Non-residential",null,null,null,null,null,null,null,{"$f":"SUM(I78:I81)","v":0},{"$f":"SUM(J78:J81)","v":0},{"$f":"SUM(K78:K81)","v":0}]
["Vacancy Allowance (Total Annual Income x Vacancy Rate)",null,null,null,null,"%",null,null,null,null,{"$f":"-(F83*K82)","v":0}]
["Effective Gross Income/Non-residential Space (Total Annual Income - Vacancy Allowance)",null,null,null,null,null,null,null,null,null,{"$f":"K82+K83","v":0}]
["Effective Gross Income (sum Residential and Non-residential totals)",null,null,null,null,null,null,null,null,null,{"$f":"K74+K84","v":0}]

{"sheet":"RENTAL_EXPENSES","index":3,"n_rows":83,"n_cols":6,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,3,2,4],[2,0,2,1],[4,0,4,2],[43,0,43,2]]}
["Contract","Quote","Developer estimate"]
["PROJECT EXPENSES"]
["Total Residential Units:",null,{"$f":"RENTAL_INCOME!D32","v":0},"Total Gross Square Footage:",null,{"$f":"RENTAL_INCOME!C42","v":0}]
["ADMINISTRATIVE EXPENSES"]
["Expenses",null,null,"Total Cost","Cost per sq. ft.","Cost per Unit"]
["Advertising and Marketing",null,null,null,{"$f":"IF($F$3=0,0,D6/$F$3)","v":0},{"$f":"IF($C$3=0,0,D6/$C$3)","v":0}]
["Office Salaries",null,null,null,0,0]
["Office Supplies",null,null,null,0,0]
["Office or Model Apartment Rent",null,null,null,0,0]
["Management Fee:                                                                        EGI x rate of",0.06,null,{"$f":"RENTAL_INCOME!K55*RENTAL_EXPENSES!B10","v":0},0,0]
["Manager or Superintendent Rent Free Unit",null,null,null,0,0]
["Legal Expenses (project only)",null,null,null,0,0]
["Auditing Expenses (project only)",null,null,null,0,0]
["Bookkeeping Fees and Accounting Services",null,null,null,0,0]
["Telephone and Answering Services",null,null,null,0,0]
["Bad Debts",null,null,null,0,0]
["Miscellaneous Administrative Expenses (describe):",null,null,null,0,0]
["Annual Tax Credit Monitoring Fee ($45.00/tax credit unit)",null,null,null,0,0]
["Other Administrative Expenses 1",null,null,null,0,0]
["Other Administrative Expenses 2",null,null,null,0,0]
["Other Administrative Expenses 3",null,null,null,0,0]
["Other Administrative Expenses 4",null,null,null,0,0]
["Other Administrative Expenses 5",null,null,null,0,0]
["Total Administrative Expenses",null,null,{"$f":"SUM(D6:D23)","v":0},{"$f":"SUM(E6:E23)","v":0},{"$f":"SUM(F6:F23)","v":0}]
["UTILITY EXPENSES (paid by owner)"]
["Fuel Oil",null,null,null,{"$f":"IF($F$3=0,0,D26/$F$3)","v":0},{"$f":"IF($C$3=0,0,D26/$C$3)","v":0}]
["Electricity",null,null,null,0,0]
["Gas",null,null,null,0,0]
["Water/Sewer",null,null,null,0,0]
["Other Utility Expenses 1",null,null,null,0,0]
["Other Utility Expenses 2",null,null,null,0,0]
["Other Utility Expenses 3",null,null,null,0,0]
["Other Utility Expenses 4",null,null,null,0,0]
["Other Utility Expenses 5",null,null,null,0,0]
["Total Utility Expenses",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:E34)","v":0},0]
["OPERATING AND MAINTENANCE EXPENSES"]
["Janitor and Cleaning Payroll",null,null,null,{"$f":"IF($F$3=0,0,D37/$F$3)","v":0},{"$f":"IF($C$3=0,0,D37/$C$3)","v":0}]
["Janitor and Cleaning Supplies",null,null,null,0,0]
["Janitor and Cleaning Contract",null,null,null,0,0]
["Exterminating Payroll or Contract",null,null,null,0,0]
["Exterminating Supplies",null,null,null,0,0]
["Garbage and Trash Removal",null,null,null,{"$f":"IF($F$3=0,0,D42/$F$3)","v":0},{"$f":"IF($C$3=0,0,D42/$C$3)","v":0}]
[]
["Expenses",null,null,"Total Cost","Cost per sq. ft.","Cost per Unit"]
["Security Payroll or Contract",null,null,null,{"$f":"IF($F$3=0,0,D45/$F$3)","v":0},{"$f":"IF($C$3=0,0,D45/$C$3)","v":0}]
["Grounds Payroll",null,null,null,0,0]
["Grounds Supplies",null,null,null,0,0]
["Grounds Contract",null,null,null,0,0]
["Repairs Payroll",null,null,null,0,0]
["Repairs Material",null,null,null,0,0]
["Repairs Contract",null,null,null,0,0]
["Elevator Maintenance or Contract",null,null,null,0,0]
["HVAC Maintenance or Contract",null,null,null,0,0]
["Swimming Pool Maintenance or Contract",null,null,null,0,0]
["Snow Removal",null,null,null,0,0]
["Misc. Operating and Maintenance Expenses (describe):",null,null,null,0,0]
["Other Operating and Maintenance Expense 1",null,null,null,0,0]
["Other Operating and Maintenance Expense 2",null,null,null,0,0]
["Other Operating and Maintenance Expense 3",null,null,null,0,0]
["Other Operating and Maintenance Expense 4",null,null,null,0,0]
["Other Operating and Maintenance Expense 5",null,null,null,0,0]
["Total Operating and Maintenance Expenses",null,null,{"$f":"+SUM(D37:D61)","v":0},{"$f":"+SUM(E37:E61)","v":0},{"$f":"+SUM(F37:F61)","v":0}]
["TAXES AND INSURANCE"]
["Real Estate Taxes",null,null,null,{"$f":"IF($F$3=0,0,D64/$F$3)","v":0},{"$f":"IF($C$3=0,0,D64/$C$3)","v":0}]
["Payment in Lieu of Taxes",null,null,null,0,0]
["Payroll Taxes (FICA)",null,null,null,0,0]
["Miscellaneous Taxes, Licenses and Permits",null,null,null,0,0]
["Property and Liability Insurance (hazard)",null,null,null,0,0]
["Fidelity Bond Insurance",null,null,null,0,0]
["Workmen's Compensation",null,null,null,0,0]
["Health Insurance and Other Employee Benefits",null,null,null,0,0]
["Other Taxes and Insurance 1",null,null,null,0,0]
["Other Taxes and Insurance 2",null,null,null,0,0]
["Other Taxes and Insurance 3",null,null,null,0,0]
["Other Taxes and Insurance 4",null,null,null,0,0]
["Other Taxes and Insurance 5",null,null,null,0,0]
["Total Taxes and Insurance",null,null,{"$f":"SUM(D64:D76)","v":0},{"$f":"SUM(E64:E76)","v":0},0]
["RESERVES"]
["Operating Reserve",null,null,null,{"$f":"IF($F$3=0,0,D79/$F$3)","v":0},{"$f":"IF($C$3=0,0,D79/$C$3)","v":0}]
["Reserve for Replacement",null,null,null,{"$f":"IF($F$3=0,0,D80/$F$3)","v":0},{"$f":"IF($C$3=0,0,D80/$C$3)","v":0}]
["Total Operating Expenses",null,null,{"$f":"D24+D35+D62+D77+D79+D80","v":0},{"$f":"E24+E35+E62+E77+E79+E80","v":0},{"$f":"F24+F35+F62+F77+F79+F80","v":0}]
["Net Operating Income (Effective Gross Income - Total Operating Expenses)",null,null,{"$f":"RENTAL_INCOME!K55-RENTAL_EXPENSES!D81","v":0},{"$f":"IF($F$3=0,0,D82/$F$3)","v":0},{"$f":"IF($C$3=0,0,D82/$C$3)","v":0}]
["Per Unit Operating Expense for DHCD Operating Expense Limit (Operating Expenses Less Replacement Reserves)",null,null,null,null,{"$f":"IF(C3=0,0,(D81-D80)/C3)","v":0}]

{"sheet":"RENTAL_PREDEVELOPMENT_BUDGET","index":4,"n_rows":124,"n_cols":8,"rows_kept":124,"cut":false,"hidden":false,"merged":[[12,0,12,3],[4,0,4,1]]}
["DHCD- PREDEVELOPMENT BUDGET"]
[null,null,null,null,null,"Total Gross Square Footage:",null,{"$f":"RENTAL_INCOME!C42","v":0}]
["TOTAL PREDEVELOPMENT COSTS",null,null,null,null,"Total Residential Units:",null,{"$f":"RENTAL_INCOME!D32","v":0}]
["SOURCES"]
["Type of Sources",null,"Interest Rate","Term","Total Predevelopment Sources","% of Total  Cost","Cost per sq ft","Cost per unit"]
["Other Predevelopment Source 1",null,null,null,null,{"$f":"IF($E$124=0,0,E6/$E$124)","v":0},{"$f":"IF($H$2=0,0,E6/$H$2)","v":0},{"$f":"IF($H$3=0,0,E6/$H$3)","v":0}]
["Other Predevelopment Source 2",null,null,null,null,0,0,0]
["Other Predevelopment Source 3",null,null,null,null,0,0,0]
["Other Predevelopment Source 4",null,null,null,null,0,0,0]
["Other Predevelopment Source 5",null,null,null,null,0,0,0]
["Total Predevelopment Sources",null,null,null,{"$f":"SUM(E6:E10)","v":0},0,0,{"$f":"IF($H$3=0,0,E11/$H$3)","v":0}]
["ACQUISITION"]
["Type of Uses",null,null,null,"Total Predevelopment Uses","% of Total  Cost","Cost per sq ft","Cost per unit"]
["Acquisition",null,null,null,null,{"$f":"IF($E$124=0,0,E14/$E$124)","v":0},{"$f":"IF($H$2=0,0,E14/$H$2)","v":0},{"$f":"IF($H$3=0,0,E14/$H$3)","v":0}]
["Land Costs",null,null,null,null,0,{"$f":"IF($H$2=0,0,E15/$H$2)","v":0},0]
["Other Acquisition Costs 1",null,null,null,null,0,0,0]
["Other Acquisition Costs 2",null,null,null,null,0,0,0]
["Other Acquisition Costs 3",null,null,null,null,0,0,0]
["Other Acquisition Costs 4",null,null,null,null,0,0,0]
["Other Acquisition Costs 5",null,null,null,null,0,0,0]
["Total Acquisition Costs",null,null,null,{"$f":"SUM(E14:E20)","v":0},0,0,{"$f":"IF($H$3=0,0,E21/$H$3)","v":0}]
["CONSTRUCTION"]
["Construction",null,null,null,null,{"$f":"IF($E$124=0,0,E23/$E$124)","v":0},{"$f":"IF($H$2=0,0,E23/$H$2)","v":0},{"$f":"IF($H$3=0,0,E23/$H$3)","v":0}]
["Site Work (incl. Public Work)",null,null,null,null,0,{"$f":"IF($H$2=0,0,E24/$H$2)","v":0},{"$f":"IF($H$3=0,0,E24/$H$3)","v":0}]
["Environmental Remediation",null,null,null,null,0,0,0]
["Profit",null,null,null,null,0,0,0]
["Overhead",null,null,null,null,0,0,0]
["General Conditions/Requirements",null,null,null,null,0,0,0]
["Bond Premium",null,null,null,null,0,0,0]
["Contingency",null,null,null,null,0,0,0]
["Other Construction Cost 1",null,null,null,null,0,0,0]
["Other Construction Cost 2",null,null,null,null,0,0,0]
["Other Construction Cost 3",null,null,null,null,0,0,0]
["Other Construction Cost 4",null,null,null,null,0,0,0]
["Other Construction Cost 5",null,null,null,null,0,0,0]
["Total Construction Costs",null,null,null,{"$f":"SUM(E23:E35)","v":0},0,0,0]
["SOFT COSTS"]
["Architect & Engineer ",null,null,null,null,{"$f":"IF($E$124=0,0,E38/$E$124)","v":0},{"$f":"IF($H$2=0,0,E38/$H$2)","v":0},{"$f":"IF($H$3=0,0,E38/$H$3)","v":0}]
["Architect & Engineer Supervision",null,null,null,null,0,{"$f":"IF($H$2=0,0,E39/$H$2)","v":0},{"$f":"IF($H$3=0,0,E39/$H$3)","v":0}]
["A&E Reimbursables (Cost Review, LEED Cert)",null,null,null,null,0,0,0]
["Owner's Rep (Construction Monitoring)",null,null,null,null,0,0,0]
["Borrower Legal",null,null,null,null,0,0,0]
["Appraisal",null,null,null,null,0,0,0]
["Permits and Tap Fees (Incl. Permit Expediter)",null,null,null,null,0,0,0]
["Builder's Risk Insurance",null,null,null,null,0,0,0]
["Bond Premium",null,null,null,null,0,0,0]
["Market Study",null,null,null,null,0,0,0]
["Environmental & Soil Reports",null,null,null,null,0,0,0]
["Testing and Inspection",null,null,null,null,0,0,0]
["Title, Transfer and Recordation",null,null,null,null,0,0,0]
["Interim Insurance",null,null,null,null,0,0,0]
["Interim Taxes",null,null,null,null,0,0,0]
["Accounting Fees and Cost Cert.",null,null,null,null,0,0,0]
["Marketing",null,null,null,null,0,0,0]
["Survey",null,null,null,null,0,0,0]
["FFE",null,null,null,null,0,0,0]
["Tenant Improvements",null,null,null,null,0,0,0]
["Soft Cost Contingency",null,null,null,null,0,0,0]
["Other Soft Cost 1",null,null,null,null,0,0,0]
["Other Soft Cost 2",null,null,null,null,0,0,0]
["Other Soft Cost 3",null,null,null,null,0,0,0]
["Other Soft Cost 4",null,null,null,null,0,0,0]
["Other Soft Cost 5",null,null,null,null,0,0,0]
["Total Soft Costs",null,null,null,{"$f":"SUM(E38:E63)","v":0},0,0,0]
["FINANCING"]
["DCHFA Bond Application Fee",null,null,null,null,{"$f":"IF($E$124=0,0,E66/$E$124)","v":0},{"$f":"IF($H$2=0,0,E66/$H$2)","v":0},{"$f":"IF($H$3=0,0,E66/$H$3)","v":0}]
["DCHFA McKinney Application Fee",null,null,null,null,0,{"$f":"IF($H$2=0,0,E67/$H$2)","v":0},{"$f":"IF($H$3=0,0,E67/$H$3)","v":0}]
["DCHFA McKinney Financing Fee",null,null,null,null,0,0,0]
["DCHFA Financing Fee",null,null,null,null,0,0,0]
["DCHFA Construction Monitoring Fee",null,null,null,null,0,0,0]
["DCHFA/Issuer's Counsel Fee",null,null,null,null,0,0,0]
["Bond Counsel",null,null,null,null,0,0,0]
["Bond Purchaser's Fee",null,null,null,null,0,0,0]
["Bond Purchaser Counsel",null,null,null,null,0,0,0]
["Underwriter Fee",null,null,null,null,0,0,0]
["Underwriter's Counsel",null,null,null,null,0,0,0]
["Trustee Set Up Fee/ Legal",null,null,null,null,0,0,0]
["Rating Agency/Printing Fees",null,null,null,null,0,0,0]
["Negative Arbitrage",null,null,null,null,0,0,0]
["DCHFA Issure Fee (ST Construction Period)",null,null,null,null,0,0,0]
["DCHFA Issuer Fee (LT Construction Period)",null,null,null,null,0,0,0]
["DCHFA LIHTC Allocation Fee",null,null,null,null,0,0,0]
["DHCD LIHTC Allocation Fee",null,null,null,null,0,0,0]
["Tax Credit Fees/Legal",null,null,null,null,0,0,0]
["Construction Period Interest-Capitalized",null,null,null,null,0,0,0]
["Construction LoC Fee",null,null,null,null,0,0,0]
["Construction LoC Annual Fee",null,null,null,null,0,0,0]
["Construction Lender's Fee",null,null,null,null,{"$f":"IF($E$124=0,0,E88/$E$124)","v":0},0,0]
["Construction Lender's Counsel",null,null,null,null,0,0,0]
["Construction Lender's Inspection Fee",null,null,null,null,0,0,0]
["Conversion Fee",null,null,null,null,0,0,0]
["Permanent Lender Financing Fee",null,null,null,null,0,0,0]
["Permanent Lender Inspection Fee",null,null,null,null,0,0,0]
["Permanent Lender Counsel Fee",null,null,null,null,0,0,0]
["Freddie Mac Commitment Fee",null,null,null,null,0,0,0]
["Freddie Mac Standby Fee",null,null,null,null,0,0,0]
["Freddie Mac Counsel",null,null,null,null,0,0,0]
["Financial Advisor",null,null,null,null,0,0,0]
["Cash Flow Verification Analyst",null,null,null,null,0,0,0]
["GIC Brokerage Fee",null,null,null,null,0,0,0]
["Financing Contingency",null,null,null,null,0,0,0]
["McKinney Interest",null,null,null,null,0,0,0]
["Other Financing Cost 1",null,null,null,null,0,0,0]
["Other Financing Cost 2",null,null,null,null,0,0,0]
["Other Financing Cost 3",null,null,null,null,0,0,0]
["Other Financing Cost 4",null,null,null,null,0,0,0]
["Other Financing Cost 5",null,null,null,null,0,0,0]
["Total Financing Costs",null,null,null,{"$f":"SUM(E66:E107)","v":0},0,0,0]
["DEVELOPER FEE"]
["Developer Overhead",null,null,null,null,{"$f":"IF($E$124=0,0,E110/$E$124)","v":0},{"$f":"IF($H$2=0,0,E110/$H$2)","v":0},{"$f":"IF($H$3=0,0,E110/$H$3)","v":0}]
["Developer Fee",null,null,null,null,{"$f":"IF($E$124=0,0,E111/$E$124)","v":0},{"$f":"IF($H$2=0,0,E111/$H$2)","v":0},{"$f":"IF($H$3=0,0,E111/$H$3)","v":0}]
["Total Developer Fee",null,null,null,{"$f":"SUM(E110:E111)","v":0},{"$f":"IF($E$124=0,0,E112/$E$124)","v":0},0,0]
["GUARANTEES AND RESERVES"]
["Operating Reserve",null,null,null,null,{"$f":"IF($E$124=0,0,E114/$E$124)","v":0},{"$f":"IF($H$2=0,0,E114/$H$2)","v":0},{"$f":"IF($H$3=0,0,E114/$H$3)","v":0}]
["Replacement Reserve Deposit (Initial Payment)",null,null,null,null,0,{"$f":"IF($H$2=0,0,E115/$H$2)","v":0},{"$f":"IF($H$3=0,0,E115/$H$3)","v":0}]
["Debt Service Reserve",null,null,null,null,0,0,0]
["Lease Up Reserve",null,null,null,null,0,0,0]
["Other Reserves 1",null,null,null,null,0,0,0]
["Other Reserves 2",null,null,null,null,0,0,0]
["Other Reserves 3",null,null,null,null,0,0,0]
["Other Reserves 4",null,null,null,null,0,0,0]
["Other Reserves 5",null,null,null,null,0,0,0]
["Total Reserves and Escrows",null,null,null,{"$f":"SUM(E114:E122)","v":0},0,0,0]
["TOTAL PREDEVELOPMENT USES",null,null,null,{"$f":"SUM(E123,E112,E108,E36,E21,E64)","v":0},{"$f":"SUM(F123,F112,F108,F36,F21,F64)","v":0},{"$f":"SUM(G123,G112,G108,G36,G21,G64)","v":0},{"$f":"SUM(H123,H112,H108,H36,H21,H64)","v":0}]

{"sheet":"RENTAL_DEVELOPMENT_BUDGET","index":5,"n_rows":141,"n_cols":24,"rows_kept":141,"cut":false,"hidden":false,"merged":[[6,19,7,19],[6,20,7,20],[4,0,7,2],[4,3,7,3],[128,4,128,5],[4,4,7,4],[4,5,7,5],[48,0,50,2],[48,3,50,3],[48,4,50,4],[48,5,50,5],[96,0,98,2],[96,3,98,3],[96,4,98,4],[96,5,98,5],[140,4,140,5],[139,4,139,5],[126,9,126,23],[127,9,127,12],[128,9,134,12],[135,9,135,12],[135,17,135,23],[136,9,139,23],[131,4,131,5],[132,4,132,5],[133,4,133,5],[134,4,134,5],[137,4,137,5],[129,4,129,5],[130,4,130,5],[133,2,133,3],[138,2,138,3],[138,4,138,5],[128,13,134,23],[127,13,127,23],[6,21,7,21],[6,22,7,22],[6,23,7,23],[96,6,98,6],[96,7,98,7],[97,18,98,18],[48,6,50,6],[48,7,50,7],[49,18,50,18],[4,7,6,7],[4,6,7,6],[5,8,5,13],[5,14,5,17],[4,19,4,20],[4,8,4,13],[4,18,6,18]]}
["Incurred","Contract","Quote","Dev. Estimate",null,"CBE Committed"]
["DHCD- DEVELOPMENT BUDGET"]
["TOTAL DEVELOPMENT COSTS",null,null,null,null,null,null,null,null,"Total Residential Units",null,null,{"$f":"RENTAL_INCOME!D32","v":0},null,null,null,null,null,null,"Total Gross Square Footage",{"$f":"RENTAL_INCOME!C42","v":0}]
["Acquisition"]
["Type of Uses",null,null,"Total Budgeted Cost","% of  Cost","Cost per sq ft","Cost per unit","Residential Percentage","RESIDENTIAL",null,null,null,null,null,null,null,null,null,"Non-Residential Percentage","NON-RESIDENTIAL"]
[null,null,null,null,null,null,null,null,"Sources for DHCD Eligible Units/Uses",null,null,null,null,null,"Souces for DHCD Ineligible Units/Uses",null,null,null,null,"Source:","Source:","Source:","Source:","Source:"]
[null,null,null,null,null,null,null,null,"Source:","Source:","Source:","Source:","Source:","Source:","Source:","Source:","Source:","Source:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1-H8","v":1}]
["Acquisition",null,null,null,{"$f":"IF($D$16=0,0,D9/$D$16)","v":0},{"$f":"IF($U$3=\"\",0,D9/$U$3)","v":0},{"$f":"IF($M$3=\"\",0,D9/$M$3)","v":0},{"$f":"$H$8*D9","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D9-H9","v":0}]
["Land Costs",null,null,null,{"$f":"IF($D$16=0,0,D10/$D$16)","v":0},0,{"$f":"IF($M$3=\"\",0,D10/$M$3)","v":0},{"$f":"$H$8*D10","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D10-H10","v":0}]
["Other Acquisition Costs 1",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Acquisition Costs 2",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Acquisition Costs 3",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Acquisition Costs 4",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Acquisition Costs 5",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Total Acquisition Costs",null,null,{"$f":"SUM(D9:D15)","v":0},{"$f":"IF($D$125=0,0,D16/$D$125)","v":0},{"$f":"SUM(F9:F15)","v":0},0,0,0,{"$f":"SUM(J9:J15)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U9:U15)","v":0},0,0,0]
["Construction Costs"]
["Construction Costs",null,null,null,{"$f":"IF($D$31=0,0,D18/$D$31)","v":0},{"$f":"IF($U$3=\"\",0,D18/$U$3)","v":0},{"$f":"IF($M$3=\"\",0,D18/$M$3)","v":0},{"$f":"$H$8*D18","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D18-H18","v":0}]
["Site work (Incl. Public Work)",null,null,null,{"$f":"IF($D$31=0,0,D19/$D$31)","v":0},0,{"$f":"IF($M$3=\"\",0,D19/$M$3)","v":0},{"$f":"$H$8*D19","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D19-H19","v":0}]
["Environmental Remediation",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Profit",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Overhead",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["General Conditions/Requirements",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Bond Premium",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Contingency",null,null,null,{"$f":"IF($D$31=0,0,D25/($D$31-D25))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Construction Cost 1",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Construction Cost 2",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Construction Cost 3",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Construction Cost 4",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Construction Cost 5",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Total Construction Costs",null,null,{"$f":"SUM(D18:D30)","v":0},{"$f":"IF($D$125=0,0,D31/$D$125)","v":0},{"$f":"SUM(F18:F30)","v":0},0,{"$f":"SUM(H18:H30)","v":0},{"$f":"SUM(I18:I30)","v":0},{"$f":"SUM(J18:J30)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(S18:S30)","v":0},{"$f":"SUM(T18:T30)","v":0},{"$f":"SUM(U18:U30)","v":0},0,0,0]
["Soft Costs"]
["Architect & Engineer",null,null,null,{"$f":"IF($D$62=0,0,D33/$D$62)","v":0},{"$f":"IF($U$3=\"\",0,D33/$U$3)","v":0},{"$f":"IF($M$3=\"\",0,D33/$M$3)","v":0},{"$f":"$H$8*D33","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D33-H33","v":0}]
["Architect & Engineer Supervision",null,null,null,{"$f":"IF($D$62=0,0,D34/$D$62)","v":0},0,{"$f":"IF($M$3=\"\",0,D34/$M$3)","v":0},{"$f":"$H$8*D34","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D34-H34","v":0}]
["A&E Reimbursables (Cost Review, LEED)",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Owner's Rep (Construction Monitoring)",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Borrower Legal",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Appraisal",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Permits and Tap Fees (Incl Expediter)",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Builder's Risk Insurance",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Bond Premium",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Market Study",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Environmental & Soil Reports",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Testing and Inspection ",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Title, Transfer and Recordation",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Interim Insurance",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Interim Taxes",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Accounting Fees & Cost Certification",null,null,null,{"$f":"IF($D$62=0,0,D48/$D$62)","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Type of Uses",null,null,"Total Budgeted Cost","% of Total  Cost","Cost per sq ft","Cost per unit","Residential Total","RESIDENTIAL",null,null,null,null,null,null,null,null,null,"NON-RESIDENTIAL"]
[null,null,null,null,null,null,null,null,"Source:","Source:","Source:","Source:","Source:","Source:","Source:","Source:","Source:","Source:","Non-Residential Total","Source:","Source:","Source:","Source:","Source:"]
[null,null,null,null,null,null,null,null,{"$f":"I8","v":0},{"$f":"J8","v":0},{"$f":"K8","v":0},0,0,0,0,0,0,0,null,{"$f":"T8","v":0},{"$f":"U8","v":0},0,0,0]
["Marketing",null,null,null,{"$f":"IF($D$62=0,0,D52/$D$62)","v":0},{"$f":"IF($U$3=\"\",0,D52/$U$3)","v":0},{"$f":"IF($M$3=\"\",0,D52/$M$3)","v":0},{"$f":"$H$8*D52","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D52-H52","v":0}]
["Survey",null,null,null,{"$f":"IF($D$62=0,0,D53/$D$62)","v":0},0,0,{"$f":"$H$8*D53","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D53-H53","v":0}]
["FFE",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Tenant Improvements",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Soft Cost Contingency",null,null,null,{"$f":"IF($D$62=0,0,D56/($D$62-D56))","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Soft Cost 1",null,null,null,{"$f":"IF($D$62=0,0,D57/$D$62)","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Soft Cost 2",null,null,null,{"$f":"IF($D$62=0,0,D58/$D$62)","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Soft Cost 3",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Soft Cost 4",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Soft Cost 5",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Total Soft Costs",null,null,{"$f":"+SUM(D33:D48,D52:D61)","v":0},{"$f":"IF($D$25=0,0,D62/$D$125)","v":0},{"$f":"SUM(F33:F61)","v":0},0,0,0,0,{"$f":"SUM(K33:K61)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(U33:U61)","v":0},0,0,0]
["Financing Costs"]
["DCHFA Bond Application Fee",null,null,null,{"$f":"IF($D$109=0,0,D64/$D$109)","v":0},{"$f":"IF($U$3=\"\",0,D64/$U$3)","v":0},{"$f":"IF($M$3=\"\",0,D64/$M$3)","v":0},{"$f":"$H$8*D64","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D64-H64","v":0}]
["DCHFA McKinney Application Fee",null,null,null,{"$f":"IF($D$109=0,0,D65/$D$109)","v":0},0,{"$f":"IF($M$3=\"\",0,D65/$M$3)","v":0},{"$f":"$H$8*D65","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D65-H65","v":0}]
["DCHFA McKinney Financing Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["DCHFA Financing Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["DCHFA Construction Monitoring Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["DCHFA/Issuer's Counsel Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Bond Counsel",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Bond Purchaser's Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Bond Purchaser Counsel",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Underwriter Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Underwriter's Counsel",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Trustee Set Up Fee/ Legal",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Rating Agency/Printing Fees",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Negative Arbitrage",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["DCHFA Issuer Fee (ST Construction Period)",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["DCHFA Issuer Fee (LT Construction Period)",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["DCHFA LIHTC Allocation Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["DHCD LIHTC Allocation Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Tax Credit Fees/Legal",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Construction Period Interest-Capitalized",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Construction LoC Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Construction LoC Annual Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Construction Lender's Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Construction Lender's Counsel",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Construction Lender's Inspection Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Conversion Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Permanent Lender Financing Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Permanent Lender Inspection Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Permanent Lender Counsel Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Freddie Mac Commitment Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Freddie Mac Standby Fee",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Freddie Mac Counsel",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Financial Advisor",null,null,null,0,0,{"$f":"IF($M$3=\"\",0,D96/$M$3)","v":0},0,null,null,null,null,null,null,null,null,null,null,0]
["Type of Uses",null,null,"Total Budgeted Cost","% of Total  Cost","Cost per sq ft","Cost per unit","Residential Total","RESIDENTIAL",null,null,null,null,null,null,null,null,null,"NON-RESIDENTIAL"]
[null,null,null,null,null,null,null,null,"Source:","Source:","Source:","Source:","Source:","Source:","Source:","Source:","Source:","Source:","Non-Residential Total","Source:","Source:","Source:","Source:","Source:"]
[null,null,null,null,null,null,null,null,{"$f":"I8","v":0},0,{"$f":"K8","v":0},0,0,0,0,0,0,0,null,{"$f":"T8","v":0},{"$f":"U8","v":0},0,0,0]
["Cash Flow Verification Analyst",null,null,null,{"$f":"IF($D$109=0,0,D100/$D$109)","v":0},{"$f":"IF($U$3=\"\",0,D100/$U$3)","v":0},{"$f":"IF($M$3=\"\",0,D100/$M$3)","v":0},{"$f":"$H$8*D100","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D100-H100","v":0}]
["GIC Brokerage Fee",null,null,null,{"$f":"IF($D$109=0,0,D101/$D$109)","v":0},0,0,{"$f":"$H$8*D101","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D101-H101","v":0}]
["Financing Contingency",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["McKinney Interest",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Financing Cost 1",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Financing Cost 2",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Financing Cost 3",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Financing Cost 4",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Financing Cost 5",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Total Financing Costs",null,null,{"$f":"+SUM(D64:D96,D100:D108)","v":0},{"$f":"IF($D$125=0,0,D109/$D$125)","v":0},{"$f":"+SUM(F64:F108)","v":0},{"$f":"+SUM(G64:G108)","v":0},{"$f":"SUM(H64:H108)","v":0},0,0,{"$f":"SUM(K64:K108)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(U64:U108)","v":0},0,0,0]
["Developer's Fee"]
["Fee on Non-Acquisition Costs",null,null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!E135","v":0},{"$f":"IF($D$125=0,0,D111/$D$125)","v":0},{"$f":"IF(U3=\"\",0,D111/$U$3)","v":0},{"$f":"IF($M$3=\"\",0,D111/$M$3)","v":0},{"$f":"$H$8*D111","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D111-H111","v":0}]
["Fee on Acquisition Costs ",null,null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!E140","v":0},{"$f":"IF($D$125=0,0,D112/$D$125)","v":0},{"$f":"IF(X4=\"\",0,D112/$U$3)","v":0},{"$f":"IF($M$3=\"\",0,D112/$M$3)","v":0},{"$f":"$H$8*D112","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D112-H112","v":0}]
[" Total Developer's Fee",null,null,{"$f":"D111+D112","v":0},{"$f":"IF($D$125=0,0,D113/$D$125)","v":0},{"$f":"IF(X5=\"\",0,D113/$U$3)","v":0},{"$f":"IF($M$3=\"\",0,D113/$M$3)","v":0},{"$f":"SUM(H111:H112)","v":0},{"$f":"SUM(I111:I112)","v":0},{"$f":"SUM(J111:J112)","v":0},{"$f":"SUM(K111:K112)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(S111:S112)","v":0},{"$f":"SUM(T111:T112)","v":0},{"$f":"SUM(U111:U112)","v":0},0,0,0]
["Guarantees and Reserves (funded amounts only)"]
["Operating Reserve",null,null,null,{"$f":"IF($D$124=0,0,D115/$D$124)","v":0},{"$f":"IF($U$3=\"\",0,D115/$U$3)","v":0},{"$f":"IF($M$3=\"\",0,D115/$M$3)","v":0},{"$f":"$H$8*D115","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D115-H115","v":0}]
["Replacement Reserve Deposit (Initial Payment)",null,null,0,{"$f":"IF($D$124=0,0,D116/$D$124)","v":0},0,0,{"$f":"$H$8*D116","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"D116-H116","v":0}]
["Debt Service Reserve",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Lease Up Reserve",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Reserve 1",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Reserve 2",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Reserve 3",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Reserve 4",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Other Reserve 5",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0]
["Total Guarantees and Reserves",null,null,{"$f":"SUM(D115:D123)","v":0},{"$f":"IF($D$125=0,0,D124/$D$125)","v":0},{"$f":"SUM(F115:F123)","v":0},0,{"$f":"SUM(H115:H123)","v":0},0,0,{"$f":"SUM(K115:K123)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(U115:U123)","v":0},0,0,0]
["Total Uses of Funds",null,null,{"$f":"SUM(D124,D113,D62,D109,D31,D16)","v":0},{"$f":"SUM(E124,E113,E62,E109,E31,E16)","v":0},0,0,0,{"$f":"SUM(I124,I113,I62,I109,I31,I16)","v":0},0,{"$f":"SUM(K124,K113,K62,K109,K31,K16)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(U124,U113,U62,U109,U31,U16)","v":0},0,0,0]
["MAXIMUM DEVELOPER'S FEE"]
[null,null,null,null,null,null,null,null,null,"Maximum Developer Fee Calculation"]
["Fee on Non-acquisition Costs",null,null,null,null,null,null,null,null,"Fee on Development Costs",null,null,null,"Fee on Acquisition Costs"]
["Total Development Costs ",null,null,null,{"$f":"D16+D31+D62+(D109-SUM(D64,D67:D74,D78:D82,D102))","v":0},null,null,null,null,"Total development costs do no include the following:  hard or soft cost contingencies, syndication related costs; funded guarantee and reserve accounts that are required by lenders or investors; and developers' fees",null,null,null,"If there is an identity of interest between the seller and the purchaser, no fee shall be calculated on the acquisition price"]
["Less Acquisition Costs ",null,null,null,{"$f":"-D16","v":0}]
["Less Construction Contingency",null,null,null,{"$f":"-D25","v":0}]
["Less Soft Cost + Financing Contingency ",null,null,null,{"$f":"-D102-D56","v":0}]
["Non Acquisition Fee Basis",null,null,null,{"$f":"SUM(E129:E132)","v":0}]
[null,null,"Fee Percentage: ",null,0.15,null,"Cost/ sq ft","Cost per unit"]
["Fee on Non-acquisition Costs",null,null,null,{"$f":"E133*E134","v":0},null,{"$f":"IF($U$3=\"\",0,E135/$U$3)","v":0},{"$f":"IF(M3=\"\",0,E135/$M$3)","v":0}]
[null,null,null,null,null,null,null,null,null,0.15,null,null,null,null,null,null,null,0.05]
["Fee on Acquisition Costs",null,null,null,null,null,null,null,null,"Any fee in excess of $2 million shall be deferred up to the amount that can be recovered from cash flow over 12 years of operations.  Amounts that cannot be repaid during this period will be added to the initial $2 million paid fee."]
["Acquisition Costs",null,null,null,{"$f":"D16","v":0}]
[null,null,"Fee Percentage: ",null,0.05,null,"Cost/ sq ft","Cost per unit"]
["Fee on Acquisition Costs",null,null,null,{"$f":"E138*E139","v":0},null,{"$f":"IF($U$3=\"\",0,E140/$U$3)","v":0},{"$f":"IF(M3=\"\",0,E140/$M$3)","v":0}]
["Total Developer's Fee ",null,null,null,{"$f":"E135+E140","v":0},null,{"$f":"IF(U3=\"\",0,E141/RENTAL_DEVELOPMENT_BUDGET!$U$3)","v":0},{"$f":"IF(M3=\"\",0,E141/$M$3)","v":0}]

{"sheet":"RENTAL_SOURCES","index":6,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,1,10],[2,0,2,10],[4,0,4,1],[9,2,9,3],[4,2,4,3],[7,2,7,3],[5,2,5,3],[6,2,6,3],[8,2,8,3],[23,6,23,7],[44,2,44,3],[45,2,45,3],[13,0,13,1],[13,2,13,3],[14,2,14,3],[40,0,40,1],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[15,2,15,3],[25,0,25,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[34,7,34,8],[32,7,32,8],[31,7,31,8],[13,6,13,7],[14,8,14,9],[15,8,15,9],[14,6,14,7],[15,6,15,7],[13,8,13,9],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[24,6,24,7],[25,6,25,7]]}
[null,"Yes","No","Must pay","Cashflow","Deferred","Construction","Permanent"]
["SOURCES OF FUNDS"]
[]
["PERMANENT DEBT (NON-DHCD, DHCD LOAN AMOUNT CALCULATED BELOW)"]
["Type of Funds",null,"Source of Funds/Lender",null,"Payment Type ","Debt Coverage ","Annual Payment","Interest Rate","Amortization Period","Loan Term","Loan Amount"]
["1st Mortgage"]
["Other Permanent Debt 1"]
["Other Permanent Debt 2"]
["Other Permanent Debt 3"]
["Other Permanent Debt 4"]
["Total Permanent Debt Financing",null,null,null,null,null,{"$f":"+SUM(G6:G10)","v":0},null,null,null,{"$f":"SUM(IF(ISBLANK(K6),0,K6)+IF(ISBLANK(K7),0,K7)+IF(ISBLANK(K8),0,K8)+IF(ISBLANK(K9),0,K9)+IF(ISBLANK(K10),0,K10))","v":0}]
[]
["GRANTS"]
["Type of Funds",null,"Source of Funds",null,"Recoverable?","Provided At:","Grant Term (if recoverable)",null,null,null,"Grant Amount"]
["Other"]
["Other"]
["Total Grant Funding",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K15:K16)","v":0}]
[]
["EQUITY"]
["Type of Equity",null,null,"Source of Equity",null,null,"Equity Pricing",null,null,null,"Amount"]
["LIHTC Equity ",null,null,null,null,null,null,null,null,null,{"$f":"LIHTC_EQUITY!I33","v":0}]
["Other Tax Credit Equity (Solar, Historic, NMTC, Etc.)"]
["Deferred Developer Fee",null,null,"Deferred Developer Fee"]
["Developer Equity (not syndication proceeds)",null,null,"Seller's Note/equity contribution"]
["Other Developer Equity (not syndication proceeds)",null,null,"Other Developer Equity"]
["Interim Income (occupied rehab projects)"]
["Total Equity",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K21:K26)","v":0}]
["Total Sources of Funds (Total Permanent Debt and Grants+ Equity)",null,null,null,null,null,null,null,null,null,{"$f":"K11+K17+K27","v":0}]
[]
["DHCD Loan Amount (HPTF/HOME/CDBG/Etc.)",null,null,null,null,null,"DHCD Loan Terms:"]
["Total Uses of Funds (from previous section)",null,null,null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D125","v":0}]
["Permanent Debt Financing -- non DHCD (from above)",null,null,null,{"$f":"K11","v":0},null,"Interest Rate:",0.03]
["Grant Funding (from above)",null,null,null,{"$f":"K17","v":0},null,"Loan Term:","40 Years"]
["LIHTC Equity (from above)",null,null,null,{"$f":"K21","v":0},null,"Repayment:",0.75,"of Cash Flow"]
["Other Tax Credit Equity (from above)",null,null,null,{"$f":"K22","v":0},null,"Affordability:","40 Years"]
["Deferred Developer Fee",null,null,null,{"$f":"K23","v":0}]
["Developer Equity and Interim Income (from above)",null,null,null,{"$f":"SUM(K24:K26)","v":0}]
["Maximum DHCD Loan Amount",null,null,null,{"$f":"E31-SUM(E32:E37)","v":0}]
[]
["CONSTRUCTION DEBT"]
["Type of Funds",null,"Source of Funds/Lender",null,"Payment Type ","Source of Repayment","Amortizing?","Interest Rate","Amortization Period","Loan Term (Months)","Loan Amount"]
["Construction Loan"]
["HPTF/HOME/CDBG/Etc.",null,"DHCD",null,"Cashflow","Cashflow","No",{"$f":"H32","v":0.03},"N/A",{"$f":"H33","v":"40 Years"},{"$f":"E38","v":0}]
["Other Construction Debt 1"]
["Other Construction Debt 2"]
["Other Construction Debt 3"]
["Total Construction Debt",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K42:K46)","v":0}]

{"sheet":"RENTAL_PRO_FORMA","index":7,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"First full year of operations",null,null,null,null,null,null,null,null,null,null,"First full year of operations",{"$f":"F1","v":0}]
[null,null,null,null,"Annual Income Trending",0.02,null,null,null,null,null,null,null,null,null,"Annual Income Trending",{"$f":"F2","v":0.02}]
[null,null,null,null,"Annual Expense Trending",0.03,null,null,null,null,null,null,null,null,null,"Annual Expense Trending",{"$f":"F3","v":0.03}]
[null,null,null,null,"Years Until Sustaining Occupancy",null,null,null,null,null,null,null,null,null,null,"Years Until Sustaining Occupancy",{"$f":"F4","v":0}]
["20-YR OP. PRO FORMA"]
["Income",null,"Year 0","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20"]
["Low Income Units",null,{"$f":"RENTAL_INCOME!K32-C8","v":0},{"$f":"C7*($F$2+1)^($F$4+1)","v":0},{"$f":"D7*($F$2+1)","v":0},{"$f":"E7*($F$2+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Market Rate Units",null,{"$f":"SUMIF(RENTAL_INCOME!C7:C31,\"Market\",RENTAL_INCOME!K7:K31)","v":0},{"$f":"C8*(F2+1)^(F4+1)","v":0},{"$f":"D8*($F$2+1)","v":0},{"$f":"E8*($F$2+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Nonresidential",null,{"$f":"RENTAL_INCOME!K52","v":0},{"$f":"C9*(F2+1)^(F4+1)","v":0},{"$f":"D9*($F$2+1)","v":0},{"$f":"E9*($F$2+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gross Project Income",null,{"$f":"SUM(C7:C9)","v":0},{"$f":"SUM(D7:D9)","v":0},{"$f":"SUM(E7:E9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Vacancy Allowance",null,{"$f":"-(C7*RENTAL_INCOME!$F$33+C8*RENTAL_INCOME!$F$33+C9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(D7*RENTAL_INCOME!$F$33+D8*RENTAL_INCOME!$F$33+D9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(E7*RENTAL_INCOME!$F$33+E8*RENTAL_INCOME!$F$33+E9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(F7*RENTAL_INCOME!$F$33+F8*RENTAL_INCOME!$F$33+F9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(G7*RENTAL_INCOME!$F$33+G8*RENTAL_INCOME!$F$33+G9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(H7*RENTAL_INCOME!$F$33+H8*RENTAL_INCOME!$F$33+H9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(I7*RENTAL_INCOME!$F$33+I8*RENTAL_INCOME!$F$33+I9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(J7*RENTAL_INCOME!$F$33+J8*RENTAL_INCOME!$F$33+J9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(K7*RENTAL_INCOME!$F$33+K8*RENTAL_INCOME!$F$33+K9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(L7*RENTAL_INCOME!$F$33+L8*RENTAL_INCOME!$F$33+L9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(M7*RENTAL_INCOME!$F$33+M8*RENTAL_INCOME!$F$33+M9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(N7*RENTAL_INCOME!$F$33+N8*RENTAL_INCOME!$F$33+N9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(O7*RENTAL_INCOME!$F$33+O8*RENTAL_INCOME!$F$33+O9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(P7*RENTAL_INCOME!$F$33+P8*RENTAL_INCOME!$F$33+P9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(Q7*RENTAL_INCOME!$F$33+Q8*RENTAL_INCOME!$F$33+Q9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(R7*RENTAL_INCOME!$F$33+R8*RENTAL_INCOME!$F$33+R9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(S7*RENTAL_INCOME!$F$33+S8*RENTAL_INCOME!$F$33+S9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(T7*RENTAL_INCOME!$F$33+T8*RENTAL_INCOME!$F$33+T9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(U7*RENTAL_INCOME!$F$33+U8*RENTAL_INCOME!$F$33+U9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(V7*RENTAL_INCOME!$F$33+V8*RENTAL_INCOME!$F$33+V9*RENTAL_INCOME!$F$53)","v":0},{"$f":"-(W7*RENTAL_INCOME!$F$33+W8*RENTAL_INCOME!$F$33+W9*RENTAL_INCOME!$F$53)","v":0}]
["Effective Gross Income",null,{"$f":"C10+C11","v":0},{"$f":"D10+D11","v":0},{"$f":"E10+E11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Expenses"]
["Administrative",null,{"$f":"RENTAL_EXPENSES!D24-RENTAL_EXPENSES!D10","v":0},{"$f":"(RENTAL_EXPENSES!D24-RENTAL_EXPENSES!D10)*($F$3+1)^($F$4+1)","v":0},{"$f":"D15*($F$3+1)","v":0},{"$f":"E15*($F$3+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Management Fee",null,{"$f":"C12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"D12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"E12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"F12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"G12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"H12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"I12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"J12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"K12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"L12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"M12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"N12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"O12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"P12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"Q12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"R12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"S12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"T12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"U12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"V12*RENTAL_EXPENSES!$B$10","v":0},{"$f":"W12*RENTAL_EXPENSES!$B$10","v":0}]
["Utilities",null,{"$f":"RENTAL_EXPENSES!D35","v":0},{"$f":"RENTAL_EXPENSES!D35*($F$3+1)^($F$4+1)","v":0},{"$f":"D17*($F$3+1)","v":0},{"$f":"E17*($F$3+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Maintenance",null,{"$f":"RENTAL_EXPENSES!D62","v":0},{"$f":"RENTAL_EXPENSES!D62*($F$3+1)^($F$4+1)","v":0},{"$f":"D18*($F$3+1)","v":0},{"$f":"E18*($F$3+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q18*($F$3+1)","v":0},0,0,0,0,0]
["Taxes and Insurance",null,{"$f":"RENTAL_EXPENSES!D77","v":0},{"$f":"RENTAL_EXPENSES!D77*($F$3+1)^($F$4+1)","v":0},{"$f":"D19*($F$3+1)","v":0},{"$f":"E19*($F$3+1)","v":0},{"$f":"F19*($F$3+1)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q19*($F$3+1)","v":0},{"$f":"R19*($F$3+1)","v":0},0,0,0,0]
["Reserves (includes operating)",null,{"$f":"RENTAL_EXPENSES!D79+RENTAL_EXPENSES!D80","v":0},{"$f":"(RENTAL_EXPENSES!D79+RENTAL_EXPENSES!D80)*($F$3+1)^($F$4+1)","v":0},{"$f":"D20*($F$3+1)","v":0},{"$f":"E20*($F$3+1)","v":0},{"$f":"F20*($F$3+1)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"Q20*($F$3+1)","v":0},0,0,0,0,0]
["Total Expenses",null,{"$f":"SUM(C15:C20)","v":0},{"$f":"SUM(D15:D20)","v":0},{"$f":"SUM(E15:E20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Net Operating Income",null,{"$f":"C12-C21","v":0},{"$f":"D12-D21","v":0},{"$f":"E12-E21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Primary Debt Service Financing"]
[{"$f":"RENTAL_SOURCES!A6","v":"1st Mortgage"},null,{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0},{"$f":"RENTAL_SOURCES!$G$6","v":0}]
[{"$f":"RENTAL_SOURCES!A7","v":"Other Permanent Debt 1"},null,{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0},{"$f":"RENTAL_SOURCES!$G$7","v":0}]
[{"$f":"RENTAL_SOURCES!A8","v":"Other Permanent Debt 2"},null,{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0},{"$f":"RENTAL_SOURCES!$G$8","v":0}]
[{"$f":"RENTAL_SOURCES!A9","v":"Other Permanent Debt 3"},null,{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0},{"$f":"RENTAL_SOURCES!$G$9","v":0}]
[{"$f":"RENTAL_SOURCES!A10","v":"Other Permanent Debt 4"},null,{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0},{"$f":"RENTAL_SOURCES!$G$10","v":0}]
["Total Primary Debt Service",null,{"$f":"SUM(C25:C29)","v":0},{"$f":"SUM(D25:D29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cash Flow",null,{"$f":"C22-C30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Debt Coverage Ratio",null,{"$f":"IF(C30=0,\"\",C22/C30)","v":""},{"$f":"IF(D30=0,\"\",D22/D30)","v":""},"","","","","","","","","","","","","","","","","","",""]
[]
["Subordinate Payments"]
["Deferred Developer Fee",null,{"$f":"IF(SUM($C$31:C31)<RENTAL_SOURCES!$K$23,IF(C31>(SUM($C$31:C31)-RENTAL_SOURCES!$K$23),C31,SUM($C$31:C31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-C31,0))","v":0},{"$f":"IF(SUM($C$31:D31)<RENTAL_SOURCES!$K$23,IF(D31>(SUM($C$31:D31)-RENTAL_SOURCES!$K$23),D31,SUM($C$31:D31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:C35),0))","v":0},{"$f":"IF(SUM($C$31:E31)<RENTAL_SOURCES!$K$23,IF(E31>(SUM($C$31:E31)-RENTAL_SOURCES!$K$23),E31,SUM($C$31:E31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:D35),0))","v":0},{"$f":"IF(SUM($C$31:F31)<RENTAL_SOURCES!$K$23,IF(F31>(SUM($C$31:F31)-RENTAL_SOURCES!$K$23),F31,SUM($C$31:F31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:E35),0))","v":0},{"$f":"IF(SUM($C$31:G31)<RENTAL_SOURCES!$K$23,IF(G31>(SUM($C$31:G31)-RENTAL_SOURCES!$K$23),G31,SUM($C$31:G31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:F35),0))","v":0},{"$f":"IF(SUM($C$31:H31)<RENTAL_SOURCES!$K$23,IF(H31>(SUM($C$31:H31)-RENTAL_SOURCES!$K$23),H31,SUM($C$31:H31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:G35),0))","v":0},{"$f":"IF(SUM($C$31:I31)<RENTAL_SOURCES!$K$23,IF(I31>(SUM($C$31:I31)-RENTAL_SOURCES!$K$23),I31,SUM($C$31:I31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:H35),0))","v":0},{"$f":"IF(SUM($C$31:J31)<RENTAL_SOURCES!$K$23,IF(J31>(SUM($C$31:J31)-RENTAL_SOURCES!$K$23),J31,SUM($C$31:J31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:I35),0))","v":0},{"$f":"IF(SUM($C$31:K31)<RENTAL_SOURCES!$K$23,IF(K31>(SUM($C$31:K31)-RENTAL_SOURCES!$K$23),K31,SUM($C$31:K31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:J35),0))","v":0},{"$f":"IF(SUM($C$31:L31)<RENTAL_SOURCES!$K$23,IF(L31>(SUM($C$31:L31)-RENTAL_SOURCES!$K$23),L31,SUM($C$31:L31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:K35),0))","v":0},{"$f":"IF(SUM($C$31:M31)<RENTAL_SOURCES!$K$23,IF(M31>(SUM($C$31:M31)-RENTAL_SOURCES!$K$23),M31,SUM($C$31:M31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:L35),0))","v":0},{"$f":"IF(SUM($C$31:N31)<RENTAL_SOURCES!$K$23,IF(N31>(SUM($C$31:N31)-RENTAL_SOURCES!$K$23),N31,SUM($C$31:N31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:M35),0))","v":0},{"$f":"IF(SUM($C$31:O31)<RENTAL_SOURCES!$K$23,IF(O31>(SUM($C$31:O31)-RENTAL_SOURCES!$K$23),O31,SUM($C$31:O31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:N35),0))","v":0},{"$f":"IF(SUM($C$31:P31)<RENTAL_SOURCES!$K$23,IF(P31>(SUM($C$31:P31)-RENTAL_SOURCES!$K$23),P31,SUM($C$31:P31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:O35),0))","v":0},{"$f":"IF(SUM($C$31:Q31)<RENTAL_SOURCES!$K$23,IF(Q31>(SUM($C$31:Q31)-RENTAL_SOURCES!$K$23),Q31,SUM($C$31:Q31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:P35),0))","v":0},{"$f":"IF(SUM($C$31:R31)<RENTAL_SOURCES!$K$23,IF(R31>(SUM($C$31:R31)-RENTAL_SOURCES!$K$23),R31,SUM($C$31:R31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:Q35),0))","v":0},{"$f":"IF(SUM($C$31:S31)<RENTAL_SOURCES!$K$23,IF(S31>(SUM($C$31:S31)-RENTAL_SOURCES!$K$23),S31,SUM($C$31:S31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:R35),0))","v":0},{"$f":"IF(SUM($C$31:T31)<RENTAL_SOURCES!$K$23,IF(T31>(SUM($C$31:T31)-RENTAL_SOURCES!$K$23),T31,SUM($C$31:T31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:S35),0))","v":0},{"$f":"IF(SUM($C$31:U31)<RENTAL_SOURCES!$K$23,IF(U31>(SUM($C$31:U31)-RENTAL_SOURCES!$K$23),U31,SUM($C$31:U31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:T35),0))","v":0},{"$f":"IF(SUM($C$31:V31)<RENTAL_SOURCES!$K$23,IF(V31>(SUM($C$31:V31)-RENTAL_SOURCES!$K$23),V31,SUM($C$31:V31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:U35),0))","v":0},{"$f":"IF(SUM($C$31:W31)<RENTAL_SOURCES!$K$23,IF(W31>(SUM($C$31:W31)-RENTAL_SOURCES!$K$23),W31,SUM($C$31:W31)-RENTAL_SOURCES!$K$23),MAX(RENTAL_SOURCES!$K$23-SUM(RENTAL_PRO_FORMA!$C$35:V35),0))","v":0}]
["LP Asset Management Fee"]
["GP Asset Management Fee"]
["Other Subordinate Payment 3"]
["Other Subordinate Payment 4"]
["DHCD Repayment",null,{"$f":"RENTAL_SOURCES!$H$34*(IF(C31-SUM(C35:C39)>0,C31-SUM(C35:C39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(D31-SUM(D35:D39)>0,D31-SUM(D35:D39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(E31-SUM(E35:E39)>0,E31-SUM(E35:E39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(F31-SUM(F35:F39)>0,F31-SUM(F35:F39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(G31-SUM(G35:G39)>0,G31-SUM(G35:G39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(H31-SUM(H35:H39)>0,H31-SUM(H35:H39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(I31-SUM(I35:I39)>0,I31-SUM(I35:I39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(J31-SUM(J35:J39)>0,J31-SUM(J35:J39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(K31-SUM(K35:K39)>0,K31-SUM(K35:K39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(L31-SUM(L35:L39)>0,L31-SUM(L35:L39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(M31-SUM(M35:M39)>0,M31-SUM(M35:M39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(N31-SUM(N35:N39)>0,N31-SUM(N35:N39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(O31-SUM(O35:O39)>0,O31-SUM(O35:O39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(P31-SUM(P35:P39)>0,P31-SUM(P35:P39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(Q31-SUM(Q35:Q39)>0,Q31-SUM(Q35:Q39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(R31-SUM(R35:R39)>0,R31-SUM(R35:R39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(S31-SUM(S35:S39)>0,S31-SUM(S35:S39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(T31-SUM(T35:T39)>0,T31-SUM(T35:T39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(U31-SUM(U35:U39)>0,U31-SUM(U35:U39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(V31-SUM(V35:V39)>0,V31-SUM(V35:V39),0))","v":0},{"$f":"RENTAL_SOURCES!$H$34*(IF(W31-SUM(W35:W39)>0,W31-SUM(W35:W39),0))","v":0}]
["Total Cash Flow Debt",null,{"$f":"SUM(C35:C40)","v":0},{"$f":"SUM(D35:D40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Remaining Cash Flow",null,{"$f":"+C31-SUM(C35:C40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Accrued DHCD Interest",null,{"$f":"IF(RENTAL_SOURCES!$E$38*RENTAL_SOURCES!$H$43>C40,RENTAL_SOURCES!$E$38*RENTAL_SOURCES!$H$43-C40,0)","v":0},{"$f":"MAX(0,C44+(C45-C44)*RENTAL_SOURCES!$H$43-D40)","v":0},{"$f":"MAX(0,D44+(D45-D44)*RENTAL_SOURCES!$H$43-E40)","v":0},{"$f":"MAX(0,E44+(E45-E44)*RENTAL_SOURCES!$H$43-F40)","v":0},{"$f":"MAX(0,F44+(F45-F44)*RENTAL_SOURCES!$H$43-G40)","v":0},{"$f":"MAX(0,G44+(G45-G44)*RENTAL_SOURCES!$H$43-H40)","v":0},{"$f":"MAX(0,H44+(H45-H44)*RENTAL_SOURCES!$H$43-I40)","v":0},{"$f":"MAX(0,I44+(I45-I44)*RENTAL_SOURCES!$H$43-J40)","v":0},{"$f":"MAX(0,J44+(J45-J44)*RENTAL_SOURCES!$H$43-K40)","v":0},{"$f":"MAX(0,K44+(K45-K44)*RENTAL_SOURCES!$H$43-L40)","v":0},{"$f":"MAX(0,L44+(L45-L44)*RENTAL_SOURCES!$H$43-M40)","v":0},{"$f":"MAX(0,M44+(M45-M44)*RENTAL_SOURCES!$H$43-N40)","v":0},{"$f":"MAX(0,N44+(N45-N44)*RENTAL_SOURCES!$H$43-O40)","v":0},{"$f":"MAX(0,O44+(O45-O44)*RENTAL_SOURCES!$H$43-P40)","v":0},{"$f":"MAX(0,P44+(P45-P44)*RENTAL_SOURCES!$H$43-Q40)","v":0},{"$f":"MAX(0,Q44+(Q45-Q44)*RENTAL_SOURCES!$H$43-R40)","v":0},{"$f":"MAX(0,R44+(R45-R44)*RENTAL_SOURCES!$H$43-S40)","v":0},{"$f":"MAX(0,S44+(S45-S44)*RENTAL_SOURCES!$H$43-T40)","v":0},{"$f":"MAX(0,T44+(T45-T44)*RENTAL_SOURCES!$H$43-U40)","v":0},{"$f":"MAX(0,U44+(U45-U44)*RENTAL_SOURCES!$H$43-V40)","v":0},{"$f":"MAX(0,V44+(V45-V44)*RENTAL_SOURCES!$H$43-W40)","v":0}]
["DHCD Loan Balance",null,{"$f":"RENTAL_SOURCES!$E$38+C44-(IF(C44=0,RENTAL_PRO_FORMA!C40-(RENTAL_SOURCES!$E$38*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"C45+D44-(IF(D44=0,RENTAL_PRO_FORMA!D40-((C45-C44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"D45+E44-(IF(E44=0,RENTAL_PRO_FORMA!E40-((D45-D44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"E45+F44-(IF(F44=0,RENTAL_PRO_FORMA!F40-((E45-E44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"F45+G44-(IF(G44=0,RENTAL_PRO_FORMA!G40-((F45-F44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"G45+H44-(IF(H44=0,RENTAL_PRO_FORMA!H40-((G45-G44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"H45+I44-(IF(I44=0,RENTAL_PRO_FORMA!I40-((H45-H44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"I45+J44-(IF(J44=0,RENTAL_PRO_FORMA!J40-((I45-I44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"J45+K44-(IF(K44=0,RENTAL_PRO_FORMA!K40-((J45-J44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"K45+L44-(IF(L44=0,RENTAL_PRO_FORMA!L40-((K45-K44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"L45+M44-(IF(M44=0,RENTAL_PRO_FORMA!M40-((L45-L44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"M45+N44-(IF(N44=0,RENTAL_PRO_FORMA!N40-((M45-M44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"N45+O44-(IF(O44=0,RENTAL_PRO_FORMA!O40-((N45-N44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"O45+P44-(IF(P44=0,RENTAL_PRO_FORMA!P40-((O45-O44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"P45+Q44-(IF(Q44=0,RENTAL_PRO_FORMA!Q40-((P45-P44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"Q45+R44-(IF(R44=0,RENTAL_PRO_FORMA!R40-((Q45-Q44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"R45+S44-(IF(S44=0,RENTAL_PRO_FORMA!S40-((R45-R44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"S45+T44-(IF(T44=0,RENTAL_PRO_FORMA!T40-((S45-S44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"T45+U44-(IF(U44=0,RENTAL_PRO_FORMA!U40-((T45-T44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"U45+V44-(IF(V44=0,RENTAL_PRO_FORMA!V40-((U45-U44)*RENTAL_SOURCES!$H$43),0))","v":0},{"$f":"V45+W44-(IF(W44=0,RENTAL_PRO_FORMA!W40-((V45-V44)*RENTAL_SOURCES!$H$43),0))","v":0}]

{"sheet":"LIHTC_ELIGIBLE_BASIS","index":8,"n_rows":126,"n_cols":6,"rows_kept":126,"cut":false,"hidden":true,"merged":[[125,0,125,2],[1,0,1,5],[7,0,7,1]]}
[null,null,"Yes"]
["LOW-INCOME HOUSING TAX CREDIT BUDGET"]
[]
[]
["CALCULATION OF ELIGIBLE BASIS"]
[]
["ACQUISITION"]
["Type of Uses",null,"Residential Total","Acquisition","New Construction/ Rehab","Total Eligible Basis"]
["Acquisition",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H9","v":0},null,null,{"$f":"SUM(D9:E9)","v":0}]
["Land Costs",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H10","v":0},null,null,{"$f":"SUM(D10:E10)","v":0}]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A11","v":"Other Acquisition Costs 1"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H11","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A12","v":"Other Acquisition Costs 2"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H12","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A13","v":"Other Acquisition Costs 3"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H13","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A14","v":"Other Acquisition Costs 4"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H14","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A15","v":"Other Acquisition Costs 5"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H15","v":0},null,null,0]
["Total Acquisition Costs",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H16","v":0},{"$f":"SUM(D9:D15)","v":0},{"$f":"SUM(E9:E15)","v":0},0]
[]
["CONSTRUCTION"]
["Construction",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H18","v":0},null,null,{"$f":"SUM(D19:E19)","v":0}]
["Site Work (incl. Public Work)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H19","v":0},null,null,0]
["Environmental Remediation",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H20","v":0},null,null,0]
["Profit",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H21","v":0},null,null,0]
["Overhead",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H22","v":0},null,null,0]
["General Conditions",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H23","v":0},null,null,0]
["Bond Premium",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H24","v":0},null,null,0]
["Contingency",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H25","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A26","v":"Other Construction Cost 1"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H26","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A27","v":"Other Construction Cost 2"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H27","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A28","v":"Other Construction Cost 3"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H28","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A29","v":"Other Construction Cost 4"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H29","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A30","v":"Other Construction Cost 5"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H30","v":0},null,null,0]
["Total Construction Costs",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H31","v":0},{"$f":"SUM(D19:D31)","v":0},{"$f":"SUM(E19:E31)","v":0},0]
[]
["SOFT COSTS"]
["Architect & Engineer ",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H33","v":0},null,null,{"$f":"SUM(D35:E35)","v":0}]
["Architect & Engineer Supervision",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H34","v":0},null,null,0]
["A&E Reimbursables (Cost Review, LEED Cert)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H35","v":0},null,null,0]
["Owner's Rep (Construction Monitoring)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H36","v":0},null,null,0]
["Borrower Legal",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H37","v":0},null,null,0]
["Appraisal",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H38","v":0},null,null,0]
["Permits and Tap Fees (Incl. Permit Expediter)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H39","v":0},null,null,0]
["Builder's Risk Insurance",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H40","v":0},null,null,0]
["Bond Premium",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H41","v":0},null,null,0]
["Market Study",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H42","v":0},null,null,0]
["Environmental & Soil Reports",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H43","v":0},null,null,0]
["Testing and Inspection",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H44","v":0},null,null,0]
["Title, Transfer and Recordation",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H45","v":0},null,null,0]
["Interim Insurance",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H46","v":0},null,null,0]
["Interim Taxes",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H47","v":0},null,null,0]
["Accounting Fees and Cost Cert.",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H48","v":0},null,null,0]
["Marketing",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H52","v":0},null,null,0]
["Survey",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H53","v":0},null,null,0]
["FFE",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H54","v":0},null,null,0]
["Tenant Improvements",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H55","v":0},null,null,0]
["Soft Cost Contingency",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H56","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A57","v":"Other Soft Cost 1"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H57","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A58","v":"Other Soft Cost 2"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H58","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A59","v":"Other Soft Cost 3"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H59","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A60","v":"Other Soft Cost 4"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H60","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A61","v":"Other Soft Cost 5"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H61","v":0},null,null,0]
["Total Soft Costs",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H62","v":0},{"$f":"SUM(D35:D60)","v":0},{"$f":"SUM(E35:E60)","v":0},0]
[]
["FINANCING"]
["DCHFA Bond Application Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H64","v":0},null,null,{"$f":"SUM(D64:E64)","v":0}]
["DCHFA McKinney Application Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H65","v":0},null,null,0]
["DCHFA McKinney Financing Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H66","v":0},null,null,0]
["DCHFA Financing Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H67","v":0},null,null,0]
["DCHFA Construction Monitoring Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H68","v":0},null,null,0]
["DCHFA/Issuer's Counsel Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H69","v":0},null,null,0]
["Bond Counsel",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H70","v":0},null,null,0]
["Bond Purchaser's Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H71","v":0},null,null,0]
["Bond Purchaser Counsel",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H72","v":0},null,null,0]
["Underwriter Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H73","v":0},null,null,0]
["Underwriter's Counsel",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H74","v":0},null,null,0]
["Trustee Set Up Fee/ Legal",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H75","v":0},null,null,0]
["Rating Agency/Printing Fees",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H76","v":0},null,null,0]
["Negative Arbitrage",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H77","v":0},null,null,0]
["DCHFA Issure Fee (ST Construction Period)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H78","v":0},null,null,0]
["DCHFA Issuer Fee (LT Construction Period)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H79","v":0},null,null,0]
["DCHFA LIHTC Allocation Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H80","v":0},null,null,0]
["DHCD LIHTC Allocation Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H81","v":0},null,null,0]
["Tax Credit Fees/Legal",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H82","v":0},null,null,0]
["Construction Period Interest-Capitalized",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H83","v":0},null,null,0]
["Construction LoC Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H84","v":0},null,null,0]
["Construction LoC Annual Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H85","v":0},null,null,0]
["Construction Lender's Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H86","v":0},null,null,0]
["Construction Lender's Counsel",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H87","v":0},null,null,0]
["Construction Lender's Inspection Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H88","v":0},null,null,0]
["Conversion Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H89","v":0},null,null,0]
["Permanent Lender Financing Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H90","v":0},null,null,0]
["Permanent Lender Inspection Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H91","v":0},null,null,0]
["Permanent Lender Counsel Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H92","v":0},null,null,0]
["Freddie Mac Commitment Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H93","v":0},null,null,0]
["Freddie Mac Standby Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H94","v":0},null,null,0]
["Freddie Mac Counsel",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H95","v":0},null,null,0]
["Financial Advisor",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H96","v":0},null,null,0]
["Cash Flow Verification Analyst",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H100","v":0},null,null,0]
["GIC Brokerage Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H101","v":0},null,null,0]
["Financing Contingency",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H102","v":0},null,null,0]
["McKinney Interest",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H103","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A104","v":"Other Financing Cost 1"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H104","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A105","v":"Other Financing Cost 2"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H105","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A106","v":"Other Financing Cost 3"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H106","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A107","v":"Other Financing Cost 4"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H107","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A108","v":"Other Financing Cost 5"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H108","v":0},null,null,0]
["Total Financing Costs",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H109","v":0},{"$f":"SUM(D64:D105)","v":0},{"$f":"SUM(E64:E105)","v":0},0]
[]
["DEVELOPER FEE"]
["Developer Overhead",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H111","v":0},null,null,{"$f":"SUM(D109:E109)","v":0}]
["Developer Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H112","v":0},null,null,0]
["Total Developer Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H113","v":0},{"$f":"SUM(D109:D110)","v":0},{"$f":"SUM(E109:E110)","v":0},0]
[]
["GUARANTEES AND RESERVES"]
["Operating Reserve",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H115","v":0},null,null,{"$f":"SUM(D114:E114)","v":0}]
["Replacement Reserve Deposit (Initial Payment)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H116","v":0},null,null,0]
["Debt Service Reserve",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H117","v":0},null,null,0]
["Lease Up Reserve",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H118","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A119","v":"Other Reserve 1"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H119","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A120","v":"Other Reserve 2"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H120","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A121","v":"Other Reserve 3"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H121","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A122","v":"Other Reserve 4"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H122","v":0},null,null,0]
[{"$f":"RENTAL_DEVELOPMENT_BUDGET!A123","v":"Other Reserve 5"},null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H123","v":0},null,null,0]
["Total Reserves and Escrows",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!H124","v":0},{"$f":"SUM(D114:D122)","v":0},{"$f":"SUM(E114:E122)","v":0},0]
[]
[null,null,null,"Acquisition","Construction","Total Eligible Basis"]
["ELIGIBLE BASIS",null,null,{"$f":"SUM(D123,D111,D61,D106,D32,D16)","v":0},{"$f":"SUM(E123,E111,E61,E106,E32,E16)","v":0},{"$f":"SUM(F123,F111,F61,F106,F32,F16)","v":0}]

{"sheet":"LIHTC_EQUITY","index":9,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":true,"merged":[[1,0,1,8],[33,2,33,5],[3,0,3,7],[4,0,4,7],[5,0,5,7]]}
[null,null,"Yes","No"]
["LOW-INCOME HOUSING TAX CREDIT EQUITY",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,2]
["How many buildings are in the project?",null,null,null,null,null,null,null,1,3]
["Are any buildings in the project in a difficult to develop area, a qualfied census tract, or been granted a basis bost by DHCD?",null,null,null,null,null,null,null,"Yes",4]
["If Yes, how many buildings will be in a difficult to develop area, a qualfied census tract, or been granted a basis bost by DHCD?",null,null,null,null,null,null,null,1,5]
[null,null,null,null,null,null,null,null,null,6]
["CALCULATION OF TAX CREDIT AMOUNT",null,null,null,null,null,null,null,null,7]
["Maximum Low-Income Housing Tax Credit Based on Eligible Costs",null,null,null,null,null,null,null,null,8]
["Description",null,null,null,null,null,null,"Acquisition","New Construction/ Rehab",9]
["Eligible Basis (from LIHTC Eligible Basis tab)",null,null,null,null,null,null,{"$f":"LIHTC_ELIGIBLE_BASIS!D126","v":0},{"$f":"LIHTC_ELIGIBLE_BASIS!E126","v":0},10]
["Less Federal Grants and/or below-market Federal Loans",null,null,null,null,null,null,null,null,11]
["Less non-qualified, non-recourse financing",null,null,null,null,null,null,null,null,12]
["Less costs of non-qualifying Units of higher quality or excess costs of non-qualiftying units",null,null,null,null,null,null,null,null,13]
["Less Historic Rehabilitation Tax Credit (Residential portion only)",null,null,null,null,null,null,null,null,14]
["Adjusted Eligible Basis",null,null,null,null,null,null,{"$f":"H11-SUM(H12:H15)","v":0},{"$f":"I11-SUM(I12:I15)","v":0},15]
["Difficult to Developer Area, QCT, or DHCD approved Basis Boost",null,null,null,null,null,null,1,{"$f":"IF($I$5=\"yes\",(I6*130%+((I4-I6)*100%))/I4,100%)","v":1.3},16]
["Applicable Fraction (calculate below)",null,null,null,null,null,null,{"$f":"IF(D45=\"\",IF(H45=\"\",\"\",H45),IF(H45=\"\",D45,MIN(D45,H45)))","v":""},{"$f":"IF(D45=\"\",IF(H45=\"\",\"\",H45),IF(H45=\"\",D45,MIN(D45,H45)))","v":""},17]
["Qualified Basis",null,null,null,null,null,null,{"$f":"H16*H18*H17","v":0},{"$f":"I16*I18*I17","v":0},18]
["Applicable Percentage (construction basis qualified for 4% or 9%?)",null,null,null,null,null,null,3.2199999999999999E-2,0.09,19]
["Low Income Housing Tax Credit Eligible",null,null,null,null,null,null,{"$f":"H19*H20","v":0},{"$f":"I19*I20","v":0},20]
[null,null,null,null,null,null,null,null,null,21]
["Estimated Low-Income Housing Tax Credit Syndication Proceeds",null,null,null,null,null,null,null,null,22]
["Combined Low Income Housing Tax Credit Eligible (result from previous table)",null,null,null,null,null,null,null,{"$f":"H21+I21","v":0},23]
["Tax Credit Period (10 years)",null,null,null,null,null,null,null,"x 10",24]
["Total Tax Credit Received Over Period",null,null,null,null,null,null,null,{"$f":"I24*10","v":0},25]
["Raise Ratio from Syndicator's Proposal",null,null,null,null,null,null,null,null,26]
["Gross Proceeds from Low Income Housing Tax Credit",null,null,null,null,null,null,null,{"$f":"I26*I27","v":0},27]
["Gross Proceeds from Historic Tax Credit ",null,null,null,null,null,null,null,null,28]
["Total Equity from Syndication Proceeds",null,null,null,null,null,null,null,{"$f":"I29+I28","v":0},29]
[null,null,null,null,null,null,null,null,null,30]
["Maximum Low-Income Housing Tax Credit Based on Proceeds Needed",null,null,null,null,null,null,null,null,31]
["Proceeds Needed (enter lesser of Total Equity from Syndication Proceeds or Financing Gap)",null,null,null,null,null,null,null,null,32]
["Gross Proceeds from Historic Tax Credit",null,"(Total Historic Rehabilitation Tax Credit x Syndicator Raise Rate)",null,null,null,0.92,null,{"$f":"I15*G34","v":0},33]
["Low Income Housing Tax Credit Syndication Proceeds",null,null,null,null,null,null,null,{"$f":"I33-I34","v":0},34]
["Raise Ratio from Syndicator's Proposal",null,null,null,null,null,null,null,null,35]
["Total Tax Credit Received Over Period",null,null,null,null,null,null,null,{"$f":"IF(I35=0,\"\",I35/I36)","v":""},36]
["Tax Credit Period (10 years)",null,null,null,null,null,null,null,"÷ 10",37]
["Maximum Low-Income Housing Tax Credit",null,null,null,null,null,null,null,{"$f":"(I37/10)","v":0},38]
[null,null,null,null,null,null,null,null,null,39]
["Applicable Fraction -  The applicable fraction is the lesser of the following formulas (mark one box only)",null,null,null,null,null,null,null,null,40]
[null,"Percent of Units",null,null,null,"Percent of Sq. Ft.",null,null,null,41]
[null,"Low Income Units",null,null,null,"Low Income Sq. Ft.",null,null,null,42]
[null,"Total Units",null,null,null,"Total Sq. Ft.",null,null,null,43]
[null,"Unit Percentage",null,{"$f":"IF(D43=0,\"\",D43/D44)","v":""},null,"Sq. Ft. Percentage",null,{"$f":"IF(H43=0,\"\",H43/H44)","v":""},null,44]
[null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,null,null,50]

{"sheet":"DHCD_UNDERWRITING_STANDARDS","index":10,"n_rows":73,"n_cols":9,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["DHCD PROJECT STANDARDS",null,null,null,null,"Select Building Type:","New Construction Rental","Substantial Rehabilitation","Moderate Rehabilitation"]
[null,null,null,null,null,"Townhouses",180,145,100]
["Project Manager:",null,null,"Date:",null,"Garden Apt/Condo",175,135,95]
[{"$f":"\"Project Name:\"&\"\"&SIGNATURE!H19","v":"Project Name:"},null,null,"Funding Round:",null,"Elevator Buildings (≤ 5 Floors)",210,150,125]
[null,null,null,null,null,"Elevator Buildings (6 or more floors)",240,165,140]
["Terms/Underwriting Standards","Standard","Actual","Meets Standard?","Explanation/Waiver Requested"]
["Background"]
["Application Scorecard reviewed","Yes"]
["All Project Commitments made in application are met","Yes",null,null,null,"Yes"]
["Reviewer Comments reviewed and addressed","Yes",null,null,null,"No"]
["Site Visit held","Yes",null,null,null,"N/A"]
["Other Agencies Involved (list)"]
["Changes from initial application (list, if any)"]
[1]
[2]
[3]
[4]
[5]
["Loan Requirements/Terms"]
["HPTF funding request equal to or less than:",0.49,{"$f":"RENTAL_SOURCES!E38/DHCD_UNDERWRITING_BUDGET!C140","v":{"$error":"#DIV/0!"}}]
["Interest Rate Requested",0.03,{"$f":"RENTAL_SOURCES!H32","v":0.03}]
["Loan Term in years","40 Years",{"$f":"RENTAL_SOURCES!H33","v":"40 Years"}]
["Affordability Period in years","40 Years",{"$f":"RENTAL_SOURCES!H35","v":"40 Years"}]
["Cash Flow Percentage of Payments",0.75,{"$f":"RENTAL_SOURCES!H34","v":0.75}]
["Loan to Value of Restricted Value equal to or less than:",1,"INSERT"]
["Loan to Value of Unrestricted Value equal to or less than:",1,"INSERT"]
["Borrower Maximized all other funding sources?","Yes"]
["Acquisition"]
["Acquisition Price is the contract price or the \"As Is\" appraised value","Yes",{"$f":"DHCD_UNDERWRITING_BUDGET!C24","v":0}]
["DMPED, PADD: Acquisition Price minimized or offset by seller's note","Yes"]
["Equity Pricing"]
["LIHTC raise rate within current market standards","Yes",{"$f":"LIHTC_EQUITY!I27","v":0}]
["Construction Costs and Fees"]
["Construction costs are at least $15/sf:","Yes",{"$f":"RENTAL_DEVELOPMENT_BUDGET!$F$31","v":0}]
["Select Building Type:",{"$f":"IF(SIGNATURE!H10=DHCD_UNDERWRITING_STANDARDS!G1,VLOOKUP(DHCD_UNDERWRITING_STANDARDS!A35,DHCD_UNDERWRITING_STANDARDS!F2:I5,2,FALSE),IF(SIGNATURE!H10=DHCD_UNDERWRITING_STANDARDS!H1,VLOOKUP(DHCD_UNDERWRITING_STANDARDS!A35,DHCD_UNDERWRITING_STANDARDS!F2:I5,3,FALSE),IF(SIGNATURE!H10=DHCD_UNDERWRITING_STANDARDS!I1,VLOOKUP(DHCD_UNDERWRITING_STANDARDS!A35,DHCD_UNDERWRITING_STANDARDS!F2:I5,4,FALSE),0)))","v":{"$error":"#N/A"}},{"$f":"RENTAL_DEVELOPMENT_BUDGET!$F$31","v":0}]
["Construction Contingency:",{"$f":"IF(SIGNATURE!H10=\"New Construction Rental\",\"5-10%\",\"12-15%\")","v":"5-10%"},{"$f":"DHCD_UNDERWRITING_BUDGET!C41/(DHCD_UNDERWRITING_BUDGET!C47-DHCD_UNDERWRITING_BUDGET!C41)","v":{"$error":"#DIV/0!"}}]
["Profit","5-10%",{"$f":"DHCD_UNDERWRITING_BUDGET!C37/DHCD_UNDERWRITING_BUDGET!C47","v":{"$error":"#DIV/0!"}}]
["Overhead","2-3%",{"$f":"DHCD_UNDERWRITING_BUDGET!C38/DHCD_UNDERWRITING_BUDGET!C47","v":{"$error":"#DIV/0!"}}]
["General Conditions","5-10%",{"$f":"DHCD_UNDERWRITING_BUDGET!C39/DHCD_UNDERWRITING_BUDGET!C47","v":{"$error":"#DIV/0!"}}]
["Architect & Engineer","2-6%",{"$f":"DHCD_UNDERWRITING_BUDGET!C49/DHCD_UNDERWRITING_BUDGET!C47","v":{"$error":"#DIV/0!"}}]
["Architect & Engineer Supervision","1-3%",{"$f":"DHCD_UNDERWRITING_BUDGET!C50/DHCD_UNDERWRITING_BUDGET!C47","v":{"$error":"#DIV/0!"}}]
["Owner's Rep (Construction Monitoring)","2-4%",{"$f":"DHCD_UNDERWRITING_BUDGET!C52/DHCD_UNDERWRITING_BUDGET!C47","v":{"$error":"#DIV/0!"}}]
["Construction Interest In Line with DHCD Estimate",{"$f":"((RENTAL_SOURCES!K42*0.5)*(RENTAL_SOURCES!H42/12))*RENTAL_SOURCES!J42","v":0},{"$f":"RENTAL_DEVELOPMENT_BUDGET!D83","v":0}]
["Soft Cost Contingency"]
["Percentage of Soft Cost Budget","5-8%",{"$f":"DHCD_UNDERWRITING_BUDGET!C69/DHCD_UNDERWRITING_BUDGET!C75","v":{"$error":"#DIV/0!"}}]
["Operating Expenses"]
["Total Per Unit Expenses","$6,100-$7,100",{"$f":"RENTAL_EXPENSES!F83","v":0}]
["Operating Reserves are 3-6 months of operating expenses + must pay debt","Yes",{"$f":"RENTAL_EXPENSES!D79","v":0}]
["Replacement Reserves Per Unit",{"$f":"IF(SIGNATURE!H10=\"Moderate Rehabilitation\",350,300)","v":300},{"$f":"RENTAL_EXPENSES!F80","v":0}]
["Vacancy Rate"]
["Vacancy Rate",{"$f":"IF(SIGNATURE!H10=\"New Construction Rental\",5%,7%)","v":0.05},{"$f":"RENTAL_INCOME!F33","v":"%"}]
["Debt Service Coverage Ratio"]
["Must Pay DSCR by end of first year of sustained operatins","> 1.15, < 1.25",{"$f":"RENTAL_PRO_FORMA!D32","v":""}]
["Household Income/Proposed Rents"]
["Household Income distribution meets or exceeds original application","Yes"]
["Project meets household income/rents for funding source, w/ utility allowance","Yes"]
["Household Income/Proposed Rents"]
["HOME Subsidy Layering Review Completed","Yes"]
["LIHTC/Operating Subsidy Layering Review Completed","Yes"]
["Analysis of Development Team Financial/Workload Capacity"]
["PAMD verified acceptable past performance","Yes"]
["Developer financial capacity adequate","Yes"]
["Items for Followup"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"DHCD_UNDERWRITING_BUDGET","index":11,"n_rows":140,"n_cols":7,"rows_kept":140,"cut":false,"hidden":true,"merged":[[1,0,1,6],[4,1,4,2],[4,4,4,6]]}
[null,null,"Yes"]
["DHCD UNDERWRITING BUDGET WITH SOURCES AND USES"]
[null,null,null,null,null,"DATE:"]
[]
["PROJECT NAME:",{"$f":"SIGNATURE!H19","v":0},null,"DEVELOPER NAME:",{"$f":"SIGNATURE!H16","v":0}]
[]
["SOURCES",null,"Total Sources and Uses","DFD Underwriting ","Requested Changes","DFD Per Unit","DFD Per Sq. Foot"]
["Permanent Source 1 - ",{"$f":"RENTAL_SOURCES!C6","v":0},{"$f":"RENTAL_SOURCES!K6","v":0},null,{"$f":"C8-D8","v":0},{"$f":"D8/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D8/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Permanent Source 2 - ",{"$f":"RENTAL_SOURCES!C7","v":0},{"$f":"RENTAL_SOURCES!K7","v":0},null,{"$f":"C9-D9","v":0},{"$f":"D9/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D9/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Permanent Source 3 - ",{"$f":"RENTAL_SOURCES!C8","v":0},{"$f":"RENTAL_SOURCES!K8","v":0},null,0,{"$f":"D10/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D10/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Permanent Source 4 - ",{"$f":"RENTAL_SOURCES!C9","v":0},{"$f":"RENTAL_SOURCES!K9","v":0},null,0,{"$f":"D11/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D11/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Permanent Source 5 - ",{"$f":"RENTAL_SOURCES!C10","v":0},{"$f":"RENTAL_SOURCES!K10","v":0},null,0,{"$f":"D12/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D12/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Grant Source 1 -",{"$f":"RENTAL_SOURCES!C15","v":0},{"$f":"RENTAL_SOURCES!K15","v":0},null,0,{"$f":"D13/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D13/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Grant Source 2 -",{"$f":"RENTAL_SOURCES!C16","v":0},{"$f":"RENTAL_DEVELOPMENT_BUDGET!H3","v":0},null,0,{"$f":"D14/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D14/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["LIHTC Equity -",{"$f":"RENTAL_SOURCES!D21","v":0},{"$f":"RENTAL_SOURCES!K21","v":0},null,{"$f":"C15-D15","v":0},{"$f":"D15/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D15/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Tax Credit Equity -",{"$f":"RENTAL_SOURCES!D22","v":0},{"$f":"RENTAL_SOURCES!K22","v":0},null,0,{"$f":"D16/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D16/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Deferred Developer Fee",null,{"$f":"RENTAL_SOURCES!K23","v":0},null,0,{"$f":"D17/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D17/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Developer Equity",{"$f":"RENTAL_SOURCES!D25","v":"Other Developer Equity"},{"$f":"RENTAL_SOURCES!K25","v":0},null,0,{"$f":"D18/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D18/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Interim Income",{"$f":"RENTAL_SOURCES!D26","v":0},{"$f":"RENTAL_SOURCES!K26","v":0},null,0,{"$f":"D19/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D19/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["DHCD Financing - ","PROVIDE PROGRAM HERE",{"$f":"RENTAL_SOURCES!E38","v":0},null,0,{"$f":"D20/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D20/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Total Sources of Funds",null,{"$f":"SUM(C8:C20)","v":0},{"$f":"SUM(D8:D14)","v":0},0,{"$f":"SUM(F8:F14)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G8:G14)","v":{"$error":"#DIV/0!"}}]
[]
["ACQUISITION"]
["Acquisition",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D9","v":0},null,{"$f":"C24-D24","v":0},{"$f":"D24/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D24/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Land Costs",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D10","v":0},null,{"$f":"C25-D25","v":0},{"$f":"D25/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D25/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Acquisition Costs 1",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D11","v":0},null,0,{"$f":"D26/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D26/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Acquisition Costs 2",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D12","v":0},null,0,{"$f":"D27/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D27/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Acquisition Costs 3",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D13","v":0},null,0,{"$f":"D28/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D28/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Acquisition Costs 4",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D14","v":0},null,0,{"$f":"D29/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D29/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Acquisition Costs 5",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D15","v":0},null,0,{"$f":"D30/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D30/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Total Acquisition Costs",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D16","v":0},{"$f":"SUM(D24:D30)","v":0},0,{"$f":"SUM(F24:F30)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
["CONSTRUCTION"]
["Construction",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D18","v":0},null,{"$f":"C34-D34","v":0},{"$f":"D34/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D34/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Site Work (incl. Public Work)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D19","v":0},null,{"$f":"C35-D35","v":0},{"$f":"D35/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D35/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Environmental Remediation",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D20","v":0},null,0,{"$f":"D36/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D36/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Profit",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D21","v":0},null,0,{"$f":"D37/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D37/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Overhead",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D22","v":0},null,0,{"$f":"D38/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D38/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["General Conditions",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D23","v":0},null,0,{"$f":"D39/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D39/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Bond Premium",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D24","v":0},null,0,{"$f":"D40/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D40/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Contingency",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D25","v":0},null,0,{"$f":"D41/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D41/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Construction Cost 1",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D26","v":0},null,0,{"$f":"D42/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D42/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Construction Cost 2",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D27","v":0},null,0,{"$f":"D43/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D43/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Construction Cost 3",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D28","v":0},null,0,{"$f":"D44/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D44/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Construction Cost 4",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D29","v":0},null,0,{"$f":"D45/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D45/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Construction Cost 5",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D30","v":0},null,0,{"$f":"D46/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D46/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Total Construction Costs",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D31","v":0},{"$f":"SUM(D34:D46)","v":0},0,{"$f":"SUM(F34:F46)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["SOFT COSTS"]
["Architect & Engineer ",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D33","v":0},null,{"$f":"C49-D49","v":0},{"$f":"D49/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D49/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Architect & Engineer Supervision",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D34","v":0},null,{"$f":"C50-D50","v":0},{"$f":"D50/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D50/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["A&E Reimbursables (Cost Review, LEED Cert)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D35","v":0},null,{"$f":"C51-D51","v":0},{"$f":"D51/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D51/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Owner's Rep (Construction Monitoring)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D36","v":0},null,0,{"$f":"D52/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D52/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Borrower Legal",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D37","v":0},null,0,{"$f":"D53/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D53/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Appraisal",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D38","v":0},null,0,{"$f":"D54/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D54/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Permits and Tap Fees (Incl. Permit Expediter)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D39","v":0},null,0,{"$f":"D55/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D55/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Builder's Risk Insurance",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D40","v":0},null,0,{"$f":"D56/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D56/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Bond Premium",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D41","v":0},null,0,{"$f":"D57/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D57/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Market Study",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D42","v":0},null,0,{"$f":"D58/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D58/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Environmental & Soil Reports",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D43","v":0},null,0,{"$f":"D59/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D59/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Testing and Inspection",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D44","v":0},null,0,{"$f":"D60/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D60/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Title, Transfer and Recordation",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D45","v":0},null,0,{"$f":"D61/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D61/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Interim Insurance",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D46","v":0},null,0,{"$f":"D62/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D62/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Interim Taxes",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D47","v":0},null,0,{"$f":"D63/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D63/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Accounting Fees and Cost Cert.",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D48","v":0},null,0,{"$f":"D64/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D64/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Marketing",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D52","v":0},null,0,{"$f":"D65/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D65/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Survey",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D53","v":0},null,0,{"$f":"D66/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D66/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["FFE",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D54","v":0},null,0,{"$f":"D67/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D67/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Tenant Improvements",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D55","v":0},null,0,{"$f":"D68/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D68/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Soft Cost Contingency",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D56","v":0},null,0,{"$f":"D69/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D69/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Soft Cost 1",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D57","v":0},null,0,{"$f":"D70/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D70/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Soft Cost 2",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D58","v":0},null,0,{"$f":"D71/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D71/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Soft Cost 3",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D59","v":0},null,0,{"$f":"D72/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D72/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Soft Cost 4",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D60","v":0},null,0,{"$f":"D73/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D73/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Soft Cost 5",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D61","v":0},null,0,{"$f":"D74/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D74/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Total Soft Costs",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D62","v":0},{"$f":"SUM(D49:D74)","v":0},0,{"$f":"SUM(F49:F74)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
["FINANCING"]
["DCHFA Bond Application Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D64","v":0},null,{"$f":"C78-D78","v":0},{"$f":"D78/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D78/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["DCHFA McKinney Application Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D65","v":0},null,{"$f":"C79-D79","v":0},{"$f":"D79/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D79/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["DCHFA McKinney Financing Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D66","v":0},null,0,{"$f":"D80/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D80/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["DCHFA Financing Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D67","v":0},null,0,{"$f":"D81/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D81/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["DCHFA Construction Monitoring Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D68","v":0},null,0,{"$f":"D82/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D82/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["DCHFA/Issuer's Counsel Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D69","v":0},null,0,{"$f":"D83/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D83/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Bond Counsel",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D70","v":0},null,0,{"$f":"D84/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D84/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Bond Purchaser's Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D71","v":0},null,0,{"$f":"D85/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D85/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Bond Purchaser Counsel",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D72","v":0},null,0,{"$f":"D86/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D86/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Underwriter Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D73","v":0},null,0,{"$f":"D87/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D87/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Underwriter's Counsel",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D74","v":0},null,0,{"$f":"D88/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D88/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Trustee Set Up Fee/ Legal",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D75","v":0},null,0,{"$f":"D89/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D89/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Rating Agency/Printing Fees",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D76","v":0},null,0,{"$f":"D90/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D90/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Negative Arbitrage",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D77","v":0},null,0,{"$f":"D91/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D91/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["DCHFA Issure Fee (ST Construction Period)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D78","v":0},null,0,{"$f":"D92/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D92/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["DCHFA Issuer Fee (LT Construction Period)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D79","v":0},null,0,{"$f":"D93/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D93/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["DCHFA LIHTC Allocation Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D80","v":0},null,0,{"$f":"D94/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D94/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["DHCD LIHTC Allocation Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D81","v":0},null,0,{"$f":"D95/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D95/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Tax Credit Fees/Legal",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D82","v":0},null,0,{"$f":"D96/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D96/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Construction Period Interest-Capitalized",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D83","v":0},null,0,{"$f":"D97/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D97/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Construction LoC Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D84","v":0},null,0,{"$f":"D98/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D98/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Construction LoC Annual Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D85","v":0},null,0,{"$f":"D99/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D99/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Construction Lender's Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D86","v":0},null,0,{"$f":"D100/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D100/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Construction Lender's Counsel",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D87","v":0},null,0,{"$f":"D101/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D101/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Construction Lender's Inspection Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D88","v":0},null,0,{"$f":"D102/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D102/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Conversion Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D89","v":0},null,0,{"$f":"D103/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D103/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Permanent Lender Financing Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D90","v":0},null,0,{"$f":"D104/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D104/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Permanent Lender Inspection Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D91","v":0},null,0,{"$f":"D105/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D105/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Permanent Lender Counsel Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D92","v":0},null,0,{"$f":"D106/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D106/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Freddie Mac Commitment Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D93","v":0},null,0,{"$f":"D107/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D107/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Freddie Mac Standby Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D94","v":0},null,0,{"$f":"D108/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D108/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Freddie Mac Counsel",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D95","v":0},null,0,{"$f":"D109/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D109/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Financial Advisor",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D96","v":0},null,0,{"$f":"D110/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D110/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Cash Flow Verification Analyst",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D100","v":0},null,0,{"$f":"D111/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D111/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["GIC Brokerage Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D101","v":0},null,0,{"$f":"D112/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D112/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Financing Contingency",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D102","v":0},null,0,{"$f":"D113/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D113/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["McKinney Interest",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D103","v":0},null,0,{"$f":"D114/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D114/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Financing Cost 1",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D104","v":0},null,0,{"$f":"D115/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D115/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Financing Cost 2",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D105","v":0},null,0,{"$f":"D116/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D116/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Financing Cost 3",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D106","v":0},null,0,{"$f":"D117/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D117/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Financing Cost 4",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D107","v":0},null,0,{"$f":"D118/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D118/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Financing Cost 5",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D108","v":0},null,0,{"$f":"D119/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D119/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Total Financing Costs",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D109","v":0},{"$f":"SUM(D78:D119)","v":0},0,{"$f":"SUM(F78:F119)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
["DEVELOPER FEE"]
["Developer Overhead",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D111","v":0},null,{"$f":"C123-D123","v":0},{"$f":"D123/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D123/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Developer Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D112","v":0},null,{"$f":"C124-D124","v":0},{"$f":"D124/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D124/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Total Developer Fee",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D113","v":0},{"$f":"SUM(D123:D124)","v":0},0,{"$f":"SUM(F123:F124)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
["GUARANTEES AND RESERVES"]
["Operating Reserve",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D115","v":0},null,{"$f":"C128-D128","v":0},{"$f":"D128/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D128/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Replacement Reserve Deposit (Initial Payment)",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D116","v":0},null,{"$f":"C129-D129","v":0},{"$f":"D129/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D129/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Debt Service Reserve",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D117","v":0},null,0,{"$f":"D130/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D130/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Lease Up Reserve",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D118","v":0},null,0,{"$f":"D131/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D131/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Reserves 1",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D119","v":0},null,0,{"$f":"D132/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D132/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Reserves 2",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D120","v":0},null,0,{"$f":"D133/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D133/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Reserves 3",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D121","v":0},null,0,{"$f":"D134/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D134/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Reserves 4",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D122","v":0},null,0,{"$f":"D135/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D135/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Other Reserves 5",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D123","v":0},null,0,{"$f":"D136/RENTAL_INCOME!$D$32","v":{"$error":"#DIV/0!"}},{"$f":"D136/RENTAL_INCOME!$C$42","v":{"$error":"#DIV/0!"}}]
["Total Reserves and Escrows",null,{"$f":"RENTAL_DEVELOPMENT_BUDGET!D124","v":0},{"$f":"SUM(D128:D136)","v":0},0,{"$f":"SUM(F128:F136)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[null,null,"Total Sources and Uses","DFD Underwriting ","Requested Changes","DFD Per Unit","DFD Per Sq. Foot"]
["TOTAL USES OF FUNDS",null,{"$f":"SUM(C137,C75,C125,C120,C47,C31)","v":0},{"$f":"SUM(D137,D125,D120,D47,D31,D75)","v":0},{"$f":"SUM(E137,E125,E120,E47,E31)","v":0},{"$f":"SUM(F137,F125,F120,F47,F31)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G137,G125,G120,G47,G31)","v":{"$error":"#DIV/0!"}}]