Loading...
HomeMy WebLinkAboutR-10815 - APPROVING THE 2017-19 FINANCIAL PLAN AND 2017-18 BUDGETR 10815 RESOLUTION NO. 10815 (2017 SERIES) A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SAN LUIS OBISPO, CALIFORNIA, APPROVING THE 2017-19 FINANCIAL PLAN AND 2017-18 BUDGET WHEREAS, in accordance with San Luis Obispo Charter Section 802, the City Manager has submitted the 2017-19 Financial Plan to the Council for its review and consideration consistent with budget policies and objectives established by the Council; and WHEREAS, the 2017-19 Financial Plan is based upon extensive public comment and direction of the Council after scheduled budget workshops and public hearings held on June 1st and June 6th. NOW, THEREFORE, BE IT RESOLVED by the Council of the City of San Luis Obispo as follows: SECTION 1. The Preliminary 2017-19 Financial Plan, amended for the items listed in Exhibit 1 (including attachments A, B, C to the Exhibit), which is incorporated by reference herein, is hereby approved and the operating, debt service and capital improvement plan budget for the fiscal year beginning July 1, 2017 and ending June 30, 2018 is hereby adopted. SECTION 2. The Budget and Fiscal Policies included in the Preliminary 2017-19 Financial Plan and amended as shown in Exhibit 1 are hereby approved. SECTION 3. The City Manager is hereby delegated authority to approve budget adjustments for budget allocations earmarked by the Council action for specific purpose during 2016-17 fiscal year to be expended during 2017-18. SECTION 4. The City Manager is hereby delegated the authority to approve format and typographical changes found within the Preliminary 2017-19 Financial Plan as needed.     EXHIBIT 1 – CHANGES OT THE PRELIMINARY BUDGET    I. Amend Preliminary 2017‐19 Financial Plan based on Council direction from June 1,  2016 Budget Hearing as follows:    2017‐18 2018‐19    Decrease Transfer‐Out from Parkland  Development Fund to General Fund     Parkland Development Fund Transfer‐Out ‐480,000   General Fund Transfer‐In ‐480,000       Increase General Capital Outlay Sources for  SB 1 Revenue     SB 1 – Road Repair and Accountability  Revenue  318,000 180,000      Increase General Capital Outlay Fund  Expenditure      Safe Routes to School Capital Improvement  Project  268,000       Decrease General Capital Outlay Fund  Expenditure     Safe Routes to School  ‐250,000        II. Amend Preliminary 2017‐19 Financial Plan to correct typographical error in Fiscal  and Budget Policies as follows:    Page B1‐9 corrected.    D. Cost of Service Fees. The City will treat the water and sewer funds in the same  manner as if they were privately owned and operated. This means assessing  reasonable cost of service fees in fully recovering service costs.    The purpose of the cost of service fee is reasonable cost recovery for the use of the  city’s services such as street rights‐of‐way and public safety. The appropriateness of  charging the water and sewer fund a reasonable cost of service fee for the use of the  City streets is further supported by the results of studies Arizona, California, Ohio,  and Vermont which concluded that the leading cause of street resurfacing and  reconstruction is street cuts and trenching for utilities.   Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 3           III. Amend Preliminary 2017‐19 Financial Plan financial schedules to reflect the  Council Direction from June 1, 2016 Budget Hearing and to reflect corrections as  follows:    Attachment A – Replace page A1‐30  Attachment B – Replace pages A1‐51, E1‐9 through E1‐16  Attachment C – Replace pages G1‐5 through G1‐39      Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 4 General Fund Five Year Fiscal Forecast 2017-19 Financial Plan #REF! $ in 000's Actual Revised 2015-16 2016-17 2017-18 2018-19 2019-20 2020-21 2021-22 1 Sales Tax 17,498 16,584 16,932 17,277 17,186 17,659 18,170 2 Measure Y/G Sales Tax 7,178 7,391 7,607 7,679 7,636 7,790 7,959 3 Sales Tax Prop 172 405 428 437 445 445 454 463 4 Property Taxes 10,187 10,767 10,950 11,607 12,245 12,858 13,501 5 Property Tax in Lieu of VLF 4,113 4,365 4,593 4,846 5,088 5,343 5,610 6 Transient Occupancy Tax 7,113 7,186 7,294 7,440 7,663 8,008 8,368 7 Utility Users Tax 5,414 5,506 5,568 5,617 5,690 5,779 5,870 8 Franchise Fees 1,538 1,540 1,527 1,527 1,527 1,527 1,527 9 Business Tax 2,492 2,500 2,747 2,884 3,028 3,180 3,339 10 Real Property Transfer Tax 366 373 381 388 396 404 412 11 Subtotal Taxes 56,304 56,640 58,035 59,711 60,906 63,001 65,219 12 Transfers In (Gas, TDA, CoS, Other)2,924 2,353 3,876 3,539 2,377 2,377 2,377 13 Other Subventions & Grants 1,539 316 316 316 316 316 316 14 Development Review Fees 5,624 5,647 6,154 5,981 6,068 6,188 6,311 15 Recreation Fees 1,759 1,640 1,810 1,846 1,883 1,921 1,959 16 Other Service Charges 1,952 1,750 1,633 1,657 1,682 1,707 1,733 17 Other Revenues 891 543 543 543 543 543 543 18 Subtotal Non-Tax Revenues 14,689 12,249 14,331 13,882 12,868 13,051 13,238 19 Total Resources 70,993 68,889 72,367 73,593 73,774 76,052 78,457 20 Operating Expenses (excl PERS)2 46,223 49,548 50,906 50,817 53,147 54,349 55,665 21 PERS Normal Costs 3,612 3,866 3,058 3,020 3,080 3,157 3,236 22 PERS Unfunded Liability 5,629 6,871 8,134 9,330 10,591 11,416 12,264 23 PERS Discount Rate Adjustment 375 802 1,896 2,550 24 Subtotal: Operating Expenses 55,464 60,285 62,098 63,542 67,620 70,818 73,716 25 Debt Service 3,025 3,246 3,245 3,241 2,795 2,391 2,391 26 Transfer to CDBG 147 154 154 154 154 154 154 27 Transfer to Insurance Benefit Fund 2,124 1,740 750 500 - - - 28 Transfer to Parkland Development Fund 900 29 CIP - Fleet Replacement 384 - 674 508 485 500 500 30 CIP - IT Replacement 617 2,621 639 1,136 525 551 579 31 CIP - Major Facility Replacement 146 505 768 550 855 917 962 32 CIP - All Other & Local Measure Funded projects)3,329 6,507 3,870 3,977 3,502 3,550 3,728 33 Subtotal: Operating Transfers 9,773 15,673 10,100 10,066 8,316 8,063 8,314 #REF! 34 Total Expenditures 65,237 75,958 72,198 73,608 75,937 78,881 82,029 35 Resources Over/(Under) Expenses 5,757 (6,869) 169 (15) (2,163) (2,829) (3,572) 36 Fund Balance, Beginning of Year 24,566 21,539 14,181 14,350 14,335 12,172 9,343 37 Nondispensable/Restricted/ Committed (8,074) (489) - - - - - 38 Funding Adjustment (709) - - - - - 39 Ending Fund Balance 21,539 14,181 14,350 14,335 12,172 9,343 5,771 40 Reserve @ 20% Operating Costs (11,476) (10,851) (10,708) (10,767) (11,245) (11,501) (11,780) 41 Designated Reserve - - - - - 42 Reserve Over/(Under) Policy Level 10,063 3,330 3,642 3,567 927 (2,158) (6,009) Five Year Forecast 17-19 Financial Plan Attachment A to Exhibit 1 Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 5 FUND 2017-18 2018-19Airport Area Impact Fee 55,000$ 750,000$ Community Development Block Grant Fund 105,000$ -$ Fleet Replacement Fund 495,000$ 434,000$ General CIP Grant Fund 1,020,000$ 13,607,453$ General Purpose CIP 214,000$ 358,547$ Information Technology Replacement Fund 304,000$ 1,294,294$ Local Revenue Measure Sub-Fund 5,076,700$ 5,002,323$ Major Facility Replacement Fund 52,200$ 144,200$ Parking Fund 825,000$ 650,000$ Parkland Development Fund 85,000$ 179,000$ Public Art Fund 124,700$ 126,700$ Sewer Fund 22,042,500$ 58,162,000$ Transit Fund 335,000$ 1,085,000$ Transportation Impact Fee 310,500$ 1,369,000$ Water Fund 3,277,500$ 9,362,100$ Whale Rock Fund 520,000$ 36,000$ TOTAL 34,842,100$ 92,560,617$ CAPITAL IMPROVEMENT PLAN - SUMMARY BY FUND Airport Area Impact Fee1% Community Development Block Grant Fund0% Fleet Replacement Fund1% General CIP Grant Fund11% General Purpose CIP0%Information Technology Replacement Fund1% Local Revenue Measure Sub-Fund8%Major Facility ReplacementFund0%Parking Fund1%Parkland Development Fund0% Public Art Fund0%Sewer Fund63% Transit Fund1% Transportation Impact Fee1%Water Fund10% Whale Rock Fund0% 2017-19 CIP by FUND Attachment B to Exhibit 1 Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 6 2017-18 2018-19 2019-20 2020-21 2021-22 Airport Area Impact Fee 55,000$ 750,000$ -$ -$ -$ Airport Area Impact Fee Total 55,000$ 750,000$ -$ -$ -$ State or Federal Grant 105,000$ -$ 250,000$ 250,000$ 250,000$ CDBG Fund Total 105,000$ -$ 250,000$ 250,000$ 250,000$ Debt Financing 465,000$ 359,000$ -$ 410,000$ -$ Fleet Replacement Fund 30,000$ 75,000$ General Capital Outlay -$ -$ 784,000$ 519,000$ 522,000$ Fleet Replacement Fund Total 495,000$ 434,000$ 784,000$ 929,000$ 522,000$ State or Federal Grant 600,000$ 13,327,453$ -$ 390,500$ 16,380,600$ SB-1 318,000$ 180,000$ -$ -$ -$ Zone 9 - County Grant 102,000$ 100,000$ 100,000$ 100,000$ 100,000$ General CIP Grant Fund Total 1,020,000$ 13,607,453$ 100,000$ 490,500$ 16,480,600$ Developer Contribution -$ 97,547$ 1,350,000$ General Capital Outlay 214,000$ 261,000$ 3,786,780$ 3,514,500$ 3,690,700$ General Purpose CIP Total 214,000$ 358,547$ 5,136,780$ 3,514,500$ 3,690,700$ General Capital Outlay 189,255$ 1,078,977$ 525,000$ 550,968$ 579,000$ Parking Fund 6,633$ 18,854$ 4,069$ 633$ 9,749$ Sewer Fund 14,923$ 71,780$ 307,876$ 4,260$ 25,873$ State or Federal Grant 65,000$ -$ -$ -$ -$ Transit Fund 3,317$ 56,570$ 2,035$ 982$ 2,248$ Water Fund 22,662$ 52,150$ 24,287$ 1,848$ 29,419$ Whale Rock Fund 2,210$ 15,963$ 1,356$ 409$ 417$ Information Tech. Replacement Fund Total 304,000$ 1,294,294$ 864,623$ 559,100$ 646,706$ 2017-19 Financial Plan Proposed Airport Area Impact Fee Fleet Replacement Fund General CIP Grant Fund General Purpose CIP Community Development Block Grant (CDBG) Fund CAPITAL IMPROVEMENT PLAN - SUMMARY BY FUND & FUNDING SOURCE Information Technology Replacement Fund Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 7 2017-18 2018-19 2019-20 2020-21 2021-222017-19 Financial Plan Proposed CAPITAL IMPROVEMENT PLAN - SUMMARY BY FUND & FUNDING SOURCE Measure G Revenue 3,288,300$ 3,539,600$ -$ -$ -$ Measure G Revenue - Information Technology 536,500$ 182,023$ -$ -$ -$ Measure G Revenue - Major Facility Replacement 483,900$ 507,700$ -$ -$ -$ Measure G Revenue - Fleet Replacement 638,000$ 508,000$ -$ -$ -$ Measure G Revenue - Fleet Debt 130,000$ 265,000$ -$ -$ -$ Local Revenue Measure Sub-Fund Total 5,076,700$ 5,002,323$ -$ -$ -$ General Capital Outlay 45,000$ 101,000$ 821,900$ 288,000$ 162,200$ Sewer Fund 3,600$ 21,600$ -$ -$ -$ Water Fund 3,600$ 21,600$ -$ -$ -$ Major Facility Replacement Fund Total 52,200$ 144,200$ 821,900$ 288,000$ 162,200$ Debt Financing 17,600,000$ Parking Fund 825,000$ 650,000$ 6,000,000$ 70,000$ -$ Parking Fund Total 825,000$ 650,000$ 23,600,000$ 70,000$ -$ Park In-Lieu Fees 85,000$ 179,000$ -$ -$ -$ Parkland Development Fund Total 85,000$ 179,000$ -$ -$ -$ Art In Lieu Fee 15,000$ 15,000$ 15,000$ 15,000$ 15,000$ General Capital Outlay 109,700$ 111,700$ 50,020$ 50,500$ 52,300$ Public Art Fund Total 124,700$ 126,700$ 65,020$ 65,500$ 67,300$ Sewer Fund 22,042,500$ 58,162,000$ 37,140,000$ 30,906,000$ 4,065,000$ Sewer Fund Total 22,042,500$ 58,162,000$ 37,140,000$ 30,906,000$ 4,065,000$ State or Federal Grant 335,000$ 25,000$ 25,000$ 25,000$ 25,000$ Transit Fund -$ 1,060,000$ 1,590,000$ 1,590,000$ 250,000$ Transit Fund Total 335,000$ 1,085,000$ 1,615,000$ 1,615,000$ 275,000$ Parkland Development Fund Public Art Fund Local Revenue Measure Sub-Fund Major Facility Replacement Fund Parking Fund Sewer Fund Transit Fund Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 8 2017-18 2018-19 2019-20 2020-21 2021-222017-19 Financial Plan Proposed CAPITAL IMPROVEMENT PLAN - SUMMARY BY FUND & FUNDING SOURCE Debt Financing 12,500,000$ Transportation Impact Fee - Fund Balance 60,500$ 1,119,000$ 1,400,000$ 60,000$ -$ Transportation Impact Fee 250,000$ 250,000$ -$ -$ -$ Transportation Impact Fee Total 310,500$ 1,369,000$ 1,400,000$ 60,000$ 12,500,000$ Water Fund 3,277,500$ 9,362,100$ 17,141,000$ 2,784,000$ 2,149,000$ Water Fund Total 3,277,500$ 9,362,100$ 17,141,000$ 2,784,000$ 2,149,000$ Whale Rock Fund 520,000$ 36,000$ -$ -$ 60,000$ Whale Rock Fund Total 520,000$ 36,000$ -$ -$ 60,000$ TOTAL 34,842,100$ 92,560,617$ 88,918,323$ 41,531,600$ 40,868,506$ Transportation Impact Fee Water Fund Whale Rock Fund Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 9 2017-18 2018-19 Community & Neighborhood Livability 170,000$ 425,000$ Community Safety 390,000$ 578,600$ Culture & Recreation 620,000$ 416,700$ Environmental Health & Open Space 20,789,000$ 68,098,000$ Infrastructure & Transportation 12,873,100$ 23,042,317$ TOTAL 34,574,100$ 92,560,617$ CAPITAL IMPROVEMENT PLAN - SUMMARY BY FUNCTION Community & Neighborhood Livability 0% Community Safety 1% Culture & Recreation 1% Environmental Health & Open Space 70% Infrastructure & Transportation 28% 2017-19 CIP by FUNCTION Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 10 PAGE #FUNCTION, CATEGORY, & PROJECT NAME2017-18 2018-19 2019-20 2020-21 2021-22Neighborhood WellnessE2-1Mission Plaza Railing Upgrade-$ 30,000$ -$ 35,000$ 15,000$ E2-3Mission Plaza Restroom Replacements and Enhancements-$ 25,000$ 45,000$ E2-5Park Major Replacement & Repairs 170,000$ 290,000$ 215,000$ 315,000$ 15,000$ E2-11Playground Equipment Replacement-$ 80,000$ 350,000$ 25,000$ 150,000$ COMMUNITY & NEIGHBORHOOD LIVABILITY Total 170,000$ 425,000$ 610,000$ 375,000$ 180,000$ Fire SafetyE2-12Fire Station 4 Emergency Backup Generator7,000$ 72,500$ -$ -$ Police ProtectionE2-14Police Department Space Improvements 35,000$ 89,000$ 279,000$ -$ -$ E2-16Police Station Replacement 15,000$ StormwaterE2-18Silt Removal102,000$ 100,000$ 100,000$ 100,000$ 100,000$ E2-20Storm Drain System Replacement231,000$ 317,100$ 111,780$ 253,500$ 471,300$ COMMUNITY SAFETY Total 390,000$ 578,600$ 490,780$ 353,500$ 571,300$ Cultural ServicesE2-23City/County Library Major Maint. & ADA Compliance405,300$ -$ -$ -$ -$ E2-25Public Art Fund49,700$ 51,700$ 50,020$ 50,500$ 52,300$ E2-27Public Art Master Planning Initiatives75,000$ 75,000$ 15,000$ 15,000$ 15,000$ Recreational ServicesE2-29Parks and Recreation Interior Office Rehabilitation5,000$ 111,000$ -$ -$ E2-31Pickleball Courts (formerly New Park Amenitites60,000$ E2-33Sinsheimer Park Tennis Court Lighting25,000$ 179,000$ CULTURE & RECREATION Total 620,000$ 416,700$ 65,020$ 65,500$ 67,300$ Environmental ProtectionE2-35Green Fleet Vehicle Charging Stations30,000$ 75,000$ E2-37Ongoing Open Space Maintenance60,000$ 60,000$ 60,000$ 60,000$ 60,000$ E2-39Water Resource Recovery Facility Project19,709,000$ 56,500,000$ 35,000,000$ 29,000,000$ E2-41Water Treatment - Energy Efficiency450,000$ 8,500,000$ 5,800,000$ E2-43Water Treatment - Major Facility Maintenance360,000$ 163,000$ 171,000$ 179,000$ 189,000$ E2-45Water Treatment - Tank Maintenance40,000$ 275,000$ 50,000$ OpenSpaceE2-47Laguna Lake Dredging and Sediment Management Project Implementation40,000$ 200,000$ 250,000$ 300,000$ 350,000$ E2-49Open Space Acquisition100,000$ 2,600,000$ 100,000$ 150,000$ 200,000$ ENVIRONMENTAL HEALTH & OPEN SPACE Total 20,789,000$ 68,098,000$ 41,656,000$ 29,739,000$ 799,000$ CAPITAL IMPROVEMENT PLAN - MASTER LIST BY FUNCTIONCOMMUNITY & NEIGHBORHOOD LIVABILITYCOMMUNITY SAFETYCULTURE & RECREATIONENVIRONMENTAL HEALTH & OPEN SPACE2017-19 Financial PlanProposedResolution No. 10815 (2017 Series) EXHIBIT 1Page 11 PAGE #FUNCTION, CATEGORY, & PROJECT NAME2017-18 2018-19 2019-20 2020-21 2021-22CAPITAL IMPROVEMENT PLAN - MASTER LIST BY FUNCTION2017-19 Financial PlanProposedFacilitiesE2-51City Facility Parking Lot Maintenance 120,000$ -$ 100,000$ 200,000$ E2-53Corporation Yard TI -$ 50,000$ -$ -$ E2-55Major Facility Replacement 536,100$ 651,900$ 821,900$ 288,000$ 162,200$ Information TechnologyE2-62IT Replacement 840,500$ 1,476,317$ 864,623$ 559,100$ 646,706$ E2-165Multimodal Transportation2015 Traffic Safety Report Implementation 60,000$ 175,000$ -$ -$ E2-89Active Transportation Plan 40,000$ -$ -$ -$ -$ E2-91Bicycle Facility Improvements 100,000$ 100,000$ 100,000$ 110,000$ 110,000$ E2-92Bob Jones Trail Prefumo Creek Connection to Oceanaire -$ 1,060,000$ 1,000$ 1,000$ 1,000$ E2-94Broad Street Bicycle Boulevard 18,000$ 180,000$ 270,000$ E2-96Broad Street Corridor Access Improvements 25,000$ 45,000$ -$ -$ E2-98California & Taft Roundabout 60,000$ 1,000,000$ E2-100Higuera St. Widening - Bridge to Elks & Fontana to Chumash 35,500$ 330,000$ E2-79Marsh Street Parking Structure Maintenance 575,000$ -$ -$ -$ -$ E2-104Neighborhood Traffic Improvements 75,000$ 75,000$ 75,000$ 75,000$ 75,000$ E2-102Orcutt & Tank Farm Roundabout 100,000$ E2-81Palm - Nipomo Parking Structure 250,000$ -$ 23,600,000$ -$ -$ E2-83Parking Access Revenue Control System -$ 650,000$ -$ -$ -$ E2-106Pedestrian and Bicycle Pathway Maintenance60,000$ 60,000$ 35,000$ 80,000$ 50,000$ E2-108Penny Lane Bridge at Union Pacific Railroad (UPRR)50,000$ E2-110Prado Road Bridge & Road Widening 595,000$ 9,750,000$ E2-112Prado Road Interchange 150,000$ 840,000$ 2,700,000$ 28,000,000$ E2-114Railroad Safety Trail (RRST) - Pepper Street to the Train Station-$ 30,000$ 140,000$ -$ -$ E2-116Safe Routes to School Implementation Foothill Crossing300,000$ E2-85Transit - Automatic Vehicle Location System310,000$ -$ -$ -$ -$ E2-87Transit - Bus Shelter Replacement25,000$ 25,000$ 25,000$ 25,000$ 25,000$ E2-89Transportation Safety & Operations 30,000$ 90,000$ 30,000$ 90,000$ 30,000$ E2-65Fleet Replacement1,348,000$ 2,287,000$ 2,889,000$ 2,810,000$ 997,000$ Roadway InfrastructureE2-120Bridge Maintenance -$ 50,000$ 100,000$ 75,000$ 75,000$ E2-122Bridge Replacement - Chorro Street -$ -$ -$ 363,000$ E2-124Bridge Replacement - Madonna Road -$ -$ -$ -$ 451,000$ E2-126Bridge Replacement - Nipomo Street390,500$ 160,000$ E2-129Downtown Renewal190,000$ 60,000$ -$ E2-139New Street Lights20,000$ 20,000$ 20,000$ 20,000$ E2-132Sidewalk Replacement and Installation130,000$ 50,000$ 275,000$ 400,000$ 350,000$ E2-135Street Reconstruction & Resurfacing 1,600,000$ 1,600,000$ 1,600,000$ 1,600,000$ 1,600,000$ E2-137Traffic Signs & Striping Maintenance25,000$ 25,000$ 75,000$ 75,000$ INFRASTRUCTURE & TRANSPORTATIONResolution No. 10815 (2017 Series) EXHIBIT 1Page 12 PAGE #FUNCTION, CATEGORY, & PROJECT NAME2017-18 2018-19 2019-20 2020-21 2021-22CAPITAL IMPROVEMENT PLAN - MASTER LIST BY FUNCTION2017-19 Financial PlanProposedUtility ServicesE2-150LAN Tablet System 34,100$ E2-141Wastewater Collection System Improvements 1,250,000$ 1,474,000$ 1,570,000$ 1,630,000$ 1,870,000$ E2-146Wastewater Collection Telemetry System Improvements 100,000$ 38,000$ -$ -$ -$ E2-148Wastewater Lift Station Replacement 1,085,000$ -$ -$ -$ 1,980,000$ E2-152Water Distribution System Improvements 2,390,000$ 470,000$ 450,000$ 2,610,000$ 2,010,000$ E2-157Water Distribution Telemetry System Improvements 50,000$ 50,000$ -$ -$ -$ E2-159Water Storage Resevoir Replacement 200,000$ 10,500,000$ E2-161Whale Rock Pipeline Reliability Assessment 500,000$ E2-163Whale Rock Resevoir Automoatic Control Valve Replacement 36,000$ INFRASTRUCTURE & TRANSPORTATION Total 12,873,100$ 23,042,317$ 46,096,523$ 10,998,600$ 39,250,906$ TOTAL 34,842,100$ 92,560,617$ 88,918,323$ 41,531,600$ 40,868,506$ Resolution No. 10815 (2017 Series) EXHIBIT 1Page 13 CHANGES IN FINANCIAL POSITION ALL FUNDS COMBINED Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Tax Revenues 56,318,548 56,640,730 58,035,218 2% 59,710,423 3% Fines and Forfeitures 752,176 825,900 734,900 -11% 740,800 1% Investment and Property Revenues 1,932,386 465,400 512,898 10% 516,898 1% Subventions and Grants 14,581,707 20,921,552 5,641,605 -73% 18,858,083 234% Service Charges Governmental Funds 13,659,017 11,423,383 11,573,271 1% 11,493,599 -1% Enterprise Funds 42,991,282 39,794,789 41,030,083 3% 42,131,220 3% Trust and Agency Revenues 1,135,935 1,140,205 1,310,950 15% 1,177,691 -10% Other Revenues 1,031,450 166,100 500,360 201% 550,431 10% Total Revenues 132,402,501 131,378,059 119,339,285 -9% 135,179,146 13% Expenditures Operating Programs Community Safety 25,718,455 26,902,897 29,782,942 11% 30,536,947 3% Public Utilities ---- Infrastructure & Transportation 27,669,793 34,427,550 30,290,423 -12% 30,864,742 2% Community & Neighborhood Livability 8,433,268 10,245,126 9,074,845 -11% 8,815,479 -3% Culture & Recreation 7,505,856 8,627,251 3,613,123 -58% 3,858,583 7% Environmental Health & Open Space -- 8,673,430 8,811,479 2% Fiscal Health & Governance 22,835,600 27,306,548 22,279,840 -18% 22,384,524 0% CalPERS Discount Rate ---432,211 Total Operating Programs 92,162,971 107,509,372 103,714,603 -4% 105,703,965 2% Capital Improvement Plan Projects 26,717,422 72,506,914 34,842,100 -52% 92,560,707 166% Reimbursed Expenditures (4,008,992) (4,164,747) (4,264,633) 2% (4,264,633) Debt Service 7,668,076 7,844,645 7,969,872 2% 8,860,368 11% Total Expenditures 122,539,478 183,696,184 142,261,942 -23% 202,860,407 43% Other Sources (Uses) Adjustment to Working Capial ---- Operating Transfers In 10,123,214 11,999,475 11,739,102 -2% 11,592,133 -1% Operating Transfers Out (9,950,118) (11,998,475) (11,738,759) -2% (11,592,133) -1% Proceeds from Debt Financings 688,500 1,166,600 20,095,000 1623% 65,624,000 227% Projected MOA Adjustments - (15,398) - -100%- GST Loan per Council Approval - (500,000) - -100%- Other Sources (Uses)---- Expenditure Savings - 1,428,944 1,268,462 -11% 1,300,000 2% Total Other Sources (Uses)861,596 2,081,146 21,363,805 927% 66,924,000 213% Revenues and Other Sources Over (Under) Expenditures and Other Uses 10,724,619 (50,236,979) (1,558,852) -97% (757,262) -51% Fund Balance/Working Capital, Beginning of Year 108,867,259 119,556,437 68,830,458 -42% 67,271,607 -2% Non-Dispensible Restricted (489,000) -100% Fund Balance/Working Capital, End of Year Prior Year Restatement (709,020) --- Adjustment for Long Term Accruals (35,441) --- Reserved for Debt Service 2,119,724 2,119,724 2,119,723 0% 2,119,721 0% Unreserved 48,130,091 66,710,735 65,151,884 -2% 64,394,625 -1% Total Fund Balance/Working Capital 119,556,437 68,830,458 67,271,607 -2% 66,514,345 -1% 2017-19 Financial Plan % Change % Change Attachment C to Exhibit 1 Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 14 CHANGES IN FINANCIAL POSITION ALL GOVERNMENTAL FUNDS COMBINED Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Tax Revenues 56,318,548 56,640,730 58,035,218 2% 59,710,423 3% Fines and Forfeitures 172,353 156,000 147,600 -5% 147,600 Investment and Property Revenues 630,908 308,600 356,098 15% 356,098 Subventions and Grants 11,692,887 16,750,282 2,719,968 -84% 15,052,325 453% Service Charges 13,659,017 11,423,383 11,573,271 1% 11,493,599 -1% Other Revenues 272,299 72,500 170,660 135% 210,660 23% Total Revenues 82,746,011 85,351,495 73,002,815 -14% 86,970,706 19% Expenditures Operating Programs1 Community Safety 25,718,455 26,902,897 29,782,942 11% 30,536,947 3% Infrastructure & Transportation 3,146,156 4,050,322 11,281,049 179% 11,443,756 1% Culture & Recreation 7,505,856 8,619,751 3,605,623 -58% 3,851,083 7% Community & Neighborhood Livability 8,433,268 10,245,126 8,558,952 -16% 8,283,932 -3% Environmental Health & Open Space - - 1,023,313 1,044,495 2% Fiscal Health & Governance 16,698,171 22,138,801 14,976,666 -32% 14,968,836 0% CalPERS Discount Rate - - - 375,000 Total Operating Programs 61,501,905 71,956,897 69,228,545 -4% 70,504,049 2% Reimbursed Expenditures (4,008,992) (4,164,747) (4,264,633) 2% (4,264,633) Total Operating Expenditures 57,492,913 67,792,150 64,963,912 -4% 66,239,416 2% Capital Improvement Plan Projects 19,102,153 40,473,435 7,842,100 -81% 23,265,607 197% Debt Service 3,101,381 3,245,866 3,374,758 4% 3,506,210 4% Total Expenditures 79,696,448 111,511,451 76,180,770 -32% 93,011,233 22% Other Sources (Uses) Operating Transfers In 7,826,118 10,259,577 10,989,102 7% 11,092,133 1% Operating Transfers Out (8,514,070) (10,946,912) (9,732,193) -11% (9,362,660) -4% Proceeds from Debt Financings 688,500 1,166,600 595,000 -49% 624,000 5% Projected MOA Adjustments - - - Expenditure Savings - 1,428,944 1,268,462 -11% 1,300,000 2% Total Other Sources (Uses)548 1,908,209 3,120,371 64% 3,653,473 17% Revenues and Other Sources Over (Under) Expenditures and Other Uses 3,050,111 (24,251,747) (57,584) -100% (2,387,054) 4045% Fund Balance, Beginning of Year 47,908,724 50,249,815 25,509,068 -49% 25,451,485 0% Prior Year Restatement (709,020) - - - Non-Dispensable Restricted - (489,000) - -100%- 47,199,704 49,760,815 25,509,068 -49% 25,451,485 0% Fund Balance, End of Year Reserved for Debt Service 2,119,724 2,119,724 2,119,723 0% 2,119,721 0% Unreserved 48,130,091 23,389,344 23,331,762 0% 20,944,709 -10% Total Fund Balance 50,249,815 25,509,068 25,451,485 0% 23,064,430 -9% 1 Prior to 2017-18, Operating and Capital expenditures were categorized into different City Functions. 2017-19 Financial Plan % Change % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 15 CHANGES IN FINANCIAL POSITION ALL ENTERPRISE AND AGENCY FUNDS COMBINED Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Fines and Forfeitures 579,823 669,900 587,300 -12% 593,200 1% Investment and Property Revenues 1,301,478 156,800 156,800 160,800 3% From Other Governments 2,888,820 4,171,270 2,921,637 -30% 3,805,758 30% Service Charges 42,991,282 39,794,789 41,030,083 3% 42,131,220 3% Other Revenues 759,151 93,600 329,700 252% 339,771 3% Trust and Agency Revenues 1,135,935 1,140,205 1,310,950 15% 1,177,691 -10% Total Revenues 49,656,490 46,026,564 46,336,470 1% 48,208,440 4% Expenditures Operating Programs1 Community Safety - - - - Community & Neighborhood Livability - - 515,893 531,547 3% Environmental Health & Open Space - - 7,650,117 7,766,984 2% Infrastructure & Transportation 24,523,637 30,377,228 19,009,374 -37% 19,420,986 2% Culture & Recreation - 7,500 7,500 7,500 CalPERS Discount Rate - - - 57,211 Fiscal Health & Governance 6,137,429 5,167,747 7,303,174 41% 7,415,688 2% Total Operating Programs 30,661,066 35,552,475 34,486,058 -3% 35,199,916 2% Capital Improvement Plan Projects 7,615,269 32,033,479 27,000,000 -16% 69,295,100 157% Debt Service 4,566,695 4,598,779 4,595,114 0% 5,354,158 17% Total Expenditures 42,843,030 72,184,733 66,081,172 -8% 109,849,174 66% Other Sources (Uses) Adjustment to Working Capial - - - - Operating Transfers In 2,297,096 1,739,898 750,000 -57% 500,000 -33% Proceeds from Debt Financings - - 19,500,000 65,000,000 233% Operating Transfers Out (1,436,048) (1,051,563) (2,006,566) 91% (2,229,473) 11% GST Loan per Council Approval - (500,000) - -100% - Projected MOA Adjustments - (15,398) - -100% - Other Sources (Uses) - - - - Total Other Sources (Uses) 861,048 172,937 18,243,434 10449%63,270,527 247% Revenues and Other Sources Over (Under) Expenditures and Other Uses 7,674,508 (25,985,232) (1,501,268) -94% 1,629,793 -209% Working Capital, Beginning of Year 61,667,555 69,306,622 43,321,390 -37% 41,820,122 Adjustment for Long Term Accruals (35,441) Working Capital, End of Year 69,306,622 43,321,390 41,820,122 -3% 43,449,915 4% 1 Prior to 2017-18, Operating and Capital expenditures were categorized into different City Functions. 2017-19 Financial Plan % Change % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 16 CHANGES IN FINANCIAL POSITION GENERAL FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Tax Revenues 49,140,388 49,249,730 50,428,218 2% 52,031,423 3% Fines and Forfeitures 172,353 156,000 147,600 -5% 147,600 Investment and Property Revenues 380,946 281,700 264,798 -6% 264,798 Subventions and Grants 1,459,775 316,000 316,000 316,000 Service Charges 9,623,282 8,769,518 9,596,384 9% 9,484,425 -1% Other Revenues 86,259 55,000 130,660 138% 130,660 Total Revenues 60,863,003 58,827,948 60,883,660 3% 62,374,906 2% Expenditures Operating Programs 1 Community Safety 24,870,762 25,985,759 27,996,083 8% 28,679,650 2% Infrastructure & Transportation 2,291,830 2,734,553 10,766,356 294% 10,912,749 1% Culture & Recreation 7,311,138 8,137,529 3,605,623 -56% 3,851,083 7% Community & Neighborhood Livability 7,834,301 9,826,194 8,283,022 -16% 8,000,386 -3% Environmental Health & Open Space - - 878,628 892,427 2% Fiscal Health & Governance 15,080,806 20,425,177 13,409,321 -34% 13,396,029 0% CalPERS Discount Rate - - - 375,000 Total Program Expenditures 57,388,837 67,109,212 64,939,032 -3% 66,107,324 2% Reimbursed Expenditures (4,008,992) (4,164,747) (4,264,633) 2% (4,264,633) Total Expenditures 53,379,845 62,944,465 60,674,399 -4% 61,842,691 2% Other Sources (Uses) Operating Transfers In 2,920,748 2,353,342 3,398,300 44% 3,259,635 -4% Proceeds from Debt Issuance - - - - Operating Transfers Out (6,975,470) (9,605,233) (4,707,714) -51% (5,148,535) 9% Expenditure Savings 1,428,944 1,268,462 -11% 1,300,000 2% Other Sources - - - - Total Other Sources (Uses) (4,054,722) (5,822,947) (40,952) -99% (588,900) 1338% Revenues and Other Sources Over (Under) Expenditures and Other Uses 3,428,437 (9,939,464) 168,309 -102% (56,685) -134% Transfer to Local Revenue Measure Fund Fund Balance, Beginning of Year 22,140,527 24,859,944 14,431,480 -42% 14,599,789 1% Prior Year Restatement (709,020) - - - Non-Dispensible Restricted - (489,000) Fund Balance, End of Year sub-total 24,859,944 14,431,480 14,599,789 1% 14,543,104 0% Fund Balance Components: Designated Reserves (4,112,465) Policy Reserve Level @ 20%:(11,475,178) (10,851,000) (10,708,080) -1% (10,777,000) 1% Amount Over (Under) Policy Reserve: 9,272,301 3,580,480 3,891,709 9% 3,766,104 -3% 1 Prior to 2017-18, Operating and Capital expenditures were categorized into different City Functions. 2017-19 Financial Plan % Change % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 17 CHANGES IN FINANCIAL POSITION LOCAL REVENUE MEASURE SUB-FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Tax Revenues 7,178,160 7,391,000 7,607,000 3% 7,679,000 1% Investment & Property Revenue 9,043 - - - Total Revenues 7,187,203 7,391,000 7,607,000 3%7,679,000 1% Expenditures Operating Programs Community Safety 705,843 812,655 1,786,859 120% 1,857,297 4% Infrastructure & Transportation 854,326 1,315,769 514,693 -61% 531,007 3% Culture & Recreation 194,718 208,187 - -100% - Community & Neighborhood Livability 328,737 5,000 83,520 1570% 84,563 1% Environmental Health & Open Space 144,685 152,068 5% Fiscal Health & Governance - - - - Capital Improvement Plan Projects 2,797,460 10,030,836 4,946,700 -51% 4,737,323 -4% Total Expenditures 4,881,084 12,372,447 7,476,458 -40%7,362,258 -2% Other Sources (Uses) Operating Transfers In - - 1,658,400 1,197,723 Operating Transfers Out - - (1,788,400) (1,462,723) -18% Total Other Sources (Uses)- - (130,000) (265,000) 104% Revenues and Other Sources Over (Under) Expenditures and Other Uses 2,306,119 (4,981,447) 542 -100% 51,742 9442% Fund Balance, Beginning of Year 2,426,279 4,732,398 (249,049) -105% (248,507) 0% Fund Balance, End of Year sub-total* 4,732,398 (249,049) (248,507) 0%(196,765) -21% Fund Balance Components: Reserved (3,962,736) Unreserved 769,662 *20% Reserve fund balance is fully reported/calculated within General Fund Changes in Financial Position. Expenditures may be adjusted at each year-end to maintain the sub-fund balance above negative and the difference will be absorbed by the General Fund. % Change % Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 18 CHANGES IN FINANCIAL POSITION INSURANCE BENEFIT Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenue 987 - - - Service Charges - - - Total Revenues 987 - - - Expenditures Operating Programs Fiscal Health & Governance 2,128,437 1,000,000 1,000,000 1,000,000 Capital Improvement Plan Projects - - - - Total Expenditures 2,128,437 1,000,000 1,000,000 1,000,000 Other Sources (Uses) Operating Transfer In 2,124,000 1,739,898 750,000 -57% 500,000 -33% Operating Transfer Out - - - Total Other Sources (Uses) 2,124,000 1,739,898 750,000 -57%500,000 -33% Revenues and Other Sources Over (Under) Expenditures and Other Uses (3,450) 739,898 (250,000) -134% (500,000) 100% Fund Balance, Beginning of Year 343,301 339,851 1,079,749 218% 829,749 -23% Fund Balance, End of Year 339,851 1,079,749 829,749 -23%329,749 -60% % Change % Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 19 CHANGES IN FINANCIAL POSITION DOWNTOWN BUSINESS IMPROVEMENT DISTRICT FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenues Service Charges Assessments 222,111 214,000 227,000 6% 227,000 Other Service Charges - - - Total Service Charges 222,111 214,000 227,000 6% 227,000 Other Revenues Total Revenues 222,111 214,000 227,000 6% 227,000 Expenditures Operating Programs Fiscal Health & Governance 222,111 214,000 227,000 6% 227,000 Capital Improvement Plan Projects - - - - Total Expenditures 222,111 214,000 227,000 6% 227,000 Other Sources (Uses) Operating Transfer In Operating Transfer Out - - Total Other Sources (Uses) - - - - Revenues and Other Sources Over (Under) Expenditures and Other Uses - - - - Fund Balance, Beginning of Year 1,122 1,122 1,122 1,122 Prior Year Restatement Fund Balance, End of Year 1,122 1,122 1,122 1,122 % Change % Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 20 CHANGES IN FINANCIAL POSITION TOURISM BUSINESS IMPROVEMENT DISTRICT FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenues 1,723 1,100 1,400 27% 1,400 Service Charges 1,429,190 1,433,975 1,464,387 2% 1,493,675 2% Total Revenues 1,430,913 1,435,075 1,465,787 2% 1,495,075 2% Expenditures Operating Programs Fiscal Health & Governance 1,395,253 1,499,624 1,340,345 -11% 1,345,807 0% Capital Improvement Plan Projects - - - - Total Expenditures 1,395,253 1,499,624 1,340,345 -11% 1,345,807 0% Other Sources (Uses) Operating Transfer In - - - - Operating Transfer Out (28,412) (28,679) (27,679) -3% (28,679) 4% Total Other Sources (Uses) (28,412) (28,679) (27,679) -3% (28,679) 4% Revenues and Other Sources Over (Under) Expenditures and Other Uses 7,247 (93,228) 97,763 -205% 120,589 23% Fund Balance, Beginning of Year 333,028 340,275 247,047 -27% 344,810 40% Prior Year Restatement Fund Balance, End of Year 340,275 247,047 344,810 40% 465,399 35% % Change % Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 21 CHANGES IN FINANCIAL POSITION COMMUNITY DEVELOPMENT BLOCK GRANT (CDBG) FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues From Other Governments CDBG Allocation*304,004 597,863 232,623 -61%- -1 Other Revenues - - - - Total Revenues 304,004 597,863 232,623 -61%- -100% Expenditures Operating Programs Community & Neighborhood Livability 270,230 413,932 192,410 -54% 198,983 3% Fiscal Health & Governance - - - - Total Operating Programs 270,230 413,932 192,410 -54% 198,983 3% Capital Improvement Plan Projects 164,853 337,899 105,000 -69% - -100% Debt Service Total Expenditures 435,083 751,831 297,410 -60% 198,983 -33% Other Sources (Uses) Operating Transfer In 147,487 153,969 154,000 0% 154,000 Total Other Sources (uses) 147,487 153,969 154,000 0% 154,000 Revenues and Other Sources Over (Under) Expenditures and Other Uses 16,408 1 89,213 8921200% (44,983) -150% Fund Balance, Beginning of Year (83) 16,325 16,326 0% 105,539 546% Fund Balance, End of Year 16,325 16,326 105,539 546%60,556 -43% *The City will have more information whether fund are available in 2018-19 by the end of fiscal year 2017-18. No revenues are expected in 2018-19 at this time. % Change 2017-19 Financial Plan % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 22 CHANGES IN FINANCIAL POSITION GAS TAX FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues From Other Governments - Gasoline Tax 1,033,757 965,000 965,000 965,000 Total Revenues 1,033,757 965,000 965,000 965,000 Other Sources (Uses) Operating Transfers Out (1,033,757) (965,000) (965,000) (965,000) Total Other Sources (Uses) (1,033,757) (965,000) (965,000) (965,000) Revenues and Other Sources Over (Under) Expenditures and Other Uses - - - - Fund Balance, Beginning of Year - - - - Fund Balance, End of Year - - - - In March 2010,the Legislature passed ABx8 6 and ABx8 9, which contained the provisions for a swap of Proposition 42 state sales tax on gasoline with allocations from the motor vehicle excise tax (gas tax). % Change % Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 23 CHANGES IN FINANCIAL POSITION TRANSPORTATION DEVELOPMENT ACT (TDA) FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Subventions and Grants 40,531 41,100 45,000 9% 45,000 Total Revenues 40,531 41,100 45,000 9% 45,000 Other Sources (Uses) Operating Transfers Out (40,531) (41,100) (45,000) 9% (45,000) Total Other Sources (Uses) (40,531) (41,100) (45,000) 9% (45,000) Revenues and Other Sources Over (Under) Expenditures and Other Uses - - - - Fund Balance, Beginning of Year - - - - Fund Balance, End of Year - - - - % Change % Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 24 CHANGES IN FINANCIAL POSITION LAW ENFORCEMENT GRANTS FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenues 12 - - - Subventions and Grants 206,831 105,708 81,345 -23% 21,325 -74% Service Charges 1,782 69,000 - -100% - Total Revenues 208,625 174,708 81,345 -53%21,325 -74% Expenditures Operating Programs Community Safety 141,850 104,483 - -100% - Capital Improvement Plan Projects 60,169 69,607 - -100% - Total Expenditures 202,019 174,090 - -100%- Other Sources (Uses) Operating Transfer In - - - - Operating Transfer Out - - - - Total Other Sources (Uses) - - - Revenues and Other Sources Over (Under) Expenditures and Other Uses 6,606 618 81,345 13063% 21,325 -74% Fund Balance, Beginning of Year 16,886 23,492 24,110 3% 105,455 337% Fund Balance, End of Year 23,492 24,110 105,455 337% 126,780 20% % Change 2017-19 Financial Plan % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 25 CHANGES IN FINANCIAL POSITION PUBLIC ART (PRIVATE SECTOR CONTRIBUTIONS) FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenues 2,892 2,100 2,100 2,100 Service Charges In-lieu fees - 40,000 35,500 -11% 38,500 8% Other Revenues 79,994 - - - Total Revenues 82,886 42,100 37,600 -11% 40,600 8% Expenditures Operating Programs Cultural & Recreation 274,035 -100% Capital Improvement Plan Projects 58,321 40,061 124,700 211% 126,700 2% Total Expenditures 58,321 314,096 124,700 -60%126,700 2% Other Sources (Uses) Operating Transfer In 36,400 39,900 - -100% - Operating Transfer Out Total Other Sources (Uses) 36,400 39,900 - -100%- Revenues and Other Sources Over (Under) Expenditures and Other Uses 60,965 (232,096) (87,100) -62% (86,100) -1% Fund Balance, Beginning of Year 362,844 423,809 191,713 -55% 104,613 -45% Fund Balance, End of Year 423,809 191,713 104,613 -45% 18,513 -82% % Change 2017-19 Financial Plan % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 26 CHANGES IN FINANCIAL POSITION GENERAL PURPOSE CIP Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Subventions and Grants 8,574,127 12,124,611 1,020,000 -92% 13,705,000 1244% Service Charges - - - - Other Revenues 2,506 - - - Total Revenues 8,576,633 12,124,611 1,020,000 -92%13,705,000 1244% Expenditures Capital Improvement Plan Projects 9,972,831 15,499,077 1,234,000 -92% 13,966,000 1032% Total Expenditures 9,972,831 15,499,077 1,234,000 -92% 13,966,000 1032% Other Sources (Uses) Operating Transfers In 281,733 439,900 263,700 -40% 257,400 -2% Operating Transfers Out (53,900) (39,900) -100% Other Sources (Uses) - - Sale of Surplus Property - - Total Other Sources (Uses) 227,833 400,000 263,700 -34% 257,400 -2% Revenues and Other Sources Over (Under) Expenditures and Other Uses (1,168,365) (2,974,466) 49,700 -102% (3,600) -107% Fund Balance, Beginning of Year 4,352,266 3,183,901 209,435 -93% 259,135 24% Prior Year Restatement Fund Balance, End of Year 3,183,901 209,435 259,135 24% 255,535 -1% % Change% Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 27 CHANGES IN FINANCIAL POSITION PARKLAND DEVELOPMENT FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenues 5,756 3,000 3,900 30% 3,900 Subventions and Grants - - - Service Charges Park In-Lieu Fees 174,799 - - - Dwelling Unit Fees 7,950 - - - Other Revenues 34,320 - - - Total Revenues 222,825 3,000 3,900 30% 3,900 Expenditures Capital Improvement Plan Projects 1,572 252,697 85,000 -66% 179,000 111% Total Expenditures 1,572 252,697 85,000 -66%179,000 111% Other Sources (Uses) Operating Transfers In - 900,000 - -100% Operating Transfers Out - - (160,000) -100% Total Other Sources (Uses)- 900,000 (160,000) -118% - -100% Revenues and Other Sources Over (Under) Expenditures and Other Uses 221,253 650,303 (241,100) -137% (175,100) -0.27374533 Fund Balance, Beginning of Year 620,558 841,811 1,492,114 77% 1,251,014 -16% Fund Balance, End of Year 841,811 1,492,114 1,251,014 -16% 1,075,914 -14% % Change % Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 28 CHANGES IN FINANCIAL POSITION TRANSPORTATION IMPACT FEE FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenue 107,807 1,000 46,000 4500% 46,000 Subventions and Grants - - Impact Fees 1,356,158 889,990 250,000 -72% 250,000 Other Revenues - - Total Revenues 1,463,965 890,990 296,000 -67% 296,000 Expenditures Capital Improvement Plan Projects 3,803,935 3,734,040 310,500 -92% 1,369,000 341% Total Expenditures 3,803,935 3,734,040 310,500 -92% 1,369,000 341% Other Sources (Uses) Proceeds from Debt Financing - - Operating Transfer In - - Operating Transfer Out (320,000) (250,000) (250,000) (250,000) Total Other Sources (Uses) (320,000) (250,000) (250,000) (250,000) Revenues and Other Sources Over (Under) Expenditures and Other Uses (2,659,970) (3,093,050) (264,500) -91% (1,323,000) 400% Fund Balance, Beginning of Year 8,879,649 6,219,679 3,126,629 -50% 2,862,129 -8% Prior Year Restatement Fund Balance, End of Year 6,219,679 3,126,629 2,862,129 -8% 1,539,129 -46% % Change % Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 29 CHANGES IN FINANCIAL POSITION FLEET REPLACEMENT FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenues 13,625 6,000 10,000 67% 10,000 Service Charges - Other Revenues - Sale of Surplus Property 69,220 10,000 40,000 300% 80,000 100% Green Vehicle Rebates 7,500 -100% Total Revenues 82,845 23,500 50,000 113%90,000 80% Expenditures Capital Improvement Plan Projects 686,387 2,154,331 625,000 -71% 699,000 12% Total Expenditures 686,387 2,154,331 625,000 -71% 699,000 12% Other Sources (Uses) Proceeds from Debt Financing - 1,166,600 595,000 -49% 624,000 5% Operating Transfers Out - - (768,000) (773,000) 1% Operating Transfers In 384,100 - 768,000 773,000 1% Total Other Sources (Uses) 384,100 1,166,600 595,000 -49% 624,000 5% Revenues and Other Sources Over (Under) Expenditures and Other Uses (219,442) (964,231) 20,000 -102% 15,000 -25% Fund Balance, Beginning of Year 2,029,047 1,809,605 845,374 -53% 865,374 2% Fund Balance, End of Year 1,809,605 845,374 865,374 2% 880,374 2% % Change % Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 30 CHANGES IN FINANCIAL POSITION OPEN SPACE PROTECTION FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenue 4,101 - - - Subventions and Grants 2,600,000 -100% Service Charges 47,369 6,900 -100% Other Revenues - - - Total Revenues 51,470 2,606,900 - -100% - Expenditures Capital Improvement Plan Projects 32,743 2,970,881 -100% Total Expenditures 32,743 2,970,881 - -100% - Other Sources (Uses) Operating Transfer In - - - Operating Transfer Out - - - Total Other Sources (Uses) - - - - Revenues and Other Sources Over (Under) Expenditures and Other Uses 18,726 (363,981) - -100% - - Fund Balance, Beginning of Year 530,623 549,349 185,368 -66% 185,368 - Fund Balance, End of Year 549,349 185,368 185,368 185,368 % Change 2017-19 Financial Plan % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 31 CHANGES IN FINANCIAL POSITION AIRPORT AREA IMPACT FEE FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenue 8,248 1,000 5,000 400% 5,000 Service Charges 134,210 - - - Total Revenues 142,458 1,000 5,000 400% 5,000 Expenditures Capital Improvement Plan Projects - 56,669 55,000 -3% 750,000 1264% Total Expenditures - 56,669 55,000 -3%750,000 1264% Other Sources (Uses) Operating Transfer Out - - - - Revenues and Other Sources Over (Under) Expenditures and Other Uses 142,458 (55,669) (50,000) -10% (745,000) 1390% Fund Balance, Beginning of Year 937,498 1,079,956 1,024,287 -5% 974,287 -5% Fund Balance, End of Year 1,079,956 1,024,287 974,287 -5% 229,287 -76% % Change % Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 32 CHANGES IN FINANCIAL POSITION AFFORDABLE HOUSING FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenue 34,415 8,000 14,000 75% 14,000 Subventions and Grants - - - Service Charges 625,506 - - - Total Revenues 659,921 8,000 14,000 75%14,000 Expenditures Capital Improvement Plan Projects 636,978 1,524,227 - -100% - Total Expenditures 636,978 1,524,227 - -100%- Transfer Out (62,000) (17,000) - -100% - Revenues and Other Sources Over (Under) Expenditures and Other Uses (39,057) (1,533,227) 14,000 -101% 14,000 Fund Balance, Beginning of Year 2,601,882 2,562,825 1,029,598 -60% 1,043,598 1% Fund Balance, End of Year 2,562,825 1,029,598 1,043,598 1% 1,057,598 1% 2017-19 Financial Plan % Change % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 33 CHANGES IN FINANCIAL POSITION LOS OSOS VALLEY ROAD SUB-AREA FEE FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenue 2,586 1,700 1,700 1,700 Service Charges 14,661 - - Total Revenues 17,246 1,700 1,700 1,700 Expenditures Capital Improvement Plan Projects - - - Total Expenditures - - - - Other Sources (Uses) Operating Transfer In - - - - Operating Transfer Out - - - - Revenues and Other Sources Over (Under) Expenditures and Other Uses 17,246 1,700 1,700 1,700 Fund Balance, Beginning of Year 146,723 163,969 165,669 1% 167,369 1% Fund Balance, End of Year 163,969 165,669 167,369 1% 169,069 1% 2017-19 Financial Plan % Change% Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 34 CHANGES IN FINANCIAL POSITION INFORMATION TECHNOLOGY REPLACEMENT Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenue 2,765 1,500 5,000 233% 5,000 Subventions and Grants 73,861 - 60,000 - -100% Service Charges Total Revenues 76,626 1,500 65,000 4233%5,000 -92% Expenditures Capital Improvement Plan Projects 481,374 2,803,400 304,000 -89% 1,294,294 326% Total Expenditures 481,374 2,803,400 304,000 -89% 1,294,294 326% Other Sources (Uses) Operating Transfer In 617,000 2,621,000 689,745 -74% 1,350,967 96% Operating Transfer Out (536,500) (182,023) -66% Debt Proceeds 688,500 - - - Total Sources (Uses) 1,305,500 2,621,000 153,245 -94% 1,168,944 663% Revenues and Other Sources Over (Under) Expenditures and Other Uses 900,753 (180,900) (85,755) -53% (120,350) 40% Fund Balance, Beginning of Year (159,846) 740,907 560,007 -24% 474,252 -15% Fund Balance, End of Year 740,907 560,007 474,252 -15% 353,902 -25% % Change 2017-19 Financial Plan % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 35 CHANGES IN FINANCIAL POSITION MAJOR FACILITY REPLACEMENT Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenue 606 500 1,300 160% 1,300 Service Charges Donation 22,000 - - - Total Revenues 22,606 500 1,300 160%1,300 Expenditures Capital Improvement Plan Projects 405,530 749,710 52,200 -93% 144,290 176% Total Expenditures 405,530 749,710 52,200 -93% 144,290 176% Other Sources (Uses) Operating Transfer In 163,250 504,600 682,200 35% 593,200 -13% Operating Transfer Out - - (483,900) (507,700) 5% 163,250 504,600 198,300 -61% 85,500 -57% Revenues and Other Sources Over (Under) Expenditures and Other Uses (219,674) (244,610) 147,400 -160% (57,490) -139% Fund Balance, Beginning of Year 488,636 268,962 24,352 -91% 171,752 605% Fund Balance, End of Year 268,962 24,352 171,752 605% 114,262 -33% % Change 2017-19 Financial Plan % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 36 CHANGES IN FINANCIAL POSITION INFRASTRUCTURE INVESTMENT FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenue 1,660 1,000 900 -10% 900 Service Charges - - - Total Revenues 1,660 1,000 900 -10%900 Expenditures Operating Programs Capital Improvement Projects - 250,000 - -100% - Total Expenditures - 250,000 - -100% - Other Sources (Uses) Operating Transfer In 250,000 1,000 - -100% - Debt Proceeds - Total Sources (Uses) 250,000 1,000 - -100% - Revenues and Other Sources Over (Under) Expenditures and Other Uses 251,660 (248,000) 900 -100% 900 Fund Balance, Beginning of Year 60,105 311,765 63,765 -80% 64,665 1% Fund Balance, End of Year 311,765 63,765 64,665 1% 65,565 1% % Change% Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 37 CHANGES IN FINANCIAL POSITION DEBT SERVICE FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment Property Revenue 54,725 Total Revenues 54,725 Expenditures Debt Service Cost of debt issuance - - 2012/2001 Refunded Revenue Bonds 388,725 385,350 385,075 0% 387,875 1% 2004/1994 Refunding Revenue Bonds - - - - 2005/1996 Refunding Revenue Bonds 467,851 466,789 469,589 1% 466,789 -1% 2006 Lease Revenue Bonds 460,374 459,914 458,940 0% 459,832 0% 2009 Lease Revenue Bonds 829,998 826,610 826,779 0% 820,501 -1% Fire Engine/Truck Lease Purchase 127,492 129,203 125,764 -3% 127,326 1% Capital Lease / Fire Truck 2014 116,702 116,702 116,702 116,702 Capital Lease (I.T. Equipment)195,190 199,049 199,235 0% 199,236 0% 2014 Lease Revenue Bond/ LOVR 515,050 422,181 422,606 0% 422,881 0% Insurance Retrospective Charges - PERS Side Fund Payment - Fleet Debt Service 240,068 370,068 54% 505,068 36% Total Expenditures 3,101,381 3,245,866 3,374,758 4% 3,506,210 4% .. Other Sources (Uses) Operating Transfers In 3,025,400 3,245,866 3,374,757 4% 3,506,208 4% Operating Transfers Out - - - Proceeds from Debt Financing - - - Total Other Sources (Uses) 3,025,400 3,245,866 3,374,757 4% 3,506,208 4% Revenues and Other Sources Over (Under) Expenditures and Other Uses (21,256) - (1) (2) 100% Fund Balance, Beginning of Year 2,140,980 2,119,724 2,119,724 2,119,723 0% Fund Balance, End of Year Reserved for Debt Service 2,119,724 2,119,724 2,119,723 0% 2,119,721 0% Total Fund Balance 2,119,724 2,119,724 2,119,723 0% 2,119,721 0% % Change% Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 38 CHANGES IN FINANCIAL POSITION WATER FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Service Charges Water Sales Water Service Charges 17,084,904 17,216,708 17,623,312 2% 18,167,251 3% Sales to Other Agencies 862,813 850,000 866,250 2% 892,238 3% Development Impact Fees 1,542,268 800,000 800,000 800,000 Connection Charges and Meter Sales 60,421 71,000 61,000 -14% 61,000 Late Charges and Credit Card Fees 39,584 65,000 23,000 -65% 23,000 Account Set-up Fee 107,159 100,000 156,000 56% 156,000 AB 939 Reimbursement 141,957 135,000 145,000 7% 147,900 2% Total Service Charges 19,839,106 19,237,708 19,674,562 2% 20,247,389 3% Other Revenues 46,439 50,000 283,000 466% 283,000 Subventions and Grants - - - - Investment and Property Revenues 544,808 50,000 50,000 50,000 Total Revenues 20,430,353 19,337,708 20,007,562 3% 20,580,389 3% Expenditures Operating Programs - - 515,893 531,547 - - 2,791,977 2,761,401 Infrastructure & Transportation 12,909,891 16,438,538 11,217,372 -32% 11,415,616 2% Fiscal Health & Governance 1,328,061 1,477,598 2,191,201 48% 2,230,068 2% CalPERS Discount Rate - - - 24,414 Total Operating Programs 14,237,952 17,916,136 16,716,443 -7% 16,963,046 1% Capital Improvement Plan Projects 2,366,716 7,514,756 3,277,500 -56% 9,362,100 186% Debt Service 2,169,951 2,193,792 2,194,005 0% 2,955,652 35% Total Expenditures 18,774,619 27,624,684 22,187,948 -20% 29,280,798 32% Other Sources (Uses) Other Sources (Uses) Proceeds from Debt Financing - - 8,500,000 Projected MOA Adjustments - - - Operating Transfer In - - - Operating Transfers Out (469,607) (561,244) (967,599) 72% (1,027,176) 6% Expenditure Savings - - - Other Sources (Uses)- - - Total Other Sources (Uses)(469,607) (561,244) (967,599) 72% 7,472,824 -872% Revenues and Other Sources Over (Under) Expenditures and Other Uses 1,186,127 (8,848,220) (3,147,985) -64% (1,227,585) -61% Working Capital, Beginning of Year 21,876,499 22,929,660 14,081,440 -39% 10,933,455 -22% Adjustment for Long Term Accruals (132,966) - - - Working Capital, End of Year 22,929,660 14,081,440 10,933,455 -22% 9,705,869 -11% Environmental Health & Open Space Community & Neighborhood Livability % Change% Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 39 CHANGES IN FINANCIAL POSITION SEWER FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Service Charges Customer Sales Sewer Service Charges 14,526,664 14,300,000 14,301,464 0% 14,741,100 3% Sales to Cal Poly 888,437 875,000 875,000 901,250 3% Development Impact Fees 502,393 300,000 300,000 300,000 Account Set-Up Fees 107,131 100,000 156,000 56% 156,000 Late Charges and credit card fees 40,066 65,000 23,000 -65% 23,000 Industrial User Charges 79,822 70,000 85,000 21% 85,000 Connection Charges and Meter Sales 60,241 71,000 61,000 -14% 61,000 Total Service Charges 16,204,754 15,781,000 15,801,464 0% 16,267,350 3% Other Revenues 50,718 37,500 34,000 -9% 44,071 30% Investment and Property Revenues 388,540 50,000 50,000 50,000 Total Revenues 16,644,012 15,868,500 15,885,464 0% 16,361,421 3% Expenditures Operating Programs - - - - - - 4,858,140 4,973,738 Infrastructure & Transportation 6,018,807 7,098,843 1,126,926 -84% 1,142,593 1% Fiscal Health & Governance 1,576,026 1,591,041 3,027,860 90% 3,101,507 2% CalPERS Discount Rate - - - 24,713 Total Operating Programs 7,594,833 8,689,884 9,012,926 4% 9,242,551 3% Capital Improvement Plan Projects 5,178,481 19,677,576 22,042,500 12% 58,162,000 164% Debt Service 1,437,543 1,435,587 1,433,709 0% 1,431,006 0% Total Expenditures 14,210,857 29,803,047 32,489,135 9% 68,835,557 112% Other Sources (Uses) Cashflow adjustment for working capital - - - Proceeds from Debt Financing - - 19,500,000 56,500,000 190% Projected MOA Adjustments - - - - Operating Transfer In 173,096 - - - Operating Transfers Out (493,073) (490,319) (817,715) 67% (901,818) 10% Other Sources (Uses)- - - Total Other Sources (Uses)(319,977) (490,319) 18,682,285 -3910%55,598,182 198% Revenues and Other Sources Over (Under) Expenditures and Other Uses 2,113,177 (14,424,866) 2,078,614 -114% 3,124,046 50% Working Capital, Beginning of Year 27,071,809 29,096,197 14,671,331 -50% 16,749,946 14% Adjustment for Long Term Accruals (88,789) - - - Working Capital, End of Year 29,096,197 14,671,331 16,749,946 14% 19,873,992 19% Community & Neighborhood Livability Environmental Health & Open Space % Change% Change 2017-19 Financial Plan Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 40 CHANGES IN FINANCIAL POSITION WHALE ROCK COMMISSION Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenues 19,273 1,000 1,000 1,000 Service Charges Member Agency Contributions O & M 724,058 735,828 808,845 10% 845,179 4% Member Agency Contributions CIP 411,877 404,377 502,105 24% 332,512 -34% Water Distribution Charges 277,791 370,000 337,500 -9% 351,000 4% Other Service Charges - - - Total Service Charges & Interest 1,432,999 1,511,205 1,649,450 9% 1,529,691 -7% Other Revenues 5,508 1,500 6,000 300% 6,000 Total Revenues 1,438,507 1,512,705 1,655,450 9%1,535,691 -7% Expenditures Operating Programs Infrastructure & Transportation 838,529 1,006,373 1,026,637 2% 1,070,745 4% Fiscal Health & Governance 115,989 125,510 141,937 13% 141,937 Total Operating Programs 954,518 1,131,883 1,168,574 3% 1,212,682 4% Capital Improvement Plan Projects 49,525 606,419 520,000 -14% 36,000 -93% Total Expenditures 1,004,043 1,738,302 1,688,574 -3% 1,248,682 -26% Other Sources (Uses) Operating Transfers Out - - (2,210) (15,963) 622% Other Sources (Uses) - - - - Adjust for working capital - - - - Total Other Sources (Uses) - - (2,210) (15,963) 622% Revenues and Other Sources Over (Under) Expenditures and Other Uses 434,464 (225,597) (35,334) -84% 271,046 -867% Working Capital, Beginning of Year 1,122,068 1,556,532 1,330,935 -14% 1,295,601 -3% Working Capital, End of Year 1,556,532 1,330,935 1,295,601 -3% 1,566,647 21% % Change 2017-19 Financial Plan % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 41 CHANGES IN FINANCIAL POSITION PARKING FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Service Charges Parking Meter Collections Lots 304,345 166,200 140,400 -16% 141,900 1% Streets 1,526,182 1,539,100 1,648,100 7% 1,664,700 1% Parking Structure Collections 1,162,982 1,054,700 1,489,500 41% 1,504,400 1% Long-Term Parking Revenues 642,483 434,900 795,000 83% 802,900 1% Lease Revenues 403,630 500,500 502,900 0% 509,800 1% Parking In-Lieu Fees 2,641,296 20,200 20,400 1% 20,600 1% Other Service Charges (15,096) 100 (89,100) -89200% (90,000) 1% Total Service Charges 6,665,822 3,715,700 4,507,200 21% 4,554,300 1% Investment and Property Revenues 333,687 48,200 48,000 0% 52,000 8% Fines and Forfeitures 579,823 669,900 587,300 -12% 593,200 1% Other Revenues 827 - 100 100 Total Revenues 7,580,159 4,433,800 5,142,600 16% 5,199,600 1% Expenditures Operating Programs Infrastructure & Transportation 1,835,753 2,385,106 2,215,088 -7% 2,274,025 3% Fiscal Health & Governance 711,587 684,603 622,189 -9% 622,189 CalPERS Discount Rate - - - 6,200 Total Operating Programs 2,547,340 3,069,709 2,837,277 -8% 2,902,414 2% Capital Improvement Plan Projects 20,547 2,231,404 825,000 -63% 650,000 -21% Debt Service 959,201 969,400 967,400 0% 967,500 0% Total Expenditures 3,527,088 6,270,513 4,629,677 -26% 4,519,914 -2% Other Sources (Uses) Cashflow adjustment for working capital - - - Expenditure Savings - - - Operating Transfer In - - - - Operating Transfer Out (473,368) - (157,644) (169,865) 8% PERS 1% Contribution - - - - Proceeds from Debt Financing - - - - Other Sources (Uses)- - - - GST Loan per Council Approval - (500,000) - -100% - Potential MOA Adjustments - (11,198) - -100% - Total Other Sources (Uses) (473,368) (511,198) (157,644) -69%(169,865) 8% Revenues and Other Sources Over (Under) Expenditures and Other Uses 3,579,703 (2,347,911) 355,279 -115% 509,821 43% Working Capital, Beginning of Year 8,391,033 12,305,964 9,958,053 -19% 10,313,332 4% Adjustment for Long Term Accruals 335,228 - - - Working Capital, End of Year 12,305,964 9,958,053 10,313,332 4% 10,823,153 5% % Change 2017-19 Financial Plan % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 42 CHANGES IN FINANCIAL POSITION TRANSIT FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenues 11,202 5,800 5,800 5,800 From Other Governments TDA Revenues (LTF)1,312,716 1,286,625 1,166,759 -9% 1,166,759 TDA Revenues (STA)162,418 159,890 154,027 -4% 152,748 -1% Other Grants 39,738 1,300,200 174,600 -87% 1,060,000 507% FTA Grants 1,373,948 1,424,555 1,426,251 0% 1,426,251 Service Charges 3,809 690,381 709,357 3% 711,181 0% Other Revenues 655,660 4,600 6,600 43% 6,600 Total Revenues 3,559,492 4,872,051 3,643,394 -25% 4,529,339 24% Expenditures Operating Programs Infrastructure & Transportation 2,920,657 3,448,368 3,423,351 -1% 3,518,007 3% Fiscal Health & Governance 277,329 288,995 319,987 11% 319,987 CalPERS Discount Rate - - - 1,884 Total Operating Programs 3,197,986 3,737,363 3,743,338 0% 3,839,878 3% Capital Improvement Plan Projects - 2,003,324 335,000 -83% 1,085,000 224% Total Expenditures 3,197,986 5,740,687 4,078,338 -29% 4,924,878 21% Other Sources (Uses) Cashflow adjustment for working capital - - - - Projected MOA Adjustments - (4,200) -100% Operating Transfer In - - - - Operating Transfer Out - - (61,398) (114,651) 87% Other Sources - - Expenditure Savings - - - - Total Other Sources (Uses)- (4,200) (61,398) 1362% (114,651) 87% Revenues and Other Sources Over (Under) Expenditures and Other Uses 361,506 (872,836) (496,342) -43% (510,190) 3% Working Capital, Beginning of Year 2,775,920 2,988,512 2,115,676 -29% 1,619,334 -23% Adjustment for Long Term Accruals (148,914) Prior Year Restatement Working Capital, End of Year 2,988,512 2,115,676 1,619,334 -23% 1,109,144 -32% % Change 2017-19 Financial Plan % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 43 CHANGES IN FINANCIAL POSITION BOYSEN RANCH CONSERVATION FUND Actual Mid-Year Proposed Proposed 2015-16 2016-17 2017-18 2018-19 Revenues Investment and Property Revenue 2,981 1,800 2,000 11% 2,000 Service Charges - - - Total Revenues 2,981 1,800 2,000 11%2,000 Expenditures Culture & Recreation 7,500 7,500 7,500 Total Expenditures - 7,500 7,500 7,500 Other Sources (Uses) Operating Transfer In - Debt Proceeds - Total Sources (Uses) - - - - Revenues and Other Sources Over (Under) Expenditures and Other Uses 2,981 (5,700) (5,500) -4% (5,500) Fund Balance, Beginning of Year 86,925 89,906 84,206 -6% 78,706 -7% Fund Balance, End of Year 89,906 84,206 78,706 -7% 73,206 -7% % Change 2017-19 Financial Plan % Change Resolution No. 10815 (2017 Series) EXHIBIT 1 Page 44