The URL can be used to link to this page

Home My WebLink About2017-COH - Independent Auditor's Report On Supplementary InformationCOUNTY OF HAWAII STATE OF HAWAII INDEPENDENT AUDITOR'S REPORT ON SUPPLEMENTARY INFORMATION Fiscal Year Ended June 30, 2017 N&K CPAs, Inc. ACCOUNTANTS | CONSULTANTS AMERICAN SAVINGS BANK TOWER I 1001 BISHOP STREET, SUITE 1700 | HONOLULU, HAWAII 96813-3696 T (808) 524-2255 F (808) 523-2090 | nkcpa.com COUNTY OF HAWAII STATE OF HAWAII TABLE OF CONTENTS Page INDEPENDENT AUDITOR'S REPORT ON 3 SUPPLEMENTARY INFORMATION FINANCIAL DATA SCHEDULE 4 - 6 2 N&K CPAs, Inc. ACCOUNTANTS I CONSULTANTS AMERICAN SAVINGS BANK TOWER 1001 BISHOP STREET, SUITE 1700 HONOLULU, HAWAII 96813-3696 T (808) 524-2255 F (808) 523-2090 INDEPENDENT AUDITOR'S REPORT ON SUPPLEMENTARY INFORMATION To the Chair and Members of the County Council County of Hawaii, State of Hawaii We have audited the financial statements of the governmental activities, the business -type activities, the discretely presented component unit, each major fund, and the aggregate remaining fund information of the County of Hawaii, State of Hawaii (County), as of and for the fiscal year ended June 30, 2017, and the related notes to the basic financial statements, which collectively comprise the County's basic financial statements, and have issued our report thereon dated December 28, 2017, which contained an unmodified opinion on those financial statements. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Our audit was performed for the purpose of forming opinions on the financial statements that comprise the County's basic financial statements. The accompanying supplementary information of the Financial Data Schedule (FDS) is presented for purposes of additional analysis and is not a required part of the basic financial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the financial statements. The information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America and Government Auditing Standards, issued by the Comptroller General of the United States. In our opinion, the accompanying supplementary information of the FDS is fairly stated, in all material respects, in relation to the basic financial statements as a whole. This report is intended solely for the information and use of management, the County Council of the County of Hawaii, the Legislative Auditor, the County Administration, others within the entity, and the U.S. Department of Housing and Urban Development, and is not intended to be and should not be used by anyone other than these specified parties. N&K CPAs, Inc. Honolulu, Hawaii March 15, 2018 3 County of Hawaii State of H awai `i FINANCIAL DATA SCHEDULE Fiscal Year Ended June 30, 2017 M PIH Family Section 8 Line Self -Sufficiency Housing Choice Item Account Description Program Vouchers Program Total 111 Cash -unrestricted $ -- $ 625,909 $ 625,909 113 Cash -other restricted 4,711 31,802 36,513 115 Cash -restricted for payment of current liabilities -- 26,791 26,791 100 Total cash 4,711 684,502 689,213 121 Accounts receivable -PHA projects -- 3,826 3,826 122 Accounts receivable -HUD other projects -- 151,083 151,083 125 Accounts receivable -miscellaneous 5,700 95,580 101,280 126.2 Allowance for doubtful accounts -other -- (94,966) (94,966) 128 Fraud recovery -- 404,567 404,567 128.1 Allowance for doubtful accounts -fraud -- (381,362) (381,362) 120 Total receivables, net of allowances for doubtful accounts 5,700 178,728 184,428 142 Prepaid expenses and other assets -- 4,179 4,179 150 Total current assets 10,411 867,409 877,820 290 Total assets and deferred outflow of resources $ 10,411 $ 867,409 $ 877,820 312 Accounts payable <- 90 days $ -- $ 13,248 $ 13,248 321 Accrued wage/payroll taxes payable 2,992 75,459 78,451 332 Accounts payable -PHA projects -- 5,737 5,737 333 Accounts payable -other government -- 1,092 1,092 345 Other current liabilities -- 21,054 21,054 310 Total current liabilities 2,992 116,590 119,582 353 Non-current liabilities - other -- 31,801 31,801 350 Total non-current liabilities -- 31,801 31,801 300 Total liabilities 2,992 148,391 151,383 509.3 Restricted fund balance 7,419 22,826 30,245 512.3 Unassigned fund balance -- 696,192 696,192 513 Total equity - net assets/position 7,419 719,018 726,437 600 Total liabilities, deferred inflows of resources and equity/net assets $ 10,411 $ 867,409 $ 877,820 M County of Hawaii State of H awai `i FINANCIAL DATA SCHEDULE (Continued) Fiscal Year Ended June 30, 2017 91100 Administrative salaries 91400 Advertising and marketing 91500 Employee benefit contributions -administrative 91600 Office expenses 91800 Travel 91000 Total operating -administrative 92100 Tenant services -salaries 92300 Employee benefit contributions -tenant services 92500 Total tenant services 93200 Electricity 93000 Total utilities 96200 Other general expenses 96000 Total other general expenses 96900 Total operating expenses 97000 Excess of operating revenue over operating expenses 97300 Housing assistance payments 97350 HAP portability -in 97600 Capital outlays -governmental funds 90000 Total expenses 10030 Operating transfers from/to primary government 10100 Total other financing sources (uses) 10000 Excess (deficiency) of total revenue over (under) total expenses -- 1,451,637 -- 3,111 -- 469,624 -- 261,532 -- 13,022 2,198,926 49,216 17,998 67,214 67,214 (1,010) 67,214 23,414 23,414 19,062 19,062 2,241,402 18,162,587 17,272,987 1,249,116 14,697 20,778,202 200,000 Total 19, 047,155 1,335 64,118 20,470,193 1,451,637 3,111 469,624 261,532 13,022 2,198, 926 49,216 17,998 67,214 23,414 23,414 19,062 19,062 2,308,616 18,161,577 17,272,987 1,249,116 14,697 20,845,416 onn nnn 200,000 200,000 $ (1,010) $ (174,213) $ (175,223) PIH Family Section 8 Line Self -Sufficiency Housing Choice Item Account Description Program Vouchers Program 70600 HUD PHA operating grants $ 66,204 $ 18,980,951 $ 71100 Investment income -unrestricted -- 1,335 71400 Fraud recovery -- 64,118 71500 Other revenue -- 1,357,585 70000 Total revenue 66,204 20,403,989 91100 Administrative salaries 91400 Advertising and marketing 91500 Employee benefit contributions -administrative 91600 Office expenses 91800 Travel 91000 Total operating -administrative 92100 Tenant services -salaries 92300 Employee benefit contributions -tenant services 92500 Total tenant services 93200 Electricity 93000 Total utilities 96200 Other general expenses 96000 Total other general expenses 96900 Total operating expenses 97000 Excess of operating revenue over operating expenses 97300 Housing assistance payments 97350 HAP portability -in 97600 Capital outlays -governmental funds 90000 Total expenses 10030 Operating transfers from/to primary government 10100 Total other financing sources (uses) 10000 Excess (deficiency) of total revenue over (under) total expenses -- 1,451,637 -- 3,111 -- 469,624 -- 261,532 -- 13,022 2,198,926 49,216 17,998 67,214 67,214 (1,010) 67,214 23,414 23,414 19,062 19,062 2,241,402 18,162,587 17,272,987 1,249,116 14,697 20,778,202 200,000 Total 19, 047,155 1,335 64,118 20,470,193 1,451,637 3,111 469,624 261,532 13,022 2,198, 926 49,216 17,998 67,214 23,414 23,414 19,062 19,062 2,308,616 18,161,577 17,272,987 1,249,116 14,697 20,845,416 onn nnn 200,000 200,000 $ (1,010) $ (174,213) $ (175,223) County of Hawaii State of H awai `i FINANCIAL DATA SCHEDULE (Continued) Fiscal Year Ended June 30, 2017 PIH Family Section 8 Line Self -Sufficiency Housing Choice Item Account Description Program Vouchers Program Total 11030 Beginning equity $ 8,429 $ 893,231 $ 901,660 11100 Changes in allowance for doubtful accounts -other $ -- $ (16,329) $ (16,329) 11170 Administrative fee equity $ -- $ 696,192 $ 696,192 11180 Housing assistance payments equity $ -- $ 22,826 $ 22,826 11190 Unit months available 24,060 24,060 11210 Number of units months leased 23,493 23,493