{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Project Description","Unit Mix","Operating Budget","Mortgage Calculation","Development Costs","Sources","Cash Flow","Amortization Schedule","Summary (MHFA Use Only)","DropDownList"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":134,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,0,14,14],[16,0,16,14],[17,0,17,14],[8,0,8,14],[0,0,0,14],[3,0,3,14],[5,0,5,14],[7,0,7,14],[13,0,13,14]]}
["MINNESOTA HOUSING WORKFORCE HOUSING DEVELOPMENT PROGRAM WORKBOOK INSTRUCTIONS"]
["Workbook Version: March 2026"]
[]
["The current version of the Workforce Housing Development Program (WHDP) Workbook must be used when requesting funding under the WHDP Program at Minnesota Housing. "]
[]
["A completed Workbook along with the required documentation and exhibits comprise a complete application package.  "]
[]
["DATA ENTRY AND VALIDATION"]
["Light blue cells indicate where information is required from the applicant. In some cases, incomplete data entry will result in other required fields being left unpopulated.  "]
[]
[null,null,"Light blue cells indicate where information is required from the applicant."]
[null,null,"White cells indicate standard text or formulas that are locked from editing."]
[]
["CELL COMMENTS/INSTRUCTIONS"]
["Some cells have embedded comments, indicated by a small red triangle in the upper right hand corner. Click or hover over the triangle to see the comments. These comments contain important information related to populating the Workbook and the cell."]
[]
["PRINTING"]
["Select File > Print to access Excel's print functionality. Excel will default to have 'Print Active Sheet' selected, or you can select to 'Print Entire Workbook' to print all tabs of the WHDP Workbook."]

{"sheet":"Project Description","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,0,5,1],[8,3,8,4],[6,3,6,4],[0,0,0,4],[2,0,2,3],[3,0,3,3],[5,3,5,4]]}
["PROJECT DESCRIPTION"]
[]
["Amount of Workforce Housing Development Program funds being requested",null,null,null,{"$f":"Sources_WorkforceHousingRequestedAmount","v":0}]
["Percentage of Total Development Costs",null,null,null,{"$f":"IFERROR(Sources_WorkforceHousingRequestedAmount/DevCosts_TDC,0)","v":0}]
[]
["Name and Location",null,null,"Activity Type (Select one)"]
["Project Name"]
["Project Address"]
["City",null,null,"Unit Information"]
["Zip Code",null,null,"Will this project contain any income restricted units? (Select one)"]
["County",null,null,"Number of Restricted Units (Enter data on Unit Mix tab)",{"$f":"SUM('Unit Mix'!G6:G26)","v":0}]
[null,null,null,"Number of Market Rate Units (Enter data on Unit Mix tab)",{"$f":"SUM('Unit Mix'!F6:F26)","v":0}]
["Applicant Information",null,null,"Total Number of Units",{"$f":"UnitMix_Summary_UnitCount_Total","v":0}]
["Name of Eligible Recipient Submitting Application"]
["Eligible Recipient Mailing Address",null,null,"Property Information"]
["Eligible Recipient City",null,null,"Year Built"]
["Eligible Recipient Zip Code",null,null,"Census Tract"]
["Eligible Recipient's Authorized Representative Full Name",null,null,"Building Type"]
["Eligible Recipient's Authorized Representative Title",null,null,"# of Residential Buildings"]
["Eligible Recipient's Authorized Representative Phone",null,null,"Number of Stories"]
["Eligible Recipient's Authorized Representative Email",null,null,"Covered Parking Type"]
["Secondary Contact Full Name",null,null,"# Covered Parking Spaces"]
["Secondary Contact Title",null,null,"# Surface Parking Spaces"]
["Secondary Contact Phone"]
["Secondary Contact Email"]
[]
["Development Team"]
["Developer"]
["Permanent Owner "]
["Architect"]
["General Contractor"]
["Management Company "]

{"sheet":"Unit Mix","index":2,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[28,5,28,7],[29,5,29,6],[30,5,30,6],[28,0,28,2],[0,0,0,9],[3,0,3,9]]}
["UNIT MIX"]
[]
[]
["Rent Grid"]
["Bedrooms (Select one)","Baths","Number of Units","Square Feet","Monthly Net Rent","Number of Market Rate Units","Number of Income Restricted Units","Annual Net Rent","Number of Rooms Per Unit","Total Rooms"]
[null,null,null,null,null,null,null,{"$f":"C6*E6*12","v":0},{"$f":"IF(A6=\"\", \"0\", _xlfn.IFS(A6=\"studio\", 2.5, VALUE(A6)=1, 3.5, VALUE(A6)=2, 4.5, VALUE(A6)=3, 6, VALUE(A6)=4, 7, VALUE(A6)=5, 8.5))","v":"0"},{"$f":"IFERROR(IF(OR(ISBLANK(I6),ISBLANK(C6)), 0, I6*C6), 0)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"IF(A7=\"\", \"0\", _xlfn.IFS(A7=\"studio\", 2.5, VALUE(A7)=1, 3.5, VALUE(A7)=2, 4.5, VALUE(A7)=3, 6, VALUE(A7)=4, 7, VALUE(A7)=5, 8.5))","v":"0"},{"$f":"IFERROR(IF(OR(ISBLANK(I7),ISBLANK(C7)), 0, I7*C7), 0)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"IF(A8=\"\", \"0\", _xlfn.IFS(A8=\"studio\", 2.5, VALUE(A8)=1, 3.5, VALUE(A8)=2, 4.5, VALUE(A8)=3, 6, VALUE(A8)=4, 7, VALUE(A8)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A9=\"\", \"0\", _xlfn.IFS(A9=\"studio\", 2.5, VALUE(A9)=1, 3.5, VALUE(A9)=2, 4.5, VALUE(A9)=3, 6, VALUE(A9)=4, 7, VALUE(A9)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A10=\"\", \"0\", _xlfn.IFS(A10=\"studio\", 2.5, VALUE(A10)=1, 3.5, VALUE(A10)=2, 4.5, VALUE(A10)=3, 6, VALUE(A10)=4, 7, VALUE(A10)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A11=\"\", \"0\", _xlfn.IFS(A11=\"studio\", 2.5, VALUE(A11)=1, 3.5, VALUE(A11)=2, 4.5, VALUE(A11)=3, 6, VALUE(A11)=4, 7, VALUE(A11)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A12=\"\", \"0\", _xlfn.IFS(A12=\"studio\", 2.5, VALUE(A12)=1, 3.5, VALUE(A12)=2, 4.5, VALUE(A12)=3, 6, VALUE(A12)=4, 7, VALUE(A12)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A13=\"\", \"0\", _xlfn.IFS(A13=\"studio\", 2.5, VALUE(A13)=1, 3.5, VALUE(A13)=2, 4.5, VALUE(A13)=3, 6, VALUE(A13)=4, 7, VALUE(A13)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A14=\"\", \"0\", _xlfn.IFS(A14=\"studio\", 2.5, VALUE(A14)=1, 3.5, VALUE(A14)=2, 4.5, VALUE(A14)=3, 6, VALUE(A14)=4, 7, VALUE(A14)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A15=\"\", \"0\", _xlfn.IFS(A15=\"studio\", 2.5, VALUE(A15)=1, 3.5, VALUE(A15)=2, 4.5, VALUE(A15)=3, 6, VALUE(A15)=4, 7, VALUE(A15)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A16=\"\", \"0\", _xlfn.IFS(A16=\"studio\", 2.5, VALUE(A16)=1, 3.5, VALUE(A16)=2, 4.5, VALUE(A16)=3, 6, VALUE(A16)=4, 7, VALUE(A16)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A17=\"\", \"0\", _xlfn.IFS(A17=\"studio\", 2.5, VALUE(A17)=1, 3.5, VALUE(A17)=2, 4.5, VALUE(A17)=3, 6, VALUE(A17)=4, 7, VALUE(A17)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A18=\"\", \"0\", _xlfn.IFS(A18=\"studio\", 2.5, VALUE(A18)=1, 3.5, VALUE(A18)=2, 4.5, VALUE(A18)=3, 6, VALUE(A18)=4, 7, VALUE(A18)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A19=\"\", \"0\", _xlfn.IFS(A19=\"studio\", 2.5, VALUE(A19)=1, 3.5, VALUE(A19)=2, 4.5, VALUE(A19)=3, 6, VALUE(A19)=4, 7, VALUE(A19)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A20=\"\", \"0\", _xlfn.IFS(A20=\"studio\", 2.5, VALUE(A20)=1, 3.5, VALUE(A20)=2, 4.5, VALUE(A20)=3, 6, VALUE(A20)=4, 7, VALUE(A20)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A21=\"\", \"0\", _xlfn.IFS(A21=\"studio\", 2.5, VALUE(A21)=1, 3.5, VALUE(A21)=2, 4.5, VALUE(A21)=3, 6, VALUE(A21)=4, 7, VALUE(A21)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A22=\"\", \"0\", _xlfn.IFS(A22=\"studio\", 2.5, VALUE(A22)=1, 3.5, VALUE(A22)=2, 4.5, VALUE(A22)=3, 6, VALUE(A22)=4, 7, VALUE(A22)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A23=\"\", \"0\", _xlfn.IFS(A23=\"studio\", 2.5, VALUE(A23)=1, 3.5, VALUE(A23)=2, 4.5, VALUE(A23)=3, 6, VALUE(A23)=4, 7, VALUE(A23)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A24=\"\", \"0\", _xlfn.IFS(A24=\"studio\", 2.5, VALUE(A24)=1, 3.5, VALUE(A24)=2, 4.5, VALUE(A24)=3, 6, VALUE(A24)=4, 7, VALUE(A24)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A25=\"\", \"0\", _xlfn.IFS(A25=\"studio\", 2.5, VALUE(A25)=1, 3.5, VALUE(A25)=2, 4.5, VALUE(A25)=3, 6, VALUE(A25)=4, 7, VALUE(A25)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,0,{"$f":"IF(A26=\"\", \"0\", _xlfn.IFS(A26=\"studio\", 2.5, VALUE(A26)=1, 3.5, VALUE(A26)=2, 4.5, VALUE(A26)=3, 6, VALUE(A26)=4, 7, VALUE(A26)=5, 8.5))","v":"0"},0]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J6:J26)","v":0}]
[]
["Unit Mix",null,null,null,null,"Rent Summary"]
["Floor Plan","# Units","% Units",null,null,"Average Net Rent",null,{"$f":"IFERROR(UnitMix_GrossRentPotential/12/UnitMix_Summary_UnitCount_Total,0)","v":0}]
["Studio",{"$f":"SUMIF($A$6:$A$26,\"Studio\",C$6:$C$26)","v":0},{"$f":"IFERROR(B31/UnitMix_Summary_UnitCount_Total,0)","v":0},null,null,"Gross Rent Potential",null,{"$f":"SUM(H6:H26)","v":0}]
["1 BR",{"$f":"SUMIF($A$6:$A$26,1,C$6:$C$26)","v":0},0]
["2 BR",{"$f":"SUMIF($A$6:$A$26,2,C$6:$C$26)","v":0},0]
["3 BR",{"$f":"SUMIF($A$6:$A$26,3,C$6:$C$26)","v":0},0]
["4 BR",{"$f":"SUMIF($A$6:$A$26,4,C$6:$C$26)","v":0},0]
["5 BR",{"$f":"SUMIF($A$6:$A$26,5,C$6:$C$26)","v":0},0]
["Total",{"$f":"SUM(B31:B36)","v":0},{"$f":"SUM(C31:C36)","v":0}]

{"sheet":"Operating Budget","index":3,"n_rows":85,"n_cols":13,"rows_kept":85,"cut":false,"hidden":false,"merged":[[79,12,79,14],[74,12,74,14],[54,12,54,14],[56,12,56,14],[57,12,57,14],[58,12,58,14],[59,12,59,14],[84,1,84,8],[80,1,80,14],[81,1,81,8],[82,1,82,8],[83,1,83,8],[72,1,72,8],[73,1,73,14],[74,1,74,8],[75,1,75,8],[72,12,72,14],[75,12,75,14],[77,12,77,14],[78,12,78,14],[77,2,77,6],[78,2,78,6],[76,1,76,6],[76,8,76,14],[79,1,79,8],[18,1,18,8],[21,1,21,4],[21,5,21,6],[58,1,58,8],[59,1,59,8],[61,1,61,8],[54,1,54,8],[56,1,56,8],[57,1,57,8],[51,1,51,8],[42,1,42,8],[43,1,43,8],[49,1,49,8],[50,1,50,8],[22,5,22,6],[23,3,23,7],[24,3,24,7],[25,1,25,8],[27,1,27,8],[69,12,69,14],[70,12,70,14],[67,12,67,14],[68,12,68,14],[67,1,67,8],[68,1,68,8],[69,1,69,8],[70,1,70,8],[61,12,61,14],[63,12,63,14],[63,1,63,8],[65,12,65,14],[65,1,65,8],[10,1,10,8],[4,1,4,14],[3,1,3,8],[6,12,6,14],[7,12,7,14],[14,1,14,2],[15,1,15,2],[39,1,39,8],[34,2,34,5],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[34,12,34,14],[30,1,30,14],[31,1,31,8],[32,1,32,4],[33,2,33,5],[23,1,23,2],[24,1,24,2],[22,1,22,4],[28,1,28,14],[21,12,21,14],[17,1,17,8],[0,1,1,14],[17,12,17,14],[18,12,18,14],[20,1,20,4],[20,5,20,6],[20,12,20,14],[13,12,13,14],[14,3,14,7],[14,12,14,14],[15,3,15,7],[15,12,15,14],[16,12,16,14],[8,12,8,14],[9,4,9,7],[9,12,9,14],[10,12,10,14],[12,12,12,14],[3,12,3,14],[5,12,5,14],[12,1,12,8],[13,1,13,8],[16,1,16,8],[5,1,5,8],[6,1,6,8],[47,12,47,14],[48,12,48,14],[46,12,46,14],[36,12,36,14],[49,12,49,14],[44,12,44,14],[45,12,45,14],[52,1,52,8],[53,1,53,8],[44,1,44,8],[45,1,45,8],[46,1,46,8],[47,1,47,8],[48,1,48,8],[53,12,53,14],[52,12,52,14],[51,12,51,14],[50,12,50,14],[38,12,38,14],[39,12,39,14],[40,12,40,14],[37,12,37,14],[40,1,40,8],[35,12,35,14],[42,12,42,14],[43,12,43,14],[33,12,33,14],[29,1,29,8],[22,12,22,14],[31,12,31,14],[32,12,32,14],[27,12,27,14],[29,12,29,14],[23,12,23,14],[24,12,24,14],[25,12,25,14]]}
[null,"OPERATING BUDGET"]
[]
[]
[null,"INCOME",null,null,null,null,null,null,null,"Total","Per Unit","Per Room","Comments"]
[null,"GROSS POTENTIAL RENT"]
[null,"Rental Housing Potential",null,null,null,null,null,null,null,{"$f":"UnitMix_GrossRentPotential","v":0},{"$f":"IFERROR(J6/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J6/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Parking / Garage Rent Potential",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J7/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J7/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,null,"Covered Parking",null,"# of spaces",{"$f":"ProjDesc_Covered_Parking_Spaces","v":0},"Mo Fee",null,null,{"$f":"F8*H8*12","v":0},{"$f":"IFERROR(J8/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J8/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,null,"Surface Parking",null,"# of spaces",{"$f":"ProjDesc_Surface_Parking_Spaces","v":0},"Mo Fee",null,null,{"$f":"F9*H9*12","v":0},0,{"$f":"IFERROR(J9/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Commercial Rent Potential ",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J10/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Gross Potential Rent",null,null,null,null,null,null,null,{"$f":"SUM(J6:J10)","v":0},{"$f":"SUM(K6:K10)","v":0},0]
[null,"OTHER INCOME FROM OPERATIONS",null,null,null,null,null,null,null,null,0]
[null,"Tenant Fees",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J13/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Laundry Equipment",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J14/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Other  ",null,null,null,null,null,null,null,null,0,0]
[null,"Other ",null,null,null,null,null,null,null,null,0,0]
[null,"Forfeited Security Deposits",null,null,null,null,null,null,null,null,0,0]
[null,"Interest Income",null,null,null,null,null,null,null,null,0,0]
[null,"Total Other Income",null,null,null,null,null,null,null,{"$f":"SUM(J13:J18)","v":0},{"$f":"SUM(K13:K18)","v":0},{"$f":"SUM(L13:L18)","v":0}]
[null,"RENTAL LOSS",null,null,null,null,null,null,null,null,0]
[null,"Rental Housing Vacancy ",null,null,null,"Vacancy Rate",null,null,null,{"$f":"ROUND((J6+J19)*H21,)","v":0},0,{"$f":"IFERROR(J21/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Parking / Garage Vacancy",null,null,null,"Vacancy Rate",null,null,null,{"$f":"ROUND((J8+J9)*H22,)","v":0},0,{"$f":"IFERROR(J22/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Commercial Vacancy",null,null,null,"Vacancy Rate",null,null,null,{"$f":"ROUND(J10*H23,)","v":0},0,{"$f":"IFERROR(J23/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Other",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J24/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Other ",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J25/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Total Rental Loss",null,null,null,null,null,null,null,{"$f":"SUM(J21:J25)","v":0},{"$f":"SUM(K21:K25)","v":0},{"$f":"SUM(L21:L25)","v":0}]
[null,"NET RENTAL INCOME",null,null,null,null,null,null,null,null,0]
[null,"Net Rental Income / Total Revenue",null,null,null,null,null,null,null,{"$f":"J11+J19-J26","v":0},{"$f":"K11+K19-K26","v":0},{"$f":"L11+L19-L26","v":0}]
[]
[null,"EXPENSES",null,null,null,null,null,null,null,"Total","Per Unit","Per Room","Comments"]
[null,"ADMINISTRATIVE"]
[null,"Advertising and Marketing",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J32/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J32/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Property Management Fee",null,null,null,null,"% Revenue","$/Unit/Mo",null,{"$f":"IF(AND(G34<>0,G34<>\"\"),J28*G34,IF(AND(G35<>0,G35<>\"\"),J28*G35,0))","v":0},0,{"$f":"IFERROR(J33/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,null,"Percent of Total Revenue (OR)",null,null,null,null,{"$f":"IF(UnitMix_Summary_UnitCount_Total=0,0,OpBudget_NetRentalIncomeTotal*OpBudget_Expense_PropertyManagementFeePercentofTotalRevenue/UnitMix_Summary_UnitCount_Total/12)","v":0},null,null,0]
[null,null,"Per Unit Per Month",null,null,null,{"$f":"IF(OpBudget_NetRentalIncomeTotal=0,0,((OpBudget_PropertyManagementFeePerUnitPerMonthRevenue*UnitMix_Summary_UnitCount_Total*12)/OpBudget_NetRentalIncomeTotal))","v":0},null,null,null,0]
[null,"Professional Fees (Specify in Comments)",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J36/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Applicant Screening/Collection Expense",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J37/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Site Office Expense (Specify in Comments)",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J38/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"On-Site Management Payroll (Specify in Comments)",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J39/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Other Administration (Specify in Comments)",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J40/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Administrative Subtotal",null,null,null,null,null,null,null,{"$f":"SUM(J32:J40)","v":0},{"$f":"SUM(K32:K40)","v":0},{"$f":"SUM(L32:L40)","v":0}]
[null,"MAINTENANCE",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J42/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Elevator Maintenance/Contract",null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(J43/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Security",null,null,null,null,null,null,null,null,0,0]
[null,"Rubbish Removal",null,null,null,null,null,null,null,null,0,0]
[null,"Other Contract Services (Includes Exterminating)",null,null,null,null,null,null,null,null,0,0]
[null,"Maintenance/Janitor Supplies",null,null,null,null,null,null,null,null,0,0]
[null,"Grounds Maintenance",null,null,null,null,null,null,null,null,0,0]
[null,"Snow Removal",null,null,null,null,null,null,null,null,0,0]
[null,"Heat & A/C Repair Services",null,null,null,null,null,null,null,null,0,0]
[null,"General Repair Services",null,null,null,null,null,null,null,null,0,0]
[null,"Painting/Decorating Materials",null,null,null,null,null,null,null,null,0,0]
[null,"Maintenance/Janitor Payroll (Specify in Comments)",null,null,null,null,null,null,null,null,0,0]
[null,"Other Maintenance and Operating (Specify in Comments)",null,null,null,null,null,null,null,null,0,0]
[null,"Maintenance Subtotal",null,null,null,null,null,null,null,{"$f":"SUM(J43:J54)","v":0},{"$f":"SUM(K43:K54)","v":0},0]
[null,"UTILITIES",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J56/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Electricity",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J57/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J57/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Water & Sewer",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J58/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J58/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Gas and Oil",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J59/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J59/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Utilities Subtotal",null,null,null,null,null,null,null,{"$f":"SUM(J57:J59)","v":0},{"$f":"SUM(K57:K59)","v":0},0]
[null,"SUPPORTIVE HOUSING",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J61/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Unique Operating Expenses (Specify in comments)",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J62/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J62/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"INSURANCE",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J63/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Property and Liability Insurance Expense",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J64/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J64/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"TOTAL MANAGEMENT AND OPERATING EXPENSES",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J65/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Total M&O",null,null,null,null,null,null,null,{"$f":"J41+J55+J60+J62+J64","v":0},{"$f":"K41+K55+K60+K62+K64","v":0},{"$f":"L41+L55+L60+L62+L64","v":0}]
[null,"REALESTATE TAXES & RESERVES"]
[null,"Real Estate Taxes",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J68/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J68/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Replacement Reserve",null,null,null,null,null,null,null,{"$f":"K69*UnitMix_Summary_UnitCount_Total","v":0},null,{"$f":"IFERROR(J69/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Miscellaneous Reserves",null,null,null,null,null,null,null,0,{"$f":"IFERROR(J70/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J70/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Reserves & Escrows Subtotal",null,null,null,null,null,null,null,{"$f":"SUM(J68:J70)","v":0},{"$f":"SUM(K68:K70)","v":0},{"$f":"SUM(L68:L70)","v":0}]
[null,"TOTAL OPERATING EXPENSES"]
[null,"Total Operating Expenses",null,null,null,null,null,null,null,{"$f":"J66+J71","v":0},{"$f":"K66+K71","v":0},{"$f":"L66+L71","v":0}]
[]
[null,"NET OPERATING INCOME",null,null,null,null,null,null,null,"Total","Per Unit","Per Room","Comments"]
[null,"Net Operating Income",null,null,null,null,null,null,null,{"$f":"J28-J73","v":0},{"$f":"K28-K73","v":0},{"$f":"L28-L73","v":0}]
[null,"TEMPORARY INCOME (i.e., TIF, IRP, etc)",null,null,null,null,null,"# Years"]
[null,"TIF",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J78/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J78/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Specify",null,null,null,null,null,null,null,null,{"$f":"IFERROR(J79/UnitMix_Summary_UnitCount_Total,0)","v":0},{"$f":"IFERROR(J79/UnitMix_RentGrid_TotalRooms,0)","v":0}]
[null,"Total Temporary Income",null,null,null,null,null,null,null,{"$f":"SUM(J78:J79)","v":0},{"$f":"SUM(K78:K79)","v":0},{"$f":"SUM(L78:L79)","v":0}]
[null,"EXPENSE ANALYSIS"]
[null,null,null,null,null,null,null,null,null,"Monthly","Annual"]
[null,"Expense Ratio",null,null,null,null,null,null,null,{"$f":"K83/12","v":0},{"$f":"IFERROR(CashFlow_EffectiveGrossExpense_Year1/CashFlow_NetRentalIncome_Year1,0)","v":0}]
[null,"M&O per unit",null,null,null,null,null,null,null,{"$f":"ROUND(K84/12,)","v":0},{"$f":"'Operating Budget'!K66","v":0}]
[null,"M&O minus Insurance per unit",null,null,null,null,null,null,null,{"$f":"ROUND(K85/12,)","v":0},{"$f":"K84-'Operating Budget'!K64","v":0}]

{"sheet":"Mortgage Calculation","index":4,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[9,4,10,4],[16,1,16,3],[0,1,1,10],[4,5,4,7],[6,1,6,3],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3]]}
[null,"MORTGAGE CALCULATION"]
[]
[]
[null,"Income Available for Debt Service"]
[null,null,null,null,null,null,null,null,null,"Year 1","Year 15"]
[null,"Net Operating Income",null,null,null,null,null,null,null,{"$f":"'Cash Flow'!K34","v":0},{"$f":"'Cash Flow'!Y34","v":0}]
[null,"Temporary Income (excluding TIF)"]
[null,"Income Available for Debt Service",null,null,null,null,null,null,null,{"$f":"SUM(J6:J7)","v":0},{"$f":"SUM(K6:K7)","v":0}]
[null,"Subordinated Debt Payments"]
[null,null,null,null,"X' if Minnesota Housing","Principal","Rate","Term (Years)","Amort (Years)","Debt Service\nYear 1","Debt Service\nYear 15"]
[null,"Lender/Loan"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F12>0,PMT(G12/12,I12*12,-F12,),)*12","v":0},{"$f":"J12","v":0}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"J13","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,"Total Subordinated Debt Payments",null,null,null,null,null,null,null,{"$f":"SUM(J12:J17)","v":0},{"$f":"SUM(K12:K17)","v":0}]
[null,"Income Available for Debt Service",null,null,null,null,null,null,null,{"$f":"J8-J18","v":0},{"$f":"K8-K18","v":0}]
[null,"Minimum Debt Coverage Ratio"]
[null,"Net Income Available for Debt Service",null,null,null,null,null,null,null,{"$f":"IFERROR(J19/J20,0)","v":0},{"$f":"IFERROR(K19/K20,0)","v":0}]
[]
[null,"First Mortgage Calculation"]
[null,"Lowest Income Available for Debt Service",null,null,null,null,null,null,null,null,{"$f":"MIN(J21:K21)","v":0}]
[null,"Term (Years)"]
[null,"Amortization (Years)"]
[null,"Interest Rate"]
[null,"Mortgage Insurance Premium (MIP)",null,null,null,null,null,null,null,null,null,null,"If MIP is not applicable, enter '0' in cell K28."]
[null,"Debt Service Constant (including MIP)",null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(MortgageCalc_FirstMortgCalc_FirstMortg_InterestRate),ISBLANK(MortgageCalc_FirstMortgCalc_FirstMortg_MIP),ISBLANK(MortgageCalc_FirstMortgCalc_FirstMortg_Amortization)),0,PMT((MortgageCalc_FirstMortgCalc_FirstMortg_InterestRate)/12,MortgageCalc_FirstMortgCalc_FirstMortg_Amortization*12,-1)*12+MortgageCalc_FirstMortgCalc_FirstMortg_MIP)","v":0}]
[null,"Maximum Calculated Mortgage",null,null,null,null,null,null,null,null,{"$f":"IF(K29=0,0,K24/K29)","v":0}]
[null,"Maximum NOI Supported Mortgage (rounded)",null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(K30,-3)","v":0}]
[null,"Actual Mortgage if not Maximum Supported"]
[]
[null,"TIF Mortgage Calculation"]
[null,"Annual TIF Payment",null,null,null,null,null,null,null,null,{"$f":"'Operating Budget'!J78","v":0}]
[null,"Minimum Debt Coverage Ratio"]
[null,"Available TIF for Debt Service",null,null,null,null,null,null,null,null,{"$f":"IFERROR(K35/K36,0)","v":0}]
[null,"Term (Years)"]
[null,"Interest Rate"]
[null,"Mortgage Insurance Premium (MIP)"]
[null,"Debt Service Constant (including MIP)",null,null,null,null,null,null,null,null,{"$f":"IF(OR(K39=0,K38=0),0,(PMT(K39/12,K38*12,-1,)*12)+K40)","v":0}]
[null,"Maximum Calculated TIF Mortgage",null,null,null,null,null,null,null,null,{"$f":"IF(K41=0,0,K37/K41)","v":0}]
[null,"Maximum TIF Supported Mortgage (rounded)",null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(K42,-3)","v":0}]
[null,"Actual TIF Mortgage if not Maximum Supported"]
[null,"TIF Mortgage Included in First Mortgage (type \"x\" if true)"]

{"sheet":"Development Costs","index":5,"n_rows":125,"n_cols":10,"rows_kept":125,"cut":false,"hidden":false,"merged":[[59,3,59,5],[13,3,13,5],[22,3,22,5],[23,3,23,5],[31,3,31,5],[32,3,32,5],[35,4,37,4],[0,1,1,9],[8,1,8,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[113,1,113,2],[113,4,113,5],[123,3,123,5],[122,3,122,5],[109,1,109,2],[109,4,109,5],[110,1,110,2],[110,4,110,5],[111,1,111,2],[111,4,111,5],[112,1,112,2],[112,4,112,5],[69,3,69,5],[103,3,103,5],[104,3,104,5],[105,3,105,5],[70,3,70,5],[71,3,71,5],[72,3,72,5],[79,3,79,5],[89,3,89,5]]}
[null,"DEVELOPMENT COSTS"]
[]
[]
[null,null,null,null,null,null,null,"Total Costs","Per Unit","Comments"]
[null,"ACQUISITION "]
[null,"Land",null,null,null,null,null,null,{"$f":"IFERROR(H6/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Existing Structures",null,null,null,null,null,null,0]
[null,"Demolition",null,null,null,null,null,null,0]
[null,"Acquisition/Refinance Subtotal",null,null,null,null,null,{"$f":"SUM(H6:H8)","v":0},0]
[null,"Special Assessments",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"Holding Costs",null,null,null,null,null,null,0]
[null,"Holding Costs",null,null,null,null,null,null,0]
[null,"Acquisition Total",null,null,null,null,null,{"$f":"SUM(H9:H14)","v":0},{"$f":"SUM(I9:I14)","v":0}]
[null,"CONSTRUCTION"]
[null,"New Construction"]
[null,"Residential",null,null,null,null,null,null,{"$f":"IFERROR(H18/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Garages",null,null,null,null,null,null,0]
[null,"Accessory Structures",null,null,null,null,null,null,0]
[null,"On Site Work",null,null,null,null,null,null,0]
[null,"Off Site Work",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"New Construction Subtotal",null,null,null,null,null,{"$f":"SUM(H18:H24)","v":0},{"$f":"SUM(I18:I24)","v":0}]
[null,"Rehabilitation"]
[null,"Residential",null,null,null,null,null,null,{"$f":"IFERROR(H27/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Garages",null,null,null,null,null,null,0]
[null,"Accessory Structures",null,null,null,null,null,null,0]
[null,"On Site Work",null,null,null,null,null,null,0]
[null,"Off Site Work",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"Rehab Subtotal",null,null,null,null,null,{"$f":"SUM(H27:H33)","v":0},{"$f":"SUM(I27:I33)","v":0}]
[null,"New and Rehab Subtotal",null,null,null,null,null,{"$f":"H25+H34","v":0},{"$f":"I25+I34","v":0}]
[null,"General Requirements",null,null,{"$f":"IF(SUM(F36:F38)>14%,\"Over Limit\",\"\")","v":""},{"$f":"IFERROR(H36/H35,0)","v":0},null,null,{"$f":"IFERROR(H36/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Contractor's Overhead",null,null,null,{"$f":"IFERROR(H37/H35,0)","v":0},null,null,{"$f":"IFERROR(H37/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Contractor's Profit",null,null,null,{"$f":"IFERROR(H38/H35,0)","v":0},null,null,{"$f":"IFERROR(H38/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Construction Contract Amount",null,null,null,null,null,{"$f":"SUM(H35:H38)","v":0},{"$f":"SUM(I35:I38)","v":0}]
[null,"Contingency",null,null,null,{"$f":"IFERROR(H40/H39,0)","v":0},null,null,{"$f":"IFERROR(H40/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Total Construction Costs",null,null,null,null,null,{"$f":"H39+H40","v":0},{"$f":"I39+I40","v":0}]
[null,"ENVIRONMENTAL ABATEMENT"]
[null,"Soil Abatement",null,null,null,null,null,null,{"$f":"IFERROR(H43/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Lead Abatement",null,null,null,null,null,null,{"$f":"IFERROR(H44/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Asbestos Abatement",null,null,null,null,null,null,{"$f":"IFERROR(H45/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Other",null,null,null,null,null,null,{"$f":"IFERROR(H46/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Abatement Contingency (Agency determined)",null,null,null,null,null,null,{"$f":"IFERROR(H47/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Abatement Total",null,null,null,null,null,{"$f":"SUM(H43:H47)","v":0},{"$f":"SUM(I43:I47)","v":0}]
[null,"PROFESSIONAL FEES"]
[null,"Architect Total",null,null,null,{"$f":"IFERROR(D50/(H39-H57-H58),0)","v":0}]
[null,"Architect Fee - Design",null,null,null,null,null,{"$f":"ROUNDUP(D50*0.75,)","v":0},{"$f":"IFERROR(H51/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Architect Fee - Supervision",null,null,null,null,null,{"$f":"D50-H51","v":0},0]
[null,"Architect Reimbursables",null,null,null,null,null,null,0]
[null,"Marketing",null,null,null,null,null,null,0]
[null,"Surveys",null,null,null,null,null,null,0]
[null,"Soil Borings",null,null,null,null,null,null,0]
[null,"Payment & Performance Bond Premium",null,null,null,null,null,null,0]
[null,"Building Permit(s)",null,null,null,null,null,null,0]
[null,"Sewer-Water Access Charge",null,null,null,null,null,null,0]
[null,"Other Local Fees",null,null,null,null,null,null,0]
[null,"Appraisal Fee",null,null,null,null,null,null,0]
[null,"Energy Audit",null,null,null,null,null,null,0]
[null,"Energy Consultant",null,null,null,null,null,null,0]
[null,"Environmental Assessment",null,null,null,null,null,null,0]
[null,"Cost Certification/Audit",null,null,null,null,null,null,0]
[null,"Market Study",null,null,null,null,null,null,0]
[null,"Furnishings and Equipment",null,null,null,null,null,null,0]
[null,"Legal Fees",null,null,null,null,null,null,0]
[null,"Relocation Costs",null,null,null,null,null,null,0]
[null,"Other Fees",null,null,null,null,null,null,0]
[null,"Other Fees",null,null,null,null,null,null,0]
[null,"Other Fees",null,null,null,null,null,null,0]
[null,"Other Fees",null,null,null,null,null,null,0]
[null,"Professional Fees Total",null,null,null,null,null,{"$f":"SUM(H51:H73)","v":0},{"$f":"SUM(I51:I73)","v":0}]
[null,"DEVELOPER FEE"]
[null,"Developer Fee",null,null,null,null,null,null,{"$f":"IFERROR(H76/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Processing Agent",null,null,null,null,null,null,{"$f":"IFERROR(H77/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Owner's Construction Representative",null,null,null,null,null,null,{"$f":"IFERROR(H78/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Other Consultant Fees",null,null,null,null,null,null,{"$f":"IFERROR(H79/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Other",null,null,null,null,null,null,{"$f":"IFERROR(H80/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Developer Fee Total",null,null,{"$f":"IF(F81>0.06,\"Over Limit\",)","v":0},{"$f":"IFERROR(DevCosts_TotalDeveloperFee/(DevCosts_TDC- DevCosts_TotalDeveloperFee),0)","v":0},null,{"$f":"SUM(H76:H80)","v":0},{"$f":"SUM(I76:I80)","v":0}]
[null,"FINANCING COSTS"]
[null,"Construction Period Costs"]
[null,"Hazard and Liability Insurance",null,null,null,null,null,null,{"$f":"IFERROR(H84/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Construction Interest at:",null,null,null,null,null,null,0]
[null,"Builder's Risk Insurance",null,null,null,null,null,null,0]
[null,"Taxes During Construction",null,null,null,null,null,null,0]
[null,"Construction Loan Origination Fee",null,null,null,null,null,null,{"$f":"IFERROR(H88/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Other Inspection Fee",null,null,null,null,null,null,0]
[null,"Other",null,0,null,null,null,null,0]
[null,"Permanent Financing Costs"]
[null,"HUD/FHA MIP",null,null,null,null,null,null,{"$f":"IFERROR(H92/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"HUD/FHA Exam Fee",null,null,null,null,null,null,0]
[null,"HUD/FHA Inspection Fee",null,null,null,null,null,null,0]
[null,"Other Permanent Origination Fee",null,null,null,null,null,null,0]
[null,"Mortgage Insurance Premium",null,null,null,null,null,null,0]
[null,"Bond Issuance Fee",null,null,null,null,null,null,0]
[null,"Bond Counsel",null,null,null,null,null,null,0]
[null,"Underwriter Counsel",null,null,null,null,null,null,0]
[null,"Trustee Fee",null,null,null,null,null,null,0]
[null,"Rating Agency",null,null,null,null,null,null,0]
[null,"Other Bond Fees",null,null,null,null,null,null,0]
[null,"Title and Recording",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,0]
[null,"Financing Costs Total",null,null,null,null,null,{"$f":"SUM(H84:H106)","v":0},{"$f":"SUM(I84:I106)","v":0}]
[null,"Total Mortgageable Costs",null,null,null,null,null,{"$f":"SUM(H15+H41+H48+H74+H81+H107)","v":0},{"$f":"I15+I41+I48+I74+I81+I107","v":0}]
[null,"RESERVES"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(H110/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(H111/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(H112/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(H113/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(H114/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Total Reserves",null,null,null,null,null,{"$f":"SUM(H110:H114)","v":0},{"$f":"SUM(I110:I114)","v":0}]
[null,"TOTAL DEVELOPMENT COSTS"]
[null,"Total Development Costs",null,null,null,null,null,{"$f":"H108+H115","v":0},{"$f":"IFERROR(H117/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[]
[null,"OTHER COSTS NOT INCLUDED IN THE DEVELOPMENT BUDGET"]
[null,"Operating Deficit Escrow"]
[null,"Insurance Escrow"]
[null,"Tax Escrow"]
[null,"Other"]
[null,"Other"]
[null,"Total",null,null,null,null,null,{"$f":"SUM(H120:H124)","v":0}]

{"sheet":"Sources","index":6,"n_rows":90,"n_cols":17,"rows_kept":90,"cut":false,"hidden":false,"merged":[[87,11,87,15],[88,11,88,15],[89,11,89,15],[48,5,48,10],[56,11,56,15],[72,11,72,15],[73,11,73,15],[74,11,74,15],[75,11,75,15],[78,11,78,15],[79,11,79,15],[80,11,80,15],[81,11,81,15],[63,11,63,15],[64,11,64,15],[65,11,65,15],[66,11,66,15],[67,11,67,15],[68,11,68,15],[69,11,69,15],[71,11,71,15],[62,11,62,15],[51,11,51,15],[52,11,52,15],[86,1,86,3],[87,1,87,3],[88,1,88,3],[89,1,89,3],[77,11,77,15],[70,1,70,3],[71,1,71,3],[72,1,72,3],[73,1,73,3],[74,1,74,3],[75,1,75,3],[77,1,77,3],[78,1,78,3],[79,1,79,3],[80,1,80,3],[81,1,81,3],[82,1,82,3],[83,1,83,3],[84,1,84,3],[82,11,82,15],[70,11,70,15],[83,11,83,15],[86,11,86,15],[84,11,84,15],[16,1,16,3],[20,1,20,3],[19,10,19,15],[20,10,20,15],[21,10,21,15],[15,1,15,3],[0,1,1,15],[3,1,3,15],[4,1,4,3],[4,9,4,15],[5,1,5,3],[5,9,5,15],[6,1,6,3],[6,9,6,15],[7,1,7,3],[7,9,7,15],[66,1,66,3],[67,1,67,3],[55,1,55,3],[68,1,68,3],[58,1,58,3],[60,1,60,3],[61,1,61,3],[8,1,8,3],[8,9,8,15],[22,1,22,3],[18,1,18,3],[19,1,19,3],[9,1,9,3],[9,9,9,15],[12,1,12,15],[13,1,13,3],[13,10,13,15],[14,10,14,15],[15,10,15,15],[16,10,16,15],[17,10,17,15],[18,10,18,15],[14,1,14,3],[17,1,17,3],[26,1,26,3],[21,1,21,3],[27,1,27,3],[58,11,58,15],[28,1,28,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[22,10,22,15],[23,10,23,15],[24,10,24,15],[25,10,25,15],[26,10,26,15],[27,10,27,15],[28,10,28,15],[29,10,29,15],[49,11,49,15],[49,1,49,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[33,1,33,15],[34,10,34,15],[35,10,35,15],[69,1,69,3],[29,1,29,3],[31,1,31,3],[47,1,47,15],[59,1,59,3],[61,11,61,15],[60,11,60,15],[56,1,56,3],[57,1,57,3],[37,10,37,15],[55,11,55,15],[57,11,57,15],[59,11,59,15],[36,10,36,15],[38,10,38,15],[42,10,42,15],[53,11,53,15],[54,11,54,15],[53,1,53,3],[54,1,54,3],[62,1,62,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[43,1,43,3],[44,1,44,3],[39,10,39,15],[40,10,40,15],[41,10,41,15],[45,1,45,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[34,4,34,6],[35,4,35,6],[36,4,36,6],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6],[41,4,41,6],[42,4,42,6]]}
[null,"SOURCES"]
[]
[]
[null,"INTERIM SOURCES (do not include perm sources to be used during construction in this table)"]
[null,"Name of Source",null,null,"Term","Rate","Amount","Per Unit","Committed","Comments"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(G6/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Total Interim Financing",null,null,null,null,{"$f":"SUM(G6:G10)","v":0},0]
[]
[null,"PERMANENT SOURCES"]
[null,"Name of Source",null,null,"Term","Rate","Amount","Per Unit","Committed","End Loan","Comments"]
[null,"First Mortgage",null,null,{"$f":"'Mortgage Calculation'!K25","v":0},{"$f":"'Mortgage Calculation'!K27","v":0},{"$f":"IF(ISBLANK('Mortgage Calculation'!K32),'Mortgage Calculation'!K31,'Mortgage Calculation'!K32)+IF('Mortgage Calculation'!K45=\"x\",IF(ISBLANK('Mortgage Calculation'!K44),'Mortgage Calculation'!K43,'Mortgage Calculation'!K44),0)","v":0},{"$f":"IFERROR(G15/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"TIF Mortgage (if separate from 1st)",null,null,{"$f":"IF(($G$16=0),\"\",'Mortgage Calculation'!K38)","v":""},{"$f":"IF($G$16=0,\"\",'Mortgage Calculation'!K39)","v":""},{"$f":"IF('Mortgage Calculation'!K45<>\"x\",IF(ISBLANK('Mortgage Calculation'!K44),'Mortgage Calculation'!K43,'Mortgage Calculation'!K44),0)","v":0},{"$f":"IFERROR(G16/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Developer Cash Equity",null,null,null,null,null,0]
[null,"Sales Tax Rebate",null,null,null,null,null,0]
[null,"Energy Rebates",null,null,null,null,null,0]
[null,"Workforce Housing Program ",null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"IF(DevCosts_TDC=\" \", \" \",IF(G20=\"\",\"\",IF(G20/DevCosts_TDC<=0.5,\"\",\"** Maximum request cannot exceed 50% of Total Development Costs\")))","v":""}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Total Permanent Financing",null,null,null,null,{"$f":"SUM(G15:G30)","v":0},{"$f":"IFERROR(G31/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,"Funding Gap/(Surplus)",null,null,null,null,{"$f":"ROUND('Development Costs'!H117,)-Sources!G31","v":0},0]
[]
[null,"MATCH SOURCES"]
[null,"Name of Source",null,null,"Match Source Organization",null,null,"Amount","Per Unit","Match Type","Comments"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(H36/UnitMix_Summary_UnitCount_Total,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,"Total Match",null,null,null,null,null,{"$f":"SUM(H36:H43)","v":0},0]
[null,"Minimum Required Match",null,null,null,null,null,{"$f":"Sources_WorkforceHousingRequestedAmount/2","v":0},0]
[null,"Match Surplus/(Deficiency)",null,null,null,null,null,{"$f":"H44-H45","v":0},0]
[]
[null,"FLOW OF FUNDS"]
[null,null,null,null,null,"Enter Amount when Funds will be Disbursed"]
[null,"Name of Source",null,null,"Amount","Closing","During Construction","End of Construction","Stabilization","Post Stabilization","From\nCash Flow","Comment"]
[null,"INTERIM SOURCES"]
[null,{"$f":"IF(ISBLANK(B6), \"\", B6)","v":""},null,null,{"$f":"G6","v":0}]
[null,{"$f":"IF(ISBLANK(B7), \"\", B7)","v":""},null,null,{"$f":"G7","v":0}]
[null,"",null,null,{"$f":"G8","v":0}]
[null,"",null,null,{"$f":"G9","v":0}]
[null,"",null,null,{"$f":"G10","v":0}]
[null,"PERMANENT SOURCES",null,null,"Amount","Closing","During Construction","End of Construction","Stabilization","Post Stabilization","From\nCash Flow","Comment"]
[null,{"$f":"Source_First_Mortgage","v":"First Mortgage"},null,null,{"$f":"Source_First_Mortgage_Amount","v":0}]
[null,{"$f":"Source_TIF_Mortgage","v":"TIF Mortgage (if separate from 1st)"},null,null,{"$f":"Source_TIF_Mortgage_Amount","v":0}]
[null,{"$f":"Source_Developer_Cash_Equity","v":"Developer Cash Equity"},null,null,{"$f":"Source_Developer_Cash_Equity_Amount","v":0}]
[null,{"$f":"Source_Sales_Tax_Rebate","v":"Sales Tax Rebate"},null,null,{"$f":"Source_Sales_Tax_Rebate_Amount","v":0}]
[null,{"$f":"Source_Energy_Rebates","v":"Energy Rebates"},null,null,{"$f":"Source_Energy_Rebates_Amount","v":0}]
[null,{"$f":"Source_Workforce_Housing_Program","v":"Workforce Housing Program "},null,null,{"$f":"Sources_WorkforceHousingRequestedAmount","v":0}]
[null,{"$f":"IF(ISBLANK(Source_Other1),\"\",Source_Other1)","v":""},null,null,{"$f":"Source_Other1_Amount","v":0}]
[null,{"$f":"IF(ISBLANK(Source_Other2),\"\",Source_Other2)","v":""},null,null,{"$f":"Source_Other2_Amount","v":0}]
[null,{"$f":"IF(ISBLANK(Source_Other3),\"\",Source_Other3)","v":""},null,null,{"$f":"Source_Other3_Amount","v":0}]
[null,{"$f":"IF(ISBLANK(Source_Other4),\"\",Source_Other4)","v":""},null,null,{"$f":"Source_Other4_Amount","v":0}]
[null,{"$f":"IF(ISBLANK(Source_Other5),\"\",Source_Other5)","v":""},null,null,{"$f":"Source_Other5_Amount","v":0}]
[null,{"$f":"IF(ISBLANK(Source_Other6),\"\",Source_Other6)","v":""},null,null,{"$f":"Source_Other6_Amount","v":0}]
[null,{"$f":"IF(ISBLANK(Source_Other7),\"\",Source_Other7)","v":""},null,null,{"$f":"Source_Other7_Amount","v":0}]
[null,{"$f":"IF(ISBLANK(Source_Other8),\"\",Source_Other8)","v":""},null,null,{"$f":"Source_Other8_Amount","v":0}]
[null,{"$f":"IF(ISBLANK(Source_Other9),\"\",Source_Other9)","v":""},null,null,{"$f":"Source_Other9_Amount","v":0}]
[null,{"$f":"IF(ISBLANK(Source_Other10),\"\",Source_Other10)","v":""},null,null,{"$f":"Source_Other10_Amount","v":0}]
[null,"Total Construction Sources",null,null,{"$f":"SUM(E52:E56)","v":0},0,0,0,0,0,0]
[null,"Total Perm Sources",null,null,{"$f":"SUM(E58:E73)","v":0},{"$f":"SUM(F58:F73)","v":0},0,0,0,0,0]
[null,"Total All Sources",null,null,{"$f":"E74+E75","v":0},{"$f":"F74+F75","v":0},0,0,0,0,0]
[]
[null,"Uses",null,null,"Amount","Closing","During Construction","End of Construction","Stabilization","Post Stabilization","From\nCash Flow","Comment"]
[null,"Acquisition",null,null,{"$f":"'Development Costs'!H15","v":0}]
[null,"New Construction",null,null,{"$f":"'Development Costs'!H25","v":0}]
[null,"Rehab",null,null,{"$f":"'Development Costs'!H34","v":0}]
[null,"Contractor Fees",null,null,{"$f":"'Development Costs'!H36+'Development Costs'!H37+'Development Costs'!H38","v":0}]
[null,"Contingency",null,null,{"$f":"'Development Costs'!H40","v":0}]
[null,"Environmental Abatement",null,null,{"$f":"'Development Costs'!H48","v":0}]
[null,"Professional Fees",null,null,{"$f":"'Development Costs'!H74","v":0}]
[null,"Developer Fee",null,null,{"$f":"'Development Costs'!H81","v":0}]
[null,"Financing Fees",null,null,{"$f":"'Development Costs'!H107","v":0}]
[null,"Reserves",null,null,{"$f":"'Development Costs'!H115","v":0}]
[null,"Total Uses",null,null,{"$f":"SUM(E79:E88)","v":0},0,0,0,0,0,0]
[null,"Surplus/(Shortfall) of Funds",null,null,{"$f":"E75-ROUND(E89,)","v":0},{"$f":"F76-ROUND(F89,)","v":0},0,0,0,0,0]

{"sheet":"Cash Flow","index":7,"n_rows":67,"n_cols":40,"rows_kept":67,"cut":false,"hidden":false,"merged":[[65,1,65,6],[54,1,54,4],[55,1,55,4],[58,1,58,4],[61,1,61,4],[59,1,59,5],[62,1,62,4],[4,25,4,39],[39,1,39,5],[5,1,5,5],[19,2,19,4],[20,2,20,4],[23,1,23,5],[36,1,36,4],[38,1,38,5],[4,10,4,24],[12,2,12,4],[13,2,13,4],[14,2,14,4],[0,1,1,24],[3,9,3,10],[40,1,40,5],[53,1,53,4],[46,1,46,5],[49,1,49,4],[50,1,50,4],[52,1,52,4],[41,1,41,5],[42,1,42,5],[43,1,43,5],[44,1,44,5],[45,1,45,5],[47,2,47,5],[48,2,48,5]]}
[null,"CASH FLOW"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year"]
[null,null,null,null,null,null,"Inflator","Actuals Two Years Ago","Actuals One Year Ago","Actuals Current Year",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"INCOME"]
[null,"Rental Income",null,null,null,null,0.02,null,null,null,{"$f":"'Operating Budget'!J6","v":0},{"$f":"K8*(1+$G8)","v":0},{"$f":"L8*(1+$G8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y8*(1+$G8)","v":0},{"$f":"Z8*(1+$G8)","v":0},{"$f":"AA8*(1+$G8)","v":0},{"$f":"AB8*(1+$G8)","v":0},{"$f":"AC8*(1+$G8)","v":0},{"$f":"AD8*(1+$G8)","v":0},{"$f":"AE8*(1+$G8)","v":0},{"$f":"AF8*(1+$G8)","v":0},{"$f":"AG8*(1+$G8)","v":0},{"$f":"AH8*(1+$G8)","v":0},{"$f":"AI8*(1+$G8)","v":0},{"$f":"AJ8*(1+$G8)","v":0},{"$f":"AK8*(1+$G8)","v":0},{"$f":"AL8*(1+$G8)","v":0},{"$f":"AM8*(1+$G8)","v":0}]
[null,"Parking Income",null,null,null,null,0.02,null,null,null,{"$f":"'Operating Budget'!J8+'Operating Budget'!J9","v":0},{"$f":"K9*(1+$G9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Commercial Income",null,null,null,null,0.02,null,null,null,{"$f":"'Operating Budget'!J10","v":0},{"$f":"K10*(1+$G10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gross Potential Rent",null,null,null,null,null,{"$f":"SUM(H8:H10)","v":0},{"$f":"SUM(I8:I10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Z8:Z10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Other Income from Operations",null,null,null,null,0.02,null,null,null,{"$f":"'Operating Budget'!J19","v":0},{"$f":"K12*(1+$G12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y12*(1+$G12)","v":0},{"$f":"Z12*(1+$G12)","v":0},{"$f":"AA12*(1+$G12)","v":0},{"$f":"AB12*(1+$G12)","v":0},{"$f":"AC12*(1+$G12)","v":0},{"$f":"AD12*(1+$G12)","v":0},{"$f":"AE12*(1+$G12)","v":0},{"$f":"AF12*(1+$G12)","v":0},{"$f":"AG12*(1+$G12)","v":0},{"$f":"AH12*(1+$G12)","v":0},{"$f":"AI12*(1+$G12)","v":0},{"$f":"AJ12*(1+$G12)","v":0},{"$f":"AK12*(1+$G12)","v":0},{"$f":"AL12*(1+$G12)","v":0},{"$f":"AM12*(1+$G12)","v":0}]
[null,"  Other "]
[null,"  Other"]
[null,"  Other"]
[null,"Total Other Income",null,null,null,null,null,{"$f":"SUM(H12:H15)","v":0},0,0,{"$f":"SUM(K12:K15)","v":0},{"$f":"SUM(L12:L15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Z12:Z15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Rental Vacancy",null,null,{"$f":"OpBudget_RentalLoss_RentalHousingVacancyRate","v":0},null,null,null,null,null,{"$f":"(K8+K16)*$E17","v":0},{"$f":"(L8+L16)*$E17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(Y8+Y16)*$E17","v":0},{"$f":"(Z11+Z16)*$E17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(AN11+AN16)*$E17","v":0}]
[null,"Parking Vacancy",null,null,{"$f":"'Operating Budget'!H22","v":0},null,null,null,null,null,{"$f":"K9*$E18","v":0},{"$f":"L9*$E18","v":0},0,0,0,0,0,{"$f":"R9*$E18","v":0},0,0,0,0,0,0,0,{"$f":"Z9*$E18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Commercial Vacancy",null,null,{"$f":"'Operating Budget'!H23","v":0},null,null,null,null,null,{"$f":"K10*$E19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z10*$E19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Other",{"$f":"'Operating Budget'!D24","v":0},null,null,null,null,null,null,null,{"$f":"'Operating Budget'!J24","v":0},{"$f":"K20*(1+$G20)","v":0},{"$f":"L20*(1+$G20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y20*(1+$G20)","v":0},{"$f":"Z20*(1+$G20)","v":0},{"$f":"AA20*(1+$G20)","v":0},{"$f":"AB20*(1+$G20)","v":0},{"$f":"AC20*(1+$G20)","v":0},{"$f":"AD20*(1+$G20)","v":0},{"$f":"AE20*(1+$G20)","v":0},{"$f":"AF20*(1+$G20)","v":0},{"$f":"AG20*(1+$G20)","v":0},{"$f":"AH20*(1+$G20)","v":0},{"$f":"AI20*(1+$G20)","v":0},{"$f":"AJ20*(1+$G20)","v":0},{"$f":"AK20*(1+$G20)","v":0},{"$f":"AL20*(1+$G20)","v":0},{"$f":"AM20*(1+$G20)","v":0}]
[null,"Other",{"$f":"'Operating Budget'!D25","v":0},null,null,null,null,null,null,null,{"$f":"'Operating Budget'!J25","v":0},{"$f":"K21*(1+$G21)","v":0},{"$f":"L21*(1+$G21)","v":0},{"$f":"M21*(1+$G21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Rental Loss",null,null,null,null,null,{"$f":"SUM(H17:H21)","v":0},0,0,{"$f":"SUM(K17:K21)","v":0},{"$f":"SUM(L17:L21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Z17:Z21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Net Rental Income",null,null,null,null,null,0,0,0,{"$f":"K11+K16-K22","v":0},{"$f":"L11+L16-L22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EXPENSES"]
[null,"Property Management Fee",null,null,{"$f":"IF('Operating Budget'!G34>0,'Operating Budget'!G34,'Operating Budget'!G35)","v":0},null,0.02,null,null,null,{"$f":"'Operating Budget'!J33","v":0},{"$f":"K25*(1+$G25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y25*(1+$G25)","v":0},{"$f":"Z25*(1+$G25)","v":0},{"$f":"AA25*(1+$G25)","v":0},{"$f":"AB25*(1+$G25)","v":0},{"$f":"AC25*(1+$G25)","v":0},{"$f":"AD25*(1+$G25)","v":0},{"$f":"AE25*(1+$G25)","v":0},{"$f":"AF25*(1+$G25)","v":0},{"$f":"AG25*(1+$G25)","v":0},{"$f":"AH25*(1+$G25)","v":0},{"$f":"AI25*(1+$G25)","v":0},{"$f":"AJ25*(1+$G25)","v":0},{"$f":"AK25*(1+$G25)","v":0},{"$f":"AL25*(1+$G25)","v":0},{"$f":"AM25*(1+$G25)","v":0}]
[null,"Administrative Expenses",null,null,null,null,0.03,null,null,null,{"$f":"'Operating Budget'!J41-'Cash Flow'!K25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Maintenance Expenses",null,null,null,null,0.03,null,null,null,{"$f":"'Operating Budget'!J55","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Utilities",null,null,null,null,0.03,null,null,null,{"$f":"'Operating Budget'!J60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Unique Operating Expenses",null,null,null,null,0.03,null,null,null,{"$f":"'Operating Budget'!J62","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Insurance",null,null,null,null,0.03,null,null,null,{"$f":"'Operating Budget'!J64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Real Estate Taxes",null,null,null,null,0.03,null,null,null,{"$f":"'Operating Budget'!J68","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Reserves",null,null,null,null,0.03,null,null,null,{"$f":"'Operating Budget'!J69+'Operating Budget'!J70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Effective Gross Expense",null,null,null,null,null,{"$f":"SUM(H25:H32)","v":0},0,0,{"$f":"SUM(K25:K32)","v":0},{"$f":"SUM(L25:L32)","v":0},{"$f":"SUM(M25:M32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Z25:Z32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Net Operating Income",null,null,null,null,null,{"$f":"H23-H33","v":0},{"$f":"I23-I33","v":0},{"$f":"J23-J33","v":0},{"$f":"K23-K33","v":0},{"$f":"L23-L33","v":0},{"$f":"M23-M33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z23-Z33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Temporary Income - TIF",null,null,null,null,null,null,null,null,{"$f":"'Operating Budget'!J78","v":0},{"$f":"K35","v":0},{"$f":"L35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y35","v":0},{"$f":"Z35","v":0},{"$f":"AA35","v":0},{"$f":"AB35","v":0},{"$f":"AC35","v":0},{"$f":"AD35","v":0},{"$f":"AE35","v":0},{"$f":"AF35","v":0},{"$f":"AG35","v":0},{"$f":"AH35","v":0},{"$f":"AI35","v":0},{"$f":"AJ35","v":0},{"$f":"AK35","v":0},{"$f":"AL35","v":0},{"$f":"AM35","v":0}]
[null,"Temporary Income",null,null,null,null,null,null,null,null,{"$f":"'Operating Budget'!J79","v":0},{"$f":"K36","v":0},{"$f":"L36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Income for Debt Service",null,null,null,null,null,{"$f":"H34+H35+H36","v":0},{"$f":"I34+I35+I36","v":0},{"$f":"J34+J35+J36","v":0},{"$f":"K34+K35+K36","v":0},{"$f":"L34+L35+L36","v":0},{"$f":"M34+M35+M36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z34+Z35+Z36","v":0},{"$f":"AA34+AA35+AA36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEBT SERVICE"]
[null,"NOI Supported Mortgage",null,null,null,null,null,null,null,null,{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!K$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!L$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!M$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!N$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!O$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!P$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!Q$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!R$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!S$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!T$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!U$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!V$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!W$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!X$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!Y$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!Z$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AA$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AB$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AC$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AD$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AE$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AF$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AG$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AH$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AI$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AJ$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AK$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AL$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AM$6,'Amortization Schedule'!$D$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$25>'Cash Flow'!AN$6,'Amortization Schedule'!$D$7*12,0)","v":0}]
[null,"TIF Supported Mortgage",null,null,null,null,null,null,null,null,{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!K$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!L$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!M$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!N$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!O$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!P$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!Q$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!R$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!S$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!T$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!U$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!V$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!W$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!X$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!Y$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!Z$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AA$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AB$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AC$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AD$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AE$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AF$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AG$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AH$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AI$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AJ$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AK$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AL$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AM$6,'Amortization Schedule'!$M$7*12,0)","v":0},{"$f":"IF('Mortgage Calculation'!$K$38>='Cash Flow'!AN$6,'Amortization Schedule'!$M$7*12,0)","v":0}]
[null,"MIP",null,null,null,null,null,null,null,null,{"$f":"'Amortization Schedule'!S10","v":0},{"$f":"'Amortization Schedule'!S22","v":0},{"$f":"'Amortization Schedule'!S34","v":0},{"$f":"'Amortization Schedule'!S46","v":0},{"$f":"'Amortization Schedule'!S58","v":0},{"$f":"'Amortization Schedule'!S70","v":0},{"$f":"'Amortization Schedule'!S82","v":0},{"$f":"'Amortization Schedule'!S94","v":0},{"$f":"'Amortization Schedule'!S106","v":0},{"$f":"'Amortization Schedule'!S118","v":0},{"$f":"'Amortization Schedule'!S130","v":0},{"$f":"'Amortization Schedule'!S142","v":0},{"$f":"'Amortization Schedule'!S154","v":0},{"$f":"'Amortization Schedule'!S166","v":0},{"$f":"'Amortization Schedule'!S178","v":0},{"$f":"'Amortization Schedule'!S190","v":0},{"$f":"'Amortization Schedule'!S202","v":0},{"$f":"'Amortization Schedule'!S214","v":0},{"$f":"'Amortization Schedule'!S226","v":0},{"$f":"'Amortization Schedule'!S238","v":0},{"$f":"'Amortization Schedule'!S250","v":0},{"$f":"'Amortization Schedule'!S262","v":0},{"$f":"'Amortization Schedule'!S274","v":0},{"$f":"'Amortization Schedule'!S286","v":0},{"$f":"'Amortization Schedule'!S298","v":0},{"$f":"'Amortization Schedule'!S310","v":0},{"$f":"'Amortization Schedule'!S322","v":0},{"$f":"'Amortization Schedule'!S334","v":0},{"$f":"'Amortization Schedule'!S346","v":0},{"$f":"'Amortization Schedule'!S358","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Other"]
[null,"Other"]
[null,"Total Debt Service",null,null,null,null,null,{"$f":"SUM(H39:H49)","v":0},{"$f":"SUM(I39:I49)","v":0},0,{"$f":"SUM(K39:K49)","v":0},{"$f":"SUM(L39:L49)","v":0},{"$f":"SUM(M39:M49)","v":0},{"$f":"SUM(N39:N49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service Coverage",null,null,null,null,null,{"$f":"IFERROR(H37/H50,0)","v":0},{"$f":"IFERROR(I37/I50,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z37/Z50","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"CASH FLOW"]
[null,"Net Cash Flow",null,null,null,null,null,null,null,null,{"$f":"K37-K50","v":0},{"$f":"L37-L50","v":0},{"$f":"M37-M50","v":0},{"$f":"N37-N50","v":0},{"$f":"O37-O50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt Service Reserve",null,null,null,null,null,null,null,null,{"$f":"IF(K53<0,-K53,0)","v":0},{"$f":"IF(L53<0,-L53,0)","v":0},0,{"$f":"IF(N53<0,-N53,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Adjusted Cash Flow",null,null,null,null,null,null,null,null,{"$f":"K53+K54","v":0},{"$f":"L53+L54","v":0},{"$f":"M53+M54","v":0},{"$f":"N53+N54","v":0},{"$f":"O53+O54","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Adjusted Debt Service Coverage",null,null,null,null,null,null,null,null,{"$f":"IFERROR((K37+K54)/K50,0)","v":0},{"$f":"IFERROR((L37+L54)/L50,0)","v":0},{"$f":"IFERROR((M37+M54)/M50,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(Z37+Z54)/Z50","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"NET CASH FLOW AVAILABLE FOR DISTRIBUTION",null,null,null,null,null,null,null,null,{"$f":"K55","v":0},{"$f":"L55","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z55-#REF!","v":{"$error":"#REF!"}},{"$f":"AA55-#REF!","v":{"$error":"#REF!"}},{"$f":"AB55-#REF!","v":{"$error":"#REF!"}},{"$f":"AC55-#REF!","v":{"$error":"#REF!"}},{"$f":"AD55-#REF!","v":{"$error":"#REF!"}},{"$f":"AE55-#REF!","v":{"$error":"#REF!"}},{"$f":"AF55-#REF!","v":{"$error":"#REF!"}},{"$f":"AG55-#REF!","v":{"$error":"#REF!"}},{"$f":"AH55-#REF!","v":{"$error":"#REF!"}},{"$f":"AI55-#REF!","v":{"$error":"#REF!"}},{"$f":"AJ55-#REF!","v":{"$error":"#REF!"}},{"$f":"AK55-#REF!","v":{"$error":"#REF!"}},{"$f":"AL55-#REF!","v":{"$error":"#REF!"}},{"$f":"AM55-#REF!","v":{"$error":"#REF!"}},{"$f":"AN55-#REF!","v":{"$error":"#REF!"}}]
[null,"RETURNS ANALYSIS"]
[null,"Net Cash to Developer",null,null,null,null,null,0,0,0,{"$f":"K57","v":0},{"$f":"L57","v":0},{"$f":"M57","v":0},{"$f":"N57","v":0},{"$f":"O57","v":0},0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Net Cash to Developer (w/o assistance)",null,null,null,null,null,null,null,null,{"$f":"K34-K50","v":0},{"$f":"L34-L50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z34-Z50-#REF!","v":{"$error":"#REF!"}},{"$f":"AA34-AA50-#REF!","v":{"$error":"#REF!"}},{"$f":"AB34-AB50-#REF!","v":{"$error":"#REF!"}},{"$f":"AC34-AC50-#REF!","v":{"$error":"#REF!"}},{"$f":"AD34-AD50-#REF!","v":{"$error":"#REF!"}},{"$f":"AE34-AE50-#REF!","v":{"$error":"#REF!"}},{"$f":"AF34-AF50-#REF!","v":{"$error":"#REF!"}},{"$f":"AG34-AG50-#REF!","v":{"$error":"#REF!"}},{"$f":"AH34-AH50-#REF!","v":{"$error":"#REF!"}},{"$f":"AI34-AI50-#REF!","v":{"$error":"#REF!"}},{"$f":"AJ34-AJ50-#REF!","v":{"$error":"#REF!"}},{"$f":"AK34-AK50-#REF!","v":{"$error":"#REF!"}},{"$f":"AL34-AL50-#REF!","v":{"$error":"#REF!"}},{"$f":"AM34-AM50-#REF!","v":{"$error":"#REF!"}},{"$f":"AN34-AN50-#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Cash on Cash Annual Return",null,null,null,null,{"$f":"Sources!G17","v":0},0,0,0,{"$f":"IFERROR(K59/$G$62,0)","v":0},{"$f":"IFERROR(L59/$G$62,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z59/714388","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AN56<0,-AN56,0)","v":{"$error":"#DIV/0!"}}]
[null,"Cash on Cash Average Annual Return ",null,null,null,null,"Developer Cash Equity",null,null,null,{"$f":"IF(G62>0,IFERROR(K59/G62,0),0)","v":0},{"$f":"IF($G$62>0,IFERROR(AVERAGE(K59:L59)/$G$62,0),0)","v":0},{"$f":"IF($G$62>0,IFERROR(AVERAGE(L59:M59)/$G$62,0),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cash on Cost First Stabilized Year",null,null,null,null,null,null,null,null,{"$f":"IFERROR(K37/DevCosts_TDC,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DevCosts_TDC>0,Y37/DevCosts_TDC,\"\")","v":""}]
[null,"Cash on Cash Annual Return (w/o TIF assistance)",null,null,null,null,null,0,0,0,{"$f":"IFERROR(K60/$G$62,0)","v":0},{"$f":"IFERROR(L60/$G$62,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Z58<0,-Z58,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cash on Cash Average Annual Return (w/o TIF assistance)",null,null,null,null,null,null,null,null,{"$f":"IFERROR(K60/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:L60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:M60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:N60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:O60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:P60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:Q60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:R60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:S60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:T60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:U60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:V60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:W60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:X60)/G62,0)","v":0},{"$f":"IFERROR(AVERAGE(K60:Y60)/G62,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"*First year stabalized cash on cost return of 6.25% or less."]

{"sheet":"Amortization Schedule","index":8,"n_rows":489,"n_cols":19,"rows_kept":489,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,9,1,11],[2,0,2,2],[2,9,2,11],[3,0,3,2],[3,9,3,11],[4,0,4,2],[4,9,4,11],[5,0,5,2],[5,9,5,11],[6,0,6,2],[6,9,6,11]]}
["AMORTIZATION SCHEDULE - NOI SUPPORTED DEBT",null,null,null,null,null,null,null,null,"AMORTIZATION SCHEDULE - TIF SUPPORTED DEBT"]
["Loan amount",null,null,{"$f":"IF('Mortgage Calculation'!K32>0,'Mortgage Calculation'!K32,'Mortgage Calculation'!K31)","v":0},null,null,null,null,null,"Loan amount",null,null,{"$f":"IF('Mortgage Calculation'!K44>0,'Mortgage Calculation'!K44,'Mortgage Calculation'!K43)","v":0}]
["Annual Interest Rate",null,null,{"$f":"'Mortgage Calculation'!K27","v":0},null,null,null,null,null,"Annual Interest Rate",null,null,{"$f":"'Mortgage Calculation'!K39","v":0}]
["MIP Rate",null,null,{"$f":"'Mortgage Calculation'!K28","v":0},null,null,null,null,null,"MIP Rate",null,null,{"$f":"'Mortgage Calculation'!K40","v":0}]
["Amortization",null,null,{"$f":"'Mortgage Calculation'!K26","v":0},null,null,null,null,null,"Amortization",null,null,{"$f":"'Mortgage Calculation'!K38","v":0}]
["Payments per Year",null,null,12,null,null,null,null,null,"Payments per Year",null,null,12]
["Monthly Payment",null,null,{"$f":"IF(D2>0,PMT(D3/D6,D5*D6,-D2,),)","v":0},null,null,null,null,null,"Monthly Payment",null,null,{"$f":"IF(M2>0,PMT(M3/M6,M5*M6,-M2,),)","v":0}]
[]
["Year","Payment #","Beginning Balance","Interest","Principal","Ending Balance","Average Ending Balance","MIP",null,"Year","Payment #","Beginning Balance","Interest","Principal","Ending Balance","Average Ending Balance","MIP",null,"Total MIP"]
[1,1,{"$f":"D2","v":0},{"$f":"C10*$D$3/12","v":0},{"$f":"IF(ROUND(C10,2)>0,$D$7-D10,0)","v":0},{"$f":"C10-E10","v":0},{"$f":"AVERAGE(F10:F21)","v":0},{"$f":"G10*$D$4","v":0},null,1,1,{"$f":"M2","v":0},{"$f":"L10*$M$3/12","v":0},{"$f":"IF(ROUND(L10,2)>0,$M$7-M10,0)","v":0},{"$f":"L10-N10","v":0},{"$f":"AVERAGE(O10:O21)","v":0},{"$f":"P10*$M$4","v":0},null,{"$f":"H10+Q10","v":0}]
[null,2,{"$f":"F10","v":0},{"$f":"C11*$D$3/12","v":0},{"$f":"IF(ROUND(C11,2)>0,$D$7-D11,0)","v":0},{"$f":"C11-E11","v":0},null,null,null,null,2,{"$f":"O10","v":0},{"$f":"L11*$M$3/12","v":0},{"$f":"IF(ROUND(L11,2)>0,$M$7-M11,0)","v":0},{"$f":"L11-N11","v":0}]
[null,3,{"$f":"F11","v":0},{"$f":"C12*$D$3/12","v":0},0,{"$f":"C12-E12","v":0},null,null,null,null,3,{"$f":"O11","v":0},0,0,{"$f":"L12-N12","v":0}]
[null,4,0,0,0,0,null,null,null,null,4,0,0,0,0]
[null,5,0,0,0,0,null,null,null,null,5,0,0,0,0]
[null,6,0,0,0,0,null,null,null,null,6,0,0,0,0]
[null,7,0,0,0,0,null,null,null,null,7,0,0,0,0]
[null,8,0,0,0,0,null,null,null,null,8,0,0,0,0]
[null,9,0,0,0,0,null,null,null,null,9,0,0,0,0]
[null,10,0,0,0,0,null,null,null,null,10,0,0,0,0]
[null,11,0,0,0,0,null,null,null,null,11,0,0,0,0]
[null,12,0,0,0,0,null,null,null,null,12,0,0,0,0]
[2,13,0,0,0,0,{"$f":"AVERAGE(F22:F33)","v":0},{"$f":"G22*$D$4","v":0},null,2,13,0,0,0,0,{"$f":"AVERAGE(O22:O33)","v":0},{"$f":"P22*$M$4","v":0},null,{"$f":"H22+Q22","v":0}]
[null,14,0,0,0,0,null,null,null,null,14,0,0,0,0]
[null,15,0,0,0,0,null,null,null,null,15,0,0,0,0]
[null,16,0,0,0,0,null,null,null,null,16,0,0,0,0]
[null,17,0,0,0,0,null,null,null,null,17,0,0,0,0]
[null,18,0,0,0,0,null,null,null,null,18,0,0,0,0]
[null,19,0,0,0,0,null,null,null,null,19,0,0,0,0]
[null,20,0,0,0,0,null,null,null,null,20,0,0,0,0]
[null,21,0,0,0,0,null,null,null,null,21,0,0,0,0]
[null,22,0,0,0,0,null,null,null,null,22,0,0,0,0]
[null,23,0,0,0,0,null,null,null,null,23,0,0,0,0]
[null,24,0,0,0,0,null,null,null,null,24,0,0,0,0]
[3,25,0,0,0,0,{"$f":"AVERAGE(F34:F45)","v":0},{"$f":"G34*$D$4","v":0},null,3,25,0,0,0,0,{"$f":"AVERAGE(O34:O45)","v":0},{"$f":"P34*$M$4","v":0},null,{"$f":"H34+Q34","v":0}]
[null,26,0,0,0,0,null,null,null,null,26,0,0,0,0]
[null,27,0,0,0,0,null,null,null,null,27,0,0,0,0]
[null,28,0,0,0,0,null,null,null,null,28,0,0,0,0]
[null,29,0,0,0,0,null,null,null,null,29,0,0,0,0]
[null,30,0,0,0,0,null,null,null,null,30,0,0,0,0]
[null,31,0,0,0,0,null,null,null,null,31,0,0,0,0]
[null,32,0,0,0,0,null,null,null,null,32,0,0,0,0]
[null,33,0,0,0,0,null,null,null,null,33,0,0,0,0]
[null,34,0,0,0,0,null,null,null,null,34,0,0,0,0]
[null,35,0,0,0,0,null,null,null,null,35,0,0,0,0]
[null,36,0,0,0,0,null,null,null,null,36,0,0,0,0]
[4,37,0,0,0,0,{"$f":"AVERAGE(F46:F57)","v":0},{"$f":"G46*$D$4","v":0},null,4,37,0,0,0,0,{"$f":"AVERAGE(O46:O57)","v":0},{"$f":"P46*$M$4","v":0},null,{"$f":"H46+Q46","v":0}]
[null,38,0,0,0,0,null,null,null,null,38,0,0,0,0]
[null,39,0,0,0,0,null,null,null,null,39,0,0,0,0]
[null,40,0,0,0,0,null,null,null,null,40,0,0,0,0]
[null,41,0,0,0,0,null,null,null,null,41,0,0,0,0]
[null,42,0,0,0,0,null,null,null,null,42,0,0,0,0]
[null,43,0,0,0,0,null,null,null,null,43,0,0,0,0]
[null,44,0,0,0,0,null,null,null,null,44,0,0,0,0]
[null,45,0,0,0,0,null,null,null,null,45,0,0,0,0]
[null,46,0,0,0,0,null,null,null,null,46,0,0,0,0]
[null,47,0,0,0,0,null,null,null,null,47,0,0,0,0]
[null,48,0,0,0,0,null,null,null,null,48,0,0,0,0]
[5,49,0,0,0,0,{"$f":"AVERAGE(F58:F69)","v":0},{"$f":"G58*$D$4","v":0},null,5,49,0,0,0,0,{"$f":"AVERAGE(O58:O69)","v":0},{"$f":"P58*$M$4","v":0},null,{"$f":"H58+Q58","v":0}]
[null,50,0,0,0,0,null,null,null,null,50,0,0,0,0]
[null,51,0,0,0,0,null,null,null,null,51,0,0,0,0]
[null,52,0,0,0,0,null,null,null,null,52,0,0,0,0]
[null,53,0,0,0,0,null,null,null,null,53,0,0,0,0]
[null,54,0,0,0,0,null,null,null,null,54,0,0,0,0]
[null,55,0,0,0,0,null,null,null,null,55,0,0,0,0]
[null,56,0,0,0,0,null,null,null,null,56,0,0,0,0]
[null,57,0,0,0,0,null,null,null,null,57,0,0,0,0]
[null,58,0,0,0,0,null,null,null,null,58,0,0,0,0]
[null,59,0,0,0,0,null,null,null,null,59,0,0,0,0]
[null,60,0,0,0,0,null,null,null,null,60,0,0,0,0]
[6,61,0,0,0,0,{"$f":"AVERAGE(F70:F81)","v":0},{"$f":"G70*$D$4","v":0},null,6,61,0,0,0,0,{"$f":"AVERAGE(O70:O81)","v":0},{"$f":"P70*$M$4","v":0},null,{"$f":"H70+Q70","v":0}]
[null,62,0,0,0,0,null,null,null,null,62,0,0,0,0]
[null,63,0,0,0,0,null,null,null,null,63,0,0,0,0]
[null,64,0,0,0,0,null,null,null,null,64,0,0,0,0]
[null,65,0,0,0,0,null,null,null,null,65,0,0,0,0]
[null,66,0,0,{"$f":"IF(ROUND(C75,2)>0,$D$7-D75,0)","v":0},0,null,null,null,null,66,0,{"$f":"L75*$M$3/12","v":0},{"$f":"IF(ROUND(L75,2)>0,$M$7-M75,0)","v":0},0]
[null,67,{"$f":"F75","v":0},{"$f":"C76*$D$3/12","v":0},0,{"$f":"C76-E76","v":0},null,null,null,null,67,{"$f":"O75","v":0},0,0,{"$f":"L76-N76","v":0}]
[null,68,0,0,0,0,null,null,null,null,68,0,0,0,0]
[null,69,0,0,0,0,null,null,null,null,69,0,0,0,0]
[null,70,0,0,0,0,null,null,null,null,70,0,0,0,0]
[null,71,0,0,0,0,null,null,null,null,71,0,0,0,0]
[null,72,0,0,0,0,null,null,null,null,72,0,0,0,0]
[7,73,0,0,0,0,{"$f":"AVERAGE(F82:F93)","v":0},{"$f":"G82*$D$4","v":0},null,7,73,0,0,0,0,{"$f":"AVERAGE(O82:O93)","v":0},{"$f":"P82*$M$4","v":0},null,{"$f":"H82+Q82","v":0}]
[null,74,0,0,0,0,null,null,null,null,74,0,0,0,0]
[null,75,0,0,0,0,null,null,null,null,75,0,0,0,0]
[null,76,0,0,0,0,null,null,null,null,76,0,0,0,0]
[null,77,0,0,0,0,null,null,null,null,77,0,0,0,0]
[null,78,0,0,0,0,null,null,null,null,78,0,0,0,0]
[null,79,0,0,0,0,null,null,null,null,79,0,0,0,0]
[null,80,0,0,0,0,null,null,null,null,80,0,0,0,0]
[null,81,0,0,0,0,null,null,null,null,81,0,0,0,0]
[null,82,0,0,0,0,null,null,null,null,82,0,0,0,0]
[null,83,0,0,0,0,null,null,null,null,83,0,0,0,0]
[null,84,0,0,0,0,null,null,null,null,84,0,0,0,0]
[8,85,0,0,0,0,{"$f":"AVERAGE(F94:F105)","v":0},{"$f":"G94*$D$4","v":0},null,8,85,0,0,0,0,{"$f":"AVERAGE(O94:O105)","v":0},{"$f":"P94*$M$4","v":0},null,{"$f":"H94+Q94","v":0}]
[null,86,0,0,0,0,null,null,null,null,86,0,0,0,0]
[null,87,0,0,0,0,null,null,null,null,87,0,0,0,0]
[null,88,0,0,0,0,null,null,null,null,88,0,0,0,0]
[null,89,0,0,0,0,null,null,null,null,89,0,0,0,0]
[null,90,0,0,0,0,null,null,null,null,90,0,0,0,0]
[null,91,0,0,0,0,null,null,null,null,91,0,0,0,0]
[null,92,0,0,0,0,null,null,null,null,92,0,0,0,0]
[null,93,0,0,0,0,null,null,null,null,93,0,0,0,0]
[null,94,0,0,0,0,null,null,null,null,94,0,0,0,0]
[null,95,0,0,0,0,null,null,null,null,95,0,0,0,0]
[null,96,0,0,0,0,null,null,null,null,96,0,0,0,0]
[9,97,0,0,0,0,{"$f":"AVERAGE(F106:F117)","v":0},{"$f":"G106*$D$4","v":0},null,9,97,0,0,0,0,{"$f":"AVERAGE(O106:O117)","v":0},{"$f":"P106*$M$4","v":0},null,{"$f":"H106+Q106","v":0}]
[null,98,0,0,0,0,null,null,null,null,98,0,0,0,0]
[null,99,0,0,0,0,null,null,null,null,99,0,0,0,0]
[null,100,0,0,0,0,null,null,null,null,100,0,0,0,0]
[null,101,0,0,0,0,null,null,null,null,101,0,0,0,0]
[null,102,0,0,0,0,null,null,null,null,102,0,0,0,0]
[null,103,0,0,0,0,null,null,null,null,103,0,0,0,0]
[null,104,0,0,0,0,null,null,null,null,104,0,0,0,0]
[null,105,0,0,0,0,null,null,null,null,105,0,0,0,0]
[null,106,0,0,0,0,null,null,null,null,106,0,0,0,0]
[null,107,0,0,0,0,null,null,null,null,107,0,0,0,0]
[null,108,0,0,0,0,null,null,null,null,108,0,0,0,0]
[10,109,0,0,0,0,{"$f":"AVERAGE(F118:F129)","v":0},{"$f":"G118*$D$4","v":0},null,10,109,0,0,0,0,{"$f":"AVERAGE(O118:O129)","v":0},{"$f":"P118*$M$4","v":0},null,{"$f":"H118+Q118","v":0}]
[null,110,0,0,0,0,null,null,null,null,110,0,0,0,0]
[null,111,0,0,0,0,null,null,null,null,111,0,0,0,0]
[null,112,0,0,0,0,null,null,null,null,112,0,0,0,0]
[null,113,0,0,0,0,null,null,null,null,113,0,0,0,0]
[null,114,0,0,0,0,null,null,null,null,114,0,0,0,0]
[null,115,0,0,0,0,null,null,null,null,115,0,0,0,0]
[null,116,0,0,0,0,null,null,null,null,116,0,0,0,0]
[null,117,0,0,0,0,null,null,null,null,117,0,0,0,0]
[null,118,0,0,0,0,null,null,null,null,118,0,0,0,0]
[null,119,0,0,0,0,null,null,null,null,119,0,0,0,0]
[null,120,0,0,0,0,null,null,null,null,120,0,0,0,0]
[11,121,0,0,0,0,{"$f":"AVERAGE(F130:F141)","v":0},{"$f":"G130*$D$4","v":0},null,11,121,0,0,0,0,{"$f":"AVERAGE(O130:O141)","v":0},{"$f":"P130*$M$4","v":0},null,{"$f":"H130+Q130","v":0}]
[null,122,0,0,0,0,null,null,null,null,122,0,0,0,0]
[null,123,0,0,0,0,null,null,null,null,123,0,0,0,0]
[null,124,0,0,0,0,null,null,null,null,124,0,0,0,0]
[null,125,0,0,0,0,null,null,null,null,125,0,0,0,0]
[null,126,0,0,0,0,null,null,null,null,126,0,0,0,0]
[null,127,0,0,0,0,null,null,null,null,127,0,0,0,0]
[null,128,0,0,0,0,null,null,null,null,128,0,0,0,0]
[null,129,0,0,0,0,null,null,null,null,129,0,0,0,0]
[null,130,0,0,{"$f":"IF(ROUND(C139,2)>0,$D$7-D139,0)","v":0},0,null,null,null,null,130,0,{"$f":"L139*$M$3/12","v":0},{"$f":"IF(ROUND(L139,2)>0,$M$7-M139,0)","v":0},0]
[null,131,{"$f":"F139","v":0},{"$f":"C140*$D$3/12","v":0},0,{"$f":"C140-E140","v":0},null,null,null,null,131,{"$f":"O139","v":0},0,0,{"$f":"L140-N140","v":0}]
[null,132,0,0,0,0,null,null,null,null,132,0,0,0,0]
[12,133,0,0,0,0,{"$f":"AVERAGE(F142:F153)","v":0},{"$f":"G142*$D$4","v":0},null,12,133,0,0,0,0,{"$f":"AVERAGE(O142:O153)","v":0},{"$f":"P142*$M$4","v":0},null,{"$f":"H142+Q142","v":0}]
[null,134,0,0,0,0,null,null,null,null,134,0,0,0,0]
[null,135,0,0,0,0,null,null,null,null,135,0,0,0,0]
[null,136,0,0,0,0,null,null,null,null,136,0,0,0,0]
[null,137,0,0,0,0,null,null,null,null,137,0,0,0,0]
[null,138,0,0,0,0,null,null,null,null,138,0,0,0,0]
[null,139,0,0,0,0,null,null,null,null,139,0,0,0,0]
[null,140,0,0,0,0,null,null,null,null,140,0,0,0,0]
[null,141,0,0,0,0,null,null,null,null,141,0,0,0,0]
[null,142,0,0,0,0,null,null,null,null,142,0,0,0,0]
[null,143,0,0,0,0,null,null,null,null,143,0,0,0,0]
[null,144,0,0,0,0,null,null,null,null,144,0,0,0,0]
[13,145,0,0,0,0,{"$f":"AVERAGE(F154:F165)","v":0},{"$f":"G154*$D$4","v":0},null,13,145,0,0,0,0,{"$f":"AVERAGE(O154:O165)","v":0},{"$f":"P154*$M$4","v":0},null,{"$f":"H154+Q154","v":0}]
[null,146,0,0,0,0,null,null,null,null,146,0,0,0,0]
[null,147,0,0,0,0,null,null,null,null,147,0,0,0,0]
[null,148,0,0,0,0,null,null,null,null,148,0,0,0,0]
[null,149,0,0,0,0,null,null,null,null,149,0,0,0,0]
[null,150,0,0,0,0,null,null,null,null,150,0,0,0,0]
[null,151,0,0,0,0,null,null,null,null,151,0,0,0,0]
[null,152,0,0,0,0,null,null,null,null,152,0,0,0,0]
[null,153,0,0,0,0,null,null,null,null,153,0,0,0,0]
[null,154,0,0,0,0,null,null,null,null,154,0,0,0,0]
[null,155,0,0,0,0,null,null,null,null,155,0,0,0,0]
[null,156,0,0,0,0,null,null,null,null,156,0,0,0,0]
[14,157,0,0,0,0,{"$f":"AVERAGE(F166:F177)","v":0},{"$f":"G166*$D$4","v":0},null,14,157,0,0,0,0,{"$f":"AVERAGE(O166:O177)","v":0},{"$f":"P166*$M$4","v":0},null,{"$f":"H166+Q166","v":0}]
[null,158,0,0,0,0,null,null,null,null,158,0,0,0,0]
[null,159,0,0,0,0,null,null,null,null,159,0,0,0,0]
[null,160,0,0,0,0,null,null,null,null,160,0,0,0,0]
[null,161,0,0,0,0,null,null,null,null,161,0,0,0,0]
[null,162,0,0,0,0,null,null,null,null,162,0,0,0,0]
[null,163,0,0,0,0,null,null,null,null,163,0,0,0,0]
[null,164,0,0,0,0,null,null,null,null,164,0,0,0,0]
[null,165,0,0,0,0,null,null,null,null,165,0,0,0,0]
[null,166,0,0,0,0,null,null,null,null,166,0,0,0,0]
[null,167,0,0,0,0,null,null,null,null,167,0,0,0,0]
[null,168,0,0,0,0,null,null,null,null,168,0,0,0,0]
[15,169,0,0,0,0,{"$f":"AVERAGE(F178:F189)","v":0},{"$f":"G178*$D$4","v":0},null,15,169,0,0,0,0,{"$f":"AVERAGE(O178:O189)","v":0},{"$f":"P178*$M$4","v":0},null,{"$f":"H178+Q178","v":0}]
[null,170,0,0,0,0,null,null,null,null,170,0,0,0,0]
[null,171,0,0,0,0,null,null,null,null,171,0,0,0,0]
[null,172,0,0,0,0,null,null,null,null,172,0,0,0,0]
[null,173,0,0,0,0,null,null,null,null,173,0,0,0,0]
[null,174,0,0,0,0,null,null,null,null,174,0,0,0,0]
[null,175,0,0,0,0,null,null,null,null,175,0,0,0,0]
[null,176,0,0,0,0,null,null,null,null,176,0,0,0,0]
[null,177,0,0,0,0,null,null,null,null,177,0,0,0,0]
[null,178,0,0,0,0,null,null,null,null,178,0,0,0,0]
[null,179,0,0,0,0,null,null,null,null,179,0,0,0,0]
[null,180,0,0,0,0,null,null,null,null,180,0,0,0,0]
[16,181,0,0,0,0,{"$f":"AVERAGE(F190:F201)","v":0},{"$f":"G190*$D$4","v":0},null,16,181,0,0,0,0,{"$f":"AVERAGE(O190:O201)","v":0},{"$f":"P190*$M$4","v":0},null,{"$f":"H190+Q190","v":0}]
[null,182,0,0,0,0,null,null,null,null,182,0,0,0,0]
[null,183,0,0,0,0,null,null,null,null,183,0,0,0,0]
[null,184,0,0,0,0,null,null,null,null,184,0,0,0,0]
[null,185,0,0,0,0,null,null,null,null,185,0,0,0,0]
[null,186,0,0,0,0,null,null,null,null,186,0,0,0,0]
[null,187,0,0,0,0,null,null,null,null,187,0,0,0,0]
[null,188,0,0,0,0,null,null,null,null,188,0,0,0,0]
[null,189,0,0,0,0,null,null,null,null,189,0,0,0,0]
[null,190,0,0,0,0,null,null,null,null,190,0,0,0,0]
[null,191,0,0,0,0,null,null,null,null,191,0,0,0,0]
[null,192,0,0,0,0,null,null,null,null,192,0,0,0,0]
[17,193,0,0,0,0,{"$f":"AVERAGE(F202:F213)","v":0},{"$f":"G202*$D$4","v":0},null,17,193,0,0,0,0,{"$f":"AVERAGE(O202:O213)","v":0},{"$f":"P202*$M$4","v":0},null,{"$f":"H202+Q202","v":0}]
[null,194,0,0,{"$f":"IF(ROUND(C203,2)>0,$D$7-D203,0)","v":0},0,null,null,null,null,194,0,{"$f":"L203*$M$3/12","v":0},{"$f":"IF(ROUND(L203,2)>0,$M$7-M203,0)","v":0},0]
[null,195,{"$f":"F203","v":0},{"$f":"C204*$D$3/12","v":0},0,{"$f":"C204-E204","v":0},null,null,null,null,195,{"$f":"O203","v":0},0,0,{"$f":"L204-N204","v":0}]
[null,196,0,0,0,0,null,null,null,null,196,0,0,0,0]
[null,197,0,0,0,0,null,null,null,null,197,0,0,0,0]
[null,198,0,0,0,0,null,null,null,null,198,0,0,0,0]
[null,199,0,0,0,0,null,null,null,null,199,0,0,0,0]
[null,200,0,0,0,0,null,null,null,null,200,0,0,0,0]
[null,201,0,0,0,0,null,null,null,null,201,0,0,0,0]
[null,202,0,0,0,0,null,null,null,null,202,0,0,0,0]
[null,203,0,0,0,0,null,null,null,null,203,0,0,0,0]
[null,204,0,0,0,0,null,null,null,null,204,0,0,0,0]
[18,205,0,0,0,0,{"$f":"AVERAGE(F214:F225)","v":0},{"$f":"G214*$D$4","v":0},null,18,205,0,0,0,0,{"$f":"AVERAGE(O214:O225)","v":0},{"$f":"P214*$M$4","v":0},null,{"$f":"H214+Q214","v":0}]
[null,206,0,0,0,0,null,null,null,null,206,0,0,0,0]
[null,207,0,0,0,0,null,null,null,null,207,0,0,0,0]
[null,208,0,0,0,0,null,null,null,null,208,0,0,0,0]
[null,209,0,0,0,0,null,null,null,null,209,0,0,0,0]
[null,210,0,0,0,0,null,null,null,null,210,0,0,0,0]
[null,211,0,0,0,0,null,null,null,null,211,0,0,0,0]
[null,212,0,0,0,0,null,null,null,null,212,0,0,0,0]
[null,213,0,0,0,0,null,null,null,null,213,0,0,0,0]
[null,214,0,0,0,0,null,null,null,null,214,0,0,0,0]
[null,215,0,0,0,0,null,null,null,null,215,0,0,0,0]
[null,216,0,0,0,0,null,null,null,null,216,0,0,0,0]
[19,217,0,0,0,0,{"$f":"AVERAGE(F226:F237)","v":0},{"$f":"G226*$D$4","v":0},null,19,217,0,0,0,0,{"$f":"AVERAGE(O226:O237)","v":0},{"$f":"P226*$M$4","v":0},null,{"$f":"H226+Q226","v":0}]
[null,218,0,0,0,0,null,null,null,null,218,0,0,0,0]
[null,219,0,0,0,0,null,null,null,null,219,0,0,0,0]
[null,220,0,0,0,0,null,null,null,null,220,0,0,0,0]
[null,221,0,0,0,0,null,null,null,null,221,0,0,0,0]
[null,222,0,0,0,0,null,null,null,null,222,0,0,0,0]
[null,223,0,0,0,0,null,null,null,null,223,0,0,0,0]
[null,224,0,0,0,0,null,null,null,null,224,0,0,0,0]
[null,225,0,0,0,0,null,null,null,null,225,0,0,0,0]
[null,226,0,0,0,0,null,null,null,null,226,0,0,0,0]
[null,227,0,0,0,0,null,null,null,null,227,0,0,0,0]
[null,228,0,0,0,0,null,null,null,null,228,0,0,0,0]
[20,229,0,0,0,0,{"$f":"AVERAGE(F238:F249)","v":0},{"$f":"G238*$D$4","v":0},null,20,229,0,0,0,0,{"$f":"AVERAGE(O238:O249)","v":0},{"$f":"P238*$M$4","v":0},null,{"$f":"H238+Q238","v":0}]
[null,230,0,0,0,0,null,null,null,null,230,0,0,0,0]
[null,231,0,0,0,0,null,null,null,null,231,0,0,0,0]
[null,232,0,0,0,0,null,null,null,null,232,0,0,0,0]
[null,233,0,0,0,0,null,null,null,null,233,0,0,0,0]
[null,234,0,0,0,0,null,null,null,null,234,0,0,0,0]
[null,235,0,0,0,0,null,null,null,null,235,0,0,0,0]
[null,236,0,0,0,0,null,null,null,null,236,0,0,0,0]
[null,237,0,0,0,0,null,null,null,null,237,0,0,0,0]
[null,238,0,0,0,0,null,null,null,null,238,0,0,0,0]
[null,239,0,0,0,0,null,null,null,null,239,0,0,0,0]
[null,240,0,0,0,0,null,null,null,null,240,0,0,0,0]
[21,241,0,0,0,0,{"$f":"AVERAGE(F250:F261)","v":0},{"$f":"G250*$D$4","v":0},null,21,241,0,0,0,0,{"$f":"AVERAGE(O250:O261)","v":0},{"$f":"P250*$M$4","v":0},null,{"$f":"H250+Q250","v":0}]
[null,242,0,0,0,0,null,null,null,null,242,0,0,0,0]
[null,243,0,0,0,0,null,null,null,null,243,0,0,0,0]
[null,244,0,0,0,0,null,null,null,null,244,0,0,0,0]
[null,245,0,0,0,0,null,null,null,null,245,0,0,0,0]
[null,246,0,0,0,0,null,null,null,null,246,0,0,0,0]
[null,247,0,0,0,0,null,null,null,null,247,0,0,0,0]
[null,248,0,0,0,0,null,null,null,null,248,0,0,0,0]
[null,249,0,0,0,0,null,null,null,null,249,0,0,0,0]
[null,250,0,0,0,0,null,null,null,null,250,0,0,0,0]
[null,251,0,0,0,0,null,null,null,null,251,0,0,0,0]
[null,252,0,0,0,0,null,null,null,null,252,0,0,0,0]
[22,253,0,0,0,0,{"$f":"AVERAGE(F262:F273)","v":0},{"$f":"G262*$D$4","v":0},null,22,253,0,0,0,0,{"$f":"AVERAGE(O262:O273)","v":0},{"$f":"P262*$M$4","v":0},null,{"$f":"H262+Q262","v":0}]
[null,254,0,0,0,0,null,null,null,null,254,0,0,0,0]
[null,255,0,0,0,0,null,null,null,null,255,0,0,0,0]
[null,256,0,0,0,0,null,null,null,null,256,0,0,0,0]
[null,257,0,0,0,0,null,null,null,null,257,0,0,0,0]
[null,258,0,0,{"$f":"IF(ROUND(C267,2)>0,$D$7-D267,0)","v":0},0,null,null,null,null,258,0,{"$f":"L267*$M$3/12","v":0},{"$f":"IF(ROUND(L267,2)>0,$M$7-M267,0)","v":0},0]
[null,259,{"$f":"F267","v":0},{"$f":"C268*$D$3/12","v":0},0,{"$f":"C268-E268","v":0},null,null,null,null,259,{"$f":"O267","v":0},0,0,{"$f":"L268-N268","v":0}]
[null,260,0,0,0,0,null,null,null,null,260,0,0,0,0]
[null,261,0,0,0,0,null,null,null,null,261,0,0,0,0]
[null,262,0,0,0,0,null,null,null,null,262,0,0,0,0]
[null,263,0,0,0,0,null,null,null,null,263,0,0,0,0]
[null,264,0,0,0,0,null,null,null,null,264,0,0,0,0]
[23,265,0,0,0,0,{"$f":"AVERAGE(F274:F285)","v":0},{"$f":"G274*$D$4","v":0},null,23,265,0,0,0,0,{"$f":"AVERAGE(O274:O285)","v":0},{"$f":"P274*$M$4","v":0},null,{"$f":"H274+Q274","v":0}]
[null,266,0,0,0,0,null,null,null,null,266,0,0,0,0]
[null,267,0,0,0,0,null,null,null,null,267,0,0,0,0]
[null,268,0,0,0,0,null,null,null,null,268,0,0,0,0]
[null,269,0,0,0,0,null,null,null,null,269,0,0,0,0]
[null,270,0,0,0,0,null,null,null,null,270,0,0,0,0]
[null,271,0,0,0,0,null,null,null,null,271,0,0,0,0]
[null,272,0,0,0,0,null,null,null,null,272,0,0,0,0]
[null,273,0,0,0,0,null,null,null,null,273,0,0,0,0]
[null,274,0,0,0,0,null,null,null,null,274,0,0,0,0]
[null,275,0,0,0,0,null,null,null,null,275,0,0,0,0]
[null,276,0,0,0,0,null,null,null,null,276,0,0,0,0]
[24,277,0,0,0,0,{"$f":"AVERAGE(F286:F297)","v":0},{"$f":"G286*$D$4","v":0},null,24,277,0,0,0,0,{"$f":"AVERAGE(O286:O297)","v":0},{"$f":"P286*$M$4","v":0},null,{"$f":"H286+Q286","v":0}]
[null,278,0,0,0,0,null,null,null,null,278,0,0,0,0]
[null,279,0,0,0,0,null,null,null,null,279,0,0,0,0]
[null,280,0,0,0,0,null,null,null,null,280,0,0,0,0]
[null,281,0,0,0,0,null,null,null,null,281,0,0,0,0]
[null,282,0,0,0,0,null,null,null,null,282,0,0,0,0]
[null,283,0,0,0,0,null,null,null,null,283,0,0,0,0]
[null,284,0,0,0,0,null,null,null,null,284,0,0,0,0]
[null,285,0,0,0,0,null,null,null,null,285,0,0,0,0]
[null,286,0,0,0,0,null,null,null,null,286,0,0,0,0]
[null,287,0,0,0,0,null,null,null,null,287,0,0,0,0]
[null,288,0,0,0,0,null,null,null,null,288,0,0,0,0]
[25,289,0,0,0,0,{"$f":"AVERAGE(F298:F309)","v":0},{"$f":"G298*$D$4","v":0},null,25,289,0,0,0,0,{"$f":"AVERAGE(O298:O309)","v":0},{"$f":"P298*$M$4","v":0},null,{"$f":"H298+Q298","v":0}]
[null,290,0,0,0,0,null,null,null,null,290,0,0,0,0]
[null,291,0,0,0,0,null,null,null,null,291,0,0,0,0]
[null,292,0,0,0,0,null,null,null,null,292,0,0,0,0]
[null,293,0,0,0,0,null,null,null,null,293,0,0,0,0]
[null,294,0,0,0,0,null,null,null,null,294,0,0,0,0]
[null,295,0,0,0,0,null,null,null,null,295,0,0,0,0]
[null,296,0,0,0,0,null,null,null,null,296,0,0,0,0]
[null,297,0,0,0,0,null,null,null,null,297,0,0,0,0]
[null,298,0,0,0,0,null,null,null,null,298,0,0,0,0]
[null,299,0,0,0,0,null,null,null,null,299,0,0,0,0]
[null,300,0,0,0,0,null,null,null,null,300,0,0,0,0]
[26,301,0,0,0,0,{"$f":"AVERAGE(F310:F321)","v":0},{"$f":"G310*$D$4","v":0},null,26,301,0,0,0,0,{"$f":"AVERAGE(O310:O321)","v":0},{"$f":"P310*$M$4","v":0},null,{"$f":"H310+Q310","v":0}]
[null,302,0,0,0,0,null,null,null,null,302,0,0,0,0]
[null,303,0,0,0,0,null,null,null,null,303,0,0,0,0]
[null,304,0,0,0,0,null,null,null,null,304,0,0,0,0]
[null,305,0,0,0,0,null,null,null,null,305,0,0,0,0]
[null,306,0,0,0,0,null,null,null,null,306,0,0,0,0]
[null,307,0,0,0,0,null,null,null,null,307,0,0,0,0]
[null,308,0,0,0,0,null,null,null,null,308,0,0,0,0]
[null,309,0,0,0,0,null,null,null,null,309,0,0,0,0]
[null,310,0,0,0,0,null,null,null,null,310,0,0,0,0]
[null,311,0,0,0,0,null,null,null,null,311,0,0,0,0]
[null,312,0,0,0,0,null,null,null,null,312,0,0,0,0]
[27,313,0,0,0,0,{"$f":"AVERAGE(F322:F333)","v":0},{"$f":"G322*$D$4","v":0},null,27,313,0,0,0,0,{"$f":"AVERAGE(O322:O333)","v":0},{"$f":"P322*$M$4","v":0},null,{"$f":"H322+Q322","v":0}]
[null,314,0,0,0,0,null,null,null,null,314,0,0,0,0]
[null,315,0,0,0,0,null,null,null,null,315,0,0,0,0]
[null,316,0,0,0,0,null,null,null,null,316,0,0,0,0]
[null,317,0,0,0,0,null,null,null,null,317,0,0,0,0]
[null,318,0,0,0,0,null,null,null,null,318,0,0,0,0]
[null,319,0,0,0,0,null,null,null,null,319,0,0,0,0]
[null,320,0,0,0,0,null,null,null,null,320,0,0,0,0]
[null,321,0,0,0,0,null,null,null,null,321,0,0,0,0]
[null,322,0,0,{"$f":"IF(ROUND(C331,2)>0,$D$7-D331,0)","v":0},0,null,null,null,null,322,0,{"$f":"L331*$M$3/12","v":0},{"$f":"IF(ROUND(L331,2)>0,$M$7-M331,0)","v":0},0]
[null,323,{"$f":"F331","v":0},{"$f":"C332*$D$3/12","v":0},0,{"$f":"C332-E332","v":0},null,null,null,null,323,{"$f":"O331","v":0},0,0,{"$f":"L332-N332","v":0}]
[null,324,0,0,0,0,null,null,null,null,324,0,0,0,0]
[28,325,0,0,0,0,{"$f":"AVERAGE(F334:F345)","v":0},{"$f":"G334*$D$4","v":0},null,28,325,0,0,0,0,{"$f":"AVERAGE(O334:O345)","v":0},{"$f":"P334*$M$4","v":0},null,{"$f":"H334+Q334","v":0}]
[null,326,0,0,0,0,null,null,null,null,326,0,0,0,0]
[null,327,0,0,0,0,null,null,null,null,327,0,0,0,0]
[null,328,0,0,0,0,null,null,null,null,328,0,0,0,0]
[null,329,0,0,0,0,null,null,null,null,329,0,0,0,0]
[null,330,0,0,0,0,null,null,null,null,330,0,0,0,0]
[null,331,0,0,0,0,null,null,null,null,331,0,0,0,0]
[null,332,0,0,0,0,null,null,null,null,332,0,0,0,0]
[null,333,0,0,0,0,null,null,null,null,333,0,0,0,0]
[null,334,0,0,0,0,null,null,null,null,334,0,0,0,0]
[null,335,0,0,0,0,null,null,null,null,335,0,0,0,0]
[null,336,0,0,0,0,null,null,null,null,336,0,0,0,0]
[29,337,0,0,0,0,{"$f":"AVERAGE(F346:F357)","v":0},{"$f":"G346*$D$4","v":0},null,29,337,0,0,0,0,{"$f":"AVERAGE(O346:O357)","v":0},{"$f":"P346*$M$4","v":0},null,{"$f":"H346+Q346","v":0}]
[null,338,0,0,0,0,null,null,null,null,338,0,0,0,0]
[null,339,0,0,0,0,null,null,null,null,339,0,0,0,0]
[null,340,0,0,0,0,null,null,null,null,340,0,0,0,0]
[null,341,0,0,0,0,null,null,null,null,341,0,0,0,0]
[null,342,0,0,0,0,null,null,null,null,342,0,0,0,0]
[null,343,0,0,0,0,null,null,null,null,343,0,0,0,0]
[null,344,0,0,0,0,null,null,null,null,344,0,0,0,0]
[null,345,0,0,0,0,null,null,null,null,345,0,0,0,0]
[null,346,0,0,0,0,null,null,null,null,346,0,0,0,0]
[null,347,0,0,0,0,null,null,null,null,347,0,0,0,0]
[null,348,0,0,0,0,null,null,null,null,348,0,0,0,0]
[30,349,0,0,0,0,{"$f":"AVERAGE(F358:F369)","v":0},{"$f":"G358*$D$4","v":0},null,30,349,0,0,0,0,{"$f":"AVERAGE(O358:O369)","v":0},{"$f":"P358*$M$4","v":0},null,{"$f":"H358+Q358","v":0}]
[null,350,0,0,0,0,null,null,null,null,350,0,0,0,0]
[null,351,0,0,0,0,null,null,null,null,351,0,0,0,0]
[null,352,0,0,0,0,null,null,null,null,352,0,0,0,0]
[null,353,0,0,0,0,null,null,null,null,353,0,0,0,0]
[null,354,0,0,0,0,null,null,null,null,354,0,0,0,0]
[null,355,0,0,0,0,null,null,null,null,355,0,0,0,0]
[null,356,0,0,0,0,null,null,null,null,356,0,0,0,0]
[null,357,0,0,0,0,null,null,null,null,357,0,0,0,0]
[null,358,0,0,0,0,null,null,null,null,358,0,0,0,0]
[null,359,0,0,0,0,null,null,null,null,359,0,0,0,0]
[null,360,0,0,0,0,null,null,null,null,360,0,0,0,0]
[31,361,0,0,0,0,{"$f":"AVERAGE(F370:F381)","v":0},{"$f":"G370*$D$4","v":0},null,31,361,0,0,0,0,{"$f":"AVERAGE(O370:O381)","v":0},{"$f":"P370*$M$4","v":0},null,{"$f":"H370+Q370","v":0}]
[null,362,0,0,0,0,null,null,null,null,362,0,0,0,0]
[null,363,0,0,0,0,null,null,null,null,363,0,0,0,0]
[null,364,0,0,0,0,null,null,null,null,364,0,0,0,0]
[null,365,0,0,0,0,null,null,null,null,365,0,0,0,0]
[null,366,0,0,0,0,null,null,null,null,366,0,0,0,0]
[null,367,0,0,0,0,null,null,null,null,367,0,0,0,0]
[null,368,0,0,0,0,null,null,null,null,368,0,0,0,0]
[null,369,0,0,0,0,null,null,null,null,369,0,0,0,0]
[null,370,0,0,0,0,null,null,null,null,370,0,0,0,0]
[null,371,0,0,0,0,null,null,null,null,371,0,0,0,0]
[null,372,0,0,0,0,null,null,null,null,372,0,0,0,0]
[32,373,0,0,0,0,{"$f":"AVERAGE(F382:F393)","v":0},{"$f":"G382*$D$4","v":0},null,32,373,0,0,0,0,{"$f":"AVERAGE(O382:O393)","v":0},{"$f":"P382*$M$4","v":0},null,{"$f":"H382+Q382","v":0}]
[null,374,0,0,0,0,null,null,null,null,374,0,0,0,0]
[null,375,0,0,0,0,null,null,null,null,375,0,0,0,0]
[null,376,0,0,0,0,null,null,null,null,376,0,0,0,0]
[null,377,0,0,0,0,null,null,null,null,377,0,0,0,0]
[null,378,0,0,0,0,null,null,null,null,378,0,0,0,0]
[null,379,0,0,0,0,null,null,null,null,379,0,0,0,0]
[null,380,0,0,0,0,null,null,null,null,380,0,0,0,0]
[null,381,0,0,0,0,null,null,null,null,381,0,0,0,0]
[null,382,0,0,0,0,null,null,null,null,382,0,0,0,0]
[null,383,0,0,0,0,null,null,null,null,383,0,0,0,0]
[null,384,0,0,0,0,null,null,null,null,384,0,0,0,0]
[33,385,0,0,0,0,{"$f":"AVERAGE(F394:F405)","v":0},{"$f":"G394*$D$4","v":0},null,33,385,0,0,0,0,{"$f":"AVERAGE(O394:O405)","v":0},{"$f":"P394*$M$4","v":0},null,{"$f":"H394+Q394","v":0}]
[null,386,0,0,{"$f":"IF(ROUND(C395,2)>0,$D$7-D395,0)","v":0},0,null,null,null,null,386,0,{"$f":"L395*$M$3/12","v":0},{"$f":"IF(ROUND(L395,2)>0,$M$7-M395,0)","v":0},0]
[null,387,{"$f":"F395","v":0},{"$f":"C396*$D$3/12","v":0},0,{"$f":"C396-E396","v":0},null,null,null,null,387,{"$f":"O395","v":0},0,0,{"$f":"L396-N396","v":0}]
[null,388,0,0,0,0,null,null,null,null,388,0,0,0,0]
[null,389,0,0,0,0,null,null,null,null,389,0,0,0,0]
[null,390,0,0,0,0,null,null,null,null,390,0,0,0,0]
[null,391,0,0,0,0,null,null,null,null,391,0,0,0,0]
[null,392,0,0,0,0,null,null,null,null,392,0,0,0,0]
[null,393,0,0,0,0,null,null,null,null,393,0,0,0,0]
[null,394,0,0,0,0,null,null,null,null,394,0,0,0,0]
[null,395,0,0,0,0,null,null,null,null,395,0,0,0,0]
[null,396,0,0,0,0,null,null,null,null,396,0,0,0,0]
[34,397,0,0,0,0,{"$f":"AVERAGE(F406:F417)","v":0},{"$f":"G406*$D$4","v":0},null,34,397,0,0,0,0,{"$f":"AVERAGE(O406:O417)","v":0},{"$f":"P406*$M$4","v":0},null,{"$f":"H406+Q406","v":0}]
[null,398,0,0,0,0,null,null,null,null,398,0,0,0,0]
[null,399,0,0,0,0,null,null,null,null,399,0,0,0,0]
[null,400,0,0,0,0,null,null,null,null,400,0,0,0,0]
[null,401,0,0,0,0,null,null,null,null,401,0,0,0,0]
[null,402,0,0,0,0,null,null,null,null,402,0,0,0,0]
[null,403,0,0,0,0,null,null,null,null,403,0,0,0,0]
[null,404,0,0,0,0,null,null,null,null,404,0,0,0,0]
[null,405,0,0,0,0,null,null,null,null,405,0,0,0,0]
[null,406,0,0,0,0,null,null,null,null,406,0,0,0,0]
[null,407,0,0,0,0,null,null,null,null,407,0,0,0,0]
[null,408,0,0,0,0,null,null,null,null,408,0,0,0,0]
[35,409,0,0,0,0,{"$f":"AVERAGE(F418:F429)","v":0},{"$f":"G418*$D$4","v":0},null,35,409,0,0,0,0,{"$f":"AVERAGE(O418:O429)","v":0},{"$f":"P418*$M$4","v":0},null,{"$f":"H418+Q418","v":0}]
[null,410,0,0,0,0,null,null,null,null,410,0,0,0,0]
[null,411,0,0,0,0,null,null,null,null,411,0,0,0,0]
[null,412,0,0,0,0,null,null,null,null,412,0,0,0,0]
[null,413,0,0,0,0,null,null,null,null,413,0,0,0,0]
[null,414,0,0,0,0,null,null,null,null,414,0,0,0,0]
[null,415,0,0,0,0,null,null,null,null,415,0,0,0,0]
[null,416,0,0,0,0,null,null,null,null,416,0,0,0,0]
[null,417,0,0,0,0,null,null,null,null,417,0,0,0,0]
[null,418,0,0,0,0,null,null,null,null,418,0,0,0,0]
[null,419,0,0,0,0,null,null,null,null,419,0,0,0,0]
[null,420,0,0,0,0,null,null,null,null,420,0,0,0,0]
[36,421,0,0,0,0,{"$f":"AVERAGE(F430:F441)","v":0},{"$f":"G430*$D$4","v":0},null,36,421,0,0,0,0,{"$f":"AVERAGE(O430:O441)","v":0},{"$f":"P430*$M$4","v":0},null,{"$f":"H430+Q430","v":0}]
[null,422,0,0,0,0,null,null,null,null,422,0,0,0,0]
[null,423,0,0,0,0,null,null,null,null,423,0,0,0,0]
[null,424,0,0,0,0,null,null,null,null,424,0,0,0,0]
[null,425,0,0,0,0,null,null,null,null,425,0,0,0,0]
[null,426,0,0,0,0,null,null,null,null,426,0,0,0,0]
[null,427,0,0,0,0,null,null,null,null,427,0,0,0,0]
[null,428,0,0,0,0,null,null,null,null,428,0,0,0,0]
[null,429,0,0,0,0,null,null,null,null,429,0,0,0,0]
[null,430,0,0,0,0,null,null,null,null,430,0,0,0,0]
[null,431,0,0,0,0,null,null,null,null,431,0,0,0,0]
[null,432,0,0,0,0,null,null,null,null,432,0,0,0,0]
[37,433,0,0,0,0,{"$f":"AVERAGE(F442:F453)","v":0},{"$f":"G442*$D$4","v":0},null,37,433,0,0,0,0,{"$f":"AVERAGE(O442:O453)","v":0},{"$f":"P442*$M$4","v":0},null,{"$f":"H442+Q442","v":0}]
[null,434,0,0,0,0,null,null,null,null,434,0,0,0,0]
[null,435,0,0,0,0,null,null,null,null,435,0,0,0,0]
[null,436,0,0,0,0,null,null,null,null,436,0,0,0,0]
[null,437,0,0,0,0,null,null,null,null,437,0,0,0,0]
[null,438,0,0,0,0,null,null,null,null,438,0,0,0,0]
[null,439,0,0,0,0,null,null,null,null,439,0,0,0,0]
[null,440,0,0,0,0,null,null,null,null,440,0,0,0,0]
[null,441,0,0,0,0,null,null,null,null,441,0,0,0,0]
[null,442,0,0,0,0,null,null,null,null,442,0,0,0,0]
[null,443,0,0,0,0,null,null,null,null,443,0,0,0,0]
[null,444,0,0,0,0,null,null,null,null,444,0,0,0,0]
[38,445,0,0,0,0,{"$f":"AVERAGE(F454:F465)","v":0},{"$f":"G454*$D$4","v":0},null,38,445,0,0,0,0,{"$f":"AVERAGE(O454:O465)","v":0},{"$f":"P454*$M$4","v":0},null,{"$f":"H454+Q454","v":0}]
[null,446,0,0,0,0,null,null,null,null,446,0,0,0,0]
[null,447,0,0,0,0,null,null,null,null,447,0,0,0,0]
[null,448,0,0,0,0,null,null,null,null,448,0,0,0,0]
[null,449,0,0,0,0,null,null,null,null,449,0,0,0,0]
[null,450,0,0,{"$f":"IF(ROUND(C459,2)>0,$D$7-D459,0)","v":0},0,null,null,null,null,450,0,{"$f":"L459*$M$3/12","v":0},{"$f":"IF(ROUND(L459,2)>0,$M$7-M459,0)","v":0},0]
[null,451,{"$f":"F459","v":0},{"$f":"C460*$D$3/12","v":0},0,{"$f":"C460-E460","v":0},null,null,null,null,451,{"$f":"O459","v":0},0,0,{"$f":"L460-N460","v":0}]
[null,452,0,0,0,0,null,null,null,null,452,0,0,0,0]
[null,453,0,0,0,0,null,null,null,null,453,0,0,0,0]
[null,454,0,0,0,0,null,null,null,null,454,0,0,0,0]
[null,455,0,0,0,0,null,null,null,null,455,0,0,0,0]
[null,456,0,0,0,0,null,null,null,null,456,0,0,0,0]
[39,457,0,0,0,0,{"$f":"AVERAGE(F466:F477)","v":0},{"$f":"G466*$D$4","v":0},null,39,457,0,0,0,0,{"$f":"AVERAGE(O466:O477)","v":0},{"$f":"P466*$M$4","v":0},null,{"$f":"H466+Q466","v":0}]
[null,458,0,0,0,0,null,null,null,null,458,0,0,0,0]
[null,459,0,0,0,0,null,null,null,null,459,0,0,0,0]
[null,460,0,0,0,0,null,null,null,null,460,0,0,0,0]
[null,461,0,0,0,0,null,null,null,null,461,0,0,0,0]
[null,462,0,0,0,0,null,null,null,null,462,0,0,0,0]
[null,463,0,0,0,0,null,null,null,null,463,0,0,0,0]
[null,464,0,0,0,0,null,null,null,null,464,0,0,0,0]
[null,465,0,0,0,0,null,null,null,null,465,0,0,0,0]
[null,466,0,0,0,0,null,null,null,null,466,0,0,0,0]
[null,467,0,0,0,0,null,null,null,null,467,0,0,0,0]
[null,468,0,0,0,0,null,null,null,null,468,0,0,0,0]
[40,469,0,0,0,0,{"$f":"AVERAGE(F478:F489)","v":0},{"$f":"G478*$D$4","v":0},null,40,469,0,0,0,0,{"$f":"AVERAGE(O478:O489)","v":0},{"$f":"P478*$M$4","v":0},null,{"$f":"H478+Q478","v":0}]
[null,470,0,0,0,0,null,null,null,null,470,0,0,0,0]
[null,471,0,0,0,0,null,null,null,null,471,0,0,0,0]
[null,472,0,0,0,0,null,null,null,null,472,0,0,0,0]
[null,473,0,0,0,0,null,null,null,null,473,0,0,0,0]
[null,474,0,0,0,0,null,null,null,null,474,0,0,0,0]
[null,475,0,0,0,0,null,null,null,null,475,0,0,0,0]
[null,476,0,0,0,0,null,null,null,null,476,0,0,0,0]
[null,477,0,0,0,0,null,null,null,null,477,0,0,0,0]
[null,478,0,0,0,0,null,null,null,null,478,0,0,0,0]
[null,479,0,0,0,0,null,null,null,null,479,0,0,0,0]
[null,480,0,0,0,0,null,null,null,null,480,0,0,0,0]

{"sheet":"Summary (MHFA Use Only)","index":9,"n_rows":96,"n_cols":6,"rows_kept":96,"cut":false,"hidden":false,"merged":[[2,1,2,5],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[65,0,65,1],[85,0,85,1],[39,0,39,4],[9,0,9,4],[63,0,63,4],[15,1,15,5],[14,1,14,5],[65,3,65,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5]]}
["Project Summary"]
[]
["Property Number (D#)"]
["Project Number (M#)"]
["Project Name",{"$f":"ProjDesc_ProjectName","v":0}]
["City",{"$f":"ProjDesc_City","v":0}]
["Activity Type",{"$f":"ProjDesc_ActivityType_Response","v":0}]
[]
["Development Team"]
[]
["Eligible Recipient Submitting Application",{"$f":"ProjDesc_EligibleRecipient","v":0}]
["Developer",{"$f":"ProjDesc_Developer","v":0}]
["General Contractor",{"$f":"ProjDesc_GeneralContractor","v":0}]
["Architect",{"$f":"ProjDesc_Architect","v":0}]
["Management Company",{"$f":"ProjDesc_ManagementCompany","v":0}]
["Permanent Owner",{"$f":"ProjDesc_PermanentOwner","v":0}]
[]
["Financial Information "]
[]
[null,"Amount","Per Unit"]
["Funding Request",{"$f":"Sources_WorkforceHousingRequestedAmount","v":0},{"$f":"IFERROR(Sources_WorkforceHousingRequestedAmount/UnitMix_Summary_UnitCount_Total,)","v":0}]
["Matching Funds",{"$f":"Sources_TotalMatchAmount","v":0},{"$f":"IFERROR(Sources_TotalMatchAmount/UnitMix_Summary_UnitCount_Total,)","v":0}]
["Total Development Costs",{"$f":"DevCosts_TDC","v":0},{"$f":"IFERROR(DevCosts_TDC/UnitMix_Summary_UnitCount_Total,)","v":0}]
[]
["Funding Request Percentage of TDC",{"$f":"IFERROR(Sources_WorkforceHousingRequestedAmount/DevCosts_TDC,)","v":0}]
[]
["Property Information"]
[]
["Number of Studios",{"$f":"UnitMix_Summary_UnitCount_Studio","v":0}]
["Number of One-bedrooms",{"$f":"UnitMix_Summary_UnitCount_1BR","v":0}]
["Number of Two-bedrooms",{"$f":"UnitMix_Summary_UnitCount_2BR","v":0}]
["Number of three-bedrooms",{"$f":"UnitMix_Summary_UnitCount_3BR","v":0}]
["Number of four-bedrooms",{"$f":"UnitMix_Summary_UnitCount_4BR","v":0}]
["Number of five-bedrooms",{"$f":"UnitMix_Summary_UnitCount_5BR","v":0}]
["Total Units",{"$f":"UnitMix_Summary_UnitCount_Total","v":0}]
[]
["Number of Income-restricted Units",{"$f":"ProjDesc_RestrictedUnitCount","v":0}]
["Number of Market Rate Units",{"$f":"ProjDesc_MarketRateUnits","v":0}]
[]
["Rent Grid"]
["Bedrooms","Baths","# Units","Square Feet","Net Rent"]
[{"$f":"'Unit Mix'!A6","v":0},{"$f":"'Unit Mix'!B6","v":0},{"$f":"'Unit Mix'!C6","v":0},{"$f":"'Unit Mix'!D6","v":0},{"$f":"'Unit Mix'!E6","v":0}]
[{"$f":"'Unit Mix'!A7","v":0},{"$f":"'Unit Mix'!B7","v":0},{"$f":"'Unit Mix'!C7","v":0},{"$f":"'Unit Mix'!D7","v":0},{"$f":"'Unit Mix'!E7","v":0}]
[{"$f":"'Unit Mix'!A8","v":0},{"$f":"'Unit Mix'!B8","v":0},{"$f":"'Unit Mix'!C8","v":0},{"$f":"'Unit Mix'!D8","v":0},{"$f":"'Unit Mix'!E8","v":0}]
[{"$f":"'Unit Mix'!A9","v":0},{"$f":"'Unit Mix'!B9","v":0},{"$f":"'Unit Mix'!C9","v":0},{"$f":"'Unit Mix'!D9","v":0},{"$f":"'Unit Mix'!E9","v":0}]
[{"$f":"'Unit Mix'!A10","v":0},{"$f":"'Unit Mix'!B10","v":0},{"$f":"'Unit Mix'!C10","v":0},{"$f":"'Unit Mix'!D10","v":0},{"$f":"'Unit Mix'!E10","v":0}]
[{"$f":"'Unit Mix'!A11","v":0},{"$f":"'Unit Mix'!B11","v":0},{"$f":"'Unit Mix'!C11","v":0},{"$f":"'Unit Mix'!D11","v":0},{"$f":"'Unit Mix'!E11","v":0}]
[{"$f":"'Unit Mix'!A12","v":0},{"$f":"'Unit Mix'!B12","v":0},{"$f":"'Unit Mix'!C12","v":0},{"$f":"'Unit Mix'!D12","v":0},{"$f":"'Unit Mix'!E12","v":0}]
[{"$f":"'Unit Mix'!A13","v":0},{"$f":"'Unit Mix'!B13","v":0},{"$f":"'Unit Mix'!C13","v":0},{"$f":"'Unit Mix'!D13","v":0},{"$f":"'Unit Mix'!E13","v":0}]
[{"$f":"'Unit Mix'!A14","v":0},{"$f":"'Unit Mix'!B14","v":0},{"$f":"'Unit Mix'!C14","v":0},{"$f":"'Unit Mix'!D14","v":0},{"$f":"'Unit Mix'!E14","v":0}]
[{"$f":"'Unit Mix'!A15","v":0},{"$f":"'Unit Mix'!B15","v":0},{"$f":"'Unit Mix'!C15","v":0},{"$f":"'Unit Mix'!D15","v":0},{"$f":"'Unit Mix'!E15","v":0}]
[{"$f":"'Unit Mix'!A16","v":0},{"$f":"'Unit Mix'!B16","v":0},{"$f":"'Unit Mix'!C16","v":0},{"$f":"'Unit Mix'!D16","v":0},{"$f":"'Unit Mix'!E16","v":0}]
[{"$f":"'Unit Mix'!A17","v":0},{"$f":"'Unit Mix'!B17","v":0},{"$f":"'Unit Mix'!C17","v":0},{"$f":"'Unit Mix'!D17","v":0},{"$f":"'Unit Mix'!E17","v":0}]
[{"$f":"'Unit Mix'!A18","v":0},{"$f":"'Unit Mix'!B18","v":0},{"$f":"'Unit Mix'!C18","v":0},{"$f":"'Unit Mix'!D18","v":0},{"$f":"'Unit Mix'!E18","v":0}]
[{"$f":"'Unit Mix'!A19","v":0},{"$f":"'Unit Mix'!B19","v":0},{"$f":"'Unit Mix'!C19","v":0},{"$f":"'Unit Mix'!D19","v":0},{"$f":"'Unit Mix'!E19","v":0}]
[{"$f":"'Unit Mix'!A20","v":0},{"$f":"'Unit Mix'!B20","v":0},{"$f":"'Unit Mix'!C20","v":0},{"$f":"'Unit Mix'!D20","v":0},{"$f":"'Unit Mix'!E20","v":0}]
[{"$f":"'Unit Mix'!A21","v":0},{"$f":"'Unit Mix'!B21","v":0},{"$f":"'Unit Mix'!C21","v":0},{"$f":"'Unit Mix'!D21","v":0},{"$f":"'Unit Mix'!E21","v":0}]
[{"$f":"'Unit Mix'!A22","v":0},{"$f":"'Unit Mix'!B22","v":0},{"$f":"'Unit Mix'!C22","v":0},{"$f":"'Unit Mix'!D22","v":0},{"$f":"'Unit Mix'!E22","v":0}]
[{"$f":"'Unit Mix'!A23","v":0},{"$f":"'Unit Mix'!B23","v":0},{"$f":"'Unit Mix'!C23","v":0},{"$f":"'Unit Mix'!D23","v":0},{"$f":"'Unit Mix'!E23","v":0}]
[{"$f":"'Unit Mix'!A24","v":0},{"$f":"'Unit Mix'!B24","v":0},{"$f":"'Unit Mix'!C24","v":0},{"$f":"'Unit Mix'!D24","v":0},{"$f":"'Unit Mix'!E24","v":0}]
[{"$f":"'Unit Mix'!A25","v":0},{"$f":"'Unit Mix'!B25","v":0},{"$f":"'Unit Mix'!C25","v":0},{"$f":"'Unit Mix'!D25","v":0},{"$f":"'Unit Mix'!E25","v":0}]
[{"$f":"'Unit Mix'!A26","v":0},{"$f":"'Unit Mix'!B26","v":0},{"$f":"'Unit Mix'!C26","v":0},{"$f":"'Unit Mix'!D26","v":0},{"$f":"'Unit Mix'!E26","v":0}]
[]
["Sources and Uses"]
[]
["Permanent Sources",null,null,"Uses"]
["Name of Source","Amount ",null,"Description","Amount ","% of Total"]
[{"$f":"Source_First_Mortgage","v":"First Mortgage"},{"$f":"Sources!G15","v":0},null,"Acquisition",{"$f":"'Development Costs'!H15","v":0},{"$f":"IFERROR(E68/$E$75,\"\")","v":""}]
[{"$f":"Source_TIF_Mortgage","v":"TIF Mortgage (if separate from 1st)"},{"$f":"Sources!G16","v":0},null,"Construction",{"$f":"'Development Costs'!H41","v":0},{"$f":"IFERROR(E69/$E$75,\"\")","v":""}]
[{"$f":"Source_Developer_Cash_Equity","v":"Developer Cash Equity"},{"$f":"Sources!G17","v":0},null,"Environmental Abatement",{"$f":"'Development Costs'!H48","v":0},""]
[{"$f":"Source_Sales_Tax_Rebate","v":"Sales Tax Rebate"},{"$f":"Sources!G18","v":0},null,"Professional Fees",{"$f":"'Development Costs'!H74","v":0},""]
[{"$f":"Source_Energy_Rebates","v":"Energy Rebates"},{"$f":"Sources!G19","v":0},null,"Developer Fee",{"$f":"DevCosts_TotalDeveloperFee","v":0},""]
[{"$f":"Source_Workforce_Housing_Program","v":"Workforce Housing Program "},{"$f":"Sources!G20","v":0},null,"Financing Costs",{"$f":"'Development Costs'!H107","v":0},""]
[{"$f":"Source_Other1","v":0},{"$f":"Source_Other1_Amount","v":0},null,"Reserves",{"$f":"'Development Costs'!H115","v":0},{"$f":"IFERROR(E74/$E$75,\"\")","v":""}]
[{"$f":"Source_Other2","v":0},{"$f":"Source_Other2_Amount","v":0},null,"Total ",{"$f":"DevCosts_TDC","v":0}]
[{"$f":"Source_Other3","v":0},{"$f":"Source_Other3_Amount","v":0}]
[{"$f":"Source_Other4","v":0},{"$f":"Source_Other4_Amount","v":0}]
[{"$f":"Source_Other5","v":0},{"$f":"Source_Other5_Amount","v":0}]
[{"$f":"Source_Other6","v":0},{"$f":"Source_Other6_Amount","v":0}]
[{"$f":"Source_Other7","v":0},{"$f":"Source_Other7_Amount","v":0}]
[{"$f":"Source_Other8","v":0},{"$f":"Source_Other8_Amount","v":0}]
[{"$f":"Source_Other9","v":0},{"$f":"Source_Other9_Amount","v":0}]
[{"$f":"Source_Other10","v":0},{"$f":"Source_Other10_Amount","v":0}]
["Total",{"$f":"Source_TotalPermFinancing","v":0}]
[]
["Match Sources"]
["Name of Source","Amount","Match Type"]
[{"$f":"Source_MatchSource1","v":0},{"$f":"Source_MatchSource1_Amount","v":0},{"$f":"Source_MatchSource1_Type","v":0}]
[{"$f":"Source_MatchSource2","v":0},{"$f":"Source_MatchSource2_Amount","v":0},{"$f":"Source_MatchSource2_Type","v":0}]
[{"$f":"Source_MatchSource3","v":0},{"$f":"Source_MatchSource3_Amount","v":0},{"$f":"Source_MatchSource3_Type","v":0}]
[{"$f":"Source_MatchSource4","v":0},{"$f":"Source_MatchSource4_Amount","v":0},{"$f":"Source_MatchSource4_Type","v":0}]
[{"$f":"Source_MatchSource5","v":0},{"$f":"Source_MatchSource5_Amount","v":0},{"$f":"Source_MatchSource5_Type","v":0}]
[{"$f":"Source_MatchSource6","v":0},{"$f":"Source_MatchSource6_Amount","v":0},{"$f":"Source_MatchSource6_Type","v":0}]
[{"$f":"Source_MatchSource7","v":0},{"$f":"Source_MatchSource7_Amount","v":0},{"$f":"Source_MatchSource7_Type","v":0}]
[{"$f":"Source_MatchSource8","v":0},{"$f":"Source_MatchSource8_Amount","v":0},{"$f":"Source_MatchSource8_Type","v":0}]
["Total",{"$f":"Sources_TotalMatchAmount","v":0}]

{"sheet":"DropDownList","index":10,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Yes/No","Activity Type","Funding Request Type","Building Type","Covered Parking Type","Unit Mix_Bedrooms","Match Type","Match Source Organization","Region"]
["Yes","Conversion/Adaptive ReUse","Grant","Duplex","Attached Garage","Studio","Capital","Local Unit of Government","Central"]
["No","New Construction","Deferred Loan","Elevator","Detatched Garage",1,"Non-Capital","Business","Northeast"]
[null,"Other (explain in narrative)",null,"Single Family","Underground",2,null,"Nonprofit Organization","Northwest"]
[null,null,null,"Townhouse","Ramp",3,null,"Federally Recognized Tribe","Southeast"]
[null,null,null,"Walk-Up",null,4,null,"Other (Describe in Comments)","Southwest"]
[null,null,null,"Combination ",null,5,null,null,"West Central"]
[null,null,null,"Other"]