Presentation of Results of Independent Procedures on the Gwinnett - PowerPoint PPT Presentation

Presentation of Results of Independent Procedures on the Gwinnett County 2005, 2009, and 2014 SPLOST Programs Year ended December 31, 2015

25252atl. Overview of Procedures  Audit of County Schedule of Expenditures of 2005, 2009, and 2014 Sales Tax Programs  Agreed upon procedures for: – County disbursements – testing for compliance with SPLOST Referendum – County disbursements – testing for proper approval – County budget amendments – testing for proper approval – County revenue and expenditures – testing for accuracy – City disbursements – testing for compliance with SPLOST Referendum – City disbursements – testing for proper approval – City revenue and expenditures – testing for accuracy 1

25252atl. Overview of 2005 SPLOST Program  County Disbursements $200,000 $183,569 (including payments to $162,793 $162,932 $156,659 Cities) $160,000 $143,191 – 2015 - $7,750,258 $109,076 $120,000 – Total Overall Program $103,951 Budget - $702,323,379 – Cumulative Program to $80,000 $60,310 Date Expenditures - $50,573 $52,630 $50,410 $50,970 $697,437,410 (99.3% of $35,529 $40,000 total program) $23,674 $17,687 $12,760 $7,252 $7,948 $7,750 $6,019 $3,144 $127 $0 Revenue Expenditures 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Dollars in Chart in Thousands 2

25252atl. Overview of 2005 SPLOST Program  City Disbursements $30,000 $26,107 $25,841 $24,364 – 2015 - $951,912 $25,000 $22,627 – Total Program Budget - $18,925 $20,000 $101,016,265 $18,623 $13,421 – Cumulative Program to $15,000 Date Expenditures - $11,505 $11,118 $99,715,925 (98.7% of $10,000 $8,276 total program) $5,477 $4,382 $5,000 $1,504 $2,734 $596 $952 $222 $403 $385 $333 Revenue $0 ($10) ($646) Expenditures ($5,000) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Dollars in Chart in Thousands 3

25252atl. Summary of Testwork and Results – 2005 SPLOST  County Disbursements – $5,983,917 of disbursements vouched – 38 items vouched – No exceptions on any disbursement regarding compliance or approvals  County Budget Amendments – 6 amendments tested – No exceptions regarding approvals  Revenue of $126,634 agreed to general ledger and bank statements without exception.  Expenditures of $7,750,258 agreed to general ledger and audited schedule without exception. 4

25252atl. Summary of Testwork and Results – 2005 SPLOST  City Disbursements – $951,762 of disbursements vouched – 40 items vouched – No exceptions on any disbursement regarding compliance or approvals.  Revenue of ($9,511) agreed to general ledger and bank statements without exception.  Expenditures of $951,912 agreed to general ledger and bank statements without exception. 5

25252atl. Overview of 2009 SPLOST Program  County Disbursements $200,000 (including payments to Cities) $165,122 $149,852 $160,000 $148,302 $135,000 – 2015 - $80,268,372 – Total Overall Program Budget - $120,000 $766,700,883 $97,259 $88,222 $83,891 $74,918 $72,789 $80,268 $72,955 – Cumulative Program to Date $80,000 Expenditures - $527,947,267 $59,117 $45,867 (68.9% of total program) $40,000 $13,324 Revenue $0 Expenditures 2009 2010 2011 2012 2013 2014 2015 Dollars in Chart in Thousands 6

25252atl. Overview of 2009 SPLOST Program $30,000  City Disbursements – 2015 - $10,678,884 $23,459 $25,000 $22,407 $20,438 – Total Program Budget - $20,117 $19,277 $106,613,304 $20,000 – Cumulative Program to Date $14,058 $13,912 $15,000 $12,498 Expenditures - $89,294,033 $12,304 $11,700 (83.8% of total program) $10,679 $10,000 $8,694 $4,185 $5,000 Revenue Expenditures $181 $0 2009 2010 2011 2012 2013 2014 2015 Dollars in Chart in Thousands 7

25252atl. Summary of Testwork and Results – 2009 SPLOST  County Disbursements – $49,120,817 of disbursements vouched – 128 items vouched – No exceptions on any disbursement regarding compliance or approvals  County Budget Amendments – 25 amendments tested – No exceptions regarding approvals  Revenue of $13,323,834 agreed to general ledger and bank statements without exception.  Expenditures of $80,268,372 agreed to general ledger and audited schedule without exception. 8

25252atl. Summary of Testwork and Results – 2009 SPLOST  City Disbursements – $10,245,491 of disbursements vouched – 128 items vouched – No exceptions on any disbursement regarding compliance or approvals.  Revenue of $181,471 agreed to general ledger and bank statements without exception.  Expenditures of $10,678,884 agreed to general ledger and bank statements without exception. 9

25252atl. Overview of 2014 SPLOST Program  County Disbursements (including payments to Cities) $200,000 $153,035 – 2015- $77,934,110 $160,000 – Total Overall Program Budget - $114,335 $431,757,398 $120,000 – Cumulative Program to Date $77,934 Expenditures - $106,111,816 $80,000 (24.6% of total program) $28,178 $40,000 Revenue $0 Expenditures 2014 2015 Dollars in Chart in Thousands 10

25252atl. Overview of 2014 SPLOST Program  City Disbursements $31,502 $35,000 – 2015 - $9,585,347 $30,000 – Total Program Budget - $25,000 $105,058,888 $20,103 – Cumulative Program to Date $20,000 Expenditures - $13,400,175 (12.7% of total program) $15,000 $9,585 $10,000 $3,815 Revenue Expenditures $5,000 $0 2014 2015 Dollars in Chart in Thousands 11

25252atl. Summary of Testwork and Results – 2014 SPLOST  County Disbursements – $57,101,561 of disbursements vouched – 165 items vouched – No exceptions on any disbursement regarding compliance or approvals  County Budget Amendments – 10 amendments tested – No exceptions regarding approvals  Revenue of $153,035,417 agreed to general ledger and bank statements without exception.  Expenditures of $77,934,110 agreed to general ledger and audited schedule without exception. 12

25252atl. Summary of Testwork and Results – 2014 SPLOST  City Disbursements – $8,808,420 of disbursements vouched – 151 items vouched – No exceptions on any disbursement regarding compliance or approvals.  Revenue of $31,501,630 agreed to general ledger and bank statements without exception.  Expenditures of $9,585,347 agreed to general ledger and bank statements without exception. 13

25252atl. Questions & Comments Joel Black Partner Mauldin & Jenkins, LLC (678) 589-5102 jmblack@mjcpa.com 14