2018-2022 Financial Plan

APPENDIX C: INFRASTRUCTURE FUNDING STRATEGY

DCC Projection by Individual Component

DCC PROJECTION BY INDIVIDUAL COMPONENT

2006

Roads

Sewer

Drainage

Water

Parks*

Total

Opening

9,271,171 2,782,036

977,432 3,229,134 1,780,247 6,538,146 21,796,131

Collections

127,084

315,611

350,422 1,800,825 5,375,979

Interest

100,464 -52,229

13,352

31,529

15,401

-706

160,040

Support Salary/Debt

-32,304

-31,309

-146,877 -262,719 Land swap? ----> -1,000,000 -1,000,000

Reverse prior WIP

1,859,028 -5,822,915

40,246

223,336

24,709

304,914 2,452,233

Capital Expenditures

-44,271 -1,214,456

-776,426 -7,700,335 -15,558,403

Closing

8,137,555 1,081,540 2,553,845 1,247,476

-57,155 12,963,261

Borrow---> 4,300,000 1,000,000 1,500,000

6,800,000

2007

Roads

Sewer

Drainage

Water

Parks

Total

Opening

8,137,555 1,081,540 2,553,845 1,247,476

-57,155 12,963,261

Collections

1,793,364

81,917 11,418

203,466

225,905 1,160,903 3,465,555

Interest

61,972

27,348

12,093

-1,090

111,741

Support Salary/Debt

-53,796

0

-35,183

-146,877

-235,856

Debt Payments

-1,075,000 -3,844,348 5,019,748

-250,000

-375,000 -159,300

0

0 -1,700,000

Capital Expenditures

0

-359,072 -1,190,952 -5,553,671

Closing

924,875 2,215,176

979,525

-88,294 9,051,029

2008

Roads

Sewer

Drainage

Water

Parks

Total

Opening

5,019,748 2,165,328

924,875 2,215,176

979,525

-88,294 9,051,029

Collections

47,807

231,620

256,260 1,373,592 4,074,608

Interest

51,723

9,034

8,808

11,540

-6,800

74,305

Support Salary/Debt

-55,410

0

-39,536

-100,221

-195,167

Debt Payments

-1,075,000 -1,916,792 4,189,598

-250,000

-375,000

0

0 -1,700,000

Capital Expenditures

0 -1,327,590

-212,400 -1,829,268 -5,286,050

Closing

731,716

713,478

934,704

-550,770 6,018,725

2009

Roads

Sewer

Drainage 713,478 236,246

Water

Parks

Total

Opening

4,189,598 2,210,259

731,716

934,704

-550,770 6,018,725

Collections

48,841

261,391 1,402,674 4,159,411

Interest

15,128

6,632

5,525

1,498

-9,643

19,140

Support Salary/Debt

-57,072

0

0

-100,221

-157,293

Debt Payments

-1,075,000 -4,057,567 1,225,345

-250,000

-375,000 -132,750 447,499

0

0 -1,700,000

Capital Expenditures

0

-976,015 -1,623,331 -6,789,663

Closing

537,188

121,357

-781,071 1,550,319

2010

Roads

Sewer

Drainage 447,499 239,558

Water

Parks

Total

Opening

1,225,345 2,240,329

537,188

121,357

-781,071 1,550,319

Collections

49,459

265,093 1,420,919 4,215,357

Interest

257

3,257

2,054

-2,047

-13,420

-9,899

Support Salary/Debt

-58,784

0

0

-100,221

-159,005

Debt Payments

-1,075,000 -2,311,307

-250,000 -76,089 263,816

-375,000 -147,744 166,367

0

0 -1,700,000

Capital Expenditures

-450,000 -1,713,451 -4,698,592

Closing

20,839

-165,819 -1,087,023

-801,819

2011

Roads 20,839

Sewer

Drainage 166,367 243,202

Water

Parks

Total

Opening

263,816

-165,819 -1,087,023

-801,819

Collections

2,274,654

50,217

269,094 1,442,731 4,279,898

Interest

14,499

800

432

38

4,446

20,216

Support Salary/Debt

-60,548

0

0

-100,221

-160,769

Debt Payments

-1,075,000

-250,000

-375,000

0

0 -1,700,000

Capital Expenditures

0

Closing 360,154 1,637,526 * The Parks component 2006-2011 capital expenditures may need to be reduced if 2006 land swap occurs. 1,174,445 64,833 35,001 3,092

Page 208 of 234