COG Comprehensive Annual Financial Report

Schedule 54 Page 1 of 2

Water Resources Fund Schedule of Revenues and Expenses Budget and Actual (Non-GAAP) For the Fiscal Year Ended June 30, 2018

Variance Positive (Negative)

Final

Budget

Actual

Operating Revenues:

Charges for Current Services Other Operating Revenues

$ 116,644,845

$ 114,964,118

$

(1,680,727) 604,693 745,136 (330,898)

1,331,509

1,936,202 745,136

Other Operating Revenues - Capital Reserve Fund

Total Operating Revenues

117,976,354

117,645,456

Operating Expenses: Personal Services

16,619,119 7,456,111 9,924,214 40,899,301 1,796,909 76,695,654

15,902,740 6,847,178 4,950,771 35,903,116 1,213,171 64,816,976

716,379 608,933 4,973,443 4,996,185 583,738 11,878,678

Fringe Benefits

Maintenance and Repairs

Operations

Capital Outlay

Total Operating Expenses

Operating Income

41,280,700

52,828,480

11,547,780

Nonoperating Revenues: Investment Income

1,007,334

1,090,541 711,521 (663,807) 1,138,255 265,092 18,746 1,422,093 14,295,000 9,428,462 1,041,315 24,764,777

83,207 711,521

Investment Income - Capital Reserve Fund Net Increase (Decrease) in the Fair Value of Investments

(663,807) 130,921 65,092 (21,254) 174,759

Total Investment Income

1,007,334

Refunds and Recoveries

200,000 40,000 240,000

Miscellaneous Nonoperating Revenue

Total Nonoperating Revenues

Nonoperating Expenses: Principal Maturities

14,295,000 11,290,141 1,407,370 26,992,511

Interest Expense

1,861,679 366,055 2,227,734

Miscellaneous Nonoperating Expense

Total Nonoperating Expenses

Excess of Revenues Over Expenses Before Contributions and Other Financing Uses

15,535,523

29,485,796

13,950,273

Capital Contributions

3,068,630

3,068,630

Other Financing Sources (Uses): Debt Issuances: Revenue Bonds Issued - Refunding

66,050,270 9,151,900 (74,989,965) (28,902,590) (29,516,343) (825,958)

66,031,111 9,151,898 (74,989,963) (28,902,590) (29,535,502) (825,958)

(19,159)

Premium - Refunding Revenue Bonds

(2)

Payment to Escrow Agent for Refunding of Debt Transfers Out - Water Resources Extension Fund Project Transfers Out - Capital Improvement Fund Total Other Financing Sources (Uses) Excess of Revenues, Other Financing Sources and Contributions Over (Under) Expenses and Other Financing (Uses)

2

(19,159)

(13,980,820)

3,018,924

16,999,744

Appropriated Fund Balance

13,980,820

(13,980,820)

Excess of Revenues and Contributions Over Expenses and Other Financing (Uses)

$

$

3,018,924

$

3,018,924

-116-