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

1

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

2

25252atl.

Overview of 2005 SPLOST Program

$0 $40,000 $80,000 $120,000 $160,000 $200,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015

$109,076 $162,793 $162,932 $183,569 $50,970 $7,252 $6,019 $17,687 $7,948 $3,144 $127 $35,529 $60,310 $143,191 $156,659 $103,951 $50,573 $50,410 $52,630 $23,674 $12,760 $7,750

Revenue Expenditures

Dollars in Chart in Thousands

 County Disbursements

(including payments to Cities)

– 2015 - $7,750,258 – Total Overall Program Budget - $702,323,379 – Cumulative Program to Date Expenditures - $697,437,410 (99.3% of total program)

3

25252atl.

Overview of 2005 SPLOST Program

($5,000) $0 $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015

$13,421 $25,841 $26,107 $22,627 $11,118 $222 ($646) $385 $333 $596 ($10) $1,504 $11,505 $24,364 $18,623 $18,925 $8,276 $4,382 $5,477 $2,734 $403 $952

Revenue Expenditures

Dollars in Chart in Thousands

 City Disbursements

– 2015 - $951,912 – Total Program Budget - $101,016,265 – Cumulative Program to Date Expenditures - $99,715,925 (98.7% of total program)

4

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.

5

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.

6

25252atl.

Overview of 2009 SPLOST Program

$0 $40,000 $80,000 $120,000 $160,000 $200,000 2009 2010 2011 2012 2013 2014 2015

$88,222 $135,000 $149,852 $165,122 $148,302 $59,117 $13,324 $45,867 $72,789 $74,918 $97,259 $83,891 $72,955 $80,268

Revenue Expenditures

Dollars in Chart in Thousands

 County Disbursements

(including payments to Cities)

– 2015 - $80,268,372 – Total Overall Program Budget - $766,700,883 – Cumulative Program to Date Expenditures - $527,947,267 (68.9% of total program)

7

25252atl.

Overview of 2009 SPLOST Program

$0 $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 2009 2010 2011 2012 2013 2014 2015

$11,700 $23,459 $19,277 $22,407 $20,117 $8,694 $181 $4,185 $12,498 $14,058 $20,438 $12,304 $13,912 $10,679

Revenue Expenditures

Dollars in Chart in Thousands

 City Disbursements

– 2015 - $10,678,884 – Total Program Budget - $106,613,304 – Cumulative Program to Date Expenditures - $89,294,033 (83.8% of total program)

8

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.

9

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.

10

25252atl.

Overview of 2014 SPLOST Program

$0 $40,000 $80,000 $120,000 $160,000 $200,000 2014 2015

$114,335 $153,035 $28,178 $77,934

Revenue Expenditures

Dollars in Chart in Thousands

 County Disbursements

(including payments to Cities)

– 2015- $77,934,110 – Total Overall Program Budget - $431,757,398 – Cumulative Program to Date Expenditures - $106,111,816 (24.6% of total program)

11

25252atl.

Overview of 2014 SPLOST Program

$0 $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 $35,000 2014 2015

$20,103 $31,502 $3,815 $9,585

Revenue Expenditures

Dollars in Chart in Thousands

 City Disbursements

– 2015 - $9,585,347 – Total Program Budget - $105,058,888 – Cumulative Program to Date Expenditures - $13,400,175 (12.7% of total program)

12

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.

13

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.

14

25252atl.

Questions & Comments

Joel Black Partner Mauldin & Jenkins, LLC (678) 589-5102 jmblack@mjcpa.com