FINANCIAL STATEMENT MATRIX - Connecticut

1 Exhibit 4-2 FINANCIAL STATEMENT MATRIXFINANCIAL STATEMENTS REQUIRED AND SAMPLE FINANCIAL STATEMENT PRESENTATIONDECD FINANCIAL DECD HousingAssistance Programs-Programs - Grant/LoanPageType of FINANCIAL StatementAdministration FundsContracts27 Balance Sheet - housing Administration FundExhibit A28 Operating STATEMENT - housing Administration FundExhibit B29 Retained Earnings STATEMENT - housing Administration FundExhibit C30 Operating STATEMENT - congregate Services(if applicable)Exhibit D31 Balance Sheet - FINANCIAL Assistance ContractsExhibit E32 STATEMENT of Program Cost - FINANCIAL AssistanceContracts (Budget vs. Actual)(must include total cost including local share)Exhibit F33 Balance Sheet - Limited Equity Cooperative Exhibit GAdministration Fund only34 Operating STATEMENT - Limited EquityCooperative Administration Fund onlyExhibit H35 Restricted Retained Earnings STATEMENT -Limited Equity Cooperative Administration Fund onlyExhibit I36 Schedule of Charges to Appropriated RetainedEarnings - housing Administration Fund (if applicable)Schedule 137 Schedule of Rehabilitation Program Expenses - housing Administration Fund (if applicable)Schedule 238 Reconciliation of Retained Earnings to WorkingCapital (Limited Equity CooperativeAdministration Fund only)Schedule 339 Schedule of State and Federal FINANCIAL Assistance (if single audit required)

2 Schedule 4 Schedule 440 Reconciliation of Expenditures by Contract to StateSingle Audit Schedule of State FINANCIAL Assistance(Required if a STATEMENT of Program Cost is not issued foreach FINANCIAL Assistance Contract)Note:If a State and/or Federal Single Audit are required of an auditee, the FINANCIAL statements and schedulesrequired to be included in the audit report to meet DECD requirements are as follows:A. DECD housing Programs - Administration Funds - All applicable Exhibits and Schedules listed above are required. These may be included as either general purposefinancial statements or supplemental DECD FINANCIAL Assistance Programs - Grant/Loan Contracts - Cummulative Statementof Program Cost required (Exhibit F). This may be included as either a FINANCIAL STATEMENT , supplemental schedule or as a note to the FINANCIAL 5268/06 Exhibit AAuditeeProject No.

3 000-E-XYZ - housing Administration FundBalance SheetAs of December 31, 2006 and 200520062005 ASSETSC hecking$8, $2, Cash - Savings and Investments382, , ' Accounts Insurance7, , Cost1,667, ,667, and Equipment140, , Improvements - Rehab260, , Assistance Services Coordinator Expense2, , ASSETS$2,468, $2,442, AND EQUITYL iabilities:Payroll Deductions$ $ Payment in Lieu of Taxes12, , ' Prepaid to the State - , Retirement - (47, )Total Liabilities13, , :Capital Grant - State of Connecticut1,648, ,648, of Fixed Assets140, , by Municipality18, , Grant - State of Connecticut - Rehab210, , Loan Liquidation50, , - Authorized1, - Unissued( ) Services Coordinator Grant-Authorized4, , Services Coordinator Grant-Unissued(1, ) Retained Earnings17, , Retained Earnings367, , Equity2,454, ,427, LIABILITIES AND EQUITY$2,468, $2,442, accompanying notes are an integral part of these FINANCIAL BAuditeeProject No.

4 000-E-XYZ - housing Administration FundOperating StatementFor the Years Ended December 31, 2006 and 200520062005 BudgetActualBudgetActualIncomeRental - Base$73, $73, $73, $73, - Excess of Base98, , , , Loss(2, )(2, )(2, )(2, )Interest Income13, , , , Income1, , , , Income184, , , , :Salaries - Office19, , , , Office Expense1, , , , and Other Funds3, , , , Taxes4, , , , Administrative29, , , , , , , , , , , , , Utilities33, , , , - Maintenance33, , , , and Supplies3, , , , Services1, , , Shop & Equipment2, , , , Maintenance39, , , , Removal2, , , , , , , , in Lieu of Taxes11, , , , Service Charge18, , , , Other47, , , , , Maintenance and Replacements29, , , , Provisions29, , , , PaymentsRehabilitation5, , , , Principal Payments5, , , , Expenses184, , , , OPERATING GAIN (LOSS)$ $2, $ $4, accompanying notes are an integral part of these FINANCIAL CAuditeeProject No.

5 000-E-XYZ - housing Administration FundRetained Earnings StatementFor the Years Ended December 31, 2006 and 2005 Unappropriated Retained Earnings20062005 Beginning Balance$14, $10, (Loss) for the Year (See Exhibit B)2, , Year Assistance (1, )Ending Balance (See Exhibit A)$17, $14, Retained Earnings20062005 Beginning BalanceRepairs Maintenance and Replacements$338, $334, Loss8, , Beginning Balance346, , : Provision for the Year (See Exhibit B)Repairs Maintenance and Replacements29, , Provision for the Year29, , : ChargesRepairs Maintenance and Replacements (Schedule 1)9, , Charges9, , BalanceRepairs Maintenance and Replacements358, , Loss8, , Ending Balance (See Exhibit A)$367, $346, accompanying notes are integral part of these FINANCIAL DAuditeeProject No. 000-E-XYZ - housing Administration FundOperating STATEMENT - congregate ServicesFor the Year Ended December 31, 2006 BUDGETACTUALR evenue:Tenants' Contribution - congregate Services$117, $110, Subsidy75, , congregate Revenue193, , : Bookkeeping2, , Manager Salary16, , Salary31, , Overlap3, , Benefits4, , Taxes10, , , , Service Salary13, , of Common Areas22, , Cost30, , Services44, , Supplies2, , Services1, congregate Expenses$193, $185, in Excess of State Subsidy$ $ accompanying notes are an integral part of these FINANCIAL EAuditeeProject No.

6 000-HC-19 - FINANCIAL Assistance ContractsBalance SheetAs of June 30, 2006 ASSETSCash - Project Account$8, Reich & Tang25, - Savings5, Accounts Funds Receivable - State15, Funds Receivable15, to Revolving Program Cost1,970, : Ineligible ASSETS$2,038, AND EQUITYL iabilities:Sundry Accounts Payable$15, Retentions10, Liabilities12, Earned on State Loans/Notes from General Authorized by the Liabilities38, :Funding Grant Authorized- State 1,500, Funds Authorized - Agency400, Funds Authorized - Other60, by Municipality40, from Revolving Loan and Equity2,000, LIABILITIES AND EQUITY$2,038, accompanying notes are an integral part of these FINANCIAL FAuditeeProject No. 000-HC-19 - FINANCIAL Assistance ContractsStatement of Program CostFor the Period March 30, 2001 through June 30, 2006 TOTALDECDLOCALTOTAL(OVERRUN)BUDGETACTUAL ACTUALACTUALUNDERRUNP rogram Income:Sale of Land or Buildings$600, $540, $ 540, $ $60, of Land or ( )Sale of Salvage or Income2, , , Income1, PROGRAM INCOME603, , , , Expenditures:Land:Land Cost/Site Acquisition$3, $8, $ 8, $ ($5, )Appraisal , , (20, )Water/Utility Hookups5, , , Land8, , , (26, )Administration:Payroll - Office3, , , Salaries - In Kind60, , , , Overhead22, , , , , , , (14, ) ( )Contractual Services4, , , , and Other Funds7, , , (8, )Office ( ) ( )Advertising2, , , Administration101, , , , (3, )Carrying Charges.

7 Interest17, , Administrative Expense55, , , , , Carrying Charges77, , , , and Engineering:Architectural and Engineering Fees99, , , , (51, )Extra Design Work28, , , and Test Pits3, , , , Testing10, , , , and Supplies2, , of the Works25, , , (15, )Total Architectural and Engineering168, , , , (61, )Structural:General Contract2,086, ,800, , ,027, , Structural2,086, ,800, , ,027, , and Equipment82, , , , :Contingency78, , Other78, , PROGRAM COST2,603, ,028, , ,513, , PROGRAM COST$2,000, $1,485, $485, $1,970, $30, - This STATEMENT must be cumulative and include all sources and uses of funds included in the Project Financing Planand Budget ( Local share, company share, other share and In-Kind contributions.).328/06 Exhibit GLimited Equity CooperativeContract No. 000-LEC-1-Administration FundBalance SheetAs of December 31, 2006 and 200520062005 ASSETSC urrent AssetsChecking$8, $9, , , ' Accounts Receivable Current Assets22, , AssetsBuilding603, , and Equipment3, , Fixed Assets606, , ASSETS$628, $623, AND EQUITYL iabilities:Accrued State Service Charge$ $ Property Taxes2, Notes98, , Retirement(2, )( )Total Liabilities98, , :State Grants407, , Grants86, , Equity11, , Retained Earnings24, , Equity529, , LIABILITIES AND EQUITY$628, $623, accompanying notes are an integral part of these FINANCIAL HLimited Equity CooperativeContract No.

8 000-LEC-1-Administration FundOperating StatementFor the Years Ended December 31, 2006 and 200520062005 BudgetActualBudgetActualRevenue:Carrying Charges$19, $19, $19, $19, Loss( ) ( )( )Interest Revenue19, , , , , , , , , , , , , Service Fee1, , , , Tax Expense4, , , , Expenses12, , , , OPERATING GAIN (LOSS)$7, $6, $7, $6, accompanying notes are an integral part of these FINANCIAL ILimited Equity CooperativeContract No. 000-LEC-1-Administration Fund Restricted Retained Earnings StatementFor the Years Ended December 31, 2006 and 200520062005 Beginning Balance$20, $13, (Loss) for the Year6, , Year Payments( ) and Replacements Charges(2, )(1, )Adjust Member Balance (See Exhibit G)$24, $20, accompanying notes are an integral part of these FINANCIAL 1 AuditeeProject No. 000-E-XYZ - housing Administration FundSchedule of Charges to Appropriated Retained EarningsFor the Years Ended December 31, 2006 and 2005 Repairs Maintenance & ReplacementsDescription20062005 Painting$ $ , , Repairs1, , , Repairs1, Equipment Purchases2, , Equipment , Charges to Repairs, Maintenance andReplacements (Exhibit C)$9, $17, 2 AuditeeProject No.

9 000-E-XYZ - housing Administration FundSchedule of Rehabilitation Program ExpendituresContract No. 000-HR-2A #Contract No. 000-HR-3 BSept. 1, 2004 - Dec. 31, 2006 Aug. 1, 2003 - Sept. 30, 2006 DescriptionBudget ActualBudgetActualSurvey$1, $ $ $ of Works5, , , , , , , , , , Work Items47, , , , , , Total Rehab. Program Expenditures$60, $57, $109, $101, # Contract No. 000-HR-2A was closed out during the year ended December 31, Rehabilitation Program Expenditures have been closed out to and included in the "Capital Improvements-Rehabilitation" Schedule 3 Limited Equity CooperativeContract No. 000-LEC-1-Administration FundReconciliation of Restricted Retained Earnings to Working CapitalFor the Years Ended December 31, 2006 and 200520062005 RESTRICTED RETAINED EARNINGSR estricted Retained Earnings (See Exhibit G)$24, $20, : Accumulated Retirement(2, )( )Administration Fund Purchases of Equipment(3, )(2, )Total Working Capital$18, $17, CAPITALC urrent Assets (See Exhibit G)$22, $17.

10 Current Liabilities(3, )( )Total Working Capital$18, $17, 4 AuditeeSchedule of State FINANCIAL AssistanceFor the Year Ended June 30, 2006 State GrantProgramStateProgramState GrantorIdentification ContractAward AssistanceTotalProgram TitleNumberNumberAmountReceivedExpenditu resState Department of Economic and Community DevelopmentHousing and Community Development1801-3500-008 000-HCD-180, $ 60, $ 55, $ 1801-3500-008 000-HCD-2120, , , *200, $ 180, $ 155, $ Rental Assistance Program0-3500-102000-RAP-1-$ -$ -$ 0-3500-102000-RAP-25, , , #0-3500-102000-RAP-36, , , , $ 10, $ 9, $ Special Act GrantFranklin Theater Renovation1874-3500-01,500, $ 1,200, $ 950, $ * #Urban Action BondsMain St.