{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Financial Input Sheet","Stmt of Operations--HM 6-50","Surplus Cash--HM 6-51A","Adjusted Cash Flow--HM 6-51B","Computation of NOI--HM 6-52","DOH Congregate"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Financial Input Sheet","index":0,"n_rows":477,"n_cols":12,"rows_kept":477,"cut":false,"hidden":false,"merged":[[278,3,278,4],[416,6,416,8],[434,2,434,3],[434,6,434,8],[282,7,282,8],[283,7,283,8],[316,3,316,4],[317,3,317,4],[281,3,281,4],[294,3,294,4],[287,3,287,4],[289,3,289,4],[300,3,300,4],[301,3,301,4],[303,3,303,4],[304,3,304,4],[288,3,288,4],[299,3,299,4],[295,3,295,4],[290,3,290,4],[328,3,328,4],[336,3,336,4],[318,3,318,4],[339,1,339,6],[298,3,298,4],[279,3,279,4],[285,3,285,4],[280,3,280,4],[282,3,282,4],[283,3,283,4],[291,3,291,4],[292,3,292,4],[293,3,293,4],[329,3,329,4],[330,3,330,4],[325,3,325,4],[327,3,327,4],[302,3,302,4],[284,7,284,8],[285,7,285,8],[286,7,286,8],[287,7,287,8],[288,7,288,8],[289,7,289,8],[290,7,290,8],[291,7,291,8],[292,7,292,8],[284,3,284,4],[321,3,321,4],[322,3,322,4],[323,3,323,4],[320,7,320,8],[315,3,315,4],[315,7,315,8],[314,3,314,4],[286,3,286,4],[297,3,297,4],[313,3,313,4],[294,7,294,8],[415,9,415,13],[76,7,76,8],[77,7,77,8],[80,7,80,8],[81,7,81,8],[82,7,82,8],[329,7,329,8],[330,7,330,8],[331,7,331,8],[321,7,321,8],[322,7,322,8],[325,7,325,8],[326,7,326,8],[327,7,327,8],[328,7,328,8],[310,7,310,8],[276,7,276,8],[277,7,277,8],[313,7,313,8],[311,0,311,7],[314,7,314,8],[316,7,316,8],[317,7,317,8],[318,7,318,8],[449,7,449,8],[439,6,439,8],[415,6,415,8],[417,6,417,8],[418,6,418,8],[419,6,419,8],[420,6,420,8],[390,0,390,7],[427,6,427,8],[409,6,409,8],[410,6,410,8],[411,6,411,8],[409,1,409,3],[410,1,410,3],[411,1,411,3],[423,6,423,8],[426,6,426,8],[428,6,428,8],[430,6,430,8],[380,7,380,8],[373,7,373,8],[374,7,374,8],[379,3,379,4],[377,7,377,8],[378,7,378,8],[379,7,379,8],[377,3,377,4],[429,6,429,8],[421,6,421,8],[399,2,399,3],[397,2,397,3],[399,5,399,7],[384,7,384,8],[385,7,385,8],[386,7,386,8],[395,2,395,3],[386,3,386,4],[387,1,387,6],[388,1,388,6],[389,1,389,6],[381,7,381,8],[382,7,382,8],[383,3,383,4],[382,3,382,4],[391,5,391,7],[392,5,392,7],[476,7,476,8],[474,7,474,8],[470,7,470,8],[433,6,433,8],[435,6,435,8],[436,6,436,8],[437,6,437,8],[438,6,438,8],[383,7,383,8],[403,6,403,8],[404,6,404,8],[405,6,405,8],[406,6,406,8],[457,7,457,8],[455,7,455,8],[453,7,453,8],[451,7,451,8],[471,7,471,8],[467,7,467,8],[461,7,461,8],[462,7,462,8],[463,7,463,8],[464,7,464,8],[422,6,422,8],[362,7,362,8],[381,3,381,4],[375,3,375,4],[366,3,366,4],[367,3,367,4],[373,3,373,4],[374,3,374,4],[366,7,366,8],[367,7,367,8],[368,7,368,8],[363,3,363,4],[364,3,364,4],[370,3,370,4],[363,7,363,8],[364,7,364,8],[365,7,365,8],[368,3,368,4],[365,3,365,4],[378,3,378,4],[376,3,376,4],[380,3,380,4],[369,3,369,4],[375,7,375,8],[376,7,376,8],[334,7,334,8],[332,3,332,4],[356,7,356,8],[357,7,357,8],[358,7,358,8],[359,7,359,8],[360,7,360,8],[361,7,361,8],[361,3,361,4],[336,7,336,8],[350,7,350,8],[335,3,335,4],[333,3,333,4],[334,3,334,4],[353,7,353,8],[360,3,360,4],[332,7,332,8],[335,7,335,8],[369,7,369,8],[370,7,370,8],[371,7,371,8],[372,7,372,8],[319,3,319,4],[320,3,320,4],[337,1,337,6],[338,1,338,6],[362,3,362,4],[352,3,352,4],[355,3,355,4],[355,7,355,8],[353,3,353,4],[354,3,354,4],[354,7,354,8],[351,7,351,8],[352,7,352,8],[323,7,323,8],[324,7,324,8],[357,3,357,4],[358,3,358,4],[359,3,359,4],[319,7,319,8],[333,7,333,8],[273,7,273,8],[274,7,274,8],[275,7,275,8],[310,3,310,4],[295,7,295,8],[296,7,296,8],[297,7,297,8],[298,7,298,8],[299,7,299,8],[300,7,300,8],[301,7,301,8],[302,7,302,8],[303,7,303,8],[304,7,304,8],[305,7,305,8],[309,3,309,4],[306,3,306,4],[306,7,306,8],[309,7,309,8],[307,7,307,8],[308,7,308,8],[293,7,293,8],[305,3,305,4],[296,3,296,4],[279,7,279,8],[278,7,278,8],[280,7,280,8],[281,7,281,8],[242,7,242,8],[243,7,243,8],[237,7,237,8],[250,7,250,8],[239,7,239,8],[240,7,240,8],[247,7,247,8],[248,7,248,8],[249,7,249,8],[262,7,262,8],[263,7,263,8],[264,7,264,8],[265,7,265,8],[266,7,266,8],[267,7,267,8],[268,7,268,8],[269,7,269,8],[270,7,270,8],[271,7,271,8],[272,7,272,8],[230,7,230,8],[231,7,231,8],[232,7,232,8],[233,7,233,8],[234,7,234,8],[235,7,235,8],[236,7,236,8],[238,7,238,8],[241,7,241,8],[221,7,221,8],[222,7,222,8],[223,7,223,8],[224,7,224,8],[225,7,225,8],[226,7,226,8],[227,7,227,8],[228,7,228,8],[229,7,229,8],[215,7,215,8],[216,7,216,8],[217,7,217,8],[218,7,218,8],[219,7,219,8],[220,7,220,8],[209,7,209,8],[210,7,210,8],[211,7,211,8],[212,7,212,8],[277,3,277,4],[236,3,236,4],[219,3,219,4],[215,3,215,4],[225,3,225,4],[226,3,226,4],[227,3,227,4],[228,3,228,4],[229,3,229,4],[220,3,220,4],[221,3,221,4],[222,3,222,4],[223,3,223,4],[224,3,224,4],[230,3,230,4],[265,3,265,4],[263,3,263,4],[238,3,238,4],[241,3,241,4],[257,3,257,4],[216,3,216,4],[217,3,217,4],[218,3,218,4],[258,3,258,4],[214,3,214,4],[143,3,143,4],[147,3,147,4],[151,3,151,4],[152,3,152,4],[157,3,157,4],[173,3,173,4],[163,3,163,4],[184,1,184,6],[185,1,185,6],[148,0,148,7],[170,3,170,4],[171,3,171,4],[172,3,172,4],[182,3,182,4],[186,0,186,7],[206,7,206,8],[207,7,207,8],[169,3,169,4],[208,7,208,8],[213,7,213,8],[205,7,205,8],[214,7,214,8],[191,5,191,7],[123,3,123,4],[175,3,175,4],[176,3,176,4],[178,3,178,4],[183,3,183,4],[140,3,140,4],[70,7,70,8],[71,7,71,8],[72,7,72,8],[73,7,73,8],[119,3,119,4],[120,3,120,4],[121,3,121,4],[94,3,94,4],[104,3,104,4],[111,3,111,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[109,3,109,4],[110,3,110,4],[212,3,212,4],[213,3,213,4],[207,3,207,4],[208,3,208,4],[209,3,209,4],[206,3,206,4],[210,3,210,4],[211,3,211,4],[204,7,204,8],[48,7,48,8],[63,7,63,8],[64,7,64,8],[191,2,191,3],[204,3,204,4],[84,0,84,7],[154,3,154,4],[168,3,168,4],[138,3,138,4],[155,3,155,4],[130,3,130,4],[203,3,203,4],[118,3,118,4],[126,3,126,4],[127,3,127,4],[135,3,135,4],[195,2,195,3],[193,2,193,3],[195,5,195,7],[193,5,193,7],[96,3,96,4],[98,3,98,4],[97,3,97,4],[122,3,122,4],[57,3,57,4],[53,3,53,4],[54,3,54,4],[68,3,68,4],[79,3,79,4],[87,3,87,4],[91,3,91,4],[73,3,73,4],[62,3,62,4],[21,7,21,8],[133,3,133,4],[139,3,139,4],[153,3,153,4],[136,3,136,4],[137,3,137,4],[128,3,128,4],[124,3,124,4],[131,3,131,4],[132,3,132,4],[74,7,74,8],[75,7,75,8],[78,7,78,8],[79,7,79,8],[83,7,83,8],[66,7,66,8],[67,7,67,8],[68,7,68,8],[69,7,69,8],[134,3,134,4],[117,3,117,4],[44,7,44,8],[45,7,45,8],[56,3,56,4],[0,5,0,7],[1,5,1,7],[83,3,83,4],[66,3,66,4],[67,3,67,4],[76,3,76,4],[69,3,69,4],[77,3,77,4],[78,3,78,4],[13,7,13,8],[37,7,37,8],[38,7,38,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[22,7,22,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[15,3,15,4],[17,3,17,4],[187,5,187,7],[188,5,188,7],[16,3,16,4],[72,3,72,4],[112,3,112,4],[158,3,158,4],[160,3,160,4],[156,3,156,4],[164,3,164,4],[165,3,165,4],[166,3,166,4],[162,3,162,4],[49,7,49,8],[50,7,50,8],[52,7,52,8],[57,7,57,8],[58,7,58,8],[59,7,59,8],[60,7,60,8],[61,7,61,8],[65,7,65,8],[27,7,27,8],[55,7,55,8],[62,7,62,8],[174,3,174,4],[8,2,8,3],[159,3,159,4],[161,3,161,4],[6,2,6,3],[4,2,4,3],[8,5,8,7],[116,3,116,4],[95,3,95,4],[51,7,51,8],[53,7,53,8],[54,7,54,8],[56,7,56,8],[47,3,47,4],[64,3,64,4],[65,3,65,4],[60,3,60,4],[63,3,63,4],[51,3,51,4],[52,3,52,4],[61,3,61,4],[11,2,11,3],[14,3,14,4],[259,3,259,4],[249,3,249,4],[253,3,253,4],[248,3,248,4],[245,0,245,7],[244,7,244,8],[260,3,260,4],[261,3,261,4],[251,7,251,8],[252,7,252,8],[253,7,253,8],[254,7,254,8],[255,7,255,8],[256,7,256,8],[257,7,257,8],[258,7,258,8],[259,7,259,8],[260,7,260,8],[261,7,261,8],[250,3,250,4],[251,3,251,4],[252,3,252,4],[256,3,256,4],[268,3,268,4],[274,3,274,4],[231,3,231,4],[255,3,255,4],[262,3,262,4],[242,3,242,4],[269,3,269,4],[270,3,270,4],[271,3,271,4],[272,3,272,4],[273,3,273,4],[232,3,232,4],[237,3,237,4],[243,3,243,4],[244,3,244,4],[247,3,247,4],[264,3,264,4],[266,3,266,4],[267,3,267,4],[254,3,254,4],[233,3,233,4],[234,3,234,4],[18,3,18,4],[26,3,26,4],[30,3,30,4],[40,3,40,4],[34,3,34,4],[43,3,43,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[32,3,32,4],[31,3,31,4],[23,3,23,4],[24,3,24,4],[34,7,34,8],[35,7,35,8],[36,7,36,8],[25,7,25,8],[26,7,26,8],[33,7,33,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[46,7,46,8],[47,7,47,8],[39,7,39,8],[31,7,31,8],[32,7,32,8],[12,3,12,4],[100,3,100,4],[102,3,102,4],[103,3,103,4],[101,3,101,4],[13,3,13,4],[99,3,99,4],[46,3,46,4],[74,3,74,4],[75,3,75,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[85,7,86,7],[23,7,23,8],[24,7,24,8],[44,3,44,4],[45,3,45,4],[42,3,42,4],[397,5,397,7],[395,5,395,7],[88,3,88,4],[89,3,89,4],[90,3,90,4],[92,3,92,4],[93,3,93,4],[129,3,129,4],[150,3,150,4],[167,3,167,4],[275,3,275,4],[349,3,349,4],[384,3,384,4],[385,3,385,4],[371,3,371,4],[372,3,372,4],[356,3,356,4],[350,3,350,4],[351,3,351,4],[235,3,235,4],[331,3,331,4],[324,3,324,4],[326,3,326,4],[276,3,276,4],[476,1,476,4],[461,1,461,4],[462,1,462,4],[449,1,449,4],[419,2,419,3],[420,2,420,3],[418,2,418,3],[406,2,406,3],[415,2,415,3],[417,2,417,3],[415,1,418,1],[419,1,423,1],[435,1,437,1],[439,2,439,3],[436,2,436,3],[455,1,455,4],[457,1,457,4],[433,2,433,3],[435,2,435,3],[474,1,474,4],[470,1,470,4],[471,1,471,4],[451,1,451,4],[453,1,453,4],[2,1,2,4],[469,1,469,4],[437,2,437,3],[438,2,438,3],[421,2,421,3],[422,2,422,3],[423,2,423,3],[463,1,463,4],[464,1,464,4],[403,2,403,3],[404,2,404,3],[405,2,405,3],[467,1,467,4],[426,2,426,3],[427,2,427,3],[428,2,428,3],[429,2,429,3],[426,1,427,1],[430,2,430,3],[416,2,416,3],[105,3,105,4],[41,3,41,4],[25,3,25,4],[33,3,33,4]]}
[null,"BALANCE SHEET INPUT SECTION",null,null,null,"Connecticut Housing Finance Authority",null,null,null,null,null,"CHANGES"]
[null,null,null,null,null,"Asset Management - Multifamily Housing"]
[null,"Note:  Insertions, revisions and/or updates have been highlighted in yellow and/or appear in red lettering.  See Changes Column.",null,null,null,null,null,"Rev. 12/2022 -- Effective FYE 12/31/2022",null,null,null,"Updated Rev. and FYE dates"]
[null,null,null,null,null,null,null,null,null,"Yes"]
[null,"Project Name:",null,null,"Fiscal Year-End:",null,null,null,null,"No",null,"Updated format of date appearance (e.g. December 31, 2022)"]
[]
[null,"CHFA Number:",null,null,"Beginning Date:",null,"Number of Units:"]
[null,null,null,null,null,null,null,null,null,"Yes"]
[null,"HUD Number:",null,null,"Mortgagor:",null,null,null,null,"No"]
[null," ",null," ",null,null,null,null,null,"N/A"]
[]
[null,null,"Assets"]
[null,"SSHP Acct. #","HUD/CHFA Acct. #","Description",null,"Amount"]
[null,1117,1110,"Petty Cash Fund",null,0]
[null,1111,1120,"Cash - Operations",null,0]
[null,null,1121,"Construction Cash Account",null,0]
[null,1113,1123,"Reserve Cash - Saving and Investments",null,0]
[null,null,1125,"Cash - Entity",null,0]
[null,1122,1130,"Tenant Members A/R",null,0]
[null,1123,1130.0999999999999,"Vacated Tenants' A/R",null,0]
[null,1123.0999999999999,1131,"Allowance for Doubtful Accounts",null,0]
[null,null,"1030N","Net Tenant A/R",null,null,{"$f":"SUM(F19:F20)-F21","v":0}]
[null,1125,1135,"A/R - HUD",null,0]
[null,null,1132,"RAP Subsidy Receivable",null,0]
[null,null,1133,"ERAP Subsidy Receivable",null,0]
[null,null,1134,"RSC Subsidy Receivable",null,0]
[null,1139,1136,"Congregate Subsidy Receivable",null,0]
[null,1126,1136.0999999999999,"Construction/Rehab Grants Receivable",null,0]
[null,null,1136.2,"RSC Grant Receivable",null,0]
[null,1509,1138,"Rental Assistance Accounts Receivable - Other",null,0]
[null,null,1139,"Capital Improvement Grant Receivable",null,0]
[null,null,1140,"Accts & Notes Receivable - Operations",null,0]
[null,null,1145,"Accts & Notes Receivable Entity",null,0]
[null,1129,1146,"Accts Receivable - Sundry",null,0]
[null,1155,1150,"Advances to Revolving Fund",null,0]
[null,1145,1160,"A/R Interest",null,0]
[null,null,1165,"Interest Reduction Payment Receivables",null,0]
[null,null,1170,"Short Term Investments - Operation",null,0]
[null,null,1175,"Short Term Investments - Entity",null,0]
[null,null,1185,"Allowance for Obsolete Inventory",null,0]
[null,1269,1190,"Misc. Current Assets",null,0]
[null,1156,1200,"Misc. Pre Paid Expenses",null,0]
[null,1211,1201,"Prepaid Insurance",null,0]
[null,null,"1100T","Total Current Assets",null,null,{"$f":"SUM(F14:F18)+G22+SUM(F23:F43)","v":0}]
[null,1114,1191,"Tenant Security Deposits Held in Trust",null,0]
[null,null,null,"Total Deposits Held in Trust",null,null,{"$f":"+F45","v":0}]
[null,1115,1310,"Escrow Deposits",null,0]
[null,null,1320,"Replacement Reserves",null,0]
[null,null,1330,"Other Reserves",null,0]
[null,null,1340,"Residual Receipts Reserve",null,0]
[null,null,1355,"Bond Reserves",null,0]
[null,null,1365,"General Operating Reserves",null,0]
[null,null,1370,"Deposits to Co-ops",null,0]
[null,null,1381,"Mgmt. Improvements & Operating Plan",null,0]
[null,null,"1300T","Total Restricted Deposits",null,null,{"$f":"SUM(F47:F54)","v":0}]
[null,1405.1,1405,"Construction in Progress",null,0]
[null,null,1410,"Land",null,0]
[null,1405,1420,"Buildings",null,0]
[null,1503.1,1425.1,"Capital Improvements Unfinished Rehab Proj., No.",null,0]
[null,1503.2,1425.2,"Capital Improvements Unfinished Rehab Proj., No.",null,0]
[null,null,1440,"Building Equipment",null,0]
[null,1430,1450,"Furniture for Project/Tenant Use",null,0]
[null,null,1460,"Furnishings",null,0]
[null,null,1465,"Office Furniture & Equipment",null,0]
[null,null,1470,"Maintenance Equipment",null,0]
[null,null,1480,"Motor Vehicles",null,0]
[null,null,1490,"Misc. Fixed Assets",null,0]
[null,null,"1400T","Total Fixed Assets",null,null,{"$f":"SUM(F56:F67)","v":0}]
[null,null,1495,"Accumulated Depreciation",null,0]
[null,null,"1400N","Net Fixed Assets",null,null,{"$f":"+G68-F69","v":0}]
[null,1504.1,1504.1,"Net Program Cost Congregate - Contract No.",null,0]
[null,1504.2,1504.2,"Net Program Cost Congregate - Contract No.",null,0]
[null,null,1510,"Investments- Operations",null,0]
[null,null,1515,"Investments- Entity",null,0]
[null,null,1520,"Intangible Assets",null,0]
[null,null,1525,"Cash Restricted for Long Term Investments",null,0]
[null,null,1590,"Misc. Other Assets",null,0]
[null,null,1595,"Net Pension Asset",null,0]
[null,null,1596,"Net Other Post-Employment Benefits Asset",null,0]
[null,null,"1500T","Total Other Assets",null,null,{"$f":"SUM(F71:F79)","v":0}]
[null,null,1600,"Deferred Outflow of Resources - Pension",null,0]
[null,null,1610,"Deferred Outflow of Resources - OPEB",null,0]
[null,null,"1600T","Total Deferred Outflow of Resources",null,null,{"$f":"SUM(F81:F82)","v":0}]
[null,null,"1000T","Total Assets",null,null,{"$f":"+G44+G55+G70+G80+G46+G83","v":0}]
[]
[null,"Balance Sheet Input cont'd",null,null,null,null,null,"To be included in Surplus Cash (N/A for Adjusted Cash Flow)"]
[null,null,"Liabilities"]
[null,null,2105,"Bank Overdraft - Operations",null,0]
[null,null,"2110.a","30 days A/P",null,0]
[null,null,"2110.b","60 days A/P",null,0]
[null,null,"2110.c","90+ days A/P",null,0]
[null,2110,2110,"Accts Payable - Operations",null,null,{"$f":"SUM(F89:F91)","v":0}]
[null,2119,2110.1,"Accts Payable - Sundry",null,0,null,null,null,null,null,"Added yes/no option in Cell H93 for inclusion in surplus cash, if appllicable"]
[null,2112,2110.1999999999998,"Amount Due Revolving Loan Fund",null,0]
[null,null,2111,"Accts Payable - Construction/Development",null,0]
[null,null,2112,"Accts Payable - Project Improvement Items",null,0]
[null,null,2113,"Accts Payable -  Entity",null,0]
[null,2117,2114,"Payroll Deductions",null,0,null,null,null,null,null,"Added yes/no option in cell H98 for inclusion in surplus cash, if applicable"]
[null,null,2115,"Accts Payable - 236 Excess Income Due HUD",null,0]
[null,null,2116,"Accts Payable - Section 8 & Other",null,0]
[null,2135,2120,"Accrued Wages Payable",null,0]
[null,2135.1,2120.1,"Accrued Compensated Absences",null,0]
[null,2139,2121,"Accrued Payroll Taxes Payable",null,0]
[null,null,2123,"Accrued Management Fee Payable",null,0]
[null,null,2130,"Accrued Interest Payable - Section 236",null,0]
[null,2131,2131,"Accrued Interest Payable - First Mortgage or (bonds)",null,0]
[null,null,2132,"Accrued Interest Payable - 2nd Mortgage",null,0]
[null,null,2133,"Accrued Interest Payable - Other Loans and Notes (Surplus Cash)",null,0]
[null,null,2134,"Accrued Interest Payable - Other Loans and Notes",null,0]
[null,null,2135,"Accrued Interest Payable - Flexible Subsidy Loan",null,0]
[null,2131.1,2136,"Accrued Interest Payable - Capital Improvements Loan",null,0]
[null,null,2137,"Accrued Interest Payable - Operating Loss Loan",null,0]
[null,2136,2140,"Accrued State Service Charge",null,0]
[null,2137,2150,"Accrued Property Taxes",null,0]
[null,null,2160,"Notes Payable - Short Term",null,0]
[null,null,2170,"Mortgage Payable - First Mortgage (Short Term)",null,0]
[null,null,2172,"Mortgage Payable - 2nd Mortgage (Short Term)",null,0]
[null,null,2173,"Other Loans & Notes Payable Surplus Cash (Short Term)",null,0]
[null,null,2174,"Other Loans & Notes Payable (Short Term)",null,0]
[null,null,2175,"Flexible Subsidy Loan Payable (Short Term)",null,0]
[null,null,2176,"Capital Improvement Loan Payable (Short Term)",null,0]
[null,null,2177,"Operating Loss Loan Payable (Short Term)",null,0]
[null,null,2180,"Utility Allowances",null,0,null,null,null,null,null,"Added yes/no option in cell H123 for inclusion in surplus cash, if applicable"]
[null,2120,2190,"Misc. Current Liabilities (not escrowed)",null,0]
[null,2240,2210,"Prepaid Revenue",null,0]
[null,null,2220,"Deferred Revenue",null,0]
[null,null,2230,"Deposits to Co-ops",null,0]
[null,null,"2122T","Total Current Liabilities",null,null,{"$f":"SUM(F88:F127)","v":0}]
[null,2116,2191,"Tenant Security Deposits held in Trust (Contra)",null,0]
[null,null,null,"Total Deposit & Prepayment Liabilities ",null,null,{"$f":"+F129","v":0}]
[null,null,2310,"Notes Payable - Long Term",null,0]
[null,null,2311,"Notes Payable - Surplus Cash",null,0]
[null,2313,2320,"Mortgage Payable - First Mortgage",null,0]
[null,null,2322,"Mortgage Payable - 2nd Mortgage",null,0]
[null,null,2323,"Other Loans & Notes Payable - Surplus Cash",null,0]
[null,null,2324,"Other Loans & Notes Payable ",null,0]
[null,null,2325,"Flexible Subsidy Loan Payable",null,0]
[null,2314,2326,"Capital Improvement Loan Payable",null,0]
[null,null,2327,"Operating Loss Loan Payable",null,0]
[null,null,2332,"Accrued Interest Notes Payable (Surplus Cash) Long Term",null,0]
[null,null,2390,"Misc. Long Term Liabilities",null,0]
[null,null,2395,"Net Pension Liability",null,0]
[null,null,2396,"Net Other Post-Employment Benefits Obligation",null,0]
[null,null,"2300T","Total Long Term Liabilities",null,null,{"$f":"SUM(F131:F143)","v":0}]
[null,null,2400,"Deferred Outflow of Resources - Pension",null,0]
[null,null,2410,"Deferred Outflow of Resources - OPEB",null,0]
[null,null,"2400T","Total Deferred Outflow of Resources",null,null,{"$f":"SUM(F145:F146)","v":0}]
[null,null,"2000T","Total Liabilities",null,null,{"$f":"SUM(G128:G147)","v":0}]
[]
[null,"Balance Sheet Input cont'd"]
[null,2813,3129,"Valuation of Fixed Assets",null,0]
[null,null,3130,"Owner Equity or Owner Net Assets",null,0]
[null,null,3131,"Unrestricted Net Assets/Without Donor Restrictions (Non-Profit)",null,0]
[null,null,3132,"Temporarily Restricted Net Assets/With Donor Restrictions (Non-Profit)",null,0]
[null,null,3133,"Permanently Restricted Net Assets (Non-Profit)",null,0]
[null,2810,3134,"Capital Grant by State of Connecticut",null,0]
[null,2821,3134.1,"Capital Grant by State of Connecticut - Rehab",null,0]
[null,null,3135,"CDBG Grant",null,0]
[null,null,3135.1,"CDBG Grant",null,0]
[null,2814,3136,"Contribution by the Municipality",null,0]
[null,2814.1,3136.1,"Contribution by the Municipality",null,0]
[null,2814.3,3137,"Gifts and Donations",null,0]
[null,2830,3138,"Unappropriated Retained Earnings",null,0]
[null,2830.4,3139,"Restricted Replacement Reserves",null,0]
[null,null,3139.2,"RAP Subsidy Authorized",null,0]
[null,2827,3139.3,"ERAP Subsidy Authorized - Elderly Program Only",null,0]
[null,2828,3139.4,"RSC Subsidy Authorized - Elderly Program Only",null,0]
[null,null,3139.6,"Congregate Subsidy Authorized",null,0]
[null,null,"3130T","Total Net Assets",null,null,{"$f":"SUM(F151:F168)","v":0}]
[null,null,"2033T","Total Liabilities & Equity/ Retained Earnings",null,null,{"$f":"SUM(G148:G169)","v":0}]
[null,null,3151,"General Partner Capital (Partnerships)",null,0]
[null,null,3152,"Limited Partner Capital (Partnerships)",null,0]
[null,null,"3150T","Total Equity (Partnerships)",null,null,{"$f":"SUM(F171:F172)","v":0}]
[null,null,3161,"Common Stock (Corporations)",null,0]
[null,null,3162,"Paid In Surplus (Corporations)",null,0]
[null,null,3163,"Retained Earnings (Corporations)",null,0]
[null,null,3164,"Other Equity (Corporations)",null,0]
[null,null,3166,"Sponsor Equity (Corporations)",null,0]
[null,null,3160,"Total Equity (Corporations)",null,null,{"$f":"SUM(F174:F178)","v":0}]
[null,null,3300,"Net Investment in Capital Assets",null,0]
[null,null,3310,"Unrestricted Net Position",null,0]
[null,null,3320,"Restricted Net Position",null,0]
[null,null,"3300T","Total Equity - Governmental Accounting (GASB)",null,null,{"$f":"SUM(F180:F182)","v":0}]
[null,null,"2036T","Total Liabilities & Equity/ Retained Earnings",null,null,{"$f":"+G170+SUM(G171:G183)","v":0}]
[]
[]
[]
[null,"PROFIT AND LOSS INPUT SECTION",null,null,null,"Connecticut Housing Finance Authority"]
[null,null,null,null,null,{"$f":"$F$2","v":"Asset Management - Multifamily Housing"}]
[]
[]
[null,"Project Name:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$5),\"\",'Financial Input Sheet'!$C$5)","v":""},null,"Fiscal Year End:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$5),\"\",'Financial Input Sheet'!$F$5)","v":""}]
[]
[null,"CHFA Number:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$7),\"\",'Financial Input Sheet'!$C$7)","v":""},null,"Beginning:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$7:$H$7),\"\",'Financial Input Sheet'!$F$7:$H$7)","v":""}]
[]
[null,"HUD Number:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$9),\"\",'Financial Input Sheet'!$C$9)","v":""},null,"Mortgagor:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$9:$H$9),\"\",'Financial Input Sheet'!$F$9:$H$9)","v":""}]
[null," ",null," "]
[]
[null,"* All amounts must be rounded to the nearest dollar, $.50 and over, round up, $.49 and below, round down."]
[]
[null,"** If miscellaneous or Other Income and Expense Accounts exceed the Account Groupings by 10% or more, "]
[null,"attach a separate schedule describing or explaining the Income or Expense. "]
[]
[null,"SSHP Acct. #","HUD/CHFA Acct. #","Description",null,"Amount"]
[null,3100,5120,"Rent Revenue- Gross Potential (Tenant's Portion)",null,0]
[null,3100.1,5120.1000000000004,"Rental Income-Excess of Base",null,0]
[null,null,5121,"Tenant Assistance Payments (HAP Receipts)",null,0]
[null,2811,5121.1000000000004,"Tenant Assistance Payments (RAP Receipts)",null,0]
[null,null,5121.2,"Tenant Assistance Payments (ERAP Receipts)",null,0]
[null,null,5121.3,"Tenant Assistance Payments - Congregate",null,0]
[null,null,5140,"Rent Revenue- Stores & Commercial",null,0]
[null,3300,5170,"Rent Revenue- Garage & Parking",null,0]
[null,null,5180,"Flexible Subsidy Revenue",null,0]
[null,"3120/3300",5190,"Miscellaneous Rent Revenue**",null,0]
[null,3100.1,5191,"Excess Rent",null,0]
[null,3110,5191.1000000000004,"Excess Utilities",null,0]
[null,null,5192,"Rent Revenue- Insurance",null,0]
[null,3220,5193,"Special Claims Revenue",null,0]
[null,null,5194,"Retained Excess Income",null,0]
[null,null,"5100T","Total Rent Revenue (GPI @ 100% Occupancy)",null,null,{"$f":"SUM(F205:F219)","v":0}]
[null,3210,5220,"Apartments- Vacancy",null,0]
[null,null,5240,"Stores & Commercial- Vacancy",null,0]
[null,null,5250,"Rental Concessions",null,0]
[null,null,5270,"Garage & Parking- Vacancy",null,0]
[null,null,5290,"Miscellaneous** (other vacancy)",null,0]
[null,null,"5200T","Total Vacancies",null,null,{"$f":"SUM(F221:F225)","v":0}]
[null,null,"5125N","Net Rental Revenue Rent Revenue Less Vacancy",null,null,{"$f":"SUM(G220-G226)","v":0}]
[null,null,5300,"Elderly & Congregate Service Income (attach schedule)",null,null,0]
[null,3610,5410,"Financial Revenue - Project Operations",null,0]
[null,null,5430,"Revenue from Investments - Residual Receipts",null,0]
[null,null,5440,"Revenue from Investments - Replacement Reserves",null,0]
[null,null,5490,"Revenue from Investments - Miscellaneous **",null,0]
[null,null,"5400T","Total Financial Revenue",null,null,{"$f":"SUM(F229:F232)","v":0}]
[null,3620,5910,"Laundry & Vending Revenue",null,0]
[null,null,5915,"NSF & Late Charges",null,0]
[null,null,5930,"Damages & Cleaning Fees",null,0]
[null,null,5940,"Forfeited Tenant Security Deposits",null,0]
[null,3510,5943,"Sales & Service to Tenants (including Cable TV fees)",null,0]
[null,null,5945,"Interest Reduction Payments",null,0]
[null,null,5980,"Grant Income - Capital Grant - Unrestricted",null,0]
[null,null,5981,"Grant Income - Capital Grant - Temporarily Restricted",null,0]
[null,6100,5990,"Miscellaneous Revenue(Specify) **",null,0]
[]
[null,null,"5900T","Total Other Revenue",null,null,{"$f":"SUM(F234:F242)","v":0}]
[null,null,"5000T","Total Revenue",null,null,{"$f":"SUM(G227+G228+G233+G244)","v":0}]
[]
[null,"Profit and Loss Input Page cont'd"]
[null,4153,6203,"Conventions & Meetings",null,0]
[null,null,6204,"Management Consultants",null,0]
[null,null,6210,"Advertising & Marketing",null,0]
[null,null,6235,"Apartment Resale Expenses (Coops)",null,0]
[null,4152,6250,"Other Renting Expenses",null,0]
[null,4120,6310,"Office Salaries",null,0]
[null,null,6310.1,"Salaries - RSC",null,0]
[null,null,6312,"Office or Model Apartment Rent",null,0]
[null,4120.1000000000004,6313,"Compensated Absences - Administrative Salaries",null,0]
[null,4151,6315,"Office Supplies",null,0]
[null,4132,6320,"Management Fee",null,0]
[null,null,6330,"Manager or Superintendent Salaries",null,0]
[null,null,6331,"Administrative Rent Free Unit",null,0]
[null,4130,6340,"Legal Expense (Project)",null,0]
[null,null,6350,"Audit Expense ",null,0]
[null,4131,6351,"Bookkeeping Fees/Accounting Services",null,0]
[null,null,6360,"Telephone and Answering Service",null,0]
[null,4820,6370,"Bad Debts",null,0]
[null,4716,6380,"State Service Charge - Administrative",null,0]
[null,null,6390,"Miscellaneous Administrative Expenses **",null,0]
[null,null,"6263T","Total Administrative Expenses",null,null,{"$f":"SUM(F248:F267)","v":0}]
[null,4340,6420,"Fuel Oil/ Coal",null,0]
[null,4320,6450,"Electricity",null,0]
[null,4310,6451,"Water ",null,0]
[null,4330,6452,"Gas",null,0]
[null,4360,6453,"Sewer",null,0]
[null,4350,6454,"Cable Television",null,0]
[null,null,"6400T","Total Utilities Expense",null,null,{"$f":"SUM(F269:F274)","v":0}]
[null,4410.1000000000004,6510.1,"Compensated Absences - Maintenance Wages",null,0]
[null,4410.2,6511,"Janitor and Cleaning Payroll",null,0]
[null,null,6516,"Janitor and Cleaning Supplies",null,0]
[null,4430.1000000000004,6517,"Janitor and Cleaning Contracts",null,0]
[null,4430.2,6519,"Exterminating Contracts",null,0]
[null,null,6521,"Operating & Maintenance Rent Free Unit",null,0]
[null,4430,6522,"Exterminating Supplies",null,0]
[null,4710,6525,"Garbage & Trash Removal",null,0]
[null,4430.3,6530,"Security Payroll/ Contracts",null,0]
[null,null,6531,"Security Rent Free Unit",null,0]
[null,4410.3,6535,"Grounds Payroll",null,0]
[null,null,6536,"Ground Supplies",null,0]
[null,4430.3999999999996,6537,"Grounds Contracts",null,0]
[null,4410,6540,"Repairs Payroll",null,0]
[null,4420,6541,"Repairs Material",null,0]
[null,4430,6542,"Repairs Contracts",null,0]
[null,4430.5,6545,"Elevator Maintenance Contract",null,0]
[null,null,6546,"Heating/Cooling Repairs & Maintenance",null,0]
[null,4430.6000000000004,6547,"Swimming Pool Maintenance Contract",null,0]
[null,null,6548,"Snow Removal",null,0]
[null,null,6560,"Decorating (Painting) Contract/Payroll",null,0]
[null,null,6561,"Decorating Supplies",null,0]
[null,4440,6570,"Vehicle & Maintenance Equip. Operation & Repair",null,0]
[null,6200,6590,"Miscellaneous Operating & Maintenance **",null,0]
[null,null,"6500T","Total Operating & Maintenance Expenses",null,null,{"$f":"SUM(F276:F299)","v":0}]
[null,4715,6710,"Real Estate Tax",null,0]
[null,4161,6711,"Payroll Taxes (project share)",null,0]
[null,null,6719,"Miscellaneous Taxes, Licenses, Permits",null,0]
[null,4711,6720,"Property & Liability Insurance",null,0]
[null,null,6721,"Fidelity Bond Insurance ",null,0]
[null,null,6722,"Workmen's Compensation",null,0]
[null,4160,6723,"Health Insurance & Other Benefits",null,0]
[null,null,6724,"Pension Expense",null,0]
[null,null,6725,"Other Post-Employment Benefits Expense",null,0]
[null,null,6729,"Other Insurance",null,0]
[null,null,"6700T","Total Taxes & Insurance",null,null,{"$f":"SUM(F301:F310)","v":0}]
[]
[null,"Profit and Loss Input Page cont'd"]
[null,4717,6820,"Interest on Mortgage Payable",null,0]
[null,null,6821,"Interest on Capital Improvement Loan",null,0]
[null,null,6825,"Interest on Other Mortgages",null,0]
[null,null,6830,"Interest on Notes Payable (Long Term)",null,0]
[null,null,6840,"Interest on Notes Payable (Short Term)",null,0]
[null,null,6850,"Mortgage Insurance Premium/ Services Charges",null,0]
[null,null,6890,"Miscellaneous Financial Expenses **",null,0]
[null,null,"6800T","Total Financial Expenses",null,null,{"$f":"SUM(F314:F320)","v":0}]
[null,null,6900,"Elderly & Congregate Services Expense (attach schedule)"]
[null,null,"6000T","Total Cost of Operations before Depreciation & Amortization",null,null,{"$f":"SUM(G268+G275+G300+G311+G321+G322)","v":0}]
[null,null,"5060T","Profit (Loss) before Depreciation & Amortization",null,null,{"$f":"SUM(G245-G323)","v":0}]
[null,null,6600,"Depreciation Expenses",null,0]
[null,null,6610,"Amortization Expense",null,0]
[null,null,"6600T","Total Depreciation & Amortization Expense",null,null,{"$f":"SUM(F325:F326)","v":0}]
[null,null,"5060N","Operating Profit (Loss) after Depreciation & Amortization",null,null,{"$f":"SUM(G324-G327)","v":0}]
[null,null,7110,"Officer's Salaries",null,0]
[null,null,7120,"Legal Expenses",null,0]
[null,null,7130,"Federal, State, and Other Income Taxes",null,0]
[null,null,7140,"Interest Income",null,0]
[null,null,7141,"Interest on Notes Payable",null,0]
[null,null,7142,"Interest on Mortgage Payable",null,0]
[null,null,7190,"Other Expenses",null,0]
[null,null,"7100T","Net Entity Expenses",null,null,{"$f":"SUM(F329:F335)","v":0}]
[null,null,3250,"Net Profit (Loss)",null,null,{"$f":"SUM(G328-G336)","v":0}]
[]
[]
[]
[]
[null,null,5920,"Tenant Charges",null,null,{"$f":"SUM(F235:F237)","v":0}]
[null,null,6311,"Office Expenses",null,null,{"$f":"SUM(F257+F264)","v":0}]
[null,null,6510,"Payroll",null,null,{"$f":"SUM(F277+F286+F289)","v":0}]
[null,null,6515,"Supplies",null,null,{"$f":"F278+F282+F287+F290+F297","v":0}]
[null,null,6520,"Contracts",null,null,{"$f":"SUM(F279+F280+F288+F291+F292+F294+F296)","v":0}]
[null,null,6790,"Misc. Taxes, Permits & Insurance",null,null,{"$f":"SUM(F303+F310)","v":0}]
[null,"DOH CONGREGATE INPUT SECTION"]
[]
[null,null,null,"Description",null,"Amount"]
[null,null,7010,"Tenant's Contribution - Congregate Services",null,0]
[null,null,7011,"Other Income/Meals",null,0]
[null,null,7020,"Tenant's Contribution - Assisted Living Services",null,0]
[null,2811,7030.1,"State Subsidy - Core",null,0]
[null,2811,7030.2,"State Subsidy - Expanded Core",null,0]
[null,2811,7030.3,"State Subsidy - ALSA",null,0]
[null,null,7000,"Congregate Income",null,null,{"$f":"SUM(F351:F356)","v":0}]
[null,null,8101,"Bookkeeping",null,0]
[null,null,8102,"Housing Management Salaries",null,0]
[null,null,8103,"Attendants Wages",null,0]
[null,null,8104,"Overtime/Vacation Overlap",null,0]
[null,null,8105,"Fringe Benefits",null,0]
[null,null,8106,"Payroll Taxes",null,0]
[null,null,8107,"Insurance - Workers Compensation",null,0]
[null,null,8108,"Outside Security Services",null,0]
[null,null,8100,"House Management",null,null,{"$f":"SUM(F358:F365)","v":0}]
[null,null,8201,"Chore Service Wages",null,0]
[null,null,8202,"Cleaning of Common Areas",null,0]
[null,null,8203,"Laundry (Non-Tenant)",null,0]
[null,null,8204,"Cleaning Supplies",null,0]
[null,null,8200,"Housekeeping",null,null,{"$f":"SUM(F367:F370)","v":0}]
[null,null,8301,"Food Costs",null,0]
[null,null,8302,"Meal Services",null,0]
[null,null,8303,"Supplies/Utensils",null,0]
[null,null,8304,"Utilities",null,0]
[null,null,8300,"Meal Expense",null,null,{"$f":"SUM(F372:F375)","v":0}]
[null,null,8401,"Social Service Salary",null,0]
[null,null,8402,"Supplies",null,0]
[null,null,8400,"Social Services",null,null,{"$f":"SUM(F377:F378)","v":0}]
[null,null,8000,"Congregate Core Service Expense",null,null,{"$f":"SUM(G366:G379)","v":0}]
[null,null,9001,"Resident Services Coordinator",null,0]
[null,null,9002,"Wellness/Preventive Program",null,0]
[null,null,9003,"Emergency Transportation",null,0]
[null,null,"9001-9003","Expanded Core Services",null,null,{"$f":"SUM(F381:F383)","v":0}]
[null,null,9004,"Assisted Living",null,0]
[null,null,9005,"Initial Assessment Eligibility",null,0]
[null,null,"9004-9005","Assisted Living Services",null,null,{"$f":"SUM(F385:F386)","v":0}]
[]
[]
[]
[]
[null,"ADDITIONAL INPUT SECTION",null,null,null,"Connecticut Housing Finance Authority"]
[null,null,null,null,null,{"$f":"$F$2","v":"Asset Management - Multifamily Housing"}]
[]
[]
[null,"Project Name:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$5),\"\",'Financial Input Sheet'!$C$5)","v":""},null,"Fiscal Year End:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$5),\"\",'Financial Input Sheet'!$F$5)","v":""}]
[]
[null,"CHFA Number:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$7),\"\",'Financial Input Sheet'!$C$7)","v":""},null,"Beginning:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$7:$H$7),\"\",'Financial Input Sheet'!$F$7:$H$7)","v":""}]
[]
[null,"HUD Number:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$9),\"\",'Financial Input Sheet'!$C$9)","v":""},null,"Mortgagor:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$9:$H$9),\"\",'Financial Input Sheet'!$F$9:$H$9)","v":""}]
[null," ",null," "]
[]
[null,"Principal and Reserve"]
[null,1301,"Total principal payments required under the mortgage in the audit year (12 monthly payments). This applies to all direct loans and HUD-held and fully insured mortgages.  Any HUD approved second mortgages should be included in the figures. ",null,0]
[null,1302,"Replacement Reserve deposits required by the Regulatory Agreement or Amendments thereto, even if payments may be temporarily suspended or waived.",null,0]
[null,1303,"Replacement or Painting Reserve releases which are included as expense items on the Income Statement. ",null,0]
[null,1304,"Project Improvement Reserve Releases under the Flexible Subsidy Program that are included as expense items on the Income Statement.",null,0]
[]
[null,"Determining Use of HM 6-51A vs HM 6-51B"]
[null,"Does the Regulatory Agreement define Surplus Cash as Adjusted Cash Flow?",null,null,null,null,null,null,null,"Surplus Cash - HM 6-51A"]
[null,"Does Promissory Note indicate that a portion of Adjusted Cash Flow is due to CHFA as additional interest?",null,null,null,null,null,null,null,"Adjusted Cash Flow - HM 6-51B"]
[null,"Required form based on the above responses:",null,null,{"$f":"IF(OR(E410=J412,E411=J412),\" \",IF(AND(E410=J414,E411=J414),J410,J411))","v":" "},null,null,null,null,0]
[null,"Note: Entities with agreements that require other calculations (e.g. Remaining Gross Revenue) should default to Surplus Cash, Form HM 6-51A.",null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,"No"]
[null,"Surplus Cash - Note: Not Applicable if Cell E412 above indicates \"Adjusted Cash Flow - HM 6-51B\""]
[null,"CASH","Tenant Subsidy Vouchers due for period covered by financial statement",null,0]
[null,null,"Replacement Reserve withdrawals requested prior to the balance sheet date and approved by CHFA prior to the date of the audit report",null,0,null,null,null,null,null,null,"Inserted row 417 for input of amount in cell E417, if applicable"]
[null,null,"Other Cash (Describe)",null,0]
[]
[null,"CURRENT OBLIGATIONS","Delinquent mortgage principal payments",null,0]
[null,null,"Delinquent deposits to reserve for replacements",null,0]
[null,null,"Deficient Tax Insurance or MIP Escrow Deposits",null,0]
[null,null,"Other Current Obligations (Describe)",null,0]
[]
[]
[null,"Adjusted Cash Flow - Note: Not Applicable if Cell E412 above indicates \"Surplus Cash - HM 6-51A\""]
[null,"ADD","Imputed Interest/Amort of Deferred Loan Costs (only as included in Account 6820)",null,0]
[null,null,"Additional Interest (only as included in Account 6820)",null,0]
[null,"DEDUCT","Prior Year Accrued Interest Expense Paid in Current Year",null,0]
[null,null,"Other Non-Operating Additions or Deductions (Describe)",null,0]
[]
[]
[null,"Distributions to Owners and Required Deposit to Residual Receipts or Other Reserve"]
[null,null,"Additional Interest Due CHFA, if applicable",null,0]
[null,null,"Cash available for distribution, if applicable",null,0,null,null,null,null,null,null,"Inserted row 435 for input of amount in cell E435, if applicable"]
[null,"LIMITED DIVIDENDS PROJECTS","Annual Distribution Earned During Fiscal Period Covered by Statement",null,0]
[null,null,"Distribution Accrued and Unpaid as of the End of the Fiscal Period",null,0]
[null,null,"Distributions Paid During Fiscal Period Covered by Statement",null,0]
[null,null,"Amount Available for Distribution During Next Fiscal Period\n(Non-profits enter 0.  Limited Dividend Projects enter the lesser of Surplus Cash Available for Distribution or Amount to be Carried on Balance Sheet)",null,0]
[null,null,"Deposits Due Residual Receipts or Other Reserve\n(Must be deposited with Mortgagee as stated in your Legal Documents (e.g. Regulatory Agreement, Assistance Agreement, etc.))",null,0,null,null,null,null,null,null,"Updated wording in red"]
[]
[]
[]
[null,"COMPUTATION OF "]
[null,"NET OPERATING INCOME"]
[]
[null,"Part II - IDENTIFY SPECIAL FINANCIAL CONDITIONS FOR ADJUSTMENT"]
[]
[null,"A. Replacement Reserves "]
[null,"1)  Disbursements from replacement reserve during period covered by the statement"]
[]
[null,"Pending requests at year-end for the release of funds from the replacement reserve to cover items either expensed or capitalized during the period covered by the statement"]
[]
[null,"Total of funds received from replacement reserve during the period covered by the statement that were expensed or capitalized in prior years"]
[]
[null,"Amount capitalized as increases in fixed assets during the period covered by the statement"]
[]
[null,"2)  Are there any extraordinary or one-time sources of income and/or expense(s) that are included on the Statement of Operations? (e.g.: Proceeds from Insurance claim not received in the same period as the loss)"]
[]
[null,"3)  If YES, explain reason(s) and amount(s) below: "]
[]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
[null,"B. Other Restricted Reserves"]
[null,"1)  Have all disbursements from other restricted reserve accounts (Operating Reserve, Residual Receipts, etc.) been capitalized as Increases on the Schedule of Fixed Assets?"]
[]
[null,"2)  If NO, what is the amount of other restricted reserve account releases that are represented as expenditures on the Statement of Operations?  Explain reason(s) and amount(s) below:"]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
[null,"C. Interest Reduction Payments (HUD Section 236 developments only) "]
[null,"1)  Are Interest Reduction Payments (IRP) from HUD Section 236 contracts shown as Income in Account #5945 and included in the expense line item Interest on Mortgage Payable in Account #6820?"]
[]
[null,"2)  If NO, what is the annual amount of the IRP paid to CHFA by HUD on the development's behalf not included as income in Account #5945?",null,null,null,null,0]

{"sheet":"Stmt of Operations--HM 6-50","index":1,"n_rows":189,"n_cols":10,"rows_kept":189,"cut":false,"hidden":false,"merged":[[73,0,73,7],[156,0,156,7],[189,0,189,7],[155,0,155,7],[74,0,74,7],[137,0,137,7],[132,1,132,7],[4,3,4,7],[145,8,154,12],[0,2,0,4],[142,1,142,5],[143,1,143,5],[144,1,144,5],[6,4,6,7],[8,4,8,7],[10,4,10,7],[141,1,141,5],[5,4,5,7],[7,4,7,7],[9,4,9,7],[11,4,11,7],[0,5,0,7],[1,5,1,7]]}
["STATEMENT OF ",null,null,null,null,{"$f":"'Financial Input Sheet'!F1","v":"Connecticut Housing Finance Authority"},null,null,null,"CHANGES"]
["OPERATIONS ",null,null,null,null,{"$f":"'Financial Input Sheet'!F2","v":"Asset Management - Multifamily Housing"}]
[]
[null,null," "]
["CHFA Form HM 6-50 (Rev. 12/2022 - Effective FYE 12/31/2022)",null,null,"Note:  Insertions, revisions and/or updates have been highlighted in yellow and/or appear in red lettering.  See Changes Column.",null,null,null,null,null,"Updated Rev. and FYE dates"]
[]
["Project Name:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$5),\"\",'Financial Input Sheet'!$C$5)","v":""},null,"Fiscal Year-End:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$5),\"\",'Financial Input Sheet'!$F$5)","v":""},null,null,null,null,"(Note:  No other changes to this form.)"]
[]
["CHFA Number:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$7),\"\",'Financial Input Sheet'!$C$7)","v":""},null,"Beginning Date:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$7),\"\",'Financial Input Sheet'!$F$7)","v":""}]
[]
["HUD Number:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$9),\"\",'Financial Input Sheet'!$C$9)","v":""},null,"Mortgagor:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$9),\"\",'Financial Input Sheet'!$F$9)","v":""}]
[" "," "]
[]
["Part I- P&L","Description of Account","HUD Acct. #","SHP Acct. #",null,"Amount*",null," "]
[null,"Rent Revenue- Gross Potential (Tenant's Portion)",5120,3100,"$",{"$f":"VLOOKUP(C15,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Rental Income-Excess of Base",5120.1000000000004,3100.1,"$",{"$f":"VLOOKUP(C16,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Tenant Assistance Payments (HAP Receipts)",5121,null,"$",{"$f":"VLOOKUP(C17,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Tenant Assistance Payments (RAP Receipts)",5121.1000000000004,2811,"$",{"$f":"VLOOKUP(C18,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Tenant Assistance Payments (ERAP Receipts)",5121.2,null,"$",{"$f":"VLOOKUP(C19,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Tenant Assistance Payments - Congregate",5121.3,null,"$",{"$f":"VLOOKUP(C20,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Rent Revenue- Stores & Commercial",5140,null,"$",{"$f":"VLOOKUP(C21,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Rental","Rent Revenue- Garage & Parking",5170,3300,"$",{"$f":"VLOOKUP(C22,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Income","Flexible Subsidy Revenue",5180,null,"$",{"$f":"VLOOKUP(C23,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[5100,"Miscellaneous Rent Revenue**",5190,"3120 & 3300","$",{"$f":"VLOOKUP(C24,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Excess Rent",5191,3100.1,"$",{"$f":"VLOOKUP(C25,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Excess Utilities",5191.1000000000004,3110,"$",{"$f":"VLOOKUP(C26,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Rent Revenue- Insurance",5192,null,"$",{"$f":"VLOOKUP(C27,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Special Claims Revenue",5193,3220,"$",{"$f":"VLOOKUP(C28,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Retained Excess Income",5194,null,"$",{"$f":"VLOOKUP(C29,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Total Rent Revenue (GPI @ 100% Occupancy)","5100T",null," ",null,"$",{"$f":"SUM(F15:F29)","v":0}]
[null,"Apartments- Vacancy",5220,3210,"$",{"$f":"VLOOKUP(C31,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Stores & Commercial- Vacancy",5240,null,"$",{"$f":"VLOOKUP(C32,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Vacancies","Rental Concessions",5250,null,"$",{"$f":"VLOOKUP(C33,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[5200,"Garage & Parking- Vacancy",5270,null,"$",{"$f":"VLOOKUP(C34,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Miscellaneous** (other vacancy)",5290,null,"$",{"$f":"VLOOKUP(C35,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Total Vacancies","5200T",null," ",null,"$",{"$f":"SUM(F31:F35)","v":0}]
[null,"Net Rental Revenue Rent Revenue Less Vacancy","5125N",null," ",null,"$",{"$f":"SUM(H30-H36)","v":0}]
[null,"Elderly & Congregate Service Income (attach schedule)",5300,null," ",null,"$",{"$f":"'Financial Input Sheet'!G228","v":0}]
[null,"Financial Revenue - Project Operations",5410,3610,"$",{"$f":"VLOOKUP(C39,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Financial ","Revenue from Investments - Residual Receipts",5430,null,"$",{"$f":"VLOOKUP(C40,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Revenue","Revenue from Investments - Replacement Reserves",5440,null,"$",{"$f":"VLOOKUP(C41,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[5400,"Revenue from Investments - Miscellaneous **",5490,null,"$",{"$f":"VLOOKUP(C42,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Total Financial Revenue","5400T",null," ",null,"$",{"$f":"SUM(F39:F42)","v":0}]
[null,"Laundry & Vending Revenue",5910,3620,"$",{"$f":"VLOOKUP(C44,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Tenant Charges",5920,null,"$",{"$f":"H163","v":0}]
["Other","Sales & Service to Tenants (including Cable TV fees)",5943,3510,"$",{"$f":"VLOOKUP(C46,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Revenue","Interest Reduction Payments",5945,null,"$",{"$f":"VLOOKUP(C47,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[5900,"Grant Income - Capital Grant - Unrestricted",5980,null,"$",{"$f":"VLOOKUP(C48,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Grant Income - Capital Grant - Temporarily Restricted",5981,null,"$",{"$f":"VLOOKUP(C49,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Miscellaneous Revenue (Specify) **",5990,6100,"$",{"$f":"VLOOKUP(C50,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[" ",{"$f":"IF(ISBLANK('Financial Input Sheet'!D243),\"\",'Financial Input Sheet'!D243)","v":""},null,null," "]
[null,"Total Other Revenue","5900T",null,null,null,"$",{"$f":"SUM(F44:F50)","v":0}]
[null,"Total Revenue","5000T",null," ",null,"$",{"$f":"SUM(H37:H52)","v":0}]
[null,"Conventions & Meetings",6203,4153,"$",{"$f":"VLOOKUP(C54,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Management Consultants",6204,null,"$",{"$f":"VLOOKUP(C55,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Advertising & Marketing",6210,null,"$",{"$f":"VLOOKUP(C56,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Apartment Resale Expenses (Coops)",6235,null,"$",{"$f":"VLOOKUP(C57,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Other Renting Expenses",6250,4152,"$",{"$f":"VLOOKUP(C58,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Office Salaries",6310,4120,"$",{"$f":"VLOOKUP(C59,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Salaries - RSC",6310.1,null,"$",{"$f":"VLOOKUP(C60,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Administrative","Office Expenses",6311,null,"$",{"$f":"H166","v":0}]
["Expenses","Office or Model Apartment Rent",6312,null,"$",{"$f":"VLOOKUP(C62,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["6200/6300","Compensated Absences - Administrative Salaries",6313,4120.1000000000004,"$",{"$f":"VLOOKUP(C63,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Management Fee",6320,4132,"$",{"$f":"VLOOKUP(C64,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Manager or Superintendent Salaries",6330,null,"$",{"$f":"VLOOKUP(C65,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Administrative Rent Free Unit",6331,null,"$",{"$f":"VLOOKUP(C66,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Legal Expense (Project)",6340,4130,"$",{"$f":"VLOOKUP(C67,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Audit Expense ",6350,null,"$",{"$f":"VLOOKUP(C68,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Bookkeeping Fees/Accounting Services",6351,4131,"$",{"$f":"VLOOKUP(C69,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Bad Debts",6370,4820,"$",{"$f":"VLOOKUP(C70,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"State Service Charge - Administrative",6380,4716,"$",{"$f":"VLOOKUP(C71,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Miscellaneous Administrative Expenses **",6390,null,"$",{"$f":"VLOOKUP(C72,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Total Administrative Expenses","6263T",null," ",null,"$",{"$f":"SUM(F54:F72)","v":0}]
[]
[]
[]
["Statement of Operations"]
["Part I- Cont.","Description of Account","HUD Acct. #","SHP Acct. #",null,"Amount*",null," "]
[null,"Fuel Oil/ Coal",6420,4340,"$",{"$f":"VLOOKUP(C79,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Utilities","Electricity",6450,4320,"$",{"$f":"VLOOKUP(C80,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Expenses","Water ",6451,4310,"$",{"$f":"VLOOKUP(C81,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[6400,"Gas",6452,4330,"$",{"$f":"VLOOKUP(C82,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Sewer",6453,4360,"$",{"$f":"VLOOKUP(C83,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Cable Television",6454,4350,"$",{"$f":"VLOOKUP(C84,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Total Utilities Expense","6400T",null," ",null,"$",{"$f":"SUM(F79:F84)","v":0}]
[null,"Payroll",6510,4410,"$",{"$f":"H170","v":0}]
[null,"Compensated Absences - Maintenance Wages",6510.1,4410.1000000000004,"$",{"$f":"VLOOKUP(C87,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Supplies",6515,4420,"$",{"$f":"H176","v":0}]
[null,"Contracts",6520,4430,"$",{"$f":"H184","v":0}]
[null,"Operating & Maintenance Rent Free Unit",6521,null,"$",{"$f":"VLOOKUP(C90,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Operating &","Garbage & Trash Removal",6525,4710,"$",{"$f":"VLOOKUP(C91,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Maintenance ","Security Payroll/ Contracts",6530,null,"$",{"$f":"VLOOKUP(C92,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Expenses","Security Rent Free Unit",6531,null,"$",{"$f":"VLOOKUP(C93,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[6500,"Heating/Cooling Repairs & Maintenance",6546,null,"$",{"$f":"VLOOKUP(C94,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Snow Removal",6548,null,"$",{"$f":"VLOOKUP(C95,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Vehicle & Maintenance Equip. Operation & Repair",6570,4440,"$",{"$f":"VLOOKUP(C96,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Miscellaneous Operating & Maintenance **",6590,6200,"$",{"$f":"VLOOKUP(C97,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Total Operating & Maintenance Expenses","6500T",null," ",null,"$",{"$f":"SUM(F86:F97)","v":0}]
[null,"Real Estate Tax",6710,4715,"$",{"$f":"VLOOKUP(C99,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Payroll Taxes (project share)",6711,4161,"$",{"$f":"VLOOKUP(C100,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Taxes &","Property & Liability Insurance",6720,4711,"$",{"$f":"VLOOKUP(C101,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Insurance","Fidelity Bond Insurance ",6721,null,"$",{"$f":"VLOOKUP(C102,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[6700,"Workmen's Compensation",6722,null,"$",{"$f":"VLOOKUP(C103,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Health Insurance & Other Employee Benefits",6723,4160,"$",{"$f":"VLOOKUP(C104,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Pension Expense",6724,null,"$",{"$f":"VLOOKUP(C105,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Other Post-Employment Benefits Expense",6725,null,"$",{"$f":"VLOOKUP(C106,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Misc. Taxes, Licenses, Permits & Insurance **",6790,null,"$",{"$f":"H187","v":0}]
[null,"Total Taxes & Insurance","6700T",null," ",null,"$",{"$f":"SUM(F99:F107)","v":0}]
[null,"Interest on Mortgage Payable",6820,4717,"$",{"$f":"VLOOKUP(C109,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Interest on Capital Improvement Loan",6821,null,"$",{"$f":"VLOOKUP(C110,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Interest on Other Mortgages",6825,null,"$",{"$f":"VLOOKUP(C111,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Financial","Interest on Notes Payable (Long Term)",6830,null,"$",{"$f":"VLOOKUP(C112,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Expenses","Interest on Notes Payable (Short Term)",6840,null,"$",{"$f":"VLOOKUP(C113,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[6800,"Mortgage Insurance Premium/ Services Charges",6850,null,"$",{"$f":"VLOOKUP(C114,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Miscellaneous Financial Expenses **",6890,null,"$",{"$f":"VLOOKUP(C115,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Total Financial Expenses","6800T",null," ",null,"$",{"$f":"SUM(F109:F115)","v":0}]
[null,"Elderly & Congregate Services Exp. (attach schedule)",6900,null," ",null,"$",{"$f":"'Financial Input Sheet'!G322","v":0}]
[null,"Total Cost of Operations before Depreciation & Amortization","6000T",null," ",null,"$",{"$f":"SUM(H73,H116,H117,H108,H98,H85)","v":0}]
[null,"Profit (Loss) before Depreciation & Amortization","5060T",null," ",null,"$",{"$f":"SUM(H53-H118)","v":0}]
[null,"Depreciation Expenses",6600,null,"$",{"$f":"VLOOKUP(C120,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Amortization Expense",6610,null,"$",{"$f":"VLOOKUP(C121,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Total Depreciation & Amortization Expense",null,null,null,null,"$",{"$f":"SUM(F120:F121)","v":0}]
[null,"Operating Profit (Loss) after Depreciation & Amortization","5060N",null," ",null,"$",{"$f":"SUM(H119-H122)","v":0}]
[null,"Officer's Salaries",7110,null,"$",{"$f":"VLOOKUP(C124,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Legal Expenses",7120,null,"$",{"$f":"VLOOKUP(C125,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Entity ","Federal, State, and Other Income Taxes",7130,null,"$",{"$f":"VLOOKUP(C126,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Expenses","Interest Income",7140,null,"$",{"$f":"VLOOKUP(C127,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[7100,"Interest on Notes Payable",7141,null,"$",{"$f":"VLOOKUP(C128,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Interest on Mortgage Payable",7142,null,"$",{"$f":"VLOOKUP(C129,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Other Expenses",7190,null,"$",{"$f":"VLOOKUP(C130,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Net Entity Expenses","7100T",null," ",null,"$",{"$f":"SUM(F124:F130)","v":0}]
[null,"Net Profit (Loss)",3250,null," ",null,"$",{"$f":"SUM(H123-H131)","v":0}]
[]
[null,"* All amounts must be rounded to the nearest dollar, $.50 and over, round up, $.49 and below, round down."]
[null,"** If miscellaneous or Other Income and Expense Accounts exceed the Account Groupings by 10% or more, "]
[null,"attach a separate schedule describing or explaining the Income or Expense. "]
[]
[]
[]
["Statement of Operations"]
["Part II- Principal & Reserve "]
[1,"Total principal payments required under the mortgage in the audit year (12 monthly payments). This applies to all direct loans and HUD-held and fully insured mortgages.  Any HUD approved second mortgages should be included in the figures. ",null,null,null,null,"$",{"$f":"'Financial Input Sheet'!E404","v":0}]
[2,"Replacement Reserve deposits required by the Regulatory Agreement or Amendments thereto, even if payments may be temporarily suspended or waived.",null,null,null,null,"$",{"$f":"'Financial Input Sheet'!E405","v":0}]
[3,"Replacement or Painting Reserve releases which are included as expense items on the Income Statement. ",null,null,null,null,"$",{"$f":"'Financial Input Sheet'!E406","v":0}]
[4,"Project Improvement Reserve Releases under the Flexible Subsidy Program that are included as expense items on this Income Statement.",null,null,null,null,"$",{"$f":"'Financial Input Sheet'!E407","v":0}]
[5,"Compute the following:",null,null,null,null,null,null,"Delete Items 5 and 6 from Worksheet  --  Note:  May need to Hide instead"]
[null,"     Cash plus Tenant and HUD Receivables (Accts. 1110, 1120, 1130 & 1135)",null,null,"$",{"$f":"+'Financial Input Sheet'!F15+'Financial Input Sheet'!F19+'Financial Input Sheet'!F23","v":0}]
[null,"     Accounts Payable",null,null,"$",{"$f":"+'Financial Input Sheet'!#REF!","v":{"$error":"#REF!"}}]
[null,"          Modified Quick Ratio",null,null,null,null,null,{"$f":"IF(ISBLANK(F147),\"\",SUM(F147)/(F148))","v":{"$error":"#REF!"}}]
[6,"Compute the following:"]
[null,"     Monthly Average Cash Flow from Rents  (Acct. 5125N divided by 12)",null,null,"$",{"$f":"H37/12","v":0}]
[null,"          Less:  Monthly Debt Service (including reserves)",null,null,null,0,"$",{"$f":"F151-F152","v":0}]
[null,"              Divided by"]
[null,"     Current Accounts Payable",null,null,"$"]
[null,"          Coverage Ratio",null,null,null,null,null,0]
[]
[]
["Part III- Income & Expense Sub-Accounts "]
[" ","Description of Account","HUD Acct. #","SHP Acct. #",null,"Amount*",null," "]
["Tenant ","NSF & Late Charges",5915,null,"$",{"$f":"VLOOKUP(C160,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Charges","Damages & Cleaning Fees",5930,null,"$",{"$f":"VLOOKUP(C161,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[5920,"Forfeited Tenant Security Deposits",5940,null,"$",{"$f":"VLOOKUP(C162,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[" ","Tenant Charges",5920,null,null,null,"$",{"$f":"SUM(F160:F162)","v":0}]
[null,"Office Supplies",6315,4151,"$",{"$f":"VLOOKUP(C164,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Office","Telephone and Answering Service",6360,null,"$",{"$f":"VLOOKUP(C165,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[6311,"Office Expenses",6311,null," ",null,"$",{"$f":"SUM(F164:F165)","v":0}]
[null,"Janitor and Cleaning Payroll",6511,null,"$",{"$f":"VLOOKUP(C167,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Payroll","Grounds Payroll",6535,null,"$",{"$f":"VLOOKUP(C168,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[6510,"Repairs Payroll",6540,null,"$",{"$f":"VLOOKUP(C169,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Payroll",6510,null," ",null,"$",{"$f":"SUM(F167:F169)","v":0}]
[null,"Janitor and Cleaning Supplies",6516,null,"$",{"$f":"VLOOKUP(C171,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Exterminating Supplies",6522,null,"$",{"$f":"VLOOKUP(C172,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Supplies ","Ground Supplies",6536,null,"$",{"$f":"VLOOKUP(C173,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[6515,"Repairs Material",6541,null,"$",{"$f":"VLOOKUP(C174,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[" ","Decorating Supplies",6561,null,"$",{"$f":"VLOOKUP(C175,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Supplies",6515,4420," ",null,"$",{"$f":"SUM(F171:F175)","v":0}]
[null,"Janitor and Cleaning Contracts",6517,null,"$",{"$f":"VLOOKUP(C177,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Exterminating Contracts",6519,null,"$",{"$f":"VLOOKUP(C178,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Grounds Contracts",6537,null,"$",{"$f":"VLOOKUP(C179,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Contracts","Repairs Contracts",6542,null,"$",{"$f":"VLOOKUP(C180,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[6520,"Elevator Maintenance Contract",6545,null,"$",{"$f":"VLOOKUP(C181,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Swimming Pool Maintenance Contract",6547,null,"$",{"$f":"VLOOKUP(C182,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Decorating (Painting) Contract/Payroll",6560,null,"$",{"$f":"VLOOKUP(C183,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[null,"Contracts",6520,4430," ",null,"$",{"$f":"SUM(F177:F183)","v":0}]
[null,"Miscellaneous Taxes, Licenses, Permits",6719,null,"$",{"$f":"VLOOKUP(C185,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
["Misc.","Other Insurance",6729,null,"$",{"$f":"VLOOKUP(C186,'Financial Input Sheet'!$C$14:$H$407,4,FALSE)","v":0}]
[6790,"Miscellaneous Taxes, Permits & Insurance",6790,null," ",null,"$",{"$f":"SUM(F185:F186)","v":0}]
[]
["*** Owner to specify account numbers if not provided "]

{"sheet":"Surplus Cash--HM 6-51A","index":2,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,4,0,6],[1,4,1,6],[6,3,6,6],[8,3,8,6],[10,3,10,6],[3,2,4,6],[51,0,51,6],[24,1,24,2],[5,3,5,6],[7,3,7,6],[9,3,9,6],[11,3,11,6],[45,1,45,2]]}
["COMPUTATION OF SURPLUS CASH,",null,null,null,{"$f":"'Financial Input Sheet'!F1","v":"Connecticut Housing Finance Authority"},null,null,null,"CHANGES"]
["DISTRIBUTIONS, AND RESIDUAL RECEIPTS",null,null,null,{"$f":"'Financial Input Sheet'!F2","v":"Asset Management - Multifamily Housing"}]
[]
[null,null,"Note:  Insertions, revisions and/or updates have been highlighted in yellow and/or appear in red lettering.  See Changes Column."]
["CHFA Form HM 6-51A (Rev. 12/2022 - Effective FYE 12/31/2022)",null,null,null,null,null,null,null,"Updated Rev. and FYE dates"]
[]
["Project Name:",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",'Financial Input Sheet'!$C$5, \"\")","v":""},"Fiscal Year-End:",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",'Financial Input Sheet'!$F$5, \"\")","v":""}]
[]
["CHFA Number:",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",'Financial Input Sheet'!$C$7, \"\")","v":""},"Beginning Date:",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\", 'Financial Input Sheet'!$F$7, \"\")","v":""}]
[]
["HUD Number:",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",'Financial Input Sheet'!$C$9, \"\")","v":""},"Mortgagor:",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",'Financial Input Sheet'!$F$9, \"\")","v":""}]
[" "," "]
[]
["Part A - COMPUTE SURPLUS CASH",null,null,null,null,null," ",null,"Updated the numbering sequence throughout Part A - COMPUTE SURPLUS CASH"]
[null,"1.  Cash (Accounts 1110, 1120, 1191, 1192)",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",+'Financial Input Sheet'!F14+'Financial Input Sheet'!F15+'Financial Input Sheet'!F45,\"\")","v":""}]
[null,"2.  Tenant Subsidy vouchers due for period covered by financial statement",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\", 'Financial Input Sheet'!E416, \"\")","v":""}]
[null,"3. Replacement Reserve withdrawals requested prior to the balance sheet date and approved by CHFA prior to the date of the audit report",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\", 'Financial Input Sheet'!E417, \"\")","v":""},null,null,null,"Inserted row 17 for input of amount from Financial Input Sheet"]
["CASH","4.  Other (describe)",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",'Financial Input Sheet'!E418, \"\")","v":""}]
[null,{"$f":"IF(ISBLANK('Financial Input Sheet'!C419),\"\",'Financial Input Sheet'!C419)","v":""}]
[null,"(A) Total Cash (Add Lines 1, 2, and 3)",null,null,null,"$",{"$f":"SUM(E15:E18)","v":0}]
[null,"5.  Accrued mortgage interest payable",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",SUMIF('Financial Input Sheet'!H105:H112,\"Yes\",'Financial Input Sheet'!F105:F112))","v":false}]
[null,"6.  Delinquent mortgage principal payments ",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\", 'Financial Input Sheet'!E420, \"\")","v":""}]
[null,"7.  Delinquent deposits to reserve for replacements ",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\", 'Financial Input Sheet'!E421, \"\")","v":""}]
["CURRENT","8.  Accounts payable (due within 30 days) ",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",SUMIF('Financial Input Sheet'!H89:H93,\"Yes\",'Financial Input Sheet'!F89:F93))","v":false},null,null,null,"Added Accts Payable - Sundry in the calculation"]
["OBLIGATIONS","9.  Loans and notes payable (due within 30 days, if allowed under CHFA loan documents)",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",SUMIF('Financial Input Sheet'!H115:H122,\"Yes\",'Financial Input Sheet'!F115:F122))","v":false}]
[" ","10.  Deficient Tax Insurance or MIP Escrow Deposits ",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\", 'Financial Input Sheet'!E422, \"\")","v":""}]
[" ","11.  Accrued expenses (not escrowed) ",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",SUMIF('Financial Input Sheet'!H98:H104,\"Yes\",'Financial Input Sheet'!F98:F104)+SUMIF('Financial Input Sheet'!H123:H124,\"Yes\",'Financial Input Sheet'!F123:F124))","v":false},null,null,null,"Added Payroll Deductions and Utility Allowances in the calculation"]
[null,"12.  Prepaid Rents (Account 2210) ",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\",'Financial Input Sheet'!F125, \"\")","v":""}]
[null,"13.  Tenant security deposits liability (Account 2191)",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\", 'Financial Input Sheet'!F129, \"\")","v":""}]
[null,"14.  Other (Describe) ",null,"$",{"$f":"IF('Financial Input Sheet'!$E$412=\"Surplus Cash - HM 6-51A\", 'Financial Input Sheet'!E423, \"\")","v":""}]
[null,{"$f":"IF(ISBLANK('Financial Input Sheet'!C424),\"\",'Financial Input Sheet'!C424)","v":""},null," ",null,null,null,null,"Fixed formula so \"FALSE\" doesn't generate if no description is provided in Financial Input Sheet"]
[null,"(B) Less: Total Current Obligations (Add Lines 4 through 13) ",null," ",null,"$",{"$f":"SUM(E21:E30)","v":0}]
[null,"(C) Surplus Cash (Deficiency)(Line (A) minus Line (B))",null," ",null,"$",{"$f":"SUM(G20-G32)","v":0}]
[]
["Part B - COMPUTE DISTRIBUTIONS TO OWNERS AND REQUIRED DEPOSIT TO RESIDUAL RECEIPTS"]
[null,"1a.  Surplus Cash (From Line (C))",null," ",null,"$",{"$f":"IF(ISBLANK(G33),\" \",G33)","v":0}]
[null,"1b.  Less:  Additional Interest Due CHFA, if applicable",null,null,null,"$",{"$f":"'Financial Input Sheet'!E434","v":0}]
[null,"1c.  Surplus Cash Available for Distribution",null,null,null,"$",{"$f":"'Financial Input Sheet'!E435","v":0},null,"Changed formula to Financial Input Sheet- not all properties are allowed to distribute cash - unshaded from gray"]
[null,"2a. Annual Distribution Earned During Fiscal Period Covered by Statement ",null,"$",{"$f":"'Financial Input Sheet'!E436","v":0}]
["LIMITED ","2b. Distribution Accrued and Unpaid as of the End of the Fiscal Period ",null,"$",{"$f":"'Financial Input Sheet'!E437","v":0}]
["DIVIDEND ","2c. Distributions Paid During Fiscal Period Covered by Statement ",null,"$",{"$f":"'Financial Input Sheet'!E438","v":0}]
["PROJECTS ","3.  Amount to be Carried on Balance Sheet as Distribution Earned but Unpaid ",null,"$",{"$f":"SUM(E39+E40-E41)","v":0}]
[null,"(Line 2a plus 2b minus 2c)"," "," "]
[" ","4. Amount Available for Distribution During Next Fiscal Period ",null,null,null,"$",{"$f":"'Financial Input Sheet'!E439","v":0}]
[null,"Deposits Due Residual Receipts or Other Reserve",null,null,null,"$",{"$f":"'Financial Input Sheet'!E440","v":0},null,"Updated wording"]
[" ","(Must be deposited with Mortgagee as stated in your Legal Documents (e.g. Regulatory Agreement, Assistance Agreement, etc.))",null,null,null,null,null,null,"Updated wording"]

{"sheet":"Adjusted Cash Flow--HM 6-51B","index":3,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[44,0,44,6],[15,0,21,0],[35,0,36,0],[9,3,9,6],[10,3,10,6],[11,3,11,6],[15,1,15,2],[37,0,38,0],[32,0,34,0],[22,0,26,0],[16,1,16,2],[17,1,17,2],[28,1,28,2],[38,1,38,2],[8,3,8,6],[0,4,0,6],[1,4,1,6],[5,3,5,6],[6,3,6,6],[7,3,7,6],[4,3,4,6]]}
["COMPUTATION OF ADJUSTED CASH FLOW,",null,null,null,{"$f":"'Financial Input Sheet'!F1","v":"Connecticut Housing Finance Authority"},null,null,null,"CHANGES"]
["DISTRIBUTIONS, AND RESIDUAL RECEIPTS",null,null,null,{"$f":"'Financial Input Sheet'!F2","v":"Asset Management - Multifamily Housing"}]
[{"$f":"IF('Financial Input Sheet'!E412='Financial Input Sheet'!J410,\"FORM NOT REQUIRED - See HM 6-51A\",\" \")","v":" "}]
[]
["CHFA Form HM 6-51B (Rev. 12/2022 - Effective FYE 12/31/2022)  ",null,null,"Note:  Insertions, revisions and/or updates have been highlighted in yellow and/or appear in red lettering.  See Changes Column.",null,null,null,null,"Updated Rev. and FYE dates"]
[]
["Project Name:",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",'Financial Input Sheet'!$C$5, \"\")","v":""},"Fiscal Year-End:",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\", 'Financial Input Sheet'!$F$5, \"\")","v":""}]
[]
["CHFA Number:",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",'Financial Input Sheet'!$C$7, \"\")","v":""},"Beginning Date:",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",'Financial Input Sheet'!$F$7, \"\")","v":""}]
[]
["HUD Number:",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",'Financial Input Sheet'!$C$9, \"\")","v":""},"Mortgagor:",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",'Financial Input Sheet'!$F$9, \"\")","v":""}]
[" "," "]
[]
["Part A - COMPUTE ADJUSTED CASH FLOW",null,null,null,null,null," "]
["PROFIT","1. Operating Profit before Depreciation & Amortization (Account 5060T)",null,null,null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",'Financial Input Sheet'!G324, \"\")","v":""},null,"Updated wording to \"Depreciation & Amortization\""]
["ADD","2. Accrued Interest Expense (Included in Account 6820)",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",'Financial Input Sheet'!F106, \"\")","v":""}]
[null,"3. Imputed Interest Expense/Amortization of Deferred Loan Costs (Included in Account 6820)",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!E427, \"\")","v":""},null,null,null,"Updated wording"]
[null,"4. Additional Interest Expense (Included in Account 6820)",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",'Financial Input Sheet'!E428, \"\")","v":""}]
[null,"5. Interest on Construction and Non-CHFA Mortgages (Accounts 6821, 6825, 6830, 6840)",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!F315+'Financial Input Sheet'!F316+'Financial Input Sheet'!F317+'Financial Input Sheet'!F318, \"\")","v":""}]
[null,"6. Other Financial Expenses (Accounts 6850, 6890)",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!F319+'Financial Input Sheet'!F320, \"\")","v":""}]
[null,"7. Total Replacement Reserve Disbursements Included as Expenses (HM6-52, Part II, A(1)(d))",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\", +'Financial Input Sheet'!G450+'Financial Input Sheet'!G452-'Financial Input Sheet'!G454-'Financial Input Sheet'!G456, \"\")","v":""}]
[null,"(A) Subtotal",null,null,null,"$",{"$f":"SUM(E16:E21)","v":0},null,"Changed lettering from B to A"]
["DEDUCT","8. Prior Year Accrued Interest Expense Paid in Current Year",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!E429, \"\")","v":""}]
[null,"9. Mortgage Principal on CHFA Mortgage (Account 1301)",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!E404, \"\")","v":""}]
[null,"10. Replacement Reserve Deposit Payments (Account 1302)",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!E405, \"\")","v":""}]
[null,"11. Interest Income on Reserves (Accounts 5430, 5440, 5490)",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!F230+'Financial Input Sheet'!F231+'Financial Input Sheet'!F232, \"\")","v":""}]
[null,"(B) Subtotal",null,null,null,"$",{"$f":"SUM(E23:E26)","v":0},null,"Changed lettering from C to B"]
[null,"12. Other Non-Operating Additions or Deductions (Describe)",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!E430, \"\")","v":""}]
[null,{"$f":"IF(ISBLANK('Financial Input Sheet'!C431),\"\",'Financial Input Sheet'!C431)","v":""},null,null,null,null,null,null,"Fixed formula so \"0\" doesn't generate if no description is provided in Financial Input Sheet"]
[null,"(C) Adjusted Cash Flow",null,null,null,"$",{"$f":"+G15+G22+E28-G27","v":{"$error":"#VALUE!"}},null,"Changed lettering from D to C"]
[]
["Part B -ADDITIONAL INTEREST, DISTRIBUTION, & RESIDUAL RECEIPTS"]
[null,"1a. Adjusted Cash Flow (From Line (D))",null," ",null,"$",{"$f":"G30","v":{"$error":"#VALUE!"}}]
[null,"1b. Less:  Additional Interest Due CHFA, if applicable",null,null,null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!E434, \"\")","v":""}]
[null,"1c. Cash Available for Distribution",null,null,null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!E435, \"\")","v":""},null,"Changed formula to Financial Input Sheet- not all properties are allowed to distribute cash - unshaded from gray"]
["LIMITED DIVIDEND PROJECTS","2. Annual Distribution Earned During Fiscal Period Covered by Statement ",null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!E436, \"\")","v":""}]
[null,"3. Amount Available for Distribution During Next Fiscal Period ",null,null,null,"$",{"$f":"+E36","v":""}]
[" ","4. Deposits Due Residual Receipts or Other Reserve",null,null,null,"$",{"$f":"IF('Financial Input Sheet'!E412=\"Adjusted Cash Flow - HM 6-51B\",+'Financial Input Sheet'!E440, \"\")","v":""},null,"Updated wording and changed formula to Financial Input Sheet  - not all properties are required to deposit remaining surplus cash"]
[null,"(Must be deposited with Mortgagee as stated in your Legal Documents (e.g. Regulatory Agreement, Assistance Agreement, etc.))",null,null,null,null,null,null,"Updated wording"]

{"sheet":"Computation of NOI--HM 6-52","index":4,"n_rows":80,"n_cols":15,"rows_kept":80,"cut":false,"hidden":false,"merged":[[7,5,7,11],[5,5,5,11],[6,5,6,12],[8,5,8,12],[0,5,0,12],[1,6,1,12],[3,5,3,12],[60,2,60,4],[47,2,47,4],[48,2,48,4],[49,2,49,4],[59,2,59,4],[46,2,46,4],[24,7,24,11],[26,7,26,11],[22,7,22,11],[16,7,16,11],[82,0,82,12],[9,5,9,11],[68,7,68,11],[14,7,14,11],[18,7,18,11],[20,7,20,11],[39,7,39,11],[61,7,61,11],[51,7,51,11],[78,7,78,11],[79,7,79,11],[73,7,73,11],[74,7,74,11],[76,7,76,11],[75,7,75,11],[77,7,77,11]]}
[null,null,"COMPUTATION OF ",null,null,{"$f":"'Financial Input Sheet'!F1","v":"Connecticut Housing Finance Authority"},null,null,null,null,null,null,null,null,"CHANGES"]
[null,null,"NET OPERATING INCOME",null,null,null,{"$f":"'Financial Input Sheet'!F2","v":"Asset Management - Multifamily Housing"}]
[null,null,null,null," "]
[null,null,"CHFA Form HM 6-52 (Rev. 12/2022 - Effective FYE 12/31/2022)",null,null,"Note:  Insertions, revisions and/or updates have been highlighted in yellow and/or appear in red lettering.  See Changes Column.",null,null,null,null,null,null,null,null,"Updated Rev. and FYE dates"]
[]
[null,null,"Project Name:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$5),\"\",'Financial Input Sheet'!$C$5)","v":""},"Fiscal Year-End:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$5),\"\",'Financial Input Sheet'!$F$5)","v":""}]
[]
[null,null,"CHFA Number:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$7),\"\",'Financial Input Sheet'!$C$7)","v":""},"Beginning Date:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$7),\"\",'Financial Input Sheet'!$F$7)","v":""}]
[]
[null,null,"HUD Number:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$9),\"\",'Financial Input Sheet'!$C$9)","v":""},"Mortgagor:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$9),\"\",'Financial Input Sheet'!$F$9)","v":""}]
[null,null," "," "]
[]
[null,null,"Part I - COMPUTE NET OPERATING INCOME (Source HM 6-50 \"Statement of Operations\")"]
[null,null,null,null,null,null,"Account #"]
[null,null,"A. Profit (Loss) before Depreciation",null,null,null,"5060T",{"$f":"'Stmt of Operations--HM 6-50'!H119","v":0}]
[]
[null,null,"B. Less: Revenue from Investments - Residual Receipts",null,null,null,5430,{"$f":"'Stmt of Operations--HM 6-50'!F40","v":0}]
[]
[null,null,"C. Less: Revenue from Investments - Replacement Reserves",null,null,null,5440,{"$f":"'Stmt of Operations--HM 6-50'!F41","v":0}]
[]
[null,null,"D. Less: Revenue from Investments - Miscellaneous (Restricted Accounts Only)",null,null,null,5490,{"$f":"'Stmt of Operations--HM 6-50'!F42","v":0}]
[]
[null,null,"E. Plus: Total Financial Expenses",null,null,null,"6800T",{"$f":"'Stmt of Operations--HM 6-50'!H116","v":0}]
[]
[null,null,"F. Less: Replacement Reserve Deposits ",null,null,null,"Part II #2",{"$f":"'Stmt of Operations--HM 6-50'!H143","v":0}]
[]
[null,null,"G. Net Operating Income (NOI)",null,null,null,null,{"$f":"SUM(H15-H17-H19-H21+H23-H25)","v":0}]
[]
[]
[null,null,"Part II - IDENTIFY SPECIAL FINANCIAL CONDITIONS FOR ADJUSTMENT"]
[]
[null,null,"A. Replacement Reserves and One-Time Sources of Activity",null,null,null,null,null,null,null,null,null,null,null,"Updated wording for A"]
[null,null,"1)  Disbursements from replacement reserve during period covered by the statement",null,null,null,{"$f":"'Financial Input Sheet'!G450","v":0}]
[null,null,"        a) Plus:  Pending requests at year-end for the release of funds from the replacement reserve to"]
[null,null,"                      cover items either expensed or capitalized during the period covered by the statement",null,null,null,{"$f":"'Financial Input Sheet'!G452","v":0}]
[null,null,"        b) Less:  Total of funds received from replacement reserve during the period covered by the"]
[null,null,"                       statement that were expensed or capitalized in prior years",null,null,null,{"$f":"'Financial Input Sheet'!G454","v":0}]
[null,null,"        c) Less:  Amount capitalized as increases in fixed assets during the period covered by the"]
[null,null,"                       statement",null,null,null,{"$f":"'Financial Input Sheet'!G456","v":0}]
[null,null,"       d)  Total disbursements from the replacement reserve included as expenses on HM 6-50",null,null,null,null,{"$f":"SUM(+G33,+G35,-G37,-G39)","v":0}]
[]
[null,null,"2)  Are there any extraordinary or one-time sources of income and/or expense(s) that are included on the ",null,null,null,null,"YES",null,"NO"]
[null,null,"        Statement of Operations? (e.g.: Proceeds from Insurance claim not received in the same period as the loss)",null,null,null,null,{"$f":"IF('Financial Input Sheet'!G458=\"Yes\",\"X\",\"\")","v":""},null,{"$f":"IF('Financial Input Sheet'!G458=\"No\",\"X\",\"\")","v":""}]
[]
[null,null,"3)  If YES, explain reason(s) and amount(s) below: "]
[]
[null,null,{"$f":"IF(ISBLANK('Financial Input Sheet'!B462),\"\",'Financial Input Sheet'!B462)","v":""},null,null,null,{"$f":"'Financial Input Sheet'!G462","v":0}]
[null,null,{"$f":"IF(ISBLANK('Financial Input Sheet'!B463),\"\",'Financial Input Sheet'!B463)","v":""},null,null,null,{"$f":"'Financial Input Sheet'!G463","v":0}]
[null,null,{"$f":"IF(ISBLANK('Financial Input Sheet'!B464),\"\",'Financial Input Sheet'!B464)","v":""},null,null,null,{"$f":"'Financial Input Sheet'!G464","v":0}]
[null,null,{"$f":"IF(ISBLANK('Financial Input Sheet'!B465),\"\",'Financial Input Sheet'!B465)","v":""},null,null,null,{"$f":"'Financial Input Sheet'!G465","v":0}]
[]
[null,null,null,null,null,null,"TOTAL Extraordinary or one-time income / expense(s)",{"$f":"SUM(G47:G50)","v":0}]
[]
[null,null,"B. Other Restricted Reserves"]
[null,null,"1)  Have all disbursements from other restricted reserve accounts (Operating Reserve, Residual Receipts, etc.) ",null,null,null,null,"YES",null,"NO",null,"N/A"]
[null,null,"        been capitalized as Increases on the Schedule of Fixed Assets?",null,null,null,null,{"$f":"IF('Financial Input Sheet'!G468=\"Yes\",\"X\",\"\")","v":""},null,{"$f":"IF('Financial Input Sheet'!G468=\"No\",\"X\",\"\")","v":""},null,{"$f":"IF('Financial Input Sheet'!G468=\"N/A\",\"X\",\"\")","v":""}]
[]
[null,null,"2)  If NO, what is the amount of other restricted reserve account releases that are represented as expenditures "]
[null,null,"        on the Statement of Operations?  Explain reason(s) and amount(s) below:"]
[null,null,{"$f":"IF(ISBLANK('Financial Input Sheet'!B471),\"\",'Financial Input Sheet'!B471)","v":""},null,null,null,{"$f":"'Financial Input Sheet'!G471","v":0}]
[null,null,{"$f":"IF(ISBLANK('Financial Input Sheet'!B472),\"\",'Financial Input Sheet'!B472)","v":""},null,null,null,{"$f":"'Financial Input Sheet'!G472","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(G60:G61)","v":0}]
[]
[null,null,"C. Interest Reduction Payments (HUD Section 236 developments only) ",null,null,null,null,"YES",null,"NO",null,"N/A"]
[null,null,"1)  Are Interest Reduction Payments (IRP) from HUD Section 236 contracts shown as Income in Account #5945",null,null,null,null,{"$f":"IF('Financial Input Sheet'!G475=\"Yes\",\"X\",\"\")","v":""},null,{"$f":"IF('Financial Input Sheet'!G475=\"No\",\"X\",\"\")","v":""},null,{"$f":"IF('Financial Input Sheet'!G475=\"N/A\",\"X\",\"\")","v":""}]
[null,null,"        and included in the expense line item Interest on Mortgage Payable in Account #6820?"]
[]
[null,null,"2)  If NO, what is the annual amount of the IRP paid to CHFA by HUD on the development's behalf not"]
[null,null,"        included as income in Account #5945?",null,null,null,null,{"$f":"'Financial Input Sheet'!G477","v":0}]
[]
[]
[null,null,"Part III - ADJUSTED NET OPERATING INCOME FROM PART II"]
[null,null,null,null,null,null,"Source"]
[null,null,"Net Operating Income",null,null,null,"Part I - G",{"$f":"H27","v":0}]
[null,null,"Plus:  Replacement Reserve releases included as expenses in Statement of Operations ",null,null,null,"Part II - A1",{"$f":"H40","v":0}]
[null,null,"Less/Plus:  Extraordinary or one-time income / expense(s) ",null,null,null,"Part II - A3",{"$f":"H52","v":0}]
[null,null,"Plus: Other Restricted Reserve Accounts",null,null,null,"Part II - B2",{"$f":"H62","v":0}]
[null,null,"Plus:  Interest Reduction Payments",null,null,null,"Part II - C2",{"$f":"H69","v":0}]
[]
[null,null,"Equals:  Adjusted Net Operating Income (NOI) ",null,null,null,null,{"$f":"SUM(H74:L79)","v":0}]

{"sheet":"DOH Congregate","index":5,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[39,3,39,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[25,3,25,4],[26,3,26,4],[0,5,0,7],[1,5,1,7],[4,2,4,3],[4,5,4,7],[6,2,6,3],[6,5,6,7],[17,3,17,4],[15,3,15,4],[2,1,2,3],[70,0,70,7],[51,3,51,4],[50,3,50,4],[12,3,12,4],[8,2,8,3],[8,5,8,7],[27,3,27,4],[13,3,13,4],[14,3,14,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4]]}
[null,"Computation of Net Congregate Program Cost",null,null,null,"Connecticut Housing Finance Authority",null,null,null,"CHANGES"]
[null,null,null,null,null,"Asset Management - Multifamily Housing"]
[null,"Note:  Insertions, revisions and/or updates have been highlighted in yellow and/or appear in red lettering.  See Changes Column.",null,null,null,null,null,"(Rev. 12/2022 - Effective FYE 12/31/2022)",null,"Updated Rev. and FYE dates"]
[]
[null,"Project Name:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$5),\"\",'Financial Input Sheet'!$C$5)","v":""},null,"Fiscal Year-End:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$5),\"\",'Financial Input Sheet'!$F$5)","v":""},null,null,null,"(Note:  No other changes to this form.)"]
[]
[null,"CHFA Number:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$7),\"\",'Financial Input Sheet'!$C$7)","v":""},null,"Beginning Date:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$7),\"\",'Financial Input Sheet'!$F$7)","v":""}]
[]
[null,"HUD Number:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$C$9),\"\",'Financial Input Sheet'!$C$9)","v":""},null,"Mortgagor:",{"$f":"IF(ISBLANK('Financial Input Sheet'!$F$9),\"\",'Financial Input Sheet'!$F$9)","v":""}]
[null," ",null," "]
[]
[]
[null,null,null,"Description",null,"Amount"]
[null,null,7010,"Tenant's Contribution - Congregate Services",null,{"$f":"VLOOKUP(C14,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,7011,"Other Income/Meals",null,{"$f":"VLOOKUP(C15,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,7020,"Tenant's Contribution - Assisted Living Services",null,{"$f":"VLOOKUP(C16,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,7030.1,"State Subsidy - Core",null,{"$f":"VLOOKUP(C17,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,7030.2,"State Subsidy - Expanded Core",null,{"$f":"VLOOKUP(C18,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,7030.3,"State Subsidy - ALSA",null,{"$f":"VLOOKUP(C19,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,7000,"Congregate Income",null,null,{"$f":"SUM(F14:F19)","v":0}]
[null,null,8101,"Bookkeeping",null,{"$f":"VLOOKUP(C21,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8102,"Housing Management Salaries",null,{"$f":"VLOOKUP(C22,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8103,"Attendants Wages",null,{"$f":"VLOOKUP(C23,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8104,"Overtime/Vacation Overlap",null,{"$f":"VLOOKUP(C24,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8105,"Fringe Benefits",null,{"$f":"VLOOKUP(C25,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8106,"Payroll Taxes",null,{"$f":"VLOOKUP(C26,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8107,"Insurance - Workers Compensation",null,{"$f":"VLOOKUP(C27,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8108,"Outside Security Services",null,{"$f":"VLOOKUP(C28,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8100,"House Management",null,null,{"$f":"SUM(F21:F28)","v":0}]
[null,null,8201,"Chore Service Wages",null,{"$f":"VLOOKUP(C30,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8202,"Cleaning of Common Areas",null,{"$f":"VLOOKUP(C31,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8203,"Laundry (Non-Tenant)",null,{"$f":"VLOOKUP(C32,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8204,"Cleaning Supplies",null,{"$f":"VLOOKUP(C33,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8200,"Housekeeping",null,null,{"$f":"SUM(F30:F33)","v":0}]
[null,null,8301,"Food Costs",null,{"$f":"VLOOKUP(C35,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8302,"Meal Services",null,{"$f":"VLOOKUP(C36,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8303,"Supplies/Utensils",null,{"$f":"VLOOKUP(C37,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8304,"Utilities",null,{"$f":"VLOOKUP(C38,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8300,"Meal Expense",null,null,{"$f":"SUM(F35:F38)","v":0}]
[null,null,8401,"Social Service Salary",null,{"$f":"VLOOKUP(C40,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8402,"Supplies",null,{"$f":"VLOOKUP(C41,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,8400,"Social Services",null,null,{"$f":"SUM(F40:F41)","v":0}]
[null,null,8000,"Congregate Core Service Expense",null,null,{"$f":"SUM(G29:G42)","v":0}]
[null,null,9001,"Resident Services Coordinator",null,{"$f":"VLOOKUP(C44,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,9002,"Wellness/Preventive Program",null,{"$f":"VLOOKUP(C45,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,9003,"Emergency Transportation",null,{"$f":"VLOOKUP(C46,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,"9001-9003","Expanded Core Services",null,null,{"$f":"SUM(F44:F46)","v":0}]
[null,null,9004,"Assisted Living",null,{"$f":"VLOOKUP(C48,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,9005,"Initial Assessment Eligibility",null,{"$f":"VLOOKUP(C49,'Financial Input Sheet'!$C$351:$F$387,4,FALSE)","v":0}]
[null,null,"9004-9005","Assisted Living Services",null,null,{"$f":"SUM(F48:F49)","v":0}]
[null,null,null,"Total Expenses",null,null,{"$f":"SUM(G43:G50)","v":0}]
[null,null,null,"Net Program Costs",null,null,{"$f":"G51-G20","v":0}]