{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":[" Instructions","Information","RSF Budget","FD  Budget","Names"," TSC Budget ","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":435,"comments":0,"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":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"STEP ONE: Complete the Information tab- This fills in the top sections of the budget forms"]
[]
[null,"Instructions for Completing the Revenue Shortfall Budget"]
[null,"Enter the number of vacant units at year end and the reserve balance"]
[null,"Use the actual financial statement submitted to complete the \"recently completed year\" budget column."]
[null,"Project the budget for For the \"next year budget\" column."]
[null,"Enter the year end account payables and receivables"]
[]
[" For ALL revenue and expense types, please provide a detailed description.  If additional information is needed to explain the revenue or expense, please "]
[null,"  use the ‘Notes’ column and put the note in the same row as the revenue or expense being described (there are not enough ‘Notes’ rows for all of the expenses "]
[null,"– please list the expenses that require explanation first)."]
[]
[null,"Front Desk and Service Coordinator tabs "]
[null,"REVENUES"]
[null,"For front desk costs and/or tenant service coordination, enter all revenues for the activity "]
[null,"·         Under ‘Revenues’, the ‘Source’  column contains a pull down menu.  The ‘Source’ column’s menu allows you to select the type of funding  "]
[null,null,"  source used to pay for the Front Desk (FD) or Service Coordinator (SC)."]
[null,"·         Description: enter the name of the funding source. Be as specific as possible (do not say \"state\" or \"DHS\", but actual funding source, e.g. LTH Supportive Services Grant)"]
[null,"·         Enter the actual revenue amount for the recently completed year and the project amount for the next year budget"]
[]
[null,"EXPENSES"]
[null,"For front desk costs and/or tenant service coordination, enter all expenses for the activity (do not limit to just the expenses that the OS grant pays)."]
[null,"·         Under ‘Expenses’, the ‘Type’ column contains a pull down menu which contains choices for the type of expense associated with the activity"]
[null,null,"Select each expense type for the activity."]
[null,"·         Description: enter a description of the expense; be specific as possible. For staff costs enter enter the number # of FTE hours"]
[null,"·         Enter the actual expense amount for the recently completed year and the projected expense amount for the next year budget"]
[]
[null,"Please save and submit the budget form using the naming convention of DXXXX_Name of Development.  For Example, D0742 Evergreen Terrace"]

{"sheet":"Information","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["OS Grant - 2022-24 Draw form - Please complete",null,null,"Enter the date of the recently completed fiscal year for the property"]
["Property Name",null,null,"Property Fiscal Year End Date (MM/YY)"]
["Development (D) Number",{"$f":"IFERROR(VLOOKUP(B2,Sheet1!B3:C51,2,FALSE),\" \")","v":" "}]

{"sheet":"RSF Budget","index":2,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,2,1,3],[2,2,2,3],[3,2,3,3]]}
[null,"REVENUE SHORTFALL BUDGET",null,null,null,"Budget Instructions:"]
[null,"Fiscal Year End Date (MM/YY):",{"$f":"OS_GrantRenewalInfo_PropertyFiscalYearEndDate","v":"00:00:00"},null,null,"Enter the Fiscal Year End date for the property on Information tab."]
[null,"Property Name:",{"$f":"OS_GrantRenewalInfo_ProjectName","v":0}]
[null,"D Number:",{"$f":"OS_GrantRenewalInfo_DevelopmentNumber","v":" "}]
[null,null,"Completed Year","Next Year",null,"Revenues: include all revenues that support operations. "]
[null,"Number of Vacant Units at Year End:",null,"N/A",null,"                 DO NOT include the operating subsidy grant amount in revenues."]
[null,"Reserve Balance (exclude tax and insurance):",null,"N/A",null,"Expenses: include all operational expenses"]
[null,null,null,null,null,"Notes: Please provide a detailed explanation of all line items"]
[null,"Operating Budget","Actual Financials for completed year","Budget for Next Year",null,"Operating Subsidy need is based on the NOI or Cash Flow (line 22) "]
[null,"Revenues"]
[null,"1. Tenant Rents",null,null,null,"Notes"]
[null,"2. Rental Subsidy"]
[null,"3. Less: Vacancy Loss"]
[null,"4. Total Rental Revenues ",{"$f":"OS_RSFBudget_OperatingBudget_Revenues_YearOne_TenantRents+OS_RSFBudget_OperatingBudget_Revenues_YearOne_RentalSubsidy-OS_RSFBudget_OperatingBudget_Revenues_YearOne_VacancyLoss","v":0},{"$f":"OS_RSFBudget_OperatingBudget_Revenues_YearTwo_TenantRents+OS_RSFBudget_OperatingBudget_Revenues_YearTwo_RentalSubsidy-OS_RSFBudget_OperatingBudget_Revenues_YearTwo_VacancyLoss","v":0}]
[null,"5. Interest Income"]
[null,"6. Other Income (Explain in notes)"]
[null,"7. Total Revenues (Add lines 4 through 7)",{"$f":"SUM(C14:C16)","v":0},{"$f":"SUM(D14:D16)","v":0}]
[]
[null,"Expenses"]
[null,"8. Administrative & Marketing (Except mgmt fees )"]
[null,"9. Allowable Management Fees"]
[null,"10. Maintenance & Operating"]
[null,"11. Utilities"]
[null,"12. Property & Liability Insurance"]
[null,"13. Total M&O plus Insurance (add lines 8 through 12)",{"$f":"SUM(C20:C24)","v":0},{"$f":"SUM(D20:D24)","v":0}]
[null,"14. Real Estate Taxes"]
[null,"15. Total Operating Expenses (Line 13 + 14)",{"$f":"SUM(C25:C26)","v":0},{"$f":"SUM(D25:D26)","v":0}]
[null,"16. Net Operating Income (Loss) before debt service or deposits to reserves",{"$f":"C17-C27","v":0},{"$f":"D17-D27","v":0}]
[]
[null,"Financial Expenses"]
[null,"19. Net of withdrawals & deposits to reserves"]
[null,"20. Other Financial Expenses (Explain in notes)"]
[null,"21. Total Financial Expenses (Add lines 19 through 20)",{"$f":"SUM(C31:C32)","v":0},{"$f":"SUM(D31:D32)","v":0}]
[]
[null,"22. Cash Flow (Line 16 minus 21)",{"$f":"C28-C33","v":0},{"$f":"D28-D33","v":0}]
[]
[null,"23. Year End Account Payables"]
[null,"24. Year End Account Receivables"]

{"sheet":"FD  Budget","index":3,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,5,3,10],[2,5,2,10],[1,5,1,10],[0,0,0,1],[27,5,27,12],[26,5,26,12],[25,5,25,12],[24,5,24,12],[9,5,9,12],[10,5,10,12],[11,5,11,12],[23,5,23,12],[22,5,22,12],[21,5,21,12],[20,5,20,12],[12,5,12,12],[13,5,13,12],[14,5,14,12],[6,5,6,12],[7,5,7,12],[8,5,8,12],[18,5,18,12],[19,5,19,12],[15,5,15,12],[16,5,16,12],[17,5,17,12]]}
["FRONT DESK BUDGET"]
["Property Name",{"$f":"OS_GrantRenewalInfo_ProjectName","v":0},null,null,null,"Enter the Fiscal Year End date for the property on the Information tab. "]
["D Number",{"$f":"OS_GrantRenewalInfo_DevelopmentNumber","v":" "},null,null,null,"Do Not include the operating subsidy grant amount in the revenues section. That "]
["Fiscal Year End Date",{"$f":"OS_GrantRenewalInfo_PropertyFiscalYearEndDate","v":"00:00:00"},null,null,null,"will be calculated based on line 40."]
[]
["Revenues"]
["Source","Description","Actual Revenues for completed year","Budget for next year",null,"INCLUDE ALL REVENUES FOR THE FRONT DESK  \n\nNotes"]
[]
[]
[]
[]
[]
[]
[]
["TOTAL REVENUE",null,{"$f":"SUM(C8:C14)","v":0},{"$f":"SUM(D8:D14)","v":0}]
[]
["Expenses"]
["Type","Description- must include % FTE for Staff","Actual Expenses for completed year","Budget for next year",null,"INCLUDE ALL EXPENSES FOR THE FRONT DESK\n\nNotes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL EXPENSES",null,{"$f":"SUM(C19:C37)","v":0},{"$f":"SUM(D19:D37)","v":0}]
[]
["Operating Subsidy Need",null,{"$f":"C15-C38","v":0},{"$f":"D15-D38","v":0}]

{"sheet":"Names","index":4,"n_rows":301,"n_cols":2,"rows_kept":301,"cut":false,"hidden":true,"merged":[]}
["Name","Sheet"]
["grantMgmt","Contact Info"]
["grantMgmtAddr","Contact Info"]
["grantMgmtCity","Contact Info"]
["grantMgmtContact","Contact Info"]
["grantMgmtEmail","Contact Info"]
["grantMgmtPhone","Contact Info"]
["grantMgmtState","Contact Info"]
["grantMgmtZip","Contact Info"]
["hmis","Contact Info"]
["hmisAddr","Contact Info"]
["hmisCity","Contact Info"]
["hmisContact","Contact Info"]
["hmisEmail","Contact Info"]
["hmisPhone","Contact Info"]
["hmisState","Contact Info"]
["hmisZip","Contact Info"]
["mhis","Contact Info"]
["mhisAddr","Contact Info"]
["mhisCity","Contact Info"]
["mhisContact","Contact Info"]
["mhisEmail","Contact Info"]
["mhisPhone","Contact Info"]
["mhisState","Contact Info"]
["mhisZip","Contact Info"]
["ownAddr","Contact Info"]
["ownCity","Contact Info"]
["ownContact","Contact Info"]
["ownEmail","Contact Info"]
["owner","Contact Info"]
["ownPhone","Contact Info"]
["ownState","Contact Info"]
["ownZip","Contact Info"]
["propMgr","Contact Info"]
["propMgrAddr","Contact Info"]
["propMgrCity","Contact Info"]
["propMgrContact","Contact Info"]
["propMgrEmail","Contact Info"]
["propMgrPhone","Contact Info"]
["propMgrState","Contact Info"]
["propMgrZip","Contact Info"]
["servProv","Contact Info"]
["servProvAddr","Contact Info"]
["servProvCity","Contact Info"]
["servProvContact","Contact Info"]
["servProvEmail","Contact Info"]
["servProvPhone","Contact Info"]
["servProvState","Contact Info"]
["servProvZip","Contact Info"]
["DateSign_FD","FD and TSC Budget"]
["Desc1","FD and TSC Budget"]
["Desc2","FD and TSC Budget"]
["Desc3","FD and TSC Budget"]
["Desc4","FD and TSC Budget"]
["Desc5","FD and TSC Budget"]
["Desc6","FD and TSC Budget"]
["Desc7","FD and TSC Budget"]
["ExpDesc1","FD and TSC Budget"]
["ExpDesc10","FD and TSC Budget"]
["ExpDesc11","FD and TSC Budget"]
["ExpDesc12","FD and TSC Budget"]
["ExpDesc13","FD and TSC Budget"]
["ExpDesc14","FD and TSC Budget"]
["ExpDesc15","FD and TSC Budget"]
["ExpDesc16","FD and TSC Budget"]
["ExpDesc17","FD and TSC Budget"]
["ExpDesc18","FD and TSC Budget"]
["ExpDesc19","FD and TSC Budget"]
["ExpDesc2","FD and TSC Budget"]
["ExpDesc3","FD and TSC Budget"]
["ExpDesc4","FD and TSC Budget"]
["ExpDesc5","FD and TSC Budget"]
["ExpDesc6","FD and TSC Budget"]
["ExpDesc7","FD and TSC Budget"]
["ExpDesc8","FD and TSC Budget"]
["ExpDesc9","FD and TSC Budget"]
["ExpLY1","FD and TSC Budget"]
["ExpLY10","FD and TSC Budget"]
["ExpLY11","FD and TSC Budget"]
["ExpLY12","FD and TSC Budget"]
["ExpLY13","FD and TSC Budget"]
["ExpLY14","FD and TSC Budget"]
["ExpLY15","FD and TSC Budget"]
["ExpLY16","FD and TSC Budget"]
["ExpLY17","FD and TSC Budget"]
["ExpLY18","FD and TSC Budget"]
["ExpLY19","FD and TSC Budget"]
["ExpLY2","FD and TSC Budget"]
["ExpLY3","FD and TSC Budget"]
["ExpLY4","FD and TSC Budget"]
["ExpLY5","FD and TSC Budget"]
["ExpLY6","FD and TSC Budget"]
["ExpLY7","FD and TSC Budget"]
["ExpLY8","FD and TSC Budget"]
["ExpLY9","FD and TSC Budget"]
["ExpPurp1","FD and TSC Budget"]
["ExpPurp10","FD and TSC Budget"]
["ExpPurp11","FD and TSC Budget"]
["ExpPurp12","FD and TSC Budget"]
["ExpPurp13","FD and TSC Budget"]
["ExpPurp14","FD and TSC Budget"]
["ExpPurp15","FD and TSC Budget"]
["ExpPurp16","FD and TSC Budget"]
["ExpPurp17","FD and TSC Budget"]
["ExpPurp18","FD and TSC Budget"]
["ExpPurp19","FD and TSC Budget"]
["ExpPurp2","FD and TSC Budget"]
["ExpPurp3","FD and TSC Budget"]
["ExpPurp4","FD and TSC Budget"]
["ExpPurp5","FD and TSC Budget"]
["ExpPurp6","FD and TSC Budget"]
["ExpPurp7","FD and TSC Budget"]
["ExpPurp8","FD and TSC Budget"]
["ExpPurp9","FD and TSC Budget"]
["ExpTY1","FD and TSC Budget"]
["ExpTY10","FD and TSC Budget"]
["ExpTY11","FD and TSC Budget"]
["ExpTY12","FD and TSC Budget"]
["ExpTY13","FD and TSC Budget"]
["ExpTY14","FD and TSC Budget"]
["ExpTY15","FD and TSC Budget"]
["ExpTY16","FD and TSC Budget"]
["ExpTY17","FD and TSC Budget"]
["ExpTY18","FD and TSC Budget"]
["ExpTY19","FD and TSC Budget"]
["ExpTY2","FD and TSC Budget"]
["ExpTY3","FD and TSC Budget"]
["ExpTY4","FD and TSC Budget"]
["ExpTY5","FD and TSC Budget"]
["ExpTY6","FD and TSC Budget"]
["ExpTY7","FD and TSC Budget"]
["ExpTY8","FD and TSC Budget"]
["ExpTY9","FD and TSC Budget"]
["ExpType1","FD and TSC Budget"]
["ExpType10","FD and TSC Budget"]
["ExpType11","FD and TSC Budget"]
["ExpType12","FD and TSC Budget"]
["ExpType13","FD and TSC Budget"]
["ExpType14","FD and TSC Budget"]
["ExpType15","FD and TSC Budget"]
["ExpType16","FD and TSC Budget"]
["ExpType17","FD and TSC Budget"]
["ExpType18","FD and TSC Budget"]
["ExpType19","FD and TSC Budget"]
["ExpType2","FD and TSC Budget"]
["ExpType3","FD and TSC Budget"]
["ExpType4","FD and TSC Budget"]
["ExpType5","FD and TSC Budget"]
["ExpType6","FD and TSC Budget"]
["ExpType7","FD and TSC Budget"]
["ExpType8","FD and TSC Budget"]
["ExpType9","FD and TSC Budget"]
["FD_MOS","FD and TSC Budget"]
["FiscalYearEnd","FD and TSC Budget"]
["LY_1","FD and TSC Budget"]
["LY_2","FD and TSC Budget"]
["LY_3","FD and TSC Budget"]
["LY_4","FD and TSC Budget"]
["LY_5","FD and TSC Budget"]
["LY_6","FD and TSC Budget"]
["LY_7","FD and TSC Budget"]
["OwnerSign_FD","FD and TSC Budget"]
["Purpose1","FD and TSC Budget"]
["Purpose2","FD and TSC Budget"]
["Purpose3","FD and TSC Budget"]
["Purpose4","FD and TSC Budget"]
["Purpose5","FD and TSC Budget"]
["Purpose6","FD and TSC Budget"]
["Purpose7","FD and TSC Budget"]
["SCNotes1","FD and TSC Budget"]
["SCNotes10","FD and TSC Budget"]
["SCNotes11","FD and TSC Budget"]
["SCNotes12","FD and TSC Budget"]
["SCNotes13","FD and TSC Budget"]
["SCNotes14","FD and TSC Budget"]
["SCNotes15","FD and TSC Budget"]
["SCNotes16","FD and TSC Budget"]
["SCNotes17","FD and TSC Budget"]
["SCNotes18","FD and TSC Budget"]
["SCNotes19","FD and TSC Budget"]
["SCNotes2","FD and TSC Budget"]
["SCNotes20","FD and TSC Budget"]
["SCNotes21","FD and TSC Budget"]
["SCNotes3","FD and TSC Budget"]
["SCNotes4","FD and TSC Budget"]
["SCNotes5","FD and TSC Budget"]
["SCNotes6","FD and TSC Budget"]
["SCNotes7","FD and TSC Budget"]
["SCNotes8","FD and TSC Budget"]
["SCNotes9","FD and TSC Budget"]
["SCPropertyName","FD and TSC Budget"]
["SCPropertyNumber","FD and TSC Budget"]
["Source1","FD and TSC Budget"]
["Source2","FD and TSC Budget"]
["Source3","FD and TSC Budget"]
["Source4","FD and TSC Budget"]
["Source5","FD and TSC Budget"]
["Source6","FD and TSC Budget"]
["Source7","FD and TSC Budget"]
["TY_1","FD and TSC Budget"]
["TY_2","FD and TSC Budget"]
["TY_3","FD and TSC Budget"]
["TY_4","FD and TSC Budget"]
["TY_5","FD and TSC Budget"]
["TY_6","FD and TSC Budget"]
["TY_7","FD and TSC Budget"]
["appDate","Grant Renewal Info"]
["applicant","Grant Renewal Info"]
["city","Grant Renewal Info"]
["county","Grant Renewal Info"]
["fdAmount","Grant Renewal Info"]
["FrontDesk","Grant Renewal Info"]
["grantAmt","Grant Renewal Info"]
["hhType","Grant Renewal Info"]
["LTHUnits","Grant Renewal Info"]
["numSHunits","Grant Renewal Info"]
["projName","Grant Renewal Info"]
["Revenue","Grant Renewal Info"]
["rsfAmount","Grant Renewal Info"]
["smiUnits","Grant Renewal Info"]
["Tenant","Grant Renewal Info"]
["tscAmount","Grant Renewal Info"]
["DateSign","RSF Budget"]
["FiscalYE","RSF Budget"]
["LY_AdminMarketing","RSF Budget"]
["LY_Insurance","RSF Budget"]
["LY_InterestIncome","RSF Budget"]
["LY_LTHUnits","RSF Budget"]
["LY_MaintOper","RSF Budget"]
["LY_MgmntFee","RSF Budget"]
["LY_MortInterest","RSF Budget"]
["LY_MortPrincipal","RSF Budget"]
["LY_NetReserveActivity","RSF Budget"]
["LY_OperatingSubsidy","RSF Budget"]
["LY_OtherFinExp","RSF Budget"]
["LY_OtherIncome","RSF Budget"]
["LY_RentalSubsidy","RSF Budget"]
["LY_ReserveBal","RSF Budget"]
["LY_ReserveDeposits","RSF Budget"]
["LY_RETaxes","RSF Budget"]
["LY_SMIUnits","RSF Budget"]
["LY_TenantRents","RSF Budget"]
["LY_Utilities","RSF Budget"]
["LY_VacancyLoss","RSF Budget"]
["LY_VacantUnits","RSF Budget"]
["OSMOS","RSF Budget"]
["OSNotes1","RSF Budget"]
["OSNotes10","RSF Budget"]
["OSNotes11","RSF Budget"]
["OSNotes12","RSF Budget"]
["OSNotes13","RSF Budget"]
["OSNotes14","RSF Budget"]
["OSNotes15","RSF Budget"]
["OSNotes16","RSF Budget"]
["OSNotes17","RSF Budget"]
["OSNotes18","RSF Budget"]
["OSNotes19","RSF Budget"]
["OSNotes2","RSF Budget"]
["OSNotes20","RSF Budget"]
["OSNotes21","RSF Budget"]
["OSNotes22","RSF Budget"]
["OSNotes23","RSF Budget"]
["OSNotes24","RSF Budget"]
["OSNotes25","RSF Budget"]
["OSNotes26","RSF Budget"]
["OSNotes27","RSF Budget"]
["OSNotes28","RSF Budget"]
["OSNotes29","RSF Budget"]
["OSNotes3","RSF Budget"]
["OSNotes30","RSF Budget"]
["OSNotes4","RSF Budget"]
["OSNotes5","RSF Budget"]
["OSNotes6","RSF Budget"]
["OSNotes7","RSF Budget"]
["OSNotes8","RSF Budget"]
["OSNotes9","RSF Budget"]
["OSPropertyName","RSF Budget"]
["OSPropertyNumber","RSF Budget"]
["OwnerSign","RSF Budget"]
["TotalUnits","RSF Budget"]
["TY_AdminMarketing","RSF Budget"]
["TY_Insurance","RSF Budget"]
["TY_InterestIncome","RSF Budget"]
["TY_LTHUnits","RSF Budget"]
["TY_MaintOper","RSF Budget"]
["TY_MgmntFee","RSF Budget"]
["TY_MortInterest","RSF Budget"]
["TY_MortPrincipal","RSF Budget"]
["TY_NetReserveActivity","RSF Budget"]
["TY_OperatingSubsidy","RSF Budget"]
["TY_OtherFinExp","RSF Budget"]
["TY_OtherIncome","RSF Budget"]
["TY_RentalSubsidy","RSF Budget"]
["TY_ReserveBal","RSF Budget"]
["TY_ReserveDeposits","RSF Budget"]
["TY_RETaxes","RSF Budget"]
["TY_SMIUnits","RSF Budget"]
["TY_TenantRents","RSF Budget"]
["TY_Utilities","RSF Budget"]
["TY_VacancyLoss","RSF Budget"]
["TY_VacantUnits","RSF Budget"]

{"sheet":" TSC Budget ","index":5,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[23,5,23,12],[24,5,24,12],[25,5,25,12],[26,5,26,12],[27,5,27,12],[22,5,22,12],[11,5,11,12],[12,5,12,12],[13,5,13,12],[14,5,14,12],[15,5,15,12],[16,5,16,12],[17,5,17,12],[18,5,18,12],[19,5,19,12],[20,5,20,12],[21,5,21,12],[10,5,10,12],[0,0,0,1],[6,5,6,12],[7,5,7,12],[8,5,8,12],[9,5,9,12],[1,5,1,10],[2,5,2,10],[3,5,3,10]]}
["TENANT SERVICE COORDINATOR"]
["Property Name",{"$f":"OS_GrantRenewalInfo_ProjectName","v":0},null,null,null,"Enter the Fiscal Year End date for the property for the recently completed fiscal year on the Information tab. "]
[" D Number",{"$f":"OS_GrantRenewalInfo_DevelopmentNumber","v":" "},null,null,null,"Do Not include the operating subsidy grant amount in the revenues section. That "]
["Fiscal Year End Date",{"$f":"OS_GrantRenewalInfo_PropertyFiscalYearEndDate","v":"00:00:00"},null,null,null,"will be calculated based on line 40."]
[]
["Revenues"]
["Source","Description","Actual Revenues for completed year","Budget for next year",null,"INCLUDE ALL REVENUES FOR SERVICES \n\nNotes"]
[]
[]
[]
[]
[]
[]
[]
["TOTAL REVENUE",null,{"$f":"SUM(C8:C14)","v":0},{"$f":"SUM(D8:D14)","v":0}]
[]
["Expenses",null,{"$f":"C6","v":0},{"$f":"D6","v":0}]
["Type","Description- must include % FTE for Staff","Actual Expenses for completed year","Budget for next year",null,"INCLUDE ALL EXPENSES FOR SERVICES \n\nNotes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL EXPENSES",null,{"$f":"SUM(C19:C37)","v":0},{"$f":"SUM(D19:D37)","v":0}]
[]
["Operating Subsidy Need",null,{"$f":"C15-C38","v":0},{"$f":"D15-D38","v":0}]

{"sheet":"Sheet1","index":6,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
["Dev#",null,"Dev#",null,"HH Types",null,null,"revenue",false,null,null,null,"Expenses","Sources"]
["D0430","2001 W 3rd St. LLC","D0430",null,"Families",null,null,null,null,null,null,null,"Staff costs/wages, benefits","Federal"]
["D3173","2011 Pillsbury Residence","D3173",null,"Singles",null,null,"frontdesk",false,null,null,null,"Equipment","State"]
["D6350","3631 Penn","D6350",null,"Youth-singles",null,null,null,null,null,null,null,"Supplies","GRH"]
["D2475","Kimball Court","D2475",null,"Youth-families",null,null,null,null,null,null,null,"Space cost","Medicaid Billing"]
["D3845","Alicias Place","D3845",null,null,null,null,null,null,null,null,null,"Transportation","Philanthropic"]
["D3192","American House Apartments","D3192",null,null,null,null,null,null,null,null,null,"Training","Fund Raising"]
["D3912","Anpa Waste Numpa","D3912",null,null,null,null,"tenant",false,null,null,null,"Other","Other"]
["D3866","Belle Haven Townhomes","D3866"]
[]
["D4045","Castleview Apartments","D4045"]
["D3871","Country View","D3871"]
["D3065","Dale Street Place ","D3065"]
["D1591","Delancey and Selby Stone Apartments","D1591"]
["D3890","DreamCatcher Homes","D3890"]
["D5954","Fond du Lac Supportive Housing","D5954"]
["D6730","Fond du Lac Veterans Supportive Housing","D6730"]
["D6256","Fort Road Flats","D6256"]
["D6252","Gateway Gardens","D6252"]
["D7535","Giwanakimin","D7535"]
["D5957","Higher Ground -Mpls","D5957"]
["D6723","Hillside Apartments","D6723"]
["D2355","HOPE Harbor","D2355"]
["D4056","HOPE on Ninth","D4056"]
["D2939","Jackson Street Village","D2939"]
["D1194","Jordan Tower II","D1194"]
["D5229","Lexington Commons Apts","D5229"]
["D5886","Lincoln Place","D5886"]
["D3124","Lindquist Apartments","D3124"]
["D1504","Louisiana Court Apartments","D1504"]
["D3844","Maxfield Place","D3844"]
["D0447","Memorial  Park Apartments","D0447"]
["D6357","New Moon (fka Oshki-agooajin)","D6357"]
["D5909","Nicollet Square","D5909"]
["D5197","North Shore Horizons ","D5197"]
["D0959","Opportunity Housing Limited Partnership","D0959"]
["D3797","Perpich Apartments Limited Partnership","D3797"]
["D5896","PPL Re-Start / North Side Community LP","D5896"]
["D5200","River Crest Apartments","D5200"]
["D5225","Sankofa Apartments","D5225"]
["D6347","Silver Creek Corner","D6347"]
["D3151","St. Christopher Place","D3151"]
["D4075","The Francis ","D4075"]
["D4076","The Salvation Army Booth Brown House","D4076"]
["D6374","Youngdahl Living","D6374"]
["D5216","LSS Park Avenue Apartments","D5216"]
["D5905","Alliance Scattered Site Rehab","D5905"]
["D5894","Youth Foyer Project (Virginia)","D5894"]
["D5956","Conifer Estates","D5956"]
["D5906","Penn Avenue Apartments","D5906"]
["D3052","Grotto Place","D3052"]