FY18-19 and 19-20 RECOMMENDED OPERATING AND CIP BUDGET - FIN

FY 2017-18 Fund Balance Projection (continued)

7-1-2017

17-18

17-18

17-18

17-18

06-30-2018

Fund

Projected Projected Projected Projected Projected

Balance

Revenues

Transfers In Transfers Out Expenditures

Balance

Debt Service Funds 420

Civic Center Debt

$

161,328

$

1,350

$

293,701

$

-

$

297,423

$

158,956

441

Police Facility Bond Debt Service

93,903

450

381,458

-

383,610

92,201

Subtotal

$

255,231

$

1,800

$

675,159

$

-

$

681,033

$

251,157

Enterprise Funds 640

Sewer Operations Fund

$

3,166,252

$

10,133,984

$

-

$

3,973,932

$

6,670,665

$

2,655,639

641

Sewer Impact Fund

13,739,517

4,006,973

-

240,476

4,774,093

12,731,921

642

Sewer Rate Stablization Fund

2,538,125

23,500

-

-

3,900

2,557,725

643

Sewer System Replacement Fund

8,958,692

385,358

3,339,800

-

6,081,302

6,602,548

650

Water Operations Fund

1,553,946

12,583,273

415,544

2,511,677

9,564,740

2,476,346

651

Water Impact Fund

3,153,844

1,039,792

-

664,238

601,192

2,928,206

652

Water Rate Stabilization Fund

539,303

6,000

-

-

606

544,697

653

Water System Replacement Fund

613,123

10,500

2,701,313

-

3,315,872

9,064

Subtotal

$

34,262,802

$

28,189,380

$

6,456,657

$

7,390,324

$

31,012,369

$

30,506,146

Internal Service Funds 730

Information Systems Fund

$

643,810

$

1,603,986

$

-

$

9,113

$

1,688,252

$

550,431

740

Building Maintenance Fund

101,294

3,126,389

10,028

9,400

3,226,566

1,745

741

Building Replacement Fund

2,063,612

461,432

30,243

-

356,500

2,198,787

745

CIP Administration Fund

32,485

1,397,622

-

20,511

1,376,719

32,877

760

Unemployment Insurance Fund

164,584

1,500

-

-

6,172

159,912

770

Worker's Comp Fund

1,653,150

940,671

-

-

1,080,413

1,513,408

790

Equipment Replacement Fund

4,110,874

690,410

300,000

-

1,225,467

3,875,817

791

Employee Benefits Fund

87,709

613,569

300,002

-

558,538

442,742

795

General Liab. Insurance Fund

1,108,152

947,010

-

775

885,613

1,168,774

Subtotal

$

9,965,670

$

9,782,589

$

640,273

$

39,799

$

10,404,239

$

9,944,494

Agency Funds 820

Special Deposits

$

27,918

$

7,850

$

-

$

-

$

-

$

35,768

830

Downtown PBID

3,663

900

-

-

-

4,563

843

MH Business Ranch 1998 AD Fund

649,955

739,297

-

-

736,227

653,025

844

MH Ranch Reassessment 2004 Fund

39,472

300

-

-

-

39,772

845

Madrone BP (Tax Exempt) Fund

557,179

665,531

-

-

665,361

557,349

846

Madrone BP (Taxable) Fund

106,858

82,521

-

-

81,735

107,644

848

Tennant Ave Business Park AD Fund

11,399

5,400

-

-

-

16,799

881

Police Donation Trust Fund

25,822

212

-

-

-

26,034

Subtotal

$

1,422,266

$

1,502,011

$

-

$

-

$

1,483,323

$

1,440,954

TOTAL - ALL FUNDS

$

115,762,151

$

111,634,444

$

11,761,946

$

11,761,946

$

120,783,330

$

106,613,265

BUDGET SUMMARY 77